- 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.
推薦閱讀
- 計算思維與算法入門
- DevOps入門與實踐
- Yocto for Raspberry Pi
- Test-Driven Machine Learning
- Test-Driven JavaScript Development
- Unity 2018 Augmented Reality Projects
- 自學Python:編程基礎、科學計算及數據分析(第2版)
- 零基礎輕松學C++:青少年趣味編程(全彩版)
- DB2SQL性能調優秘笈
- ArcPy and ArcGIS(Second Edition)
- 網頁設計與制作
- ASP.NET jQuery Cookbook(Second Edition)
- Java網絡編程實用精解
- Python編程基礎與數據分析
- Programming MapReduce with Scalding