Product Schema Integration for Electronic Commerce - A Synonym Comparison Approach

In any electronic commerce system, the heterogeneity of product descriptions is a critical impediment to efficient business information exchange. In the ABECOS electronic commerce system, buyer agents, seller agents, and directory agents liaise with one another in e-commerce activities. Only when agents have a common ontology of product descriptions (also called product schemas) are they able to interact seamlessly in e-commerce activities. This gives rise to the product schema integration problem (PSI); the problem of integrating heterogeneous schemas of a certain product into one globally compatible schema. We adopt an integration approach based on product attribute synonyms. We give a formal definition of the problem and show that it is NP-complete. We contrast our approach of study to conventional schema integration in federated databases. We also propose a set of approximate algorithms for PSI and evaluate their performance.

[1]  Michael Stonebraker,et al.  Database research: achievements and opportunities into the 1st century , 1996, SGMD.

[2]  Yelena Yesha,et al.  Strategic directions in electronic commerce and digital libraries: towards a digital agora , 1996, CSUR.

[3]  Michael Stonebraker,et al.  The Asilomar report on database research , 1998, SGMD.

[4]  Ee-Peng Lim,et al.  Heterogeneous product description in electronic commerce , 2000, SECO.

[5]  Abraham Silberschatz,et al.  Strategic directions in database systems—breaking out of the box , 1996, CSUR.

[6]  Clement T. Yu,et al.  Determining relationships among attributes for interoperability of multi-database systems , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[7]  William J. Premerlani,et al.  An approach for reverse engineering of relational databases , 1993, [1993] Proceedings Working Conference on Reverse Engineering.

[8]  Stephen Hayne,et al.  Multi-user view integration system (MUVIS): an expert system for view integration , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[9]  Stéphane Bressan,et al.  The Context Interchange mediator prototype , 1997, SIGMOD '97.

[10]  James A. Larson,et al.  A tool for integrating conceptual schemas and user views , 1988, Proceedings. Fourth International Conference on Data Engineering.

[11]  Marti A. Hearst Trends & Controversies: Information integration , 1998, IEEE Intell. Syst..

[12]  Christine Collet,et al.  Resource integration using a large knowledge base in Carnot , 1991, Computer.

[13]  Douglas B. Lenat,et al.  CYC: a large-scale investment in knowledge infrastructure , 1995, CACM.

[14]  James A. Larson,et al.  A Theory of Attribute Equivalence in Databases with Application to Schema Integration , 1989, IEEE Trans. Software Eng..

[15]  David S. Johnson,et al.  Computers and Intractability: A Guide to the Theory of NP-Completeness , 1978 .

[16]  SilberschatzAvi,et al.  Strategic directions in database systemsbreaking out of the box , 1996 .

[17]  Eugene Wong,et al.  Multibase: integrating heterogeneous distributed database systems , 1981, AFIPS '81.

[18]  Peter Scheuermann,et al.  Multidatabase query processing with uncertainty in global keys and attribute values , 1998 .

[19]  James A. Larson,et al.  Integrating User Views in Database Design , 1986, Computer.

[20]  Gerald Salton,et al.  Automatic text processing , 1988 .

[21]  Ee-Peng Lim,et al.  An Overview of the Agent-Based Electronic Commerce System (ABECOS) Project. , 2000 .

[22]  Alberto O. Mendelzon,et al.  Database techniques for the World-Wide Web: a survey , 1998, SGMD.

[23]  Chris Clifton,et al.  Semantic Integration in Heterogeneous Databases Using Neural Networks , 1994, VLDB.

[24]  Chris Clifton,et al.  Using field specifications to determine attribute equivalence in heterogeneous databases , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.