US 12,248,490 B2
System and method for ranking of database tables for use with extract, transform, load processes
Krishnan Ramanathan, Bengaluru (IN); Aman Madaan, Pittsburgh, PA (US); and Somashekhar Pammar, San Jose, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Oct. 21, 2020, as Appl. No. 17/076,164.
Application 17/076,164 is a continuation in part of application No. 16/851,869, filed on Apr. 17, 2020, granted, now 11,803,798.
Claims priority of application No. 201941015571 (IN), filed on Apr. 18, 2019; application No. 201941015572 (IN), filed on Apr. 18, 2019; application No. 201941015582 (IN), filed on Apr. 18, 2019; and application No. 201941015583 (IN), filed on Apr. 18, 2019.
Prior Publication US 2021/0049183 A1, Feb. 18, 2021
Int. Cl. G06F 16/25 (2019.01); G06F 16/22 (2019.01); G06F 16/2457 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/254 (2019.01) [G06F 16/2282 (2019.01); G06F 16/24578 (2019.01); G06F 16/283 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system for use with an analytic applications environment, for ranking of database tables for use in controlling extract, transform, load (ETL) processes, comprising:
a computer including one or more processors, that includes an analytic applications environment operating theron that provides access to a data warehouse for storage of data by a plurality of tenants, wherein the analytic applications environment includes:
a first warehouse customer tenancy for a first tenant, that comprises a first database instance, a first staging area, and a first data warehouse instance of a plurality of data warehouses or data warehouse instances; and
a second customer tenancy for a second tenant, that comprises a second database instance, a second staging area, and a second data warehouse instance of the plurality of data warehouses or data warehouse instances;
wherein the analytic applications environment includes a data pipeline or other processing component that performs an extract, transform, load (ETL) process to extract data from an enterprise application or database environment, to be loaded into the data warehouse;
wherein the data stored within the data warehouse comprises customer data associated with the plurality of tenants, the customer data including a plurality of database tables and/or table columns, across different tenants of the plurality of tenants, associated with a set of data; and
wherein in association with the ETL process to extract the data from the enterprise application or database environment, to be loaded into the data warehouse, the computer operates as a table ranker that performs a ranking process to rank the database tables and/or table columns associated with the set of data across the plurality of tenants, including:
determining within each tenant's customer data one or more database tables and/or table columns indicative of importance to the tenant, including:
determining, for the first tenant, a first table and/or column ranking associated with a first customer data, for use by the ETL process in loading the first customer data in the first data warehouse instance; and
determining, for the second tenant, a second table and/or column ranking associated with a second customer data, for use by the ETL process in loading the second customer data in the second data warehouse instance;
which first and second table and/or column rankings are used by the analytic applications environment to prioritize processing by the ETL process to extract the tenant's first and second customer data to be loaded into the data warehouse.