Databases and data warehouses
It is now time to talk about the data warehouse and databases. We will have a look at their theoretical structure and some practical technology available on the market to build these kinds of instruments:
What is a data warehouse, and how is it different from a simple database?
A data warehouse is a software solution aimed at storing usually great amounts of data properly related among them and indexed through a time-related index. We can better understand this by looking at the data warehouse's cousin: the operational database.
These kinds of instruments are usually of small dimensions, and aimed at storing and inquiring data, overwriting old data when new data is available. Data warehouses are therefore usually fed by databases, and stores data from those kinds of sources ensuring a historical depth to them and read-only access from other users and software applications. Moreover, data warehouses are usually employed at a company level, to store, and make available...