US 12,235,876 B2
System and method for improved performance in a multidimensional database environment
Cloud Walker, Hayward, CA (US); Vinod Padinjat Menon, San Jose, CA (US); and Kumar Ramaiyer, Cupertino, CA (US)
Assigned to ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed by ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US)
Filed on Jul. 6, 2022, as Appl. No. 17/858,794.
Application 17/858,794 is a continuation of application No. 16/434,925, filed on Jun. 7, 2019, granted, now 11,403,321.
Application 16/434,925 is a continuation of application No. 15/332,945, filed on Oct. 24, 2016, granted, now 10,346,435, issued on Jul. 9, 2019.
Claims priority of provisional application 62/411,473, filed on Oct. 21, 2016.
Claims priority of provisional application 62/245,883, filed on Oct. 23, 2015.
Prior Publication US 2022/0350819 A1, Nov. 3, 2022
Int. Cl. G06F 16/28 (2019.01); G06F 12/0868 (2016.01); G06F 12/0873 (2016.01); G06F 12/121 (2016.01)
CPC G06F 16/283 (2019.01) [G06F 12/0868 (2013.01); G06F 12/0873 (2013.01); G06F 12/121 (2013.01); G06F 2212/1016 (2013.01); G06F 2212/163 (2013.01); G06F 2212/206 (2013.01); G06F 2212/263 (2013.01); G06F 2212/313 (2013.01); G06F 2212/401 (2013.01); G06F 2212/452 (2013.01); G06F 2212/465 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system for performing input/output operations on data blocks with a multidimensional database, comprising:
a multidimensional database for storage of data; and
a computing device having a processor that executes instructions to:
create a background thread pool for the multidimensional database, the background thread pool being associated with a background queue that indicates data blocks in a data cache stored in memory; and
write data blocks indicated by the background queue to one or more memory-mapped page files mapped to respective regions of a data storage via writer threads in the background thread pool,
wherein writing of the data blocks by the writer threads is performed in parallel with other operations performed on data blocks in the data cache.