The PSQL MicroKernel Engine
The PSQL MicroKernel Engine offers easy installation, uncomplicated maintenance, and high levels of performance and reliability. PSQL provides a foundation on which you can run transactional applications or migrate to a relational database system.
Benefits
PSQL’s MicroKernel Engine through the Btrieve API has been the data management system of choice for tens of thousands of applications around the world for more than 25 years now. In the highly competitive accounting software market—where reliability and performance are paramount—many of the top 10 vendors choose PSQL. Many application developers choose PSQL for its speed, data integrity, easy scalability, and low maintenance costs.
•
Speed. The MicroKernel Engine is capable of sub-second response rates, even when building multi-gigabyte databases for hundreds of users. The engine 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 Engine 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. PSQL provides easy scalability from workstation to large client/server environments.
•
Low Cost. The low support costs experienced by PSQL developers translate into low maintenance costs realized by PSQL application end users. PSQL eliminates the need for sustained database administration through automatic data recovery functions and easy-to-use utilities.
Features
The MicroKernel Engine offers many features, including the following:
•
Direct interaction with the data that does not require fixed data schema to access the data. It uses key-value store to store and access the data.
•
Calls to the engine are made programmatically with Btrieve API rather than through the use of a query language; therefore, PSQL does not have to parse the request.
•
Low-level API calls and memory caching of data reduce the time required to manipulate data.
•
Access to databases distributed across multiple engines.
•
Robust transactions for both single-server systems and distributed, multi-server systems.
•
The engine operates in complete database transactions and guarantees full ACID (Atomicity, Consistency, Isolation, Durability).
•
Records are stored in files which are roughly equivalent to the tables of a relational database engine. It supports multiple keys on a record and therefore multiple indexes in the file.