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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access