2. Data model
In a database, data is described using a data model, which provides a structure for representing the data, and a language for manipulating the data thus described. The aim of a data model is to represent real-world data as simply and accurately as possible. The main difference between data models is their suitability for specific applications.
2.1 Relational model
The relational model is by far the most widely used. Created in the early 1970s for business applications, it owes its success to its simplicity and the declarative aspect of the associated manipulation language.
In the relational model, data is represented in the form of relationships (tables), made up of attributes (columns) and tuples (rows). Each tuple uniquely describes...
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Data model
Data storage
Bibliography
References
Standardization
- Technologies de l'information. Langage de base de données SQL - NF ISO/CEI 9075 - 9-94
Software
(non-exhaustive list)
UDB, DB2, IBM http://www.ibm.com/db2
SQL Server 2005, Microsoft http://www.microsoft.com/france/sql/sql2005/
Organizations
Transaction Processing Performance Council (TPC) http://www.tpc.org/
World Wide Web Consortium (W3C) http://www.w3.org/
The Ultimate Scientific and Technical Reference
