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

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.

[1]  Mario Piattini,et al.  An ontological approach to describe the SQL: 2003 object-relational features , 2006, Comput. Stand. Interfaces.

[2]  Philippe Thiran,et al.  Wrapper development for legacy data reuse , 2001, Proceedings Eighth Working Conference on Reverse Engineering.

[3]  Alexandra Poulovassilis,et al.  Automatic Migration and Wrapping of Database Applications - A Schema Transformation Approach , 1999, ER.

[4]  Yu Cai,et al.  A Web Services Application for the Data Quality Management in the B2B Networked Environment , 2005, Proceedings of the 38th Annual Hawaii International Conference on System Sciences.

[5]  Timothy James Grose,et al.  Mastering XMI: Java Programming with XMI, XML, and UML , 2002 .

[6]  Michael R. Blaha.  A retrospective on industrial database reverse engineering projects - part 2 , 2001, Proceedings Eighth Working Conference on Reverse Engineering.

[7]  Arie van Deursen,et al.  Harvesting Software Systems for MDA-Based Reengineering , 2006, ECMDA-FA.

[8]  Giuseppe A. Di Lucca,et al.  Reverse engineering Web applications: the WARE approach , 2004, J. Softw. Maintenance Res. Pract..

[9]  James H. Cross,et al.  Reverse engineering and design recovery: a taxonomy , 1990, IEEE Software.

[10]  Philip Newcomb,et al.  Architecture-Driven Modernization (ADM) , 2005, 12th Working Conference on Reverse Engineering (WCRE'05).

[11]  Ignacio García Rodríguez de Guzmán.  Pressweb: un proceso para la reingeniería de sistemas heredados hacia servicios web , 2007 .

[12]  Ibm Redbooks,et al.  Patterns: Service Oriented Architecture And Web Services , 2004 .

[13]  Klaus R. Dittrich,et al.  Algebraic Database Migration to Object Technology , 2000, ER.

[14]  Robert S. Arnold.  Software Reengineering , 1993 .

[15]  Jean Bézivin,et al.  Towards a precise definition of the OMG/MDA framework , 2001, Proceedings 16th Annual International Conference on Automated Software Engineering (ASE 2001).

[16]  Jim Melton,et al.  Database Language SQL , 2006, Handbook on Architectures of Information Systems.

[17]  Philippe Thiran,et al.  Updating legacy databases through wrappers: data consistency management , 2004, 11th Working Conference on Reverse Engineering.

[18]  Alan R. Simon,et al.  Understanding the New SQL: A Complete Guide , 1993 .

[19]  Matthew MacDonald,et al.  Web Services Architecture , 2004 .

[20]  Sam Chung,et al.  Service-oriented software reengineering: Bertie3 as Web services , 2005, IEEE International Conference on Web Services (ICWS'05).

[21]  Jean Bézivin,et al.  Applying MDA approach for Web service platform , 2004 .

[22]  Vincent Englebert,et al.  Database reverse engineering: From requirements to CARE tools , 2004, Automated Software Engineering.

[23]  Jim Steel,et al.  MOF QVT final adopted specification: meta object facility (MOF) 2.0 query/view/transformation specification. , 2005 .

[24]  Alexander E. Quilici,et al.  Proceedings on the 5th working conference on reverse engineering , 1998 .

[25]  Jean Bézivin,et al.  Applying MDA approach for Web service platform , 2004, Proceedings. Eighth IEEE International Enterprise Distributed Object Computing Conference, 2004. EDOC 2004..

[26]  Genny Tortora,et al.  Migrating to Web Services , 2007 .

[27]  Pearl Brereton,et al.  Turning Software into a Service , 2003, Computer.

[28]  Mario Piattini,et al.  Generating three-tier applications from relational databases: a formal and practical approach , 2002, Inf. Softw. Technol..

[29]  Mario Piattini,et al.  Using Model-Driven Pattern Matching to derive functionalities in Models , 2007, SEKE.

[30]  Willem-Jan van den Heuvel,et al.  Matching and Adaptation : Core Techniques for MDA-( ADM )-driven Integration of new Business Applications with Wrapped Legacy Systems , 2004 .

[31]  Genny Tortora,et al.  Emerging Methods, Technologies and Process Management in Software Engineering , 2008 .