Apple Inc.

Edward L Ford

Wesley Powell

Adam Ward

Eric Jacobson

Peter Nelson

Les Thomas

Gang Zhang

Methods, program products, and systems implementing browser-based database manipulation are described. A browser on a client device can receive a form definition that is generated based on a schema of a relational database and a layout. The schema in the form definition can specify properties of data fields. The browser can display the data fields and other components of the layout in a list. The browser can receive a drag-and-drop input, the drag-and-drop input selecting a data field or a layout component from the list and dropping the selected data field or layout component in a drop zone in a form area in the browser. The browser can determine the drop location, and use the drop location as a parameter to modify the form definition. The layout and the schema can be modified based on the modified form definition.

Browser based database manipulation

Methods, program products, and systems implementing intelligent data caching are disclosed. A client can send a request for data to a server. The request can include a query and a query context. The query can retrieve more data than can be displayed in a current page. The query context can specify a quantity of data records that can be displayed in the current page. The client can receive from the server two sets of data in response to the request. The first set of data can include row identifiers of data records that satisfy the query. The second set of data can include data records that can be displayed in the current page. The client can store the two sets of data in one or more buffers (e.g., two buffers) and update buffer(s) when different data records are displayed (e.g., when a user scrolls through pages).

Intelligent data caching

Growing community of inventors

Santa Clara, CA, United States of America

Edward L Ford