JPH11143857A - Year data management system and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a year data management system and a recording medium capable of simply dealing with the problem of A.D. 2000 by leaving an application which deals with a year by two digits as it is, providing a filter processing means between files and the like to which the application accesses, using up to the maximum numbers of month two digits without changing an attribute (or a format) and performing a conversion/inverse conversion in write and read. SOLUTION: This system is composed of a means 1 for inputting and outputting year two digits and month two digits and a filter processing means 8 that, with regard to the inputted year two digits and month two digits, converts year 99 and the year two columns into the month two digits when the year two digits are below a year 07 and writes it in a file 10 and, on the other hand, reverse-converts the month two digits below month 12 by the year two digits and the month two digits and outputs it.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a year data management device and a recording medium for managing data with a two-digit year.

[0002]

2. Description of the Related Art Conventionally, year data in a file asset such as a database created in the COBOL language or the like uses only the last two digits of the year of the Christian era.
When the 000's were mixed, the comparison of magnitude was not correctly processed. For the year 2000 to process correctly, the corresponding application and files, such as the year 2
The digit representation was corrected to the four-digit representation of the Christian era, and the year order was correctly processed in the magnitude judgment and rearrangement processing. The change required an expert and required a lot of migration costs and preparation time.

[0003] In addition, since the file asset conventionally handles the year using two digits, changing the number to four digits requires a sufficient amount of resources since resource expansion is required.

[0004]

As described above, in the conventional assets in which the Christian era is treated with two digits, changing the Christian era to four digits requires an increase in the number of work steps and resources for the change. There was a problem that an extremely large number of man-hours and expansion of resources were required as measures for the year 2000.

[0005] The present invention solves these problems,
The application and resources that handle the year with two digits are left as they are, and a filter processing unit that performs conversion processing with the file etc. accessed by the application is provided, and the maximum number of two digits per month can be used without changing the attribute (format) Then, conversion / reverse conversion is performed at the time of writing / reading, and the purpose is to easily realize compliance with the year 2000.

[0006]

Means for solving the problem will be described with reference to FIG. In FIG. 1, the filter processing means 8 manages data with two digits for the year and two digits for the month. Here, if the two digits for the year are 07 or less at the time of writing, they are converted to 99 digits for the year and two digits for the month. In the case of a year 99 at the time of reading, the two-digit month is inversely converted to the month 12 or less by the two-digit year and the two-digit month.

The two-digit year input by the filter processing means 8;
Regarding the two-digit month, if the two-digit year is less than or equal to 07, the year 99 and the two-digit year are converted to two-digit month and written to the file. On the other hand, if the two-digit year read from the file is the 99 year, Two-digit month and two-digit year and two-month are inversely converted to 12 months or less for output.

[0008] When data of the year 2000 or more is input, the conversion processing means sets 99 as year data and converts month data in accordance with the difference between the input data and December 1999. Output.

Therefore, an application that handles a year with two digits is provided with a filter processing means 8 provided between the application and a file accessed by the application, and is written using the maximum number of two digits of the month without changing the format. / Convert when reading /
By performing the inverse conversion, it is possible to easily realize the year 2000 compliance.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment and operation of the present invention will be described in detail with reference to FIGS. Here, a program read from a recording medium (not shown) or a hard disk device as an external storage device, or a program transferred from an external storage device of the center via a line is loaded into the main storage and activated. Performs the various processes described in FIG.

FIG. 1 shows a system configuration diagram of the present invention.
In FIG. 1, the input device / keyboard 1 indicates a year (A.D.).
Is entered in the last two digits and the month in two digits, such as a keyboard.

The display device / display 2 has a year (AD)
Is displayed in two digits and the month is displayed in two digits, or input from the screen. The output device / printer 3 outputs the year (AD) in two digits and the month in two digits, and is, for example, a printer.

The input / output device 4 is for inputting / outputting the two-digit year and the two-month data obtained by converting the two-digit year and the two-month data. For example, the input / output device 4 is various storage devices and stores the data of the DB 10 as it is. It is for doing and so on.

