Question

database of operating system Purpose: To help you know about the main concepts of concurrency control...

  • database of operating system


    Purpose:

    To help you know about the main concepts of concurrency control and recovery.

    Topic of Discussion:

    According to the conflicts and failure in transactions processing, the need of concurrency control and recovery appeared.

    Discuss the differences between concurrency control and recovery in terms of:

    · The purposes.

    · The algorithms.

    · The problems.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
  1. Concurrency Control: Without losing the consistency of a database, when we do 2 transactions simultaneously, then it is called as concurrency control.
  2. Recovery: When we recover data in DBMS, lost due to any kind of failures such as hardware, electronic, power supply etc successfully, then it is called as recovery.
  3. Concurrency Control: The concurrency algorithm ensures that the transaction which we are doing, happens automatically.
  4. Recovery: The purpose of the recovery algorithm is, if some task is failed due to some reason and the task is unable to finish, then the recovery algorithm must remove/eliminate the effects of the transaction partially completed.
Add a comment
Know the answer?
Add Answer to:
database of operating system Purpose: To help you know about the main concepts of concurrency control...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • This is about database system. Thank you. Question A1 You are given with three Oracle tables,...

    This is about database system. Thank you. Question A1 You are given with three Oracle tables, namely, Program, Channel and Booking, as shown in Tables 1 to 3. PROGRAM_ID PROGRAM_NAME DURATION 2012022 Dragon Dance 2014063 Haunted House 2016005 CID 2017172 Kung Fu Master 2018322 Family Affair 2019006 Hong Kong Sites 2019113 2019 Singing Contest 25 58 45 28 68 120 75 Table 1: Program CHANNEL_NO CHANNEL_NAME TVR-1 Rediffusion Channel 1 TV-P Television Pearl Channel TV-G Television Gold Channel Table 2:...

  • Explain what enterprise resource planning (ERP) systems. Outline several of their key characteristics. Describe in reasonable...

    Explain what enterprise resource planning (ERP) systems. Outline several of their key characteristics. Describe in reasonable detail how a company leverages an ERP system and how its operations are improved after installing an ERP system like SAP. Explain how a supply chain management system helps an organization make its operations more efficient What is Upstream and Downstream management of the supply chain? Explain the concept of “Supply Network”, its benefits, and how technology made this concept available Explain the difference...

  • The discussion: 150 -200 words. Auditing We know that computer security audits are important in business....

    The discussion: 150 -200 words. Auditing We know that computer security audits are important in business. However, let’s think about the types of audits that need to be performed and the frequency of these audits. Create a timeline that occurs during the fiscal year of audits that should occur and “who” should conduct the audits? Are they internal individuals, system administrators, internal accountants, external accountants, or others? Let me start you: (my timeline is wrong but you should use some...

  • This is all of the information I have: Now that you have reviewed information about Cover...

    This is all of the information I have: Now that you have reviewed information about Cover 2 Cover, you are ready to begin the first step in the accounting cycle, recording transactions. On this page of the practice set, you are asked to record transactions that occurred during the first week of June into the company's journals and post the appropriate entries to the ledger accounts. The following transactions occurred throughout the first week of June: Week 1 Date Transaction...

  • This is all of the information I have: Now that you have reviewed information about Cover...

    This is all of the information I have: Now that you have reviewed information about Cover 2 Cover, you are ready to begin the first step in the accounting cycle, recording transactions. On this page of the practice set, you are asked to record transactions that occurred during the first week of June into the company's journals and post the appropriate entries to the ledger accounts. The following transactions occurred throughout the first week of June: Week 1 Date Transaction...

  • 1. Focusing on only the inpatient care cost (i.e., ignoring operating room costs), what is the...

    1. Focusing on only the inpatient care cost (i.e., ignoring operating room costs), what is the cost of a TAH (non-oncology) under each of the cost accounting systems? A tuboplasty? A TAH (oncology)? What accounts for the differences? Croswell University Hospital This report doesn't describe where our costs are generated. We're applying one standard to all patients, regardless of their level of care. What incentive is there to identify and account for the costs of each type of procedure? Unless...

  • DQ1. What is an Audit Work Program (some call it Audit Program)? The audit work program...

    DQ1. What is an Audit Work Program (some call it Audit Program)? The audit work program - Email Surveillance Audit Program – What is the structure and contents including various audit steps. Find 1-2 steps in the audit program where the audit software can be used. How can audit software be used to gather evidence?. (the Audit program (Email Surveillance Audit Program details is attached). DQ3. Review the contents of the Audit Manual of Office of University Audits at University...

  • Need help, numbers 3-6 please show work. and fill out table of chemicals for all chemical...

    Need help, numbers 3-6 please show work. and fill out table of chemicals for all chemical used. calculate mmol in the table as well show work please and each of these must be listed in its own row. There are 10 column headings: IUPAC name OR common name, structure, CAS number (Chemical Abstract Service number) molecular mass, melting point (if applicable), boiling point (if applicable), solubility (in water, if applicable), density, amounts to be used in the experiment, and the...

  • Introduction: A manufacturing company that possesses many complexities can be highly challenged when maintaining production goals...

    Introduction: A manufacturing company that possesses many complexities can be highly challenged when maintaining production goals and standards in conjunction with a major organizational change. Garment manufacturing is a complex industry for many reasons. The product line is a complex array of styles, seasons, varying life cycles and multidimensional sizing. Many sewn product firms are viewing TQM as the appropriate strategy to meet the double demand of competition and quality; however, many companies are finding sustaining their TQM adoption decision...

  • please Identify the key points and main thesis of the article 2. Describe the skills you...

    please Identify the key points and main thesis of the article 2. Describe the skills you will need to develop to manage the hospital of the future. use critical analysis doing these questions Suggestion for writing assignmemnt make believe the reader has never read the article -what are the key points you would want the reader to know in order to understand the hospital of the future. In addition, managers, executives do not have time to read--so again what key...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT