Program for displaying and operating table

• US 8,271,867 B2
• Filed: 06/18/2008
• Issued: 09/18/2012
• Est. Priority Date: 06/18/2008
• Status: Active Grant

• Current Assignee: Kunio Kamimura
• Original Assignee: Kunio Kamimura
• Inventors: Kamimura, Kunio
• Primary Examiner(s): Ries, Laurie
• Application Number:
  US12/996,382
• Publication Number:
  US 20110093770A1
• Time in Patent Office: 1,553 Days
• Field of Search: 715/227, 707/626, 707/627
• US Class Current: 715/227
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

In columns of a table, a list of labels of records of a table referenced by the table as a relation is displayed. A correlational display function of the record of interest enables information on a table involving an operator to be grasped in one table. When a record of the table of the reference origin is selected, a record referenced by the selected record is highlighted. Conversely, when a record of the reference destination is selected, the record of the reference origin referencing the selected record is highlighted and the related record is displayed in the same line or in the neighborhood. The reference, addition or change of a record of the reference destination can be intuitively performed around the table of the reference origin. A new record can be added to the reference destination during the addition of a record to the table of the reference origin. Information on the table of the reference destination is allowed to be grasped and managed with only an operation focusing on one table.

Claims

1. A computer operable method of displaying a relational database, comprising,

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of a record of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, by ignoring a relation to a record of said displayed-table.

4. The computer operable method according to claim 1, claim 2 or claim 3, further comprising:

(3) a process including;

a step of identifying a selected record (hereinafter “

selected-record”

) of said displayed-table,

a step of finding a record (hereinafter “

referred-record”

) of inserted-table that is referred from said selected-record, and

a step to emphasize said referred-record, or to place said selected-record and said referred-record on a same line or neighborhood.

5. The computer operable method according to claim 1, claim 2 or claim 3, further comprising:

(3) a process including;

a step of identifying a record (hereinafter “

selected-record”

) of said inserted-table,

a step of finding a record (hereinafter “

referring-record”

) of displayed-table that is referring to said selected-record, and

a step to emphasize said referring-record, or to place said selected-record and referring-record on a same line or neighborhood.

2. A computer operable method of displaying a relational database, comprising,

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of a record of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, by ignoring a rule that a record (hereinafter “

referenced-record”

) of the inserted-table is placed at the same line of a record (hereinafter “

referencing-record”

) of said displayed-table, here said referencing-record refers said referenced-record.

3. A computer operable method of displaying a relational database, comprising,

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of a record of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, here, a record of said inserted-table is shown as at most one row of said inserted-column, even if said record is referred by plural records of said displayed-table.

6. A computer-readable non-transitory medium containing a program for displaying a relational database, performing processes comprising:

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of records of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, by ignoring relations to records of said displayed-table.

9. The computer-readable non-transitory medium performing processes, according to claim 6, claim 7 or claim 8, further comprising:

(3) a process including;

a step of identifying a selected record (hereinafter “

selected-record”

) of said displayed-table,

a step of finding a record (hereinafter “

referred-record”

) of inserted-table that is referred from said selected-record, and

a step to emphasize said referred-record, or to place said selected-record and said referred-record on a same line or neighborhood.

10. The computer-readable non-transitory medium performing processes, according to claim 6, claim 7 or claim 8, further comprising:

(3) a process including;

a step of identifying a record (hereinafter “

selected-record”

) of said inserted-table,

a step of finding a record (hereinafter “

referring-record”

) of displayed-table that is referring to said selected-record, and

a step to emphasize said referring-record, or to place said selected-record and referring-record on a same line or neighborhood.

7. A computer-readable non-transitory medium containing a program for displaying a relational database, performing processes comprising:

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of records of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, by ignoring a rule that a record (hereinafter “

referenced-record”

) of the inserted-table is placed at the same line of a record (hereinafter “

referencing-record”

) of the displayed-table, here said referencing-record refers said referenced-record.

8. A computer-readable non-transitory medium containing a program for displaying a relational database, performing processes comprising:

(1) a process of displaying a table (hereinafter “

displayed-table”

) of said database, in a table style,

(2) a process of displaying a list of records of a table (hereinafter “

inserted-table”

) as a column (hereinafter “

inserted-column”

) inserted to said displayed-table, here, a record of said inserted-table is shown as at most one row of said inserted-column, even if said record is referred by plural records of said displayed-table.