Multi-part looked-up table fields and its use in data...

Details Multi-part looked-up table fields and its use in data... Multi-part looked-up table fields and its use in data...

2005-10-18

2008-11-11

Lee, Wilson (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07451138

ABSTRACT:
In accordance with a first aspect, a software component is equipped to identify looked-up table fields in a data processing statement, and automatically includes with a SQL statement one or more appropriate JOIN clauses joining one or more target tables from which the table fields are to be looked up with a basis table. In one embodiment, the looked-up table fields are expressed in a multi-part form. In accordance with a second aspect, a software component is equipped to automatically expand table fields available for inclusion in a data processing operation to include table fields of a target table of a look-up table field, in response to the selection of the look-up table field. In one embodiment, the second aspect is practiced in conjunction with the automatic inclusion of appropriate JOIN clauses to a SQL statement of the first aspect.

REFERENCES:
patent: 5291583 (1994-03-01), Bapat
patent: 5412804 (1995-05-01), Krishna
patent: 5499359 (1996-03-01), Vijaykumar
patent: 5548755 (1996-08-01), Leung et al.
patent: 5615367 (1997-03-01), Bennett et al.
patent: 5619688 (1997-04-01), Bosworth et al.
patent: 5832477 (1998-11-01), Bhargava et al.
patent: 6088691 (2000-07-01), Bhargava et al.
patent: 2002/0013779 (2002-01-01), Sridhar

Affiliated with

Also associated with

Rating

Multi-part looked-up table fields and its use in data... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Multi-part looked-up table fields and its use in data..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multi-part looked-up table fields and its use in data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4029293