Configurable data integration middleware system

Barbosa, Alvaro C. P.; Porto, Fábio A.M.; Melo, Rubens Nascimento

doi:10.1590/S0104-65002002000200002

Abstract

This paper presents a new approach for generating configured and flexible middleware systems for integration of heterogeneous and distributed data. The configuration is based on the selection of an adequate set of database services components and flexibility is achieved by adopting framework techniques. A control model checks the configuration, manages the communication between components and dynamically schedules tasks. The objective is to build tailored integration middleware systems, using a minimum number of components. In addition, the use of framework allows for increased software quality and reduced development effort.

Databases systems; component-based systems; frameworks composition; interoperability; middleware systems

Full text available only in PDF format

ARTICLES

Configurable data integration middleware system

Alvaro C. P. BarbosaI, ¹ 1 This work was partially developed while the authors were PhD candidates at the Computer Science Department PUC-Rio, TecBD Laboratory. ; Fábio A.M.PortoII, ¹ 1 This work was partially developed while the authors were PhD candidates at the Computer Science Department PUC-Rio, TecBD Laboratory. ; Rubens Nascimento Melo^III

^IDepartamento de Informática Universidade Federal do Espírito Santo, Av. Fernando Ferrari, s/n, Vitória, Espírito Santo, 29060-900 -Brasil email: alvaro@inf.ufes.br

^IIDepartamento de Engenharia de Sistemas, Instituto Militar de Engenharia, Praça Gal. Tibúrcio, 80, Rio de Janeiro, RJ, 22290-270-Brasil, email: fporto@ime.eb.br

^IIIDepartamento de Informática, Pontifícia Universidade Católica do Rio de Janeiro, R. Marquês de São Vicente, 225, Rio de Janeiro, RJ, 22451-900-Brasil, email: rubens@inf.puc-rio.br

ABSTRACT

This paper presents a new approach for generating configured and flexible middleware systems for integration of heterogeneous and distributed data. The configuration is based on the selection of an adequate set of database services components and flexibility is achieved by adopting framework techniques. A control model checks the configuration, manages the communication between components and dynamically schedules tasks. The objective is to build tailored integration middleware systems, using a minimum number of components. In addition, the use of framework allows for increased software quality and reduced development effort.

Keywords: Databases systems, component-based systems, frameworks composition, interoperability, middleware systems.

[2] Uchôa, E.M.A.; Lifschitz, S. & Melo, R.N. "HEROS: A Heterogeneous Object-Oriented Database System".

DEXA Conference and Workshop Programme. Vienna, Austria, 1998.

[5] Barbosa, A.C.P. and Tanaka, A.K. "Using HDBMS as an Heterogeneous Environmental Information Integrator".

Technical Report (PUC-Rio.Inf.MCC 30/99), PUC-Rio, Brazil, 39p. (In Portuguese).

