Pervasive SQL 2000 The Freedom to Create Applications

Pervasive. SQL 2000 The Freedom to Create Applications for Everyone, Everywhere

Proud to be part of the: Conference

Pervasive. SQL 2000

Pervasive. SQL 2000 – Service Pack 2 Pervasive. SQL 2000 SP 2 - Common Address Space (CAS) - both the transactional and relational engines are loaded and operate in the same process address space, thus, reducing the CPU time required to communicate between them - Auto-Increment - The SQL Relational Database Engine now creates an index for an Identity (auto-increment) column. It will also default the value for the column to the value 0. The net result is that the value will increment to the next in the series for the column. - New Communications Server - new features such as Net. BIOS support and TCP/IP Multihomed support - Multihomed support for TCP/IP allows you to communicate directly to more than one Network Interface Card without the use of IP Forwarding

Pervasive. SQL 2000 – Service Pack 2 continued - Asynchronous I/O - The server Micro. Kernel for Windows NT now uses asynchronous I/O when writing pages to disk - The Micro. Kernel quickly writes pages to Windows NT system cache and Windows NT signals when the pages are on disk - Read performance is also enhanced when there are many concurrent operations being done in the Micro. Kernel at the same time, especially if you access your dataset on a striped set of disk drives. Each read causes a worker thread to wait until the page is available. With asynchronous I/O, Windows NT can pool the work of multiple readers to make the "reads" more efficient New Grant Statement for Secured Databases - - This will enable users, including the Master User, to access tables that have owner names associated with them

Pervasive. SQL 2000 – Service Pack 2 continued - Modifying Legacy Data - This means you can Insert/Update NULL into any legacy column type without pseudo-Null conversion speed improvements across all access methods - DSNless connection - Updated Pervasive Control Center - First SP for Linux/Solaris platforms - Many bug fixes

Pervasive. SQL 2000 – Service Pack 2 continued Pervasive. SQL 2000 SP 2 - Asynchronous I/O speed improvements across all access methods - DSNless connection - Updated Pervasive Control Center - First SP for Linux/Solaris platforms - Many bug fixes

Replication

Pervasive. SQL 2000 - Replication Key Features • Heterogeneous enterprise operation: n n fully bidirectional, 100% fidelity all data types, including BLOBs • Database support “matrix”: n n n n Oracle (7. x and 8. x) Microsoft SQL Server (6. 5 and 7) Sybase SQL Server / ASE Sybase SQL Anywhere / ASA Informix Dynamic Server Inter. Base Microsoft Access Corel Paradox

Pervasive. SQL 2000 - Replication Key Features • Scalable, Reliable: n n n all Pervasive. SQL 2000 platforms, server to palmtop up to thousands of databases, various sizes, full local autonomy volumes: trickle to 10 GB+/day any TCP/IP network: LAN, WAN, Internet, wireless efficient net-change, compressed, strongly encrypted • Manageable: n n central and remote management from any location automatic, scheduled operation • Automatic conflict resolution n n default: timestamps, most recent update wins fully customizable, as part of event callback API

Pervasive. SQL 2000 - Replication n every database a peer: update-anywhere based on user-defined rules every database autonomous, all transactions local; no point of failure automatic, transparent: just add a database wherever needed

Pervasive. SQL 2000 - Replication Hub and spoke

Pervasive. SQL 2000 - Replication N-Tier

Pervasive. SQL 2000 - Replication Peer-to-Peer

Roadmap

Pervasive. SQL 2000 – Service Pack 3 Pervasive. SQL 2000 SP 3 - Improved Stability - OLEDB 2. 0 compliance -ICommand IRowset - JDBC 2. 0 compliance - Auto Reconnect through System Sockets - Everything that Pervasive. SQL 7 DOES and more

Pervasive Future Re-Organization Getting Back to Core Product Taking Care of OEMs and VARs

Training for YOU and YOUR company

Training Courses Services and Support Training (Beginning and Intermediate) • • • Pervasive. SQL Architecture Access Methods Utilities Installation Optimizing Configuration Creating DDFs

Training Courses - continued Pervasive. SQL Programming (Introduction) • Overview of Pervasive. SQL Architecture • Differences between Workstation, Workgroup, and Server • Capabilities of the Btrieve API • Relational access through SQL Relational Database Engine (SRDE) and ODBC • Discussion of using Active. X and PDAC

Training Courses - continued Pervasive. SQL Relational Programming (Intermediate) • Database design for power and performance • Structured Query Language (SQL) in your application • Access Methods • Enforcing Data Referential Integrity • Data retrieval and data manipulation • Writing Open Database Connectivity Applications

Training Courses - continued Pervasive. SQL Btrieve Programming (Intermediate) • Embedding data access using the Transactional API • Access Methods • How to develop a multi user application • Data retrieval and data manipulation • Identify the need to use the extended operators of the MKDE

WHY DO I NEED TRAINING Pervasive Training makes a smarter you!! • If you KNOW the product your selling it’s more credible to your customer and easier to SELL!!! • Fascinate your friends and co-workers with your knowledge • It will impress your clients more if you can speak intelligently about the product instead of just saying “It’s COOL!!”

Wrap-up

Wrap up Pervasive Website • http: //www. pervasive. com • Revised content and search engine • Under constant enhancement Information from Pervasive Tech Support and partners’ support organizations • FYIs, FAQs, White Papers, Tech Tips, READMEs • Installation and configuration instructions • Sample code

Contact us Phone Number • United States 1 -800 -287 -4383 • Europe 011 -353 -1 -887 -9222 (Dublin) Internet • Website (http) - www. pervasive. com • FTP (ftp) - ftp. pervasive. com/support • E-mail - techsupport@pervasive. com- FAX 1 -512 -794 -1778 (US) 011 -353 -1 -887 -9244 (Dublin) USENET comp. databases. btrieve

Questions