ADM 2372 Chapter Notes - Chapter 4: Cluster Analysis, Data Mart, Time Series

• School: University of Ottawa
• Department: Administration
• Course: ADM 2372
• Professor: Zikun Zhang

Document Summary

Adm2372 chapter 4- databases, data warehouses, and data mining: Records retrieved from databases can be used to provide answers to questions and make decisions. Database management system (dbms): the computer program used to manage and query a database. Schema: structural description for the raw facts a database holds. Database models: modelling the database structure: describes objects represented and relationships among them, most common is he relational model. Database: maintains data about various types of objects, events, people, and places. Hierarchical database model: data are organized into a treelike structure that allows repeating data using parent-child relationships. Network database model: a flexible way of representing objcets and their relationships: widely used in the first mainframe database management systems, allows each record to have multiple parent and child records, lattice structure. Relational database model: a type of database that stores data in the form of logically related two-dimensional tables. Entity: a person, place, thing, transaction, about which data are stored.