Displaying a tooltip associated with a concurrently displayed database object

• US 7,672,968 B2
• Filed: 05/12/2005
• Issued: 03/02/2010
• Est. Priority Date: 05/12/2005
• Status: Active Grant

• Current Assignee: Apple Inc.
• Original Assignee: Apple Inc.
• Inventors: Milan, Toufic, Vahey, Geraldine, McIntyre, Lee, Bradateanu, Vladimir, Welshofer, John Lorin
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Nofal; Christopher P
• Application Number:
  US11/128,459
• Publication Number:
  US 20060259503A1
• Time in Patent Office: 1,755 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5, 715/700
• US Class Current: 707/807
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

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.

Claims

1. A computer-implemented method for automatically displaying a tooltip associated with a displayed database object, the method comprising:

providing a database containing a plurality of records, wherein each record in the plurality of records includes at least one field;

displaying, in a layout or design form, a visual representation of the database, the visual representation including one or more selectable database objects, wherein each database object corresponds to a field stored in the database, wherein each database object is associated with one or more state-variables defined in the database;

receiving an indication to select a first database object, wherein the indication is determined by satisfying a condition or triggering an event;

automatically calculating a tooltip corresponding to the first database object, wherein the tooltip has been previously defined for the first database object by a user of the database, wherein the tooltip provides information that is related to the first database object;

automatically parsing an expression that is defined for displaying the tooltip, wherein the expression comprises one or more state-variables that are related to the first database object,

wherein the one or more state-variables are stored in one or more records of the database;

automatically determining one or more values for the one or more state-variables of the expression;

dynamically evaluating the expression based on the one or more determined values of the one or more state-variables; and

automatically displaying the tooltip with a result of the evaluated expression, wherein the tooltip is displayed proximate to and concurrently with the displayed first database object.

2. The method of claim 1, further comprising:

defining one or more user-defined tooltip expressions by;

for each of the plurality of displayed database objects, providing a visual indication of whether or not the corresponding database object has an associated user-defined tooltip expression; and

for each of the plurality of displayed database objects that does not have an associated user-defined tooltip expression, displaying at least one table or field of a record of a database to aid a user in defining a user-defined tooltip expression.

3. The method of claim 2,

wherein the at least one displayed table or field of a record of a database to aid a user in defining a user-defined tooltip expression includes a table or field related to the field of the corresponding database object.

4. The method of claim 1, wherein the expression is a mathematical operation.

5. The method of claim 1, wherein the expression is a logical operation.

6. The method of claim 1, wherein the expression is a text processing operation.

7. The method of claim 1, wherein the expression is a database function.

8. The method of claim 1, wherein the indication includes a user positioning a cursor over the database object in a display, for a predetermined period of time.

9. The method of claim 1, wherein the automatically determining one or more values identifies one or more database records that contain values for the state-variables.

10. A database system comprising:

a database containing a plurality of records, wherein each record in the plurality of records includes at least one field;

a database engine communicatively coupled to the database; and

a graphical user interface, wherein the graphical user interface is configured to;

display, in a layout or design form, a visual representation of the database, the visual representation including one or more selectable database objects, wherein each database object corresponds to a field stored in the database, wherein each database object is associated with one or more state-variables defined in the database;

receive an indication to select a first database object, wherein the indication is determined by satisfying a condition or triggering an event;

automatically calculate a tooltip corresponding to the first database object, wherein the tooltip has been previously defined for the first database object by a user of the database, wherein the tooltip provides information that is related to the first database object;

automatically parse an expression that is defined for displaying the tooltip, wherein the expression comprises one or more state-variables that are related to the first database object, wherein the one or more state-variables are stored in one or more records of the database;

automatically determine one or more values for the one or more state-variables of the expression;

dynamically evaluate the expression based on the one or more determined values of the one or more state-variables; and

automatically display the tooltip with a result of the evaluated expression, wherein the tooltip is displayed proximate to and concurrently with the displayed first database object.

11. The database system of claim 10, wherein the expression is a mathematical operation.

12. The database system of claim 10, wherein the expression is a logical operation.

13. The database system of claim 10, wherein the expression is a text processing operation.

14. The database system of claim 10, wherein the expression is a database function.

15. The database system of claim 10, wherein the indication includes a user positioning a cursor over the database object in a display, for a predetermined period of time.

16. The database system of claim 10, wherein the automatically determining one or more values identifying one or more database records that contain values for the state-variables.

17. A computer-readable medium tangibly embodying a set of computer instructions executable by a machine to perform a method for automatically displaying a tooltip associated with a displayed database object, the method comprising:

providing a database containing a plurality of records, wherein each record in the plurality of records includes at least one field;

displaying, in a layout or design form, a visual representation of the database, the visual representation including one or more selectable database objects, wherein each database object corresponds to a field stored in the database, wherein each database object is associated with one or more state-variables defined in the database;

receiving an indication to select a first database object, wherein the indication is determined by satisfying a condition or triggering an event;

automatically calculating a tooltip corresponding to the first database object, wherein the tooltip has been previously defined for the first database object by a user of the database, wherein the tooltip provides information that is related to the first database object;

automatically parsing an expression that is defined for displaying the tooltip, wherein the expression comprises one or more state-variables that are related to the first database object, wherein the one or more state-variables are stored in one or more records of the database;

automatically determining one or more values for the one or more state-variables of the expression;

dynamically evaluating the expression based on the one or more determined values of the one or more state-variables; and

automatically displaying the tooltip with a result of the evaluated expression, wherein the tooltip is displayed proximate to and concurrently with the displayed first database object.

18. The computer readable medium of claim 17, wherein the expression includes a concatenation of multiple strings of characters.

19. The computer readable medium of claim 17, wherein the method further comprises:

displaying an expression definition screen containing a plurality of database objects and an indication of whether or not the corresponding database object has an associated tooltip.

20. The computer readable medium of claim 17, wherein the indication of whether or not the corresponding database object has an associated tooltip is a small yellow box displayed when a database object has an associated tooltip.