NEW INTERVIEW QUESTIONS.COM
DATA WAREHOUSING INTERVIEW QUESTIONS
GENERAL DATAWAREHOUSING INTERVIEW QUESTIONS DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
||What is the Difference between OLTP and OLAP?
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.
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
Submitted By: ( puppy1974 @ hotmail . com )
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
|Notify me when better answer is posted!