Capella University Advanced Database Concepts Discussion

Having Trouble Meeting Your Deadline?

Get your assignment on Capella University Advanced Database Concepts Discussion  completed on time. avoid delay and – ORDER NOW

Do My Paper

Write 350 words

Transaction management and concurrency control are the two most important functions of database management systems (DBMS) to ensure the database remains in a consistent state when many users concurrently access the database, or when any system component (hardware, software, or both) experiences a failure. First, please study the relevant content in the course materials, and investigate the Library and Internet for the definitions and functions of transaction management and concurrency control. Then, based on the results of your research, answer the following questions. Assume that the nested transaction is used in your database.

• What will be the pros and cons in the following cases?
  • The conservative concurrency control method is used
  • The optimistic concurrency control method is used
• Please provide examples as necessary.