Apple Inc.

Les Thomas

Eric Jacobson

Gang Zhang

Peter Nelson

Wesley Powell

Edward L Ford

Adam Ward

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 integrated repository of structured and unstructured data are disclosed. An integrated environment is provided for accessing structured data (e.g., data of a relational database) and unstructured data (e.g., data stored in a text or binary file), including creating, managing, modifying, and searching the structured data and unstructured data. The integrated environment can include an integrated user interface, a set of commands and application programming interface (API), and storage for a relational database and a document repository. The integrated environment can include a database abstraction layer that allows database operations on both the structured data and the unstructured data.

Extended database search

Methods, program products, and systems implementing integrated repository of structured and unstructured data are disclosed. An integrated environment is provided for accessing, structured data (e.g., data of a relational database) and unstructured data (e.g., data stored in a text or binary file), including creating, managing, modifying, and searching the structured data and unstructured data. The integrated environment can include an integrated user interface, a set of commands and application programming interface (API), and storage for a relational database and a document repository. The integrated environment can include a database abstraction layer that allows database operations on both the structured data and the unstructured data.

Integrated repository of structured and unstructured data

Methods, program products, and systems implementing dynamic data association are described. Relations between a first data item and a second data item can be created in an ad hoc manner. The first data item can include a row of data in a table in a relational database. The second data item can include a row of data in the same table, in another table in the relational database, or a document outside the relational database. Configurable metadata can be created to link the first data item and the second data item. The link can be directional. The configurable metadata can include data specified by a user. The configurable metadata can be stored in one or more system tables in the relational database. The configurable metadata can be specific to the user, or to a work group of the user. The configurable metadata can change when the first data item or the second data item is modified.

Growing community of inventors

Los Gatos, CA, United States of America

Les Thomas