Browse Prior Art Database

List Support for LAN NetView Fix Browser in Dynamic DB Environment

IP.com Disclosure Number: IPCOM000112201D
Original Publication Date: 1994-Apr-01
Included in the Prior Art Database: 2005-Mar-26
Document File: 2 page(s) / 76K

Publishing Venue

IBM

Related People

Arkeketa, WW: AUTHOR [+2]

Abstract

Disclosed is a method for a user to pick values for filters that are applied to the LAN NetView Fix* Event Log table, so that the user can view only the event data that is of interest.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

List Support for LAN NetView Fix Browser in Dynamic DB Environment

      Disclosed is a method for a user to pick values for filters
that are applied to the LAN NetView Fix* Event Log table, so that the
user can view only the event data that is of interest.

      In the LAN NetView Fix product, there is a component called the
Event Log Browser which displays event data from the LAN NetView Fix
Event Log (Database Manager) table.  The data in this table is always
changing; with new event data being logged and older event data being
archived or deleted from the table.

      The Browser displays filter panels that allow the user to
specify filter criteria that is applied to the Event Log table, so
that only the event data that meets all criteria is displayed in the
Browser's main display panel.

      For a particular filter, the user may wish to see a list of all
distinct values that exist in the table, so that he/she may pick the
ones they want.  Since the data in the Event Log table is dynamic,
the set of values for a filter changes over time.  The set changes in
size also.  The user is interested in the current filter values at
the time they request the list, so the list must be generated for
each request in order to be accurate.  After selections from the list
have been made, the list can be discarded.

      This disclosure addresses a method for providing a current list
of distinct values for the requested filter that the user can select
from.

      The Event Log table consists of several columns some of which
correspond to filters from the Browser Filter panels.  Each filter is
for a single column in the table.  Each column that has a filter
associated with it also has an index defined on it.

      When a list is requested, a Database Manager SELECT statement
is executed to retrieve a count of distinct values for the
corresponding column.  The SELECT statement may look like the
following:

           SELECT COUNT(DISTINCT COL_1) FROM EVENT_TABLE

The processing of this statement is very efficient since...