Representation of data records

• US 7,461,077 B1
• Filed: 07/29/2002
• Issued: 12/02/2008
• Est. Priority Date: 07/31/2001
• Status: Active Grant

• Current Assignee: Musicqubed Innovations LLC (Ascend Innovation Management, LLC)
• Original Assignee: Nicholas Greenwood
• Inventors: Greenwood, Nicholas
• Primary Examiner(s): Le; Debbie M
• Application Number:
  US10/208,635
• Time in Patent Office: 2,318 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A computerized method for representing a data record comprising: querying a data source to obtain data selected from the group consisting of a data element in a record, and metadata concerning the record; presenting in a display a record handle for manipulation of the record; presenting in the display a data item wherein the data item is a list of data items or a reference to another record; and, optionally, presenting on the display the metadata above the data item. In some embodiments, the method includes the step of retrieving one or more heterogeneous records from a plurality of databases for display and manipulation. The invention is also a grid control programmed to implement a disclosed method and is a computer-readable medium having computer-executable instructions for performing a disclosed method. The invention links the grid control of the invention with automatic query generation using hierarchical data schema trees. Both the trees and the grid records represent relational foreign keys as extra reference columns. In the grid control, these reference columns are additional embedded record handles.

Claims

1. A computerized method for representing data on a display, the method comprising:

querying a data source to obtain data comprising a first data record;

presenting the first data record on the display as a data field; and

presenting on the display a record handle for manipulation of the first data record;

wherein the data field has any data field type in the group consisting of

a single data element,

a list of data elements, and

a reference to a second data record;

wherein the record handle is a visual element that represents the first data record and that is operative to control and continuously track the state of the first data record on the display and in the data source; and

wherein the record handle is operative to visually indicate to a user a current default action that will be activated when the user clicks on the record handle.

2. The computerized method of claim 1 wherein the data obtained during the querying step further comprises metadata concerning the first data record and the method further comprises:

presenting on the display the metadata as a label in a header above the data field.

3. The computerized method of claim 1 wherein the list of data elements is presented in a format selected from the group consisting of:

a single data element in the list,

a list handle that is operative to present all the data elements in the list,

all of the data elements in the list, and

a new field that is operative to allow the user to add a data element to the list.

4. The computerized method of claim 1 wherein the reference to the second data record is presented in a format selected from the group consisting of:

a get handle that is operative to display a second data element in the second data record on the same line upon which the get handle is displayed wherein the displayed record handle is not operative to save data to the second record, and

a second record handle and the data element in the second data record.

5. The computerized method of claim 2 wherein the metadata that is obtained comprises a first data record type and a first data element name.

6. In a computer system having a memory and a graphical user interface including a display and an input device for use by a user, a method of displaying and manipulating data in a first data record stored in a database residing in said memory, the method comprising:

retrieving said first data record from said database, said first data record having at least one data element;

displaying a record handle having a state on the display wherein said state may be is any one data record status selected from the group consisting of

a save state that is displayed after the at least one data element has been entered or changed by the user and in which state said record handle is operative to save to the database all the data elements in the displayed first data record,

a close state that is displayed after the at least one data element has been saved by the user and in which state said record handle is operative to remove all the data elements in the first data record from the display, and

a get state that is displayed after the data element is removed from the display and in which state said record handle is operative to refresh all the data elements in the first data record on the display; and

displaying the first data record on the display as one or more data fields;

wherein said record handle is a visual element that represents the first data record and that is operative to control and continuously track said state; and

wherein said record handle is operative to visually change and indicate to a user a current default action that will be activated when the user clicks on the record handle.

7. The method of claim 6 further comprising:

displaying on the display a header comprising one or more names wherein said one or more names is selected from the group consisting of

a type name for the type of the first data record, and

a data element name for the at least one data element.

8. The method of claim 6 wherein the first data record comprises more than one data element and displaying the first data record on the display comprises displaying a display item selected from the group consisting of

a single-valued data field,

a multi-valued data field, and

a reference to another data record.

9. The method of claim 6 wherein the at least one data element comprises character data or binary data.

10. The method of claim 6 further comprising:

displaying on the display a retractable multi-valued data field as a list handle that is operative to display on the display each individual data element comprising the multi-valued data item in a drop down list.

11. The method of claim 6 further comprising:

displaying on the display a reference data field of the first data record that refers to a second data record as a second record handle having a get state that is operative to display on the display the second data elements of the second data record on the same line upon which the record handle having a get state is displayed wherein the record handle of the first data record is not operative to save to the database the second data elements of the second data record; and

displaying a third record handle on the display having a new state that is operative to create or link another referenced data record to the first data record.

