Data browser for group-by data access
View Patent ↗Methods and apparatus, including computer program products, are provided for group-by access of a database. In one aspect there is provided a method. The method may include receiving from a user interface information defining a database and a database table; converting the received information into at least one instruction for performing the group-by and the sum at the database table included in the database; sending the at least one instruction to the database; receiving, in response to the at least one instruction sent, a result-set from the database, the result-set representative of the group-by and the sum of the database table; and providing the result-set to an interface. Related systems and articles of manufacture are also discloses.
1. A non-transitory computer-readable medium containing instructions to configure at least one processor to cause operations comprising:
receiving, from a user interface, information representative of a selection of a database and a database table, the information further representative of at least one function to be performed at the database table;
selecting, based on the information, the database and the database table, the selecting of the database performed from among a plurality of databases, and the selecting of the database table performed from among a plurality of database tables of the selected database;
converting the information into at least one instruction for performing the at least one function comprising a group-by and a sum at the database table included in the selected database;
transforming the at least one instruction into a database command, the database command in a format compatible with the selected database, the format based on whether the selected database is a column-store database or a row-store database;
sending the database command to the database;
receiving, in response to the database command sent, a result-set from the database, the result-set representative of the group-by and the sum of the database table; and
providing the result-set to an interface comprising at least one of the user interface or a programming interface.
2. The non-transitory computer-readable medium of claim 1 , wherein the converting is implemented at a first processor separate from the database configured as at least one of an in-memory database and a column-store database.
3. The non-transitory computer-readable medium of claim 1 , wherein the providing further comprises:
providing the result-set as a page presented at the user interface.
4. The non-transitory computer-readable medium of claim 1 , wherein the selected database further comprises an in-memory database.
5. A method comprising:
receiving, from a user interface, information representative of a selection of a database and a database table, the information further representative of at least one function to be performed at the database table;
selecting, based on the information, the database and the database table, the selecting of the database performed from among a plurality of databases, and the selecting of the database table performed from among a plurality of database tables of the selected database;
converting the information into at least one instruction for performing the at least one function comprising a group-by and a sum at the database table included in the selected database;
transforming the at least one instruction into a database command, the database command in a format compatible with the selected database, the format based on whether the selected database is a column-store database or a row-store database;
sending the database command to the database;
receiving, in response to the database command sent, a result-set from the database, the result-set representative of the group-by and the sum of the database table; and
providing the result-set to an interface comprising at least one of the user interface or a programming interface.
6. The method of claim 5 , wherein the converting is implemented at a first processor separate from the database configured as at least one of an in-memory database and a column-store database.
7. The method of claim 5 , wherein the providing further comprises:
providing the result-set as a page presented at the user interface.
8. The method of claim 5 , wherein the selected database further comprises an in-memory database.
9. A system comprising:
at least one processor; and
at least one memory including code, which when executed by the at least one processor causes operations comprising:
receiving, from a user interface, information representative of a selection of a database and a database table, the information further representative of at least one function to be performed at the database table;
selecting, based on the information, the database and the database table, the selecting of the database performed from among a plurality of databases, and the selecting of the database table performed from among a plurality of database tables of the selected database;
converting the information into at least one instruction for performing the at least one function comprising a group-by and a sum at the database table included in the selected database;
transforming the at least one instruction into a database command, the database command in a format compatible with the selected database, the format based on whether the selected database is a column-store database or a row-store database;
sending the database command to the database;
receiving, in response to the database command sent, a result-set from the database, the result-set representative of the group-by and the sum of the database table; and
providing the result-set to an interface comprising at least one of the user interface or a programming interface.
10. The system of claim 9 , wherein the converting is implemented at a first processor separate from the database configured as at least one of an in-memory database and a column-store database.
11. The system of claim 9 , wherein the providing further comprises:
providing the result-set as a page presented at the user interface.