Kevin Lewis Lead Software Engineer Stephen Slezak Product

Kevin Lewis Lead Software Engineer Stephen Slezak Product Manager Pervasive. SQL Pervasive Software On Target With Pervasive Software

Pervasive Software Presentation Overview • Pervasive Software - Company Strengths • Pervasive Software - Product Strengths • Pervasive. SQL 2000 • Pervasive Software - Technology Futures • Internationalization • Replication • Mobile and Embedded Products Pervasive Software

Pervasive Software - Company Vision To be the leading provider of database and information management solutions that dramatically simplify the development, deployment and maintenance of robust distributed and web-based applications. Pervasive Software

Pervasive Software - Company Vision The Pervasive Advantage • Lowest cost of ownership • Smallest footprint • Highest performance transaction engine in the universe • Unique advantage of both Transactional and SQL interfaces • Enterprise partner (Oracle) integration • True cross platform deployment Pervasive Software

Pervasive Software - Market Strength World Wide Sales and Marketing • Market dominance in networked accounting • Worldwide Channel of 10, 000 ISVs, VARs and System Integrators • Worldwide Sales and Support - Offices in: • Toronto, Frankfurt, Paris, London, Tokyo and Hong Kong • Pervasive. SQL is now bundled within every copy of Net. Ware 5 • #3 on Forbes 1999 ASAP Dynamic 100 List of Top Technology Companies Pervasive Software

Pervasive Software - Partners and Relationships • Microsoft • Windows NT is our reference platform • Member Microsoft Developer’s Network • Collaboration with Windows DNA Platform group • Close relationship with Win. CE Platform group • Oracle • Common interoperability environment • Schlumberger • P. SQL “lite” embedded in Java. Flex smart cards • Novell • Strong sales and marketing relationship world wide • Pervasive. SQL now shipping with Net. Ware 5 Pervasive Software

Pervasive Software Pervasive. SQL • Designed for low IT infrastructure • Low maintenance and administration • Best of both worlds • Transactional and relational data access • Lowest cost of ownership • Dramatically improved installation and maintenance • Up to 10 x performance improvement over Btrieve 6. 15 • Full support for existing Btrieve applications Pervasive Software

Pervasive. SQL - Product Architecture Modular Data Access Architecture • Pervasive. SQL data access modules Applications Micro. Kernel Database Engine Future - XML OLE DB Transactional Relational • Data access functions • Schema management • Micro. Kernel Database Engine • Physical data access • Transaction processing and recovery • Advanced caching • Data integrity enforcement • Common Data Format Common data format Pervasive Software • Common data format across all access mechanisms

Pervasive. SQL - Product Architecture Best of Both Worlds Data Access Data Warehousing ? Ad-hoc Reports Relational Transaction Processing Pervasive Software

Pervasive. SQL - Cross Language / Cross interface / Cross Platform Dev. Tools Languages Access Method Dataflex C OLE DB MS Dev. Studio MS Access Delphi C++ VB Java Btrieve Symantec Cafe Cobol Java Trans ODBC Power Builder Pascal JDBC Pervasive. SQL Operating Systems Solaris Pervasive Software Windows NT/95/98 Net. Ware Linux

Pervasive. SQL - Product Strengths Broad Industry Support • Microsoft Back. Office Certification • IBM Netfinity Certification • Novell Net. Ware Certification Pervasive Software

Pervasive. SQL - Product Strengths Lowest Total Cost of Ownership • Little or no IS staff required for deployment and operation • Zero DBA install • Self diagnosing and configuring communications • Smart Component Architectures • Self identifying and configuring DLL components • Provides transparent support for applications based on multiple versions of the DB engine. Pervasive Software

Pervasive. SQL - Product Strengths Industry Leading Ease of Installation Self Diagnosing and configuring Communications Based on our Zero Administration Architecture Pervasive Software

Pervasive. SQL - Product Strengths Smart Components Architecture Compatibility Interface Application Interface WBTRV 32. DLL W 3 BTRV 7. DLL Btrieve Requester Communications Server Remote MKDE Server Net. Ware Server W 3 BIF 103. DLL Micro. Kernel Router W 3 MIF 103. DLL Communications Requester W 3 NSL 103. DLL Local MKDE Server Pervasive Software TCP/IP, SPX Communications Server Remote MKDE Server Windows NT Server

Pervasive. SQL - Product Strengths Pervasive. SQL I*net Data Server (IDS) • Internet enable existing and new applications • Zero code changes, including DOS apps! • Extend existing packaged applications to mobile and remote workers. Client Application/Browser Windows NT Server IDS TCP/IP Network (LAN or Internet) Pervasive. SQL Pervasive Software

