Differences between oltp and olap?
Loading
Differences between oltp and olap?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Oct 27, 2022, 3:06 PM
Operational data. OLTP systems are the original data sources, Consolidation data. OLAP data comes from the OLTP databases.
Responsible for controlling and running basic business tasks, Responsible for planning, problem-solving and supporting business decisions.
Queries are standard and straightforward, Complex queries.
Fast speed, Complex queries can take a long time to process.
Frequent complete backups along with incremental backups, No regular backups. Instead, OLTP data is reloaded as a recovery method.
Online transactional system, Online analysis and data retrieving process.
Uses traditional DBMS, Uses a data warehouse.
Detailed organisation of data, Disorganised data.
Market-oriented process, Customer-oriented process.
Application-oriented design, Subject-oriented design.
Clerks, online shoppers, etc., use OLTP, Data knowledge workers like managers and CEOs use OLAP.
Enhances the productivity of the user, Enhances the productivity of business analysts.
The user starts the data updates, which are short and fast, Regular refreshing of data with long, scheduled batch jobs.
Amit MohantyPosted Oct 25, 2022, 7:07 AM
Check the below links
https://www.geeksforgeeks.org/difference-between-olap-and-oltp-in-dbms/
https://www.stitchdata.com/resources/oltp-vs-olap/