Formatting in a Database
A system and method for formatting in a database are disclosed. A request for data in a database is received from an application. The request includes one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application. The formatting functions are executed at the database to restructure the request. A query of the data in the database is then generated based on the restructured request, the query including only data to display in the graphical user interface according to the request. Then, a result of the query is returned from the database to the application for display in the graphical user interface.
1 . A method comprising:
receiving a request for data in a database from an application, the request including one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application;
executing the formatting functions at the database to restructure the request;
generating a query of the data in the database based on the restructured request, the query including only data to display in the graphical user interface according to the request;
returning a result of the query from the database to the application for display in the graphical user interface.
2 . The method in accordance with claim 1 , wherein the one or more processing functions includes at least one of filtering, sorting, grouping, and/or aggregating of the data in the database.
3 . The method in accordance with claim 1 , wherein executing the processing functions at the database further includes executing one or more filters specified by the application prior to receiving the request.
4 . The method in accordance with claim 3 , wherein the one or more filters includes one or more data formatting specifications.
5 . The method in accordance with claim 3 , wherein the one or more filters includes one or more code translation specifications.
6 . A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
providing, from an application, a request for data in a database, the request including one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application;
executing the formatting functions at the database to restructure the request;
generating a query of the data in the database based on the restructured request, the query including only data to display in the graphical user interface according to the request;
returning a result of the query from the database to the application for display in the graphical user interface.
7 . The computer program product in accordance with claim 6 , wherein the one or more processing functions includes at least one of filtering, sorting, grouping, and/or aggregating of the data in the database.
8 . The computer program product in accordance with claim 6 , wherein the operations include executing one or more filters specified by the application prior to receiving the request.
9 . The computer program product in accordance with claim 8 , wherein the one or more filters includes one or more data formatting specifications.
10 . The computer program product in accordance with claim 8 , wherein the one or more filters includes one or more code translation specifications.
11 . A system comprising:
at least one programmable processor; and
a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one programmable processor to perform operations comprising:
provide, from an application, a request for data in a database, the request including one or more formatting functions to be performed on the data to display a result of the request in a graphical user interface generated by the application;
execute the formatting functions at the database to restructure the request;
generate a query of the data in the database based on the restructured request, the query including only data to display in the graphical user interface according to the request;
return a result of the query from the database to the application for display in the graphical user interface.
12 . The system in accordance with claim 11 , wherein the one or more processing functions includes at least one of filtering, sorting, grouping, and/or aggregating of the data in the database.
13 . The system in accordance with claim 11 , wherein the operations include executing one or more filters specified by the application prior to receiving the request.
14 . The system in accordance with claim 13 , wherein the one or more filters includes one or more data formatting specifications.
15 . The system in accordance with claim 13 , wherein the one or more filters includes one or more code translation specifications.