Skip to main content
SpringerLink
Log in

Enabling Supply-Chain Coordination: Leveraging Legacy Sources for Rich Decision Support

  • Chapter
Applications of Supply Chain Management and E-Commerce Research

Part of the book series: Applied Optimization ((APOP,volume 92))

Abstract

As supply chains come under escalating pressure for responsiveness to customer demands as well as cost pressures, there is increased scope for decision support models to enhance coordination of supply chain activities. However, enhanced coordination implicitly requires sharing information about costs, production capacity, materials availability, delivery schedules, etc. This information is currently stored in a panoply of legacy information systems distributed across the many firms that comprise a given supply chain. As such, accessing useful information presents considerable technical challenges, effectively limiting the deployment of decision support tools for supply chain operations. The purpose of this chapter is to present the research issues and approaches to accessing or integrating data in legacy information systems. Current industry approaches to information integration, including information hubs and Web Services technologies, are briefly reviewed and critiqued as useful but inadequate to the task of integrating data stored in legacy systems. Recommended requirements for new methods include rapid deployment, ability to connect to heterogeneous legacy systems, composition of knowledge for decision support, and provision for secure data access. These requirements motivate a review of the research literature on knowledge extraction and composition. As an example of new methods built from current research, an integrated toolkit known as SEEK: Scalable Extraction of Enterprise Knowledge is presented. Capabilities and limitations of the SEEK toolkit are used to suggest novel areas of research in visualization and representation of data for human refinement of automatic integration results, as well as further development of evolutionary algorithms to enhance the scope of automatic knowledge extraction. Throughout the chapter, an example of a construction industry supply chain is used to motivate discussion.

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

Access this chapter

