Database
Last updated
A DBMS offers capabilities for defining, updating, retrieving, and administering data within a structured collection.[1] In non-professional contexts, any related-data collection like a spreadsheet or card index is frequently called a database.[2] The database concept became feasible due to direct-access storage media like magnetic disks becoming widely available around the mid-1960s.[3]
Quick Facts
- Field
- Computing
Facts from the source article.
Key facts and history
The earliest known technical use of the term "data-base" appears in a 1962 report from the System Development Corporation of California, according to the Oxford English Dictionary.[4] IBM's Information Management System (IMS), a DBMS that debuted in 1966, originated from software created for the Apollo program on the System/360.[5] IMS navigated data using a strict hierarchy, whereas IDMS and Cincom Systems' TOTAL employed a network model.[5] In 1970, Edgar F. Codd introduced the relational model, arguing that applications ought to locate data by content rather than by traversing links.[6][7]
Ledger-style tables, each designated for a distinct entity type, are the building blocks of the relational model.[6] SQL was created and presented by IBM researchers Donald Chamberlin and Raymond Boyce during the 1970s, and it reached the commercial market in 1979.[8] Oracle Version 2, from Larry Ellison's company, reached the market before IBM's product in 1979.[9] Relational systems had taken over all major large-scale data processing work by the early 1990s.[6]
NoSQL databases, which appeared in the late 2000s, are built to scale horizontally and manage less structured data.[10][8]
What the cited sources add
SQL commands fall into categories such as data definition language, data manipulation language, data control language, data query language, and transaction control language.[8] The TOPDB Top Database Index ranks databases by analyzing how often their names are searched on Google, with higher search frequency indicating greater assumed popularity.[11] Wayne Ratliff, who created dBASE, explained that unlike BASIC, C, FORTRAN, and COBOL, dBASE had already handled much of the complex groundwork.[12] Ratliff observed that dBASE performs data manipulation on behalf of the user, allowing the user to focus on their task rather than on file operations and space management.[12]
References
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: "Update Definition & Meaning", Merriam-Webster; "Retrieval Definition & Meaning", Merriam-Webster; "Administration Definition & Meaning", Merriam-Webster (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: Ullman Widom 1997, p. 1 (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: Bachman 1973 (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: "database, n", OED Online, June 2013}} {{subscription required (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: IBM Corporation, "IBM Information Management System (IMS) 13 Transaction and Database Servers delivers high performance and low total cost of ownership", October 2013 (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: "TOPDB Top Database index", pypl.github.io (we also read that source) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: Codd 1970 (original not read by us) en.wikipedia.org
- "What Is Structured Query Language (SQL)?", IBM. facts only, no text reused. ibm.com
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: "Oracle 30th Anniversary Timeline" (original not read by us) en.wikipedia.org
- Wikipedia, "Database" (CC BY-SA 4.0), which cites: Jordan, "NoSQL Latency", ScyllaDB; "SQL vs. NoSQL: Full comparison of features, differences, and more", www.testgorilla.com (original not read by us) en.wikipedia.org
- "TOPDB Top Database index", pypl.github.io. facts only, no text reused. pypl.github.io
- Interview with Wayne Ratliff. The FoxPro History. Retrieved on 12 July 2013.. facts only, no text reused. foxprohistory.org
Each numbered sentence above was checked against the source it cites before publication. Sentences citing Wikipedia adapt text from the English Wikipedia article Database (contributors), used under CC BY-SA 4.0; this entry is available under the same licence. Other sources were used for facts only; no text or images are copied from them.
More in Computing & Digital
Sources
Compiled from Wikipedia and the sources listed below. Text from Wikipedia is available under CC BY-SA 4.0; this entry is adapted from it.
- Wikipedia: Database (CC BY-SA 4.0).
Spotted an error? Know more?
Reader corrections go straight into our review queue. Suggest an edit · How this site is sourced
