JPH10111820A - Database device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily and surely cope with a change even when it occurs in a database part in the database device for operating a database. SOLUTION: The device is provided with a database part 1 executing an operation in accordance with the operation instruction of a prescribed language when it is received and plural processing means 3a, 3b and 3c... issuing a signal with a previously set form as an operation instruction to the database part 1 and also one access managing means 4 is provided between the processing means 3a, 3b and 3c and the database part 1. When the plural processing means 3a, 3b and 3c issue the signal of the previously set form, the one access managing means 4 generates the operation instruction of the prescribed language based on the signal so as to transmit it to the database part 1.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database device for managing a database, which is a set of a plurality of data, and operating the database efficiently.

[0002]

2. Description of the Related Art A database system is a database management system (DBMS) for operating a database.
It consists of a computer system having software such as DataBase Management System) and hardware for operating the same. It stores and accumulates a data group having a systematic data structure. It manages and executes searches and the like.

Conventionally, as such a database device, for example, as shown in FIG. 3, there is a device provided with a database unit 1 and a management unit 10. The management unit 10
May be provided on one terminal device (such as a personal computer) or may be provided separately on a plurality of terminal devices connected via a network. .

[0004] The database unit 1 is composed of a storage device such as a magnetic disk device, and stores and stores a data group having a systematic data structure. However, when the database unit 1 receives an operation instruction described in a predetermined language (for example, an SQL sentence), the database unit 1 according to the operation instruction
Data processing operations such as new storage, deletion, search output, or update of data are performed. The management unit 10 includes a CPU (Central Processing Unit), RA
M (Random Access Memory), ROM (Read Only Memo)
ry), etc., and the database section 1
A predetermined data processing (for example, an arithmetic processing) is performed using the data in the above. However, the management unit 10 includes a plurality of processing units 11a, 11b, 11c,... In order to enable execution of a plurality of types of data processing.

[0005] Each of the processing means 11a, 11b, 11c ...
It is realized by executing a processing program or the like for performing data processing, and is a minimum unit of a function for performing data processing. These processing means 11a, 11b, 11
..,... independently perform different types of data processing using data in the database unit 1. Therefore, each of the processing units 11a, 11b, 11c,... Fetches data necessary for data processing from the database unit 1 and the data unit 1 after data processing.
Access means 12a, 12b, respectively for accessing the database unit 1 for storing in the
12c...

[0006] Each access means 12a, 12b, 12c ...
Are realized by executing a part of the processing programs and the like in each of the processing means 11a, 11b, 11c...
In accordance with an instruction from each of the processing units 11a, 11b, 11c,..., An operation instruction described in an SQL statement or the like is generated and transmitted to the database unit 1. In response to the operation command from the access means 12a, 12b, 12c,..., The database unit 1 performs data processing operation, that is, new storage, deletion, search output, or update of data.

[0007]

In the above-mentioned conventional database apparatus, a plurality of processing means 11a, 1
1b, 11c,... Perform different types of data processing. Therefore, each access means 12
a, 12b, 12c,...
The operation instruction is generated by a method most suitable for the data processing function (program form) of b, 11c. That is, in this database device, access to the database unit 1 is performed by each of the access units 12a and 12a.
Each of b, 12c,... is performed by a different method.

Therefore, in this database device,
For example, when it is necessary to change a part of the operation command understood by the database unit 1 due to a system change or a data configuration change (for example, version upgrade) in the database unit 1, each access unit 12a, 12b,
12c..., The corresponding parts (corresponding programs and the like) must be corrected. Therefore, in this case, a lot of trouble and time are required, and furthermore, there is a high possibility that a bug or the like is included when the correction is made. As a result, easiness and certainty are lacking. .

Further, in this database device, for example, when a new processing means is to be added to the management unit 10, the developer (additional worker) of the new processing means is required
It is necessary to understand a method of creating an operation command such as a QL statement, that is, a complicated database access method. If this database access method is not understood, the new processing means cannot correctly access the database unit 1. Therefore, this database device cannot easily and flexibly cope with a change in the device configuration or the like, and lacks versatility of the device.

Therefore, the present invention provides, for example, a system change or data structure change in the database unit 1 or a case where a new processing means is added to the structure.
It is an object of the present invention to provide a database device that can easily and surely cope with a case where a change occurs in the database unit 1.

[0011]

SUMMARY OF THE INVENTION The present invention is directed to a database device devised to achieve the above object, which stores and accumulates data and, when receiving an operation instruction written in a predetermined language, executes the operation. A database unit that performs a data processing operation according to an instruction, and a plurality of processing units that provide an instruction to cause the database unit to perform the data processing operation, wherein the plurality of processing units are:
As an instruction to cause the database unit to perform a data processing operation, a signal in a preset form different from the predetermined language is issued. When one access management unit receives a signal in a predetermined form from the plurality of processing units, the one access management unit converts the signal into an operation instruction described in the predetermined language. , And sends the operation command to the database unit.

According to the database apparatus having the above-described configuration, when the database section is to perform a data processing operation such as new storage, deletion, retrieval output, or update of data, a plurality of processing means perform the processing operation. A signal in a preset form is issued as an instruction to make the setting.
Upon receiving this signal, one access management means converts this into an operation command described in a predetermined language and sends the operation command to the database unit. Then, the database unit performs a data processing operation in accordance with an operation command from one access management unit. That is, the plurality of processing units cause the database unit to perform the data processing operation via one access management unit. Therefore, in this database apparatus, for example, even when it is necessary to change a part of the operation command for the database unit, only one access management means needs to be corrected. Further, each of the plurality of processing means may transmit a signal in a preset form to the access management means,
Without generating operation instructions written in a predetermined language,
The data processing operation can be performed by the database unit.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A database device according to the present invention will be described below with reference to the drawings. However, here, a database device for managing a relational (relational) database, that is, an RDBMS (Relati
A case in which the present invention is applied to a database device including software such as an onal DataBase Management System) and hardware for operating the software will be described. The database device according to the present embodiment includes a database unit 1 and a management unit 2, as shown in FIG. Note that the same components as those of the conventional database device (see FIG. 3) are assigned the same reference numerals and description thereof will be omitted.

The management unit 2 is provided on one terminal device or on a plurality of terminal devices connected via a network, and performs predetermined data processing using data in the database unit 1. is there. For this purpose, the management unit 2 includes a plurality of processing units 3a, 3b, 3c,.
One access management unit 4 is provided.

Each of the plurality of processing means 3a, 3b, 3c... Independently performs different types of data processing using data in the database unit 1. for that reason,
Each of these processing means 3a, 3b, 3c... Emits a signal in a preset form as an instruction for causing the database unit 1 to perform a processing operation such as new storage, deletion, search output, or update of data. It has become.

The signal of the preset form includes:
“PtCreate ()”, “PtDelete ()”, “PtGet ()”,
There are four types of “PtSet ()”. “PtCreate ()” is a signal for instructing a processing operation for newly storing data in the database unit 1, more specifically, a process of adding one row of a record to a certain table in the database unit 1. “PtDelete ()” is a signal for instructing a processing operation for deleting data in the database unit 1, more specifically, a processing operation for deleting one row of a record from a certain table in the database unit 1. “PtGet ()” is a signal for instructing a processing operation of retrieving and outputting data from the database unit 1, more specifically, a processing operation of acquiring column information of a corresponding record from a certain table in the database unit 1. “PtSet ()” is a signal for instructing a processing operation for updating data in the database unit 1, more specifically, a processing operation for updating column information for a record of a certain table in the database unit 1. In each of these signals, a parameter for specifying the data to be processed is entered in the “()” part.

On the other hand, the access management means 4 is provided between the database unit 1 and the processing means 3a, 3b, 3c... Is realized. That is, the access management unit 4 includes the processing units 3a, 3
b, 3c..., ie, “PtCreate ()”,
Upon receiving “PtDelete ()”, “PtGet ()”, and “PtSet ()”, an operation instruction described in a predetermined language such as an SQL statement is generated based on these. The access management means 4 sends the operation command obtained by the conversion to the database unit 1.

Next, an example of a processing operation in the database device configured as described above will be described with reference to a conceptual diagram of FIG. However, here, the processing operation when newly storing (registering) data in the database unit 1 will be described as an example. The database unit 1 includes
It is assumed that station data (for example, a station name, a station number, and the like) relating to a communication station (for example, a communication terminal device) is stored and stored in a table format.

When registering data in the database unit 1, a user of the database unit first operates with an OS (Operating) which is a higher-level program of the management unit 2.
GUI (Graphical User I)
nterface) 5 to input station data to be registered. When the station data is input on the GUI 5, the processing means 3a having the function most suitable for registering the station data,
In 3b, 3c,..., The input station data is received from the GUI 5 (Step 101; hereinafter, the step is abbreviated as S).

