Generating a database query to dynamically aggregate rows of a data set
Generating a database query to dynamically aggregate rows of a data set including determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set; receiving a calculation for a third column within the spreadsheet structure; determining that the third column is on a same hierarchical level as the first column; and in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
1. A method for generating a database query to dynamically aggregate rows of a data set, the method comprising:
determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set;
receiving a calculation for a third column within the spreadsheet structure;
determining that the third column is on a same hierarchical level as the first column; and
in response to the determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
2. The method of claim 1 , further comprising:
receiving, in response to the database query, the aggregated plurality of rows of the data set; and
displaying, in the spreadsheet structure, the aggregated plurality of rows of the data set in the third column of the spreadsheet structure.
3. The method of claim 1 , further comprising:
determining that the third column has been moved to a same hierarchical level as the second column; and
in response to the determining that the third column has been moved to a same hierarchical level as the second column, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
4. The method of claim 1 , further comprising:
determining a change in the hierarchical relationship between the first column and the second column within the spreadsheet structure; and
in response to the determining the change in the hierarchical relationship between the first column and the second column within the spreadsheet structure, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the change to the hierarchical relationship between the first column and the second column.
5. The method of claim 1 , further comprising:
determining a row windowing based on the hierarchical relationship between the first column and the second column within the spreadsheet structure, and
wherein the generating the database query aggregating the plurality of rows of the data set is further based on the row windowing.
6. The method of claim 1 , wherein the determining that the third column is on the same hierarchical level as the first column comprises determining that the third column has been added to a first level in a list structure, wherein the first column has been selected as a key of the first level.
7. The method of claim 1 , wherein the database query aggregating a plurality of rows of the data set comprises a structure query language statement.
8. An apparatus for generating a database query to dynamically aggregate rows of a data set, the apparatus comprising:
a computer processor and a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set;
receiving a calculation for a third column within the spreadsheet structure;
determining that the third column is on a same hierarchical level as the first column; and
in response to the determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
9. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, in response to the database query, the aggregated plurality of rows of the data set; and
displaying, in the spreadsheet structure, the aggregated plurality of rows of the data set in the third column of the spreadsheet structure.
10. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
determining that the third column has been moved to a same hierarchical level as the second column; and
in response to the determining that the third column has been moved to a same hierarchical level as the second column, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
11. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
determining a change in the hierarchical relationship between the first column and the second column within the spreadsheet structure; and
in response to the determining the change in the hierarchical relationship between the first column and the second column within the spreadsheet structure, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the change to the hierarchical relationship between the first column and the second column.
12. The apparatus of claim 8 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
determining a row windowing based on the hierarchical relationship between the first column and the second column within the spreadsheet structure, and
wherein the generating the database query aggregating the plurality of rows of the data set is further based on the row windowing.
13. The apparatus of claim 8 , wherein the determining that the third column is on the same hierarchical level as the first column comprises determining that the third column has been added to a first level in a list structure, wherein the first column has been selected as a key of the first level.
14. The apparatus of claim 8 , wherein the database query aggregating a plurality of rows of the data set comprises a structure query language statement.
15. A computer program product for generating a database query to dynamically aggregate rows of a data set, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising:
computer program instructions that, when executed, cause a computer to carry out the steps of:
determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set;
receiving a calculation for a third column within the spreadsheet structure;
determining that the third column is on a same hierarchical level as the first column; and
in response to the determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
16. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, in response to the database query, the aggregated plurality of rows of the data set; and
displaying, in the spreadsheet structure, the aggregated plurality of rows of the data set in the third column of the spreadsheet structure.
17. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
determining that the third column has been moved to a same hierarchical level as the second column; and
in response to the determining that the third column has been moved to a same hierarchical level as the second column, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.
18. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
determining a change in the hierarchical relationship between the first column and the second column within the spreadsheet structure; and
in response to the determining the change in the hierarchical relationship between the first column and the second column within the spreadsheet structure, generating a subsequent database query aggregating the plurality of rows of the data set based on the calculation for the third column and the change to the hierarchical relationship between the first column and the second column.
19. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
determining a row windowing based on the hierarchical relationship between the first column and the second column within the spreadsheet structure, and
wherein the generating the database query aggregating the plurality of rows of the data set is further based on the row windowing.
20. The computer program product of claim 15 , wherein the determining that the third column is on the same hierarchical level as the first column comprises determining that the third column has been added to a first level in a list structure, wherein the first column has been selected as a key of the first level.