DISSCUSSION QUESTION

Feb 3rd, 2012
Studypool Tutor
Academy of Computer Education
Price: $10 USD

Tutor description

7.1 "Concurrency Control" Please respond to the following: There are times when a database is accessed by many users across the enterprise. Transaction logs can help maintain concurrency in a multiuser platform. Describe at least two business scenarios where COMMIT and ROLLBACK would be required. Describe how these functions would be essential for business continuity and concurrency control. Identify how these functions would enable an organization to recover from a database corruption event. Describe how locks could be used in order to qualify data transactions and enhance concurrency control. Suggest at least two business scenarios that would benefit from implementing locking methods. 7.2 "Optimization for Transactional Processing" Please respond to the following: Databases can grow in data structure and data capacity throughout time. At certain times, it is necessary to perform optimization techniques in order to ensure optimal performance of the database. Evaluate at least tw

Word Count: 722
Showing Page: 1/4
Business Scenarios where COMMIT and ROLLBACK are needed: Submit is utilized to roll out the changeless improvements in the database. Rollback is utilized as a part of case to undiscovered the progressions in the information base. Case in point; if one needs to exchange the sum from one record to an alternate record.( Alkhatib, G., & Labban, R. S.,2002).Then the Commit is utilized if all the exchanges are checked. At the same time if the exchanges are not weighed then all things considered it obliges checking every single exchange if any mistake is show there or any wrong exchange is made then Rollback can be utilized. Utilization of COMMIT and ROLL Back for business coherence and concurrency control: On the off chance that a database disappointment or pulverization happens, then the Rollback will give the concurrency control and business coherence. Utilization of ROLL Back for database recuperation occasion: There can be not kidding decimations in the database. A Rollback can be utilized to recoup the database and can change the database to its same state actually when there are various incorrect operations are performed on the database. Utilization of Locks for informati

Review from student

Studypool Student
" Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors