JP2532378B2 - Data file data arrangement method - Google Patents

Description

The present invention relates to a data file data organization method for writing a large number of information in each data area of a data file in the order of code numbers uniquely assigned to each information.

[Prior Art] For example, in a POS (point-of-sale information management) system adopted in department stores, large-scale supermarkets, etc., a single file control unit is connected with a large number of electronic cash registers via a transmission path. Then, in the internal storage unit formed by the RAM or the like of the file control unit, product data such as the product name, unit price, and department of each product for all products sold at each sales floor is stored for each product code, and the number of sales points, A master file (data file) that collects sales data such as sales amount by product code is formed.

Then, when the product code of the product sold by each electronic cash register is input with a keyboard or a barcode scanner, the product code is transmitted to the file control unit via the transmission path. The file control unit searches the master file with the received product code, reads the product data such as the product name and unit price of the product code, and returns it to the electronic cash register. The electronic cash register that has received the product data executes the sales registration operation using this product data. Then, the sales data such as the number of sales and the sales amount are transmitted again to the file control unit. The file control unit updates the sales number and sales amount of the corresponding product code in the master file with the received sales data.

As described above, the file control unit needs to search the master file with the product code each time data is exchanged with each electronic cash register. Therefore, by shortening the time required for this search, it is possible to improve the efficiency of sales registration work for each product in each electronic cash register. Then, in general, a binary search method is adopted in order to shorten the time required to search for the product code. This binary search method is, as is well known,
Information such as product data and sales data for each product is stored in each data area of the master file in the order of the code number of the product code, and when searching for the product code, the data located in the center rather than the area number of the data area is searched. The search is started from the product code in the area, and the size of the product code is compared to determine the data area to be searched next. By adopting such a binary search method, the search time can be greatly reduced. This is especially effective when the number of products handled is large.

[Problems to be Solved by the Invention] However, the above binary search method is adopted.
The POS system also had the following problems. That is, in this binary search method, the absolute condition is that the product codes to be searched are always arranged in each data area in the order of the code number in the master file.
That is, there is no effect that there is a missing code number, but if the code numbers are changed in size or the same code number occurs, the product code will not be searched correctly and error processing without the corresponding code will occur. Will end up.

In order to eliminate such a state, it is sufficient to rewrite the product code whose size is changed in the regular data area. In addition, if it is written twice, the unnecessary product code may be deleted. However, it is impossible to search for a product code to be rewritten and a product code to be erased by the conventional binary search method. In such a case, it is necessary to rewrite all the data in the master file from the beginning.

The present invention has been made under such circumstances, and an object of the present invention is to temporarily save each data of a data file in another recording medium and then write each data written in this recording medium. By writing data in each data area of the data file so that they are arranged in the order of the code number in the data file, we provide a data file data organization method that can prevent the code numbers from being mixed up and down and double writing in the data file. To do.

[Means for Solving Problems] In the data organization method of the data file of the present invention, each data stored in each data area of the data file is temporarily stored in each recording area of a recording medium different from the data file. After clearing each data area of the data file after writing (data saving) and data saving, each data written in each recording area of the recording medium is sequentially read in the order of the area number of the recording area, and this reading is performed. When the code number of the data written earlier than this data is searched for in each data area of the data file by the code number of the data, and the corresponding code number is not found in this code search, this code Each data area for storing each data having a code number larger than the number is sequentially shifted one data area to the larger area number. Then, the data having the corresponding code number is written in the empty data area after the shift.

On the other hand, when the corresponding code number is searched by the code search in the previous invention, the data previously written in the data area having the corresponding code number and the data read later from the recording medium are duplicated. The data is printed out as embedded data.

In another invention, the above-mentioned double write data is stored in the internal storage unit.

In still another invention, when the corresponding code number is searched by the code search, the data in the data area in which the corresponding code number is written is rewritten to the data of the corresponding code number read from the recording medium later. It is the one.

[Operation] According to the data organization method of the data file configured as described above, each data stored in each data area of the data file is once written in each recording area of the recording medium regardless of the code number. Then, the data is sequentially read from each recording area of this recording medium, and when they are written in each data area of the data file, they are written so as to be arranged in the order of code numbers. Therefore, even if the code numbers are replaced in the data file, the replacement will be corrected when the data is written in each data area of the data file again from the recording medium.

If a double code number occurs when writing from the recording medium to each data area of the data file, the data of the corresponding code number is printed out as double write data.

In another invention, the double write data is stored in the internal storage unit.

In another aspect of the invention, when a double code number occurs when writing from the recording medium to each data area of the data file, the data of the corresponding code number read from the recording medium later is given priority. Written in the area.

[Embodiment] An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a schematic configuration diagram showing a POS system to which the data organization method of data files of the embodiment is applied. That is, a plurality of electronic cash registers 2 are connected to one file control unit 1 by a transmission line 3. The file control unit 1 is connected to a RAM 4 in which a master file as a data file is formed and a floppy disk drive device (FDD) 5 for writing / reading data to / from a floppy disk (FDK) as a recording medium. There is.

As shown in FIG. 2, each of the electronic cash registers 2 is provided with a keyboard 7 on the front surface of a housing 6, a display portion 8 on the upper front portion, a receipt issuing port 9 on the front middle portion, and a drawer on the lower portion.
10, a display unit 11 for customers is provided on the upper surface. further,
The housing 6 has a bar code scanner 12 for reading a bar code indicating the product code of the product attached to the product for sale.
Is connected.

On the keyboard 7, there are a number key 13 for inputting numbers such as product codes and sales points of sold products, a department key 14 for inputting a department code, and a total key 15 for calculating the total amount of money. Various registration keys are arranged. Also,
Adjacent to this keyboard 7 [Registration] [Inspection] [Settlement]
A control key 16 for selectively setting various business modes such as [Setting] is provided.

FIG. 3 is a block diagram showing a schematic configuration of each electronic cash register 2, and 17 in the figure is a CPU (central processing unit) that executes various arithmetic processing based on data input from the keyboard 7 or the bar code scanner 12. . This CPU17
Is a ROM 21 that stores control programs and the like via the address bus 18, data bus 19 and control line 20, RAM 2 that stores data input from the keyboard 7 and variable data such as various totalizers.
Control 2 Further, a scanner input circuit 23 for inputting a product code read by the barcode scanner 12, a control key input circuit 24 for inputting various commands from the control key 16, and a keyboard input circuit 25 for inputting various key signals from the keyboard 7. A display control circuit 26 that sends display data to the display units 8 and 11, a printer control circuit 28 of a dot printer 27 that prints out various data to a receipt, and a file control unit via a transmission connector 29 connected to the transmission path 3. 1, the transmission control circuit 30 connected to the data bus 19
It is also connected to the CPU 17 via the control line 20.

FIG. 4 is a block diagram showing a schematic configuration of the file control unit 1. CPU31 has address bus 32, data bus 33,
ROM 35 for storing various control programs via the control line 34,
The RAM 4 that stores variable data such as a master file that aggregates product data and sales data for each product for each product sold at each sales floor by product code is controlled. Further, an output port 36 for connecting the file control unit 1 to an external control unit such as a host computer, a keyboard input circuit 38 for inputting various business commands from a keyboard 37, a transmission line 3
And a transmission control circuit 40 connected to each electronic cash register 2 via a transmission connector 39, and an FDD control circuit 41 for driving and controlling a floppy disk drive device (FDD) 5.
Are connected to the CPU 31 via a data bus 33 and a control line 34.

In the RAM 4, in addition to various work areas such as a transmission / reception buffer for transmitting / receiving various data to / from each electronic cash register 2, a master file R1 and a master file R1 are stored in the master file R1 as shown in FIG. Same product code is 2
A dual data storage area R2 is formed to store product data such as product code, product name, unit price, and department when more than one product is stored.

Further, the master file R1 is composed of M data areas R3 assigned area numbers N from 1 to M. Each data area R3 is a code area R4 that stores the product code of the product, a product data area R5 that stores product data such as the product name, unit price, department, and status of the product, and sales data such as the number of sales and the amount of sales. And a sales data area R6 for cumulatively storing. The product data and the sales data constitute information about the product code.

Also, FIG. 6 shows a floppy disk (FDK) 42 set in the floppy disk drive device (FDD) 42.
And a recording area R7 for recording data consisting of M pieces of information consisting of product data and sales data and a product code read from each data area R3 of the master file R1 of the RAM4. Are formed.

Then, the CPU 31 of the file control unit 1 is configured to execute the main routine of FIG. 7 when the power is turned on and various kinds of initial processing are completed. That is, P1
When, for example, a data save command for writing the data recorded in each data area R3 of the master file R1 to the floppy disk (FDK) 42 is input from the keyboard 37, the area number N of the data area R3 to be read is set as the top number. Set to 1. Then, in P2, the data area of area number N
Data consisting of product code, product data, and sales data is read from R3, and written to the Nth recording area R7 of the floppy disk (FDK) 42 set in the floppy disk drive device (FDD) 5 via the FDD control circuit 41. Put in. Then, the area number N is incremented by 1. When it is confirmed that the increased area number N does not exceed the number M of data areas of the master file R1, the process returns to P2 and the data is read from the data area R3 of the next area number to read the data from the floppy disk (FDK) 42. Write to the next recording area R7. When the area number N exceeds the number M of data areas, the data save processing for the floppy disk 42 of all data is completed, and the M data areas R3 of the master file R1 are cleared.

Also, on P3, from the keyboard 37 to the floppy disk 42
When a data load command indicating the writing of the respective data saved in the master file R1 is input, the area number N of the recording area 7 to be read of the floppy disk 42 is set to the head number 1. Then, at P4, the data recorded in the Nth recording area R7 of the floppy disk (FDK) 42 is read out via the floppy disk drive device (FDD) 5. Next, each product code (code number) already stored in each product code region R4 of the master file R1 is binary-searched with the product code (code number) included in the data read in P5.

This binary search process is shown in FIG. When this process is started, the search code A which is the product code (code number) of the data read from the floppy disk 42 is determined. Then, the product code area R4 of the master file R1
The product code A ₁ stored in the first area (area number = 1) of is read.

When the area number N read from the floppy disk 42 is 1, the data is not set in the leading area of the master file R1 and the product code A ₁ cannot be read. It is determined that the code identical to that is not retrieved from the master file R1, and this binary retrieval process is terminated.

On the other hand, when the area number N is 2 or more, since data is already written in the area number 1 to area number N-1 in the master file R1, the search code A and the product code read from the leading area in P51 are read. Determines if A ₁ is equal. If they are equal, it is determined that the same code as the corresponding product code A has been retrieved from the master file R1, and this binary retrieval processing is terminated.

If the search code A is not equal to the product code A _{1 in} P51, the size is determined in P52. Then, when the search code A is smaller than the product code A _1, it is determined that the same code as the product code A has not been searched for in the master file R 1, and this binary search process is terminated.

If the search code A is larger than the product code A _{1 in} P52, the product code A _N-1 of the final area in the area number N-1 of the master file R1, that is, the area where the data has already been written in the master file R1. Is read and compared with the search code A. As a result, if it is the same as before, it is determined that the corresponding product code has been searched, and this binary search process is terminated. If the search code A is larger than the read product code A _{N-1, the} corresponding product code is not searched. If so, the binary search process ends.

When the search code A is smaller than the product code A _{N-1, the} lower area number N ₀ defining the search area is set to 1 and the upper area number N ₁ is set to N-1. Then, in P53, the area number N
₀ 1 of the total product code number of regions present in up to area number N ₁ from
The product code area R4 existing at the position of / 2, that is, the product code A _H of the product code area R4 whose area number H is represented by the following formula.
Read out.

H = N _H = (N ₀ + N ₁ ) / 2 If the calculation result of the above equation does not yield an integer value, round up.

Then, the search code A and the read product code A _H are compared. If the search code A and the product code A _H are equal, it is determined that the corresponding product code has been searched, and this binary search processing is terminated.

If they are not equal, it is confirmed in P54 that the lower area number N ₀ and the upper area number N ₁ do not yet match, and then the magnitude of the search code A and the product code A _H is checked. And
When the search code A is larger than the product code A _H , the lower area number N ₀ is set to the area number N _H of this product code A _H , and the upper area number N ₁ is unchanged and is the area number N ₁ . . on the other hand,
If the search code A is smaller than the product code A _H , the lower area number N ₀ remains unchanged and the upper area number N ₀ is set.
Set N ₁ to the area number N _H of this product code A _H.

When the lower area number N ₀ and the upper area number N ₁ that define the area to be searched are reset, return to P53, and the product code of the product code area R4 located at 1/2 of each area number set earlier Read A _H. In this way, the distance between the lower area number N ₀ and the upper area number N ₁ indicating the search area is sequentially reduced, and finally at P54, the lower area number N ₀ and the upper area number N ₁
Product code read by search code A until and are equal
If it does not match with A _H , it is determined that there is no corresponding product code, and this binary search process ends.

When it is confirmed that the corresponding product code (code number) is not found in P6 as a result of executing this binary search process, the data area that stores the data of the product code (code number) larger than the product code (code number)
R3 is moved (shifted) one data area toward the larger area number. Then, the data read from the floppy disk 42 is written into the empty data area R3 after the shift. If there is no product code (code number) larger than the product code (code number) of the read data, the floppy disk 42 is placed in the data area R3 having the area number next to the data area R3 in which the data is already stored. It is sufficient to write the read data. Therefore, in this state, the product codes are stored in the product code areas R4 of the master file R1 in the order of the code numbers.

When the relevant product code is searched on P6, there will be two or more identical product codes (code numbers).
Two pieces of data, the data read from the floppy disk 42 and the data of the same product code read from the master file R1, are transmitted to, for example, the electronic cash register 2 serving as a master, and the dot printer 27 of the electronic cash register 2 serving as a master. Then, as shown in FIG. 11, it is printed out as a duplicate code on the receipt 43. Further, these data are stored in the double data storage area R2 of the RAM4. After that, the stored content of the data area in which the data of the same product code (code number) of the master file R1 is written is rewritten to the data having the same product code newly read from the floppy disk 42.

When the process of writing one data read from the recording area R7 of the floppy disk 42 to the master file R1 is completed, the area number N of the recording area R7 of the floppy disk 42 is incremented by 1 to P7. After confirming that the increased area number N does not exceed the number M of recording areas, the process returns to P4 and the data of the next recording area R7 of the floppy disk 42 is read.

When the increased area number N exceeds the number M of recording areas in P7, it is determined that writing of all the data recorded on the floppy disk 42 to the master file R1 is completed,
This data loading process ends.

In the data organization method of the data file configured in this way, for example, as shown in FIG. 9A, the ninth data area (area number N = 9) of the master file R1
As shown in (b) of the same figure, the product code [12000] of R3 has an error in the most significant bit due to some reason [0200
It is assumed that the value changes to 0]. Therefore, this product code matches the product code [02000] of the sixth data area R3. In this case, since the number M of data areas is 11, when a data save command is input from the keyboard 37, the data in the respective data areas R3 of the master file R1 are stored in the area numbers 1 to 11 of the floppy disk 42 shown in FIG. The data is written in the recording area R7 and each data area R3 of the master file R1 is cleared.

When a data load command is input from the keyboard 37, as shown in FIG. 10, data is written in each data area R3 of the area number N = 1 to 10 of the master file R1 in the order of product code (code number). Be done. Then, the ninth data of the floppy disk 42 is written in the sixth data area R3. Then, each product data of the above two [02000] product codes is stored in the dual data storage area R2 of the RAM4, and the electronic cash register 2 serving as the master as shown in FIG. Two pieces of data are printed out. Therefore, the operator can easily recognize the erroneous data from the printed and output data. Further, since the error data is stored in the dual data storage area R2 of the RAM 4, it is possible to read this data later or analyze the error data by connecting a host computer to the output port 36.

If there are two identical product codes,
The reason why the product code data read after the floppy disk 42 is preferentially written in the data area R3 is that the data entered later in the data correction or the like is often correct.

Even when the product code size is changed in the master file R1, the order is corrected in the correct order after the data loading process.

The present invention is not limited to the above embodiment. Although the floppy disk drive device (FDD) 5 is provided as an external recording medium in the embodiment, a RAM other than the RAM 4 described above may be provided internally as a recording medium.

[Effects of the Invention] As described above, according to the present invention, it is possible to prevent the difference in the size of code numbers in a data file and double writing, and in addition, when double writing data occurs, the data Can be easily confirmed. Further, when the double write data is generated, the data written later can be preferentially left in the data file.

[Brief description of drawings]

FIG. 1 shows a POS system to which the data file data reduction method of the present invention is applied. FIG. 1 is a diagram showing the entire system, FIG. 2 is a perspective view showing each electronic cash register, and FIG. FIG. 4 is a block diagram showing an electronic cash register, FIG. 4 is a block diagram showing a file control unit, FIG. 5 is a diagram showing a master file formed in a storage unit of the file control unit, and FIG. 6 is a recording format of a floppy disk. FIG. 7, FIG. 7 and FIG. 8 are flow charts showing the operation, FIG. 9 and FIG. 10 are diagrams for explaining the data organization method, and FIG. 11 is a diagram showing the print format of the receipt. 1 ... File control unit, 2 ... Electronic cash register, 3 ... Transmission unit, 4 ... RAM, 5 ... Floppy disk drive (FDD), 7,37 ... Keyboard, 12
…… Bar code scanner, 17,31 …… CPU, 42 …… Floppy disk (FDK), 43 …… Receipt, R1 …… Master file (data file), R2 …… Dual data storage area, R3… Data area , R4 …… Product code area, R7…
... Recording area, N ... area number.

Claims (3)

(57) [Claims] 1. Data for organizing the respective data stored in the respective data areas of a data file having a plurality of data areas for storing data consisting of information and a code number unique to the information in the order of the code numbers. In the file data organization method, first, each data stored in each data area of the data file is once written in each recording area of a recording medium different from the data file, and then the data after the data is saved. Each data area of the file is cleared, then each data written in each recording area of the recording medium is sequentially read out in the order of the area number of the recording area, and each of the data files is read by the code number of the read data. Each code number of the data written before this data in the data area is searched, and the corresponding code number is searched as a result of this search. If there is not, the data area for storing each data having a code number larger than the corresponding code number is sequentially shifted one data area toward the larger area number, and the corresponding code number is shifted to the empty data area after the shift. Data is written on the other hand, and when the corresponding code number is searched as a result of the search, the data previously written in the data area having the corresponding code number and the data read from the recording medium later are written. A method for organizing data in a data file, wherein the data is printed out as double-written data. 2. Data for organizing the respective data stored in the respective data areas of a data file having a plurality of data areas for storing data consisting of information and a code number unique to the information, in the order of the code numbers. In the file data organization method, first, each data stored in each data area of the data file is once written in each recording area of a recording medium different from the data file, and then the data after the data is saved. Each data area of the file is cleared, then each data written in each recording area of the recording medium is sequentially read out in the order of the area number of the recording area, and each of the data files is read by the code number of the read data. Each code number of the data written before this data in the data area is searched, and the corresponding code number is searched as a result of this search. If there is not, the data area for storing each data having a code number larger than the corresponding code number is sequentially shifted one data area toward the larger area number, and the corresponding code number is shifted to the empty data area after the shift. Data is written on the other hand, and when the corresponding code number is searched as a result of the search, the data previously written in the data area having the corresponding code number and the data read from the recording medium later are written. A method for organizing data in a data file, wherein the data is stored in an internal storage section as double-written data. 3. Data for organizing the respective data stored in the respective data areas of a data file having a plurality of data areas for storing data consisting of information and a code number unique to the information in the order of the code numbers. In the file data organization method, first, each data stored in each data area of the data file is once written in each recording area of a recording medium different from the data file, and then the data after the data is saved. Each data area of the file is cleared, then each data written in each recording area of the recording medium is sequentially read out in the order of the area number of the recording area, and each of the data files is read by the code number of the read data. Each code number of the data written before this data in the data area is searched, and the corresponding code number is searched as a result of this search. If there is not, the data area for storing each data having a code number larger than the corresponding code number is sequentially shifted one data area toward the larger area number, and the corresponding code number is shifted to the empty data area after the shift. Data is written on the other hand, and when the corresponding code number is searched as a result of the search, the data previously written in the data area having the corresponding code number and the data read from the recording medium later are written. The data is printed out as double-written data, and the data in the data area in which the corresponding coder number is written is rewritten to the data in the corresponding code number read out from the recording medium later. How to organize data in a data file.