It is embarrassing that I've spent all these decades working with computers and I had never heard the term "Informatics" before until starting a new contract this past week?! :eek:
OLAP vs OLTP
OLAP is the analyse (the A) of a huge mass of data in a big data warehouse. 100s of millions of rows of data might get analysed
OLTP is the insert of one or two lines of data at a time, or a query to find the available items of a given type, the database might only be a couple of thousand rows. An online shop, or your supermarket use OLTP. The database is updated a little bit at a time, every second, or dozens of times per second. You buy a camera, your details and the single item bought are added at that moment.
A data warehouse might only get updated once a week, but the update could be a couple of million rows being added in one go. It could be all the sales that week in all Walmarts across the country being added. Not your individual sale as it happens.
Yes, that part I understand.
OLAP is NOT another name for a data warehouse, it is a technique for analysing tens of millions of rows of data and extracting useful info from the data warehouse. So they do go together.
Okay, but OLTP would never go with a Data Warehouse, right?
And OLAP would never go with a Relational Database, right?
The decision support bit is let's present this info on widget sales country wide, in ways that we can spot trends, and help the company make a decision. This is business information, it supports a company wide decision. You or I just want to know the cost of that one camera and the postage of it. But the company needs a wider picture than where I bought this one or that one on thursday.
I understand that, but how does BI differ from DSS differ from Executive Support Systems (ESS)?
(Some say ESS and DSS are under BI.)
Does that help?
We are getting there!