2006-08-23 03:46:48 · 3 answers · asked by vishaljeetdogra 1 in Computers & Internet ➔ Software
These are two diffrent questions tied into a single one. I will answer the second one.
Answer I
*****************
OLTP databases provide real time acesses to its data which is being updated by other transactions. OLTP databases contrasts earlier databases that allowed updation in batch modes as all upations were provided in one go.(database Replication can be considered so).
In case of OLTP there is no such boundation and all updations can be done anytime and other users will autometically see your changes.
OLAP provides analytical processing capabilities on an OLTP database. This provides a real time analytical view of the database. Historically OLAP suffered since it would slow down OLTP database considerably. However with more faster h/w and better algos its now practical.
Answer II
******************
Data Warehouses contain historic & non operational data that is not required for day to day working of the operations. For example you purchased a pair of Shoes from a branded store 10 years ago. Chances that you will come back reclaiming you money are very very less ;-).
Such data is transferred to special database known as Warehouse. If it would have being in the OLTP database then it would have comsumed storage and WORSE will make transaction processing very very slow. Since best database algo's are log(n) where n is the amount of data. As 'n' grows so is the time complexity.
Hence it makes sense to keep such historic data separate for analysis purposes.
Hope that helps
*<|:-)
2006-08-23 04:05:40 · answer #1 · answered by vaibhav 2 · 0⤊ 0⤋
OLAP which is Online Analytical Processing is a way of querying the warehouse and the operation requires going through entire sets of data elements and producing a user wanted result. For example you can have the history of sales for a company by day for the last 15 years stored in the warehouse, an OLAP query would generate a report for say the best days to sell 4 the company. OLTP which is Online Transaction Processing is for doing on the fly transactions like selling a ticket on the Internet.
Warehouses are very large and therefore kept on different machines + OLAP queries themselves requires a lot of time and memory to execute, thus because of their basics, warehouses are stores while OLAP servers are executers, there machine requirements are different, plus you also protect ur data by keeping the processor from the processe.
2006-08-23 04:08:24 · answer #2 · answered by bostoncity_guy 2 · 0⤊ 0⤋
????????
2006-08-23 03:49:18 · answer #3 · answered by andrew_perrong 3 · 0⤊ 0⤋