Pervasive.SQL 2000 White Paper Btrieve TM 6.15 Pervasive.SQL TM 7 Pervasive.SQL TM 2000 White Paper Rev.1 11/1999 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere
...3...3...3...4...5...5...5 Windows NT...6 Novell NetWare...6...6...6...7...8 Pervasive.SQL 2000 Workstation / Workgroup...8 Pervasive.SQL 2000 Server...8...10...11...11 ( )...12...13...14 [Sort Buffer Size]...14...15?...16...17 B-Tree ( )...18
White Paper Btrieve 6.15 Pervasive.SQL 7 Pervasive.SQL 2000 3 ( ) Pervasive.SQL Btrieve Pervasive.SQL 7 Pervasive.SQL 2000 White Paper ( Pervasive.SQL 7 Pervasive.SQL 2000) Pervasive.SQL 7 Pervasive.SQL 2000 32-bit Windows DOS 16-bit Windows Windows 95/98 Windows NT 4.0 (SP3) Pervasive.SQL 7 Pervasive.SQL 2000 Windows 1 Windows 32 bit Pervasive.SQL Pervasive.SQL Windows 16 bit 32-bit
DOS Btrieve Pervasive.SQL DOS Pervasive.SQL 2000 Workgroup Pervasive.SQL 2000 Pervasive.SQL Btrieve 6.15 MEFS ( ) MEFS Pervasive.SQL 2000 Workgroup / Pervasive.SQL 2000 Pervasive.SQL 2000 Workgroup Pervasive.SQL 2000 Workgroup [Startup] Pervasive.SQL 2000 Workgroup Pervasive.SQL 2000 Workgroup 3 3 3 ( 3 3
) Getting Started Guide Windows 32-bit/16-bit Pervasive.SQL 2000 DOS DOS Btrieve Btrieve 1 Pervasive.SQL Server InstallScout Server CD-ROM ( Getting Started (Server edition). ) Btrieve 6.15 Pervasive.SQL Btrieve 6.15 Pervasive.SQL 7 20 10 30
Windows NT Pervasive.SQL Windows NT CD-ROM Windows NT Server 4.0 Pervasive.SQL Windows NT Service Pack 3 Novell NetWare Pervasive.SQL NetWare NetWare Windows Btrieve for NetWare BTRIEVE.NLM BSTART.NCF Smart Components TM MicroKernel Btrieve BSTART.NCF Pervasive.SQL Btrieve Server Bsetup BTRMon NLM Pervasive.SQL NLM ( Butil.NLM) Pervasive.SQL Windows Server BTI.CFG SYS:SYSTEM BSTART.NCF SYS:SYSTEM PVSW7.BCK Pervasive.SQL (
DLL) Pervasive.SQL SDK Pervasive.SQL Programmer s Guide Pervasive.SQL Smart Components TM 1 DLL Pervasive.SQL DLL Wbtrcall.dll Wbtrv32.dll Wxqlcall.dll Wssql32.dll Wdbnm32.dll Wbnames.dll DLL ( x.dlx ) DLL DLL Pervasive.SQL Btrieve/Scalable SQL DLL Pervasive.SQL Server [ ] [ ] CD-ROM CD-ROM Getting Started with Pervasive.SQL (Server edition) Pervasive.SQL Windows (.hlp) Web Adobe Acrobat (PDF)
1 CD-ROM [clients] [clients] Win16 Win32 OS/2 DOS DOS Workstation / Workgroup Pervasive.SQL Workstation Workgroup Windows 16-bit 32-bit ( Btrieve 6.15 ) DLL Wbtrcall.dll Wbtrv32.dll Wxqlcall.dll Wssql32.dll Wdbnm32.dll Wbnames.dll ( drive: PVSW) DLL ( x.dlx ) DLL DLL Pervasive.SQL DLL Server NetWare 4.1x Pervasive.SQL 2000 ( ) (Unlimited) (Unlimited)
NetWare BTRIEVE.NLM BSPXCOM.NLM Novell / Btrieve 6.15.451 Pervasive.SQL 7 NetWare BSTART Btrieve 7.x Btrieve 6.15 NetWare 6.15.451 NLM Pervasive.SQL 7 NLM SYS:SYSTEM B*.NLM B*.NCF Pervasive.SQL Pervasive.SQL for NetWare Pervasive.SQL BSPXCOM.NLM NLM NSGetConfigInfo NsisValidRequestClass Undefined Public Symbol NLM NetWare TCP/IP Pervasive.SQL SPX TCP/IP SYS: SYSTEM BTI.CFG BTI.CFG NetWare SPX Pervasive.SQL Scalable SQL Communications Manager Btrieve Communications Manager [Supported Protocols] SPX Pervasive.SQL TCP/IP Pervasive.SQL NetWare TCP/IP Btrieve Communications Manager BTI.CFG [Supported Protocols]
NWBSRVCM IPX/SPX BSPXCOM / Btrieve TCP/IP Pervasive.SQL NetWare TCP/IP BTRIEVE.NLM NetWare NLM MicroKernel (NWMKDE.NLM) NWMKDE NetWare Btrieve.NLM Pervasive.SQL 7 Service Pack 4 Pervasive.SQL 2000 BSTOP BTRV UNLINK NWMKDE NWMKDE Btrieve.NLM NWMKDE OS BTRIEVE.NLM NWMKDE BSTART Btrieve.NLM OS NLM NWMKDE Btrieve.NLM Btrieve Pervasive.SQL Pervasive.SQL 5.x 6.x 7 Pervasive.SQL 6.x Pervasive.SQL ( ) ISR (International Sort Rule) 7 Pervasive.SQL 64 GB
NetWare Pervasive.SQL Service Pack Licensing information is out of sync, 03 5405-2265 tyosupport@pervasive.co.jp Pervasive.SQL Pervasive.SQL 03 5405-2265 tyopsg@pervasive.co.jp http://ww.pervasive.co.jp/
A ( ) ( ) 7 (Rebuild) Pervasive.SQL User's Guide MicroKernel GUI 1 : Pervasive.SQL 7 Service Pack 1 DDF (Windows NT Server ) GUI 3 GB 4 GB NetWare BREBUILD.NLM User's Guide Pervasive.SQL 7 Service Pack 2 NetWare (2 GB ) 20 30 Service Pack 2 CPU Continue on Error *.* Continue on
on Error 7 7 6.x User's Guide [ ] [ ] Btrieve MicroKernel MicroKernel RAM 2 Btrieve 1. 2. 3. 4. 5. MicroKernel Extended Step 6. MicroKernel 7. MicroKernel 5 6 8. ( Blocks Required ) MicroKernel Btrieve
9. 5 8 ( 5 7) MicroKernel 1 MicroKernel 1. 2. 3. 4. 1 5. MicroKernel Step Next 1 6. MicroKernel 7. MicroKernel 5 6 8. 5 7 2 ( ) NetWare ( ) [Sort Buffer Size] [MKDE] [Memory Resources] [Sort Buffer Size] MicroKernel
[Sort Buffer Size] ( ) [Sort Buffer Size] [Sort Buffer Size] MicroKernel MicroKernel 60% 60% MicroKernel MicroKernel 20 512 Btrieve 8 18 ( ) 800 7 B-Tree (7 ) 4096 Btrieve 72 145 B-Tree 4 / B-Tree 4096 Btrieve
Pervasive.SQL SDK Pervasive.SQL Programmer's Guide = ( 12 ) / ( + )? / RAM 1 RAM = = 8 ( (Linked Duplicate) 12) = = ((( + )* ) + 65536 ) / 0.6 = / 30 800 20 ( ) ((( 20 + 8 ) * 8,000,000 ) + 65536 ) / 0.6 = 373,442,560 373.5 MB 1/30 12,448,086 12.45MB 30 30 1 0.6 60% 373,442,560 (373.5MB) / RAM 60%
0.6 2 30 = ( / ) ( ( 2 * + 1 ) * ( + ) ) * 512 12.45MB = 373,500,000 / 12,450,000 = 30 = (512-12) / 28 = 18 ( ( ( 2 * 18 ) + 1 ) * ( 20 + 8 ) ) * 9 = 9324 (12.5MB) 9324? 2 12.45MB B-Tree ( ) [MKDE] [Memory Resources] [Cache Allocation] ( ) MicroKernel : [Cache Allocation]
B-Tree ( ) B-Tree ( ) 12 = 1 ( ) =.65 ([Index Balancing ] ) =.55 ([Index Balancing ] ) = 1 ( (Linked Duplicate) ) = ( ) / 1 / = ( ( ( ) / ( + ) ) * ) B-Tree ( * < / ) B-Tree 1 ( * < ( / + / ^2)) B-Tree 2 ( * < ( / + / ^2 + / ^3)) B-Tree 3 B-Tree
MicroKernel Database Architecture MicroKernel Database Engine Navigational Client / Server Scalable SQL Pervasive Software Inc. Btrieve Pervasive Software Inc. Novell NetWare Novell, Inc. Windows Windows NT Visual Basic Microsoft Corporation Microsoft Microsoft Corporation 105-6124 2-4-1 33F TEL: (03) 5405-2261 FAX: (03) 5405-2269 Email:tyoinfo@pervasive.co.jp http://www.pervasive.co.jp