DATABASE SYSTEM AND DISPLAY METHOD ON INFORMATION TERMINAL

• US 20080288462A1
• Filed: 05/16/2008
• Published: 11/20/2008
• Est. Priority Date: 05/16/2007
• Status: Abandoned Application

• Current Assignee: Ripplex Inc. (Casio Computer Company Limited)
• Original Assignee: Ripplex Inc. (Casio Computer Company Limited)
• Inventors: Ota, Tomohisa, NAONO, Norihiko
• Application Number:
  US12/122,254
• Publication Number:
  US 20080288462A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/288 Entity relationship models

Abstract

A database system that includes a database for storing one or a plurality of relationships existing between a plurality of first instances belonging to a first entity and a plurality of second instances belonging to a second entity. A microprocessor is provided for searching the database when one or more of the first instances are selected as a first selected set for determining a first relationship existing between an instance in the first selected set and one of the plurality of the second instances, and when one or more of the second instances are selected as a second selected set for determining a second relationship existing between one of the plurality of first instances and a instance in the second selected set. A display device is included for displaying a first pane and a second pane, a first list which includes the plurality of the first instances in the first pane, a second list which includes the plurality of the second instances in the second pane, and the first relationship or the second relationship in the first pane or the second pane.

Claims

1. A database system comprising:

a database, the database storing one or a plurality of relationships existing between a plurality of first instances belonging to a first entity and a plurality of second instances belonging to a second entity;

a microprocessor, the micro processor searching the database, when one or a plurality of the first instances are selected as a first selected set among the plurality of the first instances, for a first relationship existing between a instance in the first selected set and one of the plurality of the second instances, and the microprocessor searching the database, when one or a plurality of the second instances are selected as a second selected set among the plurality of the second instances, for a second relationship existing between one of the plurality of the first instances and an instance in the second selected set; and

a display device, the display device displaying a first pane and a second pane, the display device displaying a first list which includes the plurality of the first instances in the first pane and displaying a second list which includes the plurality of the second instances in the second pane, and the display device displaying the first relationship or the second relationship in the first pane or the second pane.

2. The database system according to claim 1, wherein the display device highlights, when displaying the first relationship or the second relationship, an instance of the plurality of the first instances or an instance of the plurality of the second instances, the first relationship or the second relationship existing the instance of the plurality of the first instances and the instance of the plurality of the second instances.

3. The database system according to claim 2, wherein the display device highlights the instance of the plurality of the second instances for displaying the first relationship and highlights the instance of the plurality of the first instances for displaying the second relationship.

4. The database system according to claim 3, wherein the display device displays the first list and the second list, the first list or the second list being displayed so that a display region in which a mark can be displayed internally is displayed at a side of each instance in the first list or the second list when displaying the second relationship or the first relationship.

5. The database system according to claim 4, wherein the mark displayed at a side of each instance in the first list is displayed differently depending on the number of instances in the second selected list such that there exists a first relationship between each instance in the first list and one of the instances in the second selected list, and the mark displayed at a side of each instance in the second list is displayed differently depending on the number of instances in the first selected list such that there exists a second relationship between one of the instances in the first selected list and the each instance in the second list.

6. The database system according to claim 4, wherein the display region is a check box.

7. The database system according to claim 2, wherein the instance of the plurality of the first instances included in the first list and the instance of the plurality of the second instances in the second list are displayed by using characters and the instance of the plurality of the first instances or the instance of the plurality of the second instances are highlighted by changing fonts of the characters.

8. The database system according to claim 1, wherein the microprocessor deletes from the database a relationship which existed between an instance of the first selected set and an instance of the one or the plurality of the second instances which is selected after the first relationship has been displayed or between an instance of the one or the plurality of the first instances which is selected and an instance of the second selected set after the second relationship has been displayed.

9. The database system according to claim 1, wherein the microprocessor causes the database to store a relationship between an instance of the first selected set and an instance of the one or the plurality of the second instances which is selected after the first relationship has been displayed or between an instance of the one or the plurality of the first instances which is selected and an instance of the second selected set after the second relationship has been displayed.

