Total Page Preview:   000000001401

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
 
 
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 : 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

                           
                           
                           
                           

Recent Posts

How to get the alternate rows or records from table in sql server
07-Jun-2017
 Data Warehouse Three Tier Architecture
20-Aug-2017
 SQL Server - Fragmentation on azure sql database
07-Oct-2018
 Limitations of Azure SQL Database
19-Sep-2019
 PIVOT and UNPIVOT in SQL Server with Example
29-Jun-2017
 SQL Server - Find unused indexes on azure SQL database scripts
02-Oct-2018
 SQL Server - Find all index with key columns on Azure SQL Database
02-Oct-2018
 Find Resource usage in Azure SQL Database using script or T-SQL
07-Oct-2018
 How to Set client IP Address using the firewall security in Azure SQL Using Portal
29-Jun-2017
 What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?
10-Sep-2021
 Top 60 SQL Server Interview Questions Answers for freshers and experienced
17-Sep-2021
 Top 16 performance query optimization techniques in SQL Database?
16-Sep-2021
 What is a Trigger and type of trigger in SQL server?
10-Sep-2021
 How many types of dimension tables available in data warehouse?
16-Sep-2021
 Data warehouse Interview Questions Answers for freshers and experienced
16-Sep-2021
 What are the differences between OLTP and OLAP?
07-Sep-2021
 What is Table Variable? Explain its advantages and disadvantages?
10-Sep-2021
 What are the different types of Error Handling in SQL Server?
11-Sep-2021
 Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced
31-Aug-2021
 What are characteristics and advantages of stored procedure?
10-Sep-2021

Facebook User: