Hierarchical dimension analysis in multi-dimensional pivot grids
First Claim
1. A method for facilitating transforming or updating displayed data in an enterprise computing environment, the enterprise computing environment including one or more client devices in communication with a server system, wherein the server system executes webpage software, wherein the webpage software provides webpage information accessible to one or more client devices, the server system executing steps of the method, the method comprising:
- providing a user interface display that includes controls to;
select a tree to attach or detach to a set of data in response to a user selection; and
attach or detach a tree name and a tree node to associate or disassociate a tree structure with the set of data;
generating one or more flattened temporary tree tables based on a tree hierarchy of the selected tree, wherein the one or more flattened temporary tree tables are stored in a database, wherein the one or more flattened temporary tree tables provide live access via constructs to data from a dataset that is in the database, wherein the data represents leaf nodes of the tree hierarchy;
storing hierarchy information via one or more metadata tree tables, wherein the hierarchy information characterizes relationships between nodes of the tree hierarchy;
reverse mapping the hierarchy information relative to the data maintained in the one or more flattened temporary tree tables;
selectively accessing the database using the constructs to update the data characterized by metadata of the one or more metadata tree tables;
using the one or more pivot grids to replicate one or more hierarchical properties of the one or more metadata tree tables, based on the reverse mapping relative to the data maintained in the one or more flattened tree tables;
providing information based on the one or more pivot grids, the information adapted to be displayed via one or more client devices;
detecting a user initiated change to the one or more pivot grids; and
in response to the user initiated change to the one or more pivot grids, retrieving a proper subset of the dataset related to the user initiated change to the one or more pivot grids and updating the one or more flattened temporary tree tables based on the proper subset of the dataset related to the user initiated change to the one or more pivot grids without using a cache call.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.
56 Citations
21 Claims
-
1. A method for facilitating transforming or updating displayed data in an enterprise computing environment, the enterprise computing environment including one or more client devices in communication with a server system, wherein the server system executes webpage software, wherein the webpage software provides webpage information accessible to one or more client devices, the server system executing steps of the method, the method comprising:
-
providing a user interface display that includes controls to;
select a tree to attach or detach to a set of data in response to a user selection; andattach or detach a tree name and a tree node to associate or disassociate a tree structure with the set of data; generating one or more flattened temporary tree tables based on a tree hierarchy of the selected tree, wherein the one or more flattened temporary tree tables are stored in a database, wherein the one or more flattened temporary tree tables provide live access via constructs to data from a dataset that is in the database, wherein the data represents leaf nodes of the tree hierarchy; storing hierarchy information via one or more metadata tree tables, wherein the hierarchy information characterizes relationships between nodes of the tree hierarchy; reverse mapping the hierarchy information relative to the data maintained in the one or more flattened temporary tree tables; selectively accessing the database using the constructs to update the data characterized by metadata of the one or more metadata tree tables; using the one or more pivot grids to replicate one or more hierarchical properties of the one or more metadata tree tables, based on the reverse mapping relative to the data maintained in the one or more flattened tree tables; providing information based on the one or more pivot grids, the information adapted to be displayed via one or more client devices; detecting a user initiated change to the one or more pivot grids; and in response to the user initiated change to the one or more pivot grids, retrieving a proper subset of the dataset related to the user initiated change to the one or more pivot grids and updating the one or more flattened temporary tree tables based on the proper subset of the dataset related to the user initiated change to the one or more pivot grids without using a cache call. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 21)
-
-
19. An apparatus comprising:
-
a digital processor coupled to a display and to a processor-readable storage device, wherein the processor-readable storage device includes one or more instructions executable by the digital processor to perform the following acts; providing a user interface display that includes controls to; select a tree to attach or detach to a set of data in response to a user selection; and attach or detach a tree name and a tree node to associate or disassociate a tree structure with the set of data; generating one or more flattened temporary tree tables based on a tree hierarchy of the selected tree, wherein the one or more flattened temporary tree tables are stored in a database, wherein the one or more flattened temporary tree tables provide live access via constructs to data from a dataset that is in the database, wherein the data represents leaf nodes of the tree hierarchy; storing hierarchy information via one or more metadata tree tables, wherein the hierarchy information characterizes relationships between nodes of the tree hierarchy; reverse mapping the hierarchy information relative to the data maintained in the one or more flattened temporary tree tables; selectively accessing the database using the constructs to update the data characterized by metadata of the one or more metadata tree tables; using the one or more pivot grids to replicate one or more hierarchical properties of the one or more metadata tree tables, based on the reverse mapping relative to the data maintained in the one or more flattened tree tables; providing information based on the one or more pivot grids, the information adapted to be displayed via one or more client devices; detecting a user initiated change to the one or more pivot grids; and in response to the user initiated change to the one or more pivot grids, retrieving a proper subset of the dataset related to the user initiated change to the one or more pivot grids and updating the one or more flattened temporary tree tables based on the proper subset o f the dataset related to the user initiated change to the one or more pivot grids without using a cache call.
-
-
20. A processor-readable storage device including instructions executable by a digital processor, the processor-readable storage device including one or more instructions for:
-
providing a user interface display that includes controls to; select a tree to attach or detach to a set of data in response to a user selection; and attach or detach a tree name and a tree node to associate or disassociate a tree structure with the set of data; generating one or more flattened temporary tree tables based on a tree hierarchy of the selected tree, wherein the one or more flattened temporary tree tables are stored in a database, wherein the one or more flattened temporary tree tables provide live access via constructs to data from a dataset that is in the database, wherein the data represents leaf nodes of the tree hierarchy; storing hierarchy information via one or more metadata tree tables, wherein the hierarchy information characterizes relationships between nodes of the tree hierarchy; reverse mapping the hierarchy information relative to the data maintained in the one or more flattened temporary tree tables; selectively accessing the database using the constructs to update the data characterized by metadata of the one or more metadata tree tables; using the one or more pivot grids to replicate one or more hierarchical properties of the one or more metadata tree tables, based on the reverse mapping relative to the data maintained in the one or more flattened tree tables; providing information based on the one or more pivot grids, the information adapted to be displayed via one or more client devices; detecting a user initiated change to the one or more pivot grids; and in response to the user initiated change to the one or more pivot grids, retrieving a proper subset of the dataset related to the user initiated change to the one or more pivot grids and updating the one or more flattened temporary tree tables based on the proper subset of the dataset related to the user initiated change to the one or more pivot grids without using a cache call.
-
Specification