- Learning PostgreSQL 11
- Salahaldin Juba Andrey Volkov
- 138字
- 2021-07-02 13:11:37
Relational model concepts
A relational model is a first-order predicate logic that was first introduced by Edgar F. Codd in 1970 in his paper A Relational Model of Data for Large Shared Data Banks. A database is represented as a collection of relations. The state of the whole database is defined by the state of all the relations in the database. Different information can be extracted from the relations by joining and aggregating data from different relations and by applying filters on the data. In this section, the basic concepts of the relational model are introduced using the top-down approach by first describing the relation, tuple, attribute, and domain.
The terms relation, tuple, attribute, and unknown, which are used in the formal relational model, are equivalent to table, row, column, and null in the SQL language.
推薦閱讀
- Spring 5企業(yè)級(jí)開發(fā)實(shí)戰(zhàn)
- The Modern C++ Challenge
- Interactive Data Visualization with Python
- 差分進(jìn)化算法及其高維多目標(biāo)優(yōu)化應(yīng)用
- Apache Mesos Essentials
- 動(dòng)手學(xué)數(shù)據(jù)結(jié)構(gòu)與算法
- 案例式C語言程序設(shè)計(jì)實(shí)驗(yàn)指導(dǎo)
- Android應(yīng)用開發(fā)深入學(xué)習(xí)實(shí)錄
- Flink技術(shù)內(nèi)幕:架構(gòu)設(shè)計(jì)與實(shí)現(xiàn)原理
- PowerDesigner 16 從入門到精通
- Microsoft Exchange Server 2016 PowerShell Cookbook(Fourth Edition)
- 大規(guī)模語言模型開發(fā)基礎(chǔ)與實(shí)踐
- Learning Dynamics NAV Patterns
- C語言從入門到精通(微視頻精編版)
- Access 2016數(shù)據(jù)庫應(yīng)用與開發(fā):實(shí)戰(zhàn)從入門到精通(視頻教學(xué)版)