US 12,248,476 B2
System and method for dynamic database split generation in a massively parallel or distributed database environment
Ashok Shivarudraiah, San Mateo, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Dec. 29, 2023, as Appl. No. 18/400,568.
Application 18/400,568 is a continuation of application No. 16/502,727, filed on Jul. 3, 2019, granted, now 11,899,666.
Application 16/502,727 is a continuation of application No. 14/864,765, filed on Sep. 24, 2015, granted, now 10,394,818, issued on Aug. 27, 2019.
Claims priority of provisional application 62/056,400, filed on Sep. 26, 2014.
Prior Publication US 2024/0134861 A1, Apr. 25, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/24 (2019.01); G06F 16/2455 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/24554 (2019.01) [G06F 16/278 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for database split generation in a database access environment including a plurality of databases and a data warehouse layer executing on one or more microprocessors, the method comprising:
receiving by a database table accessor executing on the one or more microprocessors, from a client application, a query for data in a table of the data warehouse layer;
obtaining a metadata representative of the table containing the data;
determining a splits generator based at least partly on the obtained metadata;
generating, by the splits generator, a plurality of query splits, wherein each of the plurality of query splits is executable by a corresponding associated mapper of a plurality of associated mappers against the table; and
generating a response to the query based on received results of each of the plurality of query splits executed against the table.