What are the most common approaches in data warehousing?
- What are the three approaches to data query data warehouses?
- What is top-down approach and bottom-up approach in data warehousing?
- What are the two most popular methodologies in data warehouse design?
- Which approach is more complex in data warehouse?
What are the three approaches to data query data warehouses?
In a traditional architecture there are three common data warehouse models: virtual warehouse, data mart, and enterprise data warehouse: A virtual data warehouse is a set of separate databases, which can be queried together, so a user can effectively access all the data as if it was stored in one data warehouse.
What is top-down approach and bottom-up approach in data warehousing?
Bottom-up approach: First, the data is extracted from external sources (same as happens in top-down approach). Then, the data go through the staging area (as explained above) and loaded into data marts instead of datawarehouse. The data marts are created first and provide reporting capability.
What are the two most popular methodologies in data warehouse design?
The two most popular data modeling techniques for data warehousing are Entity-Relational and Dimensional modeling.
Which approach is more complex in data warehouse?
Project Deadline: Designing a normalized data model is comparatively more complex than designing a denormalized model. This makes the Inmon approach a time-intensive process. Therefore, if you have less time for delivery, then opt for the Kimball method.
Related Questions
-
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago