JPH0275067A - Ndb access system by read/write interface - Google Patents

Abstract

PURPOSE:To enable even a person who has no technical knowledge of a data base operating language to easily have an access to a network data base by preparing a file data base correspondence definition which defines previously the information that has an access to the network data base in a file form. CONSTITUTION:The file data correspondence definition 3 is prepared to previously define the information having an access to a network data base 6 in a file form. Then an application program 1 produces a read/write instruction to the base 6 and therefore this instruction is converted into a data base operating instruction by reference to the definition 3. Thus a constitution is attained for reception of the corresponding data. As a result, even a person who has no technical knowledge of a data base operating language can easily have an access to the base 6 having a complicated structure via a program described in a COBOL language, etc. Then the desired data can be taken out or written.

Description

[Detailed Description of the Invention] [Summary] Regarding the NDB access force formula for accessing the NDB using a read/write interface, a file DB correspondence definition is created in advance, and this is executed in response to the issuance of a read/write 1-instruction. The purpose of the NDB is to refer to it, convert it into the corresponding y-database operating language, publish it, and access it, making NDB access possible even for people without knowledge of NDB.
The information to access B is defined in the file format in the file DB correspondence definition, and in response to the issuance of read/write commands from the application block, this file is predefined in the corresponding file of this file DI3 correspondence definition. Based on the information, it is converted into an NDB database search command in a different language and issued to the NDB, and in the case of a read command, the information returned from the NDB in response to this issuance is assembled into record 1' and applied. The present invention includes an NDB/file record conversion mechanism to be passed to a program, and is configured so that an application program can read/write an NDB that is accessed using a description in a different language using a read/write command.

[Industrial application field]

The present invention provides N
This relates to an NDB access method for accessing a DB.

[Problems to be solved by conventional technology and invention] Conventional C
OB OL program NDB (Netwo
rk Data Ba5e) access processing is performed using the database manipulation language (DML:
Data Ba5e Manipulation La
DM+, COB
Programs were created as part of the OL language.

However, the structure of the NDB is complex, and the [)ML is very different from cosob, ;words, so even if you only want to refer to a small amount of data in the NDB,
There is a problem in that it requires all specialized knowledge regarding NDB, and the number of people who can process NDB is limited to a small number of people, which hinders program development.

In the present invention, a file DB correspondence definition is created in advance,
In response to the issuance of a read/write command, the command is referred to, converted into the corresponding database operation language, issued, and accessed, and the purpose is to enable even people without knowledge of NDB to access NDB.

Means to solve problem C] FIG. 1 shows a basic configuration diagram of the present invention.

In FIG. 1(a), in response to the issuance of a read/write command from the application program l, the NDB/file record conversion mechanism 2 performs a Then, convert it into NDB database operation instructions, which are in a different language, and write them into NDB.
6, and in the case of a read command, the information returned from the NDB 6 in response to this issuance is assembled into a record and passed to the application program 1.

File DB correspondence definition 3 is a file format in which information for accessing NDB 6 is defined in advance (see Figure 1 (
b) See file structure).

NDB (network database) 6 is a database that stores data.

[Effect]

As shown in FIG. 1, in response to the issuance of a read/write command from an application program 1, an NDB/file record conversion mechanism 2 is defined in advance in a corresponding file of a file DB correspondence definition 3. Based on the information, it is converted into a database operation command and issued, and in the case of a read command, the information returned from the NDB 6 in response to the issuance of this command is assembled into a record and passed to the application program 1. .

Therefore, by creating a file DB correspondence definition 3 that predefines information for accessing the NDB 6 in a file format, the application program 1 can issue read/write commands to receive and receive the corresponding data from the NDB 6. Alternatively, data can be written to NDB6. As a result, even people without specialized knowledge of database manipulation languages can easily access an NDB with a complex structure from a program written in the C0BOL language or the like.

〔Example〕

Next, the configuration and operation of one embodiment of the present invention will be explained using FIGS. 1 to 3. 1) 1! will be explained in detail next.

In FIG. 1 (a), file DB correspondence definition 3 is N
Information to be read/written from a logical structure based on the DB 6 record type and Sera I type is defined in a file format.

A I M (Advanced Info+mati
on Ma'nager) / Nr) B4 is for accessing NDB 6 online.

5 defines the DD/D and schema in A+M/NDB4.

FIG. 1(b) shows an example of file DB correspondence definition. Here, the record type is the type of the record group that constitutes the NDB 6, and for example, record type A represents a record type called an owner record that is related by a hierarchical relationship, and record type I3 represents a record type that is related by a hierarchical relationship. Represents a record type called a related member record. The set type is owner record and
A set, which represents a relationship with member records, represents a collection of one owner record and an arbitrary number of member records that are related to this owner record. In the example described on the left here, the file code corresponds to one owner record and member record B connected to it. In addition, in this example, the file structure shown in the lower right (file D
As can be seen from (corresponding to B correspondence definition 3),
Only the data items At from record type A are selected and mapped (defined) to the file. In this way, if you are not conscious of data items other than necessary (if application program 1 is data ring F1 that does not need to be received by issuing a read/write command), you can omit the unnecessary data ring]. and map it to the file. This makes it possible to receive only the necessary data items from the record.

For example, in Figure 2, by mapping only the data item "section code" of the owner record of record type A to the file structure, and mapping all the data items of the member records of record type ■3 to the file structure, As stated in the dotted line column of the configuration,
The corresponding data is searched and retrieved from NDB6,
The information is assembled into a record and passed to the application program that issued the read command.

Next, the operation of the configuration of one embodiment of the present invention will be described with reference to FIGS. 2 and 3.

+1) Figure 3: When the application program 1 issues a read/write command to the NDB 6, the NDB/file record conversion mechanism 2 is called, obtains information from the file DB correspondence definition 3, and converts the read/write command to the corresponding NDB. database operation instructions (DML interface). This means, for example, that application program 1 is C0BOL
In response to issuing a READ command written in a language to the NDB 6, an NDB database as described in the NDB/file record conversion mechanism 2 in FIG. 3 is created based on a predefined file DB correspondence definition 3 not shown. Convert to operation instructions. More specifically, as shown by the solid line in the file structure in Figure 2 (corresponding to file DB correspondence definition 3), only the "intelligence code" of the data items of the record type A owner record. , for all data items of member records of record type B, ND
It is converted into a database operation command for searching and retrieving from B6.

(2) Convert the converted database operation instructions to N I) [3
Issue to fi. In response to the issuance of this database operation command, the AIM/NDB4 searches the NDB6, reads the corresponding data item, and notifies the N D 13/File Record Conversion 1 Structure 2 (when the read command is issued), or the corresponding data item. Write data to (when issuing a write command).

+3) Assemble the information obtained from NDB6 into a record based on the file DB correspondence definition 3°.

(4) Pass to application program 1 and return.

Through the above procedure, for example, in response to the application program 1 issuing a read command to the NDB 6, the data shown using the dotted line in the file structure at the bottom right of Figure 2 is assembled into a record and passed to the application program 1. It will be done.

〔Effect of the invention〕

As explained above, according to the present invention, the file D in which information for accessing the NDB 6 is defined in advance in a file format.
Create B correspondence definition 3, and in response to application program 1 issuing a read/write command to NDB 6, refer to this file DB correspondence definition 3 and convert the corresponding data into an input operation command. Because it uses a configuration that publishes to NDB6 and receives and receives the corresponding data, even people without specialized knowledge of database operation languages can easily access the complex structure of NDB6 from programs written in C0BOL languages etc. The desired data can be retrieved or written.

[Brief explanation of the drawing]

FIG. 1 is a diagram showing the principle configuration of the present invention, FIG. 2 is an explanatory diagram of the operation of the present invention, FIG. 3 is an example of conversion and publication into a database operation language, and FIG. 4 is an explanatory diagram of the prior art. In the figure, 1 is an application program, 2 is an NDB/file record conversion mechanism, 3 is a file DB correspondence definition, and 4 is an AIM.
/NDB, 6 is NDB (network data base)
represents.

Claims (1)

[Claims] NDB that accesses a network database (hereinafter referred to as NDB) through a read/write interface.
In the access method, in response to the file DB correspondence definition (3), which predefines the information to access the NDB (6) in the file format, and the issuance of read/write commands from the application program (1),
NDB which is a different language based on the information predefined in the corresponding file of this file DB correspondence definition (3)
It is converted into a database operation command and issued to NDB (6), and in the case of a read command, NDB is issued in response to this issuance.
It is equipped with an NDB/file record conversion mechanism (2) that assembles the information returned from the DB (6) into a record and passes it to the application program (1), and the application program (1) uses read/write instructions to
NDB that can be accessed with descriptions in different languages (
6) An NDB access method using a read/write interface, characterized in that it is configured to read/write.