the difference

“The Difference Between Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP)” Please respond to the following: OLTP and OLAP are two of the common systems for the management of data. OLTP (Online Transaction Processing) is a category of systems that manages transaction processing. OLAP (Online Analytical Processing) is a BI (Business intelligence) tool. BI refers to computer-based methods for identifying and extracting useful information from business data. Research OLTP and OLAP.

1. Discuss the difference between online transaction processing (OLTP) and online analytic processing (OLAP), and their relationship with business intelligence, data warehousing, and data mining.

Engage the following resource(s) to get started.

DBMS – Transaction – https://www.tutorialspoint.com/dbms/dbms_transaction.htm, DBMS – Concurrency Control – https://www.tutorialspoint.com/dbms/dbms_concurrency_control.htm, Fundamental Knowledge on OLTP and OLAP? – https://www.youtube.com/watch?v=fdeJjX2qygk

PLEASE RESPOND TO CLASSMATE DISCUSSION WHETHER YOU AGREE OR NOT & A DETAILED WHY: OLTP is what I would call a typical DB lookup. It is pulling one or more groups of data that consist of task and perform no analysis. An example might be the sales numbers last week for a store. OLAP is may perform OLTPs, or physically import data from a file to ingest the data into variables within an analytics engine. The engine then produces information based on the data it ingested and analysis it is performing. Both processing engines rely on data that is typically stored in a data warehouse. OLTP is method for retrieving data and can be a data-mining tool. Business Intelligence (BI) is derived by performing an analysis of data collected from a data warehouse and presenting information to the user in the form of things like trends, or gaps.

 
Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"