SOURCES AND DATA WAREHOUSES
Building Business Intelligence
INFO: Stephen Haag is the major author of this chapter. In case you have any questions or responses, please will take them to him at [email protected] edu.
THIS CHAPTER/MODULE TO PUT IT BRIEFLY FORMвЂ¦
This kind of chapter features your learners to the vitally important role info in an firm and the various technology equipment (databases, DBMSs, data facilities, and data-mining tools) that facilitate the management and organization info.
In the first section вЂ“ which is short but effective вЂ“ the students will gain details about about the value of business intelligence. We all also review some important concepts including OLTP and OLAP and introduce the idea of an detailed database.
The second section is known as a fairly comprehensive (but not technical) consider the relational data source model. This explores this sort of key ideas and terms as 1 . Database and relation
2 . Data book
3. Main key and foreign essential
The following section covers database software system application and includes key subject areas such as opinions, queries, survey generators, and SQL.
In the fourth section, your students will head to data facilities and data-mining tools that support OLAP and help produce business intelligence. Inside data-mining equipment we cover query-and-reporting tools, intelligent providers, multidimensional evaluation tools, and statistical tools.
In the last section, we look at three important concerns. They are: 1 . Strategic supervision support
2 . The writing of information with responsibility
a few. Information cleanliness
STUDENT LEARNING OUTCOMES
1 . Describe business intelligence and its function in an corporation. 2 . Identify between directories and info warehouses with respect to their concentrate on online deal processing and online analytical processing. several. List and describe the main element characteristics of your relational data source. 4. Determine the five software components of a database management system. your five. List and describe the main element characteristics of your data factory. 6. Determine the 4 major types of data-mining tools within a data factory environment. several. List key considerations in information ownership.
INTRODUCTION (p. 124)
THE RELATIONAL REPOSITORY MODEL (p. 126)
1 ) Collections info
2 . Created with Logical Constructions
3. With Logical Ties within the Information
4. With Built-In Integrity Constraints
DATABASE SOFTWARE MANAGEMENT SYSTEM EQUIPMENT (p. 130)
1 . Info Definition Subsystem
2 . Info Manipulation Subsystem
3. Software Generation Subsystem
4. Data Administration Subsystem
DATA WAREHOUSES AND INFO MINING (p. 140)
1 ) What Is a Data Warehouse?
installment payments on your What Are Data-Mining Tools?
three or more. Data Marts: Smaller Data Warehouses
four. Data Mining as a Career Opportunity
a few. Important Considerations in Using a Data Warehouse
INFORMATION OWNERSHIP (p. 146)
1 ) Strategic Management Support
2 . The Posting of Information with Responsibility
several. Information Cleanliness
END OF CHAPTER (p. 149)
1 ) Summary: Student Learning Final results Revisited
installment payments on your Closing Case Study One
3. Closing Example Two
5. Key Terms and Concepts
five. Short-Answer Concerns
6. Tasks and Exercises
7. Dialogue Questions
eight. Electronic Trade
Extended Learning Module C вЂ“ Creating Databases and Entity-Relationship Diagramming -follows this chapter. It will require your learners through the process of designing a well-formed relational database. In Chapter several, we focus on Solomon Corporations to illustrate the use of a relational database inside the context of customer romance management. We all continue with Solomon in Extended Learning Module C and give attention to designing the provision chain management side.
If you opt to cover this module, we might encourage one to shortly comply with with Expanded Learning Module J, which teaches your students the right way to implement a database in Microsoft Get and build questions, reports, and forms.