MIS271 Lecture 7: ONLINE ANALYTICAL PROCESSING (OLAP)

• School: Deakin University
• Department: Business and Law
• Course: MIS271
• Professor: Mr. Jay Zeal

Document Summary

Data is collected and stored in databases, using online transaction processing (oltp) Oltp processes sets of commands (insert, update, delete) that are executed in sequence to complete a transaction. Multiple-command: transfer money from one account to another. Single command: update the name of a customer. Multi-command: transfer the registration of a car from the seller to a buyer: oltp processes data using transaction principles known as acid: Atomicity: all or nothing of the command set gets executed. Consistency: only correct/valid data are recorded; any failure will result in roll-back to the previous state of the data. Isolation: transactions remain isolated from each other when running and will not affect each other. Durability: the results of a completed transaction will be written to the database and will be saved: the main product of oltp practices is a (set of) valid databases. Patients database: the main considerations of oltp include: Small transactions, simple queries with limited table joins.