HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Transferring Data from OLTP to OLAP databases

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fromdatabasestransferringolapoltpdata

Problem

Systems that have both OLTP and OLAP databases periodically move data from the OLTP database to the OLAP database, so that reports can be generated based on the OLAP database.

What's the official term for this process and is there an overview of this process online?

Solution

It is mostly referred as ETL process (extraction, transformation, and load).

Here are a link of MSDN article on Transforming OLTP Data to OLAP Data Warehouses. It is an old article but the same concept applied.

Context

StackExchange Database Administrators Q#45671, answer score: 6

Revisions (0)

No revisions yet.