JPH06290213A - Data processing system - Google Patents

Abstract

PURPOSE:To prevent the log file of an ISAM system from being misspecified by opening the log file by referring to specific information defined in an environment definition file when a command is executed. CONSTITUTION:When a file in a data base is processed by the ISAM system, the log file 11 is specified with an environmental variable R and the record of a LOGPATH in an environmental setting file 5. Namely, when the log file 11 is on a path LOGPATH=XX described in the environmental setting file 11 called rdconfig, the user sets a value rdconfig to the environmental variable R in a RAM first in order to open the log file 11. Then, the user starts a program to open the log file rdconfig. When this program is executed and normally described, the file on the path XX is opened. Consequently, the file is prevented from being misspecified.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing system for processing data on a database, for example.

[0002]

2. Description of the Related Art ISAM (Index Order Access Method) is one of the access methods to a database. Especially U
UNIX system (UNIX is UNIX System Laboratorie
s, Inc. developed operating system)
SAM to C-ISAM (C-ISAM is US INFORMIX S
oftware, Inc.).

In C-ISAM, "file lock", "record lock", and "for maintaining data consistency" are provided as means for preventing the occurrence of data inconsistency during simultaneous use by multiple users. Three lock functions of "transaction" are prepared. File lock includes lock by lock function and lock by exclusive opening of file. There are two types of record lock: "auto lock", which locks only the last record accessed, and "manual lock", which controls the record to be locked by a program.

[0004]

The conventional ISAM, especially C-ISAM, has the following drawbacks. (1) When opening a log file, you have to specify the path of the log file.
I often made a mistake in the designation. (2) When opening an ISAM file, you must specify where the file is. this is,
This means that it is necessary to distinguish between the test version file and the final version file in the development process of the program, and therefore it is necessary to rewrite the debug file and the final version file, which is troublesome. (3) Each time a file is locked, the lock mode must be specified in the program, which is one of the factors that hinder the efficiency of program development.

[0005]

The present invention has been proposed to solve the above-mentioned problems of the prior art. The configuration of the present invention for achieving the above object is a data processing method for processing a file on a database by the ISAM method, and a log file for recording a history of update of the ISAM file on the system, and a log file for this log file. A means for interpreting and executing an environment definition file that stores specification information and a command for opening the log file, and referring to the specification information defined in the environment definition file when executing the command. Accordingly, an opening means for opening the log file is provided.

Another structure of the present invention for achieving the above object is a data processing system for processing a file on a database by the ISAM system, and a memory for storing designation information for designating an ISAM file, and the ISAM. A means for interpreting and executing a command for opening a file, wherein when executing the command, the ISAM is referred to by referring to designation information defined in the memory.
A file is specified, and an opening means for opening this ISAM file is provided.

Another structure of the present invention for attaining the above object is a data processing method for processing a file on a database by an ISAM method, for storing a ISAM file, and for opening the ISAM file. Means for interpreting and executing the command of
Lock control means for interpreting and executing a command for reading and / or updating a SAM file while performing lock control, wherein the lock control means is an open type of the ISAM file when opened by the opening means. A data processing method, wherein lock control of the ISAM file is performed according to a predetermined lock control mode.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT A preferred embodiment of the present invention will be described below with reference to the accompanying drawings. FIG. 1 is a block diagram of a data processing system in which the ISAM database of the present invention is installed. This system is configured by connecting one processor board and a plurality of expansion boards (EXIF boards) to one system bus. Up to eight workstations can be connected to one EXIF board.

The processor board includes a 32-bit microprocessor MPU, a ROM storing a bootstrap program, a RAM storing data for programs and work, a floppy disk device FD, a hard disk device HD, and a streamer device. Connected SCS
An I (small computer system interface) interface circuit and an RS232 interface circuit for the system console are stored.

FIG. 2 shows the environment in which the ISAM system of FIG. 1 operates. In the figure, the tool for maintenance which is the feature of this ISAM system is shown as isamtool 10. This isamtool is idx file 6, data file 7, rec file 8, ke
Input 4 files such as y file 9 and ISAM
File open, close, read,
By executing commands such as "Write", "Search", "Delete", "Lock", "Unlock", ISAM
File maintenance. Here, idx is an index file, data is a data file, rec is a record definition file, and key is a key definition file.

In FIG. 2, a log file 11 is a file to which the history is written when file maintenance is performed. The user uses the CRT / keyboard 1 or the like to create the format file 3 via the EDITOR program or the like. The mkidx command prepared in advance in ISAM creates the idx file 6, the data file 7, the rec file 8, and the key file 9 from the format file 3 described above. rdconf
The ig file 5 is an environment setting file, the details of which will be described later with reference to FIG.

