COMM-5121EL Chapter Notes - Chapter 4: Data Warehouse, Data Mining, Unique Key
14 Mar 2018
School
Department
Course
Professor
Document Summary
Chapter 4 databases, data warehouses, & data mining. Transactional data are stored in a database : operational-based is, such as scm & crm systems, access and maintain these data, records retrieved from the databases can be used to provide answers to questions & help make decisions. Database maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Schema structural description of the type of raw facts held in a database; describes the objects represented and the relationships among them. Database models ways of organizing a schema. There are many different models for organizing data in a database, including: Hierarchical database model data are organized into a treelike structure that allows repeating data using parent-child relationships, in such a way that it cannot have too many relationships. Network database model a flexible way of representing objects and their relationships; allows each record to have multiple parent and child records, forming a lattice structure.
