Article | REF: H3860 V1

Relational databases

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

Publication date: August 10, 2009, Review date: December 19, 2015

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

Already subscribed? Log in!


Français

6. Conclusion

Today, most database software (DBMS) is based on the relational model. A database is seen as a set of tables, structured according to normal forms and manipulated using non-algorithmic languages, the best-known representative of which is SQL.

This article successively presents :

  • the table normalization process to avoid data inconsistencies during updates;

  • operations on tables to extract the required data ;

  • SQL language for expressing retrieval queries ;

  • implementation of SQL queries in an application program written in Java.

The relational model is well suited to describing data in business applications. However, multimedia applications handling complex objects require more elaborate...

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