Join paths across multiple databases

Details Join paths across multiple databases Join paths across multiple databases

2005-11-22

2009-12-08

Boccio, Vincent (Department: 2158)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07630967

ABSTRACT:
Methods, systems and computer instructions on computer readable media are disclosed for optimizing a query, including a first join path, a second join path, and an optimizer, to efficiently provide high quality information from large, multiple databases. The methods and systems include evaluating a schema graph identifying the join paths between a field X and a field Y, and a value X=x, to identify the top-few values of Y=y that are reachable from a specified X=x value when using the join paths. Each data path that instantiates the schema join paths can be scored and evaluated as to the quality of the data with respect to specified integrity constraints to alleviate data quality problems. Agglomerative scoring methodologies can be implemented to compute high quality information in the form of a top-few answers to a specified problem as requested by the query.

REFERENCES:
patent: 5307484 (1994-04-01), Baker et al.
patent: 5345585 (1994-09-01), Iyer et al.
patent: 5469568 (1995-11-01), Schiefer et al.
patent: 5671403 (1997-09-01), Shekita et al.
patent: 5680603 (1997-10-01), Bhargava et al.
patent: 6115705 (2000-09-01), Larson
patent: 6212514 (2001-04-01), Eberhard et al.
patent: 6477534 (2002-11-01), Acharya et al.
patent: 6643636 (2003-11-01), Au et al.
patent: 6662175 (2003-12-01), Ghazal et al.
patent: 6668253 (2003-12-01), Thompson et al.
patent: 6754652 (2004-06-01), Bestgen et al.
patent: 6904590 (2005-06-01), Ball et al.
patent: 6944633 (2005-09-01), Higa et al.
patent: 6957222 (2005-10-01), Ramesh
patent: 6957225 (2005-10-01), Zait et al.
patent: 2001/0049685 (2001-12-01), Carey et al.
patent: 2003/0061244 (2003-03-01), Hirohata
patent: 2003/0167272 (2003-09-01), Sinnott, Jr.
patent: 2004/0153435 (2004-08-01), Gudbjartsson et al.
patent: 2004/0260675 (2004-12-01), Bruno et al.

Affiliated with

Also associated with

Rating

Join paths across multiple 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 Join paths across multiple databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Join paths across multiple databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4052720