Discuss the purpose of analyzing the transactions that have to be supported and describe the type of information you would collect and analyze.

      

Discuss the purpose of analyzing the transactions that have to be supported and describe the type of information you would collect and analyze.

  

Answers


KELVIN
You can’t make meaningful physical design decisions until you understand in detail the transactions that have to be supported. In analyzing the transactions, you’re attempting to identify performance criteria, such as:
•the transactions that run frequently and will have a significant impact on performance;
•the transactions that are critical to the operation of the business;
•the times of the day/week when there will be a high demand made on the database (called the peak load).
You’ll use this information to identify the parts of the database that may cause performance problems. At the same time, you need to identify the high-level functionality of the transactions, such as the columns that are updated in an update transaction or the columns that are retrieved in a query. You’ll use this information to select appropriate file organizations and indexes.

kalvinspartan answered the question on July 4, 2018 at 17:13


Next: Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.
Previous: Analyse why free markets often lead to large wage differentials

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions