Method of providing tree-structured views of data

• US 20060277203A1
• Filed: 08/27/2004
• Published: 12/07/2006
• Est. Priority Date: 09/09/2003
• Status: Abandoned Application

• Current Assignee: Koninklijke Philips Electronics N.V. (Koninklijke Philips N.V.)
• Original Assignee: Koninklijke Philips Electronics N.V. (Koninklijke Philips N.V.)
• Inventors: Uittenbogaard, Frank
• Application Number:
  US10/570,433
• Publication Number:
  US 20060277203A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: G06F 16/24566 Recursive queries
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

This invention relates to a method of enabling a user of a database to define a tree view representation of data items in a database. The data items in the database relate to object types and attributes. An attribute can be a basic attribute or a link attribute, where basic attributes contain general information regarding the object type to which it is related and wherein the concept of link attributes is provided by this invention. A link attribute is relating one object type to one or more other object types and provides the possibility of enabling a user to define a required representation of the data items in the database in a tree structure. The invention enables a user to choose the root of the tree structure and to define recursive database views.

Claims

1. A method of providing a tree structured view on data items in a data base, which data items each are related to one or more object types, where each object type has any number (including zero) of attributes, and the method comprises

representing at least one relationship between any object type and other object types related thereto in the data base as a link attribute, which link attribute is expandable, i.e. is related to an object type having one or more further attributes;

presenting an object type and its attribute(s);

providing the user with the possibility to expand any link attribute, so that one or more further attribute(s) of the object type related to the expanded link attribute(s) is (are) presented;

providing the user with the possibility to define a view of data on the basis of the presented attribute(s); and

displaying the data items related to attribute(s) in the user defined view of data.

2. Method according to claim 1, which method further comprises the step of

providing the user with the possibility to select an object type to be presented as the root of the tree structured view.

3. A method according to claim 1, which method further comprises the step of:

displaying the attributes of an object type in an indented view.

4. A method according to claim 1, wherein the data items related to the attribute(s) are presented in a first part of a screen and wherein the attribute(s) is (are) presented to the user on a second part of the screen.

5. A method according to claim 1, wherein the method is executed by use of a database model of the database.

6. A method according to claim 1, wherein the method is performed in a personal computer, a personal digital assistant, a set-top box or in a television.

7. A method according to claim 1, wherein the method further comprises the step of providing the user with the possibility of defining a recursive view by marking a cyclic path through one or more link attributes.

8. An apparatus for performing the method of claim 1.

9. A system for performing the method of any claim 1.

10. (canceled)