Translate

Tuesday, September 25, 2012

DATA WAREHOUSING AND MINIG ENGINEERING LECTURE NOTES--Mapping the data warehouse to a multiprocessor architecture

Mapping the data warehouse to a multiprocessor architecture
                        To manage large number of client requests efficiently, database vendor’s designed parallel hardware architectures by implementing multiserver and multithreaded systems. This is called interquery parallism in which different server threads handle multiple requests at the same time.

This can be implemented on SMP systems, where it increases throughput and allowed the support of more concurrent users.

Data warehouse can be mapped into different type of architectures as follows:

·         Shared memory architecture

·         Shared disk architecture

·         Shared nothing architecture

 
This architecture is simple to implement and the key idea is that a single RDBMS server can potentially utilize all processors, access all memory and access the entire database.

3 comments:

  1. awesome post presented by you..your writing style is fabulous and keep update with your blogs Informatica Online Course Bangalore

    ReplyDelete
  2. A superb meal, just one point is that the many of the dishes have a rich cream accompaniment and the richness of these does affect ones liver a little. The Sauvignon Blanc helped to cut it. Chef has now changed this menu for a new one, so do go and try it. He does this regularly according to the seasonal and local foods available. local self storage units

    ReplyDelete
  3. https://sachinplacement.blogspot.com/

    ReplyDelete