chapter_04_Notes - CHAPTER 4 - DATABASES AND DATA...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CHAPTER 4 - DATABASES AND DATA WAREHOUSES - Building Business Intelligence Chapter 4 - DATABASES AND DATA WAREHOUSES - Building Business Intelligence What I consider important in this chapter… This chapter introduces 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. The concepts of business intelligence, OLTP and OLAP and the introduction of operational database . The understanding of such key concepts as: 1. Database and relation 2. Data dictionary 3. Primary key and foreign key The database management system software (DBMS) and views , queries , reports , and SQL . D ata warehouses and data mining tools that support OLAP and help create business intelligence. Within data mining tools, query-and-reporting tools , intelligent agents, multidimensional analysis tools , and statistical tools .. Four important questions. They are: 1. Who should oversee the organization’s information? 2. How will changes in technology affect organizing and managing information? 3. Is information ownership a consideration? 4. What are the ethics involved in managing and organizing information? KEY TERMS AND CONCEPTS Application generation subsystem 133 Business intelligence 120 Chief information officer (CIO) 143 Data administration 143 Data administration subsystem 133 Data definition subsystem 127 Data dictionary 122 Data manipulation subsystem 128 Data mart 139 Data mining tool 137 Data warehouse 136 Database 122 Database administration 143 Database management system (DBMS) 125 DBMS engine 126 Foreign key 124 Integrity constraint 124 Logical view 126 Page 1 of 7
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CHAPTER 4 - DATABASES AND DATA WAREHOUSES - Building Business Intelligence Multidimensional analysis (MDA) tool 138 Online analytical processing (OLAP) 121 Online transaction processing (OLTP) 120 Operational database 120 Physical view 126 Primary key 124 Query-and-reporting tool 137 Query-by-example (QBE) tool 131 Relation 122 Relational database model 122 Report generator 129 Structured query language (SQL) 132 View 128 Good opening case study Chrysler Spins a Competitive Advantage with Su0pply Chain Management Software This is a very interesting case about how data bases can be used to help better coordinate and integrate the business processes of different firms and gain a competitive advantage. SPIN (supply partner information network) allows Chrysler to provide information about new products to external supplier as soon as they become available. Structured around a powerful database, SPIN tracks Chrysler’s inventory, material requirements planning, work in progress and maintains supplier information. SPIN allows Chrysler to do business intelligence. This is a new connection with the discussion of Chapter 1
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

chapter_04_Notes - CHAPTER 4 - DATABASES AND DATA...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online