US 12,443,616 B2
Extensible attributes for data warehouses
Dylan Wan, Fremont, CA (US); Francoise J. Lawrence, Dublin, CA (US); Justin Hyde, Oakland, CA (US); Amit Goyal, East Palo Alto, CA (US); Saurabh Verma, Cupertino, CA (US); and John D. Poole, Stratford, CT (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Mar. 22, 2024, as Appl. No. 18/614,571.
Application 18/614,571 is a continuation of application No. 16/848,632, filed on Apr. 14, 2020, granted, now 11,966,409.
Application 16/848,632 is a continuation of application No. 15/299,273, filed on Oct. 20, 2016, granted, now 10,635,686, issued on Apr. 28, 2020.
Claims priority of provisional application 62/362,756, filed on Jul. 15, 2016.
Claims priority of provisional application 62/244,461, filed on Oct. 21, 2015.
Prior Publication US 2024/0232216 A1, Jul. 11, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) 14 Claims
OG exemplary drawing
 
1. A method, comprising:
reserving, by a computing system, a first set of extension columns in a data warehouse table, the data warehouse table comprising a plurality of initial columns;
identifying, by the computing system, an attribute from a customer source to be mapped to the data warehouse table;
determining, by the computing system, whether the attribute corresponds to an initial column from the plurality of initial columns;
responsive to determining that the attribute does not correspond to the initial column of the plurality of initial columns, selecting, by the computing system, an unallocated column from the first set of extension columns in the data warehouse table, the selecting performed based at least in part on the unallocated column comprising:
a match between a target property corresponding to the unallocated column and a source property corresponding to the attribute; and
a match between a data type of the unallocated column and a data type of the attribute;
mapping, by the computing system, the attribute to a target column of the data warehouse table, the target column corresponding to the unallocated column in the first set of extension columns;
executing, by the computing system, instructions to move metadata associated with the attribute into the unallocated column of the data warehouse table, wherein the metadata associated with the attribute comprises a list of finite values and a language supported by the attribute and wherein the instructions to move the metadata comprise translating the list of finite values supported by the attribute to a list of finite values supported by the unallocated column based on the language supported by the attribute.