ADM 2372 Chapter Notes - Chapter 4: Hierarchical Database Model, Data Integrity, Data Warehouse
24 Jul 2017
School
Department
Course
Professor
Document Summary
Chapter 4: databases, data, warehouses, and data mining. Competitive advantage of data warehouse: facilitating business intelligence. Transaction data are stored in a database database management systems: computer program used to manage and query a database (dbms) Properties and design of dbms, schema: a given database has structural description of the type of raw facts. Database: maintains data about various types of objects(inventory), events (transactions), people (employees), and places (warehouses). Hierarchical database model: data organized into a treelike structure that allows repeating data (parent-child relationships: cannot be used to relate to structures that exist in the real world. Network database model: flexible way of representing objects and their relationships: flexible way of representing objects and their relationships, subordinate records can have many part records forming a complex, multi- dimensional lattice structure. Relationship database model: types of database that stores data in the form of logically related two-dimensional tables. (not like hierarchal)
