This topic contains a solution. Click here to go to the answer

Author Question: Explain the term detailed and/or summarized data in the following data warehouse definition, and ... (Read 172 times)

CharlieWard

  • Hero Member
  • *****
  • Posts: 578
Explain the term detailed and/or summarized data in the following data warehouse definition, and elaborate on the reasons for storing detailed and aggregated data in the data warehouse:The data warehouse is a structured repository of integrated,
 
  subject-oriented, enterprise-wide, historical, and time-variant data. The purpose of the data warehouse is the retrieval of analytical information. A data warehouse can store detailed and/or summarized data.

Question 2

What tools are available for supporting BPR?
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

aprice35067

  • Sr. Member
  • ****
  • Posts: 337
Answer to Question 1

A data warehouse, depending on its purpose, may include detailed data or summary data, or both. The detailed data is also called atomic data or transaction-level data. For example, a table in which each ATM transaction is recorded as a separate record contains detailed data (i.e., atomic or transaction-level data). On the other hand, a table in which a record represents calculations based on multiple instances of transaction-level data contains summarized data at a coarser level of detail. For example, a summarized data record could represent the total amount of money withdrawn in one month from one account via an ATM. A data warehouse that contains the data at the finest level of detail is the most powerful, because all summaries can be calculated from it and stored if they are to be used repeatedly. However, there are cases when storing all of the analytical data at the transaction-level of detail for large time horizons is cost prohibitive. For example, for some organizations, the financial resources necessary for the specialized hardware and software required to store and process such enormous data sets may be out of reach. Also, in some other cases, organizations may decide that for some subjects of analysis, summarizations are adequate and transaction-level detail data is not necessary. In cases when the company is not able or does not want to have all of its required analytical information at the finest level of detail, the data for some or all (depending on the particular situation) of the subjects of analysis in the data warehouse is kept only at a certain level of summarization.

Answer to Question 2

There is a growing list of tools on the market today that are designed to make BPR easier and more efficient. These software packages help the team to analyze the dynamics of existing processes and can provide greater insight into how well the redesigned processes meet the project goals. Some packages are more comprehensive than others and have support for all phases of the BPR process.




CharlieWard

  • Member
  • Posts: 578
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it


Perkypinki

  • Member
  • Posts: 339
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

For a complete list of videos, visit our video library