MGIS 317 Chapter Notes - Chapter 3: Online Transaction Processing, Data Integrity, Data Warehouse

• School: University of Calgary
• Department: Management Information Systems
• Course: MGIS 317
• Professor: Catherine Heggerud

Document Summary

Analytics integrated use of technology tools and statistical techniques to create fact-based decisions: business intelligence; collective info about customers and competitors that allows for effective, important strategic decisions (a component of the overall framework of analytics) Two types of information processing: online transaction processing (oltp) deals with info. Gathering and processing input info to update existing info. Directly supporting technology tools; operational databases and dbmss. Includes operational databases; store valuable info on product, advertising and customers that forms the basis for bi: online analytical processing (olap) deals with business intelligence. Directly supporting technology tools; data warehouses and data-mining tools. Includes data warehouses; contain info from operational databases to support decision making. Database collection of info that you organize according to the logical structure. Non-relational database : next generation, distributed, open source, horizontally scalable. Relational database uses a series of logically related tables/ les to organize info in the form of a database.