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
- Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.(Solved)
Discuss some of the main reasons for selecting a column as a potential candidate for indexing. Give examples to illustrate your answer.
Date posted: July 4, 2018. Answers (1)
- When would you not add any indexes to a table?(Solved)
When would you not add any indexes to a table?
Date posted: July 4, 2018. Answers (1)
- Having identified a column as a potential candidate, under what circumstances would you decide against indexing it? (Solved)
Having identified a column as a potential candidate, under what circumstances would you decide against indexing it?
Date posted: July 4, 2018. Answers (1)
- Describe the access control facilities of SQL.(Solved)
Describe the access control facilities of SQL.
Date posted: July 4, 2018. Answers (1)
- Discuss the difference between system security and data security(Solved)
Discuss the difference between system security and data security
Date posted: July 4, 2018. Answers (1)
- Explain the meaning of denormalization.(Solved)
Explain the meaning of denormalization.
Date posted: July 4, 2018. Answers (1)
- Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer(Solved)
Describe the two main approaches to partitioning and discuss when each may be an appropriate way to improve performance. Give examples to illustrate your answer
Date posted: July 4, 2018. Answers (1)
- What factors can be used to measure efficiency?(Solved)
What factors can be used to measure efficiency?
Date posted: July 4, 2018. Answers (1)
- State and discuss how the four basic hardware components interact and affect system performance(Solved)
State and discuss how the four basic hardware components interact and affect system performance
Date posted: July 4, 2018. Answers (1)
- How should you distribute data across disks?(Solved)
How should you distribute data across disks?
Date posted: July 4, 2018. Answers (1)
- Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?(Solved)
Compare and contrast a DDBMS with distributed processing. Under what circumstances would you choose a DDBMS over distributed processing?
Date posted: July 4, 2018. Answers (1)
- Discuss the advantages of a DDBMS(Solved)
Discuss the advantages of a DDBMS
Date posted: July 4, 2018. Answers (1)
- Discuss the disadvantages of DDBMS(Solved)
Discuss the disadvantages of DDBMS
Date posted: July 4, 2018. Answers (1)
- Describe the expected functionality of a replication server.(Solved)
Describe the expected functionality of a replication server.
Date posted: July 4, 2018. Answers (1)
- Discuss the Update-anywhere (symmetric replication) ownership in replication(Solved)
Discuss the Update-anywhere (symmetric replication) ownership in replication
Date posted: July 4, 2018. Answers (1)
- Discuss the workflow ownership as portrayed in replication(Solved)
Discuss the workflow ownership as portrayed in replication.
Date posted: July 4, 2018. Answers (1)
- Discuss the master/slave type of ownership model in replication(Solved)
Discuss the master/slave type of ownership model in replication
Date posted: July 4, 2018. Answers (1)
- Give a definition of an OODBMS.(Solved)
Give a definition of an OODBMS.
Date posted: July 4, 2018. Answers (1)
- Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse(Solved)
Give a definition of a data warehouse. Discuss the benefits of implementing a data warehouse
Date posted: July 4, 2018. Answers (1)
- Describe the characteristics of the data held in a data warehouse.(Solved)
Describe the characteristics of the data held in a data warehouse.
Date posted: July 4, 2018. Answers (1)