SQL Server Performance Forum – Threads Archive

OLAP and OLTP

Hi… What do u mean by OLAP server? What is the difference between OLAP and OLTP? SURYA

See if you find answer here
http://vyaskn.tripod.com/sqlserverfaq.htm Madhivanan Failing to plan is Planning to fail

In a nutshell the difference is that OLAP is about analyzing/reading data, whereas OLTP is about processing/writing/updating the raw transactions. So for example an ATM machines processes your transaction by using an OLTP server somewhere to verify your account, process the transaction etc. Meanwhile some manager in an office uses an OLAP server to produce a report showing how much cash has been withdrawn throughout different locations in the world to see if there are any trends that might drive the business. At some point the raw data from the OLTP systems are transferred to the OLAP servers and ‘summarized’ in some way. Meaning the manager doesn’t care that you withdrew $50 on January 1, from your checking account. He only cares about the total amount of cash deposited/withdrawn from the machine for the entire week/month/year etc. Hope this helps,
Dalton

OLTP is the environment where you do lot of processing on tables like INSERT,DELETE,UPDATE and have triggers. Whereas OLAP is created based on OLTP where data is stored to do Trend Analysis such Data Warehousing such as to make any decision based on DATA.
In OLAP you can not expect data changes evry minute as then you can not make any decision.

Operations guide:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>