Transaction functionality in a multidimensional database
AssigneeOracle International Corporation
InventorsDonald Wayne Bean, Dinesh Balebail, Shailesh Phansalkar
Life of this patent
Estimating the term…
Abstract
Systems and methods that enable transaction oriented functions for a multidimensional database are provided. The systems and methods store a plurality of transactions in a multidimensional database, generate a first dimension including respective balances resulting from each of the transactions, and generate a second dimension identifying respective rules corresponding to each of the transactions.
Claims20
A method for enabling transaction oriented functions within a multidimensional database, the method comprising:
- receiving financial data generated in response to a plurality of transactions;
- storing the financial data as multidimensional data in the multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements;
- generating a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data.
A device comprising:
- a processor;
- and
- a memory storing one or more programs for execution by the processor, the one or more programs including instructions for:
- receiving financial data generated in response to a plurality of transactions;
- storing the financial data as multidimensional data in a multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements;
- generating
- a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data.
A non-transitory computer readable storage medium storing one or more programs configured to be executed by a processor, the one or more programs comprising instructions for:
- receiving financial data generated in response to a plurality of transactions;
- storing the financial data as multidimensional data in a multidimensional database, the multidimensional database comprising a plurality of dimensions, the dimensions comprising a balance dimension that stores a balance of the financial data at each of the transactions as data elements, and a rules dimension that stores each of a plurality of rules used to execute the plurality of transaction as rule elements;
- generating
- a visual representation of the data elements of the balance dimension and the rule elements of the rules dimension, the visual representation comprising visual cues that distinguishes between raw financial data and calculated financial data in the balance dimension, and that, for each of the calculated financial data, a corresponding rule element of the rules dimension that caused a calculation to generate the calculated financial data.
Dependencies are inferred from the claim text.