Browse Prior Art Database

Visual Model for Database Set Operations

IP.com Disclosure Number: IPCOM000102259D
Original Publication Date: 1990-Nov-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 2 page(s) / 58K

Publishing Venue

IBM

Related People

Banning, KR: AUTHOR [+3]

Abstract

Disclosed is a user interface model to perform relational database set operations. Set operations are used to take results from two queries and combine them in a specified manner to produce a subset of the total from both queries. The difference from queries in general is the linear nature and the use of results to select subsets. The model is based on the use of queries as objects that can be used in the visual interface to join the objects into the desired subset. The model only requires that the results be available as objects. The objects are then joined visual with one of the set operators (union, intersection, or difference).

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

Visual Model for Database Set Operations

       Disclosed is a user interface model to perform relational
database set operations.  Set operations are used to take results
from two queries and combine them in a specified manner to produce a
subset of the total from both queries. The difference from queries in
general is the linear nature and the use of results to select
subsets.  The model is based on the use of queries as objects that
can be used in the visual interface to join the objects into the
desired subset.  The model only requires that the results be
available as objects.  The objects are then joined visual with one of
the set operators (union, intersection, or difference).

      There are three identified methods to depict the results,
objects and set operations.  These are:
      LINEAR    The objects are presented in sequence with
connections indicating the direction of operation and the type of
operator.  This visualization is simple and can be read quickly.
This depiction does not emphasize the nature of the combination or
suggest anything about the results.
      TREE      The objects are presented in a tree structure to
represent the operations, with the operators being the connecting
nodes.  The visualization is simple but more difficult to read than
the linear method.  This method does convey some sense of the
combination but does not suggest anything about the nature of the
results.
      VENN      If three or...