Method and apparatus for filtering a table list before opening with a graphical user interface

• US 6,219,670 B1
• Filed: 02/18/1998
• Issued: 04/17/2001
• Est. Priority Date: 02/18/1998
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Mocek, Darryl Jon, Tan, Shih-Shan
• Primary Examiner(s): Black, Thomas
• Assistant Examiner(s): JUNG, DAVID YIUK
• Application Number:
  US09/025,316
• Time in Patent Office: 1,154 Days
• Field of Search: 400/578, 400/615.2, 707/1-206, 707/500-530
• US Class Current: 707/754
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/918 Location
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method, apparatus, and article of manufacture for a filter table list utility. Information is displayed on a monitor attached to a computer. An open database window is displayed in which search criteria is entered for searching for tables. A search is performed for tables using the entered search criteria, prior to retrieving names of all of the tables to display on the monitor. When tables are found that meet the search criteria, a list of the found tables is generated for displaying on the monitor. The generated list is displayed on the monitor.

Claims

1. A method operable in a relational database management system which accesses a database to retrieve names of tables therein, visually displays the database table names in a dialog box and opens a database table based on a database table name entered into the dialog box, the method comprising:

(a) determining if the information entered into the dialog box includes user-defined search criteria in addition to the database table name;

(b) using a filter utility program located in the database management system to retrieve names of tables in the database that satisfy the search criteria when the information entered into the dialog box includes user-defined search criteria;

(c) using the database management system to retrieve names of all tables in the database when the information entered into the dialog box does not include user-defined search criteria; and

(d) displaying the retrieved database table names in the dialog box.

2. The method of claim 1 wherein step (a) further comprises the step of:

(a.1) determining if the search criteria contains a demarcation character preceding the database table name.

3. The method of claim 2 wherein the demarcation character comprises a backslash.

4. The method of claim 2 wherein the demarcation character comprises a dot.

5. A computer program product operable in a relational database management system which accesses a database to retrieve names of tables therein, visually displays the database table names in a dialog box and opens a database table based on a database table name entered into the dialog box, the computer program product comprising a computer usable medium having computer readable program code thereon, including:

(a) program code configured to determine if the information entered into the dialog box includes user-defined search criteria in addition to the database table name;

(b) filter utility program code that is loadable into the database management system and which is configured to retrieve names of tables in the database that satisfy the search criteria when the information entered into the dialog box includes user-defined search criteria;

(c) program code that is configured to use the database management system to retrieve names of all tables in the database when the information entered into the dialog box does not include user-defined search criteria; and

(d) program code that is configured to display the retrieved database table names in the dialog box.

6. The computer program product of claim 5 wherein the program code configured to determine if the information entered contains search criteria further comprises the program code configured to determine if the search criteria contains a demarcation character preceding the database table name.

7. The method of claim 6 wherein the demarcation character comprises a backslash.

8. The method of claim 6 wherein the demarcation character comprises a dot.

9. Apparatus operable in a computer system having a memory, a display and a relational database management system which accesses a database to retrieve names of tables therein, visually displays the database table names in a dialog box and opens a database table based on a database table name entered into the dialog box, the apparatus comprising:

(a) program logic configured to determine if the information entered into the dialog box includes user-defined search criteria in addition to the database table name;

(b) filter utility program logic located in the database management system configured to retrieve names of tables in the database that satisfy the search criteria when the information entered into the dialog box includes user-defined search criteria;

(c) program logic configured to use the database management system to retrieve names of all tables in the database when the information entered into the dialog box does not include user-defined search criteria; and

(d) program logic configured to display the retrieved database table names in the dialog box.

10. The apparatus of claim 9 wherein the program logic configured to determine if the information entered contains search criteria further comprises program logic configured to determine if the search criteria contains a demarcation character preceding the database table name.

11. The apparatus of claim 10 wherein the demarcation character comprises a backslash.

12. The apparatus of claim 10 wherein the demarcation character comprises a dot.