Patent ID: 9672558
Date: 2017-06-06
CPC Classifications: G06F,G06Q

Claim:
1. A method comprising: receiving, from a requestor via a network, a request for a hierarchical dataset, the hierarchical dataset including at least two hierarchy levels, the request identifying data items of each hierarchy level; building, in memory, a single table structure where each hierarchy level is a row and each data item of a hierarchy level is a column, the single table structure including a key within the single table structure, the key including a first key row for a first hierarchy level of the at least two hierarchy levels and a second key row for a second hierarchy level of the at least two hierarchy levels, wherein the first key row comprises a first plurality of column labels for the first hierarchy level and the second key row comprises a second plurality of column labels for the second hierarchy level; retrieving, into the memory from a database, a plurality of data rows, the plurality of data rows comprising a first data row of the first hierarchy level described by the first plurality of column labels and a second data row of the second hierarchy level described by the second plurality of column labels; ordering and grouping the retrieved data rows of each hierarchy level; writing the ordered and grouped data rows of each hierarchy level to the single table structure in the memory in an order according to the at least two hierarchy levels of the hierarchical dataset; and transmitting, to the requestor via the network, a data representation of the hierarchical dataset from the memory.