InterBase

Last updated
InterBase
Developer(s) Embarcadero Technologies
Stable release
InterBase 2020 / December 2019;4 years ago (2019-12)
Operating system Cross-platform
Type Database management system
License Proprietary
Website www.embarcadero.com/products/interbase

InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase runs on the Microsoft Windows, macOS, Linux, and Solaris operating systems as well as iOS and Android.

Contents

Technology

InterBase is a SQL-92-compliant relational database and supports standard interfaces such as JDBC, ODBC, and ADO.NET.

History

Multiversion concurrency control before InterBase

Multiversion concurrency control is described in some detail in sections 4.3 and 5.5 of the 1981 paper "Concurrency Control in Distributed Database Systems" [1] by Philip Bernstein and Nathan Goodman while employed by the Computer Corporation of America. Bernstein and Goodman's paper cites a 1978 dissertation [2] by D.P. Reed which describes MVCC and claims it as an original work.

Early years

Jim Starkey was working at DEC on their DATATRIEVE 4th generation language 4GL product when he came up with an idea for a system to manage concurrent changes by many users. The idea simplified the existing problems of locking which were proving to be a serious problem for the new relational database systems being developed at the time.

Although InterBase's implementation is much more similar to the system described by Reed in his MIT dissertation than any other database that existed at the time and Starkey knew Bernstein from his previous position at the Computer Corporation of America and later at DEC, Starkey claims that he arrived at the idea of multiversion concurrency control independently. [3] According to his blog, Starkey says:

The inspiration for multi-generational concurrency control was a database system done by Prime that supported page level snapshots. The intention of the feature was to give a reader a consistent view of the database without blocking writers. The idea intrigued me as a very useful characteristic of a database system.

Open source

In early 2000, Borland announced that InterBase would be released under open-source, and began negotiations to spin off a separate company to manage the product. The source code for InterBase version 6 was released under a variant of the Mozilla Public License in mid-2000.

With the InterBase division at Borland under new management, the company released a proprietary version of InterBase version 6 and then 6.5. Borland released several updates to the open source code before announcing that it would no longer actively develop the open source project. Firebird, an open source fork of the InterBase 6 code, however, remains in active development.

In 2001, a backdoor was discovered in the software that had been present in all versions since 1994 and then resolved. [4] [5] [6]

CodeGear

On May 7, 2008, Borland and Embarcadero Technologies announced that Embarcadero had "signed a definitive asset purchase agreement to purchase CodeGear." [7] The acquisition, for approximately $24.5 million, closed on 30 June 2008. [8]

Recent releases

See also

Related Research Articles

<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.

Mimer SQL is a proprietary SQL-based relational database management system produced by the Swedish company Mimer Information Technology AB, formerly known as Upright Database Technology AB. It was originally developed as a research project at the Uppsala University, Uppsala, Sweden in the 1970s before being developed into a commercial product.

Multiversion concurrency control, is a non-locking concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.

C++Builder is a rapid application development (RAD) environment for developing software in the C++ programming language. Originally developed by Borland, as of 2009 it is owned by Embarcadero Technologies, a subsidiary of Idera. C++Builder can compile apps for Windows, iOS, macOS, and Android. It includes tools that allow drag-and-drop visual development, making programming easier by incorporating a WYSIWYG graphical user interface builder.

<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.

Oracle Rdb is a relational database management system for the OpenVMS operating system. It was originally released by Digital Equipment Corporation (DEC) in 1984 as VAX Rdb/VMS.

In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations are performed. They are crucial for recovering from database server crashes; by rolling back any transaction which was active at the time of the crash, the database is restored to a consistent state.

<span class="mw-page-title-main">HSQLDB</span> Java-based database engine

HSQLDB is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92, SQL:2008, SQL:2011, and SQL:2016 standards. It offers a fast, small database engine which offers both in-memory and disk-based tables. Both embedded and server modes are available.

MaxDB is an ANSI SQL-92 compliant relational database management system (RDBMS) from SAP AG, which was also delivered by MySQL AB from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite, and other applications that require enterprise-level database functionality.

Borland Database Engine (BDE) is the Windows-based core database engine and connectivity software behind Borland Delphi, C++Builder, IntraBuilder, Paradox for Windows, and Visual dBASE for Windows.

<span class="mw-page-title-main">H2 (database)</span>

H2 is a relational database management system written in Java. It can be embedded in Java applications or run in client-server mode.

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.

In databases, and transaction processing, snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database, and the transaction itself will successfully commit only if no updates it has made conflict with any concurrent updates made since that snapshot.

CodeGear is a wholly owned division of Embarcadero Technologies. CodeGear develops software development tools such as the Delphi Integrated development environment, the programming language Delphi, and the database server InterBase. Originally a division of Borland Software Corporation, it was launched on 14 November 2006.

Embarcadero Technologies, Inc. is an American computer software company that develops, manufactures, licenses and supports products and services related to software through several product divisions. It was founded in 1993, went public in 2000 and private in 2007, and became a division of Idera, Inc. in 2015.

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:

REAL Server is a relational database management system (RDBMS) built on top of the SQLite database engine.

This page details the history of the programming language and software product Delphi.

References

  1. Bernstein, Philip A.; Goodman, Nathan (1981). "Concurrency Control in Distributed Database Systems". ACM Computing Surveys. 13 (2): 185–221. doi: 10.1145/356842.356846 . S2CID   30874 . Retrieved September 21, 2005.
  2. Reed, D.P. (1978). Naming and Synchronization in a Decentralized Computer System. MIT dissertation (Thesis). hdl:1721.1/16279 . Retrieved November 12, 2022.
  3. Starkey, Jim. "Weblog comment". Multiversion Concurrency Control Before InterBase. Archived from the original on October 23, 2007. Retrieved September 21, 2005.
  4. "CERT Advisory CA-2001-01 Interbase Server Contains Compiled-in Back Door Account". 11 January 2000. Archived from the original on 18 November 2001.
  5. "Backdoor account in Interbase database server allows remote attackers to overwrite arbitrary files using stored procedures". 12 January 2000. Archived from the original on 7 December 2012.
  6. "Borland/Inprise Interbase SQL database server contains backdoor superuser account with known password". 11 January 2001. Archived from the original on 17 December 2001.
  7. Intersimone, David (2008-05-07). "Community Letter: Embarcadero Technologies agrees to acquire CodeGear from Borland". Archived from the original on 2012-04-15. Retrieved 2008-05-08.
  8. Bravo, Thoma (2008-07-01). "Embarcadero Technologies Closes Acquisition of CodeGear" . Retrieved 2008-07-03.