A poorly performing database will have a domino effect on all of the applications that it supports. What can be done during a database planning stage to help ensure optimal performance?

computer science

Description

Question 1

1#A poorly performing database will have a domino effect on all of the applications that it supports. What can be done during a database planning stage to help ensure optimal performance? What are common causes of poor performance in databases? Describe how establishing a performance baseline is a necessary process in analyzing database health.

 

Write 750 words with at least 8 scholarly peer reviewed citations and use current APA format for intext citations and reference page. 

 

 

 

Question 2

 

2#Poor planning in database design can result in severe blocking or even deadlocks.
Describe in detail the 4 ACID transaction properties. Describe the difference between transaction locks and deadlocks. Describe a scenario in which a deadlock might occur.

 

Write 750 words with at least 8 scholarly peer reviewed citations and use current APA format for intext citations and reference page. 

 


Related Questions in computer science category