BTMA 331 Final question n answers 2023

BTMA 331 FinalData Warehouse a subject oriented, integrated, time-variant, non-updatable collection of data used in support of management decision-making subject-oriented e.g. customers, patients, students, products integrated consistent naming conventions, formats, encoding structures; from multiple data sources time-variant can study trends and changes non-updatable read only, periodically refreshed data mart a data warehouse that is limited in scope need for data warehousing 1) a business requiress an integrated, company-wide view of high quality info 2) the information systems department must separate informational from operational systems to improve performance dramatically in managing company data issues with company wide view - inconsistent key structures - synonyms - free-form vs structured fields - inconsistent data values - missing data heterogeneous data can be problematic when developing a single corporate view of data organizational trends motivating data warehouses - No single system of records - Multiple systems not synchronized - Organizational need to analyze activities in a balanced way - CRM, SRM operational system a system that is used to run a business in real time, based on current data; also cal