Method and system for integrated optimized reporting

• US 10,587,727 B2
• Filed: 10/04/2016
• Issued: 03/10/2020
• Est. Priority Date: 10/04/2016
• Status: Active Grant

• Current Assignee: Avaya Incorporated
• Original Assignee: Avaya Incorporated
• Inventors: Smith, Lynn, Higgins, Sheila, Geist, Marc A., Li, Hongguang, Wilkison, Stan, Shepherd, Stuart M., Ockel, Dwayne W., Schin, Gregory P.
• Primary Examiner(s): Nguyen, Phuoc H
• Application Number:
  US15/285,302
• Publication Number:
  US 20180097913A1
• Time in Patent Office: 1,253 Days
• Field of Search: 709201, 709203, 709206, 709217
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: H04L 43/0817 by checking functioning
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46
• CPC Class Codes: H04L 67/34 involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416

Abstract

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.

Claims

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.