[1] Duarte, C.H.C.; Pacitti, E.; Silva, S.D. & Melo, R.N. "HEROS: A Heterogeneous Object-Oriented Database System". Proceedings of the VIII Brazilian Symposium on Databases, Paraíba, Brasil, 1993, pp. 383-394. (In Por-tuguese).
[3] Uchôa, E.M.A& Melo, R. N.. "HEROS^fw: a Framework for Heterogeneous Database Systems Integration". DEXA Conference and Workshop Programme. Italy, 1999.
[4] Barbosa, A.C.P. and Melo, R. "Using HDBMS to Access and Dispose Web Information". Technical Report (PUC-Rio.Inf.MCC 29/99), PUC-Rio, Brazil, 29p. (In Por-tuguese).
[6] Melo, R.N.; Porto, F.; Lima, F. & Barbosa, A.C.P. "ECOHOOD: Constructing Configured DBMSs based on Frameworks". Proceedings of the XIII Brazilian Symposium on Databases, Paraná, Brazil, 1998, pp. 39-51.
[7] Fayad, M.E.; Schmidt, D.C. & Johnson, R.E. "Building Application Frameworks - Object-Oriented Foundations of Frameworks". John Wiley & Sons, Inc. 1999.
[8] Barbosa, A.C.P. and Lucena, C.J.P. "Integration of Software Frameworks". Technical Report (PUC-Rio.Inf.MCC 02/00), PUC-Rio, Brazil, 25p. (In Portuguese).
[9] Shet, A.P. & Larson, J.A. "Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases". A CM Computing Surveys, Vol. 22, No. 3, September 1990, pp. 183-236.
[10] Tanaka, A.; Valduriez, P. and the Ecobase Project members. "The Ecobase Project: Database and Web Technologies for Environmental Information Systems". SIGMOD Record, Vol. 30, No. 3, September 2001.
[11] Bernstein, P., Brodie, M., Ceri, S. et al. "The Asilomar Report on Database Research". SIGMOD Record, Vol. 27, No. 4, December, 1998.
[12] Silberschatz, A. & Zdonic, S. "Database Systems -Breaking Out the Box". SIGMOD Record, Vol. 26, No. 3, September 1997.
[13] Carey, M.J., DeWitt, D.J., Graefe, G., Haight, D.M., Richardson, J.E., Schuh, D.T., Shekita, E.J., and Vandenberg, S.L. "The EXODUS Extensible DBMS Project: an Overview", in Maier, D., and Zdonik, S. (editors), Readings on Object-Oriented Database Systems, Morgan-Kaufmann, 1990.
[14] Batory, D.S., Barnett, J.R., Garza, J.F., Smith, K.P., Tsukuda, K., Twichell, B.C., and Wise, T.E. "GENESIS: An Extensible Database Management System", in Maier, D., and Zdonik, S. (editors), Readings on Object-Oriented Database Systems, Morgan-Kaufmann, 1990.
[15] Nierstrasz, O. & Dami, L. "Component-Oriented Software Technology", In Object-Oriented Software Composition, Chapter 1, edited by Nierstrasz, O & Tsichritzis,D. -Prentice-Hall Inc., 1995.
[16] Pree, W. "Component-Based Software Development -A New Paradigm in Software Engineering?". Software-Concepts and Tools (18), Springer-Verlag, 1997.
[17] Mecca, G.; Atzeni, P.; Masci, A.; Merialdo & P. Sindoni,G. "The Araneus Web-Base Management System". ACM SIGMOD International Conference on Management of Data, Seattle, USA, May,1998.
[18] Fernandez, M.; Florescu, D.; Kang, Jaewoo et al. "STRUDEL: A Web-site Management System". ACM SIGMOD International Conference on Management of Data, Arizona, USA, May 1997.
[19] Molina, H. G.; Hammer, J.; Ireland, K. et al. "Integrating and Accessing Heterogeneous Information Sources in TSIMMIS". Journal of Intelligent Information Systems, Vo. 8, No. 2, pp. 177-232, March, 1997.
[20] Tomasic, A.; Raschid, L. & Valduriez, P. "Scaling Access to Heterogeneous Data Source with DISCO". IEEE Transactions on Knowledge and Data Engineering, Vol. 10, No. 5, pp. 808-823, September, 1998.
[21] "LE SELECT: a Middleware System for Publishing Autonomous and Heterogeneous Information Sources". INRIA, English, 1999. (http://www-caravel.inria.fr/~xhumari/LeSelect/)
[22] Fankhauser, P.; Gardarin, G.; Lopez, M. et al. "Experiences in Federated Databases: From IRO-DB to MIRO-Web". Proceedings of the 24^th VLDB Conference, USA, 1998.
[23] "The Garlic Project". http://www.almaden.ibm.com/cs/ garlicl- 16/04/2000.
[24] Martinez, M.R. & Roussopoulos, N. "MOCHA: A Self-Extensible Database Middleware System for Distributed Data Sources". ACM SIGMOD International Conference on Management of Data, Dallas, USA, 2000.
[25] Gamma, E.; Helm, R.; Johnson, R. & Vlissides, J. "Design Patterns - Elements of Reusable Object-Oriented Software". Addison-Wesley professional computing series, 1995.
[26] Widom, J., and Ceri, S., editors. Active Database Systems - Triggers and Rules For Advanced Database Processing. Morgan-Kaufmann, 1996.
[27] Jablonski, S. & Bussler, C. "Workflow Management-Modeling Concepts, Architecture and Implementation". International Thomson Computer Press, 1996.
[28] Barbosa, A.C.P.. "Middleware Para Integração de Dados Heterogêneos Baseado em Composição de Frameworks". PhD theses, PUC-Rio, Brazil, may 2001 (In Portuguese).

1

This work was partially developed while the authors were PhD candidates at the Computer Science Department PUC-Rio, TecBD Laboratory.

Publication Dates

Publication in this collection
14 Sept 2004
Date of issue
Nov 2002

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

[1] [1] Duarte, C.H.C.; Pacitti, E.; Silva, S.D. & Melo, R.N. "HEROS: A Heterogeneous Object-Oriented Database System". Proceedings of the VIII Brazilian Symposium on Databases, Paraíba, Brasil, 1993, pp. 383-394. (In Por-tuguese).

[2] [3] Uchôa, E.M.A& Melo, R. N.. "HEROS^fw: a Framework for Heterogeneous Database Systems Integration". DEXA Conference and Workshop Programme. Italy, 1999.

[3] [4] Barbosa, A.C.P. and Melo, R. "Using HDBMS to Access and Dispose Web Information". Technical Report (PUC-Rio.Inf.MCC 29/99), PUC-Rio, Brazil, 29p. (In Por-tuguese).

[4] [6] Melo, R.N.; Porto, F.; Lima, F. & Barbosa, A.C.P. "ECOHOOD: Constructing Configured DBMSs based on Frameworks". Proceedings of the XIII Brazilian Symposium on Databases, Paraná, Brazil, 1998, pp. 39-51.

[5] [7] Fayad, M.E.; Schmidt, D.C. & Johnson, R.E. "Building Application Frameworks - Object-Oriented Foundations of Frameworks". John Wiley & Sons, Inc. 1999.

[6] [8] Barbosa, A.C.P. and Lucena, C.J.P. "Integration of Software Frameworks". Technical Report (PUC-Rio.Inf.MCC 02/00), PUC-Rio, Brazil, 25p. (In Portuguese).

[7] [9] Shet, A.P. & Larson, J.A. "Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases". A CM Computing Surveys, Vol. 22, No. 3, September 1990, pp. 183-236.

[8] [10] Tanaka, A.; Valduriez, P. and the Ecobase Project members. "The Ecobase Project: Database and Web Technologies for Environmental Information Systems". SIGMOD Record, Vol. 30, No. 3, September 2001.

[9] [11] Bernstein, P., Brodie, M., Ceri, S. et al. "The Asilomar Report on Database Research". SIGMOD Record, Vol. 27, No. 4, December, 1998.

[10] [12] Silberschatz, A. & Zdonic, S. "Database Systems -Breaking Out the Box". SIGMOD Record, Vol. 26, No. 3, September 1997.

[11] [13] Carey, M.J., DeWitt, D.J., Graefe, G., Haight, D.M., Richardson, J.E., Schuh, D.T., Shekita, E.J., and Vandenberg, S.L. "The EXODUS Extensible DBMS Project: an Overview", in Maier, D., and Zdonik, S. (editors), Readings on Object-Oriented Database Systems, Morgan-Kaufmann, 1990.

[12] [14] Batory, D.S., Barnett, J.R., Garza, J.F., Smith, K.P., Tsukuda, K., Twichell, B.C., and Wise, T.E. "GENESIS: An Extensible Database Management System", in Maier, D., and Zdonik, S. (editors), Readings on Object-Oriented Database Systems, Morgan-Kaufmann, 1990.

[13] [15] Nierstrasz, O. & Dami, L. "Component-Oriented Software Technology", In Object-Oriented Software Composition, Chapter 1, edited by Nierstrasz, O & Tsichritzis,D. -Prentice-Hall Inc., 1995.

[14] [16] Pree, W. "Component-Based Software Development -A New Paradigm in Software Engineering?". Software-Concepts and Tools (18), Springer-Verlag, 1997.

[15] [17] Mecca, G.; Atzeni, P.; Masci, A.; Merialdo & P. Sindoni,G. "The Araneus Web-Base Management System". ACM SIGMOD International Conference on Management of Data, Seattle, USA, May,1998.

[16] [18] Fernandez, M.; Florescu, D.; Kang, Jaewoo et al. "STRUDEL: A Web-site Management System". ACM SIGMOD International Conference on Management of Data, Arizona, USA, May 1997.

[17] [19] Molina, H. G.; Hammer, J.; Ireland, K. et al. "Integrating and Accessing Heterogeneous Information Sources in TSIMMIS". Journal of Intelligent Information Systems, Vo. 8, No. 2, pp. 177-232, March, 1997.

[18] [20] Tomasic, A.; Raschid, L. & Valduriez, P. "Scaling Access to Heterogeneous Data Source with DISCO". IEEE Transactions on Knowledge and Data Engineering, Vol. 10, No. 5, pp. 808-823, September, 1998.

[19] [21] "LE SELECT: a Middleware System for Publishing Autonomous and Heterogeneous Information Sources". INRIA, English, 1999. (http://www-caravel.inria.fr/~xhumari/LeSelect/)

[20] [22] Fankhauser, P.; Gardarin, G.; Lopez, M. et al. "Experiences in Federated Databases: From IRO-DB to MIRO-Web". Proceedings of the 24^th VLDB Conference, USA, 1998.

[21] [23] "The Garlic Project". http://www.almaden.ibm.com/cs/ garlicl- 16/04/2000.

[22] [24] Martinez, M.R. & Roussopoulos, N. "MOCHA: A Self-Extensible Database Middleware System for Distributed Data Sources". ACM SIGMOD International Conference on Management of Data, Dallas, USA, 2000.

[23] [25] Gamma, E.; Helm, R.; Johnson, R. & Vlissides, J. "Design Patterns - Elements of Reusable Object-Oriented Software". Addison-Wesley professional computing series, 1995.

[24] [26] Widom, J., and Ceri, S., editors. Active Database Systems - Triggers and Rules For Advanced Database Processing. Morgan-Kaufmann, 1996.

[25] [27] Jablonski, S. & Bussler, C. "Workflow Management-Modeling Concepts, Architecture and Implementation". International Thomson Computer Press, 1996.

[26] [28] Barbosa, A.C.P.. "Middleware Para Integração de Dados Heterogêneos Baseado em Composição de Frameworks". PhD theses, PUC-Rio, Brazil, may 2001 (In Portuguese).