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

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

2006-01-17

2006-01-17

Alam, Hosain (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

06988094

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: 5548755 (1996-08-01), Leung 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 field and its use to 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 field and its use to 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 field and its use to in data... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3591743