International Business Machines Corporation

Jean C Ho

Gerald Johann Wilmot

Jing-Song Jang

Dragutin Petkovic

Mimi Phuong-Thao Vo

Peter C Yanker

Nelson Mendonca Mattos

Douglas Michael Hembry

David Couttie Fallside

Carlton Wayne Niblack

Siyi Terry Donn

Frank C Tung

Tri Quac Ha

Matthew Paul Anderson

Peter Paval Uhrowczik

Josephine Min-Kung Cheng

James Louis Keesey

Howard Justin Glaser

Constance Jane Nelin

Thomas E Conrad

Erik Allan Kane

Roger Georges Bitar

Angela Go Reyda

Gerold Johann Wilmot

In a database processing system with a partitioned database that provides relational extenders to support storage of and access to complex data types, metadata table rows are collocated with corresponding relational table partitions. Image indexes are generated and stored at system nodes with their corresponding relational table partitions. Image query processing is conditioned to account for the partitioned structure of the database.

Complex data query support in a partitioned database system

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

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of Internet and Intranet applications. In particular, an extender user interface for creating a relational database extender is provided. A window is displayed on the monitor. The window illustrates a relational database extender, which comprises multiple objects.

Extender user interface

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.

Growing community of inventors

Saratoga, CA, United States of America

Jean C Ho