Reverse engineering relational databases to identify and specify basic Web services with respect to service oriented computing

Abstract

Service-oriented computing (SOC) is the computing paradigm that utilizes services as a fundamental building block. Services are self-describing, open components intended to support composition of distributed applications. Currently, Web services provide a standardbased realization of SOC due to: (1) the machine-readable format (XML) of their functional and nonfunctional specifications, and (2) their messaging protocols built on top of the Internet. However, how to methodologically identify, specify, design, deploy and manage a sound and complete set of Web services to move to a service-oriented architecture (SOA) is still an issue. This paper describes a process for reverse engineering relational database applications architecture into SOA architecture, where SQL statements are insulated from the applications, factored, implemented, and registered as Web services to be discovered, selected, and reused in composing e-business solutions. The process is based on two types of design patterns: schema transformation pattern and CRUD operations pattern. First, the schema transformation pattern allows an identification of the services. Then the CRUD operations pattern allows a specification of the abstract part of the identified services, namely their port types. This process is implemented as a CASE tool, which assists analysts specifying services that implement common, reusable, basic business logic and data manipulation.

Automatic service derivation from business process model repositories via semantic technology

“…Besides the multitude of service derivation approaches utilizing source code, there are also other strategies. For instance, Baghdadi [36] analyzes the schemas of relational database applications to define web services. In a quite similar vein, Mani et al [37] investigate the user interfaces of applications to derive requirements for information services.…”

A method to identify services using master data and artifact-centric modeling approach

“…This SIM does not address IT perspective. On the other hand, the method described in [29] elicits only the IT perspective. This method uses database reverse engineering to identify basic data access services.…”

A Comparative Study of Enterprise Resource Planning Vs Service Oriented Architecture in Small Medium Enterprises

“…Also services by using variety of methods such extracting a service from a limited area by plotting Create, Read, Update, Delete (CRUD) tasks or converting a table that represent a bounded data as a service and so on this architecture prepare an easy to achieve and not limited techniques for enterprises to get SOA's benefits (Baghdadi, 2006;Klose and Knackstedt, 2007;Jamshidi et al, 2008). Through the comparison it is clear that SOA as architectural method can response the main SME challenges.…”

“…Through the comparison it is clear that SOA as architectural method can response the main SME challenges. In more than one SOA approaches, lack of experts has been tried to be covered by tools to automating the service identification from enterprise' business processes, or leverage existing databases in order to transform them as services (Baghdadi, 2006) (Jamshidi et al, 2008). Also, the comparison has revealed a focus on business-IT alignment in SOA methods that is a main challenge in SMEs that suffer due to this gap between their business and information systems even when they implement ERP system that not fully compatible with their business and enterprise structure.…”