The processing device 5 performs various processes in accordance with the program 6, and here, the program A, the filter processing means 8, the general-purpose program 9 and the like operate as shown.

The program A7 is a conventional business program for processing the year (AD) with two digits and the month with two digits (processing such as threshold value processing, comparison, and calculation of the year / month). This is a business program that can be processed normally within the program 99.

The filter processing means 8 converts the two-digit year and two-digit year data received from the program A7 for processing in the year 00 to 99 into the year described later and writes the converted data to the DB 10 or the data read from the DB 10 Is converted back to the Christian era data to be described later and passed to the program A7.

The general-purpose program 9 is a program for handling the converted Christian data, accesses the DB 10 storing the converted Christian data, passes the data of the DB 10 to the input / output device 4 as it is, or For example, data from the output device 4 is written in the DB 10.

The DB 10 is a database, and is an example of a file for storing converted Christian data according to the present invention. By providing the above-described configuration, in the present invention, as described in the lower right, even if the Christian data is a key, the inversion phenomenon does not occur.
For this reason, the year 2000 data in the DB 10
Even if it exceeds the year, processing such as sorting can be performed in the same manner as before until 2007.

The conventional program can easily correspond to the year 2000. The general-purpose program 9 can also process the data (even if there is no filtering process, since the Christian era data in the DB is an external decimal number, it can be handled without inversion in the data size comparison judgment). The details will be sequentially described below.

FIG. 2 is a diagram for explaining the operation of the present invention. First, the write operation to the DB will be described according to S1 to S5 in FIG. In FIG. 2, S1 makes a key input (for example, "Year / Month 11") to the program A7 in FIG.

In step S2, calculation processing is performed. In this case, various business processes are performed using a conventional two-digit year and two-digit month of the year 00/11. In step S3, a writing process 61 is executed.

In step S4, in response to the execution of the write processing 61 in step S3, the filter processing means 8 performs WRITE conversion to convert the data into "99/23". As will be described in detail later with reference to FIG. 3, the month 23 is obtained by substituting year = 99, month = (year + 1) × 12 + month, and is converted into “year 99/23”.

S5 is "September 2" after the conversion in S4.
3 ”is written in the DB 10. This“ September 23, ”
Actually, it represents "November 2000 AD". As described above, the conventional year 2 digits and month 2 digits (for example, “year 00/11”) are converted to the year 2
Two digits of the month (for example, “September 23”) can be stored in the DB10, and even if it exceeds 2000, it can be stored in the DB10 in the conventional format (two digits of the year, two digits of the month) until 2007. Becomes

Next, according to S11 to S14 of FIG.
The reading process from the DB will be described. S11 in FIG. 2 indicates that the reading of the data corresponding to November 2000 is designated by the program A.

In step S12, corresponding to the execution of the reading process 62 in step S11, a corresponding two-digit month and two-digit (for example, "99/23") is read from the DB 10. S13 is S12
2 digits of month read out in 2 digits of month (for example, "99/23")
Is inversely converted by READ conversion to return to the original two-digit year and two-digit month (for example, “Year / Month 11”).

In step S14, various calculation processes are performed using the two-digit year and two-digit year (for example, "Year / Month 11") after the inverse conversion in S13. As described above, the two-digit year and two-digit year read from the DB 10 are converted back to the original two-digit month and two-digit number (for example, “year 00/11”), and then converted to the conventional format (two-digit month and two-digit year). ) Can be used to perform various calculation processes (such as threshold processing, comparison processing, and arithmetic processing).

FIG. 3 is a diagram for explaining the processing of the write conversion unit according to the present invention. This is because the filter processing means 8 of FIG. 2 replaces the conventional year data (two digits of year and two digits of month) with two digits of year and two months of the present invention.
It shows the procedure for converting to a digit in detail.

FIG. 3A shows a flowchart.
In FIG. 3A, S21 determines whether year <7.
It is determined whether the value of the last two digits of the four digits of the year is 07 or less. In the case of YES, the process proceeds to S22. In the case of NO, it is out of the scope of the present invention, and the process ends.

In step S22, the month is calculated by substituting into the following equation: month = (year + 1) × 12 + month (Equation 1).

In step S23, the year is set as follows: year = 99 (formula 2)

As described above, it is possible to convert the above-described conventional two-digit month and two-digit year of FIG. 2 into two-digit year and two-month month according to the present invention. FIG. 3B shows a specific example of the write processing of the present invention.

Here, in the case of “January 03”, year = 99 (determined by equation 1) Month = (year + 1) × 12 + month = (01 + 1) × 12 + 03 = 27 (determined by equation 2) Is calculated.

Therefore, after the conversion, the date is "September 27". FIG. 4 is a diagram for explaining the processing of the read conversion unit of the present invention. This is the procedure when the filter processing means 8 of FIG. 2 reversely converts year data of two digits and two digits of the year according to the present invention read from the DB 10 to conventional Christian data (two digits of year and two digits of month). This is shown in detail.

FIG. 4A shows a flowchart.
In FIG. 4A, S31 determines whether month> 12. This determines whether the two-digit month of the two-digit year and two-digit month according to the present invention is greater than twelve. If YES, S
Go to 32. In the case of NO, it is out of the scope of the present invention, and the process ends.

A step S32 decides whether the year = 99. In the case of YES, it is determined that the year data is a two-digit year and two-digit year data according to the present invention, so the flow proceeds to S33. In the case of NO, it is out of the scope of the present invention, and the process ends.

In step S33, the year is obtained by substituting into the following equation: (year = (month-1) ÷ 12 quotient-1) (Equation 3)

In step S34, the month is calculated by substituting into the following equation: month = (month-1) ÷ the remainder of 12 + 1 (Equation 4).

As described above, the two-digit year and two-digit year according to the present invention shown in FIG. 2 can be inversely converted into the conventional two-digit month and two-digit year. FIG. 4B shows a specific example of the read processing of the present invention.

Here, in the case of “September 27”, year = (month−1) ÷ 12 quotient−1 = (27−1) ÷ 12 quotient−1 = 2-1 = 1 (expression・ Calculate as follows: Month = (Month−1) ÷ Remainder of + 1 + 1 = (27−1) ÷ Remainder of 12 + 1 + 1 = 2 + 1 = 3 (Calculated from Equation 4)

Therefore, after the inverse conversion, it becomes "January 03". FIG. 5 is an explanatory diagram of a database to which the present invention is applied. FIG. 5A shows an example of a database file. The logical file structure of the database file is an index organization, a relative organization, a sequential organization sort and merge, and shows an example in which a key portion has a date item.

In the case of the index organization, as shown in the figure, a key section has an item of year and month, and corresponding data is stored using the designated year and month as keys. Since the key portion contains the date data, the data of the data portion corresponding to the designated date can be read and written using the conversion processing of the present invention.

FIGS. 5B and 5C show specific examples of the conversion. FIG. 5B illustrates the description of the READ conversion.・
Precondition: month> 12 AND year = 99. This is because the converted 2-year year 2-month year data according to the present invention has the month set to 12 or more to 99 and the year = 99, and thus these conditions are determined. .
To convert the two-digit year and two-digit year data according to the present invention back to the original conventional two-digit month and two-digit year, as described above (Equation 3),
Inverse conversion is performed by the following (Equation 4).

Year = (Month-1) ÷ 12 quotient−1—Month = (Month−1) ÷ Remainder of + 1 + 1 For example 1) In the case of “September 13”: Year = (13 -1) Quotient of $ 12 -1 = 1-1 = 0-Month = (13-1) Remainder of $ 12 + 1 = 0 + 1 = 1. After inverse conversion, it becomes "00/01".

Example 2) In the case of "99/47", the quotient of year = (47-1) / 12 is -1 = 3-1 = 2. The remainder of month = (47-1) / 12. + 1 = 10 + 1 = 11, and becomes “February 11” after the inverse conversion.

FIG. 5C illustrates the WRITE conversion. -Precondition: year <7. This is because, of the conventional 2-digit year and 2-digit year data before conversion, year = 07 (200 AD)
7 years) The following are prerequisites. In order to convert conventional 2-digit year / month 2-digit year data into 2-digit year / month 2-digit according to the present invention, conversion is performed by the following (Formula 1) and (Formula 1) described above.

