JP4340412B2 - Data verification device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to data linkage between two or more information systems (including information processing apparatuses such as computers). In particular, the present invention relates to a method and an apparatus for performing verification for using data in another information system in data linkage in which data stored in the information system can be used in another information system.
[0002]
[Prior art]
In a corporate group or the like, a plurality of information systems are operated for each constituent company, and a program for performing data linkage such as data migration and unified management between information systems is required. The data linkage program acquires data from the information system that stores the original data, converts the data so that it can be input to another information system, verifies the data type / format, and writes the data . Hereinafter, an information system storing original data is called a source information system, and an information system to which data is written is called a target information system. Data type / format verification refers to data between the data acquired by the data linkage program from the source information system and converted, and the data type / format corresponding to the data within the target information system. Is defined as comparing the same type and format. Here, the data type is characters, numbers, binary, etc. The data format is, for example, year (Japanese calendar, era abbreviation)-month (2 digits)-day (2 digits) in date data This is a form of data representation.
[0003]
If the data linkage program does not verify the data type / format, incorrect data of the type / format may be input to the target information system, which may cause an error. By verifying the data type and format in the data linkage program, the possibility of generating an error can be reduced, and the entire plurality of information systems can be operated smoothly.
[0004]
[Problems to be solved by the invention]
In such a conventional method, the following problems remain.
[0005]
In the data linkage program, in the method in which only the data type and format are verified, it is verified whether the type and format of the input data are valid inside the target information system. However, since it is unknown whether the value stored as data is valid, an error may occur that the value is not valid inside the target information system. Here, “effective” defines that data is defined as a data value within the target information system, or is defined as not to be used as a data value. Conversely, invalid means that data is defined not to be used as a data value within the target information system, or is not defined as a data value.
[0006]
As described above, the conventional method has a problem that an error may occur because the data value is not verified.
[0007]
An object of the present invention is to provide a method for verifying the value of data. Hereinafter, in this patent, the data verification is the verification of the data value. Data value verification means between the data acquired by the data linkage program from the source information system and converted, and the valid or invalid data value in the data item corresponding to the data in the target information system, Define comparing data to see if the values are the same or if the values meet the criteria.
[0008]
[Means for Solving the Problems]
In the data verification in the data linkage program, the present invention acquires definition information used for verification from the target information system at the time of verification, and verifies the data using the definition information. Definition information is a value, a list of values, a range of values, or data that is added to the above values to define the status value of that value, and a criterion for determining whether certain data is valid or invalid Is a set of information. Here, the state value is an attribute value related to the state of the value, and is defined as a value serving as a reference for determining whether the value is valid or invalid. This definition information may differ depending on the data item to be verified. Further, by acquiring definition information used for verification from the target information system at the time of data verification, it is possible to solve a problem related to the freshness of the definition information. Here, the problem related to freshness is that when data verification is performed, definition information (assumed to be A) used for verification retained by the data linkage program and definition information retained by the target information system (temporarily The data that was determined to be valid using A at the time of data verification was written to the target information system because of the difference between the last update date and the content of the information. Sometimes, it is defined as a problem in which written data may become an error because it is already invalidated in B. The difference is mainly related to the last update date (freshness) of the data, so the term freshness is used.
[0009]
In addition, it supports connection information for connecting to the target information system, data model that describes the data type, format, meaning, etc. of the definition information, and multiple forms of definition information required to obtain this definition information. Three verification methods are defined in advance. At this time, the definition is facilitated by acquiring the information to be defined from the target information system at the time of definition.
[0010]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described in detail.
First, the components in FIG. 1 will be described. FIG. 1 is a configuration diagram showing an embodiment of a configuration when the present invention is applied to an accounting system.
[0011]
In FIG. 1, journal data 110 is stored in the source accounting system 100. The data conversion / verification program 130 is composed of a data conversion processing unit 140, a data verification processing unit 150, and error processing / data input 160. The data conversion processing unit reads the journal data 110 and the conversion table 120 and converts the data.
[0012]
Also, the converted data is sent to the data verification processing unit 150. The data verification processing unit 150 performs each process of a data comparison process 151 for comparing input data and definition information and a definition information acquisition process 152 for reading definition information 172 for comparison, and the definition data acquisition 152 defines It is characterized by having data 155 relating to acquisition of definition information, which is data necessary for reading information 172. The data verification processing unit 150 performs a comparison result notification process 153 for notifying the comparison result and a data type / format verification process 154 for verifying the data type and the data format. The data after the conversion / verification is written in the journal data 171 of the target accounting system 170 after error processing in error processing / data input 160. The definition tool 180 is a tool that acquires the definition data of the definition information 172 and defines the data 155 related to the definition information acquisition and the data conversion / verification program 130.
[0013]
Next, the block diagram showing the configuration of the source accounting system / target accounting system / data conversion / verification program / definition tool according to the present invention shown in FIG. 2 will be described.
[0014]
In FIG. 2, the source accounting system software 100 operates on the server computer 200, the data conversion / verification program 130 operates on the server computer 210, and the target accounting system software 170 operates on the server computer 220. The definition tool 180 operates on the client computer 230. In the present embodiment, four computers are used as shown in FIG. 2, but all may be performed by one computer.
[0015]
Also, two or three computers may be used by integrating processes performed by a plurality of computers. 1 and 2 show only one accounting system as a source and a target, but any number of accounting systems is targeted.
[0016]
Next, processing performed by the data conversion / verification program 130 in the configuration of FIG. 1 will be described with reference to the flowcharts of FIGS. 3, 4, and 5.
[0017]
The data conversion / verification program 130 reads the journal data 110 in the source accounting system 100 (step 300). The data conversion processing unit 140 acquires the conversion table 120 necessary for the conversion (step 310), converts the input journal data (step 320), and outputs the converted journal data to the data verification processing unit 150. The data comparison process 151 reads definition information 172 used for verification of the input data by the definition information acquisition process 152.
[0018]
For this purpose, the definition information acquisition process 152 first reads data 155 relating to definition information acquisition (step 400), extracts data for connecting to the target accounting system from the read data (step 410), and uses the data. To the target accounting system 170 (step 420), and the definition information 172 is read from the target accounting system 170 (step 430). The definition information acquisition processing 152 releases the connection with the target accounting system after reading the definition information 172 (step 440). The data comparison process 151 receives journal data and definition information (step 500), and compares input values (step 510). The storage method of the value in the definition information includes a case where a valid value is stored, a case where a pair of a value and its state value is stored, and a case where an invalid value is stored. Therefore, the comparison method (1) compares the input value with the value defined in the definition information to obtain a state value (step 520), and (2) a range of values in which the input value is defined in the definition information. There are three methods: obtaining the status value (step 530), (3) comparing the input value with the value defined in the definition information, and obtaining presence / absence (step 540).
[0019]
After the comparison, error determination is performed based on the comparison result whether there is a valid or invalid value or the state value in the definition information of the input value (step 550), and the result is notified to the outside of the data conversion program. (Step 350). The data type / format verification processing 154 verifies the data type such as the number of characters and whether the numeric value is an integer or floating point, and whether date data is expressed in the order of year-month-day of the four-digit year. The format is verified (step 360). After verification, error processing / data input 160 performs error processing such as discarding data determined to be an error (step 370), and inputs normal data to the target accounting system (step 380).
[0020]
Next, data transition in FIG. 6 will be described. FIG. 6 shows an example of journal data / conversion table / definition information and data transition processed in the above flowchart.
In FIG. 6, the journal data 600 includes items of date, account item, debit, and credit. However, one item may be included. Further, the journal data 600 may include items other than those described above.
[0021]
The conversion table 610 holds a correspondence relationship between the date notation of the source accounting system 100 and the date notation of the target accounting system 170. The data conversion processing unit 140 converts the date of the journal data 600 according to the conversion table 610, and generates the converted journal data 620. The date notation of the post-conversion journal data 620 is a value corresponding to the conversion table 610. The definition information 630 is a list of dates that are business days and state values corresponding to the values.
[0022]
In the data comparison 151, the date of the record of the converted journal data 620 and the record of the definition information 630 having the business day corresponding to the date of the data 620 are combined to create data like the comparison data 640. Based on the state value of the comparison data 640, determination data 650 describing normal / error determination results is created.
[0023]
In this example, the status value is expressed as a binary value of Yes / No, and Yes is determined as normal data, and No is determined as an error. The correspondence between the status value and normal data or error data is recorded in data 155 related to definition information acquisition. The state value can take one or more values. In error processing / data input 160, error processing is performed based on the determination result.
[0024]
In addition, in FIG. 6, verification of whether the date is a valid business day is described as an example, but in addition, data items expressed by one item such as account item, currency exchange, currency, product code, department code are verified. Is possible. Verification of data represented by a plurality of items will be described with reference to FIG.
[0025]
Next, FIG. 7, FIG. 8, and FIG. 9, which are diagrams corresponding to different verifications of definition information in FIG. 6, will be described.
[0026]
First, data comparison for verifying a plurality of values in FIG. 7 will be described.
In FIG. 7, the converted journal data 720 includes account items, departments, debits, and credits. However, one item may be included. The journal data 720 may include items other than those described above. In the definition information 730, a state value is defined for a record that combines two values of an account item and a department code. At this time, the number of items may be three or more. In the data comparison 151, the comparison data 740 is created by combining the account item / department of the journal data 720 and the corresponding data of the definition information 730 and the state value. Based on the state value of the comparison data 740, determination data 750 describing normal / error determination results is created.
[0027]
In this example, it is determined that the value 0 is normal and the value 1 is an error. The correspondence between 0 and 1 and normal / error is different for each definition information, and the correspondence between the status value and whether the status value is normal or error is recorded in the data 155 relating to the definition information acquisition.
[0028]
In FIG. 7, verification of whether the combination of the account item and the department code is valid is described as an example, but in addition to the account item and the department code, the date and exchange, the exchange and currency, the account and product code, the currency and Data items that can be defined as valid / invalid for multiple value pairs, such as department code, currency and product code, can be verified.
[0029]
Next, data comparison for verifying the range of the date and accounting period in FIG. 8 will be described.
In FIG. 8, the converted journal data 820 includes a date, account item, debit, and credit. However, one item may be included. The journal data 820 may include items other than those described above. The definition information 830 includes an accounting period name, an accounting period start date, an end date, and a status value that is a value indicating the status of the accounting period.
[0030]
In the data comparison 151, the date of the journal data 820, the corresponding data in the definition information 830, and the state value are combined to create comparison data 840. Although the state value in the comparison data 840 takes two values, Open and Close, it can take a plurality of values. At this time, the Open value indicates that the accounting period is valid, and the Close value indicates that the accounting period is invalid. Based on the status value of the comparison data 840, determination data 850 describing normal / error determination results is created. In the determination data 850, Open is valid and Close is an error, but the correspondence between the state value and normality / error differs for each definition information, and the correspondence is recorded in the data 155 related to the definition information acquisition.
[0031]
In FIG. 8, the verification of whether the date is included in the valid accounting period range is described as an example. In addition to the date, valid or invalid values such as exchange rate, account item, product code, etc. The data item to be defined can be verified. In addition, the definition information 830 may have one value as a comparison reference. At this time, in the definition information 830, either the lower limit or the upper limit of the value is set.
[0032]
Next, data comparison for verifying whether the currency code of the input data in FIG. 9 is valid will be described.
In FIG. 9, the converted journal data 920 includes a currency, an account item, a debit, and a credit. However, one item may be included. The journal data 920 may include items other than those described above. The definition information 930 includes currency code data items that are valid in the accounting system 170. In the data comparison 151, the comparison data 940 is created by combining the currency of the journal data 920 and the corresponding data of the definition information 930.
[0033]
In the comparison data 940, the same value is set in the valid currency item for data existing in the definition information 930, and a blank is set for data that does not exist. Based on the presence / absence of a valid currency item in the comparison data 940, determination data 950 describing normal / error determination results is created. In the determination data 950, the data existing in the valid currency is normal, and the data that does not exist is determined as an error.
[0034]
At this time, since only the value that is valid in the accounting system 170 is stored in the definition information 930, a blank is determined to be an error. In the opposite case, if only the value that is invalid in the accounting system 170 is stored in the definition information 830, it is determined that the blank is normal. This correspondence relationship is recorded in data 155 related to the definition information acquisition.
[0035]
In FIG. 9, the verification of whether the currency is valid is described as an example. However, in addition to the currency, a data item represented by a binary value indicating whether the value of the date, account item, product code, etc. is valid or invalid is taken. Can do. Also, data that can be expressed by a set of a plurality of values instead of a single value can be taken.
[0036]
6, 7, 8, and 9, the data items in the journal data are not limited to the illustrated items, and can include other items. In addition, all data items having values represented by letters or numbers can be verified.
[0037]
Finally, the screen configuration of the definition tool 180 will be described with reference to FIGS. FIG. 10 is an interface screen for defining data for acquiring definition information, and FIG. 11 is an interface screen for defining a data model of the definition information and error detection determination values.
[0038]
The target accounting system information acquisition screen 1000 is an interface for setting information for acquiring the definition information 172. On this screen, information such as a system name 1001 of the target accounting system, a location 1002 for specifying the location of the target accounting system, a user ID 1003 for correctly connecting to the system, and a password 1004 are input. Using this information, the definition tool 180 at the time of definition and the definition data acquisition 152 at the time of verification connect to the target accounting system 170 and acquire the definition information 172.
[0039]
The data model definition screen 1100 is an interface for defining the data model of the definition information 172. This screen includes a data model 1110 for specifying a data model of definition information to be defined, a data model for editing a data item of definition information selected in the data model 1110: a data item definition 1120, and error determination. A data model for setting a state value used for the purpose: a state value determination 1130.
[0040]
In the data model 1110, an identification ID, a system name 1001 that is information for connecting to the target accounting system 170 input in the target accounting system information acquisition 1000, and a definition information name for specifying arbitrary definition information in the definition information 172 1111 is entered. The definition information name 1111 corresponds to specific definition information in the definition information 172 used for data verification. In the data model: data item definition 1120, information such as a data item name, a data type, a data length, and a description is input for the definition information selected to be edited in the data model 1110. In the data model: state value determination 1130, a state value item name in the data model and a determination result for each state value stored in the item are input.
[0041]
Further, by selecting the definition information acquisition 1141, a part of the information defined in the data model: data item definition 1120 is used from the definition information 172 using the information defined in the data model 1110 and the target accounting system information acquisition 1000. get.
[0042]
Information defined using these interfaces is stored in data 155 relating to definition information acquisition. However, the definition information may be stored anywhere as long as the data comparison 151 can be used.
[0043]
In the above, description has been made by taking as an example data verification for error processing when journal data is acquired from the source accounting system 100, converted and verified, and written to the target accounting system 170. The present invention is not limited to an accounting system, and can be used for all information systems that require value verification. For example, when an order slip is input from the order management system to the accounting system, it is verified whether the transaction date is valid in the accounting system, or the customer order history information is also input from the order management system to the customer management system. In this case, it is possible to verify whether data such as a telephone number at the time of ordering matches that in the customer management system.
[0044]
The result of data verification can be used not only for error processing but also for changing the conversion table 120 and for changing the definition information 172. As an example of the former, when a new correspondence between account items is input in the accounting system, a means for updating the conversion table can be activated. As an example of the latter, when a telephone number mismatch is detected in cooperation with the customer management system, it is determined that the telephone number has been changed, and a means for updating the telephone number of the customer management system can be activated.
[0045]
According to the embodiment of the present invention, before data is written to the information system to be written, the data is verified using the definition information of the information system to be written to This eliminates the need for data verification and reduces the possibility of errors. Since the definition information may be in a different form depending on the type of verification, the difference can be dealt with by preparing information for acquisition corresponding to each verification and a verification method. Further, by acquiring the definition information from the information system to be written at the time of data verification, it is possible to eliminate the possibility of failure of data verification due to the problem of definition information freshness. In addition, when defining definition information, it is obtained from the information system to which information about definition information is written and defined based on it, reducing the possibility of mistakes when defining definition information Can be made.
[0046]
【The invention's effect】
According to the present invention, it is possible to reduce the occurrence of errors in data linkage.
[Brief description of the drawings]
FIG. 1 is an overall configuration diagram of an embodiment.
FIG. 2 is a block diagram showing a computer configuration.
FIG. 3 is a flowchart showing an embodiment of a processing procedure.
FIG. 4 is a flowchart showing an embodiment of a processing procedure.
FIG. 5 is a flowchart showing an embodiment of a processing procedure.
FIG. 6 is a data transition diagram.
FIG. 7 is a data transition diagram.
FIG. 8 is a data transition diagram.
FIG. 9 is a data transition diagram of FIG.
FIG. 10 is an interface and data model diagram.
FIG. 11 is an interface and data model diagram.
[Explanation of symbols]
100 ... Source accounting system 130 ... Data conversion / verification program 140 ... Data conversion processing unit 150 ... Data verification processing unit 151 ... Data comparison 152 ... Definition information acquisition 153 ... Comparison result notification 154 ... Data type / format verification 155 ... Definition information acquisition Data 160 ... Error processing / data input 170 ... Target accounting system 172 ... Definition information 180 ... Definition tool

Claims (3)

A data verification device connected via a communication line to a first information processing device capable of executing a first application and a second information processing device capable of executing a second application,
Means for connecting to the first information processing apparatus;
Means for reading, from the first information processing apparatus, first application data that can be used by the first application configured by records having data values corresponding to a plurality of data items;
Means for converting the read first application data into second application data including data values corresponding to a plurality of data items in a format corresponding to the second information processing apparatus;
Means for acquiring, from the second information processing apparatus, definition information indicating whether a data value corresponding to a predetermined data item is valid or invalid for processing of the second application;
Means for comparing the converted data value with the definition information and verifying whether the data value corresponding to the data item is valid or invalid when there is a data item indicated in the definition information When,
As a result of the verification, if the data value is invalid, the entry including the data value is not transmitted to the second information processing apparatus, and if the data value is valid, the entry including the data value is A data verification apparatus comprising: a transmission control means for transmitting to the second information processing apparatus. The data verification device according to claim 1,
The data verification apparatus characterized in that the verification means executes the verification by a verification method corresponding to each of the plurality of data items. In the data verification device according to any one of claims 1 to 2,
The definition information includes information indicating whether the value corresponding to a predetermined data item is a valid range or an invalid range,
The data verification apparatus characterized in that the verification means verifies whether a value included in the converted data is included in the range .

Images