Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Determining the currency of data
Fan W., Geerts F., Wijsen J. ACM Transactions on Database Systems37 (4):1-46,2012.Type:Article
Date Reviewed: Mar 27 2013

Dirty data refers to inaccurate, incomplete, or erroneous data in a computer system. One form of dirty data is created when relational databases contain multiple relations for an entity. Determining which of the entity attribute values are correct or most probably correct, especially when the values do not carry timestamps, is the subject of this theoretical study. The authors propose a model using simple constraints to specify partial currency orders in the presence of copy functions. A simple copy function from one relation to another is assumed. Exploring the issues that occur when the copy function is used to create one or more tuples is the primary focus of the paper. The authors discuss what information and functions are needed to decide whether the imported information is sufficient to answer a query, and if it is not, to determine whether the copy function can be extended to bring in necessary current data for a query. Of course, this is done while assuring the constraints are met and the query set is size bounded.

The paper identifies seven problems associated with data currency and currency preservation. The upper and lower bounds of these problems are determined for a variety of query languages. These results are of theoretic value and may be useful to database programmers as questions of the currency of data arise. However, most of the problems explored are intractable. The authors propose further studies using heuristic algorithms and incremental analysis to lower the complexity. A final concern is raised regarding the fundamental differences between data consistency and data currency.

This paper is very readable and well organized, and the authors have made a significant intellectual addition to the study of the challenges faced in managing databases that are modified over their lifetimes. Data and database researchers and data administrators will find this paper worthwhile.

Reviewer:  E. A. Unger Review #: CR141075 (1306-0533)
Bookmark and Share
  Featured Reviewer  
 
Languages (H.2.3 )
 
 
Computational Logic (F.4.1 ... )
 
Would you recommend this review?
yes
no
Other reviews under "Languages": Date
Logic as a database language
Kowalski R. (ed)  Proc. of the third British national conference on databases (BNCOD3) (, Leeds, UK,1321984. Type: Proceedings
Mar 1 1986
Logic, algebra and databases
Gray P. (ed), John Wiley & Sons, Inc., New York, NY, 1984. Type: Book (9789780470202593)
Nov 1 1986
A relational representation of an abstract type system
Weller D., York B. IEEE Transactions on Software Engineering SE-10(3): 303-309, 1984. Type: Article
Jan 1 1985
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