Year = 99 Month = (year + 1) × 12 + month For example 3) In case of “Month 01”, year = 99 Month = (year + 1) × 12 + month = (00 + 1) × 12 + 0
1 = 13, and after conversion, it is “99/13”.

Example 4) In the case of "February 11", year = 99 month = (year + 1) × 12 + month = (02 + 1) × 12 + 1
1 = 47, and becomes “September 47” after the inverse conversion.

When the conventional two-digit year and two-digit year in the Christian era are converted to two-digit year and two-digit year by the conversion according to the present invention, a fixed value of "year 99" is obtained by (Equation 2) described above. After setting (converting),
Without being limited to this, 00, 0 that have no meaning after conversion
One or any of these numbers, including 1, 02, 03, 04, 06, 07, and 99, may be used for the two digits of the year (if used, the reverse is of course the case). The number used at the time of conversion will be inverted instead of 99.)

[0049]

As described above, according to the present invention,
Regarding the input two-digit year and two-digit month indicating the year, when the two-digit year is less than or equal to 07, the year 99 and the two-digit year are converted to two-digit months and written to a file such as a database.
When the two-digit year read from the file is the year 99, a configuration is adopted in which the two-digit month is inversely converted to a month of 12 or less with two-digit year and two-digit month and output. Therefore, even if data of more than 2000 AD is input and data before 1999 is mixed with data on the database, the data length is not changed,
It is possible to correctly process the order of size determination and sorting of year data on a database.

The application that handles the year with two digits is left as it is in the past, and the filter processing means 8 is provided between the application and the file to be accessed to use the maximum number of two digits per month without changing the format. Conversion / inverse conversion is performed at the time of writing / reading, so that the year 2000 can be easily realized.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of the present invention.

FIG. 2 is a diagram illustrating the operation of the present invention.

FIG. 3 is an explanatory diagram of a write process according to the present invention.

FIG. 4 is an explanatory diagram of a read process according to the present invention.

FIG. 5 is an explanatory diagram of a specific example of the present invention.

[Explanation of symbols]

 1: input device / keyboard 2: display device / display 3: output device / printer 4: input / output device 5: processing device 6: program / application 7: program A 8: filter processing means 9: general-purpose program 10: DB / file 11: I / O device

 ──────────────────────────────────────────────────続 き Continued on the front page (72) Inventor Tadashi Saito 2-1-1 Minato Mirai, Nishi-ku, Yokohama-shi, Kanagawa Prefecture Fujitsu Keihin System Engineering Co., Ltd.

Claims (4)

[Claims] 1. A year data management device for managing data with a two-digit year, means for inputting / outputting a two-digit year and a two-digit month; Is year 0
If the value is 7 or less, the year 99 and the corresponding two-digit year are converted to two-month digits and written to the file. On the other hand, if the two-digit year read from the file is the year 99, the two-month month is converted to two-year and two-digit months. And a filter processing means for inverting the data to a month or less and outputting the result. 2. In a year data management apparatus for managing year data with the last two digits of the year, when data of year 2000 or more is input, 99 is set as year data, and the input data and 19
An year data management device comprising a conversion processing means for converting and outputting month data according to a difference from December 1999. 3. A recording medium recording a year data management program for managing year data with the last two digits of the year by a computer, wherein when data of 2000 years or more is input, 99 is set as year data. Along with the entered data and 19
A recording medium on which a year data management program is recorded, wherein month data is converted and output according to a difference from December 1999. 4. A means for inputting and outputting a two-digit year and a two-digit month; and for the input two-digit year and a two-month month, the two-digit year is the year 0.
If the value is 7 or less, the year 99 and the corresponding two-digit year are converted to two-month digits and written to the file. On the other hand, if the two-digit year read from the file is the year 99, the two-month month is converted to two-year and two-digit months. A computer-readable recording medium on which a program for functioning as a filter processing means for inversely converting the data to 12 or less and outputting the data is stored.