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