Skip to content

DW Architecture: The Streamed Data Repository

April 11, 2013

As specified in the DW Architecture block diagram, the Streamed Data Repository (SDR) belongs to the Data Warehouse Architecture.

The discrete data generated by the Streamed Data Management System (SDMS) is stored in the SDR as periodic snapshot fact tables and its associated dimensions. This fact tables are predictable dense and can get large. Further reduction can be done by aggregation.

The feeds from the SMDA are received in semi real time; depending on the nature of the streamed data, the rows (grain) in the fact tables can be mapped to one of more time windows on the SDMS.

The data in the SDR is normally used for long time observations or thread identification and analysis. The data in the SDMS is used for real time monitoring.

 

Read Further

The Data Warehouse Architecture

Advertisements

From → DW Architecture

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: