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].
References in periodicals archive ?
There are numerous temporal extensions that have been proposed and implemented by extending the relational data models [6], [8].
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.
Changing the relational data model, respectively change in the information system is initiated by two situations (events):
The functional dependency in the relational data model and the child-parent relationships in the hierarchical data model are typical examples.
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.
Examples of general data models are the hierarchical, network, and relational data models The relational model is the most general design tool.
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.
Enterprise applications today stretch the relational data model in new ways --ways it was never intended to bend
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.
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.
Clearly the most popular DBMS for user application development is any of a variety of systems based on the relational data model [3].
The major difference between the relational data model and the non-relational data model is the way of modeling relationships among entities.

Full browser ?