Conversely viewing information from the detailed

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: allow the users to analyze the data using elaborate, multi-dimensional complex views. In short, OLAP helps an organization to decide what to do and OLTP helps the organization to do it. Figure 16.16 lists out the differences between OLTP and OLAP systems. Features OLTP OLAP Stands for Designed for On-Line Transaction Processing On-Line Analytical Processing Supporting day-to-day business Supporting effective data analysis operations Used for Implementing the policy decisions Making policy decisions regarding what to do Structure Transaction processing (entry, Complex, large scale data analysis optimized for retrieval, and update of individual pieces of fact) Data model Normalized Multi-dimensional Nature of access Insert, retrieve, update, and delete Retrieve summarized information and records load data in batches Access tools Query language Query language and advanced analytical tools Type of data Data that runs the business Data to analyze the business stored Nature of data Detailed Summarized and detailed Performance Transaction throughput Query analysis throughput metric Figure 16.16. Differences between OLTP and OLAP systems. Data Mart A data mart is a subset of an organization's data warehouse. It contains data that is of value to a specific business unit or department rather than the whole organization. It can contain both detailed and summarized data for each specific business areas of an organization. The data may be captured either from the organization's operational systems or from the organization's data warehouse. A data mart can be used to analyze data only to an extent of single business area or department unlike the organization's data warehouse, which can be used to analyze da across multiple business areas or departments of the organization. A data mart can be built at a much lower cost, time, and effort than that involved in building a data warehouse. Because of their low cost and shorter development time, data marts start giving an early payback, thus justifying the return of investment. Metadata An important componen...
View Full Document

This document was uploaded on 04/07/2014.

Ask a homework question - tutors are online