Data Integration

Knowledges on procedural programming.

Weekly classes consist in:
–   2 hours of theoretical classes in which new concepts and different methodologies for data integration are introduce. All the studied subjects are complemented by simple examples.
–   2 hours of laboratorial classes where the students develop solutions of data integration to different case studies.
Evaluation consists in: Theoretic (60%):
The students can choose for accomplish this evaluation through the realization of three tests during the semester or making a final exam.
Practical (40%)
The students have to moralize two different practical assignments
In order to successfully complete this curricular unit, the students must have a minimum of 35% in each of these components.

The goals of this unit are to provide students the capacity to analyze and solve data integration related problems in different levels of an organization. The unit focus different types and strategies of data integration and explores the use of different tools and/or programming solutions for data integration. The students develop different skills such as: to explain the main reasons for data integration; to identify the principal types of data integration; to explain the stages involved in the process of data integration; to understand the basic concepts needed to conceive data integration solutions; to apply the knowledge about interoperability of different components and applications, built using different programming languages; to use markup languages to query heterogeneous sources of information; to make reasonable choices about integration technologies; to elaborate clear documentation identifying and justifying the main undertaken options.

1   – Introduction to Systems Integration
1.1   Reasons to integrate
1.2   Limitations to integration
1.3   Types of integration
1.4   Models and types of Middleware
1.5   Enterprise Application Integrations
1.5.1   Remote Procedure Calls
1.5.2   Message oriented Middleware
1.5.3   Distributed Objects
1.5.4   Database oriented Middleware
1.5.5   Transaction oriented Middleware
2   – The Extended Markup Language (XML)
2.1   Origin and historical evolutions
2.2   Objectives
2.3   Structure of XML documents
2.4   Validation of XML documents (DTD and XSD)
2.5   Transformation with XML (XSLT)
2.6   Querying XML documents (xPath, xQuery) 3 – Service-Oriented Architecture (SOA)
3.1   Web services
3.2   Simple Object Access Protocol (SOAP)
3.3   Web Services Description Language (WSDL)
3.4   Universal Description Discovery and Integration (UDDI)
3.5   Business Process Execution Language (BPEL) 4 – B2B – Business-to-Business Integration
4.1   EDI
4.2   ebXML

NAO