Data mapping: Difference between revisions

Revision as of 13:42, 17 August 2022

Revision as of 13:43, 17 August 2022

Line 6:

* [[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 [[Relational database]] to data expressed in terms of the [[Resource_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]]).

==Hand-coded, graphical manual ==