Browse Prior Art Database

Informative Column List for Naming Columns in a View Definition

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

Publishing Venue

IBM

Related People

Li, SG: AUTHOR [+2]

Abstract

Disclosed is a user interface design that provides a more informative list of base columns for defining a database View.

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

Informative Column List for Naming Columns in a View Definition

       Disclosed is a user interface design that provides a more
informative list of base columns for defining a database View.

      Naming columns for a View definition becomes complicated when
the foundation is a Fullselect statement with SET operations on
multiple SELECT statements.  In this case, a column in the View may
be based on a combination of columns belonging to different tables
with SET operations involved.  For example, an underneath base column
combination may be (Table1.Dept UNION Table2.Group) INTERSECT
(Table3.Product UNION Table4.Area).  However, the process to derive
such expressions based on a Fullselect definition is not trivial.
This article describes a user interface that generates such full
representative column expressions from the relationships among the
SELECT statements specified in a Fullselect.  Fullselects are the
foundation of a database View definition.

      This article documents a user interface that provides a list of
base columns for defining the columns of a database View.  In the
list, each entry is generated by identifying the corresponding column
from each SELECT statement of the Fullselect statement and expressed
with the relationships among these SELECT statements.  The simplest
case is when there is only a single SELECT statement in the
Fullselect.  The full expressions of base columns provide more
information to help the user in naming the Vi...