Skip to main content
SpringerLink
Log in

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

  • Published:
Information Systems Frontiers Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

References

  • Altman, R. (2003). The challenge of Web services. Business Integration Journal, July, 59.

  • Arsanjani, A. (2002). Developing and integrating enterprise components and services. Communications of the ACM, 45(10), 31–34.

    Article  Google Scholar 

  • Arsanjani, A. (2004). Service-oriented modeling and architecture. http://www-128.ibm.com/developerworks/webservices/library/ws-soa-design1/.

  • Austin, D., Barbir, A., Ferris C., & Garg, S. (2002). Web Services architecture requirements. W3C Working Group Draft 14.

  • Baghdadi, Y. (2005). A business model for deploying Web services: A data-centric approach based on factual dependencies. Journal of Information Systems and e-Business, 3(2), 151–173.

    Article  Google Scholar 

  • Barry, D. K. (2003). Web services and service-oriented architecture. USA: Elsevier.

    Google Scholar 

  • Booch, G., Rumbaugh, J., & Jacobson, I. (1999). The unified modelling language user guide. Addison Wesley.

  • Chen, M., Chen, A. K. N., & Shao, B. B. M. (2003). Implications and impacts of Web services to EC research and practices. Journal of Electronic Commerce Research, 4(4), 128–139.

    Google Scholar 

  • Collins, S. R., Navathe, B., & Mark, L. (2002). XML schema mappings for heterogeneous database access. Information and Software Technology, 44(4), 251–257.

    Article  Google Scholar 

  • Crnkovic, I., Hnich, B., Jonsson, T., & Kiziltan, Z. (2002). Specification, implementation, and deployment of components. Communications of the ACM, 45(10), 35–40.

    Article  Google Scholar 

  • Curbera, F., Khalaf, R., Mukhi, N., Tai, S., & Weerawarana, S. (2003). The next step in Web services. Communications of the ACM, 46(10), 29–34.

    Article  Google Scholar 

  • Endrei, M., et al. (2004). Patterns: Service-oriented architecture and Web services. http://www.IBM.com/Redbooks.

  • Fernandez, M., Florescu, D., Kang, J., Levi, A., & Suciu, D. (1998). Catching the boat with strudel: Experience with Web site management system. SIGMOD Record, 27(2), 414–425.

    Article  Google Scholar 

  • Fowler, M. (2003). Enterprise application architecture: Mapping relational databases. Addison Wesley Professional.

  • Fremantel, P., Weerawarana, S., & Khalaf, R. (2002). Enterprise services. Communication of the ACM, 45(10), 77–82.

    Google Scholar 

  • Gamma, et al. (1995). Design patterns: Elements of reusable object-oriented software. Reading, Massachusetts: Addison Wesley.

    Google Scholar 

  • Huang, Y., & Chung, J. Y. (2002). A Web services-based framework for business integration solutions. Electronic Commerce Research and Applications, 2(1), 15–26.

    Article  Google Scholar 

  • Huhns, M. N., & Singh, M. P. (2005). Service-oriented computing: Key concepts and principles. IEEE Internet Computing, Jan/Feb, 9(1), 75–81.

  • Kreger, H. (2003). Fulfilling the Web services promise. Communication of the ACM, 46(6), 29–34.

    Article  Google Scholar 

  • Levi, K., & Arsanjani, A. (2002). Goal-driven approach to enterprise component identification and specification. Communication of the ACM, 45(10), 45–52.

    Article  Google Scholar 

  • Meredith, L. G., & Bjorg, S. (2003). Contracts and types. Communications of the ACM, 46(10), 41–48.

    Article  Google Scholar 

  • Papazoglou, M. P. (2003). Web services and business transactions. WWW: Internet and Web Information Systems, 6(1), 49–91.

    Google Scholar 

  • Papazoglou, M. P., & Georgakopoulos, D. (2003). Service-oriented computing. Communications of the ACM, 46(10), 25–28.

    Article  Google Scholar 

  • Papazoglou, M. P., & Yang, J. (2002). Design methodology for Web services and business process. Proceedings of the third international workshop on technologies for E-services, 54–64.

  • Polo, M., Gomez, J. A., Piattini, M., & Ruiz, F. (2002). Generating three-tier applications from relational databases: A formal and practical approach. Journal of Information ad Software technology, 44, 923–941.

    Article  Google Scholar 

  • Premerlani, W. J., & Blaha, M. R. (1994). An approach for reverse engineering relational databases. Communications of the ACM, 37(5), 42–49.

    Article  Google Scholar 

  • Smith, D. (2004). Web services enable service-oriented and event-driven architectures. Business Integration Journal, May, 12–14.

  • Stal, M. (2002). Web services: Beyond component-based computing. Communication of the ACM, 45(10), 71–76.

    Article  Google Scholar 

  • Sycara, K., Paolucci, M., Ankolekar, P., & Srinivasan, N. (2003). Automated discovery, interaction and composition of semantic Web services. Journal of Web Semantics, 1(1), 27–46.

    Google Scholar 

  • Van den Brandt, M. G. J., Klint, P., & Verhoef, C. (1997). Reverse engineering and system renovation: An annotated bibliography. ACM SIGSOFT Software Engineering Notes, 22(1), 57–68.

    Article  Google Scholar 

  • Zimmermann, O., Korgdahl, P., & Gee C. (2004). Elements of service-oriented analysis and design: An interdisciplinary approach for SOA projects. http://www-128.ibm.com/developerworks/webservices/library/ws-soad1/.

Download references

Author information

Authors and Affiliations

  1. Sultan Qaboos University, Muscat, Oman

    Youcef Baghdadi

Authors
  1. Youcef Baghdadi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Youcef Baghdadi.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Baghdadi, Y. Reverse engineering relational databases to identify and specify basic Web services with respect to service oriented computing. Inf Syst Front 8, 395–410 (2006). https://doi.org/10.1007/s10796-006-9007-2

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10796-006-9007-2

Keywords

Search

Navigation