Pervasive. SQL - Product Strengths Multi-platform support • Windows NT • Windows 95 • Windows CE • Unix - Solaris • Linux • Net. Ware • Future Pervasive Software

Pervasive. SQL - Product Strengths High Performance • Pervasive. SQL offers the best of both Worlds • The unique value of both transactional and relational data access mechanisms • Transactional Access: Provides a direct API into the database engine. • Relational Access: Allows high performance queries based on the standard SQL dialect. • Pervasive. 2000 will provide relational performance more than 2 times that of Pervasive. SQL 7. Pervasive Software

Pervasive. SQL Five-Year Cost of Ownership Comparison Pervasive. SQL Vs Microsoft SQL Server 6. 5 Source: Aberdeen Group 1997 Down load the white paper: http: //www. pervasive. com/support/technical/white/aberdeen-psql/ Pervasive Software

Pervasive. SQL Three-Year Cost of Ownership Comparison Microsoft SQL Server Vs. Oracle 8 Source: Aberdeen Group 1997 Down load the white paper: http: //www. microsoft. com/SQL/70/gen/tcoaberdeen. htm Pervasive Software

Pervasive. SQL Five-Year Cost of Ownership Comparison Pervasive. SQL Vs Microsoft SQL Server 7 Source: Aberdeen Group 1999 Down load the white paper: http: //www. pervasive. com/support/technical/white_cost. html Pervasive Software

Pervasive. SQL Five-Year Cost of Ownership Comparison Pervasive. SQL Vs Microsoft SQL Server 7 Improvement Ratio Source: Aberdeen Group 1997, 1999 Pervasive Software

Pervasive. SQL Five-Year Cost of Ownership Comparison Aberdeen Conclusions • Pervasive Software’s Pervasive. SQL 7 offers clearly superior TCO to that of Microsoft’s SQL Server 6. 5 and 7. 0. • The TCO ratio between Pervasive. SQL and SQL Server appears to be increasing. • Buyers should also consider performance, downtime, ease-ofuse, and flexibility. In each case, Pervasive. SQL 7 adds significant value relative to SQL Server 7. Pervasive Software

SQL Server Performance or Benchmark Testing. You may not disclose the results of any benchmark test of either the Server Software or Client Software for Microsoft SQL. . . to any third party without Microsoft's prior written approval Pervasive Software

Pervasive. SQL - Performance Industry Leading Performance Pervasive. SQL vs. Btrieve 6. 15 performance Debit/credit benchmark with TPC-B transaction profile and two second think time Windows NT Server Transactions/sec Pervasive. SQL logging Btrieve 6. 15 non-logging Btrieve 6. 15 logging Numbers of users Pervasive Software Btrieve 6. 15 durable

Pervasive. SQL Performance Pervasive. SQL Vs. Pervasive. 2000 Pervasive Software

Pervasive. SQL - Product Reviews “THE BOTTOM LINE: EXCELLENT. . . Pervasive. SQL is fast, reliable, and inexpensive. It also includes a choice of database access methods, a small footprint, and "maintenance-free" operations, which means the product can be developed, deployed, and maintained with little or no assistance. ” Info. World Magazine - Product Review Jan. 18, 1999 “Unlike other SQL-based database engines for NT, Pervasive. SQL has very modest system requirements because of several unique technologies that Pervasive Software uses to deliver the product. ” “Pervasive. SQL is a real bargain, especially for small and medium-sized business markets where IS staff is not necessarily in place…” Windows NT Magazine - Product Review May 1999 Pervasive Software

Pervasive. SQL - Pervasive Embedded Solutions Pervasive Software

Pervasive. SQL - Pervasive Corporate Customers Pervasive Software

Pervasive Software Pervasive. SQL 2000 2 L. SQ e v i s a Pervasive Software

Pervasive Software - Pervasive. SQL 2000 Pervasive. 2000 Release Highlights • Drives Cost of Ownership even lower than P. SQL 7. • Provides “Peer-to-Peer” Workgroup deployment. • Enhanced Relational data access performance • Enhanced Client/server relational architecture • Near-native MKDE performance • Client / Server ODBC access on Net. Ware! • Distributed Tuning Interface (DTI) • Allows direct application tuning and configuration of Pervasive. SQL. Pervasive Software