12. The method of claim 6 further comprising:

entering a query statement into a user interface element before the retrieving step is executed.

13. The method of claim 12 wherein the query statement is a join statement that is operative to cause a second data record to be displayed on the same line as the first data record, said first displayed data record and said second displayed data record being separated by a symbol and being related in the manner specified in the join statement.

24. A computerized method for displaying and manipulating data that has been retrieved by querying by a user of a non-relational database, said database comprising a data record that comprises a multi-valued attribute and a single-valued attribute, said method comprising:

said user submitting a select command to the database, said select command instructing the database to retrieve information concerning said multi-valued attribute and said single-valued attribute; and

said database returning a name for said multi-valued attribute, each value of said multi-valued attribute, a name for said single-valued attribute and the single value of said single-valued attribute;

wherein said returned data is displayed in accordance with the method of claim 6.

14. A computer-readable medium having computer-executable instructions for performing a method, the method comprising:

retrieving a data record from a database, said record having a plurality of data fields;

displaying a record handle on a display wherein said record handle changes visually to become a save handle that is displayed after one of the data fields has been input or edited by a user and that is operative when selected by a user to save all the data fields in the data record to the database, a close handle that is displayed after the data fields have been saved by the user and that is operative when selected by the user to remove all the data fields from the display, and a get handle that is displayed after the data fields are removed from the display and that is operative when selected by the user to refresh all the data fields on the display; and

displaying the data fields on the display wherein each one of said data fields is selected from the group consisting of

a null data element,

a character or numerical data element,

a list or array of data elements, and

a reference to another data record;

wherein said record handle is a visual element that represents said data record and that is operative to track and control the state of said data record.

15. A computer-readable medium of claim 14 wherein the method further comprises:

at the option of the user, displaying on the display a header line comprising one or more names wherein said one or more names is a type name for the type of the data record, or a field name for the data field.

16. In a computer system having a memory and a graphical user interface including a display and an input device for use by a user, an apparatus for displaying and manipulating data in a first data record stored in a database residing in said memory, the apparatus comprising:

means for retrieving said first data record from said database, said first data record having at least one data element;

means for displaying a record handle having a state on the display wherein said state is any one data record status selected from the group consisting of

a save state that is displayed after the at least one data element has been entered or changed by the user and in which state said record handle is operative to save to the database all the data elements in the displayed first data record,

a close state that is displayed after the at least one data element has been saved by the user and in which state said record handle is operative to remove all the data elements in the first data record from the display, and

a get state that is displayed after the data element is removed from the display and in which state said record handle is operative to refresh all the data elements in the first data record on the display; and

means for displaying the first data record on the display as one or more data fields;

wherein said record handle is a visual element that represents the first data record and that is operative to perform tracking of said state and allow the user to control said state; and

wherein, based on the results of said tracking, said record handle is operative to visually indicate to the user a current default action that will be activated when the user clicks on the record handle.

17. The apparatus of claim 16 further comprising:

means for displaying on the display a header comprising one or more names wherein said one or more names is selected from the group consisting of

a type name for the type of the first data record, and

a data element name for the at least one data element.

18. The apparatus of claim 16 wherein the first data record comprises more than one data element and the means for displaying the first data record on the display comprises means for displaying a display item selected from the group consisting of

a single-valued data field,

a multi-valued data field, and

a reference to another data record.

19. The apparatus of claim 16 wherein the at least one data element comprises character data or binary data.

20. The apparatus of claim 16 further comprising:

means for displaying on the display a retractable multi-valued data field as a list handle that is operative to display on the display each individual data element comprising the multi-valued data item in a drop down list.

21. The apparatus of claim 16 further comprising:

means for displaying on the display a reference data field of the first data record that refers to a second data record as a record handle having a get state that is operative to display on the display the second data elements of the second data record on the same line upon which the record handle having a get state is displayed wherein the record handle of the first data record is not operative to save to the database the second data elements of the second data record.

22. The apparatus of claim 16 further comprising:

means for entering a query statement into a user interface element before the retrieving step is executed.

23. The apparatus of claim 16 wherein the query statement is a join statement that is operative to cause a second data record to be displayed on the same line as the first data record, said first displayed data record and said second displayed data record being separated by a symbol and being related in the manner specified in the join statement.

25. A computerized method for displaying and manipulating data that has been retrieved by querying by a user of a non-relational database, said database comprising a plurality of data records, at least some of which data records comprising a multi-valued attribute, said method comprising:

