Databases and Data Warehouses Essay

SECTION 3

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.

LECTURE SUMMARIZE

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

CORRESPONDING MODULE(S)

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.

GROUP PROJECTS...



Essay for the Past, Present and Future of Tattooing

Related

Category

News