The Pervasive.SQL Transactional Interface
Show this topic in Library frames
The Pervasive.SQL transactional interface, built on Btrieve, offers easy installation, uncomplicated maintenance, and high levels of performance and reliability. Pervasive.SQL provides a foundation on which you can run transactional applications or migrate to a relational database system.
Benefits
Pervasive.SQL's transactional interface is Btrieve, which has been the data management system of choice for tens of thousands of applications around the world for over two decades. In the highly competitive accounting software market-where reliability and performance are paramount-many of the top 10 vendors choose Pervasive.SQL. Many application developers choose Pervasive.SQL for its speed, data integrity, easy scalability, and low maintenance costs. As part of Pervasive.SQL, Btrieve's transactional interface offers:
- Speed. Pervasive.SQL uses the highly-evolved MicroKernel Database Engine, capable of sub-second response rates, even when building multi-gigabyte databases for hundreds of users. The MicroKernel achieves these high speeds through features such as internal indexing algorithms that cache pages for fast data retrieval and updates, and automatic index balancing to maintain fast data access, even as your files grow.
- Data Integrity. The MicroKernel guarantees data integrity through rich transaction processing support, referential integrity controls, and automatic file recovery. In the event of a server or system failure, logging features and roll forward utilities allow you to recover data up to your last completed transaction.
- Scalability. Many client/server database applications begin on the desktop and scale with corporate growth. Pervasive.SQL provides easy scalability from workstation to large client/server environments.
- Low Cost. The low support costs experienced by Pervasive.SQL developers translate into low maintenance costs realized by Pervasive.SQL application end users. Pervasive.SQL eliminates the need for sustained database administration through automatic data recovery functions and easy-to-use utilities.
Features
Pervasive.SQL provides a comprehensive transactional database management system that offers many features, including the following:
- MicroKernel Database Engine as the underlying data manager.
- Access to databases distributed across multiple server engines.
- Robust transactions for both single-server systems and distributed, multi-server systems.
