Method and system for integrated optimized reporting
Systems and methods of the present disclosure are directed to efficiently editing data requests sent from devices, allowing for an improved database information delivery system. In some embodiments of the present disclosure, an administrator device limits an amount of data requested based on a number of factors prior to sending the request to a server. In some embodiments, a server, after receiving a request for refreshed data, reduces the amount of data requested based on a number of factors prior to retrieving the requested data from a source and delivering the requested data to an administrator device.
1. A method of refreshing data on an administrator device, the method comprising:
generating, by a processor of the administrator device, a refresh request associated with a plurality of cells of data to be refreshed;
identifying, by the processor of the administrator device, one or more of the plurality of cells of data to be refreshed to remove from the refresh request;
creating, by the processor of the administrator device, a minimized refresh request by removing the association of the one or more of the plurality of cells of data from the refresh request, wherein the minimized refresh request is of a lesser amount of data compared to the refresh request;
transmitting, by the processor of the administrator device, the minimized refresh request to a server;
receiving, at the processor and from the server, refreshed data comprising cells associated with the cells of data associated with the minimized refresh request; and
replacing, by the processor of the administrator device, the plurality of cells of data to be refreshed with the minimized refreshed data.
2. The method of claim 1 , wherein the refresh request is generated automatically based on a time interval.
3. The method of claim 2 , further comprising:
determining whether the one or more of the plurality of cells of data to be refreshed are identified to be in-focus; and
based on the determination, decreasing the time interval.
4. The method of claim 2 , further comprising:
determining whether the one or more of the plurality of cells of data to be refreshed are identified to be out-of-focus; and
based on the determination, decreasing the time interval.
5. The method of claim 1 , wherein the refresh request is generated manually by an administrator using the administrator device.
6. The method of claim 1 , wherein the one or more of the plurality of cells of data to be refreshed are identified according to one or more administrator-level rules.
7. The method of claim 1 , further comprising, prior to removing the association:
determining that the administrator device is running a screensaver; and
wherein, based on the determination that the administrator device is running a screensaver, creating the minimized refresh request comprises removing the association of all of the plurality of cells of data.
8. The method of claim 1 , further comprising, prior to removing the association:
determining that the administrator device is locked; and
wherein, based on the determination that the administrator device is locked, creating the minimized refresh request comprises removing the association of all of the plurality of cells of data.
9. The method of claim 1 , further comprising, prior to removing the association:
determining that an administrator is not physically present at the device; and
wherein, based on the determination that the administrator is not physically present at the device, creating the minimized refresh request comprises removing the association of all of the plurality of cells of data.
10. The method of claim 1 , further comprising, prior to removing the association:
determining one or more of the plurality of cells of data to be refreshed are not visible on a display of the administrator device; and
wherein, based on the determination of the one or more of the plurality of cells of data to be refreshed are visible on a display of the administrator device, creating the minimized refresh request comprises removing the association of the one or more of the plurality of cells of data to be refreshed.
11. The method of claim 1 , further comprising, prior to removing the association:
determining a portion of a first window on a display of the administrator device and the first window is hidden behind a second window displayed on the display; and
determining one or more cells requested in the refresh request are within the portion of the first window;
wherein creating the minimized refresh request comprises removing the association of the one or more cells in addition to removing the association of the one or more of the plurality of cells of data.
12. A system for delivering refreshed data to an administrator device, the system comprising:
a server comprising:
a memory;
a first processor in communication with the memory, wherein the first processor:
receives a refresh request associated with a plurality of cells of data to be refreshed on the administrator device;
identifies one or more of the plurality of cells of data to be refreshed to remove from the refresh request;
creates a minimized refresh request by removing the association of the one or more of the plurality of cells of data from the refresh request, wherein the minimized refresh request is of a lesser amount of data compared to the refresh request;
retrieves data corresponding to the cells of data associated with the minimized refresh request; and
transmits the data corresponding to the cells of data associated with the minimized refresh request to the administrator device.
13. The system of claim 12 , wherein the one or more of the plurality of cells of data to be refreshed are identified according to one or more server-level rules.
14. The system of claim 12 , wherein the processor:
determines a CPU Occupancy Level Average of the server exceeds a limit; and
initiates a server-level refresh throttling.
15. The system of claim 14 , wherein the processor:
determines the CPU Occupancy Level Average of the server is below the limit; and
ends the server-level refresh throttling.
16. The system of claim 14 , wherein the server-level refresh throttling comprises the processor delaying retrieving data corresponding to the cells of data associated with the refresh request until the server-level refresh throttling ends.
17. The system of claim 12 , wherein the processor, prior to retrieving data:
determines a second one or more of the plurality of cells to be refreshed were previously refreshed within a time interval;
wherein creating the minimized refresh request comprises removing the association of the second one or more of the plurality of cells of data from the refresh request.
18. The system of claim 17 , wherein the time interval is set based on how often data associated with the second one or more of the plurality of cells changes.
19. The system of claim 12 , wherein the processor:
receives a second refresh request from the administrator device;
determines the second refresh request was received outside a time limit; and
retrieves data associated with the second refresh request.
20. The system of claim 12 , wherein the one or more of the plurality of cells of data are identified based on an associated row or column.