Choose Index below for a list of all words and phrases defined in this glossary.

Data Cleansing_

index | Index

Data Cleansing - definition(s)

Data Cleansing : An informationscrap-and-rework process to correct data errors in a collection of data in order to bring the level of quality to an acceptable level to meet the information customers' needs.

[Category=Data Quality ]

Source: Larry English, External, 20-Jan-2009 13:59

These advertisers support this free service

Data Cleansing - Also referred to as data scrubbing. Data Cleansing is the process of detecting dirty data in a database (data that is incorrect, out-of-date, redundant, incomplete, or formatted incorrectly) and then removing and/or correcting the data. Data cleansing is often necessary to bring consistency to different sets of data that have been merged from separate databases. Cleansing data involves consolidating data within a database by removing inconsistent data, removing duplicates and reindexing existing data in order to achieve the most accurate and concise database. It can involve manual tasks or processes automated by special Data Quality tools. A particular type of Data Cleansing is Address Cleansing, in which street addresses are converted to a standard format as set forth by the U.S. Postal Service master database. For example, standard abbreviations are utilized, typos are corrected and ZIP codes are converted to 9-digit format. Address cleansing is usually done in conjunction with address matching, a process that validates an address against one of the 57 million addresses in the USPS database.

[Category=Data Governance ]

Source: The Data Governance Institute, 24 November 2009 08:32:07, External

Data Cleansing - The act of data validating and/or data auditing and correcting (or removing) corrupt or inaccurate records from a record set, table, or database.

Source: Public Schools of North Carolina, 22 April 2010 13:54:37, External

Data Cleansing - Removing errors and inconsistencies from data being imported into a data warehouse.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 06 May 2010 09:53:51, SDG Computing, now offline

Data Cleansing - the process of eliminating inaccuracies, irregularities, and discrepancies from data.

[Category=Data Quality ]

Source: SAS, 27 May 2010 09:27:29, External

Data Cleansing - The process of manipulating the data extracted from operational systems so as to make it usable by the data warehouse. When loading data from existing operational systems, it is likely that few if any of the operational systems will have data to present in a format which is compatible with the data model developed for the Warehouse. For example, a product number may be held as a numeric field in one system while a second system appends an alpha suffix to the number for reporting purposes.

[Category=Data Warehousing ]

Source:, 21 July 2010 09:28:24, External

Data Cleansing - The transformation of data in its current state to a pre-defined, standardized format using packaged software or program modules.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 15 November 2010 08:36:04, External

Data Cleansing - The process of removing inaccuracies in data or databases such as missing elements, incorrect postcodes or names.

[Category=Database Marketing ]

Source: DBG, 03 May 2011 08:06:37, External

Data Cleansing - The process of detecting records in a database that are corrupt, incomplete, incorrect, inaccurate, irrelevant, out of date, etc. and then replacing, modifying or deleting such records.

[Category=Direct Marketing ]

Source: Digital Formatting Services, 23 December 2011 09:11:43, External

Cleansing (Data cleansing) - Data cleansing, data cleaning, of data scrubbing is het proces van het ontdekken en corrigeren (of verwijderen) van corrupte, incomplete of niet zuivere records van een dataset, tabel of database.

Datacleansing wordt meestal gebruikt in databases en de term refereert naar het identificeren naar de vervuilde delen in de data om deze te vervangen, te verplaatsen of zelfs te verwijderen uit de vervuilde data.

[Category=Business Intelligence ]

Source:, 23 October 2012 12:56:04, External

Data Cleansing - The process of ensuring that a program operates on clean, correct and useful data. It includes manipulation of data - using a variety of techniques: parsing, standardizing, correcting, and consolidating- extracted from operational systems so as to make it usable by the data warehouse.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 28 October 2012 09:25:56, External 

data scrubbing (data cleansing) - Data scrubbing, also called data cleansing, is the process of amending or removing data in a database that is incorrect, incomplete, improperly formatted, or duplicated. An organization in a data-intensive field like banking, insurance, retailing, telecommunications, or transportation might use a data scrubbing tool to systematically examine data for flaws by using rules, algorithms, and look-up tables. Typically, a database scrubbing tool includes programs that are capable of correcting a number of specific type of mistakes, such as adding missing zip codes or finding duplicate records. Using a data scrubbing tool can save a database administrator a significant amount of time and can be less costly than fixing errors manually.

Related glossary terms: raw data (source data or atomic data), data, data-driven decision management (DDDM), data-driven disaster, data governance_, fixed data (permanent data, reference data, archival data, or fixed-content data), data hygiene, data quality_

[Category=Data Management ]

Source:, 18 July 2013 08:27:17, External  

Data cleansing – the process of reviewing and revising data in order to delete duplicates, correct errors and provide consistency.

[Category=Big Data ]

Source: BigData-Startup, 24 September 2013 09:05:37, External

data cleansing - The act of reviewing and revising data to remove duplicate entries, correct misspellings, add missing data, and provide more consistency.

[Category=Big Data ]

Source: DataInformed, 21 October 2013 10:15:50, External

Data Cleansing - A procedure involving a detailed review and cleansing of the data the purpose of which is to eliminate errors both visual and tabular prior to loading to the geospatial data repository.

[Category=Geospatial ]

Source: City of Toronto, 23 November 2013 08:35:11, External

Data cleansing - The act of detecting and removing and/or correcting data that is incorrect, out-of-date, redundant, incomplete, or formatted incorrectly. Also referred to as data cleaning or data scrubbing.

[Category=Data Cleansing ]

Source: Datawand, 24 December 2013 09:38:04, External

data cleansing: An information scrap-and-rework process that corrects data errors in a collection of data to bring the quality of the data to an acceptable level to meet the information customers' needs. Data cleansing is the act of detecting and correcting or removing corrupt or inaccurate records from a recordset, table, or database.

[Category=Data Cleansing ]

Source: Microsoft Data Quality Services Data Portability Overview, 27 December 2013 08:44:44, External

Data Cleansing - Unter Data Cleansing versteht man das Entfernen und Korrigieren von fehlerhaften Daten in unternehmenseigene Datenbanken oder Informationssystemen. Als fehlerhafte gelten beispielsweise inkorrekte, redundante oder falsch formatierte Daten. Mögliche Werkzeuge fürData Cleansing Projekte External bei Kundendaten sind Adressanalyse und -formatierung, Dublettenabgleich, Telefonnummernprüfung oder aber auch Bankdaten-Check.

[Category=Data Quality ]

Source: Uniserv, 02 January 2014 08:36:38, External

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: