InterBase
 | This articlecontains content that is written likean advertisement.(March 2012) |
| Developer(s) | Embarcadero Technologies |
|---|---|
| Stable release | InterBase 2020
/ December 2019 |
| Operating system | Cross-platform |
| Type | Database management system |
| License | Proprietary |
| Website | www |
InterBaseis arelational database management system(RDBMS) currently developed and marketed byEmbarcadero Technologies.InterBase runs on theMicrosoft Windows,macOS,Linux,andSolarisoperating systemsas well asiOSandAndroid.
Technology
[edit]InterBase is aSQL-92-compliantrelational databaseand supports standard interfaces such asJDBC,ODBC,andADO.NET.
History
[edit]Multiversion concurrency control before InterBase
[edit]Multiversion concurrency controlis described in some detail in sections 4.3 and 5.5 of the 1981 paper "Concurrency Control in Distributed Database Systems"[1]byPhilip Bernsteinand 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 describesMVCCand claims it as an original work.
Early years
[edit] | This sectionneeds additional citations forverification.(June 2014) |
Jim Starkeywas working atDECon theirDATATRIEVE4th generation language4GLproduct when he came up with an idea for a system to manage concurrent changes by many users. The idea simplified the existing problems oflockingwhich were proving to be a serious problem for the newrelational databasesystems being developed at the time.
Although InterBase's implementation is much more similar to the system described byReedin 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 byPrimethat supported page level snapshots. The intention of the feature was to give a reader aconsistentview of the database without blocking writers. The idea intrigued me as a very useful characteristic of a database system.
Open source
[edit]In early 2000, Borland announced that InterBase would be released underopen-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 theMozilla Public Licensein mid-2000.
With the InterBase division at Borland under new management, the company released aproprietaryversion 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 sourceforkof the InterBase 6 code, however, remains in active development.
In 2001, abackdoorwas discovered in the software that had been present in all versions since 1994 and then resolved. [4][5][6]
CodeGear
[edit]On May 7, 2008, Borland andEmbarcadero Technologiesannounced 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
[edit]See also
[edit]References
[edit]- ^Bernstein, Philip A.; Goodman, Nathan (1981)."Concurrency Control in Distributed Database Systems".ACM Computing Surveys.13(2): 185–221.doi:10.1145/356842.356846.S2CID30874.RetrievedSeptember 21,2005.
- ^Reed, D.P. (1978).Naming and Synchronization in a Decentralized Computer System.MIT dissertation(Thesis).hdl:1721.1/16279.RetrievedNovember 12,2022.
- ^Starkey, Jim."Weblog comment".Multiversion Concurrency Control Before InterBase.Archived fromthe originalon October 23, 2007.RetrievedSeptember 21,2005.
- ^"CERT Advisory CA-2001-01 Interbase Server Contains Compiled-in Back Door Account".11 January 2000. Archived fromthe originalon 18 November 2001.
- ^"Backdoor account in Interbase database server allows remote attackers to overwrite arbitrary files using stored procedures".12 January 2000.Archivedfrom the original on 7 December 2012.
- ^"Borland/Inprise Interbase SQL database server contains backdoor superuser account with known password".11 January 2001.Archivedfrom the original on 17 December 2001.
- ^Intersimone, David (2008-05-07)."Community Letter: Embarcadero Technologies agrees to acquire CodeGear from Borland".Archived fromthe originalon 2012-04-15.Retrieved2008-05-08.
- ^Bravo, Thoma (2008-07-01)."Embarcadero Technologies Closes Acquisition of CodeGear".Retrieved2008-07-03.
