Chapter 6 : Foundations of Business Intelligence: Databases and…
Chapter 6 : Foundations of Business Intelligence: Databases and Information Management
6.4 Why are information policy, data administration, and data quality assurance essential for managing the firm’s data resources?
Ensuring Data Quality
Establishing an Information Policy
6.3 What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?
Databases and the Web
Analytical Tools: Relationships, Patterns, Trends
Text Mining and Web Mining
Online Analytical Processing (OLAP)
Business Intelligence Infrastructure
Data Warehouses and Data Marts
The Challenge of Big Data
6.2 What are the major capabilities of database management systems (DBMS), and why is a relational DBMS so powerful?
Non-relational Databases and Databases in the Cloud
Normalization and Entity-Relationship Diagrams
Capabilities of Database Management Systems
Querying and Reporting
Database Management Systems
Operations of a Relational DBMS
How a DBMS Solves the Problems of the Traditional File Environment
6.1 What are the problems of managing data resources in a traditional file environment?
Problems with the Traditional File Environment
Lack of Data Sharing and Availability
Lack of Flexibility
Data Redundancy and Inconsistency
File Organization Terms and Concepts