词条 | Pervasive PSQL |
释义 |
| name = Pervasive PSQL | developer = Actian Corporation | genre = DBMS, RDBMS, NotOnlySQL | status = Active | latest release version = PSQL v12 | latest release date = September 2015 | language = English, Japanese | operating system = Cross-platform | license = Shareware | website = {{URL |1=http://www.pervasivedb.com/}} {{URL |1=http://www.pervasive.com/}} {{URL |1=http://www.actian.com/}} }} Pervasive PSQL is an ACID-compliant database management system (DBMS)[1] developed by Pervasive Software. It is optimized for embedding in applications[2] and used in several different types of packaged software applications offered by independent software vendors (ISVs) and original equipment manufacturers (OEMs). It is available for software as a service (SaaS) deployment[3] due to a file-based architecture enabling partitioning of data for multitenancy needs. Applications 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). Pervasive PSQL runs on system platforms that include Microsoft Windows, Linux, and Mac OS X. Both 32-bit and 64-bit editions of Pervasive PSQL 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. The original name for Pervasive PSQL was Btrieve.[4] Pervasive Software was acquired by Actian Corporation in 2013.[5] Uses and customersBecause Pervasive PSQL is used for embedded databases, and sold indirectly, it is not well known.[4] Pervasive PSQL is embedded by OEMs like Sage,[6] 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. “Users include Novell, Microsoft, PeachTree Software, Fair Isaac, Disney World, Radio Shack, Cardiff and others.”[7] The accounting industry formed a large part of its market in 2007.[7] Historically, Pervasive PSQL served as a DBMS for small and medium enterprises.[8] DBMS architecture{{See also|Architecture of Btrieve}}Pervasive PSQL supports stand-alone, client-server, peer-to-peer[9] and software-as-a-service (SaaS)[3] architecture. 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). Both engines can access the same data, but the methods of data access differ.[10] MicroKernel Database EnginePervasive’s transactional database engine, the MicroKernel Database Engine, interacts directly with the data and does not require fixed data schema to access the data. It uses key-value store to store and access the data. Calls to the MKDE are made programmatically with Btrieve API[9] rather than through the use of a query language; therefore, Pervasive PSQL does not have to parse the request. This places the MicroKernel Database Engine in the category of NotOnlySQL databases.[11] 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 Pervasive PSQL performance for their applications. Relational Database EngineThe 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.[12] Significant other features include relational integrity, database security, and temporary tables. SRDE extends its functionality by supporting stored procedures, user-defined functions, and triggers.[13] 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.[9] Additional featuresPervasive PSQL provides the following additional features:
InterfacesPervasive PSQL interfaces fall into two categories: management interfaces and data manipulation interfaces. Management interfacesPervasive Software provides the management interfaces Distributed Tuning Interface (DTI)[9] and Distributed Tuning Objects (DTO), a Component Object Model (COM) adapter pattern (wrapper) for the DTI.[9] 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.[19] Application interfacesAll other interfaces[9] exist for data manipulation purposes.
ToolsPervasive provides utility software designed to facilitate administration and use of Pervasive PSQL.[9] There are graphical and command line utilities in Windows, Linux, and Mac OS X environments. Pervasive Control Center (PCC) is the main utility that enables the user to create and manipulate databases and tables, to access servers and clients, to set configuration, properties, and to edit data. Through PCC, the user can access a series of other utilities:
VersionsSee Btrieve, beginning with Pervasive.SQL 7. Editions and licensingEditionsThere are four editions of PSQL:[9] Pervasive PSQL Client, Pervasive PSQL Workgroup, Pervasive PSQL Server, and Pervasive PSQL Vx Server.
LicensingPervasive Software uses two different licensing models, user-count licensing and capacity-based licensing.[9]
Both PSQL Server and PSQL Workgroup use a user-count licensing model, while PSQL Vx Server uses capacity-based licensing. Limitations
See also
References1. ^1 {{cite web|title=Transactions, Locking and DataFlex|url=http://www.dataaccess.com/whitepapers/TransactionsLockingandDataFlex.htm#DFCKPSQL|publisher=Data Access Worldwide|author=Wiejers, Ben|origyear=December 2000|date=October 2001}} 2. ^{{cite web|title=Delivering Embedded Database Solutions for Small and Medium-sized Businesses|url=http://www.pervasivedb.com/SiteCollectionDocuments/WP0907F_Hurwitz.pdf|publisher=Hurwitz and Associates|author=Stanley, Nigel|author2=Kaufman, Marcia|year=2007}} 3. ^1 {{cite web|title=Moving to the Cloud with Pervasive PSQL|url=http://www.pervasivedb.com/SiteCollectionDocuments/WP_Bloor_Moving_to_the_Cloud_with_PSQL_Dec2011.pdf|publisher=The Bloor Group|author=Bloor, Robin|author2=Jozwiak, Rebecca|date=December 2011}} 4. ^1 {{cite book|title=The SQL Guide to Pervasive PSQL|year=2009|publisher=Lulu|isbn=978-0-557-10543-4|pages=44–45|author=van der Lans, Rick F.}} 5. ^{{cite web|title=Actian Corporation and Pervasive Software Unite to Take Action on Big Data|url=http://www.actian.com/press/actian-pervasive}} 6. ^{{cite web|url=http://www.sagepfw.com/products/pervasivesql.aspx |title=Manufacturing ERP Software–Sage PFW ERP |publisher=Sagepfw.com |accessdate=2012-05-12}} 7. ^1 {{cite web|title=Pervasive on replication trail|url=http://adtmag.com/articles/2002/10/16/pervasive-on-replication-trail.aspx|publisher=Application Development Trends|author=Vaughan, Jack|date=October 16, 2002}} 8. ^{{cite web|title=Software provides growth solution for organization databases|url=http://news.thomasnet.com/fullstory/Software-provides-growth-solution-for-organization-databases-531641|publisher=ThomasNet News|date=September 26, 2007}} 9. ^1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 {{cite web|title=Pervasive Documentation Library: Pervasive PSQL v11 SP2|url=http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=welcome/libwelcome.html|publisher=Pervasive Software|date=April 2012}} 10. ^1 {{cite web|title=Top-notch Auditing an Impressive Add-on for Pervasive.SQL|url=http://www.devx.com/dbzone/Article/20006|publisher=DevX.com|author=Lax, Joe|date=January 23, 2004}} 11. ^{{cite web|title=LIST OF NOSQL DATABASES|url=http://nosql-database.org/|publisher=NoSQL|accessdate=April 30, 2012}} 12. ^{{cite web|title=Methods for interacting with a Pervasive SQL database|url=https://stackoverflow.com/questions/405640/methods-for-interacting-with-a-pervasive-sql-database|publisher=stackoverflow|author=Brettski|date=January 4, 2009}} 13. ^{{cite book|title=The SQL Guide to Pervasive PSQL|year=2009|publisher=Lulu|isbn=978-0-557-10543-4|pages=443–548|author=van der Lans, Rick F.}} 14. ^{{cite web|title=What file versions does Row Level Locking (RLL) work with in Pervasive.SQL 2000?|url=http://www.pervasivedb.com/kb/Pages/00014776.aspx|publisher=Pervasive Software|date=June 2001}} 15. ^1 {{cite web|title=Pervasive Software Delivers Pervasive PSQL Summit v10.10 Database|url=http://investor.pervasive.com/releasedetail.cfm?releaseid=386715|publisher=Pervasive Software|date=June 11, 2008}} 16. ^{{cite web|title=Unicode support?|url=http://cs.pervasive.com/forums/p/2901/9926.aspx|publisher=Pervasive Community Site|author=Durham, Dale|date=April 23, 2008}} 17. ^{{cite web|title=Pervasive Documentation Library: Pervasive AuditMaster|url=http://docs.pervasive.com/products/database/auditmaster/640/wwhelp/wwhimpl/js/html/wwhelp.htm#href=AM_Library/libwelcome_am.html|publisher=Pervasive Software|date=April 2012}} 18. ^{{cite web|title=Pervasive Documentation Library: Pervasive DataExchange|url=http://docs.pervasive.com/products/database/dataexchange/300/wwhelp/wwhimpl/js/html/wwhelp.htm#href=uguide/intro.02.2.html|publisher=Pervasive Software|date=April 2012}} 19. ^{{cite web|title=Pervasive Documentation Library: Pervasive PSQL v10|url=http://www.pervasivedb.com/support/Documents/Docs2/Active_Connector_ACUCOBOL-GT_Developer_Guide.pdf|publisher=Pervasive Software|date=April 2008}} 20. ^{{cite web|title=Pervasive Software Announces Hypervisor-Friendly PSQl Vx Server 11|url=http://www.serverwatch.com/server-news/pervasive-software-announces-hypervisor-friendly-psql-vx-server-11-.html|publisher=ServerWatch|author=Beal, Vangie|date=February 13, 2012}} 21. ^{{cite web|url=http://www.goldstarsoftware.com/papers/MakingTheMostOfTheClientCacheEngine.pdf|title=Making the Most of the Client Cache Engine |date=March 7, 2016|publisher= Goldstar Software Inc.}} External links
1 : Proprietary database management systems |
随便看 |
|
开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。