Friday, September 24, 2010

what is dimensional data store (DDS)?

A DDS is a database that stores the data warehouse data in a different format than OLTP.

The reason for getting the data from the source system into the DDS and then querying the DDS instead of querying the source system directly is that in a DDS the data is arranged in a dimensional format that is more suitable for analysis.

The second reason is because a DDS contains integrated data from several source systems.

and we can take risk of querying source systems... source systems may go down

1 comment:

  1. Find Your Perfect Casino - Dr.MCD
    Find your perfect 시흥 출장샵 casino 안성 출장안마 on Dr.MCD. Discover the best slots, table games, video 울산광역 출장샵 poker and 의왕 출장샵 so much more. Try the games and live games 오산 출장안마 on your smartphone,

    ReplyDelete