Method and apparatus for database filter generation by display s

Details Method and apparatus for database filter generation by display s Method and apparatus for database filter generation by display s

Filed on

1996-03-20

Date issued

1998-07-28

Examiner

Amsbury, Wayne

Patent Class

Data processing: database and file management or data structures

SubClass

Database design

SubSubClass

Data structure types

Other Related Categories

707 4, G06F 1130

Type

Patent

Status

active

Patent number

057874115

Description

ABSTRACT:
A method for selecting records from a displayed database table by generating an SQL SELECT command for filtering the displayed records in accordance with cell values highlighted by user input. A presently selected set of records from a desired table (generally referred to as a record set or record source) are displayed on the user's display screen. The user selects particular values in cells (an intersection of a row and a column of the displayed table) by highlighting the values using the pointer device or keyboard of the computer system. Methods of the present invention then generate an SQL select (filter) command to selectively retrieve those records from the displayed records which match the user's highlighted values. A fully highlighted cell indicates exact equality is desired by the user, a beginning portion highlighted indicates that the user wishes to match records whose corresponding column starts with the highlighted value, and ending portion selection matches the ending portion of qualified records, and a middle portion highlighted matches any record containing the highlighted value. Values highlighted in the same row generate logically AND'd clauses in the SELECT command while the comparison generated for a row are logically OR'd with the comparisons generated for other rows. The user may indicate that the highlighted values are for selection (inclusion of qualified records) or for exclusion selection (exclusion of qualified records). A new select (filter) command may be logically AND'd with the prior filter to permit complex selection criteria to be defined by simple graphical user inputs.

REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 5265246 (1993-11-01), Li et al.
patent: 5301313 (1994-04-01), Terada et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5426781 (1995-06-01), Kaplan et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5455945 (1995-10-01), VanderDrift
patent: 5499368 (1996-03-01), Tate et al.
patent: 5519859 (1996-05-01), Grace
patent: 5544355 (1996-08-01), Chaudhuri et al.
patent: 5566330 (1996-10-01), Sheffield
patent: 5584024 (1996-12-01), Schwartz
patent: 5608899 (1997-03-01), Li et al.
patent: 5630120 (1997-05-01), Vachey

Affiliated with

Also associated with

Rating

Method and apparatus for database filter generation by display s does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for database filter generation by display s, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for database filter generation by display s will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-34576