Heuristic co-identification of objects across heterogeneous info

Data processing: database and file management or data structures – Database design – Data structure types

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

707 2, 707 3, 707103, 707104, 707 4, 707100, G06F 1730

Patent

active

061086517

ABSTRACT:
A method and system for generating a database query language request for performing a join between a plurality of database tables including a first database table and a second database table. The first table includes a first plurality of fields and the second database table includes a second plurality of fields, where each one of the plurality of fields has a particular meaning. The method and system includes providing a plurality of expressions that communicate the meaning of the each of the fields in the first and second plurality of fields. A user then submits a query requesting information from the tables in the form of a conjunction of literals. Each of the literals are then mapped to all matching expressions to provide a list of fields to be queried. The list of fields includes a first field from the first table and a second field from the second table, such that the mapping indicates that the first and second fields have the same meaning. After mapping the literals to the expressions, the database query language request is generated using the list of fields, such that the database query language request includes a join between the first and second fields. The first and second tables are then queried using the database query language request to provide the requested information.

REFERENCES:
patent: 4930071 (1990-05-01), Tou et al.
patent: 5317742 (1994-05-01), Bapat
patent: 5544355 (1996-08-01), Chaudhuri et al.
patent: 5594898 (1997-01-01), Dalal et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5630121 (1997-05-01), Braden-Harder et al.
patent: 5826077 (1998-10-01), Blakeley et al.
patent: 5895465 (1999-04-01), Guha
patent: 5943665 (1999-08-01), Guha
patent: 5970490 (1999-10-01), Morgenstern
Gruber, Martin, "Understanding SQL", 1990 Sybex Inc., ISBN: 0-89588-644-8 pp. 87-123, Jan. 1990.
Jang Gi-Hwa, "An Extended Model for Integration between the Oracle DBMS and WWW", Proceedings of 1997 International Conference on Information, Communications and Signal Processing, 1997 ICICS., Sep. 9-12, 1997 vol. 1, ISBN 0-7803-3676-3, pp. 569-572.
Mullen, James, "Supporting queries in the O-Raid object-oriented database system", Fourteenth Annual International Computer Software and Applications Conference, 1990. Oct. 31-Nov. 2 1990, ISBN: 0-8186-2054-4, pp. 245-250.
Yan, Weipeng, "Performing group-by before join/spl lsqb/query processing/spl rsqb/", Proceedings 10th International Conference Data Engineering, 1994. ISBN: 0-8186-5402-3, Feb. 14-18, 1994, pp. 89-100.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Heuristic co-identification of objects across heterogeneous info does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Heuristic co-identification of objects across heterogeneous info, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Heuristic co-identification of objects across heterogeneous info will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-593086

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.