Hierarchical database apparatus, components selection method in hierarchical database, and components selection program

• US 20050203869A1
• Filed: 03/02/2005
• Published: 09/15/2005
• Est. Priority Date: 03/02/2004
• Status: Abandoned Application

• Current Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Original Assignee: Kabushiki Kaisha Toshiba (Toshiba Corporation)
• Inventors: Murayama, Hiroshi, Minamino, Noriko
• Application Number:
  US11/068,760
• Publication Number:
  US 20050203869A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

A database apparatus stores a first contents table which includes first components including first contents data rows, and a second contents table which includes second components including second contents data rows. The first and second contents data rows each have a selection reference relationship between the first and second contents tables, and a selection reference condition is described using a selection reference type property. A selection reference processor is configured to query the second contents table under the selection reference condition to find candidates of second contents data rows. The candidates are referenced from a selected first contents data row according to the selection reference relationship. At least one second contents data row designated in the candidates displayed on the screen is selected. A combination device is configured to generate a combined contents table corresponding to a combined-type product, by combining the first and second contents data rows.

Claims

1. A database apparatus comprising:

a table storage to store a first contents table which includes a plurality of first components which includes a plurality of first contents data rows, and a second contents table which includes a plurality of second components which includes a plurality of second contents data rows, wherein the first contents data rows and the second contents data rows each have a selection reference relationship between the first contents table and the second contents table, and a selection reference condition is described using a selection reference type property;

a display device to display the first contents table on a screen;

a designation device to designate a first contents data row in the first contents table displayed on the screen;

a first selection device configured to select the designated first contents data row;

a selection reference processor configured to query the second contents table under the selection reference condition to find candidates of second contents data rows, wherein the candidates are referenced from the selected first contents data row according to the selection reference relationship;

a second selection device configured to select at least one second contents data row designated by the designation device in the candidates displayed on the screen; and

a combination device configured to generate a combined contents table corresponding to a combined-type product, by combining the first and second contents data rows.

2. An apparatus according to claim 1, wherein the table storage stores the first contents table and the second contents table in association with an identical class in a format of hierarchical database in which a subclass inherits properties of a superclass.

3. An apparatus according to claim 1, further comprising a selection path storage to store a selection path having a tree structure or an acyclic structure, used for guiding the selection reference to a user.

4. An apparatus according to claim 1, wherein:

the first contents table includes a first divided property table, and the first contents data rows represents values of property sets specific to the first components, and wherein;

the second contents table includes a second divided property table, and the second contents data rows represents values of property sets specific to the second components.

5. An apparatus according to claim 1, wherein external standard codes including BSU codes are used to identify classes and properties of the first and second components.

6. An apparatus according to claim 4, further comprising:

an import mechanism configured to import properties using CaseOf from other classes to one of the first and second divided property tables, in addition to properties inherit by a parent-child inheritance relationship.

7. An apparatus according to claim 4, wherein a set of properties in one of the first and second divided property tables are defined using an extended classification label having additional information for grouping the set of properties.

8. An apparatus according to claim 1, wherein the combination device is configured to execute inter-table JOIN operation thereby to combine property values of the first and second contents data rows.

9. An apparatus according to claim 1, further comprising a typical property mechanism for causing the selection reference type property in the first contents table to inherit the selection reference condition from a superclass.

10. A components selection method in hierarchical database comprising:

storing a first contents table which includes a plurality of first components which includes a plurality of first contents data rows, and a second contents table which includes a plurality of second components which includes a plurality of second contents data rows, wherein the first contents data rows and the second contents data rows each have a selection reference relationship between the first contents table and the second contents table, and a selection reference condition is described using a selection reference type property;

displaying the first contents table on a screen;

designating a first contents data row in the first contents table displayed on the screen;

selecting the designated first contents data row;

querying the second contents table under the selection reference condition to find candidates of second contents data rows, wherein the candidates are referenced from the selected first contents data row according to the selection reference relationship;

selecting at least one second contents data row in the candidates displayed on the screen; and

generating a combined contents table corresponding to a combined-type product, by combining the first and second contents data rows.

11. A method according to claim 10, wherein the first contents table and the second contents table are stored in association with an identical class in a format of hierarchical database in which a subclass inherits properties of a superclass.

12. A method according to claim 10, further comprising storing a selection path having a tree structure or an acyclic structure;

and

guiding the selection reference to a user according to the selection path.

13. A method according to claim 10, wherein:

the first contents table includes a first divided property table, and the first contents data rows represents values of property sets specific to the first components, and wherein;

the second contents table includes a second divided property table, and the second contents data rows represents values of property sets specific to the second components.

14. A method according to claim 10, further comprising using external standard codes including BSU codes to identify classes and properties of the first and second components.

15. A method according to claim 13, further comprising:

importing properties using CaseOf from other classes to one of the first and second divided property tables, in addition to properties inherit by a parent-child inheritance relationship.

16. A method according to claim 13, wherein a set of properties in one of the first and second divided property tables are defined using an extended classification label having additional information for grouping the set of properties.

17. A method according to claim 10, wherein the combining comprises:

executing inter-table JOIN operation thereby to combine property values of the first and second contents data rows.

18. A method according to claim 10, further comprising inheriting the selection reference condition to the selection reference type property in the first contents table from a superclass.

19. A components selection program stored in a computer readable medium, the program comprising:

means for instructing a computer to store a first contents table which includes a plurality of first components which includes a plurality of first contents data rows, and a second contents table which includes a plurality of second components which includes a plurality of second contents data rows, wherein the first contents data rows and the second contents data rows each have a selection reference relationship between the first contents table and the second contents table, and a selection reference condition is described using a selection reference type property;

means for instructing the computer to display the first contents table on a screen;

means for instructing the computer to designate a first contents data row in the first contents table displayed on the screen;

means for instructing the computer to select the designated first contents data row;

means for instructing the computer to query the second contents table under the selection reference condition to find candidates of second contents data rows, wherein the candidates are referenced from the selected first contents data row according to the selection reference relationship;

means for instructing the computer to select at least one second contents data row in the candidates displayed on the screen; and

means for instructing the computer to generate a combined contents table corresponding to a combined- type product, by combining the first and second contents data rows.