Retrieving and displaying data from a columnar database
View Patent ↗A query is made at a computing device for generating a result-set. The result-set may comprise data selected from a database in response to the query. One or more cursors is associated with the result-set received in response to the query. The result-set is retrieved based on the one or more cursors. In one embodiment, the result-set may be retrieved in a columnar fashion.
1. A computer implemented method for processing of a received result-set, the method comprising:
receiving a query for generating a result-set including data selected from a columnar database in response to the query;
associating a plurality of database cursors with the result-set generated in response to the query, wherein each database cursor indicates a location of data of the result-set in storage; and
retrieving the data from the result-set based on the plurality of database cursors, wherein the data from the result-set is retrieved in a columnar format and the data serially corresponds to each column of the result-set, and wherein the data of the result-set associated with each of the database cursors is retrieved in parallel.
2. A computer program product for processing of a received result-set, the computer program product comprising a non-transitory computer readable storage medium having program instructions embodied therewith, the program instructions readable by a processor to cause the processor to perform a method comprising:
receiving a query for generating a result-set including data selected from a database in response to the query;
associating a plurality of database cursors with the result-set generated in response to the query, wherein each database cursor indicates a location of data of the result-set in storage; and
retrieving the data from the result-set based on the plurality of database cursors, wherein the data from the result-set is retrieved in a columnar format and the data serially corresponds to each column of the result-set, and wherein the data of the result-set associated with each of the database cursors is retrieved in parallel.
3. A computer system for processing of a received result-set, the computer system comprising:
one or more computer processors;
one or more computer readable storage media;
program instructions stored on the computer readable storage media for execution by at least one of the one or more processors, the program instructions causing the at least one processor to perform a method comprising:
receiving a query for generating a result-set including data selected from a database in response to the query;
associating a plurality of database cursors with the result-set generated in response to the query, wherein each database cursor indicates a location of data of the result-set in storage; and
retrieving the data from the result-set based on the plurality of database cursors, wherein the data from the result-set is retrieved in a columnar format and the data serially corresponds to each column of the result-set, and wherein the data of the result-set associated with each of the database cursors is retrieved in parallel.
4. The method of claim 1 , wherein the columnar format includes at
least one column, and each column of the result-set is associated with at least one of the plurality of database cursors, each database cursor being an implicit database cursor.
5. The computer program product of claim 2 , wherein the columnar format includes at least one column, and each column of the result-set is associated with at least one of the plurality of database cursors, each database cursor being an implicit database cursor.
6. The computer system of claim 3 , wherein the columnar format includes at least one column, and each column of the result-set is associated with at least one of the plurality of database cursors, each cursor being an implicit database cursor.
7. The method of claim 4 , further comprising:
synchronizing each of the implicit database cursors with any associated columns of the result-set.
8. The computer program product of claim 5 , wherein the method further comprises:
synchronizing each of the implicit database cursors with any associated columns of the result-set.
9. The computer system of claim 6 , wherein the method further comprises:
synchronizing each of the implicit database cursors with any associated columns of the result-set.
10. The method of claim 7 , further comprising:
fetching the data associated with the same implicit database cursor into a variable.
11. The computer program product of claim 8 , wherein the method further comprises:
fetching the data associated with the same implicit database cursor into a variable.
12. The computer system of claim 9 , wherein the method further comprises:
fetching the data associated with the same implicit database cursor into a variable.