IS³ Existing academics

IS Data warehouses

Contains raw data that will require complex queries to arrive at decisions. We will speak of “information”.

Contains information useful for decision-making. We refer to this as “knowledge”.

Closed systems, operating independently.

Centralization of data from the organization’s various systems.

Relatively average data size.

Large volume of data.

Relational structure based on the entity-association model.

Dimensional structure based on the fact-dimension model.

Unintuitive understanding of data

Intuitive understanding of data.

Highly normalized tables

Non-standardized tables

High security of SGBG, which causes slow access to system data.

Once loaded into the system, access is quick.

Add, delete, modify operations

Only the add operation.

Only detailed and up-to-date Data

Includes detailed, up-to-date and historical data, summary data (aggregated, summarized).

Many tables, join which implies a long search time.

Fewer tables and joins, which implies an optimization of response time when using data.