Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere
...3 Pervasive.SQL 2000...4 Pervasive.SQL 2000...5 Pervasive.SQL 2000...7...7...10...11...12 Pervasive.SQL 2000 Workstation...14...14 Pervasive.SQL 2000 Workstation...15 Pervasive.SQL 2000 Workgroup...15...15 Pervasive.SQL 2000 Workgroup...17 Pervasive.SQL 2000 Server...18 NetWare...18 Windows NT Server...19 Pervasive.SQL 2000 Server...19...20...20...20 Pervasive.SQL 2000...21 1...23 1...24 / 1...25 2...26 2...27 / 2...28 Pervasive.SQL 2000 2...29
Pervasive.SQL 2000 / Btrieve Scalable SQL Pervasive.SQL 7 Pervasive.SQL 2000 Pervasive.SQL 2000 / Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 SDK (Software Development Kit ) SDK 2000 2 White Paper http://www.pervasive.co.jp : tyoinfo@pervasive.co.jp : tyosupport@pervasive.co.jp : (03)5405-2261
Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 ODBC Pervasive.SQL 2000 ODBC SQL Pervasive.SQL 2000 SQL NULL LEFT OUTER TABLE JOIN RIGHT OUTER TABLE JOIN Pervasive.SQL 2000 Pervasive.SQL 2000 for Workgroups DTI (Distributed Tuning Interface) DTI Pervasive.SQL 2000 API DTI Pervasive.SQL 2000 Scalable SQL API / ALTER / INSERT DELETE / Pervasive.SQL 2000 GRANT/REVOKE / Pervasive.SQL 2000 Pervasive.SQL 2000 PCC (Pervasive
(Pervasive Control Center) Pervasive.SQL 2000 1 Pervasive.SQL 2000 32 SQL Scope SQL Data Manager SQL Data Manager Oracle Pervasive.SQL 2000 Pervasive.SQL Oracle API Pervasive.SQL 2000 Oracle 8i TCO (Total Cost of Ownership) Pervasive.SQL 2000 Pervasive.SQL 2000 TCO Pervasive.SQL 2000 Pervasive.SQL v7 Btrieve Pervasive.SQL 2000 (SMB = Small to Medium Business) /TCO ( ) Btrieve Scalable SQL / LAN/WAN / (Oracle Informix DB2 )
DBA ( ) TCO SMB Pervasive.SQL Pervasive.SQL 2000 Pervasive.SQL 2000 Best of Both Worlds (Btrieve) 1 Pervasive.SQL 2000 Btrieve / Pervasive.SQL 2000 SQL Pervasive.SQL 2000 Pervasive.SQL 2000 TCO
Pervasive.SQL 2000 2 1 Pervasive.SQL 2000 2 1 Pervasive.SQL 2000 24 Continuous Pervasive.SQL 2000 Pervasive.SQL 2000 for Smart Cards* Pervasive.SQL 2000 for Embedded Devices* Pervasive.SQL 2000 for Mobile Devices* Pervasive.SQL 2000 Workstation Pervasive.SQL 2000 Workgroup Pervasive.SQL 2000 Server ( * ) Pervasive.SQL 2000 Pervasive.SQL 2000 16 32 DOS
/ Pervasive.SQL 2000 Pervasive.SQL 2000 Server Novell NetWare Windows NT Pervasive.SQL 2000 Btrieve ODBC JDBC PDAC Pervasive.SQL 2000 DTI (Distributed Tuning Interface) Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive Control Center Data Manager Monitor Function Executor
Workstation Server Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL Pervasive.SQL 2000 Pervasive.SQL 2000 TCO ( ) TCO ( ) TCO Pervasive.SQL 2000 Pervasive.SQL 2000 TCO Aberdeen Group Pervasive.SQL 2000 TCO Web http://www.pervasive.com/support/technical/white/ Pervasive.SQL 2000 Btrieve / ( 7.x / 64 GB)
Pervasive.SQL 2000 Pervasive.SQL 2000 Visual Studio Deplhi C++ Builder Pervasive.SQL 2000 ODBC ODBC Pervasive.SQL 24 X 7 Query Cost Optimizer.. Pervasive.SQL 2000 1982 Softcraft Btrieve 1.0 15 Pervasive.SQL 2000 17 Btrieve 1 Pervasive.SQL 2000 Pervasive.SQL 2000 Microkernel Microkernel Pervasive.SQL 2000 Microkernel Pervasive.SQL 2000 JDBC ADO/OLE DB Microkernel
1 - Pervasive.SQL 2000 2 Pervasive.SQL 2000 Pervasive.SQL 2000 DTI Pervasive.SQL 2000 DTI (Distributed Tuning Interface ) Microkernel Pervasive.SQL 2000 API DTI Java Pervasive.SQL 2000 Java Btrieve Java PDAC PDAC (Pervasive Direct Access Components ) Borland Delphi Imprise C++ Builder BDE (Borland Database Engine ) PDAC BDE TTTable Tquery JDBC Java Pervasive.SQL 2000 100% pure Java JDBC Level 1 Type III /
ODBC Pervasive.SQL 2000 ODBC 2.5 ODBC ( Access) SQL 92 / ODBC Pervasive.SQL 2000 Workstation Workgroup Server OLE DB OLE DB ADO Visual Studio 6 Microsoft Pervasive.SQL 2000 Irowset OLE DB Pervasive.SQL OLE DB ActiveX Visual Basic Pervasive ActiveX Pervasive.SQL 2000 Btrieve Btrieve Pervasive.SQL 2000 Btrieve Btrieve Pervasive.SQL 2000 Windows DLL Windows DLL TCO Pervasive.SQL 2000 DLL DLL Windows 16 32 2 Pervasive.SQL 2000 DLL
W3BTRV7.DLL W3BTRV7.DLL W3BIFxxx.DLL ( W3BIF104.DLL) DLL 6 8 W3BIF104.DLL 1.04 Windows DLL DLL / / DLL DLL W3BIF105.DLL DLL DLL DLL DLL W3BTRV7.DLL W3BTRV7.DLL DLL W3BIF104.DLL W3BIF105.DLL W3BIF105.DLL Pervasive.SQL 2000 Pervasive.SQL 2000 Btrieve (WBTRV32.DLL) DLL DLL DLL DLL 1 BTRV32.DLL DLL 2 Application Pervasive.SQL Pervasive.SQL Application Client WBTRV7.DLL W3BIF104.DLL W3MIF104.DLL W3NSL104.DLL
Pervasive.SQL 2000 Workstation Pervasive.SQL 2000 Workstation 32 Pervasive.SQL 2000 Workstation DOS Windows 16 32 Btrieve API Pervasive.SQL 2000 / 9 Pervasive.SQL 2000 Workstation Application DBMS
Pervasive.SQL 2000 Workstation Windows 95/98 Windows NT 4.0(SP 3 ) Intel Pentium 16 MB RAM/ 35 MB HDD ODBC 2.5 (ANSI SQL 89/ 92) OLE DB Btrieve ActiveX Borland Database Engine (BDE) Pervasive.SQL 2000 Direct Access Components for Delphi (BDE ) / 64 GB / / 20 64,000 ( ) : 2 GB : Pervasive.SQL 2000 Workgroup Pervasive.SQL 2000 Workgroup / / Pervasive.SQL 2000 Workgroup (5.x 6.15 MEFS ( ) ) Pervasive.SQL 2000 / 1 Pervasive.SQL 2000 Workgroup Pervasive.SQL
2000 Workgroup Pervasive.SQL 2000 Workgroup Workgroup Pervasive.SQL 2000 Workgroup [ ] Windows Workgroup Pervasive.SQL 2000 Workgroup ( ) 10 - Workgroup Application Application DBMS Application Pervasive.SQL 2000 Workgroup
11 - Workgroup Application Application DBMS Application File Server Workgroup 3 1 Workgroup / Workgroup 3 3 2 ( 2 / ) Pervasive.SQL 2000 Workgroup Windows 95/98 Windows NT 4.0(SP 3 ) Intel Pentium 16 MB RAM/ 35 MB HDD ODBC 2.5 (ANSI SQL 89/ 92) OLE DB Btrieve ActiveX Borland Database Engine (BDE) Pervasive.SQL 2000 Direct Access Components for Delphi (BDE ) / 64 GB / / 20 64,000 ( ) : 2 GB :
Pervasive.SQL 2000 Server Pervasive.SQL 2000 Server / Pervasive.SQL 2000 Server 24 X 7 Pervasive.SQL 2000 Novell NetWare Windows NT Sun Solaris Linux Web 2 1 Pervasive.SQL 2000 Pervasive.SQL 2000 Server Pervasive.SQL 2000 Server IPX/SPX TCP/IP NetWare Pervasive.SQL 2000 Server for NetWare NetWare NetWare 2.15 NetWare Btrieve Pervasive.SQL 7 Pervasive.SQL Novell NetWare 5 Pervasive.SQL 2000 NetWare Pervasive.SQL 2000 NetWare Pervasive.SQL 2000 NetWare NetWare NetWare Pervasive.SQL 2000 Server for NetWare IPX/SPX TCP/IP 2
Windows NT Server Pervasive.SQL 2000 Server for Windows NT Server Microsoft BackOffice NT Server Btrieve SQL/ODBC Pervasive.SQL 2000 for NT Server IPX/SPX TCP/IP Pervasive.SQL 2000 for NT Server PCC (Pervasive Control Center ) Pervasive.SQL 2000 32 12 - / (LAN) Internet DBMS Pervasive.SQL 2000 Server Windows NT Server 4.0(SP3 ) NetWare 3.12, 4.11, 5.0 Windows NT, NetWare: Intel Pentium 32 MB RAM/ 35 MB HDD Windows NT 4.0 (SP 3 ) Windows 95/98 (DOS, Win16, Win 32 ) Windows 3.11 DOS 5.0 Windows NT 4.0 (SP 3 ), Windows 95/98 : 23 MB HDD/ 6 MB RAM Windows 3.11 : 23 MB HDD/ 6 MB RAM DOS : 1 MB HDD / 640K RAM IPX/SPX : NetWare, Windows NT TCP/IP : NetWare, Windows NT
ODBC 2.5 (ANSI SQL 89/ 92) OLE DB Btrieve ActiveX Borland Database Engine (BDE) Pervasive.SQL 2000 Direct Access Components for Delphi (BDE ) / 64 GB / / 20 64,000 ( ) : 2 GB : Btrieve Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 I/O TCPA TCPB TCPC /
1999 11 Web Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 ODBC ODBC Pervasive.SQL 2000 Btrieve Pervasive.SQL 2000 Pervasive.SQL 2000 Pervasive.SQL 2000 3 / ODBC Pervasive.SQL 2000 Pervasive.SQL 7
Pervasive.SQL 2000 I/O TCPB 0 ( ) 0 1 4 10 ( ) 1 Pentium II 233 Mhz 64 MB Fast SCSI X 2 Windows NT Server 4.0 SP3 Pervasive.SQL 7 SP4 (for Pervasive.SQL v7 numbers) Pervasive.SQL 2000 32 MB (Pervasive.SQL ) 2 Pentium II 450 Mhz 256 MB Fast-Wide SCSI X 2 Windows NT Server 4.0 SP3 Pervasive.SQL 7 SP4 (for Pervasive.SQL v7 numbers) Pervasive.SQL 2000 128 MB (Pervasive.SQL )
1 14 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / 15 - Pervasive.SQL 2000 vs. Pervasive.SQL 7
1 16 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / 17 - Pervasive.SQL 2000 vs. Pervasive.SQL 7
/ 1 18 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / / 19 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 /
2 20 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / 21 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 -
2 22 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / 23 - Pervasive.SQL 2000 vs. Pervasive.SQL 7
/ 2 24 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 / / 25 - Pervasive.SQL 2000 vs. Pervasive.SQL 7 /
Pervasive.SQL 2000 2 26 - Pervasive.SQL 2000 ( / )