question) an"integrated, time-variant, nonvolatile, subject-oriented repository of detail and summary data used for decision support and business analytics within an organization. These characteristics, which are discussed further in the section just after the definition, are not necessarily true of databases in general--though each could apply individually to a given one As a practical matter most databases are highly normalized, in part to avoid update anomalies. Data warehouses are highly denormalized for performance reasons. This is acceptable because their content is never updated, just added to Historical data are static What is an ODS? Operational Data Store is the database from which a business operates on an on going basis Differentiate among a dM. an ODS and an EDw An ODs(Operational Data Store)is the database from which a business operates on an ongoing basis Both an EDW and a data mart(dm)are data warehouses. An EDW(Enterprise Data Warehouse) is an all-encompassing dw that covers all subject areas of interest to the entire organization. a data mart is a smaller dw designed around one problem, organizational function, topic, or other suitable focus area 5. Explain the importance of metadata Metadata, " data about data, are the means through which applications and user access the content of a data warehouse, through which its security is managed and through which organizational management manages, in the true sense of the word,its information assets. Most database management systems would be unable to function without at least some metadata. Indeed the use of metadata, which enable data access through names and logical relationships rather than physical locations, is fundamental to the very concept of a DBms Metadata are essential to any database, not just a data warehouse. ( See answer to Review Question 2 of this section above Section 3.3 Review Questions Describe the data warehousing process The data warehousing process consists of the following steps 1. Data are imported from various internal and external sources Data are cleansed and organized consistently with the organizations needs Copyright C2018 Pearson Education, Inc.4 Copyright © 2018Pearson Education, Inc. question) an “integrated, time-variant, nonvolatile, subject-oriented repository of detail and summary data used for decision support and business analytics within an organization.” These characteristics, which are discussed further in the section just after the definition, are not necessarily true of databases in general—though each could apply individually to a given one. As a practical matter most databases are highly normalized, in part to avoid update anomalies. Data warehouses are highly denormalized for performance reasons. This is acceptable because their content is never updated, just added to. Historical data are static. 3. What is an ODS? Operational Data Store is the database from which a business operates on an on￾going basis. 4. Differentiate among a DM, an ODS, and an EDW. An ODS (Operational Data Store) is the database from which a business operates on an ongoing basis. Both an EDW and a data mart (DM) are data warehouses. An EDW (Enterprise Data Warehouse) is an all-encompassing DW that covers all subject areas of interest to the entire organization. A data mart is a smaller DW designed around one problem, organizational function, topic, or other suitable focus area. 5. Explain the importance of metadata. Metadata, “data about data,” are the means through which applications and users access the content of a data warehouse, through which its security is managed, and through which organizational management manages, in the true sense of the word, its information assets. Most database management systems would be unable to function without at least some metadata. Indeed, the use of metadata, which enable data access through names and logical relationships rather than physical locations, is fundamental to the very concept of a DBMS. Metadata are essential to any database, not just a data warehouse. (See answer to Review Question 2 of this section above.) Section 3.3 Review Questions 1. Describe the data warehousing process. The data warehousing process consists of the following steps: 1. Data are imported from various internal and external sources 2. Data are cleansed and organized consistently with the organization’s needs