When the station data is received from the GUI 5, the processing means 3a, 3b, 3c... Use the contents of the received station data (eg, station name, station number, etc.) as parameters.
A signal for newly storing the station data in the database unit 1 is issued to the access management unit 4 (S10).
2). For example, "INST When receiving the station data such as ID (ID number for station data) = 3, station name = C, station number = 12, the processing means 3a, 3b, 3c,... , "PtCrea
te (INST ID = 3, station name = C, station number = 12). "

[Pt] issued by the processing means 3a, 3b, 3c...
Create (INST ID = 3, station name = C, station number = 12), the access management means 4 generates an operation command described in an SQL statement or the like based on the signal,
The generated operation command is sent to the database unit 1 (S1).
03). Upon receiving the operation command from the access management means 4, the database unit 1 stores "INST" in a corresponding table in the database unit 1 according to the operation command. ID
= 3, station name = C, station number = 12 ”and stored (S104).

As described above, in this database device, the station data input on the GUI 5 is stored in the database unit 1.
Register with. Also, in this database device, data deletion in the database unit 1 is performed in the same manner.
Processing operations such as search output or update are performed.

As described above, according to the database device of the present embodiment, each of the plurality of processing means 3a, 3b, 3c,... It is made to be performed. That is, the access management means 4 collectively manages access to the database unit 1 from each of the processing means 3a, 3b, 3c... Therefore, in this database device, even if it is necessary to change a part of the operation command understood by the database unit 1 due to a system change or a data configuration change in the database unit 1, for example, Correction need only be made for four. Therefore, unlike the related art, a lot of trouble and time are not required, and the possibility of incorporating a defect such as a bug at the time of correction can be reduced. In other words, this database device can easily and surely cope with a change in the database unit 1 even when it occurs.

In the database device of the present embodiment, the processing means 3a, 3b, 3c...
, PtDelete (), PtGet (), PtSet ()
When a signal in a predetermined form is received, the access management means 4 generates an operation command described in a predetermined language such as an SQL statement based on the signal. That is, each of the processing units 3a, 3b, 3c,... Can issue an access management unit 4 a signal in a preset form to instruct access to the database unit 1. Therefore, in this database device,
For example, even when a new processing unit is to be added to the management unit 4, if the new processing unit emits a signal in a preset form, the database unit 1 can be correctly accessed. Become like In other words, in this database device, even if the device configuration is changed,
Since this can be dealt with easily and flexibly, the versatility of the device can be secured as compared with the conventional device.

In this embodiment, a case has been described where the present invention is applied to a database device for managing a relational database. However, the present invention is not limited to this. The present invention is also applicable to a database device for managing a hierarchical database. Furthermore, the present invention can be applied to a database device for managing an object-oriented database. In this case, if one class (database class) is provided as the access management means 4,
The same effect as described above can be obtained.

[0026]

As described above, in the database device of the present invention, when a plurality of processing means emits a signal in a predetermined form, the access management means 4 between these processing means and the database unit. However, the data processing operation is performed by the database unit. Therefore, in this database device, even if a change occurs in the database unit, for example, only the access management means needs to be modified, so that it does not require much labor and time unlike the conventional device, and Thus, the possibility of occurrence of a failure can be reduced, and as a result, it is possible to easily and surely respond to the change in the database unit. Furthermore, the processing means can correctly access the database unit 1 by issuing a signal of a preset form to the access management means, so that, for example, even if the apparatus configuration is changed, it can be easily and flexibly dealt with. Will be able to

[Brief description of the drawings]

FIG. 1 is a block diagram showing a functional configuration of an example of an embodiment of a database device according to the present invention.

FIG. 2 is a conceptual diagram showing a procedure of an operation example when newly storing (registering) data in a database unit in the database device of FIG. 1;

FIG. 3 is a block diagram showing a functional configuration of an example of a conventional database device.

[Explanation of symbols]

 1 database section 3a, 3b, 3c processing means 4 access management means

Claims (1)

[Claims] 1. A database unit for storing and accumulating data and receiving an operation instruction described in a predetermined language, performing a data processing operation in accordance with the operation instruction, and causing the database unit to perform the data processing operation. A plurality of processing means for giving an instruction for performing the data processing operation, wherein the plurality of processing means is an instruction for causing the database unit to perform a data processing operation. Between the processing means and the database unit, one access management means is provided, and the one access management means is provided in advance by the plurality of processing means. Upon receiving the signal in the set form, it generates an operation command described in the predetermined language based on the signal,
A database device for transmitting the operation command to the database unit.