The Pervasive PSQL Transactional Interface
Chapter contents
The Pervasive PSQL transactional interface, built on Btrieve, offers easy installation, uncomplicated maintenance, and high levels of performance and reliability. Pervasive PSQL provides a foundation on which you can run transactional applications or migrate to a relational database system.
Benefits
Pervasive PSQL'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 PSQL. Many application developers choose Pervasive PSQL for its speed, data integrity, easy scalability, and low maintenance costs. As part of Pervasive PSQL, Btrieve's transactional interface offers:
- Speed. Pervasive PSQL 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 PSQL provides easy scalability from workstation to large client/server environments.
- Low Cost. The low support costs experienced by Pervasive PSQL developers translate into low maintenance costs realized by Pervasive PSQL application end users. Pervasive PSQL eliminates the need for sustained database administration through automatic data recovery functions and easy-to-use utilities.
Features
Pervasive PSQL 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.
