Efficiently handling large data sets on mobile devices

• US 9,529,866 B2
• Filed: 12/20/2010
• Issued: 12/27/2016
• Est. Priority Date: 12/20/2010
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Sethi, Raman
• Primary Examiner(s): Chow, Doon
• Assistant Examiner(s): NGUYEN, LE V
• Application Number:
  US12/973,814
• Publication Number:
  US 20120159393A1
• Time in Patent Office: 2,199 Days
• Field of Search: 715/812, 715/738, 715/708, 715/773, 715/827, 715784-787
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/9574 of access to content, e.g. by caching
• CPC Class Codes: G06F 3/0485 Scrolling or panning
• CPC Class Codes: G06F 3/04855 Interaction with scrollbars

Abstract

A system, method, and computer program product are provided for efficiently fetching and displaying large datasets on mobile devices, such as devices running the iPhone™ operating system. The method fetches data for a mobile device from a server and displays a plurality of data rows in a ListView within a user interface on the mobile device. The method stores primary keys on the mobile device until their corresponding data rows are to be displayed. The method reacts to user inputs such as scrolling actions and touch screen gestures to efficiently fetch and display list view subsets of large datasets. The method facilitates quick response times when navigating through large lists of data on a mobile device by: fetching displayable or visible rows of data in a data list view, preloading the visible rows on the mobile device; and binding the visible rows to user interface elements on the mobile device.

Claims

1. A computer-implemented method for displaying a list view of a dataset on a mobile device, comprising:

initializing a list view for the mobile device, wherein the list view comprises bound primary keys and bound data rows received from a server and bound to user interface (UI) elements as displayed on the mobile device;

receiving data from the server in response to a query, wherein the received data comprises a plurality of primary keys corresponding to data rows from the dataset not already received at the mobile device, and wherein the corresponding data rows are stored on the server;

in response to detecting a direction and velocity of a scrolling input within the UI of the mobile device, defining a logical data window to have a size Nx, wherein x is a number of records simultaneously displayable on a page of the UI, and wherein N is a scroll speed, the logical window comprising the received primary key data which is not displayed on the mobile device;

predicting the scroll speed of the scrolling input based on a previous scrolling speed;

based on the speed of the scrolling input predicted to be a predetermined value, allocating a thread to fetch data;

based on the speed of the scrolling input predicted to be other than the predetermined value, receiving the data rows of the data set corresponding to the primary keys already received at the mobile device that comprise the logical data window;

binding, at the mobile device, the requested data rows corresponding to the primary keys of the logical data window, to a plurality of UI elements for display on the mobile device within the logical data window and prior to display in the list view, wherein the logical data window comprises a plurality of virtual groups bound to UI elements and sized based on a size of the logical data window and the direction and velocity of the scrolling input.

2. The method of claim 1, further comprising dividing the list view into virtual groups.

3. The method of claim 2, virtual groups comprise records for scroll behind data pages and scroll ahead data pages.

4. The method of claim 1, wherein the list view is a logical data structure based on a number of records displayable in the UI and a height of one visible row in the UI.

5. The method of claim 1, wherein the scroll speed is measured in pixels per second.

6. The method of claim 1, wherein the UI of the mobile device comprises a touch screen display, and wherein the scroll speed is predicted based upon a forcefulness measure of a scrolling gesture.

7. The method of claim 6, wherein the forcefulness measure of a scrolling gesture is based in part on the coefficient of friction on a touch screen UI of the mobile device.

8. The method of claim 1, wherein the dataset comprises hybrid data.

9. The method of claim 8, wherein the hybrid data comprises multimedia data types.

10. The method of claim 1, further comprising:

detecting a second direction and a second velocity of a scrolling input within the UI of the mobile device; and

redefining a size of the logical data window based on the second direction and second velocity, wherein the size of the logical data window prior to the redefining is different from the size of the logical data window after the redefining.

11. The method of claim 1, wherein based on the predicted speed of the scrolling input predicted to be the predetermined value, the allocating further comprises:

predicting the speed of the scrolling input to be zero;

determining that the thread is allocated to render visible rows.

12. The method of claim 1, further comprising:

resizing a moving window based on the scrolling speed, wherein the moving window indicates a number of records displayed on a screen; and

dynamically binding the size of the moving window.

13. A non-transitory computer-readable medium having stored thereon, computer-executable instructions that, in response to execution by a computing device, cause the computing device to perform operations for displaying data on a mobile device, the operations comprising:

initializing a list view for the mobile device, wherein the list view comprises bound primary keys and bound data rows received from a server and bound to user interface (UI) elements as displayed on the mobile device;

receiving data from the server in response to a query, wherein the received data comprises a plurality of primary keys corresponding to data rows from the dataset not already received at the mobile device, and wherein the corresponding data rows are stored on the server;

in response to detecting a direction and velocity of a scrolling input within the UI of the mobile device, defining a logical data window to have a size Nx, wherein x is a number of records simultaneously displayable on a page of the UI, and wherein N is a scroll speed, the logical window comprising the received primary key data which is not displayed on the mobile device;

predicting the scroll speed of the scrolling input based on a previous scrolling speed;

based on the speed of the scrolling input predicted to be a predetermined value, allocating a thread to fetch data;

based on the speed of the scrolling input predicated to be other than the predetermined value, receiving the data rows of the data set corresponding to the primary keys already received at the mobile device that comprise the logical data window;

binding, at the mobile device, the requested data rows corresponding to the primary keys of the logical data window, to a plurality of UI elements for display on the mobile device within the logical data window and prior to display in the list view, wherein the logical data window comprises a plurality of virtual groups bound to UI elements and sized based on a size of the logical data window and the direction and velocity of the scrolling input.

14. A system capable of displaying a list view of a dataset, the system comprising:

a mobile device comprising;

a fetching module configured to retrieve primary keys from the dataset in response to a query, wherein the primary keys correspond to data rows from the dataset not already received at the mobile device, and wherein the corresponding data rows are stored on a server;

an initialization module configured to initialize a list view data structure based on a number of records in the dataset and a height of one row in the UI of the mobile device;

a definition module configured to, in response to detecting a direction and velocity of a scrolling input within the UI of the mobile device, define a logical data window to have a size Nx, wherein x is a number of records simultaneously displayable on a page of the UI, and wherein N is a scroll speed, the logical window comprising the received primary key data which is not displayed on the mobile device;

a dynamic paging module, configured to;

predict the scroll speed of the scrolling input based on a previous scrolling speed;

based on the speed of the scrolling input predicted to be a predetermined value, allocate a thread to fetch data;

based on the speed of the scrolling input predicted to be other than the predetermined value, receive the data rows of the data set corresponding to the primary keys already received at the mobile device that comprise the logical data window;

a binding module configured to bind the requested data rows corresponding to the primary keys of the logical data window, to a plurality of UI elements for display on the mobile device within the logical data window and prior to display in the list view, wherein the logical data window comprises a plurality of virtual groups bound to UI elements and sized based on a size of the logical data window and the direction and velocity of the scrolling input; and

a display module configured to display the requested data rows corresponding to the primary keys of the logical data window bound to the plurality of UI elements.

15. The system of claim 14, wherein the primary keys are stored in a memory of the mobile device.

16. The system of claim 15, wherein the display module is further configured to display the portion of the plurality of data rows within 150 milliseconds after the receiving module receives the selection of an active view.

17. A computer program product comprising a non-transitory computer usable medium having computer program logic recorded thereon for enabling a processor to display a list view of a dataset at a client device, the computer program logic comprising:

fetching means for enabling the processor to retrieve primary keys from the dataset in response to a query, wherein the primary keys correspond to data rows from the dataset not already received at the mobile device, and wherein the corresponding data rows are stored on a server;

initialization means for enabling the processor to initialize a list view data structure based on a number of records in the dataset and a height of one row in the UI of the client device;

definition means for enabling the processor to, in response to detecting a direction and velocity of a scrolling input within the UI of the mobile device, define a logical data window to have a size Nx, wherein x is a number of records simultaneously displayable on a page of the UI, and wherein N is a scroll speed, the logical window comprising the received primary key data which is not displayed on the mobile device;

paging means for enabling the processor to;

predict the scroll speed of the scrolling input based on a previous scrolling speed;

based on the speed of the scrolling input predicted to be a predetermined value, allocate a thread to fetch data;

based on the speed of the scrolling input predicted to be other than the predetermined value, receive the data rows of the data set corresponding to the primary keys already received at the mobile device that comprise the logical data window;

binding means for binding, at the mobile device, the requested data rows corresponding to the primary keys of the logical data window, to a plurality of UI elements for display on the mobile device within the logical data window and prior to display in the list view, wherein the logical data window comprises a plurality of virtual groups bound to UI elements and sized based on a size of the logical data window and the direction and velocity of the scrolling input; and

displaying means for enabling the processor to display the requested data rows corresponding to the primary keys of the logical data window bound to the plurality of UI elements.

18. The computer program product of claim 17, wherein the client device is one or more of a desktop computer or a mobile device.

19. The computer program product of claim 17, further comprising a prioritization means for enabling the processor to give preference to the fetching means over the displaying means in response to detection of a zero or near zero scrolling velocity by the paging means.