The other important data in this ISAM system are two environment variables, RDCONFNAME and RDDISAMPATH. These two environment variables are input to the hard disk HD by the user from the CRT.
Reserved in RAM of FIG. 1, not above. Its input is
In this example, setenv RDCONFNAME <path name> setenv RDDISAMPTH <path name>. If setenv RDCONFNAME <rdconf
ig> setenv RDISAMPHAT <isamfi
If you enter le>, the above variables RDCONFNAME and RDI
In SAMPATH, as shown in FIG. 3, the name of the environment setting file to be used is designated as rdconfig, and the directory storing the ISAM file to be opened is designated as isamfile. <Log File Opening> The log file opening operation in this embodiment will be described with reference to FIGS.

In the example of FIG. 4, the user has XX / X on the HD.
It is assumed that the log file of the path X / XXXX is opened. And on the hard disk HD rdc
It is assumed that an environment setting file named "onfig" exists. A feature of opening a log file in this ISAM system is that i: the user does not need to specify the log file on the program. ii: The log file is specified by the environment variable RDCON described above.
It is specified by FNAME and a record called LOGPATH in the environment setting file.

If the user has a log file of XX / XX / XX
If you know that it is on the path XX, and you know that the path is written as LOGPATH = XX / XX / XXXXXX in the LOGPATH record in the environment setting file named rdconfig For example, XX / XX /
In order to open a log file on a path called XXXXX, the user must first set the environment variable RDC on RAM.
During ONFNAME, setenv RDCONFNAME <rdconf
ig> sets the value "rdconfig". Then, the program that should open the log file rdconfig is started. The statement rd_init must be included in this program. 5 shows the log file open, that is, the command "rd_in
It is an execution routine of "it". When this program is executed, the system first refers to the environment variable RDCONFNAME in RAM in step S1. If the name of the environment setting file is not set in this variable, it is returned to the program as an illegal open (step S4). Next, in step S6, the environment setting file is opened. Setenv RDCONFNAME above
If rdconfig is input, step S6
Then rdconfig will be opened. If the environment setting file with the specified name does not exist, an unauthorized open message is returned in step S10. Next, in step S12, it is checked whether or not there is a record including the description of "LOGPATH =" described above in the environment setting file. If it does not exist, an illegal open message is returned to the program in step S14. Step S
At 16, the file name defined by LOGPATH = is opened. In the example, LOGPATH = XX /
Since it is described as XX / XXXX, the path XX / XX
/ Open the file on XXXX. If successfully opened, return a normal open message to the program.

Thus, the log file is opened.
The features of the present ISAM system are, as described above, the flexibility of changing the specification of the log file and the prevention of the mistake of the file specification. This point will be described. The flexibility of specifying the log file is as follows. That is, by omitting the name setting of the log file in the log file open command (rd_init), the program mistake was prevented. By specifying the log file with the environment variable RDCONFNAME and the environment setting file instead of specifying it in the program, it becomes possible to change the specification of the log file only by changing these. Therefore, since it is not necessary to change the program even if the log file needs to be changed, it is possible to prevent a program error from occurring.

FIG. 6 shows an example of opening a file on the path TT / TT / TTTT as a log file. Even in this case, it is not necessary to change the program.
An environment setting file (its name is zzzzz) including a description of LOGPATH = TT / TT / TTTT is created in advance. Therefore, before opening the log file, the user sets "zz" in the environment variable RDCONFNAME.
zzz ”is set. Then, as shown in FIG. 6, rd
Regardless of the existence of the environment setting file named config, a file on the path TT / TT / TTTT is opened as a log file through the environment setting file named zzzzz.

That is, when changing the log file, a plurality of environment setting files are prepared and an appropriate environment setting file is selected, or an LO in the environment setting file is selected.
The description of GPPATH may be changed. You can freely change the log file by creating multiple environment setting files in advance and setting the environment setting file that specifies the target log file each time with setenv RDCONFNAME.

The environment variable RDCONFNAME may be set on the disk HD. However, the setting on the RAM as described above increases the arbitrariness of file selection when the log file is opened after power-on. Therefore, as described above, this environment variable may be set on the disk HD when it is not necessary to change the setting even when the power is turned on. Especially, on UNIX, if the setnv command is described in the login file, the environment variables can be automatically set at the time of startup. <Open ISAM File> The ISAM file open command has the following format.

Rd_open <pathname> This command opens the ISAM file specified by <pathname>. However, when the path name is directly specified, that is, when the path name of II / II / IIII is specified, the ISAM file on the path is directly opened.

