Object or instance locking

Instance locking locks a single relational tuple in an RDBMS or a single object in an ODBMS. This type of concurrency control is illustrated below.

Object or instance locking

Additional information on this subject along with examples of multi-user considerations can be found in the Object Database Handbook (new window).

 

Web Services and Service-Oriented Architectures
Online articles>
Consulting
Mentoring
Speaking
Suggested programs
Stencils for the Savvy Manager's Guide
Links
Mail list
Privacy policy
Sitemap
Contact
Web Services articles
XML standards and vocabularies
Application server articles
Database concepts and standards>
Object database articles
Relational database articles
Object-relational mapping articles
XML database articles
XML middleware articles
Article Sponsorship
Reprint policy
Basic concepts for using a DBMS>
Database models
DBMS standards
Article suggestions
ACID properties
Concurrency control and locking>
Page locking
Cluster locking
Class or table locking
Object or instance locking>

Related recent articles from Google News


Data Analytics Startup Lands MySpace As Early Adopter
InformationWeek, NY - May 14, 2008
... against large data stores: 1) scale up by adding processors to a DBMS; 2) deploy a DBMS across a massively parallel cluster; 3) write custom code. ...

After the Attack
Redmond Developer News, CA - 14 hours ago
In this case, I absolutely agree that it's not the fault of the DBMS [database management system]. Since I first heard of SQL insertion attacks I developed ...
Who's to Blame for SQL Threat? Redmond Developer News
Will SQL Server 2008 Slip Again? Redmond Developer News
all 3 news articles

Of All Things, IBM Takes a Lead in the Mashup Fray
Intelligent Enterprise, CA - 21 hours ago
IBM's DB2 v9 pureXML, which merges the power of a respected SQL database management system with a truly integrated XML database engine, is a tour de force ...

Data archiving: For the users, by the users
SearchCIO.com - May 15, 2008
Olofson agrees the archiving approach means companies can put the data in a place where the database management system doesn't need to manage it anymore, ...

ParAccel and Talend Form Alliance
Business Wire (press release), CA - May 13, 2008
?Business intelligence and analytics bring special requirements to the database management system, and the ability to access cross-platform data is a ...

More related news: data database-management-system OR DBMS - Google News

Related books at Amazon.com


Modern Database Management (8th Edition)
by Jeffrey A. Hoffer, Mary Prescott, Fred McFadden
Average Customer Review: 3.5 stars based on 14 reviews.
Customer Review: I used this book in graduate school while taking the Database Management System course. The book has usefull information. It help me understand and practice normalization. Some unfamiliar concepts also were learnt from the book. I can recommend this book to anyone getting into the database world.

Databases Demystified (Demystified)
by Andrew Oppel
Average Customer Review: 5 stars based on 21 reviews.
Customer Review: There are two things in life that are difficult: databases and comedy. Fortunately, the author makes understanding databases far less difficult with his clear explanations and examples. I confess that some aspects of a database (and I have some experience) are still a mystery, but I hurriedly read this book because I have some much ...

Database Systems: Design, Implementation, and Management, Seventh Edition
by Peter Rob, Carlos Coronel
Average Customer Review: 3.5 stars based on 26 reviews.
Customer Review: This text covers database theory and some SQL (two chapters or so). I think it's generally good book as an intro to database systems. It will not make you into DBA or programmer, but you'll feel better grip of database concepts you may encounter in other more 'practical' books (like DB programming, or administration). To learn SQL f...

The American Church in Crisis: Groundbreaking Research Based on a National Database of over 200,000 Churches
by David T. Olson
Average Customer Review: 5 stars based on 2 reviews.
Customer Review: This book does an excellent job of bridging a well-researched assessment of the Church in America, with practical responses that the Church must make in order to fulfill the mission of the Kingdom of God. Olson approaches the reality of an American Church in decline with love and respect for the Body of Christ; while he gives church ...

Database Systems: Design, Implementation, and Management, Eighth Edition
by Peter Rob, Carlos Coronel
Average Customer Review: 3 stars based on 1 review.
Customer Review: Book does not come with the student content that it is suppose to come with. It is supposed to come with online appendices A though L and downloads for files used in each chapter. I would not advise to by a 130 dollar incomplete book. It was release in December of 2007 unprepared for people to use because it makes references to sites ...

More related books: Search Amazon.com for database

 

Copyright © 2000-2008 Barry & Associates, Inc. All Rights Reserved.
You can use this material for your work or classes. Click here for our reprint policy.
www.service-architecture.com

 

 Information on becoming a sponsor

 

 

Google

 

Barry & Associates, Inc.