COBOL can also provide component management through a COBOL connector that can talk to DTI. These provide application programming interfaces for configuration, monitoring, and diagnostics of Pervasive components.
Pervasive sql software#
Pervasive Software provides the management interfaces Distributed Tuning Interface (DTI) and Distributed Tuning Objects (DTO), a Component Object Model (COM) adapter pattern (wrapper) for the DTI. Pervasive PSQL interfaces fall into two categories: management interfaces and data manipulation interfaces. In addition to its support for SQL-92, the SRDE supports several significant features of COBOL: COBOL data types and COBOL OCCURS and VARIANT records. SRDE extends its functionality by supporting stored procedures, user-defined functions, and triggers. Significant other features include relational integrity, database security, and temporary tables. SRDE parses SQL queries and sends them to the MKDE to run. The second database engine, the SQL Relational Database Engine or SRDE, operates in a manner similar to other relational database engines, that is, through the support of Structured Query Language queries. Configuration settings for caches can be pre-configured by ISVs to optimize Pervasive PSQL performance for their applications. When a call is made to the MKDE, cached data is searched first physical storage is searched if there is no cache of the data. The MKDE caches data in memory to facilitate performance.
It supports multiple keys on a record and therefore multiple indexes in the file. In the MKDE, records are stored in files which are roughly equivalent to the tables of a relational database engine. If a transaction does not fully run its course due to an external event such as a power interruption, the data remains in the state in which it existed before the transaction began to run.
Pervasive sql full#
The MKDE operates in complete database transactions and guarantees full ACID (Atomicity, Consistency, Isolation, Durability). 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. 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 sql mac os#
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). Pervasive PSQL is an ACID-compliant database management system (DBMS) developed by Pervasive Software.
0 kommentar(er)