As mentioned above, the environment variable RDISAMP
Command to set ATH setenv RDISAMPHAT <isamfi
le> is the ISAM file <isa to be opened.
Specify the mfile> directory. If the command above sets setenv RDISAMPHAT II / II / and the environment variable RDISAMPHAT,
If rd_open IIII was specified in the SAM file open command, II / II / in the environment variables
And IIII in the open command are combined, the file on path II / II / IIII is ISAM
It is opened as a file. An example is shown in FIG.
FIG. 8 shows the procedure for executing the ISAM file open command.

The setenv command is used to execute RDISA.
Multiple directories can be set in MPATH. The directories are separated by spaces.
When opening, the existence is checked sequentially from the top directory, and the first one found is opened. In this way, according to the method for opening the retained ISAM file, the flexibility of changing the ISAM file specification and the prevention of file specification error can be prevented, similar to the case of opening the log file. <Lock Control> Next, the record lock control in this ISAM system will be described. The feature of this lock control is that the lock control is determined according to the opening mode of the ISAM file. Figure 8
Is a table showing that the lock control differs depending on the type of ISAM file opened.
In this embodiment, the type of open is input (INPUT)
There are three types of files: output files, output files, and input / output files. Locking is not performed when opening as an input file and when opening as an output file. When opened as an I / O file, the last record read is automatically locked. In the past (C-ISAM), lock control is programmatically specified for each input and output of a file. In this system, the mode of lock control is determined according to the type of open, so that the user is relieved from the trouble of specifying lock control one by one in the input / output instructions of the program. Further, since the input file and the output file are usually assumed to have the value changed by another user after being read or written, as shown in FIG. 8, when the lock is unnecessary. Because there are many. On the other hand, since the input / output file reads the record on the assumption that the record is updated, it is necessary to lock the record until the update is performed.

[0022]

As described above, according to the present invention, (1) the number of specified mistakes when opening a log file is reduced. (2) When opening an ISAM file, the complexity of specifying where the file is located is eliminated. (3) Each time a file is locked, the complexity of designating the lock mode in the program each time is released.

[Brief description of drawings]

FIG. 1 is a block diagram showing a hardware configuration of an ISAM system to which the present invention is applied.

FIG. 2 is a diagram showing an environment of an ISAM system to which the present invention is applied.

3 is a diagram showing the configuration of environment variables used in the system of FIG.

FIG. 4 is a block diagram of XX / XX / XXX in the system of FIG.
The figure explaining the operation | movement which opens the log file on the path X.

FIG. 5 is a flowchart showing a control procedure for opening a log file.

FIG. 6 shows the system of FIG. 2 in which II / II / III
The figure explaining the operation | movement which opens the log file on the path called I.

FIG. 7 shows a system of FIG. 2 in which YY / YY / YYY
The figure explaining the operation | movement which opens the ISAM file on the path Y.

FIG. 8 is a flowchart showing a control procedure for opening an ISAM file.

FIG. 9 is a table diagram illustrating a mode of lock control.

Claims (10)

[Claims] 1. A data processing method for processing a file on a database by the ISAM method, wherein a log file for recording a history of update of the ISAM file on the system, and an environment definition file for storing designation information of this log file. And a means for interpreting and executing a command for opening the log file, wherein the log file is opened by referring to designation information defined in the environment definition file when executing the command. A data processing method comprising an opening means. 2. The data processing method according to claim 1, wherein the designation information is information designating a path to the log file. 3. The designation information is first information stored in a non-volatile memory, the first information designating a path to the log file, and the second information stored in a volatile memory. 2. The data processing method according to claim 1, further comprising: second information designating a file storing the first information. 4. A data processing method for processing a file on a database by an ISAM method, comprising: a memory for storing designation information for designating an ISAM file; and a means for interpreting and executing a command for opening the ISAM file. Yes, when executing the above command,
A data processing method, comprising: an opening unit for identifying the ISAM file by referring to the designation information defined in the memory and opening the ISAM file. 5. The designation information is information designating a path to the ISAM file.
Data processing method described in. 6. The designation information is first information designating an ISAM file in the command and second information stored in a non-volatile memory, and path information designating a path to the log file. 5. The data processing method according to claim 4, wherein the opening means specifies the ISAM file to be opened by combining the first information and the second information. 7. A data processing method for processing a file on a database by an ISAM method, comprising: storage means for storing an ISAM file; open means for interpreting and executing a command for opening the ISAM file; And a lock control means for interpreting and executing a command for reading and / or updating the ISAM file while performing lock control, wherein the lock control means opens the ISAM file when opened by the opening means. A data processing method, wherein lock control of the ISAM file is performed according to a predetermined lock control mode for a type. 8. The data processing method according to claim 7, wherein the lock control mode is determined not to lock the input file. 9. The data processing method according to claim 7, wherein the lock control mode is determined not to lock the output file. 10. The data processing method according to claim 7, wherein the mode of the lock control is determined to lock the record read last for the input / output file.