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

Youcef Baghdadi*

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

19 Citations (Scopus)


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 standard-based 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.

Original languageEnglish
Pages (from-to)395-410
Number of pages16
JournalInformation Systems Frontiers
Issue number5
Publication statusPublished - Dec 2006


  • Application architecture
  • CASE tool
  • CRUD operations pattern
  • Relational databases
  • Reverse engineering process
  • Service-oriented architecture
  • Service-oriented computing
  • Transformation pattern
  • Web services

ASJC Scopus subject areas

  • Software
  • Theoretical Computer Science
  • Information Systems
  • Computer Networks and Communications


Dive into the research topics of 'Reverse engineering relational databases to identify and specify basic Web services with respect to service oriented computing'. Together they form a unique fingerprint.

Cite this