Overview
Français
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 articleAUTHORS
-
Geneviève PUJOLLE: Senior Lecturer at Toulouse 1 University
-
Franck RAVAT: Senior Lecturer at Toulouse 1 University
-
Olivier TESTE: Senior lecturer at Toulouse 3 University
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.
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
Relational databases
Relational model
Also in our database
The Ultimate Scientific and Technical Reference
