FIT2094 Lecture 12: FIT2094 Lec 12 Notes
W12: Data Current Trends!
Usage of database !
▪Example of a supermarket ▪Decision making !
–Operational level"
•When do we need to re-stock X-item? !
–Strategic and tactical level"
•Is there any branch that performs worse than the state average? !
•What is the total sales made by each state each year and across a number of years?"
•What a particular customer is interested in or would be interested in near-future? !
Operational data !
•$– %Mostly stored in relational database !
•$– %Optimized to support transactions representing daily operations !
•$– %Example: "
– How many students enrolled in FIT2094? !
▪ Decision support data differs from operational data in three main areas: !
•$– %Time span !
•$– %Granularity !
•$– %Dimensionality !
•$– %Example: "
– What is the total number of students in the foundation units in each year (subtotal of the two
semesters numbers) and the total across years, across a single unit. !
Scaling !
▪ How do we scale current relational systems? !
▪ SQL designed for data base as a single physicalentity !
•$– %Purchase bigger "boxes": costly and has real limits !
•$– %Increase the number of processors, yielding parallel "
computation/database with complex issues to handle !
•$– %Distribute database– challenges to maintainACID transaction principles and issues of
availability/consistency !
•$Conventional RDBMS will continue play an important and significant role in OLTP (Online
Transactions Processing) "
find more resources at oneclass.com
find more resources at oneclass.com