Continue in 2 seconds

Please define data reconciliation and database reconciliation.

  • Chuck Kelley, Evan Levy
  • January 03 2005, 1:00am EST


Please define data reconciliation and database reconciliation. I also need a definition of data synchronization.


Chuck Kelley's Answer: Synchronization is really about making sure that you have extracted from the appropriate sources and that all the data is available (i.e., run through the ETL process and loaded). Data reconciliation and database reconciliation I believe are synonyms. Both have to do with the reconciling the data and measures to the source systems.

Evan Levy's Response: I've sent these terms used interchangeably - here's my use of each.

Data reconciliation is element level checking where each element is valid. This includes matching the source and reflecting an accurate, valid value.

Database reconciliation focuses on the integrity and quality of the entire database or data set. Database reconciliation is a superset of data reconciliation.

We frequently use data reconciliation to address the integrity or accuracy of individual records of data quantities. Database reconciliation is frequently discussed at the completion of a data migration effort where we want to understand if the validity of the entire data set is still intact.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access