Explanation Database Deadlock: Database deadlock is a condition in which no data can be accessed as sites are held at halt due to locks created by many users for long time. Database lockout is a controlling method inbuilt within database software to ensure data consistency and accuracy while recording transactions. In a distributed database, transactions are recorded from various sites. For example, accountants from different sites want to update transactions in sales and orders table. Site A sends request to update rows in sales table and simultaneously Site B requests to update orders table. The database management system will lock Site B to access database until Site A completes its transaction. Database lockouts are different from database deadlocks in following manner: On the Basis Database lockout Deadlock Conflict Conflicts can be reduced in database lockout. Conflicts cannot be reduced in deadlock. Time for process Certain time for processing the session...

10th Edition

ISBN: 9781337619202

Author: Hall, James A.

Publisher: Cengage Learning,

See similar textbooks

Question

Chapter 9, Problem 5P

To determine

Determine the difference between database lockout and database deadlock. Illustrate an accounting example to explain the need database lockout. Also, determine the way in which deadlock gets created.

Expert Solution & Answer

Chapter 9 Solutions

Accounting Information Systems

Ch. 9 - Prob. 1RQ Ch. 9 - Prob. 2RQ Ch. 9 - Prob. 3RQ Ch. 9 - Prob. 4RQ Ch. 9 - Prob. 5RQ Ch. 9 - Prob. 6RQ Ch. 9 - Prob. 7RQ Ch. 9 - Prob. 8RQ Ch. 9 - Prob. 9RQ Ch. 9 - Prob. 10RQ

Ch. 9 - Prob. 11RQ Ch. 9 - Prob. 12RQ Ch. 9 - Prob. 13RQ Ch. 9 - Prob. 14RQ Ch. 9 - Prob. 15RQ Ch. 9 - Prob. 16RQ Ch. 9 - Prob. 17RQ Ch. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQ Ch. 9 - Prob. 20RQ Ch. 9 - Prob. 21RQ Ch. 9 - What is a user view?Ch. 9 - Prob. 23RQ Ch. 9 - Prob. 24RQ Ch. 9 - Prob. 25RQ Ch. 9 - Prob. 1DQ Ch. 9 - Prob. 2DQ Ch. 9 - Prob. 3DQ Ch. 9 - Prob. 4DQ Ch. 9 - Prob. 5DQ Ch. 9 - Prob. 6DQ Ch. 9 - Prob. 7DQ Ch. 9 - Prob. 8DQ Ch. 9 - Prob. 9DQ Ch. 9 - Prob. 10DQ Ch. 9 - Prob. 11DQ Ch. 9 - Prob. 12DQ Ch. 9 - Prob. 13DQ Ch. 9 - Prob. 14DQ Ch. 9 - Prob. 15DQ Ch. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQ Ch. 9 - Prob. 18DQ Ch. 9 - Prob. 19DQ Ch. 9 - Prob. 20DQ Ch. 9 - Prob. 1MCQ Ch. 9 - Prob. 2MCQ Ch. 9 - Prob. 3MCQ Ch. 9 - Prob. 4MCQ Ch. 9 - Prob. 5MCQ Ch. 9 - Prob. 6MCQ Ch. 9 - Prob. 7MCQ Ch. 9 - Prob. 8MCQ Ch. 9 - Prob. 9MCQ Ch. 9 - Prob. 10MCQ Ch. 9 - Prob. 11MCQ Ch. 9 - Prob. 12MCQ Ch. 9 - Prob. 13MCQ Ch. 9 - Prob. 14MCQ Ch. 9 - Prob. 15MCQ Ch. 9 - Prob. 16MCQ Ch. 9 - Prob. 17MCQ Ch. 9 - Prob. 18MCQ Ch. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2P Ch. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4P Ch. 9 - Prob. 5P Ch. 9 - Prob. 6P Ch. 9 - Prob. 7P Ch. 9 - Prob. 8P Ch. 9 - Prob. 9P Ch. 9 - Prob. 10P Ch. 9 - Prob. 11P Ch. 9 - Prob. 12P Ch. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14P Ch. 9 - Prob. 15P Ch. 9 - Prob. 16P Ch. 9 - Prob. 17P Ch. 9 - Prob. 18P Ch. 9 - Prob. 21P Ch. 9 - Prob. 22P Ch. 9 - Prob. 23P Ch. 9 - Prob. 24P

Knowledge Booster

Similar questions

Which of the following is false about accounting information systems? A. They provide reports that people analyze. B. They prevent errors and stop employees from stealing inventory. C. They are designed to gather data about the companys transactions. D. They consist of processes that involve input of data from source documents, processing, output, and storage.
Which of the following statements is NOT correct? a. EAMs capture transactions during processing without removing the application from service. b. EAMs support continuous monitoring of controls. c. EAMs have the potential to corrupt corporate databases d. EAMs decrease operational performance. e. All of the above are correct statements.

Recommended textbooks for you

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College