Eager block fetching for web-based data grids

• US 8,965,963 B2
• Filed: 06/04/2014
• Issued: 02/24/2015
• Est. Priority Date: 10/19/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Evans, James A., van den Broek, Hendrik, Ahmed, Diar
• Primary Examiner(s): DINH, KHANH Q
• Application Number:
  US14/295,785
• Publication Number:
  US 20140289673A1
• Time in Patent Office: 265 Days
• Field of Search: 709/220, 709/224, 709/228, 709/232
• US Class Current: 709/203
• CPC Class Codes: G06F 2209/541 Client-server
• CPC Class Codes: G06F 3/0485 Scrolling or panning
• CPC Class Codes: G06F 9/54 Interprogram communication
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/34 involving the movement of software or configuration parameters network booting or remote initial program loading [RIPL] G06F9/4416
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]

Abstract

Techniques for improving scrolling performance in a web-based data grid. In one set of embodiments, when a user scrolls through a data grid rendered in a viewport of the user'"'"'s web browser, client-side code executing in the web browser can detect whether a scroll event has occurred that requires a portion of the viewport to be filled/refreshed with data from a server. The client-side code can further determine whether the scroll event is a short scroll or a long scroll, and can send a request to the server that indicates the type of scroll event. If the scroll event is a short scroll, the server can determine a first amount of data to fetch based on one or more first parameters. If the scroll event is a long scroll, the server can determine a second amount of data to fetch based on one or more second parameters.

Claims

1. A method for optimizing scrolling performance of a data grid, the method comprising:

receiving, by a server from a client computer system via a network, a request for data in response to a scroll event performed at the client computer system with respect to the data grid presented in a web browser, wherein;

the request comprising an indication of whether the scroll event is of a short scroll type or a long scroll type; and

the long scroll type being performed results in no portion of the data grid being displayed that comprises data previously transmitted to the client computer system;

determining, by the server, based on the request for data, that the scroll event is of the short scroll type; and

retrieving, by the server, based on the request for data and the scroll event being of the short scroll type, a first group of data for the data grid based on a predefined block size, the predetermined block size being a first number of cells by a second number of cells.

2. The method for optimizing scrolling performance of the data grid of claim 1, further comprising transmitting, by the server, the first group of data for the data grid to the client computer system.

3. The method for optimizing scrolling performance of the data grid of claim 1, wherein the request for the data comprises an indication of a starting position within the data grid.

4. The method for optimizing scrolling performance of the data grid of claim 1, wherein the short event of the short scroll type results in a portion of the data grid being displayed that comprises data previously transmitted to the client computer system.

5. The method for optimizing scrolling performance of the data grid of claim 3, further comprising:

receiving, by the server, a definition of the predefined block size.

6. The method for optimizing scrolling performance of the data grid of claim 3, further comprising:

receiving, by the server from the client computer system, a second request for data in response to a second scroll event performed at the client computer system with respect to the data grid presented in the web browser, wherein;

the second request comprising a second indication of whether the second scroll event is of the short scroll type or the long scroll type;

determining, by the server, based on the request for data, that the second scroll event is of the long scroll type; and

retrieving, based on the second request for data and the second scroll event being of the long scroll type, a second group of data for the data grid based on the predefined block size and a predetermined block array size, the second group of data comprising more data than the first group of data.

7. The method for optimizing scrolling performance of the data grid of claim 6, further comprising transmitting, by the server, the second group of data for the data grid to the client computer system.

8. The method for optimizing scrolling performance of the data grid of claim 6, wherein the predetermined block array size defines a first number of blocks by a second number of blocks.

9. A system for optimizing scrolling performance of a data grid, the system comprising:

a server comprising one or more processors and a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to;

receive, from a client computer system via a network, a request for data in response to a scroll event performed at the client computer system with respect to the data grid presented in a web browser, wherein;

the request comprising an indication of whether the scroll event is of a short scroll type or a long scroll type; and

the long scroll type being performed results in no portion of the data grid being displayed that comprises data previously transmitted to the client computer system;

determine, based on the request for data, that the scroll event is of the short scroll type; and

retrieve, based on the request for data and the scroll event being of the short scroll type, a first group of data for the data grid based on a predefined block size, the predetermined block size being a first number of cells by a second number of cells.

10. The system for optimizing scrolling performance of the data grid of claim 9, wherein the processor-readable instructions, when executed, further cause the one or more processors to:

cause the first group of data for the data grid to be transmitted to the client computer system.

11. The system for optimizing scrolling performance of the data grid of claim 9, wherein the request for the data comprises an indication of a starting position within the data grid.

12. The system for optimizing scrolling performance of the data grid of claim 9, wherein the scroll event of the short scroll type results in a portion of the data grid being displayed that comprises data previously transmitted to the client computer system.

13. The system for optimizing scrolling performance of the data grid of claim 11, wherein the processor-readable instructions, when executed, further cause the one or more processors to:

receive, from the client computer system, a second request for data in response to a second scroll event performed at the client computer system with respect to the data grid presented in the web browser, wherein;

the second request comprising a second indication of whether the second scroll event is of the short scroll type or the long scroll type;

determine based on the request for data, that the second scroll event is of the long scroll type; and

retrieve, based on the second request for data and the second scroll event being of the long scroll type, a second group of data for the data grid based on the predefined block size and a predetermined block array size, the second group of data comprising more data than the first group of data.

14. The system for optimizing scrolling performance of the data grid of claim 13, wherein the processor-readable instructions, when executed, further cause the one or more processors to:

cause the second group of data for the data grid to be transmitted to the client computer system.

15. The system for optimizing scrolling performance of the data grid of claim 13, wherein the predetermined block array size defines a first number of blocks by a second number of blocks.

16. A non-transitory processor-readable medium for optimizing scrolling performance of a data grid, comprising processor-readable instructions configured to cause one or more processors to:

receive, from a client computer system via a network, a request for data in response to a scroll event performed at the client computer system with respect to the data grid presented in a web browser, wherein;

the request comprising an indication of whether the scroll event is of a short scroll type or a long scroll type; and

the long scroll type being performed results in no portion of the data grid being displayed that comprises data previously transmitted to the client computer system;

determine, based on the request for data, that the scroll event is of the short scroll type; and

retrieve, based on the request for data and the scroll event being of the short scroll type, a first group of data for the data grid based on a predefined block size, the predetermined block size being a first number of cells by a second number of cells.

17. The non-transitory processor-readable medium for optimizing scrolling performance of the data grid of claim 16, wherein the processor-readable instructions are further configured to cause the one or more processors to cause the first group of data for the data grid to be transmitted to the client computer system.

18. The non-transitory processor-readable medium for optimizing scrolling performance of the data grid of claim 16, wherein the processor-readable instructions are further configured to cause the one or more processors to:

receive, from the client computer system, a second request for data in response to a second scroll event performed at the client computer system with respect to the data grid presented in the web browser, wherein;

the second request comprising a second indication of whether the second scroll event is of the short scroll type or the long scroll type;

determine based on the request for data, that the second scroll event is of the long scroll type; and

retrieve, based on the second request for data and the second scroll event being of the long scroll type, a second group of data for the data grid based on the predefined block size and a predetermined block array size, the second group of data comprising more data than the first group of data.