440 likes | 726 Views
Chapter 3 DATABASES AND DATA WAREHOUSES Building Business Intelligence. STUDENT LEARNING OUTCOMES. CAN COMPANIES KEEP YOUR PERSONAL INFORMATION PRIVATE AND SECURE?. Big Information Loss Examples. Questions. Have you been a victim of identity theft? If so, what happened?
E N D
Chapter 3DATABASES AND DATA WAREHOUSESBuilding Business Intelligence
CAN COMPANIES KEEP YOUR PERSONAL INFORMATION PRIVATE AND SECURE?
Questions Have you been a victim of identity theft? If so, what happened? What can you do to protect yourself from identity theft? How many organizations have your credit card number?
INTRODUCTION Businesses use many IT tools to manage and organize information for many reasons Online transaction processing (OLTP) Online analytical processing (OLAP)
INTRODUCTION • OLTP • OLAP
CHAPTER ORGANIZATION • Relational Database Model • Database Management System Tools • Data Warehouses and Data Mining • Business Intelligence Revisited • Information Ownership
RELATIONAL DATABASE MODEL • Database • Relational database
Database – Created with Logical Structures Before you can enter information into a database, you must define the data dictionary for all the tables and their fields. For example, when you create the Truck table, you must specify that it will have three pieces of information and that Date of Purchase is a field in Date format. Data dictionary
Database – Logical Ties within the Information Customer Number is the primary key for Customer and appears in Order as a foreign key Primary key Foreign key
Databases – Built-In Integrity Constraints Integrity constraints Data dictionary Foreign keys
DATABASE MANAGEMENT SYSTEM TOOLS Database management system (DBMS)
DBMS Engine • DBMS engine • Physical view • Logical view
Data Definition Subsystem Data definition subsystem The data dictionary helps you define…
Data Manipulation Subsystem Data manipulation subsystem Includes views, report generators, query-by-example tools, and structured query language
View Binoculars • View
Report Generator Report generator
Query-by-Example Tool QBE tool
Application Generation Subsystem Application generation subsystem
Data Administration Subsystem Data administration subsystem
Data Administration Subsystem • Backup and recovery • Backup • Recovery
Data Administration Subsystem Security management Query optimization Reorganization
Data Administration Subsystem • Concurrency control • Change management
DATA WAREHOUSES AND DATA MINING Help you build and work with business intelligence and some forms of knowledge Data warehouse
Data Warehouse Characteristics • Multidimensional • Support decision making, not transaction processing
Data-Mining Tools Data-mining tools
Data-Mining Tools Query-and-reporting tools Intelligent agents Multidimensional analysis (MDA tools) Statistical tools
Data Marts • Data mart
BUSINESS INTELLIGENCE REVISITED • Business intelligence (BI) • Hot topic in business today • Current market is $50 billion and double-digit annual growth
BI Objectives Help people understand several things:
Viewing Business Intelligence Digital dashboard
INFORMATION OWNERSHIP Information is a resource you must manage and organize to help the organization meet its goals and objectives You need to consider several things:
Strategic Management Support Covered many c-level positions in Chapter 2 for IT 2 others in information management Data administration Database administration
Sharing Information Everyone can share – while not consuming – information But someone must “own” it by accepting responsibility for its quality and accuracy