US 11,455,296 B1Granted

Offline structured data entry and data access on a mobile device

AssigneeQuickBase, Inc.

InventorsJonathan Williamson, Siddhant Benadikar

Life of this patent

Estimating the term…

Loading patent…

Abstract

A digital data processing system includes a server digital data processor that maintains (i) one or more tables, each comprising records or other structured data (collectively, “records”), (ii) a schema for each of the remote app and of one or more of the tables dedicated to or associated with the app, where each schema comprises a collection of metadata for the respective app or table. A client digital data processor is at least intermittently connected for communications with the server, and a remote app executes on that client digital data processor. The app includes instructions to cause that digital data processor request a record from one of the tables, to update data in that record and to request storage of the update back to that table. The remote app utilizes the schemas to prefetch data from the one or more tables dedicated to or associated with the app.

Claims25

Dependent claims

A method of remote app execution comprising the steps of:

A. executing a remote app on a client digital data processor that is adapted to be at least intermittently connected for communications with a server digital data processor,
B. executing instructions within the remote app to cause the client digital data processor to request a record from a table maintained on the server digital data processor, to update data in that record, and to request storage of the update back to that table,
C. executing a proxy on the client digital data processor that accommodates interruptions in connectivity between the client digital data processor and the server digital data processor by alternatively (i) passing to the server digital data processor, during intervals when there is connectivity, requests made by or on behalf of the remote app and routing back to the remote app responses by the server to those requests, and (ii) responding to those requests directly and without, first, passing them to the server when connectivity is lacking,
D. wherein the proxy caches data previously fetched from the one or more tables and uses the cached data to respond to the requests made by or on behalf of the app when connectivity is lacking,
E. wherein, during an interval when there is connectivity, the proxy passes to the server digital data processor a request made by or on behalf of the remote app, even if data requested by that request has been previously been fetched and cached by the proxy.

2 more elements

A digital data processing system, comprising:

A. a server digital data processor that maintains one or more tables, each comprising records or other structured data (collectively, “records”),
B. a client digital data processor that is at least intermittently connected for communications with the server,
C. a remote app executing on the client digital data processor, the app including instructions to cause that digital data processor to request a record from one of the tables, to update data in that record and to request storage of the update back to that table,
D. a proxy executing on the client digital data processor that accommodates interruptions in connectivity between the client digital data processor and the server digital data processor by alternatively (i) passing to the server digital data processor, during intervals when there is connectivity, requests made by or on behalf of the remote app and routing back to the remote app responses by the server to those requests, and (ii) responding to those requests directly and without, first, passing them to the server digital data processor when connectivity is lacking,
E. wherein the proxy caches data previously fetched from the one or more tables and uses the cached data to respond to the requests made by or on behalf of the app when connectivity is lacking,
F. wherein, during an interval when there is connectivity, the proxy passes to the server digital data processor a request made by or on behalf of the remote app, even if data requested by that request has previously been fetched and cached by the proxy.

3 more elements

A digital data processing system, comprising:

A. a server digital data processor that maintains
(i) one or more tables, each comprising records or other structured data (collectively, “records”),
(ii) a schema for each of a remote app and of one or more of the tables dedicated to or associated with that app, where each schema comprises a collection of metadata for the respective app or table, where that metadata includes names and types of data fields in said one or more tables, definitions of forms for user entry of data into those tables, and at least one of queries, views, and reports for use in navigating said one or more tables,
B. a client digital data processor that is at least intermittently connected for communications with the server,
C. the remote app executing on the client digital data processor, that app including instructions to cause that digital data processor request a record from one of the tables, to update data in that record and to request storage of the update back to that table,
D. the remote app utilizes the schemas to
(i) identify tables used by the remote app and the names and types of data fields in each such table, and based thereon to prefetch data from the one or more tables dedicated to or associated with the remote app,
(ii) present data from the one or more tables to a user of the remote app based on at least one of queries, views, and reports defined in the metadata, and
(iii) accept entry of data from the user of the remote app for the one or more tables based on forms defined in the metadata.

6 more elements

A digital data processing method, comprising:

A. maintaining on a server digital data processor one or more tables, each comprising records or other structured data (collectively, “records”),
B. executing a remote app on a client digital data processor that is at least intermittently connected for communications with the server, the app including instructions to cause that digital data processor to request a record from one of the tables, to update data in that record and to request storage of the update back to that table,
D. executing a proxy on the client digital data processor that accommodates interruptions in connectivity between the client digital data processor and the server digital data processor by alternatively (i) passing to the server, during intervals when there is connectivity, requests made by or on behalf of the remote app and routing back to the remote app responses by the server to those requests, and (ii) responding to those requests directly and without, first, passing them to the server when connectivity is lacking,
E. wherein the proxy caches data previously fetched from the one or more tables and uses the cached data to respond to the requests made by or on behalf of the app when connectivity is lacking,
F. wherein, during an interval when there is connectivity, the proxy passes to the server digital data processor a request made by or on behalf of the remote app, even if data requested by that request has previously been fetched and cached by the proxy.

2 more elements

A digital data processing method, comprising:

A. maintaining, with a server digital data processor:
(i) one or more tables, each comprising records or other structured data (collectively, “records”),
(ii) a schema for each of the remote app and of one or more of the tables dedicated to or associated with the app, where each schema comprises a collection of metadata for the respective app or table, where that metadata includes names and types of data fields in said one or more tables, definitions of forms for user entry of data into those tables, and at least one of queries, views, and reports for use in navigating said one or more tables,
B. executing a remote app on a client digital data processor that is at least intermittently connected for communications with the server, the app including instructions to cause that digital data processor request a record from one of the tables, to update data in that record and to request storage of the update back to that table,
C. utilizing the schemas within the remote app to
(i) identify tables used by the remote app and the names and types of data fields in each such table, and based thereon to prefetch data from the one or more tables dedicated to or associated with the remote app,
(ii) present data from the one or more tables to a user of the remote app based on at least one of queries, views, and reports defined in the metadata, and
(iii) accept entry of data from the user of the remote app for the one or more tables based on forms defined in the metadata.

5 more elements

Dependencies are inferred from the claim text.