ADM 1370 Chapter Notes - Chapter 1: Database Design, Enterprise Performance Management, Online Analytical Processing

• School: University of Ottawa
• Department: Administration
• Course: ADM 1370
• Professor: Umar Ruhi

Document Summary

Data management technologies that keep users informed and support the various business demands: Over the years, data-processing techniques, processing power, and enterprise performance management capabilities have evolved over the years. Integrate with data collection systems such as tps (transaction-processing systems and business applications; store data in an organized way; and provide facilities for accessing and managing that data. Regional database standard database adopted by most enterprises. Store data in tables consisting of columns and rows. Provide access to data using a declarative language structured query. Declarative languages simplify data access by requiring that users only specify what data they want to access without defining how access will be achieved. Functions performed by a dbms to help create such a view are: Data filtering and profiling process and store data efficiently, inspect the data for errors, inconsistencies, redundancies and incomplete info. Data integrity and maintenance correct, standardize, and verify the consistency and integrity of the data.