The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Apr. 04, 2000
Filed:
Jul. 13, 1998
Matthew Paul Anderson, Morgan Hill, CA (US);
Siyi Terry Donn, Saratoga, CA (US);
David Couttie Fallside, San Jose, CA (US);
Tri Quac Ha, San Jose, CA (US);
Douglas Michael Hembry, Los Gatos, CA (US);
Jean C Ho, Saratoga, CA (US);
Jing-Song Jang, Cupertino, CA (US);
Nelson Mattos, San Jose, CA (US);
Carlton Wayne Niblack, San Jose, CA (US);
Dragutin Petkovic, Saratoga, CA (US);
Frank Chin Tung, Saratoga, CA (US);
Peter Paval Uhrowczik, Los Gatos, CA (US);
Mimi Phuong-Thao Vo, San Jose, CA (US);
Gerald Johann Wilmot, Marina, CA (US);
Peter C Yanker, Mountain View, CA (US);
Josephine Min-Kung Cheng, San Jose, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
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.