Actian Zen

Last updated
Actian Zen (PSQL)
Developer(s) Actian Corporation
Stable release
v16 / June 17, 2024
Operating system Cross-platform
Available inEnglish, Japanese
Type DBMS, RDBMS, NoSQL
License Shareware
Website www.actian.com/data-management/zen-embedded-database/

Actian Zen (formerly Btrieve, later named Pervasive PSQL until version 13) is an ACID-compliant, zero-DBA, embedded, nano-footprint, multi-model, Multi-Platform database management system (DBMS). [1] It was originally developed by Pervasive Software, which was acquired by Actian Corporation in 2013. [2]

Contents

It is optimized for embedding in applications [3] and is used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). Zen runs on system platforms that include Microsoft Windows, Linux, and Mac OS X. Both 32-bit and 64-bit editions of Zen are available. Editions are also specifically designed for different computer networking deployment needs, such as workgroup, client-server and highly virtualized environments including Cloud computing.

History

Pervasive Software was acquired by Actian Corporation in 2013. [2] Zen is embedded by OEMs like Sage, [4] Maestro* Technologies, ABACUS Research AG (Switzerland), and Unikum (Sweden) supporting software applications that address the accounting, finance, retail, point-of-sale, entertainment, reservation system, and medical and pharmaceutical industry segments. “Users include Novell, Microsoft, PeachTree Software, Fair Isaac, Disney World, Radio Shack, Cardiff and others.” [5] The accounting industry formed a large part of its market in 2007. [5]

Historically, Zen served as a DBMS for small and medium enterprises. [6]

DBMS architecture

Zen supports stand-alone, client-server, peer-to-peer [7] and software-as-a-service (SaaS) [8] architecture.

The central architecture of Zen consists of two database engines: (1) the storage engine, known as MicroKernel Database Engine (MKDE) and described as a transactional database engine, and (2) the relational database engine, known as SQL Relational Database Engine (SRDE). Both engines can access the same data, but the methods of data access differ. [9]

Micro Kernel Database Engine

The Micro-Kernel Database Engine, the transactional database engine, interacts directly with the data and does not require a fixed data schema to access the data. It uses a key-value store to store and access the data. Calls to the MKDE are made grammatically with Btrieve API [7] rather than through the use of a query language; therefore, Zen does not have to parse the request. This places the Micro Kernel Database Engine in the category of NotOnlySQL databases. [10] Low-level API calls and memory caching of data reduce the time required to manipulate data.

The MKDE operates in complete database transactions and guarantees full ACID (Atomicity, Consistency, Isolation, Durability). [1] 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.

In the MKDE, 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. The MKDE caches data in memory to facilitate performance. 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. Configuration settings for caches can be pre-configured by ISVs to optimize Zen performance for their applications.

Relational Database Engine

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. SRDE parses SQL queries and sends them to the MKDE to run.

The SRDE implements SQL-92. Significant other features include relational integrity, database security, and temporary tables. SRDE extends its functionality by supporting stored procedures, user-defined functions, and triggers. [11]

In addition to its support for SQL-92, the SRDE supports several significant features of COBOL: COBOL data types, COBOL OCCURS and VARIANT records. [7]

Additional features

Interfaces

Interfaces for Pervasive PSQL Interfaces to Pervasive PSQL.png
Interfaces for Pervasive PSQL

Zen interfaces fall into two categories: management interfaces and data manipulation interfaces.

Management interfaces

Actian provides the management interfaces Distributed Tuning Interface (DTI) [7] and Distributed Tuning Objects (DTO) and a Component Object Model (COM) adapter pattern (wrapper) for the DTI. [7] These provide application programming interfaces for configuration, monitoring, and diagnostics of Pervasive components. COBOL can also provide component management through a COBOL connector that can talk to DTI. [17]

Application interfaces

All other interfaces [7] exist for data manipulation purposes.

Tools

Actian provides utility software designed to facilitate administration and use of Zen. [7] There are graphical and command line utilities in Windows, Linux, and Mac OS X environments.

Zen Control Center (CC) is the main utility that enables the user to create and manipulate databases and tables, to access servers and clients, to set configurations and properties, and to edit data. Through CC, the user can access a series of other utilities:

Editions and licensing

Editions

There are five editions of Zen:

Other Products

Licensing

There are two different licensing models, user-count licensing and capacity-based licensing. [27]

Both Zen Edge Server and Zen Enterprise Server use a user-count licensing model, while Zen Cloud Server uses capacity-based licensing, and Zen Core is royalty-free for developers.

Versions

Actian Zen release history

ReleaseGeneral availabilityEnd of Enterprise SupportEnd of Extended SupportEnd of Obsolescence SupportMarquee Features
Current stable version:Zen v16August 27, 2019Aug 31, 2024Aug 31, 2029Aug 31, 2034New v16 File Format, Long Keys, Simple Replication, Universal Triggers, Microkernel Page Read-Ahead, SQL Query Logging Improvements, Offline Rebuild, Secured SQL Rights, Developer Changes, Linux Install/Uninstall Changes, Kafka integration, Licensing Changes [30]
Old version, yet still maintained: Zen v15August 15, 2021Aug 31, 2026Aug 31, 2031Aug 31, 2036Performance Improvements (File Close Delay, Transaction Log Changes, SQL DELETE and LIKE Operations, Scalar Subqueries and Statistics), System Data v2, File Size Limit for Backward Compatibility, SQL Windowing Functions, Administrative Changes, API Updates (Btrieve 2 Improvements, PDAC/BPL Changes, ADO.NET Changes, ActiveX and OLEDB SDK's removed), Platform Changes (removed support for Windows 7 and Windows Server 2008, added support for Windows 10 IoT Enterprise, Windows 11 and Windows Server 2022), Config-on-Install [31]
Old version, yet still maintained: Zen v14August 27, 2019Aug 31, 2024Aug 31, 2029Aug 31, 2034Complete Rebranding, AutoTimestamp Key Type, AES-256 Encryption, Java Runtime Environment Upgrade, JSON Filter, ADO.NET 4.4 Support (including support for Visual Studio 2019 and BIGIDENTITY data type), New Time Data Types (TIMESTAMP2, SQL support for the AUTOTIMESTAMP type, new time scalar functions), New Data Export Tool, Delete Extended Operations, SQL on Android/iOS, Read-Only DSN's, BUTIL Improvements (maintenance utility) [32]
Legend:
Old version, not maintained
Old version, still maintained
Latest version
Latest preview version
Future release

Actian PSQL and Btrieve release history

ReleaseGeneral AvailabilityEnd of General AvailabilityTransition SupportEnd of SupportNotes
Old version, no longer maintained: Zen/PSQL v13June 23, 2017December 31, 2020December 31, 2021December 31, 2022Support for Larger Data Sets, PSQL Reporting Engine, New Btrieve C and C++ APIs, New Schema Export and Import in CC, Updated Cache Management, New SDKs, LIKE with Btrieve Extended Operations, Integration with AD Security, New Operating System Support (Android, iOS, Windows Server 2019, and Windows Nano Server), 8-Byte AutoInc/BIGIDENTITY, TRY_CAST and TRY_CONVERT, UPSERT Capability. [33]
Old version, no longer maintained: Btrieve 12February 9, 2016Not ScheduledNot ScheduledNot ScheduledBtrieve 12 engine is file format and API compatible with Btrieve 6.15, so there is no need to change or even recompile your application. It offers a number of improvements over v6.15, such as full OS support for Windows 7, 8, and 10, improved performance due to a better caching configuration, the ability to use across-the-wire encryption and auto-reconnect (to survive brief network outages on wireless networks), and a vastly simplified configuration. [34]
Old version, no longer maintained: PSQL v12December 17, 2014June 30, 2018January 1, 2019July 1, 2019Online Database Defragmenter, More Unicode Support, Rebranding, Easier Installation, License Changes, Developer-Level Updates (ADO.NET v4.1 drivers, new features through JDBC and ODBC) New Operating systems (Windows 10, Mac OS X, Windows Server 2016). [35]
Old version, no longer maintained: PSQL Vx Server 11February 9, 2012June 30, 2015January 1, 2016July 1, 2016Hypervisor-Friendly Licensing (per instance), Flexible Bit Level Licensing, Optimized Backup Solutions for Virtual Machines. [36]
Old version, no longer maintained: PSQL v11September 29, 2010June 30, 2015January 1, 2016July 1, 2016New Operating Systems (Windows 8 and Windows Server 2012), Improved multi-threading, Full 64-bit and IPv6 Support, Developer-Level Updates, New Security Solutions and SQL Features, License and Logging Enhancements, Native Backup Solutions (at no extra costs), Licensing Changes and Updated Tools. [37]
Old version, no longer maintained: PSQL v10September 18, 2007March 31, 2011September 1, 2011March 1, 2012SQL syntax enhancements, a new cache (called Xtreme I/O) to improve 32-bit server performance, and a new 64-bit engine to provide native 64-bit support on newer hardware and operating system platforms. [37]
Old version, no longer maintained: PSQL v9March 1, 2005July 1, 2009July 1, 2009January 1, 2010Larger Database Support, Improved Linux Support, Improved SQL Performance and Syntax, New DBA Features, A New Control Center, Improved COBOL Support, Drive Letter Redirection, New Developer Features. [38]
Old version, no longer maintained: Pervasive.SQL V8November 26, 2002July 1, 2006December 31, 2006Improved Btrieve and SQL Performance, New SQL Syntax, No More Workstation Engine, New File Format, Simpler Configuration, Debug Requesters, Simpler Licensing. [39]
Old version, no longer maintained: Pervasive.SQL 2000iSeptember, 1999January 1, 2003July 1, 2004Pervasive.SQL 2000i was available in 3 client/server flavors and two local engines. [39]
Old version, no longer maintained: Pervasive.SQL 7January, 1998January 1, 2002January 1, 2002Pervasive.SQL 7 is the result of the bundling of Btrieve 7 and Scalable SQL 4 (a relational database product) engines into a single product. It allowed for a high level of backward compatibility for applications based on the Btrieve API or ODBC/SSQL. Pervasive.SQL 7 was available in a client/server model for both Novell NetWare and Microsoft Windows NT 4.0, and supports access from DOS, Windows 3.x, Windows 9x, Windows NT, and OS/2 clients. [40]
Old version, no longer maintained: Btrieve 6.15July 1, 1994July 1, 1999September 1, 1999See Btrieve for more information. Btrieve 6.15 was released for DOS, Windows and OS/2. This version is incompatible with previous releases, as it was totally rewritten.
Legend:
Old version, not maintained
Old version, still maintained
Latest version
Latest preview version
Future release

Actian Zen AuditMaster release history

ReleaseGeneral AvailabilityEnd of General AvailabilityTransition SupportEnd of SupportNotes
Current stable version:AuditMaster v16June 17, 2024June 30, 2029June 30, 2034June 30, 2039AuditMaster v16 offers compatibility with Actian Zen v16 for Windows. This release is for Windows ONLY and is available as of June 17, 2024.
Old version, yet still maintained: AuditMaster v15August 15, 2021Aug 31, 2026Aug 31, 2031Aug 31, 2036AuditMaster v15 offers compatibility with Actian Zen v15.10 for Windows. [41]
Old version, yet still maintained: AuditMaster v14August 27, 2019Aug 31, 2024Aug 31, 2029Aug 31, 2034AuditMaster v14 offers compatibility with Actian Zen v14.10 for Windows, and it has been completely rewritten from the ground up with all new tools and alert capabilities. [41]
Old version, no longer maintained: AuditMaster v13June 23, 2017December 31, 2020December 31, 2021December 31, 2022AuditMaster v13 offers compatibility with Actian Zen/PSQL v13 and Zen Vx Server 13 Service Pack 1 and newer. [41]
Old version, no longer maintained: AuditMaster v12December 17, 2014June 30, 2018January 1, 2019July 1, 2019AuditMaster v12 offers compatibility with Actian PSQL v12 and PSQL Vx Server 12 Service Pack 1 and newer. [41]
Old version, no longer maintained: AuditMaster v8February 9, 2012July 1, 2016January 1, 2017July 1, 2017AuditMaster v8.0 offers compatibility with Actian PSQL Vx Server 11 as well as Actian PSQL v11. This version offers a per-database licensing (instead of per user), and worked with 32-bit and 64-bit server engines. Version v8.1 offered compatibility with Service Pack 3 of both PSQL versions, which now included support for Windows 8 and Windows Server 2012. Since v8.0, AuditMaster is only available for Windows. [41]
Old version, no longer maintained: AuditMaster v7November 22, 2010April 1, 2012January 1, 2016July 1, 2016AuditMaster v7.0 was released in November 2010 and requires Pervasive PSQL v11. There was only a Windows 32-bit implementation of this product, so it was not compatible with a 64-bit engine. [41]
Old version, no longer maintained: AuditMaster v6.4September 18, 2007October 31, 2011March 1, 2012September 1, 2012AuditMaster v6.4 was supported on Pervasive PSQL v10, and was available for Windows only. This product worked with 32-bit versions of PSQLv10 only. [41]
Old version, no longer maintained: AuditMaster v6.3November 15, 2005March 1, 2010March 1, 2010October 1, 2010AuditMaster v6.3 was supported on Pervasive PSQL v9.1 server database engines only, but there was a version for Windows Servers and a different one for NetWare servers. [41]
Old version, no longer maintained: AuditMaster v6.2December 31, 2006AuditMaster v6.2 was supported on Pervasive.SQL V8 Windows Server database engines only. Workgroup Engines are NOT supported. If you have Pervasive.SQL V8, you can't upgrade to 6.3 - you must upgrade to PSQLv9 first. [41]
Legend:
Old version, not maintained
Old version, still maintained
Latest version
Latest preview version
Future release

Actian Zen DataExchange release history

ReleaseGeneral AvailabilityEnd of General AvailabilityTransition SupportEnd of SupportNotes
Current stable version:DataExchange v16June 17, 2024June 30, 2029June 30, 2034June 30, 2039DataExchange v16 is designed for Actian Zen v16 Server (64-bit only)
Old version, yet still maintained: DataExchange v15January 24, 2023Aug 31, 2026Aug 31, 2031Aug 31, 2036DataExchange v15 was designed for Actian Zen v15 Server and Zen Cloud Server 15 systems that are running Service Pack 1 or above. Note that this release includes only the 64-bit Windows platform, so there is no version that will work with a Workgroup Engine. [42]
Old version, yet still maintained: DataExchange v14May, 2021TBDTBDTBDDataExchange v14 was designed for Actian Zen v14 Server and Zen Cloud Server 14 systems. Note that this release includes only the 64-bit Windows platform, so there is no version that will work with a Workgroup Engine. [42]
Old version, no longer maintained: DataExchange v13June 23, 2018December 31, 2020December 31, 2021December 31, 2022DataExchange v13 was designed for Actian Zen v13 Server and Zen Vx Server 13 systems. [42]
Old version, no longer maintained: DataExchange v12December 17, 2014June 30, 2018January 1, 2019July 1, 2019DataExchange v12 was designed for Actian PSQL v12 Server and PSQL Vx Server 12 systems. It features no major changes over v5.1, except for support on Windows Server 2016 and Windows 10. [42]
Old version, no longer maintained: DataExchange v5February 9, 2012July 1, 2016January 1, 2017July 1, 2017DataExchange v5.0 was released to add compatibility with Actian PSQL Vx Server 11 as well as Actian PSQL v11. This version offered a per-database licensing (instead of per user), worked with 32-bit and 64-bit server engines, and was available only for Windows. Version v5.1 was designed for Actian PSQL Server v11 and PSQL Vx Server 11 for Service Pack 3 and newer. This new patch adds support for Windows 8 and Windows Server 2012, but it also removes the DataExchange Designer from the code. [42]
Old version, no longer maintained: DataExchange v4November 22, 2010April 1, 2012January 1, 2016July 1, 2016DataExchange v4.0 required Pervasive PSQL v11. There was both 32-bit and 64-bit versions, and it was only available for Windows. [42]
Old version, no longer maintained: DataExchange v3.0August 19, 2008October 31, 2011March 1, 2012September 1, 2012DataExchange v3.0 for new PSQLv10 installations was released with Service Pack 1. It only worked on Pervasive PSQL Summit v10.10 and above (it didn't work on v10.00). This tool was supported on Windows 32-bit platforms only. DXv3 did not work on a PSQLv10 64-bit engine. [42]
Old version, no longer maintained: DataExchange v2.9September 18, 2007August 19, 2008August 19, 2008September 1, 2012DataExchange v2.9 was supported on Pervasive PSQL v10.00, but only as an upgrade from a PSQLv9 installation. This product worked with 32-bit versions of PSQLv10 only. [42]
Old version, no longer maintained: DataExchange v2.8April 26, 2005March 1, 2010March 1, 2010October 1, 2010DataExchange v2.8 was supported on Pervasive PSQL v9.1 and newer server database engines on Windows servers only (There is no DataExchange for Linux or NetWare). [42]
Old version, no longer maintained: DataExchange v2.7December 31, 2006DataExchange v2.7 was supported on Pervasive.SQL V8 Windows Server database engines only. If you have Pervasive.SQL V8, you can't upgrade to 2.8 ― you must upgrade to PSQLv9 first. [42]
Legend:
Old version, not maintained
Old version, still maintained
Latest version
Latest preview version
Future release

Limitations

Actian Zen lacks:

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">Informix</span> Database management software product family

Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

FileMaker is a cross-platform relational database application developed by Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to visually modify a database. Versions for desktops, servers, iOS, and web-delivery have been released.

<span class="mw-page-title-main">Firebird (database server)</span> Relational database management system

Firebird is an open-source SQL relational database management system that supports Linux, Microsoft Windows, macOS and other Unix platforms. The database forked from Borland's open source edition of InterBase in 2000 but the code has been largely rewritten since Firebird 1.5.

Btrieve is a transactional database software product. It is based on Indexed Sequential Access Method (ISAM), which is a way of storing data for fast retrieval. There have been several versions of the product for DOS, Linux, older versions of Microsoft Windows, 32-bit IBM OS/2 and for Novell NetWare.

InterSystems Caché is a commercial operational database management system from InterSystems, used to develop software applications for healthcare management, banking and financial services, government, and other sectors. Customer software can use the database with object and SQL code. Caché also allows developers to directly manipulate its underlying data structures: hierarchical arrays known as M technology.

Btrieve is a database developed by Pervasive Software. The architecture of Btrieve has been designed with record management in mind. This means that Btrieve only deals with the underlying record creation, data retrieval, record updating and data deletion primitives. Together with the MicroKernel Database Engine it uses ISAM, Indexed Sequential Access Method, as its underlying storage mechanism.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

The Access Database Engine is a database engine on which several Microsoft products have been built. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.

<span class="mw-page-title-main">OpenROAD</span>

OpenROAD, which stands for "Open Rapid Object Application Development", is a fourth-generation programming language (4GL) and development suite from Actian Corporation.

Pervasive Software was a company that developed software including database management systems and extract, transform and load tools. Pervasive Data Integrator and Pervasive Data Profiler are integration products, and the Pervasive PSQL relational database management system is its primary data storage product. These embeddable data management products deliver integration between corporate data, third-party applications and custom software.

<span class="mw-page-title-main">Virtuoso Universal Server</span> Computer software

Virtuoso Universal Server is a middleware and database engine hybrid that combines the functionality of a traditional relational database management system (RDBMS), object–relational database (ORDBMS), virtual database, RDF, XML, free-text, web application server and file server functionality in a single system. Rather than have dedicated servers for each of the aforementioned functionality realms, Virtuoso is a "universal server"; it enables a single multithreaded server process that implements multiple protocols. The free and open source edition of Virtuoso Universal Server is also known as OpenLink Virtuoso. The software has been developed by OpenLink Software with Kingsley Uyi Idehen and Orri Erling as the chief software architects.

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

<span class="mw-page-title-main">Db4o</span> Open source object database

db4o was an embeddable open-source object database for Java and .NET developers. It was developed, commercially licensed and supported by Actian. In October 2014, Actian declined to continue to actively pursue and promote the commercial db4o product offering for new customers.

CUBRID ( "cube-rid") is an open-source SQL-based relational database management system (RDBMS) with object extensions developed by CUBRID Corp. for OLTP. The name CUBRID is a combination of the two words cube and bridge, cube standing for a space for data and bridge standing for data bridge.

Actian is an American software company headquartered in Santa Clara, California that provides analytics-related software, products, and services. The company sells database software and technology, cloud engineered systems, and data integration solutions.

The following outline is provided as an overview of and topical guide to MySQL:

References

  1. 1 2 Wiejers, Ben (October 2001) [December 2000]. "Transactions, Locking and DataFlex". Data Access Worldwide. Archived from the original on 2012-05-05. Retrieved 2012-04-18.
  2. 1 2 "Actian Corporation and Pervasive Software Unite to Take Action on Big Data". Archived from the original on 2013-12-02. Retrieved 2013-06-13.
  3. Stanley, Nigel; Kaufman, Marcia (2007). "Delivering Embedded Database Solutions for Small and Medium-sized Businesses" (PDF). Hurwitz and Associates. Archived from the original on 2023-08-13. Retrieved 2012-04-18.
  4. "Manufacturing ERP Software–Sage PFW ERP". Sagepfw.com. Archived from the original on 2012-03-08. Retrieved 2012-05-12.
  5. 1 2 Vaughan, Jack (October 16, 2002). "Pervasive on replication trail". Application Development Trends. Archived from the original on March 5, 2016. Retrieved April 18, 2012.
  6. "Software provides growth solution for organization databases". ThomasNet News. September 26, 2007. Archived from the original on March 3, 2016. Retrieved April 18, 2012.
  7. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 "Pervasive Documentation Library: Pervasive PSQL v11 SP2". Pervasive Software. April 2012. Archived from the original on 2012-04-26. Retrieved 2012-05-01.
  8. Bloor, Robin; Jozwiak, Rebecca (December 2011). "Moving to the Cloud with Pervasive PSQL" (PDF). The Bloor Group. Archived (PDF) from the original on 2013-06-07. Retrieved 2012-04-18.
  9. Lax, Joe (January 23, 2004). "Top-notch Auditing an Impressive Add-on for Pervasive.SQL". DevX.com. Archived from the original on June 2, 2007. Retrieved April 12, 2024.
  10. "LIST OF NOSQL DATABASES". NoSQL. Archived from the original on December 26, 2018. Retrieved April 30, 2012.
  11. van der Lans, Rick F. (2009). The SQL Guide to Pervasive PSQL. Lulu. pp. 443–548. ISBN   978-0-557-10543-4.
  12. "What file versions does Row Level Locking (RLL) work with in Pervasive.SQL 2000?". Pervasive Software. June 2001. Archived from the original on 2023-08-13. Retrieved 2012-04-18.
  13. 1 2 "Pervasive Software Delivers Pervasive PSQL Summit v10.10 Database". Pervasive Software. June 11, 2008. Archived from the original on January 31, 2013. Retrieved April 18, 2012.
  14. Durham, Dale (April 23, 2008). "Unicode support?". Pervasive Community Site. Archived from the original on March 4, 2016. Retrieved April 18, 2012.
  15. "Pervasive Documentation Library: Pervasive AuditMaster". Pervasive Software. April 2012. Archived from the original on 2011-10-07. Retrieved 2012-05-01.
  16. "Pervasive Documentation Library: Pervasive DataExchange". Pervasive Software. April 2012. Archived from the original on 2011-10-07. Retrieved 2012-04-18.
  17. "Pervasive Documentation Library: Pervasive PSQL v10" (PDF). Pervasive Software. April 2008. Archived from the original on 2023-08-13. Retrieved 2012-04-19.
  18. "Archived copy" (PDF). Archived (PDF) from the original on 2023-04-10. Retrieved 2023-04-10.{{cite web}}: CS1 maint: archived copy as title (link)
  19. "Archived copy" (PDF). Archived (PDF) from the original on 2023-04-10. Retrieved 2023-04-10.{{cite web}}: CS1 maint: archived copy as title (link)
  20. "Zen Products". Actian. Retrieved 2024-04-11.
  21. "Archived copy" (PDF). Archived (PDF) from the original on 2023-03-06. Retrieved 2023-04-10.{{cite web}}: CS1 maint: archived copy as title (link)
  22. "Archived copy" (PDF). Archived (PDF) from the original on 2023-04-10. Retrieved 2023-04-10.{{cite web}}: CS1 maint: archived copy as title (link)
  23. "Introducing Actian AuditMaster". Actian. Retrieved 2024-04-11.
  24. "Introducing DataExchange". Actian. Retrieved 2024-04-11.
  25. "Backup Agent Documentation". Actian. Retrieved 2024-11-03.
  26. "Backup Agent Product Information". Goldstar Software. Retrieved 2024-11-03.
  27. "License Models". Actian. Retrieved 2024-04-11.
  28. "Concurrent User License Model". Actian. Retrieved 2024-04-11.
  29. "Capacity-based License Model". Actian. Retrieved 2024-04-11.
  30. "Actian Zen v16 Product Information". Goldstar Software. Retrieved 2024-11-02.
  31. "Actian Zen v15 Product Information". Goldstar Software. Retrieved 2024-04-12.
  32. "Actian Zen v14 Product Information". Goldstar Software. Retrieved 2024-04-12.
  33. "Actian Zen/PSQL v13 Product Information". Goldstar Software. Retrieved 2024-04-12.
  34. "Btrieve 12 Product Information". Goldstar Software. Retrieved 2024-04-12.
  35. "Pervasive PSQL v12 Product Information". Goldstar Software. Retrieved 2024-04-12.
  36. "Pervasive PSQL Vx Licensing Primer". Goldstar Software. Retrieved 2024-04-12.
  37. 1 2 "Pervasive PSQL v10 Product Information". Goldstar Software. Retrieved 2024-04-12.
  38. "Pervasive PSQL v9 Product Information". Goldstar Software. Retrieved 2024-04-12.
  39. 1 2 "Pervasive.SQL 2000i Product Information". Goldstar Software. Retrieved 2024-04-12.
  40. "Pervasive.SQL 7 Product Information". Goldstar Software. Retrieved 2024-04-12.
  41. 1 2 3 4 5 6 7 8 9 Goldstar Software. "AuditMaster Product Information" . Retrieved 2021-04-12.
  42. 1 2 3 4 5 6 7 8 9 10 Goldstar Software. "Actian DataExchange Product Information" . Retrieved 2021-04-12.
  43. "Setting Up a Client Reporting Engine". Actian. Retrieved 2024-04-12.
  44. "Making the Most of the Client Cache Engine" (PDF). Goldstar Software Inc. March 7, 2016. Archived (PDF) from the original on December 15, 2018. Retrieved December 15, 2018.