This preview shows page 1. Sign up to view the full content.
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
Designed for On-Line Transaction Processing
On-Line Analytical Processing
Supporting day-to-day business Supporting effective data analysis
Implementing the policy decisions Making policy decisions regarding
what to do
Transaction processing (entry, Complex, large scale data analysis
retrieval, and update of individual
pieces of fact)
Nature of access Insert, retrieve, update, and delete Retrieve summarized information and
load data in batches
Query language and advanced
Type of data Data that runs the business
Data to analyze the business
Nature of data Detailed
Summarized and detailed
Query analysis throughput
Figure 16.16. Differences between OLTP and OLAP systems.
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.
- Spring '14