The Research of Multi-source heterogeneous Data Integration Based on LINQ

by Jungh K
For this week’s blog assignment, I chose an article, titled “The Research of Multi-source heterogeneous Data Integration Based on LINQ”.  The authors explore technological aspects of data integration using LINQ.  LINQ, which stands for Language-Integrated Query, encapsulates the data into objects so users can manipulate them with programming languages, such as Visual Basic, C#, and F#.  One advantage of LINQ is that it simplifies different data types and sources with unified means to extract, transform, and load the data.  The authors’ proposed system has four layers:  heterogeneous data layer, data access layer based on LINQ, business logic layer of query processing, and user interface.  On the heterogeneous data layer, data types that are supported by LINQ provider assemblies are wrapped into objects.  The data access layer provides access to data stored in persistent storage.  On the business logic layer of query processing, user queries are manipulated to enable him/her to analyze the data and ultimately display the information to the user using the user interface layer.  The authors note that the collections provided .NET is flexible enough to incorporate all data types.  Programmers just need to implement IEnumerable<T> to accommodate different data types and sources.

This week’s lecture topic on data application development directly applies to the article.  LINQ integrates different data types and sources, whether they are DB2, Oracle 11g, MS SQL Server or XML.  Since they are some deviations in syntax and formats among all the RDMSs, LINQ provides great interoperability and scalability for programmers.  In my personal experience, I took a class for VB application development with MS SQL Server.  The professor briefly went over LINQ but since we were using only one data source ADO.NET was useful enough for the class.


Yunxiao Wang; Xuecheng Zhang; , “The Research of Multi-source Heterogeneous Data Integration Based on LINQ,” Computer Science and Electronics Engineering (ICCSEE), 2012 International Conference on , vol.1, no., pp.147-150, 23-25 March 2012
doi: 10.1109/ICCSEE.2012.437