skip to main content
10.1145/1529282.1529753acmconferencesArticle/Chapter ViewAbstractPublication PagessacConference Proceedingsconference-collections
research-article

PRECISO: a reengineering process and a tool for database modernisation through web services

Published: 08 March 2009 Publication History

Abstract

A common trend in Service Oriented Architecture (SOA) is to consider Information Systems exposing software as services. This current approach is not only applied to new software developments, but also it is related to the maintenance of legacy systems. Nowadays, a cornerstone of Information Systems are relational databases, which constitute meaningful sources of services. These services can provide database's information in SOA scenarios. This paper presents a reengineering process to recover and implement Web Services in automatic manner from relational databases. This process follows the ADM approach (Architecture-Driven Modernization). In this paper authors present a case study that has been carried out using a tool built to support the process. This tool is used to generate a set of Web Services which are integrated into a web development allowing to modernise the legacy database in a SOA context. This case study has been carried out in the context of software company Indra.

References

[1]
Arnold, R. S., Software Reengineering. 1994: IEEE Computer Society Press. 688 pages.
[2]
Behm, A., A. Geppert and K. Dittrich, Algebraic Database Migration to Object Technology, in Lecture Notes in Computer Science. Springer Berlin / Heidelberg. 2000.
[3]
Bezivin, J., S. Hammoudi, D. Lopes and J. Jouault, Applying MDA Approach for Web Service Platform, in Proceedings of the Enterprise Distributed Object Computing Conference, Eighth IEEE International. 2004, IEEE Computer Society. p. 58--70.
[4]
Blaha, M. A Retrospective on Industrial Database Reverse Engineering Projects-Part 1. in Proceedings of the 8th Working Conference on Reverse Engineering (WCRE'01). 2001. Suttgart, Germany: IEEE Computer Society. p. 136--147.
[5]
Blaha, M. A Retrospective on Industrial Database Reverse Engineering Projects-Part 2. in Proceedings of the 8th Working Conference on Reverse Engineering (WCRE'01). 2001. Suttgart, Germany: IEEE Computer Society. p. 147--156.
[6]
Booth, D., H. Haas, F. McCabe, E. Newcomer, M. Champion, C. Ferris and D. Orchard, Web Services Architecture. 2004: W3C - World Wide Web Consortiumpages.
[7]
Calero, C., An Ontological Approach To Describe the SQL:2003 Object-Relational Features. Accepted in "Computer Standards and Interfaces". 2005: p. 28.
[8]
Channabasavaiah, K., K. Holley and E. Tuggle, Migrating to a service-oriented architecture, Part 1. http://www.ibm.com/developerworks/library/ws-migratesoa/. 2003.
[9]
Chikofsky, E. J. a. J. H. C., Reverse Engineering and Design Recovery: ATaxonomy. IEEE Software (January), 1990: p. 13--17.
[10]
Chung, S., P. S. Young and J. Nelson, Service-Oriented Software Reengineering: Bertie3 as Web Services, in Proceedings of the IEEE International Conference on Web Services. 2005, IEEE Computer Society.
[11]
Di Lucca, G. A., A. R. Fasolino and P. Tramontana, Reverse engineering Web applications: the WARE approach. Journal of Software Maintenance and Evolution: Research and Practice 16, 2004.
[12]
Endrel, M., J. Ang, A. Arsanjani, S. Chua, P. Comte, P. Krogdahi, M. Luo and T. Newling, Patterns: Service-Oriented Architecture and Web Services. 2004: IBM - WebSphere Software. pages.
[13]
García, I., PRESSWEB: Un Proceso para REingeniería de Sistemas heredados hacia Servicios Web. 2007, Universidad de Castilla-La Mancha. p. 344.
[14]
García, I., M. Polo and M. Piattini, Using Model-Driven Pattern Matching to derive functionalities in Models., in Proceedings of the Nineteenth International Conference on Software Engineering and Knowledge Engineering. 2007: Boston, USA.
[15]
Grose, T. J., G. C. Doney and S. A. Brodsky, Mastering XMI: Java Programming with XMI, XML, and UML, ed. O. Press. 2001: John Wiley & Sons. 480 pages.
[16]
Hainaut, J.-L., V. Englebert, J. Henrard, J.-M. Hick and D. Roland1, Database reverse engineering: From requirements to CARE tools, in Applied Categorical Structures. SpringerLink. 2004.
[17]
Heuvel, W.-J.v.d., Matching and Adaptation: Core Techniques for MDA-(ADM)-driven Integration of new Business Applications with Wrapped Legacy Systems, in Model-Driven Evolution of Legacy Systems (MELS 2004). 2004: Monterey, California, USA.
[18]
IBM, New to SOA and Web services. http://www.ibm.com/developerworks/webservices/newto/. 2006: p. 6.
[19]
INRIA, ATL Transformation Description Template version 0.1. http://www.eclipse.org/m2m/atl/doc/ATL_Transformation_Template%5Bv00.01%5D.pdf. 2005, ATLAS group.
[20]
ISO/IEC, ISO/IEC 9075:1992, Database Language SQL. 1992.
[21]
Jean Bezivin and O. Gerb, Towards a Precise Definition of the OMG/MDA Framework, in Proceedings of the 16th IEEE international conference on Automated software engineering. 2001, IEEE Computer Society.
[22]
McBrien, P. and A. Poulovassilis, Automatic Migration and Wrapping of Database Applications - A Schema Transformation Approach, in Proceedings of the 18th International Conference on Conceptual Modeling. 1999, Springer-Verlag.
[23]
Melton, J. and A. R. Simon, Understanding the new SQL: A Complete Guide. 1993, United States of America: Morgan Kaufmann Publishers, Inc. pages.
[24]
MOMOCS. MOdel driven MOdernisation of Complex Systems Is an EU-Project. 2008 {accessed: 2008; Disponible en: http://www.momocs.org/.
[25]
Newcomb, P., Architecture-Driven Modernization (ADM), in Proceedings of the 12th Working Conference on Reverse Engineering. 2005, IEEE Computer Society.
[26]
OMG, MDA Guide Version 1.0.1. www.omg.org/docs/omg/03-06-01.pdf, OMG, Editor. 2003. p. 62.
[27]
OMG, Architecture-Driven Modernization Roadmap. 2006, Object Management Group.
[28]
OMG. Unified Modeling Language: Superstructure. Version 2.0. http://www.omg.org/docs/formal/05-07-04.pdf. 2007 {accessed: 16-08-2007}; Disponible en: http://www.omg.org/docs/formal/05-07-04.pdf.
[29]
OMG, QVT. Meta Object Facility (MOF) 2.0 Query/View/Transformation Specification. http://www.omg.org/spec/QVT/1.0/PDF. 2008, OMG.
[30]
Polo, M., J.Á. Gómez, M. Piattini and F. Ruiz, Generating three-tier applications from relational databases: a formal and practical approach. Information and Software Technology, 2002. 44.
[31]
Reus, T., H. Geers and A. v. Deursen. Harvesting Software for MDA-Based Recovering. in European Conference on Model Driven Architecture - Foundations and Applications. 2006. Bilbao (Spain): Springer-Verlag Berlin Heidelberg.
[32]
Shankaranarayanan, G. and Y. Cai, A Web Services Application for the Data Quality Management in the B2B Networked Environment., in Proceedings of the Proceedings of the 38th Annual Hawaii International Conference on System Sciences (HICSS'05) - Track 7 - Volume 07. 2005, IEEE Computer Society.
[33]
Sneed, H. M., Migrating to Web Services, in Emerging Methods, Technologies and Process Management in Software Engineering. 2008, Wiley-IEEE Computer Society Pr. p. 151--176.
[34]
Thiran, P. and J.-L. Hainaut, Wrapper Development for Legacy Data Reuse in Proceedings of the Eighth Working Conference on Reverse Engineering (WCRE'01) 2001 IEEE Computer Society. p. 198
[35]
Thiran, P., G.-J. Houben, J.-L. Hainaut and D. Benslimane, Updating Legacy Databases through Wrappers: Data Consistency Management in Proceedings of the 11th Working Conference on Reverse Engineering (WCRE'04) - Volume 00 2004 IEEE Computer Society. p. 58--67
[36]
Turner, M., D. Budgen and P. Brereton, Turning Software into a Service, in IEEE Computer Society. 2003pages.
[37]
W3C. WSDL in Web Services Description Working Group. 2007 {accessed: 2008 08/01/2008}; Disponible en: http://www.w3.org/2002/ws/desc/.

Cited By

View all
  • (2024)Modernizing Legacy IT Systems : Methods, Challenges, and Strategic Insights2024 1st International Conference on Innovative and Intelligent Information Technologies (IC3IT)10.1109/IC3IT63743.2024.10869403(1-6)Online publication date: 3-Dec-2024
  • (2020)Towards architectural view-driven modernization2020 International Conference on Advanced Aspects of Software Engineering (ICAASE)10.1109/ICAASE51408.2020.9380106(1-6)Online publication date: 28-Nov-2020
  • (2015)A guidance process to modernize legacy applications for SOAService Oriented Computing and Applications10.1007/s11761-013-0137-39:1(41-58)Online publication date: 1-Mar-2015
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
SAC '09: Proceedings of the 2009 ACM symposium on Applied Computing
March 2009
2347 pages
ISBN:9781605581668
DOI:10.1145/1529282
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 08 March 2009

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. ADM
  2. MDA
  3. SOA
  4. relational databases
  5. software modernisation
  6. web services

Qualifiers

  • Research-article

Funding Sources

  • project ESFINGE, Plan Nacional de Investigacion Cientifica, Desarrollo e Innovacion Tecnologica
  • project MECENAS, Plan Regional de Investigacion Cientifica, Desarrollo Tecnologico e Innovacion
  • project PRALIN, Junta de Comunidades de Castilla-La Mancha

Conference

SAC09
Sponsor:
SAC09: The 2009 ACM Symposium on Applied Computing
March 8, 2009 - March 12, 2008
Hawaii, Honolulu

Acceptance Rates

Overall Acceptance Rate 1,650 of 6,669 submissions, 25%

Upcoming Conference

SAC '25
The 40th ACM/SIGAPP Symposium on Applied Computing
March 31 - April 4, 2025
Catania , Italy

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)6
  • Downloads (Last 6 weeks)0
Reflects downloads up to 14 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2024)Modernizing Legacy IT Systems : Methods, Challenges, and Strategic Insights2024 1st International Conference on Innovative and Intelligent Information Technologies (IC3IT)10.1109/IC3IT63743.2024.10869403(1-6)Online publication date: 3-Dec-2024
  • (2020)Towards architectural view-driven modernization2020 International Conference on Advanced Aspects of Software Engineering (ICAASE)10.1109/ICAASE51408.2020.9380106(1-6)Online publication date: 28-Nov-2020
  • (2015)A guidance process to modernize legacy applications for SOAService Oriented Computing and Applications10.1007/s11761-013-0137-39:1(41-58)Online publication date: 1-Mar-2015
  • (2015)A systematic literature review on SOA migrationJournal of Software: Evolution and Process10.1002/smr.171227:5(337-372)Online publication date: 1-May-2015
  • (2014)A mapping study on architecture-driven modernizationProceedings of the 2014 IEEE 15th International Conference on Information Reuse and Integration (IEEE IRI 2014)10.1109/IRI.2014.7051941(577-584)Online publication date: Aug-2014
  • (2013)Legacy to SOA EvolutionMigrating Legacy Applications10.4018/978-1-4666-2488-7.ch003(40-70)Online publication date: 2013
  • (2013)Meta-modeling of inclusion dependency constraintsProceedings of the 6th Balkan Conference in Informatics10.1145/2490257.2490265(114-121)Online publication date: 19-Sep-2013
  • (2013)Reverse Engineering Applied to CMS-Based Web Applications Coded in PHP: A Proposal of MigrationEvaluation of Novel Approaches to Software Engineering10.1007/978-3-642-54092-9_18(241-256)Online publication date: 2013
  • (2012)A family of case studies on business process mining using MARBLEJournal of Systems and Software10.1016/j.jss.2012.01.02285:6(1370-1385)Online publication date: 1-Jun-2012
  • (2012)A case study on business process recovery using an e-government systemSoftware—Practice & Experience10.1002/spe.105742:2(159-189)Online publication date: 1-Feb-2012
  • Show More Cited By

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media