Sign in to join Michael Dupre's fan club.
What Is Database Mapping?
Data mapping is to some extent, a complex and rapidly developing subject matter, specially within big, data led organizations. In this article, I will attempt to teach you, in simple terms, just the thing is data mapping, the most effective options for engaging in data mapping and a speedy summary of possible tactics / tools, finally I will describe a variety of industry best practices.
Therefore let’s commence with a simple concept of data mapping. Whilst there's no set dictionary definition the below works as a good enough starting place.
Data mapping can be explained as the whole process of creating data element mappings amongst two particular models, normally a source data along with a destination information with the data mapping process developing a connection or map linking data fields in both data models.
The data model itself may be either meta-data or any atomic unit of information which have a particular meaning. Concerning conducting a data mapping, this can be accomplished in many different ways, determined by your level of competence and what tools you might have on hand.
Data Mapping Approaches
There are a variety of methods of going about data mapping, common methods include applying procedural code, xslt transforms and also through mapping tools or software that can instantly and programmatically build and also run executable transformation programs. Lets cover each of these methods in more details.
Manual data mapping is largely linking or mapping fields in one set of data to your comparable field in another data set by practically pulling a line in one field to another. This is usually carried out some sort of graphical mapping tool that can automatically generate the results not to mention execute the data transformation
Data driving mapping entails using sophisticated heuristics and statistics to in unison evaluate data values in 2 sources to automatically complex mappings involving the two data sets. Its also one of many latest techniques for data mapping and is particularly valued for aiding more complicated mapping functions concerning data sets for example uncovering advanced transformations or points ie substrings, arithmetic, case statements, concatenations etc.
Semantic data mapping is comparable to the auto-connect characteristic of data mappers due to the fact it will use semantics to connect and map two sets of data, however it cannot utilize the metadata registry to discover or match synonyms. It can mainly uncover exact matches in between data columns and not any transformation logic or execptions.
Some Common Uses of Data Mapping
Several of the key implementation of data mapping involves numerous platforms and functions.
As an example, an agency that's considering having purchase orders and invoices traded or transported electronically in between themselves and another company, say a service provider, can use data mapping to build data maps from its own data to a set recognised standard for its messages (for example ANSI) for this kind of purchase orders and invoices. Some other uses or applications may incorporate, but they are not at all confined to;
• Transformation of data or mediation between your source and destination
• Revealing secret or private data, for instance the last four digits of a credit card which is connected to a user id
• Identifying relationships between data for lineage investigation
• Distilling or even joining together several databases into one database and selecting columns of data that are no longer looked at as essential, for consolidation or erasure.
Data Mapping Tips
To realize your targets, you really should contemplate adoption and / or consideration of sticking with numerous tips.
• Put in place various dependable data mobility analysis, design and programming patterns
• Create recycleable analysis, design and construction elements which means you possess a high enough standard of data quality.
• Put in position coding and naming specifications which are regular and apply the best practices
• Lower your examination costs and the expense of upkeep and improvement
• Integrate controls into the data motion procedure to ensure data quality and strength.
Thomas Harding is known as an experienced expert in XML coding and even XML standards and possesses loads of working expertise in Data Mapping as well as highly recommends anyone to Data Mapper.
Article submitted Wednesday, January 18, 2012 & read 8 times.
Leave your comments through Blogz:
3-0-0-0-3-ADSO
Copyright © 2012 IcoLogic, Inc.