tailieunhanh - Lecture Database Systems - Lecture 30

After completing this chapter, students will be able to: Transaction-processing monitors, transactional workflows, electronic commerce, high-performance transaction systems, real-time transaction systems, and long-duration transactions. | CSC271 Database Systems Lecture # 30 Summary: Previous Lecture Normalization summary/example Remaining steps/activities in building logical data model Physical database design Translate logical data model for target DBMS Physical Database Design Methodology Translate logical data model for target DBMS Design base relations Design representation of derived data Design general constraints Design file organizations and indexes Analyze transactions Choose file organizations Choose indexes Estimate disk space requirements Design user views Design security mechanisms Consider the introduction of controlled redundancy Monitor and tune the operational system Physical Database Design Methodology Design file organizations and indexes To determine optimal file organizations to store the base relations and the indexes that are required to achieve acceptable performance; that is, the way in which relations and tuples will be held on secondary storage The types of file organization available are dependent on the target DBMS The DB designer must understand the typical workload that database must support Physical Database Design Methodology Analyze transactions To understand the functionality of the transactions that will run on the database and to analyze the important transactions Attempt to identify performance criteria, such as: Transactions that run frequently and will have a significant impact on performance Transactions that are critical to the business Times during the day/week when there will be a high demand made on the database (called the peak load) Physical Database Design Methodology Analyze transactions Use this information to identify the parts of the database that may cause performance problems Also need to know high-level functionality of the transactions, such as: Attributes that are updated Search criteria used in a query Use this information to select appropriate file organization Physical Database Design Methodology Analyze transactions Difficult to estimate all | CSC271 Database Systems Lecture # 30 Summary: Previous Lecture Normalization summary/example Remaining steps/activities in building logical data model Physical database design Translate logical data model for target DBMS Physical Database Design Methodology Translate logical data model for target DBMS Design base relations Design representation of derived data Design general constraints Design file organizations and indexes Analyze transactions Choose file organizations Choose indexes Estimate disk space requirements Design user views Design security mechanisms Consider the introduction of controlled redundancy Monitor and tune the operational system Physical Database Design Methodology Design file organizations and indexes To determine optimal file organizations to store the base relations and the indexes that are required to achieve acceptable performance; that is, the way in which relations and tuples will be held on secondary storage The types of file organization available are .