Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-02-18
2001-04-17
Black, Thomas (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06219670
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates generally to graphical user interfaces, and in particular, to a method, apparatus, and article of manufacture for filtering a table list before opening with a graphical user interface.
2. Description of the Related Art
Graphical user interfaces (GUIs) have greatly enhanced the usability and productivity of computer software. In most GUIs, such as found in operating systems such as Microsoft Windows (3.x, 95, and NT), IBM OS/2, Apple Macintosh, and some versions of the UNIX operating system, data is supplied to a user through one or more windows or views.
In conventional systems, a GUI is displayed that enables a user to open a table of a database. Databases are computerized information storage and retrieval systems. A Relational Database Management System (RDBMS) is a database management system (DBMS) which uses relational techniques for storing and retrieving data. Relational databases are organized into tables which consist of rows and columns of data. The rows are formally called tuples. A database will typically have many tables and each table will typically have multiple tuples and multiple columns. The tables are typically stored on direct access storage devices (DASD) such as magnetic or optical disk drives for semi-permanent storage.
RDBMS software using a Structured Query Language (SQL) interface is well known in the art. The SQL interface has evolved into a standard language for RDBMS software and has been adopted as such by both the American National Standards Institute (ANSI) and the International Standards Organization (ISO). The SQL interface allows users to formulate relational operations on the tables either interactively, in batch files, or embedded in host languages, such as C and COBOL. SQL allows the user to manipulate the data.
In a conventional system, when a user wants to open a table in a database, a GUI that includes a window is displayed for the user. The window typically includes a File|Open menu and/or a Browse command. Upon selection of the File|Open menu, an Open Database window is displayed that includes the list of databases, a “Look in” dropdown list box for selecting a server to be searched, a “File name” edit box for selecting a database from which tables are to be retrieved, and a “Files of type” dropdown list box for specifying a file type (i.e., the file type could be “IBM DB2 (*)” or “all file types”). When the Open Database window appears, the user selects the “Files of type” dropdown list box to select a file type. For example, to select a DB2 table, the user selects an “IBM DB2 (*)” file type. At this point the IBM DB2 Open Database Connectivity (“ODBC”) login window appears and the user logs in.
Once logged in, the Open Database window reappears with the name of the connection (e.g., userid@DB2 ). The user selects the connection and is presented with a list of databases or schema from which to select. The user selects a database or schema and is presented with a list of tables. In a conventional system, displaying the tables for databases which contain a large number of tables takes a long time. Also, since the list is potentially very large, the user may have a difficult time finding the desired table.
In some current systems, a user can enter a database search that will limit the tables that are displayed. However, these systems will retrieve all tables, which is time consuming, and then search for the requested tables. Consequently, a significant need exists for a utility that allows a user to filter table lists more efficiently.
SUMMARY OF THE INVENTION
To address the requirements described above, the present invention discloses a method, apparatus, and article of manufacture for a filter table list utility. According to the present invention, 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.
REFERENCES:
patent: 4221003 (1980-09-01), Chang et al.
patent: 5418950 (1995-05-01), Li et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5584591 (1996-12-01), Mori et al.
patent: 5748954 (1998-05-01), Mauldin
patent: 5878408 (1999-03-01), Van Huben et al.
patent: 5893087 (1999-04-01), Wlaschlin et al.
patent: 5999940 (1999-12-01), Ranger
Mocek Darryl Jon
Tan Shih-Shan
Black Thomas
International Business Machines - Corporation
Jung David
Kudirka & Jobse LLP
LandOfFree
Method and apparatus for filtering a table list before... 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 filtering a table list before..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for filtering a table list before... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2549996