Efficiently handling large data sets on mobile devices

Patent metadata

Field	Value
Publication number	US-9529866-B2
Application number	US-97381410-A
Country	US
Kind code	B2
Filing date	Dec 20, 2010
Priority date	Dec 20, 2010
Publication date	Dec 27, 2016
Grant date	Dec 27, 2016

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.

First claim

What is claimed is:

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 base

Assignees

• Sethi Raman
• Sybase Inc

Inventors

• Sethi Raman

Classifications

• G06F16/9574

  of access to content, e.g. by caching · CPC title

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F3/0485

  Scrolling or panning · CPC title

• G06F3/04855

  Interaction with scrollbars · CPC title

• G06F17/30902

  Physics · mapped topic