Low-level API calls and memory caching of data reduce the time required to manipulate data.

This places the MicroKernel Database Engine in the category of NotOnlySQL databases. Calls to the MKDE are made programmatically with Btrieve API rather than through the use of a query language therefore, Pervasive PSQL does not have to parse the request. It uses key-value store to store and access the data. Pervasive's transactional database engine, the MicroKernel Database Engine, interacts directly with the data and does not require fixed data schema to access the data. Both engines can access the same data, but the methods of data access differ.

The central architecture of Pervasive PSQL consists of two database engines: (1) the storage engine, known as MicroKernel Database Engine (MKDE) and described by Pervasive Software as a transactional database engine and (2) the relational database engine, known as SQL Relational Database Engine (SRDE). Pervasive PSQL supports stand-alone, client-server, peer-to-peer and software-as-a-service (SaaS) architecture. Historically, Pervasive PSQL served as a DBMS for small and medium enterprises. “Users include Novell, Microsoft, PeachTree Software, Fair Isaac, Disney World, Radio Shack, Cardiff and others.” The accounting industry formed a large part of its market in 2007. Pervasive PSQL is embedded by OEMs like Sage, maestro* Technologies, ABACUS Research AG (Switzerland), and Unikum (Sweden) in packaged software applications that address the accounting, finance, retail, point-of-sale, entertainment, reservation system, and medical and pharmaceutical industry segments. īecause Pervasive PSQL is used for embedded databases, and sold indirectly, it is not well known. Pervasive Software was acquired by Actian Corporation in 2013. The original name for Pervasive PSQL was Btrieve.

Editions are also specifically designed for different computer networking deployment needs, such as workgroup, client-server, and highly virtualized environments, including Cloud computing. Both 32-bit and 64-bit editions of Pervasive PSQL are available. Pervasive PSQL runs on system platforms that include Microsoft Windows, Linux, and Mac OS X. It is available for software as a service (SaaS) deployment due to a file-based architecture enabling partitioning of data for multitenancy needs.Īpplications can store the data and the relationships in tables in a relational model (RDBMS) or store the data in a schema-less way with no fixed data model ( key-value store). It is optimized for embedding in applications and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). data-management /zen-embedded-database /Īctian Zen (named Pervasive PSQL before version 13) is an ACID-compliant database management system (DBMS) developed by Pervasive Software.

Pervasive psql v13 cache client