Describe, with examples, the types of problem that can occur in a multi-user environment when concurrent...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Describe, with examples, the types of problem that can occur in a multi-user environment when concurrent access to the database is allowed. Give full details of a mechanism for concurrency control that can be used to ensure that the types of problem discussed in Question 4 (a) cannot occur. Show how the mechanism prevents the problems illustrated from occurring. Discuss how the concurrency control mechanism interacts with the transaction mechanism. Describe, with examples, the types of problem that can occur in a multi-user environment when concurrent access to the database is allowed. Give full details of a mechanism for concurrency control that can be used to ensure that the types of problem discussed in Question 4 (a) cannot occur. Show how the mechanism prevents the problems illustrated from occurring. Discuss how the concurrency control mechanism interacts with the transaction mechanism.
Expert Answer:
Answer rating: 100% (QA)
In a multiuser environment where concurrent access to a database is allowed several problems related to data consistency integrity and isolation can occur These problems are often referred to as concu... View the full answer
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these databases questions
-
The average Swedish household spent its disposable income (i.e., budget) on the following categories of goods and services: Category 1. Food and non-alcoholic beverages 2. Alcoholic beverages and...
-
Short statements reflecting various personality traits which individuals rate on the degree to which they are self-descriptive are referring to as what ? Provide brief explanation.
-
1. Identify four main points that would be included in a contract of employment. 1.1 Identify the main points of contracts of employment 1.2 Identify the main points of legislation affecting...
-
The reconciling item in a bank reconciliation that will result in an adjusting entry by the depositor is: (a) outstanding checks. (b) deposit in transit. (c) a bank error. (d) bank service charges.
-
(a) As the solid metal disk in Figure 23-37 swings to the right, from the region with no field into the region with a finite magnetic field, is the induced current in the disk clockwise,...
-
The statement of financial position of Delacosta Corporation as at December 31, 2017, is as follows: Note 1: Goodwill in the amount of $70,000 was recognized because the company believed that the...
-
Equilibrium for extraction of acetic acid from 3-heptanol into water at \(25^{\circ} \mathrm{C}\) is \(\mathrm{y}=1.208 \mathrm{x}\), where \(\mathrm{y}=\) weight fraction acetic acid in water and...
-
Jorgansen Lighting, Inc., manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external...
-
The carrying value of Quail's $340,000 face value bonds is $327,300. If the bonds are redeemed at 103, what would be the amount Quail would pay its bondholders? Select answer from the options below...
-
The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral. The company wants to run TV ads promoting its cruises to high-income men, high-income women, and retirees. The...
-
You are interested in investing in a company that expects to grow steadily at an annual rate of 6 percent for the foreseeable future. The firm will pay a dividend of $2.30 next year. If your discount...
-
Ryan Lawrence's regular hourly rate is $15. He receives 1 times the regular rate for any hours worked over 40 a week and double the rate for work on Sunday. During the past week, Lawrence worked 8...
-
A paralegal friend at another firm calls and asks you details on personal injury cases. Can you discuss the details of Mrs. Munch's case?
-
Suppose that A-D + E and that D/A = 0.76. Solve for D/E. Suppose that S/A = 4.7 and N/S = 0.10. Solve for N/A. Suppose A - D= E, that N = 7,545,000, E/A = 0.49 and N/E = 0.42. Compute D/A.
-
A consulting firm has two departments, Corporate and Government. Computer support is common to both departments. The cost of computer support is $14.18 million. The following information is given:...
-
2. Write the equivalent assembly code if you were to translate from C to Assembly: for (i=0; i <10; i++) sum += i;
-
Discuss the influence of the institutional structure on the form and content of financial statements and describe how financial data are assembled and integrated onto an articulated set of financial...
-
2. Assume a person bends forward to lift a load "with his back" as shown in Figure P12.42a. The person's spine piv- ots mainly at the fifth lumbar vertebra, with the principal supporting force...
-
Discuss the items an auditor communicates at the end of the audit to those charged with governance.
-
Lisa Curtis is documenting the purchasing and cash payments processes at Hardies Wholesaling, Inc. (HWI), a company in Iowa. HWI distributes garden and landscaping items such as pots, furniture,...
-
Explain how the standard audit report on the financial statements would be modified if reference is made to a component auditor.
-
Which of the following matches is performed in evaluated receipt settlement (ERS)? a. the vendor invoice with the receiving report b. the purchase order with the receiving report c. the vendor...
-
Which of the following is true? a. ERS systems use disbursement vouchers. b. Setting up petty cash as an imprest fund violates segregation of duties. c. The EOQ formula is used to identify the...
-
Which method would provide the greatest efficiency improvements for the pur chase of noninventory items such as miscellaneous office supplies? a. bar-coding c. procurement cards b. EDI d. EFT
Study smarter with the SolutionInn App