Jump to content

Database server

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 212.219.3.100 (talk) at 08:36, 11 September 2019. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

{{more citations needed|date=, and Microsoft SQL Server. Examples of free software database applications include PostgreSQL; and under the GNU General Public Licence include Ingres and MySQL. Every server uses its own query logic and structure. The SQL (Structured Query Language) query language is more or less the same on all relational database applications.

For clarification, a database server is simply a server that maintains services related to clients via database applications.

DB-Engines lists over 300 DBMSs in its ranking.[1]

History

The foundations for modeling large sets of data were first introduced by Charles Bachman in 1969.[2] Bachman introduced Data Structure Diagrams (DSDs) as a means to graphically represent data. DSDs provided a means to represent the relationships between different data entities. In 1970, Codd introduced the concept that users of a database should be ignorant of the "inner workings" of the database.[2] Codd proposed the "relational view" of data which later evolved into the Relational Model which most databases use today. In 1971, the Database Task Report Group of CODASYL (the driving force behind the development of the programming language COBOL) first proposed a "data description language for describing a database, a data description language for describing that part of the data base known to a program, and a data manipulation language." [2] Most of the research and development of databases focused on the relational model during the 1970s.

In 1975 Bachman demonstrated how the relational model and the data structure set were similar and "congruent" ways of structuring data while working for the Honeywell.[2] The Entity-relationship model was first proposed in its current form by Peter Chen in 1976 while he was conducting research at MIT.[3] This model became the most frequently used model to describe relational databases. Chen was able to propose a model that was superior to the navigational model and was more applicable to the "real world" than the relational model proposed by Codd.[2]

References

  1. ^ "DB-Engines Ranking". DB-Engines.com. 2018-01-23. Retrieved 2018-01-23.
  2. ^ a b c d e "Databases - History & Early Development". Archived from the original on 2012-04-20. Retrieved 2016-07-08. {{cite web}}: Unknown parameter |dead-url= ignored (|url-status= suggested) (help)
  3. ^ The Entity-Relationship Model: Toward a Unified View of Data (1976)

See also

Retrieved from "https://en.wikipedia.org/w/index.php?title=Database_server&oldid=915111419"