Continue in 2 seconds

What is a distributed data warehouse?

  • Joe Oates, Chuck Kelley
  • June 04 2003, 1:00am EDT


What is a distributed data warehouse?


Chuck Kelley’s Answer: If you believe a data warehouse is a single physical database, then a distributed data warehouse would be where there are different physical databases that work together as a single physical database (In other words, there is not difference between distributed data warehouse and distributed database). There are others who will say that the data marts unioned together would make up a distributed data warehouse. It depends on your definition.

Joe Oates’ Answer: A distributed data warehouse is a conglomeration of separate components that are connected via a network. The goal is to have these separate components appear as a single global data warehouse image.

In my experience the distributed data warehouse approach has not been successful. Please see my answer to the previous question regarding changing from and integrated to federated data warehouse approach.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access