Differences between oltp and olap

Question

Differences between oltp and olap?

Amit Mohanty · Answer

Check the below links https://www.geeksforgeeks.org/difference-between-olap-and-oltp-in-dbms/ https://www.stitchdata.com/resources/oltp-vs-olap/

Rajanikant Hawaldar · Answer

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.