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 .
8-577: InterBase is a SQL-92 -compliant relational database and supports standard interfaces such as JDBC , ODBC , and ADO.NET . 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" by Philip Bernstein and Nathan Goodman while employed by the Computer Corporation of America. Bernstein and Goodman's paper cites
16-433: A 1978 dissertation by D.P. Reed, which describes MVCC and claims it as an original work. 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
24-499: 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. On May 7, 2008, Borland and Embarcadero Technologies announced that Embarcadero had "signed a definitive asset purchase agreement to purchase CodeGear." The acquisition, for approximately $ 24.5 million, closed on 30 June 2008. SQL-92 SQL-92
32-523: 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
40-479: 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. According to his blog, Starkey says: The inspiration for multi-generational concurrency control
48-414: 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. In early 2000, Borland announced that InterBase would be released under open-source , and began negotiations to spin off a separate company to manage
56-590: Was only by a factor of 1.5–2. Many of the new features had already been implemented by vendors before the new standard was adopted. However, most of the new features were added to the "intermediate" and "full" tiers of the specification, meaning that conformance with SQL-92 entry level was scarcely any more demanding than conformance with SQL-89 . Later revisions of the standard include SQL:1999 (SQL3), SQL:2003 , SQL:2008 , SQL:2011 , SQL:2016 and SQL:2023 . Significant new features include: Two significant extensions were published after standard (but before
64-502: Was the third revision of the SQL database query language . Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92. The standard specification itself grew about five times compared to SQL-89. Much of it was due to more precise specifications of existing features; the increase due to new features
#905094