Computer Science 1032A/B Lecture Notes - Lecture 8: Online Transaction Processing, Decision-Making, Data Mining

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Louis Magguilli

Document Summary

Decision making is a daily occurrence for business managers. Factors making business decisions challenging: uncertainty and complexity o. Exponential growth: both inside and outside of organizations, used to improve decision making. Allows for a better understanding of the customers. Incorporate this data into decision making o o. Data quality (processed) data from operational systems can be used for: basic reports o. Raw data unsuitable for sophisticated reporting or data mining. Online transaction processing (oltp) system: collects data electronically, processes the transactions online. Backbone of all functional, cross-functional, and interorganizational systems in an organization. Oltp systems support decision making: provides raw information about transactions, provides information about status for an organization. Real-time processing: transactions are entered and processed immediately upon entry. System waits until it has a batch of transactions before the data are processed and the information is updated. Example: transfer of all daily branch transactions to the central office for processing.