MyArticle » Computers » Programming » What Is Database Mapping?

What Is Database Mapping?

View PDF | Print View
by: michaeldupre
Total views: 210
Word Count: 705
Date: Mon, 23 Jan 2012 Time: 4:21 AM

Data mapping is to some degree, an elaborate and rapidly expanding issue, specially within important, data led companies. In this article, I will make an effort to summarize, in simple terms, exactly what is data mapping, the most beneficial strategies to conducting data mapping and a swift overview of the available techniques / tools, and at last I will outline several business best practices.

So let’s start out with a straightforward concept of data mapping. Whilst there's no set dictionary definition the below works as a good enough place to begin.

Data mapping can be defined as the entire process of building data element mappings amongst two specific versions, typically a source data plus a destination information with the data mapping process building a connection or map in between data fields in both data models.

The data model itself can be either meta-data or any atomic unit of information which has a exact meaning. In terms of performing a data mapping, this can be achieved in numerous ways, dependant upon your level of skills and what resources you've got at hand.
Data Mapping Methods

There are a variety of ways to carry out data mapping, common methods include using procedural code, xslt transforms or even through mapping tools or software which could instantly and programmatically make and run executable transformation programs. Lets cover every one of these methods in more details.

Manual data mapping it's essentially hooking up or mapping fields in one set of data with a matching field in another data set by literally pulling a line from one field to another. Normally, this is done in some form of graphical mapping tool which will automatically generate the results and also undertake the data transformation

Data driving mapping consists of utilizing sophisticated heuristics as well as statistics to in unison review data values in 2 sources to automatically complex mappings between the two data sets. Its also on the list of latest techniques for data mapping and is particularly valued for facilitating more complex mapping functions concerning data sets for instance discovering advanced transformations or features ie substrings, arithmetic, case statements, concatenations etc.

Semantic data mapping is much like the auto-connect feature of data mappers due to the fact it will use semantics to connect and map two sets of data, however it can not utilize the metadata registry to obtain or match synonyms. It is able to only discover exact matches between data columns and not any transformation logic or execptions.
A Handful Of Usual Uses of Data Mapping

A few of the main application of data mapping involves a multitude of platforms and reasons.

For example, an organization which is interested in having purchase orders and invoices interchanged or even transported a digital format involving themselves and another company, say a service provider, is able to use data mapping to make data maps from its own data to a set accepted standard for its messages (for example ANSI) for this sort of purchase orders and invoices. Some other uses or applications can include, but you're under no circumstances restricted to;

•    Transformation of data or arbitration between the source and destination

•    Revealing hidden or confidential data, such as the last four digits of a bank card which is connected to a user id

•    Identifying relationships between data for lineage analysis

•    Distilling or maybe bringing together many databases into one database and selecting columns of data that are not any longer deemed required, for consolidation or removal.
Data Mapping Tips

To achieve your targets, you really should take into account adoption and even deliberation over pursuing a number of recommendations.

•    Put in place some consistent data movement analysis, design plus coding patterns

•    Create reusable analysis, design and construction factors so that you will have a high enough standard of data quality.

•    Put in position coding and labeling standards which are regular and implement the best practices

•    Lower your evaluation costs and the expense of preservation and development

•    Integrate handles into the data mobility practice to make sure data quality and reliability.

About the Author

Michael Dupre undoubtedly an experienced guru in XML development and XML standards and has loads of working understanding of Data Mapping as well as strongly endorses you to Data Mapper.

Latest Articles about: Programming

Popular Articles about: Programming

Rating: Not yet rated