- 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.
推薦閱讀
- 數據庫程序員面試筆試真題與解析
- ASP.NET Core 5.0開發入門與實戰
- 控糖控脂健康餐
- R的極客理想:工具篇
- JavaScript 程序設計案例教程
- Spring Boot進階:原理、實戰與面試題分析
- Node學習指南(第2版)
- INSTANT Silverlight 5 Animation
- 運維前線:一線運維專家的運維方法、技巧與實踐
- 小程序從0到1:微信全棧工程師一本通
- Mastering Concurrency Programming with Java 9(Second Edition)
- MongoDB Cookbook(Second Edition)
- C語言程序設計實驗指導與習題精解
- Tkinter GUI Application Development Blueprints
- 深度學習企業實戰:基于R語言