# A technique of designing data integration models^{{1}}

by Polun L

The article, “A Design Technique: Data Integration Modeling”, by Anthony David Giordano, talks about converting logical data integration models to physical data model. The author describes that logical data integration modeling determines the extraction, data quality, transformations, and loads. Meanwhile, the target based data integration design in physical data integration models ensure various components will perform optimally. What the target based data integration design does is that it creates PDI components, and the source systems populate them based on the subject areas within each data integration model type. As for the source system, it releases data, performs source system data quality checks, and conforms the data into the specific subject area file formats. All in all, the article wants to point out that the step of designing a good data integration. Also, it explains data integration models and how the technique applies for each rules in that model.

Response:

What I have learned from this article is that a data integration model has several layers, rules, and techniques. At first, I thought data integration modeling is like logical model converted to physical model by just clicking some buttons. But now, I know that a good data integration model that can have the highest performance needs to be designed according to the rules.

Resource:

Giordano, A. D. (2011). A design technique: Data integration modeling. Retrieved from http://www.informit.com/articles/article.aspx?p=1671910&seqNum=6

Mike Yamamoto

Mar 05, 2012@ 08:06:30Smooth integration of data is always welcomed. Proper data integration also promotes data quality because there are no duplicates or loss of data.