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.
