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

  • Learning PostgreSQL 11
  • Salahaldin Juba Andrey Volkov
  • 185字
  • 2021-07-02 13:11:40

Data model perspectives

Data model perspectives are defined by ANSI as follows:

  • Conceptual data model: Describes the domain semantics, and is used to communicate the main business rules, actors, and concepts. It describes the business requirements at a high level and is often called a high-level data model. 
  • Logical data model: Describes the semantics for a certain technology, for example, the UML class diagram for object-oriented languages.
  • Physical data model: Describes how data is actually stored and manipulated at the hardware level, such as storage area network, table space, CPUs, and so on.

According to ANSI, this abstraction allows changing one part of the three perspectives without amending the other parts. One could change both the logical and the physical data models without changing the conceptual model. To explain, sorting data using bubble or quick sort is not of interest for the conceptual data model. Also, changing the structure of the relations could be transparent to the conceptual model. One could split one relation into many relations after applying normalization rules, or by using enum data types in order to model the lookup tables.

主站蜘蛛池模板: 德庆县| 莲花县| 塘沽区| 嵩明县| 磴口县| 清徐县| 乌兰察布市| 望谟县| 仁化县| 如皋市| 隆德县| 大冶市| 锦州市| 隆安县| 怀仁县| 监利县| 武山县| 宁津县| 和硕县| 宝山区| 甘谷县| 闵行区| 龙泉市| 磐石市| 陆河县| 改则县| 浑源县| 拜泉县| 神农架林区| 高雄县| 确山县| 乐平市| 康定县| 安乡县| 新津县| 兰州市| 镇坪县| 增城市| 揭阳市| 荥阳市| 佳木斯市|