You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram.
To start, here are three criteria from [...]
November 18, 2008
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good.
The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
Concurrency control and locking is the mechanism used by
DBMSs for the sharing of data.
Atomicity, consistency, and isolation are achieved through concurrency control
and locking.
See ACID properties (new
window).
When many people may be reading the same data item at the same time, it is usually necessary to ensure that only one application at a time can change a data item.
Locking is a way to do this. Because of locking, all changes to a particular data item will be made in the correct order in a transaction.
See isolation (new
window).
The amount of data that can be locked with the single instance or groups of instances defines the granularity of the lock.
The types of granularity are illustrated here are:
There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.
Search this site for more articles
Custom Search
Browse this site for more articles
Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current
article: Concurrency control and locking.
Related recent articles from Google News
SSDs Speed Up Online DBMS Performance NetworkComputing.com For a $35 monthly fee, customers receive access to detailed inventory data for more than 40 million components. They can determine what items different ... 19 Mar 2010 at 10:10am
Embedded controllers capture energy data Dataweek (press release) Once read, the values are normalised and written directly into a database management system (DBMS). The PC Worx automation software supports direct ... 16 Mar 2010 at 3:31am
Database Systems: Design, Implementation, and Management by Peter Rob, Carlos Coronel Average Customer Review: based on 14 reviews. Customer Review: Great Book, great information. I thought I knew something about databases having worked with them for 7 years. This book open my mind to the theories and the beginnings that need to take place before trying to make a database in a software. Very helpful and easy read book.
Citing Ancestry.com Databases & Images Quicksheet by Elizabeth Shown Mills Average Customer Review: based on 1 review. Customer Review: I am glad this was recommended to me. I have Mills' book and this card is a great productivity aid.
Beginning Database Design: From Novice to Professional by Clare Churcher Average Customer Review: based on 19 reviews. Customer Review: I wanted to learn the fundamentals of modeling data and designing appropriate SQL tables for a moderately complicated online database, and I had been very frustrated with another book on data modeling that I had started off reading. Fortunately, I decided to try this Churcher book instead. It is clearly the work of a very intelligen...
Databases Demystified (Demystified) by Andrew Oppel Average Customer Review: based on 24 reviews. Customer Review: Very clear and concise coverage of many essential database issues. I really appreciate the brevity and lack of unnecessary jargon and formalism. However it's definitely worth pointing out that the examples come from Microsoft SQL, Microsoft Access and to a lesser degree Oracle.
The Manga Guide to Databases by Mana Takahashi, Shoko Azuma, Trend-Pro Co. Ltd. Average Customer Review: based on 17 reviews. Customer Review: Most of my friends and colleagues had to laugh when I told about or showed them this manga guide. Though this book is really fun to read and contains many subtle jokes, it's not something to dismiss as some crazy comic book. Don't fool yourself, under the happy Manga lies a superb learning book on databases. The book deals with the ...
Link code for page
based on 14 reviews.
based on 1 review.
based on 19 reviews.