Log in via an institution
eBook
USD 16.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 159.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  • Agrawal, R., Mannila, H., Srikant, R., Toivonen, H., and Verkamo, A. I. (1996). “Fast Discovery of Association Rules.” Advances in Knowledge Discovery and Data Mining, U. M. Fayyad, G. Piatetsky-Shapiro, P. Smyth, and R. Uthurusamy, eds., AAAI/MIT Press.

    Google Scholar 

  • Ahmed, R., Albert, J., Du, W., Kent, W., Litwin, W., and Shan, M.-C. (1993). “An Overview of Pegasus.” Research Issues in Data Engineering, 273–277.

    Google Scholar 

  • Aiken, P. (1996). Data Reverse Engineering: Slaying the Legacy Dragon, McGraw-Hill.

    Google Scholar 

  • Aiken, P., Muntz, A., and Richards, R. (1994). “DoD legacy systems: Reverse engineering data requirements.” Communications of the ACM, 37(5), 26–41.

    Article  Google Scholar 

  • Amor, R., and Faraj, I. (2001). “Misconceptions about integrated project databases.” ITcon, 6, 57–66.

    Google Scholar 

  • Arens, Y., Chee, C.Y., Hsu, C., and Knoblock, C. (1993). “Retrieving and Integrating Data from Multiple Information Sources.” International Journal of Intelligent & Cooperative Information Systems, 2(2), 127–158.

    Article  Google Scholar 

  • Ballard, G. (1999). “Improving Work Flow Reliability.” Seventh Annual Conference of the International Group for Lean Construction, IGLC-7, Berkeley, CA, July 26–28, 1999, 275–286

    Google Scholar 

  • Bayardo, R., Bohrer, W., Brice, R., Cichocki, A., Fowler, G., Helal, A., Kashyap, V., Ksiezyk, T., Martin, G., Nodine, M., Rashid, M., Rusinkiewicz, M., Shea, R., Unnikrishnan, C., Unruh, A., and Woelk, D. (1996). “Semantic Integration of Information in Open and Dynamic Environments.” MCC-INSL-088-96, MCC.

    Google Scholar 

  • Beyer, D., and Ward, J. (2002). “Network server supply chain at HP: a case study.” Supply Chain Structures: Coordination, Information, and Optimization, J.-S. Song and D. Yao, eds., Kluwer Academic Publishers, Boston/Dordrecht/London, 257–282.

    Google Scholar 

  • Boulanger, D., and March, S.T. (1989). “An approach to analyzing the information content of existing databases.” Database, 1–8.

    Google Scholar 

  • Cai, Y., Cercone, N., and Han, J. (1991). “Attribute-oriented Induction in Relational Databases.” Knowledge Discovery in Databases, G. Piatetsky-Shapiro and W. J. Fawley, eds., AAAI/MIT Press, Cambridge, MA.

    Google Scholar 

  • Casanova, M.A., and Sa, J.E.A.D. (1983). “Designing entity-relationship schemas for conventional information systems.” Third International Conference on Entity-Relationship Approach, August 1983.

    Google Scholar 

  • Castro-Raventós, R. (2002). “Comparative Case Studies of Subcontractor Information Control Systems,” M.S. Thesis, University of Florida.

    Google Scholar 

  • Chawathe, S., Garcia-Molina, H., Hammer, J., Ireland, K., Papakon-stantinou, Y., Ullman, J., and Widom, J. (1994). “The TSIMMIS Project: Integration of Heterogeneous Information Sources.” Tenth Anniversary Meeting of the Information Processing Society of Japan, Tokyo, Japan, October 1994, 7–18.

    Google Scholar 

  • Chiang, R.H. (1995). “A knowledge-based system for performing reverse engineering of relational database.” Decision Support Systems, 13, 295–312.

    Article  Google Scholar 

  • Chiang, R.H.L., Barron, T. M., and Storey, V. C. (1994). “Reverse engineering of relational databases: Extraction of an EER model from a relational database.” Data and Knowledge Engineering, 12(1), 107–142.

    Article  Google Scholar 

  • Chikofsky, E.a.J.C. (1990). “Reverse engineering and design recovery: A taxonomy.” IEEE Software, 7(1), 13–17.

    Article  Google Scholar 

  • Codd, E.F. (1970). “A Relational Model for Large Shared Data Banks.” Communications of the ACM, 13(6), 377–387.

    Article  MATH  Google Scholar 

  • Connolly, D. (1997). “Extensible Markup Language (XML).” W3C.

    Google Scholar 

  • DARPA. (2000). “The DARPA Agent Markup Language Homepage.”

    Google Scholar 

  • Davis, K.H. (1995). “August-II: A tool for step-by-step data model reverse engineering.” IEEE Second Working Conference on Reverse Engineering, May 1995, 146–155.

    Google Scholar 

  • Davis, K.H., and Aiken, P. (2000). “Data reverse engineering: A historical survey.” IEEE Seventh Working Conference on Reverse Engineering, November 2000, 70–78.

    Google Scholar 

  • Davis, K.H., and Arora, A.K. (1985). “Methodology for translating a conventional file system into an entity-relationship model.” Fourth International Conference on Entity-Relationship Approach, November 1985, 148–159.

    Google Scholar 

  • Davis, K.H., and Arora, A.K. (1987). “Converting a relational database model into an entity-relationship model.” Sixth International Conference on Entity-Relationship Approach, October 1987, 271–285.

    Google Scholar 

  • Dayani-Fard, H., and Jurisica, I. (1998). “Reverse engineering: A History-Where we've been and what we've done.” IEEE Fifth Working Conference on Reverse Engineering, April 1998, 174–182.

    Google Scholar 

  • DeGroot, M.H., and Schervish, M.J. (2002). Probability and Statistics, Addison-Wesley Publishing, Reading, MA.

    Google Scholar 

  • Dumpala, S.R., and Arora, S.K. (1981). “Schema translation using the entity-relationship approach.” Second International Conference on the Entity-Relationship Approach, August 1981, 337–356.

    Google Scholar 

  • Elmasri, R., and S.B. Navathe. (2000). Fundamentals of database systems, 3rd ed., Addison-Wesley.

    Google Scholar 

  • Englebert, V., and Hainaut, J.-L. (1999). “DB-MAIN: A next generation Meta-CASE.” Information Systems Journal, 24(2), 99–112.

    Article  Google Scholar 

  • Gallego, G., and Özer, Ö. (2002). “Optimal Use of demand information in supply chain management.” Supply Chain Structures: Coordination, Information, and Optimization, J.-S. Song and D. Yao, eds., Kluwer Academic Publishers, Boston/Dordrecht/London, 119–160.

    Google Scholar 

  • Genesereth, M., and Duschka, O. (1997). “Answering Recursive Queries Using Views.” ACM Symposium on Principles of Database Systems, Tucson, AZ, June 1997, 109–116.

    Google Scholar 

  • Hainaut, J.-L. (1991). “Database reverse engineering: Models, techniques, and strategies.” 10th International Conference on Entity-Relationship Approach, November 1991, 729–741.

    Google Scholar 

  • Hammer, J., Breunig, M., Garcia-Molina, H., Nestorov, S., Vassalos, V., and Yemeni, R. (1997a). “Template-Based Wrappers in the TSIMMIS System.” Twenty-Third ACM SIGMOD International Conference on Management of Data, Tucson, Arizona, May 23–25, 1997, 532.

    Google Scholar 

  • Hammer, J., Garcia-Molina, H., Ireland, K., Papakonstantinou, Y., Ullman, J., and Widom, J. (1995). “Integrating and Accessing Heterogeneous Information Sources in TSIMMIS.” AAAI Symposium on Information Gathering, Stanford, CA, March 1995, 61–64.

    Google Scholar 

  • Hammer, J., McHugh, J., and Garcia-Molina, H. (1997b). “Semistructured Data: The TSIMMIS Experience.” First East-European Symposium on Advances in Databases and Information Systems (ADBIS '97), St. Petersburg, Russia, September 1997, 1–8.

    Google Scholar 

  • Hammer, J., Schmalz, M., O'Brien, W., Shekar, S., and Haldavnekar, N. (2002). “Knowledge Extraction in the SEEK Project.” TR-0214, University of Florida, Gainesville, FL 32611-6120, 30.

    Google Scholar 

  • Han, J., and Kamber, M. (2001). Data Mining: Concepts and Techniques, Morgan Kaufmann Publishers, San Francisco, CA.

    Google Scholar 

  • Han, J., Nishio, S., Kawano, H., and Wang, W. (1998). “Generalization-based Data Mining in Object-Oriented Databases Using an Object-cube Model.” Data and Knowledge Engineering, 25, 55–97.

    Article  MATH  Google Scholar 

  • Hensley, J., and Davis, K.H. (2000). “Gaining domain knowledge while data reverse engineering: An experience report.” Data Reverse Engineering Workshop, EuroRef Seventh Reengineering Forum, January 2000.

    Google Scholar 

  • Horwitz, S., and Reps, T. (1992). “The use of program dependence graphs in software engineering.” Fourteenth International Conference on Software Engineering, Melbourne, Australia, May 1992.

    Google Scholar 

  • Jain, A.K., Murty, M.N., and Flynn, P.J. (1999). “Data Clustering: A Survey.” ACM Computing Surveys, 31(2), 264–323.

    Article  Google Scholar 

  • Johannesson, P., and Kalman, K. (1989). “A method for translating relational schemas into conceptual schemas.” Eighth International Conference on the Entity-Relationship Approach, November 1989, 271–285.

    Google Scholar 

  • Kirk, T., Levy, A., Sagiv, J., and Srivastava, D. (1995). “The Information Manifold.” AT&T Bell Laboratories

    Google Scholar 

  • Klug, A.C. (1980). “Entity-relationship views over uninterpreted enterprise schemas.” First International Conference on the Entity-Relationship Approach, August 1980, 39–60.

    Google Scholar 

  • Lassila, and Swick. (1999). “Resource Description Framework (RDF) Model and Syntax Specification.”

    Google Scholar 

  • Lee, H.L., and Whang, S. (2001). “E-Business and Supply Chain Integration.” SGSCMF-W2-2001, Stanford Global Supply Chain Management Forum, 20 pages.

    Google Scholar 

  • Lee, H.L., and Whang, S. (2002). “Supply chain integration over the internet.” Supply Chain Management: Models, Applications, and Research Directions, J. Geunes, P. M. Pardalos, and H. E. Romeijn, eds., Kluwer Academic Publishers, Dordrecht/Boston/London, 3–18.

    Google Scholar 

  • Lee, M., and Hammer, J. (2001). “Speeding Up Warehouse Physical Design Using A Randomized Algorithm.” International Journal of Co-operative Information Systems (IJCIS), 10(3), 327–354.

    Article  Google Scholar 

  • Levy, A., Rajaraman, A., and Ordille, J.J. (1996). “Querying heterogeneous information sources using source descriptions.” International Conference on Very Large Databases, Bombay, India, September 1996, 251–262.

    Google Scholar 

  • Li, C., Yerneni, R., Vassalos, V., Garcia-Molina, H., Papakonstantinou, Y., Ullman, J. D., and Valiveti, M. (1998). “Capability Based Mediation in TSIMMIS.” Proceedings of the ACM SIGMOD International Conference on Management of Data, Seattle, Washington, June 2–4, 1998, 564–566.

    Google Scholar 

  • Markowitz, V.M. and Makowsky, J.A. (1990). “Identifying extended entity-relationship object structures in relational schemas.” IEEE Transactions on Software Engineering, 16(8), 777–790.

    Article  Google Scholar 

  • Maybury, M. (2001). “Human language technologies for knowledge management: challenges and opportunities.” Mitre Corporation Technical Note, Mitre Corporation, Bedford, MA

    Google Scholar 

  • Melkanoff, M.A., and Zaniolo, C. (1980). “Decomposition of relations and synthesis of entity-relationship diagrams.” First International Conference on the Entity-Relationship Approach, August 1980, 277–294.

    Google Scholar 

  • Microsoft Corp. (2000). “Microsoft Project 2000 Database Design Diagram.”

    Google Scholar 

  • Mitchell, T. (1997). Machine Learning, McGraw-Hill Science., New York, NY.

    MATH  Google Scholar 

  • Moh, C.-H., E-P. Lim, and W-K. Ng. (2000). “Re-engineering structures from Web documents.” ACM International Conference on Digital Libraries 2000, 67–76.

    Google Scholar 

  • Morey, D., Maybury, M., and Thuraisingham, B., eds. (2000). Knowledge Management: Classic and Contemporary Works. MIT Press, Cambridge, MA.

    Google Scholar 

  • Navathe, S.B., and Awong, A.M. (1988). “Abstracting relational and hierarchical data with a semantic data model.” Entity-Relationship Approach, 305–333.

    Google Scholar 

  • Nilsson, E.G. (1985). “The translation of COBOL data structures to an entity-relationship type conceptual schema.” Fourth International Conference on the Entity-Relationship Approach, November 1985, 170–177.

    Google Scholar 

  • O'Brien, W.J., Fischer, M.A., and Jucker, J.V. (1995). “An economic view of project coordination.” Construction Management and Economics, 13(5), 393–400.

    Google Scholar 

  • O'Brien, W., and Hammer, J. (2001). “Robust mediation of construction supply chain information.” ASCE Specialty Conference on Fully Integrated and Automated Project Processes (FIAPP) in Civil Engineering, Blacksburg, VA, January 23–25, 2002, 415–425.

    Google Scholar 

  • O'Brien, W.J., Issa, R.R., Hammer, J., Schmalz, M., Geunes, J., and Bai, S. (2002). “SEEK: Accomplishing enterprise information integration across heterogeneous sources.” ITcon-Electronic Journal of Information Technology in Construction-Special Edition on Knowledge Management, 7, 101–124.

    Google Scholar 

  • Palomaeki, A., Wolski, A., Veijalainen, J., and Jokiniemi, J. (1993). “Retrospection on the HERMES PROJECT: Implementation of a Heterogeneous Transaction Management System.” IEEE RIDE-International Workshop on Interoperability in Multidatabase Systems, Vienna, Austria, April 1993.

    Google Scholar 

  • Paul, S., and Prakash, A. (1994). “A Framework for Source Code Search Using Program Patterns.” Software Engineering, 20(6), 463–475.

    Article  MATH  Google Scholar 

  • Petit, J.-M., Toumani, F., Boulicaut, J.-F., and Kouloumdjian, J. (1996). “Towards the Reverse Engineering of Denormalized Relational Databases.” Twelfth International Conference on Data Engineering (ICDE), New Orleans, LA, February 1996, 218–227.

    Google Scholar 

  • Rahm, E. and P.A. Bernstein. (2001). “A survey of approaches to automatic schema matching,” VLDB Journal: Very Large Data Bases, 10, 334–350.

    Article  MATH  Google Scholar 

  • Schlenoff, C., Gruninger, M., Tissot, F., Valois, J., Lubell, J., and Lee, J. (2000). “The Process Specification Language (PSL): Overview and Version 1.0 Specification.” NISTIR 6459, NIST, www.mel.nist.gov/psl/pubs/PSLl.0/paper.doc, 83 pages.

    Google Scholar 

  • Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., and Funderburk, J. (2001). “XPERANTO: Bridging Relational Technology and XML.” IBM Research Report, IBM

    Google Scholar 

  • Shao, J., and Pound, C. (1999). “Reverse engineering business rules from legacy system.” BT Journal, 17(4).

    Google Scholar 

  • Shapiro, J.F. (1999). “Bottom-up vs. Top-down approaches to supply chain modeling.” Quantitative Models for Supply Chain Management, S. Tayur, R. Ganeshan, and M. Magazine, eds., Kluwer Academic Publishers, Boston/Dordrecht/London, 737–760.

    Google Scholar 

  • Shapiro, J.F. (2001). Modeling the Supply Chain, Duxbury, Pacific Grove, CA.

    Google Scholar 

  • Silva, A.M., and Melkanoff, A. (1981). “A method for helping discover the dependencies of a relation.” Conference on Advances in Database Theory, Toulouse, Prance, 115–133.

    Google Scholar 

  • Smith, J.M., Bernstein, P.A., Goodman, N., Dayal, U., Landers, T., Lin, K.W.T., and Wong, E. (1981). “MULTIBASE-Integrating Heterogeneous Distributed Database Systems.” National Computer Conference, March 1981, 487–499.

    Google Scholar 

  • Song, I.-Y., and Froehlich, K. (1995). “Entity-relationship modeling.” IEEE Potentials, 13(5), 29–34.

    Article  Google Scholar 

  • Suciu, D. (1998). “An Overview of Semistructured Data.” SIGACT News, 29(4), 28–38.

    Article  MathSciNet  Google Scholar 

  • Tan, G.W., Shaw, M.J., and Fulkerson, W. (2000). “Web-based global supply chain management.” Handbook on Electronic Commerce, M. J. Shaw, R. Blanning, T. Strader, and A. Whinston, eds., Springer-Verlag, Berlin, 457–480.

    Google Scholar 

  • Tayur, S., Ganeshan, R., and Magazine, M., eds. (1999). Quantitative Models for Supply Chain Management. Kluwer Academic Publishers, Boston/Dordecht/London.

    MATH  Google Scholar 

  • Templeton, T., and Al., E. (1987). “Mermaid: A Front-End to Distributed Heterogeneous Databases.” Computer Science International Conference on Database Engineering, 695–708.

    Google Scholar 

  • Tsay, A.A., Nahmias, S., and Agrawal, N. (1999). “Modeling supply chain contracts: a review.” Quantitative Models for Supply Chain Management, S. Tayur, R. Ganeshan, and M. Magazine, eds., Kluwer Academic Publishers, Boston/Dordrecht/London, 299–336.

    Google Scholar 

  • Verdicchio, M., and Colombetti, M. (2002). “Commitments for agent-based supply chain management.” SIGecom Exchanges, 13–23.

    Google Scholar 

  • Weiss, S.M., and Kulikowski, C.A. (1991). Computer Systems that Learn: Classification and Prediction Methods from Statistics, Neural Nets, Machine Learning, and Expert Systems, Morgan Kaufmann, San Mateo, CA.

    Google Scholar 

  • Wiggerts, T., Bosma, H., and Fielt, E. (1997). “Scenarios for the identification of objects in legacy systems.” IEEE Fourth Working Conference on Reverse Engineering, September 1997, 24–32.

    Google Scholar 

  • Wills, L.M. (1994). “Using attributed flow graph parsing to recognize cliches in programs.” International Workshop on Graph Grammars and Their Application to Computer Science., November 1994, 101–106.

    Google Scholar 

  • Workflow Management Coalition. (2002). “Workflow process definition interface — XML process definition language, version 1.0.” WFMC C1025, The Workflow Management Coalition, http://www.wfmc.org/standards/docs/TC-1025-10_xpdl_102502.pdf, 87 pages.

    Google Scholar 

  • Xyleme, L. (2001). “A dynamic warehouse for XML Data of the Web.” IEEE Data Engineering Bulletin, 24(2), 40–47.

    Google Scholar 

  • Zamanian, M.K., and Pittman, J.H. (1999). “A software industry perspective on AEC information models for distributed collaboration.” Automation in Construction, 8, 237–248.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer & Information Science & Engineering, University of Florida, Florida

    Joachim Hammer

  2. M.E. Rinker, Sr. School of Building Construction, University of Florida, Florida

    William O'Brien

Authors
  1. Joachim Hammer
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. William O'Brien
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. University of Florida, Gainesville, USA

    Joseph Geunes , Elif Akçali , Panos M. Pardalos , H. Edwin Romeijn  & Zuo-Jun Max Shen , , ,  & 

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer Science+Business Media, Inc.

About this chapter

Cite this chapter

Hammer, J., O'Brien, W. (2005). Enabling Supply-Chain Coordination: Leveraging Legacy Sources for Rich Decision Support. In: Geunes, J., Akçali, E., Pardalos, P.M., Romeijn, H.E., Shen, ZJ.M. (eds) Applications of Supply Chain Management and E-Commerce Research. Applied Optimization, vol 92. Springer, Boston, MA. https://doi.org/10.1007/0-387-23392-X_9

Download citation

Publish with us

Policies and ethics

Search

Navigation