Matches in DBpedia 2016-04 for { <http://dbpedia.org/resource/Record_locking> ?p ?o }
Showing triples 1 to 40 of
40
with 100 triples per page.
- Record_locking abstract "Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.The classic example is demonstrated by two bank clerks attempting to update the same bank account for two different transactions. Clerks 1 and 2 both retrieve (i.e., copy) the account's record. Clerk 1 applies and saves a transaction. Clerk 2 applies a different transaction to his saved copy, and saves the result, based on the original record and his changes, overwriting the transaction entered by clerk 1. The record no longer reflects the first transaction, as if it had never taken place.A simple way to prevent this is to lock the file whenever a record is being modified by any user, so that no other user can save data. This prevents records from being overwritten incorrectly, but allows only one record to be processed at a time, locking out other users who need to edit records at the same time.To allow several users to edit a database table at the same time and also prevent inconsistencies created by unrestricted access, a single record can be locked when retrieved for editing or updating. Anyone attempting to retrieve the same record for editing is denied write access because of the lock (although, depending on the implementation, they may be able to view the record without editing it). Once the record is saved or edits are canceled, the lock is released. Records can never be saved so as to overwrite other changes, preserving data integrity.In database management theory, locking is used to implement isolation among multiple database users. This is the \"I\" in the acronym ACID.A thorough and authoritative description of locking was written by Jim Gray.".
- Record_locking wikiPageID "689470".
- Record_locking wikiPageLength "6895".
- Record_locking wikiPageOutDegree "17".
- Record_locking wikiPageRevisionID "647556070".
- Record_locking wikiPageWikiLink ACID.
- Record_locking wikiPageWikiLink Bank.
- Record_locking wikiPageWikiLink Bank_account.
- Record_locking wikiPageWikiLink Category:Concurrency_control.
- Record_locking wikiPageWikiLink Category:Transaction_processing.
- Record_locking wikiPageWikiLink Concurrency_(computer_science).
- Record_locking wikiPageWikiLink Data_integrity.
- Record_locking wikiPageWikiLink Database.
- Record_locking wikiPageWikiLink Deadlock.
- Record_locking wikiPageWikiLink FIFO_(computing_and_electronics).
- Record_locking wikiPageWikiLink File_locking.
- Record_locking wikiPageWikiLink Granularity.
- Record_locking wikiPageWikiLink Jim_Gray_(computer_scientist).
- Record_locking wikiPageWikiLink Row_(database).
- Record_locking wikiPageWikiLink SQL.
- Record_locking wikiPageWikiLink Table_(database).
- Record_locking wikiPageWikiLinkText "Record locking".
- Record_locking wikiPageWikiLinkText "locked".
- Record_locking wikiPageWikiLinkText "record locking".
- Record_locking wikiPageWikiLinkText "record".
- Record_locking wikiPageUsesTemplate Template:Merge_from.
- Record_locking wikiPageUsesTemplate Template:Refimprove.
- Record_locking wikiPageUsesTemplate Template:Reflist.
- Record_locking subject Category:Concurrency_control.
- Record_locking subject Category:Transaction_processing.
- Record_locking hypernym Technique.
- Record_locking type TopicalConcept.
- Record_locking comment "Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.The classic example is demonstrated by two bank clerks attempting to update the same bank account for two different transactions. Clerks 1 and 2 both retrieve (i.e., copy) the account's record. Clerk 1 applies and saves a transaction.".
- Record_locking label "Record locking".
- Record_locking sameAs Q17086786.
- Record_locking sameAs Record_locking.
- Record_locking sameAs m.032z2n.
- Record_locking sameAs Q17086786.
- Record_locking wasDerivedFrom Record_locking?oldid=647556070.
- Record_locking isPrimaryTopicOf Record_locking.