Foundations of Business Intelligence: Database and
Information Management
Student Learning Objectives
1. How does a relational database organize data, and how does it differ from an object-oriented database?
2. What are the principles of a database management system?
3. What are the principal tools and technologies for accessing information from databases to improve business performance and decision making?
4. What is the role of information policy and data administration in the management of organizational data resources?
5. Why is data quality assurance so important for a business?
Chapter Outline
5.1 The Database Approach to Data Management
Entities and Attributes Organizing Data in a Relational Database Establishing Relationships
5.2 Database Management Systems Operations of a Relational DBMS Capabilities of Database Management Systems Object-Oriented Databases Databases in the Cloud
5.3 Using Databases to Improve Business Performance and Decision Making Data Warehouses What Is a Data Warehouse? Data Marts Tools for Business Intelligence: Multidimensional Data Analysis and Data Mining Data Mining Databases and the Web
5.4 Managing Data Resources Establishing an Information Policy Ensuring Data Quality
Key Terms
The following alphabetical list identifies the key terms discussed in this chapter. The page number for each key term is provided.
|Attributes, 149 |Field, 150 |
|Data administration, 168 |Foreign key, 151 |
|Data cleansing, 169 |Information policy, 166 |
|Data definition, 157 |Key field, 150