pervasive.sql 2000 the freedom to create applications for everyone, everywhere
TRANSCRIPT
Pervasive.SQL 2000The Freedom to Create Applications for Everyone, Everywhere
Conference
Proud to be part of the:
Pervasive.SQL 2000
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
Pervasive.SQL 2000 – Service Pack 2
- 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
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 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
Pervasive.SQL 2000 – Service Pack 2 continued
Replication
Pervasive.SQL 2000 - Replication
• 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
Key Features
Pervasive.SQL 2000 - Replication
• 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
Key Features
Pervasive.SQL 2000 - Replication
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 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
Pervasive.SQL 2000 – Service Pack 3
Re-Organization
Getting Back to Core Product
Taking Care of OEMs and VARs
Pervasive Future
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 ActiveX 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 - [email protected]
FAX 1-512-794-1778 (US)
011-353-1-887-9244 (Dublin)
USENETcomp.databases.btrieve
Questions