Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Ensuring consistency in multidatabases by preserving two-level serializability
Mehrotra S., Rastogi R., Korth H., Silberschatz A. ACM Transactions on Database Systems23 (2):199-230,1998.Type:Article
Date Reviewed: Jul 1 1999

Database consistency is the normal measure by which databases are determined to be correct. The normal technique for ensuring consistency is to implement concurrency control techniques that ensure serializability. However, ensuring serializability in a multidatabase system (MDBS) can be not only difficult, but expensive. This paper presents a technique that can be used to ensure data consistency in an MDBS without requiring global serializability. Instead, a weaker restriction, called two-level serializability (2LSR), is enforced. The benefit of this approach is that 2LSR is much easier to implement and ensure in an MDBS system than regular serializability.

I found the work to be technically accurate, but at times difficult to read. The presentation and organization are fine, but there is a lot of notation, some of which could have been avoided. As it is, the paper’s audience is probably limited to theoretical database researchers specializing in consistency issues for distributed and MDBS systems. Most of the notation is important to a thorough understanding of the theory, but is not needed to comprehend the overall ideas and approaches provided in the paper.

The paper presents some very interesting ideas that will interest database implementers and programmers. Thus, the results are of practical interest. In section 5, five different approaches to implementing 2LSR in an MDBS are presented. A nontheoretical database programmer would find that these approaches present reasonable techniques that can be used to ensure consistency. Not all of them are applicable in all situations, but each indicates what restrictions on transactions must be made to ensure that a 2LSR execution will guarantee consistency.

This paper not only provides an excellent theoretical overview of the consistency issues related to MDBS systems, but proposes practical approaches that can be implemented to ensure consistency without enforcing global serializability. However, it is not for everyone. The technical content requires not only a database but also a mathematical maturity not typically possessed by the average programmer. Thus I recommend this paper only to researchers in the area.

Reviewer:  Margaret Dunham Review #: CR121861 (9907-0556)
Bookmark and Share
 
Concurrency (H.2.4 ... )
 
 
Transaction Processing (H.2.4 ... )
 
Would you recommend this review?
yes
no
Other reviews under "Concurrency": Date
Locking performance in centralized databases
Tay Y., Academic Press Prof., Inc., San Diego, CA, 1988. Type: Book (9789780126844009)
Mar 1 1989
The performance of a precedence-based queuing discipline
Tsitsiklis J., Papadimitriou C., Humblet P. Journal of the ACM 33(3): 593-602, 1986. Type: Article
May 1 1987
The theory of database concurrency control
Papadimitriou C., Computer Science Press, Inc., New York, NY, 1986. Type: Book (9789780881750270)
Jul 1 1988
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy