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...

2006-07-11

2006-07-11

Alam, Shahid (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07076482

ABSTRACT:
In accordance with a first aspect, a software component is equipped to identify non-looked-up table fields and looked-up table fields to be grouped, and table fields having aggregate functions to be performed in their row values in a data processing statement, and automatic inclusion with a SQL statement a subquery to generate a grouped derivative table comprising grouped non-looked-up table fields and aggregated table fields, and one or more appropriate JOIN clauses joining one or more target tables from which the table fields are to be looked up with the grouped derivative 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, and selection of aggregation function.

REFERENCES:
patent: 5706494 (1998-01-01), Cochrane et al.
patent: 5724600 (1998-03-01), Ogi
patent: 5875447 (1999-02-01), Goel et al.
patent: 6032144 (2000-02-01), Srivastava et al.
patent: 6327587 (2001-12-01), Forster
patent: 6477534 (2002-11-01), Acharya et al.
patent: 6748374 (2004-06-01), Madan et al.
Silberschatz et al., Database System Concepts, The McGraw-Hill Companies, copyright 1999, Third Edition, pp. 122-124.

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-3612531