Intelligent joining system for a relational database

Details Intelligent joining system for a relational database Intelligent joining system for a relational database

1996-05-23

1997-12-23

Kulik, Paul

395604, G06F 1730

Patent

active

057014604

ABSTRACT:
A system for generating a structured query language query to extract data from a database wherein the database includes a schema defined by a plurality of record sources and a plurality of relationships therebetween. The system includes selecting a field set containing at least one field from among said plurality record sources in said database, and determining a minimal path relationship between each of the plurality of record sources in the database that contain at least one field from the field set. The minimal path relationship includes at least one indirect relationship between two of the plurality of record sources in the database that contain at least one field from the field set. Output from the intelligent joining system is a Structured Query Language (SQL) statement in the syntactical form that a database management system can execute. Additional output can include an edge set containing the minimal paths between record sources that contain at least one field from the field set, and a graph of the sub-schema defined by the field set. The output is generated from the above identified inputs in a manner transparent to the database user.

REFERENCES:
patent: 5495605 (1996-02-01), Cadot
patent: 5548755 (1996-08-01), Leung et al.
patent: 5572650 (1996-11-01), Antis et al.
patent: 5596746 (1997-01-01), Sheo et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5630120 (1997-05-01), Vachey

Affiliated with

Also associated with

Rating

Intelligent joining system for a relational database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Intelligent joining system for a relational database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Intelligent joining system for a relational database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1807970