DATA-DRIVEN DATABASE PROCESSOR

• US 20110010402A1
• Filed: 12/24/2008
• Published: 01/13/2011
• Est. Priority Date: 01/11/2008
• Status: Active Grant

• Current Assignee: RSUN Corporation
• Original Assignee: RSUN Corporation
• Inventors: Takeuchi, Ken, Yodo, Takahiro, Takeuchi, Yuji
• Granted Patent: US 8,316,063 B2
• Time in Patent Office: Days
• US Class Current: 707/812
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Provided is a technique for a data-driven database which frees a user from having to be conscious of a sequence in which instructions of a program for accessing a database are described, an interrelation of data items, and the like, and from having to describe redundant instructions. A data-driven database processor includes: schema definition storage means 2 for storing a schema definition of a database 24; derived definition storage means 3 for storing a derived definition describing a cause-and-effect relationship that exists when a value of a given data item is derived from a value of another data item; derived definition processing means 26 for generating a trigger program 27 that makes a chain of changes to values of data items based on the cause-and-effect relationship described in the derived definition; and a database management system 23 for executing the trigger program 27 when a change is made to the other data item that affects the value of the given data item.

Claims

1. A data-driven database processor comprising:

schema definition storage means for storing a schema definition of a database;

derived definition storage means for storing a derived definition describing a cause-and-effect relationship between a data item in the schema definition and another data item for deriving the data item;

derived definition processing means for generating a trigger program that makes a chain of changes to data items based on the derived definition; and

a database management system for executing the trigger program when a change is made to another data item that affects the data item.

2. The data-driven database processor according to claim 1, wherein

the derived definition processing means comprises:

a judging unit for judging, based on the cause-and-effect relationship, a sequence in which the derived definition is executed; and

a generating unit for generating the trigger program according to the sequence judged by the judging means.

3. The data-driven database processor according to claim 2, wherein the judging unit judges an execution sequence so that a derived definition, capable of deriving a data item solely using an already-determined data item, is preferentially executed.

4. The data-driven database processor according to claim 1, comprising database access program storage means for storing a database access program which makes a change to another data item that affects the data item and which is executable by the database management system.

5. A data-driven database processing method, wherein a computer executes:

processing of storing a schema definition of a database;

processing of storing a derived definition describing a cause-and-effect relationship between a data item in the schema definition and another data item for deriving the data item; and

processing of making a chain of changes to the data items based on the derived definition when a change is made to the other data item that affects the data item.

6. The data-driven database processing method according to claim 5, wherein

the processing of making a chain of changes comprises:

processing of generating, based on the derived definition, a trigger program that makes a chain of changes to the data items; and

processing of executing the trigger program when a change is made to another data item that affects the data item.

7. The data-driven database processing method according to claim 6, wherein

the computer executes:

processing of storing a database access program that makes a chain of changes to the other data item that affects the data item; and

processing of executing the database access program and the trigger program.

8. A computer-executable data-driven database processing program that causes a computer to execute:

processing of storing a schema definition of a database;

processing of storing a derived definition describing a cause-and-effect relationship between a data item in the schema definition and another data item for deriving the data item; and

processing of making a chain of changes to the data items based on the derived definition when a change is made to the other data item that affects the given data item.

9. The data-driven database processing program according to claim 8, wherein

the processing of making a chain of changes comprises:

processing of generating, based on the derived definition, a trigger program that makes a chain of changes to the data items; and

processing of executing the trigger program when a change is made to another data item that affects the data item.

10. The data-driven database processing program according to claim 9, wherein

the program causes the computer to execute:

processing of storing a database access program that makes a chain of changes to the other data item that affects the data item; and

processing of executing the database access program and the trigger program.