Total Page Preview:   000000001839

What are the differences between OLTP and OLAP?

Difference between OLTP and 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
What are the differences between OLTP and OLAP




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 :


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




Facebook User: