Briefly describe four major components of the data warehousing process

What will be an ideal response?


• Data sources. Data are sourced from multiple independent operational "legacy" systems and possibly from external data providers (such as the U.S. Census).
Data may also come from an OLTP or ERP system.
• Data extraction and transformation. Data are extracted and properly transformed using custom-written or commercial ETL software.
• Data loading. Data are loaded into a staging area, where they are transformed and cleansed. The data are then ready to load into the data warehouse and/or data marts.
• Comprehensive database. Essentially, this is the EDW to support all decision analysis by providing relevant summarized and detailed information originating from many different sources.
• Metadata. Metadata include software programs about data and rules for organizing data summaries that are easy to index and search, especially with Web tools.
• Middleware tools. Middleware tools enable access to the data warehouse. There are many front-end applications that business users can use to interact with data stored in the data repositories, including data mining, OLAP, reporting tools, and data visualization tools.

Business

You might also like to view...

What top management values are most likely to lead to a growth orientation?

What will be an ideal response?

Business

Projects are often underfunded in the concept stage because:

A) The project requirements were deliberately understated. B) There is complete trust in project managers by top management so more resources can be asked for at any time. C) The project's goals are too clearly defined. D) The project's top management sponsor is too influential.

Business

Which of the following distributions is most often used to estimate the arrival pattern?

A) negative exponential B) normal C) Poisson D) Erlang E) beta

Business

Some courts have ruled that an alternative to "replacement cost less depreciation" should be used to determine the actual cash value of a property loss

Under this alternative, the value of property lost is determined by the price a willing buyer would pay a willing seller for the property in a free market. This method of determining actual cash value is called the A) intrinsic value method. B) valued policy method. C) fair market value method. D) forensic cost method.

Business