1. Home
  2. IT
  3. Software technologies and System architectures

  4. Relational databases

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

    Overview

    ABSTRACT

    This article presents the basis of the relational model. This model is currently the most used in order to describe computer databases regardless of the implemented applications. Due to its universal mathematical base (set theory) and its simplicity, the relational model has allowed for the emergence of non-algorithmic languages (SQL, QBE) in order to search for data in a base. This article firstly presents the data structuring process (normalization) and then proceeds to studying the operations which allow for the extraction of data from the base by means of requests. The article finally presents the interaction mechanisms of a program written in JAVA language with the data.

    Read this article from a comprehensive knowledge base, updated and supplemented with articles reviewed by scientific committees.

    Read the article

    AUTHORS

     INTRODUCTION

    This article presents the basics of the relational model. Today, this model is the most widely used to describe databases manipulated by software, whatever the application. Thanks to its universal mathematical basis (set theory) and its simplicity, the relational model has enabled the emergence of non-algorithmic languages (SQL, QBE) to search for data in a database.

    The article begins by presenting the data structuring process (normalization). It then looks at the operations involved in querying the database to extract the information required. The article then looks at how a program written in Java interacts with the data.

    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 databases
    Outline