dimensions (all products sold in the Eastern region above a certain price during a certain time period) and display them. such as time periods can be broken down into sub attributes. OLAP can be used for or the discovery of previously undiscerned relationships between data items. An OLAP database does not need to be as large as a , since not all transactional data is needed for trend analysis. Using Open Database Connectivity (), data can be imported from existing relational databases to create a multidimensional database for OLAP. OLTP OLAP Defination OLTP stands for On Line Transaction OLAP stands for On Line Analytic Processing Processing and is a data modeling and is an approach to answer approach typically used to facilitate and queries. OLAP was conceived for manage usual business applications. Management Information Systems and Most of applications you see and use Decision Support Systems are OLTP based Horizon OLTP System deals with operational OLAP deals with Historical Data or Archival data. Operational data are those data Data. Historical data are those data that are involved in the operation of a particular archived over a long period of time. system. Refresh OLPT requires instant update. When OLAP has not require instant refresh. Nobody you cash some money from an ATM instant information to make strategic you balance shall be immediately business decision. updated Data Model OLTP perfectly fits traditional OLAP solution is use an hybrid approach & Schema or object-oriented models. based sitting on conventional relational We usually refer to information as technology. This model employs so called attributes related to entities, objects or star-schema instead of traditional classes, like product price, invoice normalization. amount or client name. Mapping can be with a simple, one argument function OLPT emphasis is on update. OLAP can be updated by periodic (daily) Transaction level isolation assures that processes that work in standalone mode thus database is always in a consistent state. consistency can be assured through update Emphasis This can imply in some overhead to process. coordinate concurrent updates but is necessary even in small applications. Example In a banking System, you withdraw If we collect last 10 data about flight amount through an ATM. Then account reservation, The data can give us many Number,ATM PIN Number,Amount you meaningful information such as the trends in
dimensions (all products sold in the Eastern region above a certain price during a certain time period) and display them. such as time periods can be broken down into sub attributes. OLAP can be used for or the discovery of previously undiscerned relationships between data items. An OLAP database does not need to be as large as a , since not all transactional data is needed for trend analysis. Using Open Database Connectivity (), data can be imported from existing relational databases to create a multidimensional database for OLAP. OLTP OLAP Defination OLTP stands for On Line Transaction Processing and is a data modeling approach typically used to facilitate and manage usual business applications. Most of applications you see and use are OLTP based OLAP stands for On Line Analytic Processing and is an approach to answer queries. OLAP was conceived for Management Information Systems and Decision Support Systems Horizon OLTP System deals with operational data. Operational data are those data involved in the operation of a particular system. OLAP deals with Historical Data or Archival Data. Historical data are those data that are archived over a long period of time. Refresh OLPT requires instant update. When you cash some money from an ATM you balance shall be immediately updated OLAP has not require instant refresh. Nobody instant information to make strategic business decision. Data Model & Schema OLTP perfectly fits traditional or object-oriented models. We usually refer to information as attributes related to entities, objects or classes, like product price, invoice amount or client name. Mapping can be with a simple, one argument function OLAP solution is use an hybrid approach based sitting on conventional relational technology. This model employs so called star-schema instead of traditional normalization. Emphasis OLPT emphasis is on update. Transaction level isolation assures that database is always in a consistent state. This can imply in some overhead to coordinate concurrent updates but is necessary even in small applications. OLAP can be updated by periodic (daily) processes that work in standalone mode thus consistency can be assured through update process. Example In a banking System, you withdraw amount through an ATM. Then account Number,ATM PIN Number,Amount you If we collect last 10 data about flight reservation, The data can give us many meaningful information such as the trends in
dm-ss-solutions.docx