Data mapping: Difference between revisions

Revision as of 13:42, 17 August 2022

Latest revision as of 16:39, 13 December 2024

(4 intermediate revisions by 3 users not shown)

Line 1:

{{Data transformation}}

{{Expert needed|Information Architecturecomputing|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 |access-date=29 May 2018}}</ref>

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

* Identification of data relationships as part of [[data lineage]] analysis

* Discovery of hidden sensitive data such assas the last four digits of a social security number hidden in another user id as part of a data masking or [[de-identification]] project

* [[Data consolidation|Consolidation]] of multiple databases into a single database and identifying redundant columns of data for consolidation or elimination

Line 12:

==Standards==

X12 standards are generic [[Electronic Data Interchange]] (EDI) standards designed to allow a [[company (law)|company]] to exchange [[data]] with any other company, regardless of industry. The standards are maintained by the Accredited Standards Committee X12 (ASC X12), with the [[American National Standards Institute]] (ANSI) accredited to set standards for EDI. The X12 standards are often called [[ANSI ASC X12]] standards.

The [[W3C]] introduced [https://www.w3.org/TR/r2rml/ R2RML] as a standard for mapping data in a [[Relationalrelational database]] to data expressed in terms of the [[Resource_Description_FrameworkResource Description Framework]] (RDF).

In the future, tools based on [[semantic web]] languages such as [[Resource Description Framework]] (RDF), the [[Web Ontology Language]] (OWL) and standardized [[metadata registry]] will make data mapping a more automatic process. This process will be accelerated if each application performed [[metadata publishing]]. Full automated data mapping is a very difficult problem (see [[semantic translation]]).

In the future, tools based on [[semantic web]] languages such as [[Resource Description Framework]] (RDF), the [[Web Ontology Language]] (OWL) and standardized [[metadata registry]] will make data mapping a more automatic process. This process will be accelerated if each application performed [[metadata publishing]]. Full automated data mapping is a very difficult problem (see [[semantic translation]]).

==Hand-coded, graphical manual ==