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 [...]
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 [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
The isolation portion of the ACID properties is needed when there are concurrent transactions.
Concurrent transactions are transactions that occur at the same time, such as shared multiple users accessing shared objects. This situation is illustrated at the top of
the figure as activities occurring over time. The safeguards used by a DBMS to prevent conflicts between concurrent transactions are a concept referred to as isolation.
As an example, if two people are updating the same catalog item, it's not acceptable for one person's changes to be "clobbered" when the second person saves a different set of changes. Both users should be able to work in isolation, working as though he or she is the only user.
Each set of changes must be isolated from those of the other users.
An important concept to understanding isolation through transactions is
serializability. Transactions are serializable when the effect on the database is the same whether the transactions are executed in serial order or in an interleaved fashion. As you can see at the top of
the figure, Transactions 1 through Transaction 3 are executing concurrently over time. The effect on the DBMS is that the transactions may execute in serial order based on consistency and isolation requirements. If you look at the bottom of
the figure, you can see several ways in which these transactions may execute. It is important to note that a serialized execution does not imply the first transactions will automatically be the ones that will terminate before other transactions in the serial order.
Degrees of isolation¹:
degree 0 - a transaction does not overwrite data updated by another user or process ("dirty data") of other transactions
degree 1 - degree 0 plus a transaction does not commit any writes until it completes all its writes (until the end of transaction)
degree 2 - degree 1 plus a transaction does not read dirty data from other transactions
degree 3 - degree 2 plus other transactions do not dirty data read by a transaction before the transaction commits
¹ These were originally described as degrees of consistency by Jim
Gray.
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: Isolation.
Related recent articles from Google News
Textual Data – A Brief Sojourn B-EYE-Network And for a long time it has been held that textual data cannot be manipulated by a computer. Textual data is notoriously non repetitive, and non-repetitive data simply does not fit well into a standard database management system. 2 Feb 2012 at 5:13am
Business Objects BI developer Emirates 24/7 Comfortable working with Business Objects against a non-SAP environment, including an Oracle data warehouse, as well as other types of DBMS. 8. Troubleshoot performance problems with business intelligence applications and reports post conversion or ... 2 Feb 2012 at 6:02am
Hadapt Expands Executive Team With Kelly Stirman, VP Customer Solutions MarketWatch (press release) 23, 2012 /PRNewswire via COMTEX/ -- Hadapt, creator of the first big data platform that combines the benefits of Hadoop and relational DBMS into a single platform, today announced Kelly Stirman has joined as Vice President, Customer Solutions. and more » 23 Jan 2012 at 8:31am
Repair corrupt and inaccessible databases with this impeccable software Industry Today (press release) MS Access is one of the most famous database management systems developed by Microsoft Corporation; it stores data in its own format called MDB files. MS Access finds immense application across the industry either as a backend DBMS system or as a ... 31 Jan 2012 at 3:02am
Data Driven Subscription in SSRS 2008 R2 Database Journal By Arshad Ali SQL Server Reporting Services (SSRS) is a server based scalable and extensible platform for authoring, deploying, executing and managing reports based on a variety of data sources. SSRS allows us to create interactive, tabular, ... 23 Jan 2012 at 2:04am
Transaction Processing: Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems) by Jim Gray, Andreas Reuter Description: The key to client/server computing. Transaction processing techniques are deeply ingrained in the fields of databases and operating systems and are used to monitor, control and update information in modern computer systems. This book will show you how large, distributed, heterogeneous computer systems can be made to work reliably. Using transactions as a unifying conceptual fram...
Database and Transaction Processing by Philip M. Lewis, Arthur Bernstein, Michael Kifer Description: "This is a great book! This is the book I wish I had written." -Jim Gray, Microsoft Research, recipient of 1998 A.M. Turing Award "for seminal contributions to database and transaction processing research" Databases and Transaction Processing provides a complete and clear explanation of the conceptual and engineering principles underlying the design and implementation of database a...
