Databases and Data Warehouses
CHAPTER 3
DATABASES AND DATA WAREHOUSES
Building Business Intelligence
CONTACT INFORMATION: Stephen Haag is the primary author of this chapter. If you have any questions or comments, please direct them to him at shaag@du.edu.
THIS CHAPTER/MODULE IN SHORT FORM…
This chapter introduces your students to the vitally important role of information in an organization and the various technology tools (databases, DBMSs, data warehouses, and data-mining tools) that facilitate the management and organization of information.
In the first section – which is short but powerful – your students will learn about the value of business intelligence. We also review some key concepts such as OLTP and OLAP and introduce the notion of an operational database.
The second section is a fairly thorough (but not technical) look at the relational database model. It explores such key concepts and terms as
1. Database and relation
2. Data dictionary
3. Primary key and foreign key
The following section covers database management system software and covers key topics such as views, queries, report generators, and SQL.
In the fourth section, your students will tour data warehouses and data-mining tools that support OLAP and help create business intelligence. Within data-mining tools we cover query-and-reporting tools, intelligent agents, multidimensional analysis tools, and statistical tools.
In the final section, we look at three important issues. They are:
1. Strategic management support
2. The sharing of information with responsibility
3. Information cleanliness
STUDENT LEARNING OUTCOMES
1. Describe business intelligence and its role in an organization.
2. Differentiate between databases and data warehouses with respect to their focus on online transaction processing and online analytical processing.
3. List and describe the key characteristics of a relational database.
4. Define the five software components of a database management system.
5. List
DATABASES AND DATA WAREHOUSES
Building Business Intelligence
CONTACT INFORMATION: Stephen Haag is the primary author of this chapter. If you have any questions or comments, please direct them to him at shaag@du.edu.
THIS CHAPTER/MODULE IN SHORT FORM…
This chapter introduces your students to the vitally important role of information in an organization and the various technology tools (databases, DBMSs, data warehouses, and data-mining tools) that facilitate the management and organization of information.
In the first section – which is short but powerful – your students will learn about the value of business intelligence. We also review some key concepts such as OLTP and OLAP and introduce the notion of an operational database.
The second section is a fairly thorough (but not technical) look at the relational database model. It explores such key concepts and terms as
1. Database and relation
2. Data dictionary
3. Primary key and foreign key
The following section covers database management system software and covers key topics such as views, queries, report generators, and SQL.
In the fourth section, your students will tour data warehouses and data-mining tools that support OLAP and help create business intelligence. Within data-mining tools we cover query-and-reporting tools, intelligent agents, multidimensional analysis tools, and statistical tools.
In the final section, we look at three important issues. They are:
1. Strategic management support
2. The sharing of information with responsibility
3. Information cleanliness
STUDENT LEARNING OUTCOMES
1. Describe business intelligence and its role in an organization.
2. Differentiate between databases and data warehouses with respect to their focus on online transaction processing and online analytical processing.
3. List and describe the key characteristics of a relational database.
4. Define the five software components of a database management system.
5. List