OLTP - Online Transaction Processing System
OLTP – Online Transaction Processing System is used to store and maintains Business Transactional Information in the Database. OLTP Database is helps to generate MIS Transaction Report for Management to know the status of Business Transaction.
An instance, Inventory Management System is one kind of Online Transaction Processing System. By default, Customer, Product, Supplier, Employees are Entity of OLTP System and Purchase, Sales, Shipping and Delivery are Event of OLTP System.
When, Sales Event happened, the application user must be update Sales Transactional Information in the Database and then prepare Sales Invoice Report quickly to get Sales Amount from Customer.
In the OLTP, the complex database structure must be decompose into many simple database structures that help to store, retrieve and maintain data quickly in the Database Management System.
OLTP Database Architecture can design through Entity Relationship Model and Normalization Technique.
Data warehouse
Data warehouse is a centralized repository of Enterprise’s Historical and Operational Information that helps to queries and analysis Enterprise Operation to take Management Decision.
Data are extracts, transforms and loads in Data Warehouse from non-integrated Heterogeneous Source or Online Transaction System.
Data warehouse Architecture can design through Dimensional Data Model and De-normalization Technique.
OLAP - Online Analytical Processing System
OLAP – Online Analytical Processing System is helps to generate MIS Analysis Report from Data warehouse by using CUBE. In the OLAP, a predefined Multidimensional Data Structures is called CUBE.
CUBE is used to organize and summarize Data warehouse data. CUBE is helps to generate Typical Explorative Analysis Questions can be answered with little or no querying of the Relational Database.
An instance, we can generate following Explorative Analysis Report from SALES Data Marts.
When? Where? Whom? And how many Products are purchased in the particular period of Time?
When? Where? Whom? And how many Products are sold in the particular period of Time?
When? Where? Whom? And how many Products are sold by particular Sales Employee?
OLTP – Online Transaction Processing System is used to store and maintains Business Transactional Information in the Database. OLTP Database is helps to generate MIS Transaction Report for Management to know the status of Business Transaction.
An instance, Inventory Management System is one kind of Online Transaction Processing System. By default, Customer, Product, Supplier, Employees are Entity of OLTP System and Purchase, Sales, Shipping and Delivery are Event of OLTP System.
When, Sales Event happened, the application user must be update Sales Transactional Information in the Database and then prepare Sales Invoice Report quickly to get Sales Amount from Customer.
In the OLTP, the complex database structure must be decompose into many simple database structures that help to store, retrieve and maintain data quickly in the Database Management System.
OLTP Database Architecture can design through Entity Relationship Model and Normalization Technique.
Data warehouse
Data warehouse is a centralized repository of Enterprise’s Historical and Operational Information that helps to queries and analysis Enterprise Operation to take Management Decision.
Data are extracts, transforms and loads in Data Warehouse from non-integrated Heterogeneous Source or Online Transaction System.
Data warehouse Architecture can design through Dimensional Data Model and De-normalization Technique.
OLAP - Online Analytical Processing System
OLAP – Online Analytical Processing System is helps to generate MIS Analysis Report from Data warehouse by using CUBE. In the OLAP, a predefined Multidimensional Data Structures is called CUBE.
CUBE is used to organize and summarize Data warehouse data. CUBE is helps to generate Typical Explorative Analysis Questions can be answered with little or no querying of the Relational Database.
An instance, we can generate following Explorative Analysis Report from SALES Data Marts.
When? Where? Whom? And how many Products are purchased in the particular period of Time?
When? Where? Whom? And how many Products are sold in the particular period of Time?
When? Where? Whom? And how many Products are sold by particular Sales Employee?
 Your Comment To AUTHOR |
|
Download e-Book 
Copyright © 2010 data-e-education.com. All rights reserved.
