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:
Jun. 03, 2025
Filed:
Jan. 19, 2023
Oracle International Corporation, Redwood Shores, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Juan R. Loaiza, Woodside, CA (US);
Beda Christoph Hammerschmidt, Palo Alto, CA (US);
Andrew Witkowski, Foster City, CA (US);
Sankar Subramanian, Cupertino, CA (US);
Sabina Petride, Tracy, CA (US);
Ajit Mylavarapu, Mountain View, CA (US);
Gerald Venzl, Redwood City, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Disclosed herein are techniques for storing, within a database system, metadata that indicates an intended usage (IU). Once created, an IU may be assigned to a column to (a) indicate how the column is intended to be used, and (b) affect how the database server behaves when database operations involve values from the column. The IU assigned to a column supplements, but does not replace, the datatype definition for the column. Each IU may have an IU-bundle. The IU-bundle of an IU indicates how the database server behaves with respect to any column that is assigned the IU. For example, the IU-bundle may indicate constraints that the database server must validate during operations on values from columns assigned to the IU. Techniques are also described for implementing multi-column IUs and flexible IUs.