Data mapping: Difference between revisions

Revision as of 10:04, 21 April 2020

Revision as of 07:43, 22 October 2020

Line 2:

{{Expert needed|Information Architecture|reason=The information appears outdated and requires sources both historical (history of data mapping) and current (how is data mapping performed today).|date=May 2018}}

In [[computing]] and [[data management]], '''data mapping''' is the process of creating [[data element]] [[Map (mathematics)|mapping]]s between two distinct [[data model]]s. Data mapping is used as a first step for a wide variety of [[data integration]] tasks, including:<ref name="ShahbazData15">{{cite book |url=https://books.google.com/books?id=pRChCgAAQBAJ |title=Data Mapping for Data Warehouse Design |author=Shahbaz, Q. |publisher=Elsevier |pages=180 |year=2015 |isbn=9780128053355 |accessdate=29 May 2018}}</ref>:

* [[Data transformation]] or [[data mediation]] between a data source and a destination

Line 20:

==Data-driven mapping==

This is the newest approach in data mapping and involves simultaneously evaluating actual data values in two data sources using heuristics and statistics to automatically discover complex mappings between two data sets. This approach is used to find transformations between two data sets, discovering substrings, concatenations, [[Arithmetic|arithmetic]], case statements as well as other kinds of transformation logic. This approach also discovers data exceptions that do not follow the discovered transformation logic.

==Semantic mapping==