GeekInterview.com
Series: Subject: Topic:
Question: 125 of 133

What is the Difference between OLTP and OLAP


Answered by swetha on 2005-03-30 12:00:33: 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 
 
Asked by: Interview Candidate | Asked on: Jun 5th, 2005
Showing Answers 1 - 22 of 22 Answers
swetha

Answered On : 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  

Yes  2 Users have rated as useful.
  
Login to rate this answer.
deepak

Answered On : Jun 5th, 2005

Hi  that is exact difference between oltp and OLAP bye

  
Login to rate this answer.

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.

  
Login to rate this answer.
joinKishore

Answered On : Mar 2nd, 2006

View all answers by joinKishore

Hey add this point also, Index OLTP : FEWOLAP : MANYJOINSOLTP : MANYOLAP : FEWDeepa

  
Login to rate this answer.
SAHADEVAN

Answered On : May 17th, 2006

Hi deepa,thanks.Warm RegardsSahadevan from GE Healthcare

  
Login to rate this answer.
pradeep reddy

Answered On : May 30th, 2006

good answer.

  
Login to rate this answer.
Krishna Chowdary

Answered On : Aug 30th, 2006

In Oltp's, Data Can be insert,update and Delete.Follows ER ModelingIn OLap's Data cannot be insert,update and Detete. Follows Dimensional Modeling.

  
Login to rate this answer.
R.Rajakrishnan

Answered On : 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

  
Login to rate this answer.
mahesh4346

Answered On : Jan 31st, 2007

View all answers by mahesh4346

Hi SwethaThanks a lot for the answer

  
Login to rate this answer.
mrudula

Answered On : Mar 28th, 2007

oltp:                                                                                     1.current data only2.insert,update,delete operations are possible3.continous changing of data4.1 year data is present5.only one record is processed at a time6.data is present in 2d formatolap:1.current+historical data2.used for reprting and analysis3.non volatile in nature4.5-30 yrs of data is stored5.group of records processed at a time6.data is present in muti dim format

Yes  1 User has rated as useful.
  
Login to rate this answer.
jyotsna

Answered On : Jul 1st, 2007

OLTPdetailed datanormalized datano. of concurrent users are very high.data is volatile.size of lotp system is low.contains current data.subject orientedgives operational view of dataOLAPsummarized datadenormalized datano. of concurrent users are low.data is nonvolatile.contains both current and historic data.integrated and subject oriented database.give analytical view.

  
Login to rate this answer.
abhaykalla

Answered On : Oct 30th, 2007

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

  
Login to rate this answer.

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

  
Login to rate this answer.

Thanks Jyothsna.......

  
Login to rate this answer.
Lavanya.leela

Answered On : Jun 15th, 2008

View all answers by Lavanya.leela

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Olap->online analytical processing OLAP is a set of specifications which alows the client applications(reports)in retreiving the data from data ware houseoltp->olnline transactional processingOLTP 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 dataNarasimha kumar konakandla

  
Login to rate this answer.
mani191186

Answered On : Mar 9th, 2009

View all answers by mani191186

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

  
Login to rate this answer.
swetha_0505

Answered On : Oct 6th, 2009

View all answers by swetha_0505

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. 

  
Login to rate this answer.
tsurekha

Answered On : Oct 20th, 2010

View all answers by tsurekha

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.

  
Login to rate this answer.
tsurekha

Answered On : Dec 14th, 2010

View all answers by tsurekha

OLTP 1) Original source of data2) Normalized 3) Quries are simple 4) Regular going operations OLAP 1) comes from all OLTP's2) Denormalized3) Quries are complex4) Data which is used for analysis

  
Login to rate this answer.
keerthi

Answered On : 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

  
Login to rate this answer.
ShivaRam

Answered On : 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.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.