You are currently viewing Write a comparison between Online-analytical processing and online transaction processing | OLAP vs OLTP

Write a comparison between Online-analytical processing and online transaction processing | OLAP vs OLTP

Comparison between OLTP and OLAP systems are as follows – OLAP vs OLTP

FeatureOLTPOLAP
Full formOnline transaction ProcessingOnline analytical processing
Characteristicoperational Processinginformational processing
Orientationtransactionanalysis
Userclerk, DBA, transaction database professionalknowledge worker (e.g., manager, executive, analyst)
Function day-to-day operationslong-term informational requirements, decision support
DB designER-based, application-oriented star/snowflake, subject-oriented
Datacurrent guaranteed up-to-datehistorical; accuracy maintained over time.
Summarizationprimitive, highly detailedsummarized, consolidated
View detailed, flat relationalsummarized, multidimensional
Unit of workshort, simple transactioncomplex query
Accessread/writemostly read
Focusdata ininformation out
Operations Number of recordsindex/hash on primary keylots of scans
accessedtensmillions
Number of usersthousandshundreds
DB size100 MB to GB100 GB to TB
Priorityhigh performance, high availabilityhigh flexibility end-user autonomy.
Metrictransaction throughputquery throughput, response time

Aanchal Gupta

Welcome to my website! I'm Aanchal Gupta, an expert in Electrical Technology, and I'm excited to share my knowledge and insights with you. With a strong educational background and practical experience, I aim to provide valuable information and solutions related to the field of electrical engineering. I hold a Bachelor of Engineering (BE) degree in Electrical Engineering, which has equipped me with a solid foundation in the principles and applications of electrical technology. Throughout my academic journey, I focused on developing a deep understanding of various electrical systems, circuits, and power distribution networks.

Leave a Reply