What are the differences between OLTP and OLAP?

Total Page Preview: 000000002130

What are the differences between OLTP and OLAP?

Difference between OLTP and OLAP :

	OLTP	OLAP
1	OLTP stands for Online Transactional Processing.	OLAP stands for Online Analytical Processing.
2	Data Usage : Current Data (Database).	Data Usage : historical Data (Data warehouse).
3	Processing : fast for delta operations (DML).	Processing : fast for read operations.
4	Operation : Delta operation (update, insert, delete) aka DML Terms Used : table, columns and relationships	Operation : read operation (select)
5	N/A	Terms Used : dimension table, fact table

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com

Comments

Horowitz

27-Sep-2021

viagra cialis sildenafil 60mg sildenafil pills like viagra over the counter sildenafil for women

https://docviamed.com

Relpy


Please enter your comment.
Please enter your Email-Id. Please enter valid Email-Id
Please enter your name.

Notify me of new comments via email. Notify me of new posts via email.