Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17681 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anand
OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high
OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP
| Is This Answer Correct ? | 27 Yes | 0 No |
OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed.
OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.
| Is This Answer Correct ? | 26 Yes | 3 No |
Answer / vams_gk
i am agree with the above answer.olap is denormalized and
oltp normalised
| Is This Answer Correct ? | 24 Yes | 1 No |
Answer / balaji
OLTP
• Current data
• Short database transactions
• Online update/insert/delete
• Normalization is promoted
• High volume transactions
• Transaction recovery is necessary
• only one record is processed at a time
• data is present in 2d format
OLAP
•
• Current and historical data
• Long database transactions
• Batch update/insert/delete
• Denormalization is promoted
• Low volume transactions
• Transaction recovery is not necessary
• group of records processed at a time
• data is present in multi dim format
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / madhusudana rao
OLTP:
# OLTP means Online Transactional Processing, data comes
from different sources
# OLTP is normalized(3NF)
# it's used to stored the current transactional data
# it's store the less no of data
# here we will perform the DML operations
(INSERT,UPDATE,DELETE)
# performance is very fast
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / madhusudana rao
OLAP:
# OLAP means Online Analytical Processing
# OLAP is denormalized
# it's containes current&previouse data and used for the
analytical purpose
# perfprmance processing is slow compare with OLTP
#it is used to store the large data
| Is This Answer Correct ? | 1 Yes | 0 No |
How to Shedule the reports in Xi R2
What are the Users and User groups?
Explain what are the steps to be taken to schedule the report?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can we take report on Excel in Business Objects?
6 Answers Business Intelligence Analytics, Oracle,
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
Can i merge two dataproviders if they do not have common column?
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
What is the difference in creating filters in designer and business objects?
plz tell me about BOmain key in detail?
Teradata 
