Browse Prior Art Database

Intuitive Screen Layout for Defining User Defined Columns

IP.com Disclosure Number: IPCOM000103574D
Original Publication Date: 1993-Jan-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 2 page(s) / 75K

Publishing Venue

IBM

Related People

Li, SG: AUTHOR [+2]

Abstract

Disclosed is a screen layout that provides a convenient way to allow the user to create user-defined columns and save them for future use. Multiple areas are arranged on the screen to intuitively guide the users, experienced or inexperienced, in defining user-defined columns.

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

Intuitive Screen Layout for Defining User Defined Columns

       Disclosed is a screen layout that provides a convenient
way to allow the user to create user-defined columns and save them
for future use.  Multiple areas are arranged on the screen to
intuitively guide the users, experienced or inexperienced, in
defining user-defined columns.

      Usually, columns are involved in the expressions and functions
that will be included in the select clause of a SQL SELECT statement.
These expressions and functions are user-defined columns that are
treated as logical columns.  For each SQL implementation, only a
certain set of mathematical operations and functions are supported.
It is a burden for users to memorize them.  Thus, in defining
user-defined columns, a user interface is needed that will allow the
user to view columns of a selected table or view, choose the needed
columns, and press the buttons of delimiters, algebraic operators,
and functions.

      This article documents a screen layout that can intuitively
guide the user in defining user-defined columns.  From top to bottom,
the screen is divided into three areas (panes):
(1) The Table-Column Paired Lists allow the user to select a table or
view and see its columns in an adjacent list.  This list includes
column names, types and their lengths.  This information can help the
user to determine the proper mathematical operations and functions to
be applied on the selected columns.
(2) The Function and Symbol Buttons provide the symbols and functions
for defining user-defined columns.
(3) The Defined Columns Defi...