CLICK HERE TO DOWNLOAD PPT ON DATABASE AND DATA WARAEHOUSE FUNDAMENTALS
DATABASE AND DATA WARAEHOUSE FUNDAMENTALS Presentation Transcript
1.DATABASE & DATA WARAEHOUSE FUNDAMENTALS
2.LECTURE OVERVIEW
DATABASE FUNDAMENTALS
Organizational Information
Storing Organizational Information
Relational Database Fundamentals
Relational Database Advantages
Database Management Systems
Integrating Data Among Multiple Databases
DATA WARAEHOUSE FUNDAMENTALS
Accessing Organizational Information
History of Data Warehousing
Data Warehouse Fundamentals
Data Mining and Business Intelligence
DATABASE FUNDAMENTALS
Organizational Information
Storing Organizational Information
Relational Database Fundamentals
Relational Database Advantages
Database Management Systems
Integrating Data Among Multiple Databases
DATA WARAEHOUSE FUNDAMENTALS
Accessing Organizational Information
History of Data Warehousing
Data Warehouse Fundamentals
Data Mining and Business Intelligence
3.ORGANIZATIONAL INFORMATION
4.THE VALUE OF QUALITY INFORMATION
Characteristics of high-quality information include:
Accuracy
Completeness
Consistency
Uniqueness
Timeliness
Characteristics of high-quality information include:
Accuracy
Completeness
Consistency
Uniqueness
Timeliness
5.RELATIONAL DATABASE FUNDAMENTALS
Database – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
Entity – a person, place, thing, transaction, or event about which information is stored
Attribute (field, column) – characteristics or properties of an entity class
Primary keys and foreign keys identify the various entities (tables) in the database
Database – maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)
Entity – a person, place, thing, transaction, or event about which information is stored
Attribute (field, column) – characteristics or properties of an entity class
Primary keys and foreign keys identify the various entities (tables) in the database
6.RELATIONAL DATABASE ADVANTAGES
Database advantages from a business perspective include
Increased flexibility
Increased scalability and performance
Reduced information redundancy
Increased information integrity (quality)
Increased information security
Database advantages from a business perspective include
Increased flexibility
Increased scalability and performance
Reduced information redundancy
Increased information integrity (quality)
Increased information security
7.DATABASE MANAGEMENT SYSTEMS
Database management systems (DBMS) – software through which users and application programs interact with a database
Data-driven websites – an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database
Database management systems (DBMS) – software through which users and application programs interact with a database
Data-driven websites – an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database
8.INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
Integration – allows separate systems to communicate directly with each other
Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes
Integration – allows separate systems to communicate directly with each other
Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes
9.Need for DataWarehousing
Better business intelligence for end-users
Reduction in time to locate, access, and analyze information
Consolidation of disparate information sources
Strategic advantage over competitors
Faster time-to-market for products and services
Replacement of older, less-responsive decision support systems
Reduction in demand on IS to generate reports
Better business intelligence for end-users
Reduction in time to locate, access, and analyze information
Consolidation of disparate information sources
Strategic advantage over competitors
Faster time-to-market for products and services
Replacement of older, less-responsive decision support systems
Reduction in demand on IS to generate reports
10.DATA WAREHOUSE FUNDAMENTALS
Data warehouse – a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
Data warehouse – a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
11.Business Queries using DataWarehouse
Which product generated maximum revenue over last two quarters in a chosen geographical region, city wise, relative to the previous version of product, compared with the plan
What percent of customer procures product A with B in a chosen region, broken down by city, season, and income group
Which product generated maximum revenue over last two quarters in a chosen geographical region, city wise, relative to the previous version of product, compared with the plan
What percent of customer procures product A with B in a chosen region, broken down by city, season, and income group
12.DATA WAREHOUSE FUNDAMENTALS
13.Subject-Oriented
14.Integrated
15.Non-volatile
16.Time Variant
17.Data Mart
18.MULTIDIMENSIONAL ANALYSIS
Databases contain information in a series of two-dimensional tables
In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows Dimension – a particular attribute of information
Cube – common term for the representation of multidimensional information
Databases contain information in a series of two-dimensional tables
In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows Dimension – a particular attribute of information
Cube – common term for the representation of multidimensional information
19.INFORMATION CLEANSING OR SCRUBBING
An organization must maintain high-quality data in the data warehouse
Information cleansing or scrubbing – a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
An organization must maintain high-quality data in the data warehouse
Information cleansing or scrubbing – a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
20.INFORMATION CLEANSING OR SCRUBBING
21.INFORMATION CLEANSING OR SCRUBBING
Accurate and complete information
Accurate and complete information
22.DATA MINING AND BUSINESS INTELLIGENCE
Data mining – the process of analyzing data to extract information not offered by the raw data alone
To perform data mining users need data-mining tools
Data-mining tools helps users uncover BI
Data mining – the process of analyzing data to extract information not offered by the raw data alone
To perform data mining users need data-mining tools
Data-mining tools helps users uncover BI
23.Typical Data Warehouse Architecture
24.Typical Data Warehouse Architecture
25.Warehouse Architecture - 1
26.Warehouse Architecture - 2
27.Warehouse Architecture - 3
28.Components of a Data Warehouse Architecture
Posts
0 comments