Dirty data

Database Management  Verifiable Data – confirming the accuracy of the stored data by randomly calling a customer and verifying name, address, phone, email, and other attributes in the record.  Data Cleansing – the act of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database. Used mainly in databases, the term refers to identifying incomplete, incorrect, inaccurate, irrelevant etc. parts of the data and then replacing, modifying or deleting this dirty data.

38p truevisions 09-05-2013 52 7   Download

Recall: logging methods provide reconstructing the DB to reflect the result of committed transactions locking (or validation) methods provide serializability of transactions Problem yet uncovered: "dirty data" data written by an uncommitted transaction (to buffers or to disk) may lead to inconsistency, if read by others

22p trinh02 23-01-2013 59 6   Download