Business Information Integration from XML and Relational Databases Sources

Author(s):  
A. M. Fermoso Garcia
Author(s):  
Ana María Fermoso Garcia

This chapter introduces different alternatives to store and manage jointly relational and eXtensible Markup Language (XML) data sources. Nowadays, businesses are transformed in e-business and have to manage large data volumes and from heterogeneous sources. To manage large amounts of information, Database Management Systems (DBMS) continue to be one of the most used tools, and the most extended model is the relational one. On the other side, XML has reached the de facto standard to present and exchange information between businesses on the Web. Therefore, it could be necessary to use tools as mediators to integrate these two different data to a common format like XML, since it is the main data format on the Web. First, a classification of the main tools and systems where this problem is handled is made, with their advantages and disadvantages. The objective will be to propose a new system to solve the integration business information problem.


2009 ◽  
pp. 1959-1983
Author(s):  
Ana María Fermoso Garcia ◽  
Roberto Berjón Gallinas

This chapter introduces different alternatives to store and manage jointly relational and eXtensible Markup Language (XML) data sources. Nowadays, businesses are transformed in e-business and have to manage large data volumes and from heterogeneous sources. To manage large amounts of information, Database Management Systems (DBMS) continue to be one of the most used tools, and the most extended model is the relational one. On the other side, XML has reached the de facto standard to present and exchange information between businesses on the Web. Therefore, it could be necessary to use tools as mediators to integrate these two different data to a common format like XML, since it is the main data format on the Web. First, a classification of the main tools and systems where this problem is handled is made, with their advantages and disadvantages. The objective will be to propose a new system to solve the integration business information problem.


2011 ◽  
pp. 1760-1785
Author(s):  
Ana María Fermoso Garcia ◽  
Roberto Berjón Gallinas

This chapter introduces different alternatives to store and manage jointly relational and eXtensible Markup Language (XML) data sources. Nowadays, businesses are transformed in e business and have to manage large data volumes and from heterogeneous sources. To manage large amounts of information, Database Management Systems (DBMS) continue to be one of the most used tools, and the most extended model is the relational one. On the other side, XML has reached the de facto standard to present and exchange information between businesses on the Web. Therefore, it could be necessary to use tools as mediators to integrate these two different data to a common format like XML, since it is the main data format on the Web. First, a classification of the main tools and systems where this problem is handled is made, with their advantages and disadvantages. The objective will be to propose a new system to solve the integration business information problem.


Author(s):  
A. M. Fermoso Garcia

This chapter introduces different alternatives to store and manage jointly relational and eXtensible Markup Language (XML) data sources. Nowadays, businesses are transformed in e business and have to manage large data volumes and from heterogeneous sources. To manage large amounts of information, Database Management Systems (DBMS) continue to be one of the most used tools, and the most extended model is the relational one. On the other side, XML has reached the de facto standard to present and exchange information between businesses on the Web. Therefore, it could be necessary to use tools as mediators to integrate these two different data to a common format like XML, since it is the main data format on the Web. First, a classification of the main tools and systems where this problem is handled is made, with their advantages and disadvantages. The objective will be to propose a new system to solve the integration business information problem.


2011 ◽  
pp. 972-985
Author(s):  
Ákos Hajnal ◽  
Tamás Kifor ◽  
Gergely Lukácsy ◽  
László Z. Varga

More and more systems provide data through web service interfaces and these data have to be integrated with the legacy relational databases of the enterprise. The integration is usually done with enterprise information integration systems which provide a uniform query language to all information sources, therefore the XML data sources of Web services having a procedural access interface have to be matched with relational data sources having a database interface. In this chapter the authors provide a solution to this problem by describing the Web service wrapper component of the SINTAGMA Enterprise Information Integration system. They demonstrate Web services as XML data sources in enterprise information integration by showing how the web service wrapper component integrates XML data of Web services in the application domain of digital libraries.


2006 ◽  
Vol 532-533 ◽  
pp. 516-519 ◽  
Author(s):  
Shan Li ◽  
Ding Hua Zhang ◽  
Jing Tao Zhou ◽  
Guang Hui Ma ◽  
Hai Yang

Nowadays, most data in enterprise systems is still stored in relational databases, which brings the majority of difficulties to achieve information interoperation between enterprise-level heterogeneous systems. In this context, we propose a middleware to integrate information from heterogeneous enterprise system based on XML standard. The proposed integration architecture aims at providing a coherent and meaningful view of the integrated heterogeneous information systems by leverage the back-end relational data sources. The architecture of the middleware relies on the well-known mediator/wrapper architecture and satisfies the semantic integration features by several main functions including data descriptions, schema transformations and integrations based on the XML-Schema standard.


2011 ◽  
Vol 4 (1) ◽  
pp. 105
Author(s):  
Ralph R. Bravoco

An overview of the role of enterprise issues in Business Information Systems Development is presented. The importance of information flow and data standards in the development of an enterprise view is discussed and the need of management control and coordination of information integration is emphasized. In addition, a tested phased approach to information architecture development and the components of this information architecture are presented.


Author(s):  
Ákos Hajnal ◽  
Tamás Kifor ◽  
Gergely Lukácsy ◽  
László Z. Varga

More and more systems provide data through web service interfaces and these data have to be integrated with the legacy relational databases of the enterprise. The integration is usually done with enterprise information integration systems which provide a uniform query language to all information sources, therefore the XML data sources of Web services having a procedural access interface have to be matched with relational data sources having a database interface. In this chapter the authors provide a solution to this problem by describing the Web service wrapper component of the SINTAGMA Enterprise Information Integration system. They demonstrate Web services as XML data sources in enterprise information integration by showing how the web service wrapper component integrates XML data of Web services in the application domain of digital libraries.


Sign in / Sign up

Export Citation Format

Share Document