Skip to main content

Advertisement

Log in

Database Schema Design for a Web Services Supply Chain Manager: Requirements and Proposed Infrastructure

  • Published:
Information Systems Frontiers Aims and scope Submit manuscript

Abstract

Web services enable the commoditization of computer code components for distributed system execution in cross-organizational platforms via the Internet. At any point in time, the state of a set of composite applications and the web services they are consuming constitutes an instance of a new type of dynamic software supply chain. Proper management of what we refer to as this “web services supply chain” requires seamlessly integrated and automated B2B relationships with responsibilities for procurement, performance monitoring, benchmarking, cost allocation and ongoing relationship maintenance requiring new hybrid organizational infrastructure constructs. To cope with the increased complexity of managing this dynamic supply chain, we elaborate requirements and propose an exemplar database schema design with web-scripts as a means for pre-specifying and monitoring organizationally approved patterns of web service invocations. The database research challenges associated with long-running transactions are discussed in our schema design, including reflections of the realities associated with web-script failure, variable quality-of-service (QoS) levels, the share-ability of web-scripts between organizational business processes, the need for continuous updating of web-scripts by agents (human or automated), and the scalability of designs to accommodate evolutionary change.

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

Access this article

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

  • Andrews W, Plummer D, Smith D. How web services mean business, Research Note, Gartner Research, May 9, 2001.

  • Benatallah B, Dumas M, Fauvet M-C, Rabhi FA. Towards patterns of web services composition, working paper, November. http://citeseer.nj.nec.com/472153.htm, 2001.

  • Benatallah B, Dumas M, Fauvet M-C, Rabhi FA, Sheng QZ. Overview of some patterns for architecting and managing composite web services. ACM SIGecom Exchanges 2002;3(3):9–16.

    Google Scholar 

  • Bennett K, Layzell P, Budgen D, Brereton P, Macaulay L, Munro M. Service-based Software: The future for flexible software. In: Proc. of the Seventh Asia Pacific Conference on Software Engineering, December 2000:214–221.

  • Bultan T, Fu X, Hull R, Su J. Web engineering: Conversation specification: A new approach to design and analysis of e-service composition. In: Proc. of the Twelfth International Conference on the World Wide Web, May 2003:403–410.

  • Chiu DKW. A script language for generating internet-bots. In: Proc. of the 12th International Conference on Database and Expert System Applications, September 2001:667–671.

  • DARPA. Harnessing the power of netcentricity: A national research agenda, Robert H. Smith School of Business, University of Maryland, College Park, MD, 1999.

  • Florescu D, Levy A, Mendelzon A. Database techniques for the word-wide web: A survey. SIGMOD Record 1998;27(3):59–74.

    Google Scholar 

  • Ganesarajah D, Lupu E. Workflow-based composition of web services: Abusiness model or a programming paradigm? In: Enterprise Distributed Object Computing Conference, 2002. EDOC’02. 17–20 Sept. 2002:273–284.

  • Goldman RP, Heimerdinger W, Harp SA, Geib CW, Thomas V, Carter RL. Information modeling for intrusion report aggregation. In: Proc. for DARPA Information Survivability Conference and exposition II, 2001, DISCEX’01.

  • Goul M, Chenoweth T, Philippakis A. Stored procedure language extensions for coupling web services managers and DBMS. In: Proc. of AIS, Dallas, TX, August 2002.

  • Leymann F, Roller D, Schmidt M-T. Web services and business process management. IBM Systems Journal 2002;(41)2:198–211.

    Google Scholar 

  • March S, Hevner A, Ram S. Research Commentary: An Agenda for Information Technology Research in Heterogeneous and Distributed Environments. Information Systems Research 2000;11(4):327–341.

    Article  Google Scholar 

  • Moss F. Business Web Automation: A Winning Strategy for Plug-and-Play E-Commerce, September. http://www.bowstreet.com, 2001.

  • Singh MP. Temporal issues: Distributed enactment of multiagent workflows: Temporal logic for web service composition. In: Proceedings of the Second International Joint Conference on Autonomous Agents and Multiagent Systems, July 2003:907–914.

  • Stencil Group. (2001). Defining Web Services, The Stencil Scope, June. http://www.stencilgroup.com/ideas_scope200106wsdefined.html.

  • Swaminath J, Smith S, Sadeh N. Modeling Supply Chain Dynamics: A Multiagent Approach. Decision Sciences Summer,1998;29(3): 607–632.

    Google Scholar 

  • Tapscott D, Lowy A, Ticoll D. Digital Capital: Harnessing the Power of Business Webs. Harvard Business School Press, 2000.

  • Thatte S. Message exchange protocols for web services. In: Electronic Proceedings of W3C Workshop on Web Services, April, 1–5. http://www.w3.org/2001/03/WSWS-popa, 2001.

  • Thomas DJ, Griffin PM. Coordinated supply chain management. European Journal of Operational Research 1996;94:1–15.

    Google Scholar 

  • VanderMeer D, Datta A, Dutta K, Thomas H, Ramamritham K, Navathe SB. FUSION: A system allowing dynamic web service composition and automatic execution. In: IEEE International Conference on E-Commerce, 2003. CEC 2003, 24–27 June 2003, pp. 399–404.

  • Yung S, Yang C. A New approach to solve supply chain management problems by integrating multi-agent technology and constraint network. In: Proceedings of the 32nd Hawaii International Conference on System Science, IEEE Press, January, 1–10, 1999.

  • Zeng L, Benetallah B, Dumas M, Kalagnanam J, Sheng Q. Web engineering: Quality driven web services composition. In: Proc. of the Twelfth International Conference on the World Wide Web, May 2003:411–421.

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Michael Goul.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Goul, M., Corral, K. & Demirkan, H. Database Schema Design for a Web Services Supply Chain Manager: Requirements and Proposed Infrastructure. Inf Syst Front 7, 257–271 (2005). https://doi.org/10.1007/s10796-005-2769-0

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10796-005-2769-0

Keywords

Navigation