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

Research output: Contribution to journalArticle

16 Citations (Scopus)

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 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
Volume8
Issue number5
DOIs
Publication statusPublished - Dec 2006

Fingerprint

Service-oriented Computing
Reverse engineering
Reverse Engineering
Relational Database
Web services
Web Services
Service oriented architecture (SOA)
Specifications
Service-oriented Architecture
Schema
XML
Industry
Specification
Acoustic waves
Internet
Design Patterns
Distributed Applications
Network protocols
Electronic Commerce
Building Blocks

Keywords

  • 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

  • Information Systems
  • Theoretical Computer Science
  • Computational Theory and Mathematics

Cite this

@article{26a9cf92094b4fd19e8b75c725514136,
title = "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 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.",
keywords = "Application architecture, CASE tool, CRUD operations pattern, Relational databases, Reverse engineering process, Service-oriented architecture, Service-oriented computing, Transformation pattern, Web services",
author = "Youcef Baghdadi",
year = "2006",
month = "12",
doi = "10.1007/s10796-006-9007-2",
language = "English",
volume = "8",
pages = "395--410",
journal = "Information Systems Frontiers",
issn = "1387-3326",
publisher = "Springer Netherlands",
number = "5",

}

TY - JOUR

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

AU - Baghdadi, Youcef

PY - 2006/12

Y1 - 2006/12

N2 - 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.

AB - 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.

KW - Application architecture

KW - CASE tool

KW - CRUD operations pattern

KW - Relational databases

KW - Reverse engineering process

KW - Service-oriented architecture

KW - Service-oriented computing

KW - Transformation pattern

KW - Web services

UR - http://www.scopus.com/inward/record.url?scp=33846164052&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=33846164052&partnerID=8YFLogxK

U2 - 10.1007/s10796-006-9007-2

DO - 10.1007/s10796-006-9007-2

M3 - Article

AN - SCOPUS:33846164052

VL - 8

SP - 395

EP - 410

JO - Information Systems Frontiers

JF - Information Systems Frontiers

SN - 1387-3326

IS - 5

ER -