What is the conceptual difference between OLAP and OLTP?

Asked

Viewed 11 times

0

Good afternoon, everybody, all right?

What is the conceptual difference between OLTP and OLAP?

Contextualizing:

I am starting my studies in data analysis and I am with a doubt that I could not clarify even after several videos on youtube and searches... What I know so far: OLTP is aimed at transactions, where it is customary to add or delete records frequently, such as in a stock, current account, cash flow, etc. OLAP is aimed at historical data analysis, compare dimensions, etc., such as the amount of products sold per month or the evolution of an individual’s bank balance over time.

But there are some things I haven’t quite figured out yet:

1. OLTP and OLAP are tools integrating with a database??? For example, ERP for OLTP and Tableau for OLAP? Both interact with a database but one inserts and deletes records while the other retrieves the records and only analyzes?

2. Or OLTP and OLAP are architectures of a database? While one is organized extremely normalized and the other... (I don’t even know what kind of architecture OLAP would be)

3. If they are tools that interact with the database, both can be used in the same DBMS? For example, the studies I’ve done so far involve the Mysql DBMS, where I learned SQL, from what I understand, from the normalization one has an approximate result with OLTP. What about OLAP? Can I use it the same way as OLTP? Or do I need another type of data organization, another BD, etc?

I’m not in the IT area, I’m starting to learn about databases, BI software and languages (python) in recent times, so I don’t know the correct terms yet and I may not express myself very well, but I hope I’ve been clear in my doubts,

From now on, thank you!

  • 1

    I think that answers: https://answall.com/q/281576/101 Also useful:https://answall.com/a/22120/101

  • Maniero, yes, answered 90%, only I still have a question I could not understand: There is no difference of DBMS then for each application? - As your answer brings the solution, if you want to change to a reply, so I can mark as solution.

  • 1

    No, it’s the way you work, it’s the kind of operation you do, no matter where you do it. If you answer, you better mark as duplicate, okay?

  • OK! Thanks Maniero!! You can mark it as duplicate

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.