Data mapping: Difference between revisions

Revision as of 07:43, 22 October 2020

Latest revision as of 16:39, 13 December 2024

(13 intermediate revisions by 12 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 |accessdateaccess-date=29 May 2018}}</ref>

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

Line 14:

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.

InThe the[[W3C]] future,introduced tools[https://www.w3.org/TR/r2rml/ basedR2RML] onas a standard for mapping data in a [[semanticrelational webdatabase]] languagesto suchdata asexpressed in terms of the [[Resource Description Framework]] (RDF).

In the future, tools based on [[semantic web]] languages such as 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 ==

Data mappings can be done in a variety of ways using procedural code, creating [[XSLT]] transforms or by using graphical mapping tools that automatically generate executable transformation programs. These are graphical tools that allow a user to "draw" lines from fields in one set of data to fields in another. Some graphical data mapping tools allow users to "auto-connect" a source and a destination. This feature is dependent on the source and destination [[data element name]] being the same. Transformation programs are automatically created in SQL, XSLT, [[Java (programming language)|Java programming language]], or [[C++]]. These kinds of graphical tools are found in most [[Extract, transform, load|ETL]] (extract, transform, and load) tools as the primary means of entering data maps to support data movement. Examples include SAP BODS and Informatica PowerCenter.

==Data-driven mapping==

Line 44 ⟶ 46:

==References==

{{reflist}}

==External links==

{{DEFAULTSORT:Data Mapping}}