International Business Machines Corporation

Peter C Yanker

Dragutin Petkovic

Carlton Wayne Niblack

Bradley J Beitel

Gerald Johann Wilmot

Mimi Phuong-Thao Vo

Nelson Mendonca Mattos

Douglas Michael Hembry

David Couttie Fallside

Siyi Terry Donn

Frank C Tung

Jing-Song Jang

Jean C Ho

Tri Quac Ha

Matthew Paul Anderson

Peter Paval Uhrowczik

Josephine Min-Kung Cheng

Ronald Jason Barber

Michael David Wilkes

John J Deacon

Robert D Gordon

Nancy A Burns

Lonnie S Walling

Arthur M Sherman

Charles L Haug

Mark S Bishop

Kenneth B Smith

William Robinson Equitz

Myron Dale Flickner

Michael W Bayley

Thomas R Work

Thomas Randolph Work

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, a fifth table containing the names of the second and third tables for each object defined in the first table, a sixth table containing a reference to each object handle removed from the first table and including one column dedicated to containing a reference to the location of the object data associated with the removed object handle, and a seventh table having at least one column which describes a property of the data type of each object defined in the first table. The relational extender further includes an eighth table as a temporary holding table for the second table, and a ninth table as a temporary holding table for the third table. Both the eighth and ninth tables are used in conjunction with the extender triggers to ensure data integrity.

Computer program product for database relational extenders

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handles and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Relational database extenders for handling complex data types

This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Images in an image database are searched in response to queries which include the visual characteristics of the images such as colors, textures, shapes, and sizes, as well as by textual tags appended to the images. Queries are constructed in an image query construction area in response to values of representations of the visual characteristics and to locations of the representations in the image query construction area.

Image query system and method

An apparatus is described which includes memory areas for storing an image and trigger fields for the image, and a display which indicates a cursor in one of two configurations. Circuitry is provided for moving the cursor and enabling it to implement a select operation for a particular subroutine. The apparatus employs a method which enables the trigger fields to be invisible, which method comprises: displaying the image without trigger fields; and altering the cursor on the display from one configuration to another upon the cursor being moved into an invisible trigger field to thereby indicate to the user the presence of the trigger field.

Trigger field display selection

A data processing system includes, among others, three memory areas: a source memory which is addressed in planar, data unit increments and stores display data units on a bit per plane basis; a target memory for storing display data units in a manner suitable for operation of a display unit; and a window buffer for transferring display data units from the source memory to the target memory. The system includes apparatus for inhibiting certain data units from the source memory from overwriting data units already in the target memory. The method comprises first accessing a plurality of data units from the source memory and then logically determining if all bits of each accessed data unit meet a predetermined criteria. Each data unit found to meet the predetermined criteria is inhibited from altering any data unit already in the target memory.

Digital image overlay system and method

A user/PC interface system is described which enables the creation and performance of a synchronized audio/visual story on the PC. The interface enables the initial storage of a plurality of visual images. Then, it enables the creation of an audio presentation which includes labels and time indications, certain of which are employed for synchronization purposes. The system is responsive to a label to execute a predetermined command upon the appearance of the label in the audio presentation. The PC is then operated to perform the audio presentation, that performance automatically causing the display of visual images upon the occurrence of labels and time indications. An improved, table-based authoring system is also described for preparation of both the above noted audio and visual presentations. The system relies upon columnar presentations of a tabular form, each column indicating a separate control function (or comment) relating to the audio/visual presentation.

Computer-based, audio/visual creation and presentation system and method

A display system is described for producing and showing color images which includes a screen for displaying an interactive user interface. The display interface includes image color choice areas, anti-alias color choice areas, a current color area, an echo icon area and user-movable cursor indications. The invention enables the display system user to choose among a plurality of displayed colors and to visually determine the effect of the choice. The method includes moving a cursor indication to a color choice area, displaying the color choice in the current color selection area; and displaying in the echo icon area an echo icon drawn using the color choice. This enables the display system user to see an enlarged view of the color choice and an icon drawn with the color and enables the user to assess the effect of the color choice, both from the standpoint of the enlarged view and from the standpoint of exhibiting an expanded anti-aliased figure. In addition, the color alteration also causes the image to be modified to reflect the color change, thus enabling the user to obtain a complete assessment of the results of the color selection.

Color palette display interface for a computer-based image editor

An Image Editor includes a ZOOM function wherein other Image Editor actions are invokable and operable in whatever zoom level is currently in effect. The zoom mode is a state of the Image Editor in that invoked actions are performed in a normal 1X pel size image but are displayed to an operator in an enlarged, flat pel, zoom equivalent. Whe the ZOOM function is invoked a displayed zoom window is automatically centered upon a present position of a cursor as is also a selectively displayable viewport, the viewport showing the relative position of the cursor within the 1X image.

Image editor zoom function

A user/PC interface system is described which enables the creation and performance of a synchronized audio/visual story on the PC. The interface enables the initial storage of a plurality of visual images. Then, it enables the creation of an audio presentation which includes labels and time indications, certain of which are employed for synchronization purposes. The system is responsive to a label to execute a predetermined command upon the appearance of the label in the audio presentation. The PC is then operated to perform the audio presentation, that performance automatically causing the display of visual images upon the occurrence of labels and time indications. A table-based authoring system is also described for preparation of both the above noted audio and visual presentations. The system relies upon columnar presentations of a tabular form, each column indicating a separate control function (or comment) relating to the audio/visual presentation.

A display apparatus is described having the capability to pan a viewport image across a world-plane image. The viewport image has defined boundaries and exhibits a cursor whose position is movable by a user operated mouse or keyboard controls. The invention comprises a method for providing a variable-rate pan action of the viewport image which includes panning the viewport image at a preset rate in the direction of a first viewport boundary, if the cursor has been moved to the first boundary. The viewport image is panned at a proportionally faster rate in the direction of the first viewport boundary, as the cursor is moved further beyond the first viewport boundary thus enabling a variable speed pan under user control.

Variable speed, image pan method and apparatus

A method is described for transferring data units from a serially organized memory to a bit planar organized memory. The method first selects a plurality of data units from the serially organized memory. A bit pattern from the selected data units is then captured, which bit pattern includes only bits to be stored in a subset of the storage planes of the bit planar organized memory. The bit pattern is processed to isolate from it, subsidiary bit patterns, one bit pattern for each storage plane in the bit planar memory. Each subsidiary bit pattern is then translated so that its bit sequence is properly oriented and is then stored in a plane of the bit planar organized memory. In a preferred embodiment of the invention, the translations take place as the result of a table look-up step.

High speed method for data transfer

A graphic display PC/interface system is described which includes three memory units: a source memory which is addressed in planar byte increments and stores display data units on a bit per plane basis; a target memory for storing display data units in a manner suitable for operation of a display unit; and a window buffer for transferring display data unit from the source memory to the target memory. The system transfers a quantity of display data unit bytes from the source memory to the target memory by accessing pairs of planar bytes, which pair of planar bytes may have a display data unit byte bridging therebetween. The method comprises selecting a first pair of planar bytes from the source memory; aligning the display data unit byte which lies totally within the selected first pair of planar bytes; selecting a second pair of planar bytes from the source memory; aligning a display data unit byte which lies totally within the second selected pair of planar bytes; consolidating the display data unit byte which bridges between the first and second pairs of selected planar bytes; aligning the consolidated display data unit byte; and transferring aligned display data unit bytes to the window buffer.

Growing community of inventors

Portola Valley, CA, United States of America

Peter C Yanker