Oracle International Corporation

Anoop Mohan

Jianwu Xu

Eric J Bloemeke

Dengsheng Huang

Philip Geoffrey Holland

Bimal Patel

Mehdi Khosravi

Larry E Roddenberry

Scott D Coulter

Kiran Kumar Shetty

Weigang Lang

Subrahmanyam Kolachala

Zhibin Huang

Tak Hong

Harsh Malhotra

Systems, methods, and other embodiments are disclosed that are configured to provide distributed workbook storage for a multi-dimensional database system. In one embodiment, a workbook is created where the workbook is a personal data repository which is a subset of a domain of persistent multi-dimensional data cache of the multi-dimensional database system. A distributed storage location is selected for the workbook from multiple distributed storage locations of the data cache. A round robin selection process is used that promotes balanced loading and usage of multiple workbooks stored across the multiple distributed storage locations. A workbook directory structure is created for the workbook within the selected distributed storage location. The workbook directory structure reflects a same directory structure provided by a common global domain of the multi-dimensional database system up to a root directory of the selected distributed storage location.

System and method for distributed workbook storage

A system for dynamically parallelizing the loading operation for loading a data file onto a database. The dynamic parallelization of the loading operation involves scanning the data file in segments, such that scanning of an individual segment terminates when the scanned information is enough to enable loading of the segment across a plurality of exclusive-access memory blocks. Following the scanning of the first data file segment, the parallelized loading of each scanned segment occurs in a lock-step-mode with the scanning operation. As such, the loading of each scanned data segment is performed in parallel across multiple exclusive-access memory location, as determined by the prior scanning results, and furthermore in parallel with the scanning of a subsequent segment of the data file.

Dynamic parallelization of data loading

A system for generating a parallel calculation plan to evaluate a rule-set or a rule-based expression list by spilling the list of rule-based expressions into multiple task units and reconfiguring all independent task units at the same calculation levels into several parallelized task groups such that task units within each task group may be scheduled for parallel execution across a cluster of processing nodes. The parallelization may be dynamically determined based on generated tasks but may further be subject to an additional layer of parallelization based on range-based splitting of each task into multiple parallel executable subtasks. The final parallelized calculation plan may include a set of sequentially ordered task groups based on logical dependencies and problem partitioning with information regarding parallelized execution of each task group.

Dynamic parallelization of a calculation process

Growing community of inventors

Cumming, GA, United States of America

Anoop Mohan