Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 916 Page Views: 

What is the difference between OLTP & OLAP?



Posted By: Avi Date: 1 October 2010 11:14:07 AM
 Answer:

OLTP:- 1. It is based on entity relational model. 2. It inherits the concept of normalization so there is no redundancy. 3. Less use of indexes, infact uses more tables and joins. 4. It stores the transactional data and maximum amount of data is the current data. It gives high performance. OLAP:- 1. It is based on dimensional model. 2. Works on denormalised tables so have redundant data. 3. Main concentration is on indexing since the data is almost stable. 4. The tables contains operational data which is both historical and present one. 4. You can only use Select clause on an OLAP other clause will not work properly. 5. Low performance in comparison to OLTP


Posted By: avibtech

Date: 1 October 2010 11:14:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image b6iRWP
Related Questions
Database : What do you mean by Cardinality?

What do you mean by Cardinality?

Cardinality refers to the type of relationship like the relationship between two entities is one to ....
Category: Database Date: 8/20/2009 3:06:52 AM
Database : What do you mean by Deadlock?

What do you mean by Deadlock?

When number of transaction are running at the same time and if a situation occurs when the one trans....
Category: Database Date: 8/20/2009 3:04:53 AM
Database : What do you mean by concurrency?

What do you mean by concurrency?

Concurrency refers when the two or more transaction are executed simultaneously.
Category: Database Date: 8/20/2009 3:03:52 AM
Database : What is a Candidate key?

What is a Candidate key?

Candidate key is a set of one or more attribute other than primary key that can uniquely identify a ....
Category: Database Date: 8/20/2009 3:02:40 AM
Database : What is a Foreign Key?

What is a Foreign Key?

A foreign key is a referential constraint between two tables. The foreign key identifies a column or....
Category: Database Date: 8/20/2009 3:01:26 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories