Design guidelines for data warehouse implementation
Answers
Answer:
Explanation:
1. Requirements analysis and capacity planning: In other projects, the first step in data warehousing involves defining enterprise needs, defining architecture, carrying out capacity planning and selecting the hardware and software tools. This step will involve consulting senior
management as well as the various stakeholders.
2. Hardware integration: Once the hardware and software have been selected, they need to be put together by integrating the servers, the storage devices and the client software tools.
3. Modelling: Modelling is a major step that involves designing the warehouse schema and views.
This may involve using a modelling tool if the data warehouse is complex.
4. Physical modelling: For the data warehouse to perform efficiently, physical modelling is
required. This involves designing the physical data warehouse organization, data placement, data
partitioning, deciding on access methods and indexing.
5. Sources: The data for the data warehouse is likely to come from a number of data sources. This
step involves identifying and connecting the sources using gateways, ODBC drives or other
wrappers.
6. ETL: The data from the source systems will need to go through an ETL process. The step of
designing and implementing the ETL process may involve identifying a suitable ETL tool vendor
and purchasing and implementing the tool. This may include customizing the tool to suit the needs
of the enterprise.