relational data model


Also found in: Acronyms.

relational data model

(database)
(Or "relational model") A data model introduced by E.F. Codd in 1970, particularly well suited for business data management. In this model, data are organised in tables. The set of names of the columns is called the "schema" of the table.

Here is an example table with the schema (account number, amount) and 3 lines.

account number amount -------------- --------- 12343243546456 +30000.00 23149875245824 +2345.33 18479827492874 -123.25

The data can be manipulated using a relational algebra. SQL is a standard language for talking to a database built on the relational model (a "relational database").

["A relational model for large shared data banks" Communications of ACM 13:6, pp 377-387].
Mentioned in ?
References in periodicals archive ?
There are numerous temporal extensions that have been proposed and implemented by extending the relational data models [6], [8].
A new optimized model to handle temporal data using open source database
The students do not need expansion of the knowledge concerning the relational data model in the future, which, despite all the advances in IT, is nearly 100% presented in current DBMS.
Human resources preparation for digital information processing
Changing the relational data model, respectively change in the information system is initiated by two situations (events):
Identification of data content based on measurement of quality of performance
The functional dependency in the relational data model and the child-parent relationships in the hierarchical data model are typical examples.
Froglingo, a programming language empowered by a total-recursive-equivalent data model
Persuaded that many applications will never reach the limitations of the widespread relational data model this article focuses on traditional relational algebra equipped with extra features that allow query relaxation and similarity searches.
Similarity measures for relational databases
Examples of general data models are the hierarchical, network, and relational data models The relational model is the most general design tool.
An easy-to-use, comprehensive information service for designers
In the meantime, relational DBMSs are gaining increasing use because of the data independence inherent in the relational data model, ease of specifying and enforcing constraints, potential for optimization of query-processing strategies by the system, and a better foundation for distributed databases.
Evolution of data modeling for databases
Enterprise applications today stretch the relational data model in new ways --ways it was never intended to bend
The Cloudant data layer: state management for web apps, flexible schema for the enterprise
Working together, the companies will provide enhanced support services for the migration from a relational data model to Couchbase Server, accelerating the success of companies NoSQL database deployments.
Canada : Couchbase and PalominoDB Announce Partnership to Support NoSQL Database Implementations
Emphasizing advancements and applications to neutrosophics, this text introduces the interval neutrosophic set, which is an instance of the neutrosophic set, describes the interval neutrosophic logic based on neutrosophic sets, a situation which allows for modeling of fuzzy, incomplete, and inconsistent information, and gives a neutrosophic relational data model with a relational data base, and another model in the form of a soft semantic web services agent.
Interval neutrosophic sets and logic; theory and applications in computing
Clearly the most popular DBMS for user application development is any of a variety of systems based on the relational data model [3].
Comparing representations with relational and EER models
The major difference between the relational data model and the non-relational data model is the way of modeling relationships among entities.
DATAPLEX: an access to heterogeneous distributed databases

Encyclopedia browser ?
Full browser ?