Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATAWAREHOUSES 4.2 - Coggle Diagram
DATAWAREHOUSES 4.2
OLTP
-
-
They handle a large number of short, simple transactions, such as inserting, updating, or deleting records
-
-
-
OLAP
-
-
-
Used to perform complex, non-predefined queries over large volumes of historical and aggregated data
OLAP users are typically decision-makers who need to explore the data to find
patterns, trends, and insights
Read only, non time-critical but enable dept-analysis
-
-
-