Pervasive Software Psql

Posted on by admin

Pervasive PSQL
Developer(s)Actian Corporation
Stable release
Operating systemCross-platform
Available inEnglish, Japanese
TypeDBMS, RDBMS, NotOnlySQL
LicenseShareware
Websitewww.pervasivedb.com
www.pervasive.com
www.actian.com
  1. Pervasive Software Psql Data Dictionary Files
  2. Pervasive Software Sql
  3. Pervasive Software Psql
  4. Pervasive Psql V12
  5. Pervasive Software Psql V9 1 Client
  6. Pervasive Software Psql V12

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 software inc. Psql v12 license agreement important: do not install the enclosed or downloaded software until you have read this psql license agreement ('agreement'). By installing the software, or authorizing any other person to do so, you, and such other person, if applicable, accept the terms and conditions of this agreement.

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]

  • 2DBMS architecture
  • 4Interfaces
  • 7Editions and licensing

Uses and customers[edit]

Because 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]

Pervasive Software Psql Data Dictionary Files

Historically, Pervasive PSQL served as a DBMS for small and medium enterprises.[8]

Pervasive Software Sql

DBMS architecture[edit]

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 Engine[edit]

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. 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 Engine[edit]

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.[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 features[edit]

Pervasive PSQL provides the following additional features:

  • Multi-core processor aware[9]
  • IPv4 and IPv6 support[9]
  • Row-level locking[14]
  • Record and page compression[9]
  • Over-the-wire encryption and data encryption[9]
  • Cluster environments compatibility[9]
  • I18N support,[15] code page (including UTF-8) translation between data files and SQL clients,[9]Unicode support in Btrieve API,[16] Japanese localization[15]
  • Data backup agents or enablers with Pervasive Backup Agent and Pervasive PSQL VSS Writer[9]
  • Data auditing with Pervasive AuditMaster[17]
  • Data replication with Pervasive DataExchange[18]

Interfaces[edit]

Pervasive PSQL interfaces fall into two categories: management interfaces and data manipulation interfaces.

Management interfaces[edit]

Pervasive 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 interfaces[edit]

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

  • Btrieve, Java Class Library (JCL), COBOL, and ActiveX provides direct access to the MicroKernel Database Engine (MKDE).
  • ADO.NET; ODBC v3.51 and JDBC 2 for Core, Level 1, and Level 2; and OLE DB provide access to the SQL Relational Database Engine (SRDE).
  • Pervasive Direct Access Components (PDAC) are a set of Visual Component Library (VCL) components that enable direct access to both MKDE and SRDE for Embarcadero Delphi and C++ Builder environments.

Tools[edit]

Pervasive 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:

  • License Administrator utility handles license management activities.
  • Notification Viewer utility displays licensing-related messages logged by the PSQL engine.
  • Monitor utility checks and displays activities and attributes of both engines, including resource usage, session information, and communication statistics.
  • Pervasive System Analyzer utility tests the connections between the engines and within the network and displays information about system components.
  • Maintenance utility enables users to create and edit schema-less files.
  • Rebuild utility enables users to convert file formats and rebuild files in its MKDE file format.
  • DDF (data definition file) Builder utility enables SQL users to create and modify table schemas for data stored in the MKDE, thus providing relational access to the data.
  • Query Plan Viewer enables SQL users to analyze query plans for optimization.
  • Function Executor assists developers with development, testing, and debugging by simulating direct API operations into MKDE and providing a view into the schema-less data.

Versions[edit]

See Btrieve, beginning with Pervasive.SQL 7.

Editions and licensing[edit]

Editions[edit]

There are four editions of PSQL:[9] Pervasive PSQL Client, Pervasive PSQL Workgroup, Pervasive PSQL Server, and Pervasive PSQL Vx Server.

Pervasive Software Psql

  • Pervasive PSQL Client is designed for use with Pervasive PSQL Server and Pervasive PSQL Vx Server in a client-server network.
  • Pervasive PSQL Workgroup edition is intended for single-user or small workgroup, peer-to-peer, installations.[9]
  • Pervasive PSQL Server edition is intended for configurations that have at minimum ten concurrent connections and it is scalable up to thousands of concurrent network users in client-server network and web-based applications on the enterprise level.[9]
  • PSQL Vx Server runs under hypervisors in a VM environment. It is designed for customers “who need support for highly virtualized environments enabling live migration, fault tolerance, high availability and cloud computing.”[20]

Licensing[edit]

Pervasive Software uses two different licensing models, user-count licensing and capacity-based licensing.[9]

  • In user-count licensing, each product key specifies a licensed user. At any given moment, that many users can be connected to the engine.
  • Capacity-based licensing is based on the amount of processing performed by the database engine. It measures data in use and sessions in use. This license model is designed to facilitate Cloud computing and highly virtualized environments.

Both PSQL Server and PSQL Workgroup use a user-count licensing model, while PSQL Vx Server uses capacity-based licensing.

Limitations[edit]

  • Pervasive PSQL lacks some of the data warehousing, data mining, and reporting services built into database engines such as MySQL and Microsoft SQL Server.[10]
  • Pervasive PSQL lacks Unicode support in the RDBMS layer.
  • Pervasive PSQL lacks the ability to perform distributed transactions.
  • lacks support for database caching unless the application has specifically been designed to take advantage of the Client Caching Engine(very few applications take advantage of this feature), the inbuilt feature of the engine and only supported caching option. Because the engine does not natively support database contention negotiation but relies on the front-end to manage contention issues, it is infrequently implemented. This makes the majority of applications developed with Pervasive PSQL unsuitable on any system where network or host server performance could cause a performance bottleneck.[21]

See also[edit]

  • Connolly, P.J., “Pervasive Living Up to Its Name at 25”, SD Times, 3/15/2007, http://www.sdtimes.com/content/article.aspx?ArticleID=30319
  • DatabaseJournal.com Staff, “Pervasive Expands Linux Database Offering to Support Linux Desktop and Embedded Data Needs” Database Journal, 6/17/2003, http://www.databasejournal.com/news/article.php/2223111
  • DatabaseJournal.com Staff, “ Pervasive.SQL Database Updated to Enhance Security of Mission-critical Data” Database Journal, 7/22/2003, http://www.databasejournal.com/news/article.php/2238931
  • Domingo, Michael, “Pervasive PSQL Certified for Windows 2008, Adds Linux Support”, Application Development Trends, 3/14/2008, http://adtmag.com/articles/2008/03/14/pervasive-psql-certified-for-windows-2008-adds-linux-support.aspx
  • Information Management Editorial Staff, “40 Vendors We’re Watching in 2011”, Information Management, 3/1/2011, http://www.information-management.com/issues/21_2/40-vendors-were-watching-in-2011-10019878-1.html?pg=2
  • Kilburn, Will, “Pervasive joins Magic; unveils Linux DBMS”, Application Development Trends, 6/11/2003, http://adtmag.com/articles/2003/06/11/pervasive-joins-magic-unveils-linux-dbms.aspx
  • Kilburn, Will, “Pervasive upgrades database security”, Application Development Trends, 7/23/2003, http://adtmag.com/articles/2003/07/23/pervasive-upgrades-database-security.aspx
  • Kyle, Jim, Btrieve Complete: A Guide for Developers and System Administrators, Addison-Wesley, 1995
  • Marsan, Carolyn Duffy, 'Database Firm Reports Rising Demand for IPv6', NETWORKWORLD, May 17, 2010, https://web.archive.org/web/20100523052202/http://www.networkworld.com/news/2010/051710-ipv6-pervasive-software.html
  • Monash Research, “Pervasive Summit PSQL v10”, DBMS2, 9/24/2007, http://adtmag.com/articles/2003/07/09/pervasive-gains-advanced-database-search-engine.aspx
  • Seeley, Rich, “Pervasive gains advanced database search engine”, Application Development Trends, 7/9/2003, http://adtmag.com/articles/2003/07/09/pervasive-gains-advanced-database-search-engine.aspx
  • Seiden, Jeff, “Quotes from Partners Supporting Novell Linux Small Business Suite 9”, Novell, March 20, 2005, http://www.novell.com/news/press/2005/3/pr05024_quotes.html
  • Trocino, Richard B., The Illustrated Guide to NetWare Btrieve 6.x, Golden West Products International, 1994
  • White, Elizabeth, Armstrong, Bruce, and Remde, Kevin, “Pervasive Software Announces Pervasive PSQL Vx Server 11 for Virtualized Environments”, .NET Developer’s Journal, 2/13/2012, http://dotnet.sys-con.com/node/2163895
  • Whiting, Rick, '25 Infrastructure Software Vendors You Need to Know', CRN, July 26, 2011, http://www.crn.com/slide-shows/applications-os/231002581/25-infrastructure-software-vendors-you-need-to-know.htm;jsessionid=RjEiTtd9S-SaZB9p8vH9qA**.ecappj01?pgno=18

References[edit]

  1. ^ abWiejers, Ben (October 2001) [December 2000]. 'Transactions, Locking and DataFlex'. Data Access Worldwide.
  2. ^Stanley, Nigel; Kaufman, Marcia (2007). 'Delivering Embedded Database Solutions for Small and Medium-sized Businesses'(PDF). Hurwitz and Associates.
  3. ^ abBloor, Robin; Jozwiak, Rebecca (December 2011). 'Moving to the Cloud with Pervasive PSQL'(PDF). The Bloor Group.
  4. ^ abvan der Lans, Rick F. (2009). The SQL Guide to Pervasive PSQL. Lulu. pp. 44–45. ISBN978-0-557-10543-4.
  5. ^'Actian Corporation and Pervasive Software Unite to Take Action on Big Data'.
  6. ^'Manufacturing ERP Software–Sage PFW ERP'. Sagepfw.com. Retrieved 2012-05-12.
  7. ^ abVaughan, Jack (October 16, 2002). 'Pervasive on replication trail'. Application Development Trends.
  8. ^'Software provides growth solution for organization databases'. ThomasNet News. September 26, 2007.
  9. ^ abcdefghijklmnopqr'Pervasive Documentation Library: Pervasive PSQL v11 SP2'. Pervasive Software. April 2012.
  10. ^ abLax, Joe (January 23, 2004). 'Top-notch Auditing an Impressive Add-on for Pervasive.SQL'. DevX.com.
  11. ^'LIST OF NOSQL DATABASES'. NoSQL. Retrieved April 30, 2012.
  12. ^Brettski (January 4, 2009). 'Methods for interacting with a Pervasive SQL database'. stackoverflow.
  13. ^van der Lans, Rick F. (2009). The SQL Guide to Pervasive PSQL. Lulu. pp. 443–548. ISBN978-0-557-10543-4.
  14. ^'What file versions does Row Level Locking (RLL) work with in Pervasive.SQL 2000?'. Pervasive Software. June 2001.
  15. ^ ab'Pervasive Software Delivers Pervasive PSQL Summit v10.10 Database'. Pervasive Software. June 11, 2008.
  16. ^Durham, Dale (April 23, 2008). 'Unicode support?'. Pervasive Community Site.
  17. ^'Pervasive Documentation Library: Pervasive AuditMaster'. Pervasive Software. April 2012.
  18. ^'Pervasive Documentation Library: Pervasive DataExchange'. Pervasive Software. April 2012.
  19. ^'Pervasive Documentation Library: Pervasive PSQL v10'(PDF). Pervasive Software. April 2008.
  20. ^Beal, Vangie (February 13, 2012). 'Pervasive Software Announces Hypervisor-Friendly PSQl Vx Server 11'. ServerWatch.
  21. ^'Making the Most of the Client Cache Engine'(PDF). Goldstar Software Inc. March 7, 2016.

External links[edit]

  • Official website - product page
  • Official website - company site
  • Official website - parent company site
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Pervasive_PSQL&oldid=887201985'
Pervasive Software Inc.
Subsidiary
IndustrySoftware, RDBMS, Data Integration
Founded1994
HeadquartersAustin, Texas
ProductsPervasive Data Integrator
Pervasive DataRush
Pervasive Data Profiler
Pervasive PSQL
Revenue$47.2 million USD (Fiscal 2010)[1]
ParentActian
Websitewww.pervasive.com
www.actian.com

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 PSQLrelational 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.[2]

Pervasive Software was headquartered in Austin, Texas, and sold its products with partners in other countries.The company is involved in cloud computing through DataSolutions and its DataCloud offering[3] along with its long-standing relationship with salesforce.com.[4] It was acquired by Actian Corp.[5] in April 2013.[6]

Psql

History[edit]

Pervasive started in 1982 as SoftCraft developing the database management system technology Btrieve. Acquired by Novell in 1987,[7]in January 1994 Pervasive spun out as Btrieve Technologies. The company name was changed to Pervasive Software in June 1996. Their initial public offering in 1997 raised $18.6 million.[8]Ron R. Harris was chief executive and founder Nancy R. Woodward was chairman of the board of directors (the other co-founder was her husband Douglas Woodward).[9] Its shares were listed on the Nasdaq exchange under symbol PVSW.[8]Its database product was announced in 1999 as Pervasive.SQL version 7,[10] and later renamed PSQL. PSQL implemented the atomicity, consistency, isolation, durability properties known as ACID using a relational database model.

In August 2003, Pervasive agreed to acquire Data Junction Corporation, makers of data and application integration tools renamed Pervasive Data Integrator, for about $51.7 million in cash and stock shares.[11] Data Junction, founded in 1984, was a privately held company also headquartered in Austin. The merger closed in December 2003.[12]

Pervasive also acquired business-to-business data interchange service Channelinx in August 2009.[13] Based in Greenville, South Carolina, it continued operating under the name Pervasive Business Xchange.[14][15]In February 2011, Pervasive announced version 5 of DataRush, which included integration with the MapReduce programming model of Apache Hadoop.[16][17]

In 2013, Pervasive Software was acquired by Actian Corporation for $161.9 million.Actian had initially made offers in August 2012 starting at $154 million 30% higher than its shares traded at the time,[18] and raised its price in November. Pervasive agreed to the deal in January 2013,[19] and it closed in April.[20][21]

Products[edit]

DataRush is a dataflowparallel programming framework in the Java programming language.[22][23][24]DataRush was announced in December 2006[25] and shipped in 2009.[26]

References[edit]

Pervasive Psql V12

  1. ^'Pervasive Software Reports Results for its Fourth Quarter of Fiscal Year 2010'. Retrieved 2010-07-27.
  2. ^'Pervasive Industry Solutions'. Retrieved 2009-08-21.
  3. ^'Cloud Integration'. Retrieved 2009-08-21.
  4. ^'Salesforce Integration'. Retrieved 2009-08-21.
  5. ^'Actian Corp'.
  6. ^Christopher Calnan (April 12, 2013). 'Software maker Pervasive completes merger with Actian'. Austin Business Journal. Retrieved January 16, 2014.
  7. ^Roger Bourke White (2012). Surfing the High Tech Wave: A History of Novell 1980–1990. AuthorHouse. pp. 123–124. ISBN9781452023045. Retrieved November 24, 2013.
  8. ^ abPervasive Software (September 26, 1997). 'Prospectus'. Form S-1/A. US Securities and Exchange Commission. Retrieved November 21, 2013.
  9. ^P J Connolly (March 15, 2007). 'Pervasive Living Up to Its Name at 25'. Software Development Times. Retrieved November 21, 2013.
  10. ^Tim Fielden (January 18, 1999). 'Pervasive.SQL simplifies development'. Info World. Archived from the original on August 30, 1999. Retrieved November 23, 2013.Cite uses deprecated parameter |deadurl= (help)
  11. ^Paul Krill (August 11, 2003). 'Pervasive buying Data Junction: Database, integration vendors combine'. Info World. Retrieved November 23, 2013.
  12. ^'Pervasive completes acquisition of Data Junction; Announces new organizational structure optimized for growth'. Press release. December 8, 2003. Archived from the original on February 2, 2004. Retrieved November 21, 2013.Cite uses deprecated parameter |deadurl= (help)
  13. ^Pervasive Software (August 3, 2009). 'Pervasive Software Completes Acquisition of ChanneLinx Assets'. Press release. Archived from the original on August 31, 2009. Retrieved November 21, 2013.
  14. ^'About Us'. ChannelLinx web site. Archived from the original on August 16, 2009. Retrieved November 21, 2013.Cite uses deprecated parameter |deadurl= (help)
  15. ^'Pervasive Business Xchange'. Commercial web site. Archived from the original on April 11, 2010. Retrieved November 21, 2013.Cite uses deprecated parameter |deadurl= (help)
  16. ^Paul Krill (February 1, 2011). 'Pervasive's parallel development API paired with Hadoop MapReduce'. Info World. Retrieved November 24, 2013.
  17. ^Jim Falgout (March 1, 2011). 'Dataflow Programming: A Scalablemw-data:TemplateStyles:r886058088'>
  18. ^Sarah Drake (September 13, 2012). 'Pervasive Software to solicit potential bids'. Austin Business Journal. Retrieved December 9, 2013.
  19. ^Reuters (January 28, 2013). 'Pervasive Software to be acquired by Actian for $161.9 million'. Chicago Tribune. Retrieved November 21, 2013.
  20. ^'Actian Corporation and Pervasive Software Unite to Take Action on Big Data'. Press release. April 11, 2013. Retrieved November 23, 2013.
  21. ^Christopher Calnan (April 12, 2013). 'Software maker Pervasive completes merger with Actian'. Austin Business Journal. Retrieved November 23, 2013.
  22. ^'An Introduction to the Pervasive DataRush Framework'. Retrieved 2009-08-21.
  23. ^James Taylor (June 4, 2009). 'First Look – Pervasive DataRush'. James Taylor on Everything Decision Management. Retrieved November 22, 2013.
  24. ^Wayne Eckerson (January 4, 2011). 'The Next Wave in Big Data Analytics: Exploiting Multi-core Chips and SMP Machines'. Bye Network blog. Retrieved November 23, 2013.
  25. ^'Welcome to Pervasive DataRush'. Original Pervasive DataRush web site. Archived from the original on December 8, 2006. Retrieved November 22, 2013.Cite uses deprecated parameter |deadurl= (help)
  26. ^Dan Woods (August 25, 2009). 'Waking Up Multi-Core Processors'. Forbes.com. Archived from the original on January 23, 2013. Retrieved November 22, 2013.Cite uses deprecated parameter |deadurl= (help)

Pervasive Software Psql V9 1 Client

External links[edit]

  • Official website - company site
  • Official website - parent company site

Pervasive Software Psql V12

Retrieved from 'https://en.wikipedia.org/w/index.php?title=Pervasive_Software&oldid=863789418'