Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1997-10-14
2001-06-05
Choules, Jack (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C709S217000, C345S215000
Reexamination Certificate
active
06243703
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
This invention relates in general to a computer-implemented database system, and more particularly, to explaining data using a graphical user interface.
2. Description of Related Art
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 random access storage devices (RASD) 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.
The definitions for SQL provide that a RDBMS should respond to a particular query with a particular set of data given a specified database content, but the method that the RDBMS uses to actually find the required information in the tables on the disk drives is left up to the RDBMS. Typically, there will be more than one method that can be used by the RDBMS to access the required data. The RDBMS will optimize the method used to find the data requested in a query in order to minimize the computer time used and, therefore, the cost of doing the query.
The RDBMS software uses various data, including statistics in a RDBMS catalog, during bind time to determine the access paths of SQL statements. A utility, called RUNSTATS, updates the RDBMS catalog with statistics on table spaces, indexes, tables, and columns. Additionally, when an SQL statement is processed during a bind phase, an access path is determined for the statement. The access path is a compiled run-time structure used for executing the SQL statement. The access path is the path the RDBMS uses to get to the data that SQL statements request. For example, an SQL statement might search an entire table space, or it might use an index. The access path is the key to determining how well an SQL statement performs. The data associated with the access path is stored in the DB
2
directory, or optionally in a plan table. The plan table holds information about a plan, which is a set of one or more programs or is a portion of a program.
Analyzing and improving performance of SQL statements is currently too time-consuming and complex for the average user. In a conventional system, a user typically improves performance of SQL statements by determining the access path for a SQL statement by manually interpreting data in the plan table that holds data associated with the access path. Moreover, in conventional systems, although data in a plan table is available on a mainframe, it is in a format that is difficult to understand and must be interpreted by the user. Therefore, conventional systems do not offer users at workstations access to databases on a mainframe for obtaining data in the plan table that is easy to understand. There is a need in the art for providing users at workstations access to this information from the mainframe and providing an improved technique for users to optimize access paths.
Additionally, the RDBMS has subsystem parameters that describe the values of user set options, such as the number of current users and number of open datasets allowed at one time. Conventional systems do not provide an easy way to display and find the values, install field names, and descriptions of the subsystem parameters. There is a need in the art for an improved technique that allows a user to view subsystem parameters.
SUMMARY OF THE INVENTION
To overcome the limitations in the prior art described above, and to overcome other limitations that will become apparent upon reading and understanding the present specification, the present invention discloses a method, apparatus, and article of manufacture for a computer implemented database interpreter.
In accordance with the present invention, a query is executed in a computer, the query being performed by the computer to retrieve data from a database stored on a data storage device connected to the computer. A main window is displayed that provides selection of subsystem parameter browsing. When subsystem parameter browsing is selected, subsystem parameters are extracted from the database. Next, access to the extracted subsystem parameters is provided within a subsystem parameters window.
In accordance with another aspect of the present invention, the computer is a workstation that is connected to a mainframe storing the database. The main window is displayed providing selection of graphical plan representation at the workstation. When graphical plan representation is selected, at the workstation, plan table data is extracted from the database at the mainframe. Next, a graphical representation of the plan table data is displayed at the workstation.
An object of the invention is to provide an improved method of extracting plan table data from a database. Another object of the invention is to provide easy access to subsystem parameters. Yet another object of the invention is to provide a graphical representation of plan table data on a workstation connected to a mainframe having a database that stores the plan table data.
REFERENCES:
patent: 5265246 (1993-11-01), Li et al.
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5428776 (1995-06-01), Rothfield
patent: 5432932 (1995-07-01), Chen et al.
patent: 5471575 (1995-11-01), Giansante
patent: 5471613 (1995-11-01), Banning et al.
patent: 5546570 (1996-08-01), McPherson, Jr. et al.
patent: 5548758 (1996-08-01), Pirahesh et al.
patent: 5555403 (1996-09-01), Cambot et al.
patent: 5574918 (1996-11-01), Hurley et al.
patent: 5584024 (1996-12-01), Shwartz
patent: 5586311 (1996-12-01), Davies et al.
patent: 5596745 (1997-01-01), Lai et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5630125 (1997-05-01), Zellweger
patent: 5659728 (1997-08-01), Bhargava et al.
patent: 5689668 (1997-11-01), Beaudet et al.
patent: 5768578 (1998-06-01), Kirk et al.
patent: 5778354 (1998-07-01), Leslie et al.
patent: 5806059 (1998-09-01), Tsuchida et al.
patent: 5822750 (1998-10-01), Jou et al.
patent: 5832477 (1998-11-01), Bhargava et al.
patent: 5877757 (1999-03-01), Baldwin et al.
patent: 5995921 (1999-11-01), Richards et al.
patent: 6064821 (2000-05-01), Shough et al.
patent: 7-182358 (1995-07-01), None
IBM, Internet article, HTTP://WWW.SPI.ORG/cgi-bin
ewqry?ISA=Hit . . . 1997&rec=15&submit=seeit&csum=18342319056, “File System which Integrates and Collates Text and Tablet Entered Script and Graphics for Text Creation and Commentary”, Software Patent Institute Database of Software Technologies, Record Display, Record 15, Jul. 1973 (entire document).
IBM Technical Disclosure Bulletin, “Access Path Selection in a Relational Database Management System”, vol. 22, No. 4, Sep. 1979, pp. 1657-1660.
IBM, Internet article, HTTP://WWW.SPI.ORG/cgi-bin
ewqry?ISA=Hit . . . 1997&rec=14&submit=seeit&csum=19827063693, “Schema and subschema and Languages Date manipulation languages (DML) and Query languages and Decompiling Codasyl DML into relational queries. [From Nonbook Literature; G. Mathematics of Computing; H.2 Database Management; H.2.1 Logical Design]”, Software Patent Institute Database of Software Technologies, Record Display, Record 14, Feb. 1, 1982 (entire documen
Couch Tanya
Drummond Catherine E.
Choules Jack
Foerster Ingrid M.
International Business Machines - Corporation
Robinson Greta L.
LandOfFree
Method of accessing and displaying subsystem parameters... 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 of accessing and displaying subsystem parameters..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of accessing and displaying subsystem parameters... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2442474