Apple Inc.

Toufic Milan

Duc Vuong

Christopher L Crim

Ashok Srinivasan

Andrew Phan

Stephen Iremonger

John Lorin Welshofer

Lee McIntyre

Heather L Winkle

Vladimir Bradateanu

Geraldine Vahey

Nikita Pisliakov

Clay Maeckel

David McKee

Andrew Paulsen

Richard L Kalman

Vladimir Brad

Ryan Chen

Jeff Leveille

Tianzhou Chen

Rick Kalman

Methods, program products, and systems for analytical charting are described. A system implementing analytical charting techniques can receive a selection input from a data view displaying data retrieved from a database table. The system can determine a context of the selection input, a data environment in which the selection input is received, and characteristics of data being selected. Based on the context, the data environment, and the characteristics, the system can generate a chart data grouping that specifies a relationship between data in a chart. The system can automatically specify one or more data series for the chart based on the chart data grouping. The system can generate chart parameters automatically and transparently to the user. The system can provide the system-generated chart parameters for display and allow user modification to the system-generated chart parameters. The system can then generate a chart using the chart parameters.

Analytical charting

Methods, program products, and systems for displaying context-aware charts are described. In context-aware charts, content of a chart can reflect a context of the chart. A charting object can be defined using a data series. The system can dynamically determine what subset of a data source should be used for the data series, depending on where the chart object is placed in a layout, form or other display area. Therefore, a single chart definition can be used to display various charts based on the context of the chart. When a chart object is moved from one data area to a new data area, the system can change the source of the data series such that the data series of the chart corresponds to a different subset of the data source.

Context-aware charting

Methods, program products, and systems for displaying data in formatted views using reference files are described. In some implementations, a database application program can generate a result set using one or more queries. The result set can contain actual data from a database and metadata. The metadata can contain references to data records in the database, the references can include identifiers that can identify the data records. When a user saves a database report file, the user can save at least a part of the result set using the identifiers instead of the queries and layouts. Thus, the result set can be saved as a reference file. When the database application program opens the saved reference file, the database application program can reproduce the result set using the stored references without running all of the queries.

Reference file for formatted views

A system displays content from a database in a formatted view. The formatted view includes one or more data fields arranged in one or more data sections. Each of the data sections includes a sub-summary display field. The system receives a request to modify data in one of the data fields. In response, the system reformats the formatted view. The reformatting includes moving the data field from a first data section to a second data section and updating the sub-summary display field in the first data section and the sub-summary display field in the second data section. The system displays the reformatted view.

Interactive sub-summaries in database applications

Techniques for displaying information associated with a database are disclosed. A database-informer displays information (or additional information) about various database objects displayed for a user. The database-informer may be presented to user as a tool-tip. However, the database-informer can be customized and dynamically constructed based on various variables that are dynamically determined at runtime. As such, the information can be dynamically determined based on variables stored in different tables and provided on-demand when the database-informer is invoked by the user. As a result, database users can be provided with customized and up-to-date information without having to view different tables.

Customizable, dynamic and on-demand database-informer for relational databases

Displaying a tooltip associated with a concurrently displayed database object

Growing community of inventors

Ottawa, Canada

Toufic Milan