BU486 Chapter Notes - Chapter 4: Online Analytical Processing, Database, Data Redundancy

35 views4 pages
School
Department
Course
Professor

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents