JPS6225346A - Electronic journal file constitution system - Google Patents

Abstract

PURPOSE:To improve the use efficiency of a file and to perform retrieval in both directions by storing journal data in a data file in the form of the number of record corresponding to its size and adding information on the number of used records to the head and tail. CONSTITUTION:When one journal is received, the number of records required for the journal is decided, the information on the number of records is added to the head of an unused record in a data file 2 firstly, and journal data are stored successively. In this case, if one record is not enough, succeeding records are used in sequence. When the journal data are all stored, a control code ETX is added behind it and the information on the number of used records is added to the tail of the final record. Further, the relative record number of the head record which is stored this time is stored in the area 1a of a key file 1 as a pointer and its key data is stored in an area 1b.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a method for configuring an electronic journal file by recording a journal on a storage device such as a magnetic disk device or a floppy disk device.

Electronic journal files are created and used in various fields. For example, in a financial processing system, when a journal containing the deposit amount, withdrawal amount, type of deposit, transaction date and time, etc. of a customer is sent from a terminal to a host computer,
This information is imported into a file management system and an electronic journal file is created on a storage device such as a magnetic disk device.

[Conventional technology]

Conventionally, the creation of such electronic journal files was structured by fixing the number of records per record according to the maximum journal data, and storing sequentially generated journal data in the fixed-length area in the order of occurrence. Was. When processing the created electronic journal file later, access is generally performed in two ways: searching from the first journal data and searching backwards from the last journal data. This is because by setting the journal data to a fixed length, recognition of one item of journal data becomes uniform and access to it becomes easier.

(Problem to be solved by the invention) However, in such a conventional method, the storage area for each journal data is a fixed length, so the same amount of storage area is required even for transactions with small amount of data. is required, which poses the problem of poor file usage efficiency.

The present invention solves these conventional problems, and its purpose is to easily perform searches both in the direction from the first journal data to the last journal data and in the opposite direction. However, the object of the present invention is to provide a method for configuring electronic journal files that is efficient in file usage.

[Means for solving problems]

In order to solve the above problems, the present invention provides a system that stores journals on a storage device, in which an electronic journal file is divided into a data file containing journal data and a key file containing position information of the journal data on this data file. The area for storing journal data on the data file has a variable length with the number of records corresponding to the data length, and information indicating the number of records used for that journal data is added to the beginning and end of each journal data. do.

[Effect]

When a journal that should be stored in a file is generated, the journal data is stored in the data file with the number of records according to the size of the journal data, and a record indicating the number of records used is displayed at the beginning and end of the journal data. will be added. Additionally, information indicating the location of the stored journal data on the data file is stored in the key file.

〔Example〕

FIG. 1 is a diagram showing an example of the structure of a file employed in the present invention.

As shown in the figure, in this embodiment, the electronic journal file is composed of a key file 1 and a data file 2.

Among these, data file 2 is a file that stores journal data, and FIG. 1 shows a state in which journal data A to F are stored. Here, each journal data A to F is stored in a variable length using the number of records (each record is fixed length) according to the data length, and the journal data A, C, E,
F uses one record, journal data B uses two records, and journal data D uses three records. Information indicating the number of records is added to the beginning and end of a single record or a series of records in which each journal data is stored.

Note that ETX added at the end of each journal data is a control code indicating the end of journal data, and ETX is a control code that indicates the end of journal data.
The blank space after the X indicates that no journal data is stored.

The key file 1 also includes an area 1a that stores a pointer indicating where journal data is stored on the data file 2, and an area 1 that stores key data.
This is an information file containing b. For example, the relative record number of the first record in which journal data is stored is stored as the pointer, and in FIG. 1, journals A and C are stored.

Only the state in which relative record numbers of E and F are stored is shown.

FIG. 2 is a schematic configuration diagram showing an example of an apparatus for implementing the present invention, in which 10 is an arithmetic processing unit, 11 is a main memory, 1
2 is a magnetic disk device in which files are stored; 13 is a line control device; 14 is a line connected to a workstation (not shown); and 15 is an input/output device having a keyboard or CRT. The journal sent from the workstation is received by the line control device 13 via the line 14, and stored in a file on the magnetic disk device 12 by the arithmetic processing unit 10, which operates on a processing program stored in the main memory 11. Further, files stored in the magnetic disk device 12 are processed by the arithmetic processing unit 10.

In FIG. 2, when one journal is received via the circuit kJA 14, the arithmetic processing unit 10 determines the number of records required for that journal, and first records the number of records in FIG. Information indicating the number of records is added to the beginning of the unused record following the used record in the data file 2, and then journal data is sequentially stored from behind. In this case, if one record is insufficient, subsequent records )' are used in sequence.

When all journal data is stored, ETX is stored behind it.
control code is added, and information indicating the number of records used is added again to the end of the last record.

Further, the processing unit 10 stores the relative record number of the first record storing the current journal data as a pointer in the area 1a of the key file 1, and stores the key data in the area ib. Note that dummy data may be initially stored in the area 1b, and key data may be stored later. The above processing is performed every time journal data is received, and a file as shown in FIG. 1 is constructed.

When searching and processing electronic journal files stored in the magnetic disk device 12, this embodiment uses a sequential access method in the direction from the first journal data to the last journal data, a sequential access method in the reverse direction, and a key method. A random access method using file l is possible. In the random access method, for example, a pointer to journal data containing key data that matches the input key data is read from key file 1, and the number of records indicated by the record number specification information is read from the record with the relative record number pointed to by the pointer. By reading only the journal data, one item of journal data can be retrieved. In addition, in the forward sequential access method, the number of records used in the journal data can be determined from the record count information at the beginning.
By reading that number of records, journal data for one item is obtained.

Furthermore, if information on the number of used records is not added to the end of journal data, even if the end of the file is detected by identifying the file end mark written at the end of the file, for example, the journal data will be of variable length. For this reason, it is difficult to know how far back it will take to find the beginning of one journal data item, making reverse sequential access difficult. However, in the present invention, the number of used records for each journal data is also manually entered at the end of the journal data, so even if the records are accessed sequentially from the last record, the number of used records for one piece of journal data can be known. If it is "3", it can be identified that there is one piece of journal data three records before the file end mark. Therefore, data for one record of three records can be automatically read in one access and controlled as one journal data, and journal data can be accessed without recognizing the data length.

〔Effect of the invention〕

As explained above, in the present invention, the electronic journal file is stored separately into the key file and the data file, and the data file's glossary data length is made variable, so that file usage efficiency can be improved. . Also,
A key file was set up to memorize the position in the data file where each journal data is stored, making random access possible.Furthermore, the number of used records of the journal data was added to the beginning and end of the journal data, so the beginning This has the effect that searches can be easily performed both in the direction from journal data to the last journal data and in the opposite direction.

[Brief explanation of drawings]

FIG. 1 is a diagram showing an example of a file configuration adopted in the electronic journal file configuration method of the present invention, and FIG. 2 is a schematic configuration diagram of an apparatus implementing the present invention. In the figure, l is a key file and 2 is a data file. The present invention'? Figure 2 is a schematic configuration diagram of a device that implements the Mengi invention showing the planting of files to be adopted.

Claims (1)

[Claims] In a system that holds journals on a storage device, an electronic journal file is divided into a data file containing journal data and a key file containing position information of journal data on the data file, and , the area for storing journal data on the data file has a variable length having a number of records according to the data length, and information indicating the number of records used for the journal data is added to the beginning and end of each journal data. An electronic journal file configuration method characterized by: