A number of database related products and projects go under the name of PrimeBase. Classic PrimeBase is a SQL database server developed and maintained by PrimeBase Systems GmbH of Hamburg, Germany. The open source projects "PrimeBase XT Storage Engine for MySQL" (PBXT) and "PrimeBase Media Streaming" engine (PBMS) are supported and funded by PrimeBase Technologies GmbH.
The bulk of the PrimeBase SQL Data Server (PBDS) users are in the print and pre-press industry. This is due to historical reasons and the fact that PBDS features such as efficient BLOB handling and full-text search focus on the requirements of applications in this area. PBDS began life as P.INK SQL in 1990. It was originally developed for the Macintosh by the company P.INK Software Engineering GmbH and Co, in Hamburg. At the time, it was the only SQL server that ran on the Macintosh. In 1992 P.INK Software began porting the database to Unix. In particular, the SunSPARC workstation and the IBMRS/6000.
The database was used as the central component of the P.INK Press Publishing System, which was installed at a number of major newspapers in Germany and worldwide. Following a number of management errors that saw the company grow too fast P.INK Software declared bankruptcy in 1995 when shareholders were unable to agree on the terms for refinancing the company.
A number of former employees managed to secure the rights to the P.INK SQL database and in 1996 they founded SNAP Innovation GmbH. Support and development of the database was continued under the name of PrimeBase. By the year 2001 SNAP had added related products to the PrimeBase SQL Data Server including the PrimeBase Replication Server and the PrimeBase Application Server. These products are now all owned and maintained by PrimeBase Systems GmbH.
In 2004, SNAP began development of PBXT, the transactional storage engine for MySQL. Drawing on experience gained in the development of the PrimeBase DBMS, SNAP also launched the "Scalable BLOB Streaming Infrastructure for MySQL" project, under which PBMS and the S3 Daemon have been developed. More information is available on these products from the associated web-sites (see below). Both of these projects have now been put under the umbrella of the open source company PrimeBase Technologies.
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, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language 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.
A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970. A software system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems have an option of using the SQL for querying and maintaining the database.
Sun Microsystems, Inc. was an American technology company that sold computers, computer components, software, and information technology services and created the Java programming language, the Solaris operating system, ZFS, the Network File System (NFS), VirtualBox, and SPARC microprocessors. Sun contributed significantly to the evolution of several key computing technologies, among them Unix, RISC processors, thin client computing, and virtualized computing. Sun was founded on February 24, 1982. At its height, the Sun headquarters were in Santa Clara, California, on the former west campus of the Agnews Developmental Center.
Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.
InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture. InterBase runs on the Microsoft Windows, macOS, Linux, Solaris operating systems as well as iOS and Android.
FileMaker is a cross-platform relational database application from Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. It is available in desktop, server, iOS and web-delivery configurations.
Firebird is an open-source SQL relational database management system that "runs on Linux, Microsoft Windows, macOS and several 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.
4D is a relational database management system and IDE developed by Laurent Ribardière. 4D was created in 1984 and had a slightly delayed public release for Macintosh in 1987 with its own Programming Language
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.
Data Access Language, or simply DAL, was a SQL-like language and application programming interface released by Apple Computer in 1990 to provide unified client/server access to database management systems. It was known for poor performance and high costs, something Apple did little to address over its short lifetime, before it was sold off in 1994. DAL is used as the native SQL dialect of the PrimeBase SQL server, as well as the now-defunct Butler SQL.
Apache Derby is a relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. It has a 3.5 MB disk-space footprint.
Jim Starkey is a database architect responsible for developing InterBase, the first relational database to support multi-versioning, the blob column type, type event alerts, arrays and triggers. Starkey is the founder of several companies, including the web application development and database tool company Netfrastructure and NuoDB.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
PostBooks is a proprietary accounting and enterprise resource planning business system geared toward small to medium-sized businesses. It used to be released under an open source CPAL license on GitHub, but was made non-free in June 2019. Postbooks was based on the commercially licensed xTuple ERP system created by xTuple, a private software company based in Norfolk, Virginia (VA), United States.
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 actually a broad technology category that includes
Drizzle is a discontinued free software/open-source relational database management system (DBMS) that was forked from the now-defunct 6.0 development branch of the MySQL DBMS.
Michael Ralph Stonebraker is a computer scientist specializing in database research. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational database systems. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. He is also an editor for the book Readings in Database Systems.
Informix Corporation was a software company located in Menlo Park, California. It was a developer of relational database software for computers using the Unix, Microsoft Windows, and Apple Macintosh operating systems.
The following outline is provided as an overview of and topical guide to MySQL:
This page is based on this Wikipedia article Text is available under the CC BY-SA 4.0 license; additional terms may apply. Images, videos and audio are available under their respective licenses.
