BU486 Chapter Notes - Chapter 4: Online Analytical Processing, Database, Data Redundancy
Document Summary
Bu486 chapter 4 notes: a set of interrelated centrally coordinated data files that are stored with as little data redundancy as possible. Database management system (dbms): the program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database. Database system: the data base, the dbms, and the application programs that access the database through the dbms. Database administrator: the person, responsible for coordinating, controlling and managing the database. Data warehouse: very large databases containing detailed and summarized data for a number of years that are used for analysis rather than transaction processing. Business intelligence: analyzing large amounts of data for strategic decision making. Online analytical processing (olap: using queries to investigate hypothesized relationships among data. Data mining: using sophisticated statistical analysis to discover un-hypothesized relationships in the data. Data integration: master files are combines into large pools of data that many application programs access.
