OLTP System
Online Transaction Processing (Operational System) |
OLAP System
Online Analytical Processing (Data Warehouse) |
|
Source of data
|
Operational data;
OLTPs are the original source of the data.
|
Consolidation data;
OLAP data comes from the various OLTP Databases
|
Purpose of data
|
To control and run fundamental
business tasks
|
To help with planning, problem
solving, and decision support
|
What the data
|
Reveals a snapshot
of ongoing business processes
|
Multi-dimensional
views of various kinds of business activities
|
Inserts and Updates
|
Short and fast inserts and updates
initiated by end users
|
Periodic long-running batch jobs
refresh the data
|
Queries
|
Relatively
standardized and simple queries Returning relatively few records
|
Often complex
queries involving aggregations
|
Processing Speed
|
Typically very fast
|
Depends on the amount of data
involved; batch data refreshes and complex queries may take many hours; query
speed can be improved by creating indexes
|
Space Requirements
|
Can be relatively
small if historical data is archived
|
Larger due to the
existence of aggregation structures and history data; requires more indexes
than OLTP
|
Database Design
|
Highly normalized with many tables
|
Typically de-normalized with fewer
tables; use of star and/or snowflake schemas
|
Backup and Recovery
|
Backup religiously;
operational data is critical to run the business, data loss is likely to
entail significant monetary loss and legal liability
|
Instead of regular
backups, some environments may consider simply reloading the OLTP data as a
recovery method
|
Wednesday, November 7, 2012
Diff Between OLTP and OLAP
Subscribe to:
Post Comments (Atom)
Tags
Architecture of UNIX
(1)
Basic Unix Commands
(1)
Data warehousing Quiestions1
(1)
Debugger
(1)
Downloads
(1)
ETL Process
(1)
Fundamentals of UNIX
(1)
Get top 5 records to target without using rank
(1)
Home
(1)
How do you perform incremental logic or Delta or CDC
(1)
Incremental Loading for Dimension Table
(1)
Informatica Complete Reference
(1)
Informatica Functions
(1)
Informatica Powercenter Architecture
(1)
informatica project
(1)
Informatica Quiestions
(1)
Informatica Quiestions3
(1)
Informatica Real time Scenarios
(2)
Informatica scenarios
(3)
Integration Testing
(1)
Introduction of Unix
(1)
Oracle Queries
(1)
Power center Client
(1)
Separate rows on group basis
(1)
TESTING-User Acceptance Test
(1)
Unit Testing
(1)
Unix
(2)
What is informatica
(1)
No comments:
Post a Comment
Thank you :
- kareem