US 12,321,353 B2
Extending database data with intended usage information
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); and Gerald Venzl, Redwood City, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jan. 19, 2023, as Appl. No. 18/099,034.
Claims priority of provisional application 63/416,052, filed on Oct. 14, 2022.
Prior Publication US 2024/0126763 A1, Apr. 18, 2024
Int. Cl. G06F 16/28 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24565 (2019.01) [G06F 16/221 (2019.01); G06F 16/24554 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A method comprising:
in response to input received by a database server, the database server storing, in a database that is managed by the database server:
metadata that:
defines a flexible Intended-Usage (IU) comprising a plurality of candidate IU-bundles, and
specifies assignment, of a candidate IU-bundle of said plurality of candidate IU-bundles to a column of a table for a particular row of said table, based on one or more other columns of said table;
responsive to determining that a first candidate IU-bundle of said plurality of candidate IU-bundles is assigned to a first row of said table, the database server:
providing to database applications information specified in the first candidate IU-bundle regarding intended usage of the column, and
enforcing a constraint specified in the first candidate IU-bundle relative to values inserted into said first row; and
responsive to determining that a second candidate IU-bundle of said plurality of candidate IU-bundles is assigned to a second row of said table, the database server:
providing to the database applications information specified in the second candidate IU-bundle regarding intended usage of the column, and
enforcing a constraint specified in the second candidate IU-bundle relative to values inserted into the second row;
wherein the method is performed by one or more computing devices.