Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Improved Query Understanding Through the Use of a Having Window

IP.com Disclosure Number: IPCOM000101750D
Original Publication Date: 1990-Aug-01
Included in the Prior Art Database: 2005-Mar-16
Document File: 2 page(s) / 68K

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+2]

Abstract

Disclosed is the method to directly specify the SQL Having clause by selecting a column in a SQL Group By statement with direct manipulation techniques identical to those used to specify the SQL Where clause. The user interface design itself will enforce the restrictions as to what column may or may not be included. In addition, any changes to the validity of the Having clause are automatically corrected by the system.

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

Improved Query Understanding Through the Use of a Having Window

       Disclosed is the method to directly specify the SQL
Having clause by selecting a column in a SQL Group By statement with
direct manipulation techniques identical to those used to specify the
SQL Where clause.  The user interface design itself will enforce the
restrictions as to what column may or may not be included.  In
addition, any changes to the validity of the Having clause are
automatically corrected by the system.

      A user involved in defining a database query may be required to
use a Having clause.  This allows the output collected into groups by
the Group By clause to be filtered as a group.  Existing user
interfaces treat the Having clause as a special function that is
directly entered by text or in a special dialog.  This reduces the
useability of the product by requiring that the user conceptualize
the clause as somehow not part of the main query.  In fact, the Group
By clause directly determines what can be included in the Having
clause and what it means.  This results in unique dialogs when using
Having at a cost to the developer and user.

      A Having clause specifies that only the results table rows that
meet the Having clause restrictions be included. The Having clause
only applies to the Group By clause.  The proposal is to present a
Having clause option in the Group By object.  The user signifies the
need for a Having clause by operating on the Group By column.  This
initiates a dialog to specify the Having clause for that column.
Following the completion of the definition dialog, the Having clause
is displayed as connected to the Group By column in a visual obje...