1 / 27

Pervasive.SQL 2000

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 SP2 Common Address Space (CAS)

duane
Download Presentation

Pervasive.SQL 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. Proud to be part of the: Conference

  3. Pervasive.SQL 2000

  4. Pervasive.SQL 2000 – Service Pack 2 • Pervasive.SQL 2000 SP2 • 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 NetBIOS 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

  5. Pervasive.SQL 2000 – Service Pack 2 continued • Asynchronous I/O • The server MicroKernel for Windows NT now uses asynchronous I/O when writing pages to disk • The MicroKernel 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 MicroKernel 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

  6. 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

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

  8. Replication

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

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

  11. 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

  12. Pervasive.SQL 2000 - Replication Hub and spoke

  13. Pervasive.SQL 2000 - Replication N-Tier

  14. Pervasive.SQL 2000 - Replication Peer-to-Peer

  15. Roadmap

  16. Pervasive.SQL 2000 – Service Pack 3 • Pervasive.SQL 2000 SP3 • - Improved Stability • - OLEDB 2.0 compliance • -ICommand and IRowset • - JDBC 2.0 compliance • - Auto Reconnect through System Sockets • - Everything that Pervasive.SQL 7 DOES and more

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

  18. Training for YOU and YOUR company

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

  20. 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 ActiveX and PDAC

  21. 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

  22. 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

  23. 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!!”

  24. Wrap-up

  25. 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

  26. 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

  27. Questions

More Related