Method and system for schema matching of web databases

Details Method and system for schema matching of web databases Method and system for schema matching of web databases

2007-07-24

2007-07-24

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10846396

ABSTRACT:
A method and system for identifying schemas of web databases is provided. A schema matching system generates a mapping between an interface schema and a result schema of a web database, which is used to represent the underlying database schema. The schema matching system also generates a mapping of the interface attributes and the result attributes of the web database to global attributes of a global schema whose semantics are known. Using these mappings, a search engine service can formulate queries using the global attributes, map those queries to the corresponding interface attributes, submit the query, and retrieve the values from the result attributes that correspond to the desired global attributes.

REFERENCES:
Wang et al., “Data Extraction and Label Assignment for Web Databases”, WWW 2003, May 20-24, 2003, Budapest, Hungary, pp. 187-196.
Berlin et al., “Database Schema Matching Using Machine Learning with Feature Selection”, CAISE 2002, LNCS 2348, Springer-Verlag, pp. 452-466. (Provided by Applicant).
Hai He et al., “WISE-Integrator: An Automatic Integrator of Web Search Interfaces for E-Commerce”, Proceedings of the 29thVLDB Conference, Berlin, Germany, 2003, 12 pages. (Provided by Applicant).
Kang et al., “On Schema Matching with Opaque Column Names and Data Values”, SIGMOD 2003, Jun. 9-12, 2003, San Diego, CA, ACM, 12 pages. (Provided by Applicant).
Cohen, William W., “Integration of Heterogeneous Databases Without Common Domains Using Queries Based on Textual Similarity,” SIGMOD '98, Seattle, Washington (12 pages).
Nie, Zaiqing, et al., “Mining Coverage Statistics for Websource Selection in a Mediator,” Conference on Information and Knowledge Management, Proceedings of the Eleventh International Conference on Information and Knowledge Management, 2002 (35 pages).
Ipeirotis, Panagiotis, G. et al., “Extending SDARTS: Extracting Metadata from Web Databases and Interfacing with the Open Archives Initiative,” JCDL '02, Jul. 13-17, 2002, Portland, Oregon (9 pages).
Wang, Jiying, “Data Extraction and Label Assignment for Web Databases,” May 20-24, 2003, Budapest, Hungary (17 pages). http://www2003.org/cdrom/papers/refereed/p470/p470-wang.htm.
Raghavan, Sriram and Garcia-Molina, Hector, “Crawling the Hidden Web,” Proceedings of the 27thVLDB Conference, Rome, Italy, 2001 (10 pages).
He, Bin and Chang, Kevin Chen-Chuan, “Statistical Schema Matching Across Web Query Interfaces,” SIGMOD 2003, Jun. 9-12, 2003, San Diego, California, Copyright 2003 ACM (12 pages).
Weiyi Meng, Hai He et al., “WISE-Integrator: An Automatic Integrator of Web Search Interfaces for E-Commerce,” Proceedings of the 29thVLDB Conference, Berlin, Germany, 2003 (12 pages).
European Search Report, Application No. EP 05103966, May 29, 2006, 4 pages.
Berlin, Jacob and Amihai Motro, “Database Schema Matching Using Machine Learning with Feature Selection,” CAISE 2002, LNCS 2348, © 2002 Springer-Verlag, pp. 452-466.
Wang, Jiying et al., “Instance-based Schema Matching for Web Databases by Domain-specific Query Probing,” Proceedings of the 30th VLDB Conference, Toronto, Canada, 2004, pp. 408-419.
Kang, Jaewoo and Jeffrey F. Naughton, “On Schema Matching with Opaque Column Names and Data Values,” SIGMOD Jun. 9-12, 2003, San Diego, © 2003 ACM, 12 pages.
Arasu, Arvind and Hector Garcia-Molina, “Extracting Structured Data from Web Pages,” SIGMOD Jun. 9-12, 2003, San Diego, CA, © 2003 ACM, pp. 337-348.
Gal, Avigdor et al., “Automatic Ontology Matching using Application Semantics,” Al Magazine, American Association of Artificial Intelligence, La Canada, CA, 2003, pp. 1-16.
He, Bin and Kevin Chen-Chuan Chang, “Automatic Complex Schema Matching across Web Query Interfaces: A Correlation Mining Approach,” ACM Transactions on Database Systems, vol. 31, No. 1, Mar. 2006, pp. 1-45.

Affiliated with

Also associated with

Rating

Method and system for schema matching of web databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for schema matching of web databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for schema matching of web databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3819434