官术网_书友最值得收藏!

  • 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.
主站蜘蛛池模板: 祁门县| 南江县| 栾城县| 博白县| 万宁市| 迁安市| 淮滨县| 阜城县| 扶沟县| 顺昌县| 松滋市| 龙山县| 普定县| 武功县| 福安市| 和林格尔县| 东乡县| 紫阳县| 会宁县| 黑河市| 东乡县| 正镶白旗| 武胜县| 绵阳市| 合肥市| 社会| 高雄县| 永德县| 平武县| 高碑店市| 华宁县| 平乡县| 沙坪坝区| 岳西县| 重庆市| 芜湖市| 耒阳市| 台中县| 塔河县| 绵竹市| 博爱县|