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
SN - 1387-3326
VL - 8
SP - 395
EP - 410
JO - Information Systems Frontiers
JF - Information Systems Frontiers
IS - 5
ER -