US 11,966,409 B2
Extensible attributes for data warehouses
Dylan Wan, Fremont, CA (US); Francoise J. Lawrence, Dublin, CA (US); Justin Hyde, Oakland, CA (US); Amit Goyal, E. 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 Apr. 14, 2020, as Appl. No. 16/848,632.
Application 16/848,632 is a continuation of application No. 15/299,273, filed on Oct. 20, 2016, granted, now 10,635,686.
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 2020/0272635 A1, Aug. 27, 2020
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/25 (2019.01)
CPC G06F 16/254 (2019.01) 21 Claims
OG exemplary drawing
 
1. A method, comprising:
reserving, in a data warehouse table, a first set of extension columns, the data warehouse table containing a plurality of initial columns;
receiving metadata from a customer source, the metadata identifying an attribute for the data warehouse table;
extracting the attribute from the metadata;
determining that the attribute from the metadata does not correspond to a column of the plurality of initial columns in the data warehouse table;
responsive to determining that the attribute does not correspond to a column of the plurality of initial columns, comparing a data type corresponding to the attribute from the metadata of the customer source to a data type of a next unallocated column in the first set of extension columns from the data warehouse table;
based at least in part on the comparing, selecting the first set of extension columns in the data warehouse table for mapping based at least in part on the next unallocated column having:
(a) matching metadata code indicating matching column properties between a source property corresponding to the attribute and a target property corresponding to the next unallocated column; and
(b) a match between the data type of the next unallocated column in the first set of extension columns and the data type corresponding to the attribute;
generating code to map the attribute to the next unallocated column based at least in part on the metadata from the customer source;
mapping the attribute to the next unallocated column based at least in part on the generated code; and
executing instructions to move data associated with the attribute into the next unallocated column of the data warehouse table.