Pervasive Software - Pervasive. SQL 2000 Pervasive. 2000 Release Highlights • Expanded SQL syntax support • True NULL, outer joins, multiple variable-length columns • Enhanced ODBC Conformance • New/integrated management console • Console, Config, Monitor, Query Plan Viewer, SQL Ease (DDF Ease + SQL Scope) • Provided first release of Oracle Interoperability environment. • Fully compatible with existing Btrieve applications. Pervasive Software

Pervasive. SQL 2000 - Deployment Options Pervasive. 2000 Workstation Standalone embedded Solutions Application DBMS Pervasive Software

Pervasive. SQL 2000 - Deployment Options Pervasive. 2000 Workgroup Features • Multi-user access • Net. BIOS protocol support • Also TCP/IP and IPX/SPX • Same Install and components as Workstation • Default support for 3 clients • Better performance and reliability than MEFS Application DBMS Application Pervasive Software

Pervasive. SQL 2000 - Deployment Options Pervasive. 2000 Workgroup - Gateway Transparent Exploitation of any File Server Application DBMS Application File Server Pervasive Software

Pervasive. SQL 2000 - Deployment Options Pervasive. 2000 Client / Server Our Traditional Industry Leading Client / Server Solution Local Client Workstations Remote Client Workstations Local Area Network Internet DBMS Database Server Pervasive Software

Pervasive Software - Pervasive. SQL 2000 Distributed Tuning Interface · Connection - Start and stop Pervasive. SQL services on remote servers. · Configuration – Set database engine settings locally or on remote servers. · Monitoring - Retrieve engine statistics and resource usage, such as the files open on a server or the clients currently connected to it. • Cataloging - Manage database schema and dictionary information such as database names, table properties, data dictionary information and the ability to drop and create tables and dictionaries. Pervasive Software

Pervasive. SQL Technology Futures Pervasive Software

Pervasive Software - Technology Futures Internationalization • store and retrieve virtually any language • enable the entire core Pervasive product line to function around the world in accordance with an end-users locale specifics. This includes messages, date and number formatting, collation of data, etc. Pervasive Software

Pervasive Software - Technology Futures Replication Server A Full Database Client B Subset Pervasive Software Server C Subset Database Client D Subset

Pervasive Software - Technology Futures Mobile Connectivity and Data Replication Mobile Applications Remote stations with database replicas Rz a Rb Ra Jav Primary data server CE in W 95 in W Pervasive Software LAN, WAN or Dial up network N 1

Pervasive Software - Technology Futures Trends: Exponential Growth In Smart Handheld Devices Millions of Units Worldwide Smart Handheld Device Unit Shipment Forecast Source: IDC Pervasive Software

Pervasive Software - Technology Futures Trend: Exponential Growth in Smart Cards Millions of Units Worldwide Microcontroller and Memory Card Unit Forecast Source: Dataquest (Aug. 1998) Pervasive Software

Pervasive Software - Mobile and Embedded Products Who does this apply to. . . • Pervasive’s ultra-light databases are designed for use in. . . • Embedded systems • Mobile and handheld devices • Information Appliances Pagewriter (Win. CE) • Smart Cards and SOAC Smart Cards (Java) Pervasive Software Pilot (Palm OS)

Pervasive Software - Mobile and Embedded Products Pervasive’s Mobile and Embedded Products Strategy • RTOS • Partnerships - Wind River, QNX, ISI, Pharlap others TBD • Vertical Markets • Information Appliances • Partnerships - Software Developers, Chip Manufacturers • Sun Jini, em. Ware’s ETI Consortium, others TBD • Field Force Automation • Sell and Deploy to Pervasive’s ISVs • Commercial Mobile Devices • Win CE, Palm OS • Smart Cards • Partnerships with Card Manufacturers • Java Card Forum Database Sub-Committee Pervasive Software

Pervasive Software - Mobile and Embedded Products Product Roadmap Galileo • Win CE and Vx. Works • SDK Alpha NOW • Beta: April-June `99 • Palm Pilot, QNX, Phar. Lap • Beta: July-August ‘ 99 • Other OS’s • On-going • Smart Card DBMS • 2 nd half of 1999 Pervasive Software it Developer K Alpha Beta Roll out

Pervasive Software - Our Focus • Pervasive offers a range of choices chosen to make our partners successful. • Pervasive works to make our partners successful. • Many DBMS vendors spend the bulk of their investment and focus on gaining the acceptance of large enterprise customers. • Pervasive has always been and continues to be focused on lowering the cost of ownership for small, mid-sized and departmental organizations. Pervasive Software

Pervasive’ 1999 Partner Conference October 10 -13, 1999 - Austin Texas Pervasive Software

Pervasive Software Questions? Pervasive Software