said user submitting a select command to a database, said select command instructing the database to conditionally retrieve information concerning said plurality of data records, wherein the condition is selected from the group consisting of an any condition that is operative to select any data record wherein at least one of the values of the multi-valued attribute of the selected record is equal to, less than or greater than a given value, and an all condition that is operative to select any data record wherein all of the values of the multi-valued attribute of the selected data record are equal to, less than or greater than a given value; and

said database returning information concerning each data record that meets the selected condition;

wherein said returned information is displayed in accordance with the method of claim 16.

26. The computerized method of claim 25 further comprising:

in the case of the any condition, displaying either the values of all multi-valued attributes in the selected data records or, if the keyword selected is present in the query, only the values of the multi-valued attributes that comply with the condition.

27. A computer-readable medium having computer-executable instructions for performing a method, the method comprising:

displaying at least one data field at a first location on a screen, said at least one data field containing a first data element of a first data record in a first data source; and

displaying a record handle at a second location on the screen, said second location being horizontally in-line with said first location and said record handle being operative by a user to save the first data element to a memory after it has been changed by the user;

wherein the record handle is a visual element that represents the first data record and that is operative to control and continuously track the state of the first data record on the screen and in the first data source; and

wherein the record handle is operative to indicate to a user a current default action that will be activated when the user clicks on the record handle.

28. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

displaying the default action of the record handle on the record handle.

29. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

upon activation of a menu associated with the record handle by a user, revealing record handle actions available to the user.

30. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

displaying a multi-valued data field on the screen, said multi-valued data field comprising attributes, said attributes being displayable as a vertical list with each member of the list being displayed in an editable cell and said attributes being contractable into a single graphical element.

31. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

displaying a header on the screen above the at least one data field, said header comprising a label that describes the at least one data field on the screen below it.

32. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

displaying a scrollable area; and

automatically controlling the display of a plurality of the data fields and a plurality of headers within the scrollable area.

33. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method further comprising:

moving a first plurality of the data fields located lower on the screen than a second plurality of the data fields upward on the screen to take up an intervening space when a third plurality of the data fields located higher on the screen than said first plurality of the data fields is closed and moving a fourth plurality of the data fields located lower on the screen than a fifth plurality of the data fields downward on the screen when a list in said fifth plurality of the data fields located higher on the screen than the fourth plurality of the data fields is expanded.

34. The computer-readable medium of claim 27 having further computer-executable instructions for performing the method, the method of further comprising:

displaying a plurality of multi-valued reference attributes as a plurality of lists.

35. An apparatus for representing data on a display, the apparatus comprising, in combination:

a processing unit and a memory;

means for querying a data source to obtain data comprising a first data record;

means for presenting the first data record on the display as a data field; and

means for presenting on the display a record handle for manipulation by a user of the first data record, said record handle being operative to track the state of said first data record and to change visually to reflect the state of said first data record, and being capable of performing actions on said first data record;

wherein the data field is selected from the group consisting of

a single data element,

a list of data elements, and

a reference to a second data record;

wherein the record handle is a visual element that represents the first data record and that is operative to control and continuously track the state of the first data record on the display and in the data source; and

wherein the record handle is operative to indicate to a user a current default action that will be activated when the user clicks on the record handle.

36. The apparatus of claim 35 further comprising:

means for displaying all of the elements in a hierarchical view of a data schema of the data source at the top level of a tree view, even if some of the elements also occur somewhere else in the hierarchy.

37. The apparatus of claim 35 further comprising:

means for displaying the representations of attributes below the representations of attribute types as well as below the representations of record types on a tree view, by providing that the branches of a tree view extend outward from their sources at different angles to represent different dimensions in the hierarchy.

38. The apparatus of claim 35 further comprising:

means for displaying a foreign key from a relational database having a data schema as an expansible tree element, thereby allowing for navigation of the data schema via the foreign key.

39. The apparatus of claim 38 further comprising:

means for navigating through the data schema to represent a join via links across the foreign key which are capable of automatic query generation, or automatic generation of a part of an SQL or other query that uses the foreign keys in its joins.

40. The apparatus of claim 35 further comprising:

means for presenting the first data record on the display as a first plurality of data fields;

wherein at least one of the first plurality of data fields is selected from the group consisting of

a single data element,

a list of data elements, and

a reference to a second data record.

41. The apparatus of claim 40 wherein the at least one data field is a reference to a second data record that has been expanded horizontally inline within the first record, displacing at least some of the data fields of the first record to the right on the display.

42. The apparatus of 40 further comprising:

means for displaying a plurality of representations of foreign keys relating a first table to a second table in a relational database in a plurality of second data fields in a column in a grid displaying data from the first table, each of the plurality of second data fields comprising a display item selected from the group consisting of a record handle and a list handle, and each of said display items being operative to fetch data from the second table when the display item is selected by the user.