swetha

• Mar 30th, 2005

 

OLTP 
 
Current data 
Short database transactions 
Online update/insert/delete 
Normalization is promoted 
High volume transactions 
Transaction recovery is necessary 
 
 
OLAP 
Current and historical data 
Long database transactions 
Batch update/insert/delete 
Denormalization is promoted 
Low volume transactions 
Transaction recovery is not necessary 
 

deepak

• Jun 5th, 2005

 

hi 
that is exact difference between oltp and OLAP 
bye

senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

 

OLTP is nothing but OnLine Transaction Processing ,which  contains a normalised tables and online data,which have frequent insert/updates/delete.

But OLAP(Online Analtical Programming) contains the history of OLTP data, which is, non-volatile ,acts as a Decisions Support System and is used for creating forecasting reports.

joinKishore

 Profile Answers by joinKishore 

• Mar 2nd, 2006

 

Hey add this point also,

Index

OLTP : FEW

OLAP : MANY

JOINS

OLTP : MANY

OLAP : FEW

Deepa

SAHADEVAN

• May 17th, 2006

 

Hi deepa,

thanks.

Warm Regards

Sahadevan

from GE Healthcare

pradeep reddy

• May 30th, 2006

 

good answer.

Krishna Chowdary

• Aug 30th, 2006

 

In Oltp's, Data Can be insert,update and Delete.Follows ER Modeling

In OLap's Data cannot be insert,update and Detete. Follows Dimensional Modeling.

R.Rajakrishnan

• Dec 8th, 2006

 

Hi swetha,

 I read your answer about "Difference between OLTP and OLAP". its good and it was very useful for me. like i need the Difference between EXEC and SP_EXECUTE?

 Thanks & Regards

 R.Rajakrishnan

mahesh4346

 Profile Answers by mahesh4346 

• Jan 31st, 2007

 

Hi SwethaThanks a lot for the answer

mrudula

• Mar 28th, 2007

 

oltp:
                                                                                    

1.current data only

2.insert,update,delete operations are possible

3.continous changing of data

4.1 year data is present

5.only one record is processed at a time


6.data is present in 2d format


olap:

1.current+historical data

2.used for reprting and analysis

3.non volatile in nature

4.5-30 yrs of data is stored

5.group of records processed at a time

6.data is present in muti dim format

jyotsna

• Jul 1st, 2007

 

OLTP

detailed data
normalized data
no. of concurrent users are very high.
data is volatile.
size of lotp system is low.
contains current data.
subject oriented
gives operational view of data

OLAP

summarized data
denormalized data
no. of concurrent users are low.
data is nonvolatile.
contains both current and historic data.
integrated and subject oriented database.
give analytical view.

abhaykalla

• Oct 30th, 2007

 

The simple answer would be that OLTP is realtime processing while OLAP is not..

naveenkumarmn123

 Profile Answers by naveenkumarmn123 

• Apr 15th, 2008

 

Thanks Mudula..........

naveenkumarmn123

 Profile Answers by naveenkumarmn123 

• Apr 15th, 2008

 

Thanks Jyothsna.......

Lavanya.leela

 Profile Answers by Lavanya.leela 

• Jun 15th, 2008

 

W/H maintains subjectoriented,timevariant,histrorical data. where as OLTP apllications maintains current data, and it gets updates regularly. ex:ATM machine,Railway reservations etc.

kumar.konakandla

 Profile Answers by kumar.konakandla 

• Jul 17th, 2008

 

olap->online analytical processing

 OLAP is a set of specifications which alows the client applications(reports)in retreiving the data from data ware house


oltp->olnline transactional processing

OLTP databases are fully normalized and are designed to consistently store operational data, one transaction at a time.It performs day-to -day operations and not support historical data


Narasimha kumar konakandla

mani191186

 Profile Answers by mani191186 

• Mar 9th, 2009

 

Main Differences between OLTP and OLAP are:-

1. User and System Orientation

OLTP: customer-oriented, used for data analysis and querying by clerks, clients and IT professionals.

OLAP: market-oriented, used for data analysis by knowledge workers( managers, executives, analysis).

2. Data Contents

OLTP: manages current data, very detail-oriented.

OLAP: manages large amounts of historical data, provides facilities for summarization and aggregation, stores information at different levels of granularity to support decision making process.

3. Database Design

OLTP: adopts an entity relationship(ER) model and an application-oriented database design.

OLAP: adopts star, snowflake or fact constellation model and a subject-oriented database design.

4. View

OLTP: focuses on the current data within an enterprise or department.

OLAP: spans multiple versions of a database schema due to the evolutionary process of an organization; integrates information from many organizational locations and data stores

swetha_0505

 Profile Answers by swetha_0505 

• Oct 6th, 2009

 

Difference between OLAP and OLTP Systems
 
Time Scale
  OLTP: This stores current data
  OLAP: This stores History data for analysis

 Indexing
  OLTP: Optimizes update performance by minimizing the number of indexes
  OLAP: Optimizes adhoc queries by including lots of indexes

 Normalization
  OLTP: This is fully normalized
  OLAP: Possibly partially denormalized for performance reasons. As this is used for reporting.

 Organization
  OLTP: Data stored revolves around business functions
  OLAP: Data stored revolves around information topics.

Stored Values
  OLTP: Stores typically coded data.
  OLAP: Stores descriptive data

 Homegenity
  OLTP: Scattered among different databases or DBMS and using different value coding schemes.
  OLAP: Centralized in data warehouse. Or in a collection of subject oriented data marts. 

tsurekha

 Profile Answers by tsurekha 

• Oct 20th, 2010

 

OLTP's are original source data where as OLAP's data comes from various OLTP database.
In OLTP quries are simple quries returning in few seconds whereas quries in OLAP are complex involving aggregates.
OLTP database design is highly normalized OLAP design is denormalized.

tsurekha

 Profile Answers by tsurekha 

• Dec 14th, 2010

 

OLTP
1) Original source of data
2) Normalized
3) Quries are simple
4) Regular going operations

OLAP

1) comes from all OLTP's
2) Denormalized
3) Quries are complex
4) Data which is used for analysis

keerthi

• Feb 1st, 2012

 

OLTP:
1.insert/update
2.thousands of users
3.size 1gb to 4gb
4.day to day operations
5.transaction of data,detailed data
6.application oriented

OLAP:
1.read-query
2.hundreads of people(only d organizational)
3.size 100gb to tera bytes
4.decision making
5.summarised data,historical data
6.subject oriented

ShivaRam

• Jun 22nd, 2013

 

Hey add these points also,

1)OLTP:Volatile data behavior
OLAP:Non-volatile data behavior
2)OLTP:More no of Users
OLAP:Less no of Users
3)OLTP:E-R model for data modeling
OLAP:Dimension model for data modeling
4)OLTP:Its contains parent and child table
OLAP:Its contains Dimension table and Fact Table
5)OLTP:Designed for daily Transaction Purpose
OLAP:Designed for Queuing and reporting.

Pravin

• Jan 16th, 2015

 

very useful answer.
thanks.

ram

• Aug 30th, 2016

 

OLTP: Original Source of data
Running on fundamental business task

OLAP: Data coming from various OLTP sources
Problem Solving, Decision Making