10. The database system according to claim 9, wherein the microprocessor causes the database to store the relationship unless the relationship has been stored in the database.

11. The database system according to claim 1, wherein the plurality of the first instances belonging to the first entity form a hierarchical structure and the database stores a relationship between a first instance and a second instance if the database stores another relationship between another first instance lower than the first instance and the second instance.

12. A database system comprising:

a database, the database storing one or a plurality of relationships between a plurality of first instances belonging to a first entity and a plurality of second instances belonging to a second entity;

a microprocessor, the microprocessor searching the database, when a third instance and a fourth instance are selected from the plurality of the first instances, for one or a plurality of fifth instances in the plurality of the second instances wherein one or a plurality of first relationships exist between the one or the plurality of the fifth instances and the third instance or between the one or the plurality of the fifth instances and the fourth instance at a first condition, and searching the database for one or a plurality of sixth instances in the plurality of the second instances wherein one or a plurality of second relationships exist between the one or the plurality of the sixth instances and the third instance and/or between the one or the plurality of the sixth instances and the fourth instance at a second condition; and

,

a display device for displaying a first pane and a second pane, the display device displaying a first list which includes the plurality of the first instances in the first pane and displaying a second list which includes the plurality of the second instances in the second pane, the display device displaying the one or the plurality of the first relationships, which exists between the one or the plurality of the fifth instances and the third instance or between the one or the plurality of the fifth instances and the fourth instance, in a first mode, and the display device displaying the one or the plurality of the second relationships, which exists between the one or the plurality of the sixth instances and the third instance and/or between the one or the plurality of the sixth instances and the fourth instance, in a second mode.

13. The database system according to claim 12, wherein the one or the plurality of the first relationships exist both between the one or the plurality of the fifth instances and the third instance and between the one or the plurality of the fifth instances and the fourth instance, and wherein the one or the plurality of the second relationships exist either between the one or the plurality of the fifth instances and the third instance or between the one or the plurality of the fifth instances and the fourth instance.

14. A display method in an information terminal having a database storing one or a plurality of relationships existing between a plurality of first instances belonging to a first entity and a plurality of second instances belonging to a second entity and a display device displaying a first pane and a second pane, the display device displaying a first list which includes the plurality of the first instances in the first pane and displaying a second list which includes the plurality of the second instances in the second pane, the display method comprising:

searching the database, when one or a plurality of the first instances are selected as a first selected set among the plurality of the first instances, for a first relationship existing between an instance in the first selected set and one of the plurality of the second instances and displaying the first relationship on the display device; and

searching the database, when one or a plurality of the second instances are selected as a second selected set among the plurality of the second instances, for a second relationship existing between one of the plurality of the first instances and an instance in the second selected set and displaying the second relationship on the display device.

15. The display method of an information terminal according to claim 14, wherein the first relationship or the second relationship is displayed by highlighting the one of the plurality of the second instances or the one of the plurality of the first instances wherein the first relationship or the second relationship exists between the one of the plurality of the second instances and the one of the plurality of the first instances.

16. The display method of an information terminal according to claim 15, wherein the instance of the plurality of the second instances are highlighted for displaying the first relationship and the instance of the plurality of the first instances are highlighted for displaying the second relationship.

17. The display method of an information terminal according to claim 16, wherein the first list or the second list is displayed so that a display region in which a mark can be displayed internally is displayed at a side of each instance in the first list or the second list when displaying the second relationship or the first relationship.

18. The display method of an information terminal according to claim 17, wherein the mark displayed at a side of each instance in the first list is displayed differently depending on the number of instances in the second selected list such that there exists a first relationship between each instance in the first list and one of the instances in the second selected list, and the mark displayed at a side of each instance in the second list is displayed differently depending on the number of instances in the first selected list such that there exists a second relationship between one of the instances in the first selected list and each instance in the second list.

19. The display method of an information terminal according to claim 17, wherein the display region is a check box.

20. The display method of an information terminal according to claim 15, wherein the instance of the plurality of the first instances included in the first list and the instance of the plurality of the second instances in the second list are displayed by using characters and the instance of the plurality of the first instances or the instance of the plurality of the second instances are highlighted by changing fonts of the characters.