Article | REF: H3860 V1

Relational databases

Authors: Geneviève PUJOLLE, Franck RAVAT, Olivier TESTE

Publication date: August 10, 2009, Review date: December 19, 2015 | Lire en français

You do not have access to this resource.
Click here to request your free trial access!

Already subscribed? Log in!

Automatically translated using artificial intelligence technology (Note that only the original version is binding) > find out more.

    A  |  A

    1. Relational model

    The relational data model emerged in the early 1970s as a simple, rigorous and powerful mathematical formalism for describing and manipulating data. Ten years later, the first database management software (DBMS) made it possible to build large databases and access them easily.

    This model uses two-dimensional tables to store data. Processing rules (normal forms) guarantee data consistency, avoiding anomalies during updates.

    The data in a relational database is manipulated using declarative languages (SQL: Structured Query Language or QBE: Query By Example ). The ease of use of these languages, as opposed to the complexity of programming languages, has enabled users to access data much more simply.

    Relational databases have gradually supplanted other types of database (inverted files, hierarchical databases and networks)....

    You do not have access to this resource.

    Exclusive to subscribers. 97% yet to be discovered!

    You do not have access to this resource.
    Click here to request your free trial access!

    Already subscribed? Log in!


    The Ultimate Scientific and Technical Reference

    A Comprehensive Knowledge Base, with over 1,200 authors and 100 scientific advisors
    + More than 10,000 articles and 1,000 how-to sheets, over 800 new or updated articles every year
    From design to prototyping, right through to industrialization, the reference for securing the development of your industrial projects

    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

    Subscribe now!

    Ongoing reading
    Relational model
    Outline