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.
The Engine That Powers BI Forbes ... of low-cost "data warehouse appliances." An appliance is simply a pre-integrated bundle containing a database management system and other key software, ...
The economics of computing ZDNet UK (blog) Software has changed - internal DBMS data management software exploits both of the above to form a combined offering that is even greater than the sum of ...
Database Systems: Design, Implementation, and Management by Peter Rob, Carlos Coronel Average Customer Review: based on 13 reviews. Customer Review: This book is absolutely worthless. Don't buy unless absolutely necessary. Nobody will buy it back.
Fundamentals of Database Systems (5th Edition) by Ramez Elmasri, Shamkant B. Navathe Average Customer Review: based on 53 reviews. Customer Review: This is an excellent and thorough analysis of database processes involving transactions, concurrency control, security and covers relational tables, object-relational databases as well as object oriented technology. There is a thorough overview of UML as well as ER design tools. It is a tough read and covers a lot of material and is...
Modern Database Management (9th Edition) by Jeffrey A. Hoffer, Mary Prescott, Heikki Topi Average Customer Review: based on 17 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.
Concepts of Database Management (Sam 2007 Compatible Products) by Philip J. Pratt, Joseph J. Adamski Average Customer Review: based on 14 reviews. Customer Review: The Book is in exellent condition and the price was great. This economic budget has made everyone look for ways to save money.
Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition) by Thomas M. Connolly, Carolyn E. Begg Average Customer Review: based on 1 review. Customer Review: This book is the fifth edition. It has 34 chapters, over 1000 pages. The theoretical foundation is clearly presented. Using Oracle architecture to explain the concept is excellent. Coverages on Security and Administration, Distributed DBMS, Mobile Databases, SQL 2008, Java, XML are all good. I recommend this book to all database profe...