Dimension limits in information mining and analysis
Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to permit dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.
1. A method for data analysis, comprising:
processing a dataset resulting in a first multidimensional data structure, the dataset having a table structure comprising one or more tables; and
generating a second multidimensional data structure by applying one or more dimension limits to the first multidimensional data structure, wherein the one or more dimension limits control a number of values displayed for corresponding dimensions of the first multidimensional data structure.
2. The method of claim 1 , wherein applying the one or more dimension limits to the first multidimensional data structure comprises configuring one or more user interface elements.
3. The method of claim 1 , wherein applying the one or more dimension limits to the first multidimensional data structure comprises applying a dimension limit to a selected dimension variable of the second multidimensional data structure in response to a selection of a specific display option.
4. The method of claim 1 , wherein processing the dataset resulting in the first multidimensional data structure comprises evaluating a mathematical function for one or more dimension variables in the table structure.
5. A method comprising:
processing a dataset resulting in a first multidimensional data structure, the dataset having a table structure comprising one or more tables;
generating, based on one or more dimension limits applied to the first multidimensional data structure, a second multidimensional data structure comprising a first specific portion, wherein the one or more dimension limits control a number of values displayed for corresponding dimensions of the first multidimensional data structure; and
causing the first specific portion of the second multidimensional data structure to be displayed.
6. The method of claim 5 , wherein generating the second multidimensional data structure further comprises applying a display option resulting in a second specific portion of the second multidimensional data structure being displayed.
7. The method of claim 5 , wherein the first specific portion comprises a specific plurality of rows in a table contained in the first multidimensional data structure.
8. The method of claim 5 , wherein the first specific portion comprises a specific plurality of rows in a table contained in the first multidimensional data structure, and wherein respective values of the specific plurality of rows are accumulated and compared to a predetermined value.
9. The method of claim 5 , wherein the first specific portion comprises a specific plurality of rows in a table contained in the first multidimensional data structure, and wherein the specific plurality of rows is ordered in descending order.
10. The method of claim 5 , wherein the first specific portion comprises a specific plurality of rows in a table contained in the first multidimensional data structure, and wherein the specific plurality of rows is ordered in ascending order.
11. The method of claim 5 , wherein the first specific portion comprises one or more values that satisfy a specified condition.
12. The method of claim 5 , wherein the first specific portion comprises an aggregated value resulting from aggregating a plurality of values that dissatisfy a specific condition.
13. The method of claim 12 , wherein the first multidimensional data structure contains a result of evaluating a specific mathematical function for one or more calculation variables in the dataset, and wherein the first multidimensional data structure is partitioned for every unique value of one or more dimension variables in the dataset.
14. The method of claim 13 , wherein processing the dataset resulting in the first multidimensional data structure comprises sequentially reading a data item from the one or more tables in the table structure, and populating an intermediate data structure comprising one or more data records, and wherein each of the one or more data records contains a field for each dimension variable and an aggregation field for one or more mathematical expressions implied by the specific mathematical function.
15. The method of claim 14 , wherein populating the intermediate data structure comprises identifying, for the data item, a current value for each of the one or more dimension variable, evaluating each one of the one or more mathematical expressions based on the data item, and aggregating a result of the evaluation in an appropriate aggregation field based on the current value of each of the one or more dimension variables.
16. The method of claim 15 , wherein the first multidimensional data structure is generated by evaluating the specific mathematical function based on content of the aggregation field for every unique value of each of the one or more dimension variables.
17. The method of claim 16 , wherein the second multidimensional data structure is generated by traversing the intermediate data structure, thereby generating the aggregated value resulting from aggregating the plurality of values that dissatisfy the specific condition.
18. The method of claim 17 , further comprising identifying values for each of the one or more dimension variables that dissatisfy the specific condition based on the first multidimensional data structure.
19. The method of claim 18 , wherein traversing the intermediate data structure comprises aggregating the content of the aggregation fields associated with values of the one or more dimension variables that dissatisfy the specific condition, thereby evaluating the specific mathematical function for aggregating the plurality of values that dissatisfy the specific condition.
20. A device, comprising:
a memory having computer-executable instructions; and
a processor functionally coupled to the memory and configured, by the computer-executable instructions, to cause the device to:
process a dataset resulting in a first multidimensional data structure, the dataset having a table structure comprising one or more tables; and
apply one or more dimension limits to the first multidimensional data structure resulting in a second multidimensional data structure, wherein the one or more dimension limits control a number of values displayed for corresponding dimensions of the first multidimensional data structure.