KR100566935B1 - System and method for detecting input data error - Google Patents

Abstract

An input data error verification system and method is disclosed. The input data error verification system is a data receiver which receives the input data, and data which is repeatedly inputted with the same data multiple times through the data receiver, and which receives confirmation input for a mismatched data item when the duplicated input data do not coincide with each other. It includes a processing unit. In addition, the data processor may receive a confirmation input for a data item that violates a predetermined rule among the input data. As a result, error data input by mistake or error of an inputter as well as error data input due to an original data error can be prevented by validating the data, thereby creating a more reliable database.

Data, error, validation, duplicate entry, record, grade

Description

System and method for detecting input data error}

 1 is a schematic block diagram of one embodiment of an input data error verification system in accordance with the present invention;

FIG. 2 is an example of a data input screen displayed on the data input terminal of FIG. 1.

3 is another example of a data input screen displayed on the data input terminal of FIG. 1;

4 is a schematic flowchart for performing an input data error verification method according to the present invention;

The present invention relates to an input data error verification system and method. More particularly, the present invention relates to a system and method that prevents input of error data during database construction, thereby enabling only accurate data storage.

 With the development of computer environment, most of the data is input, stored and managed by computer. Accordingly, the user of the data can easily access the data, and thus can conveniently search for and withdraw the necessary data.

However, in order to use the stored data safely, the reliability of the data is required in addition to the accessibility of the data. That is, the user of the data should be able to trust that the stored data is correct data.

Accurate data is made possible by preventing the entry of error data, which is caused by an error in the original data or a mistake of the data entrant during data entry.

The computerization of these data is fast progressing in academic administration, especially in the computerization and academic departments of students and graduates. The register of records and records are valuable data that must be preserved forever, so the credibility of the data will be important.

However, the error of data due to the input of error data also occurs during the computerization of the school register or the school records, and the reliability of the data is reduced. This possibility of error data input is higher in the case of the input of the vast amount of data which is not computerized in the past.

 The present invention has been made to solve such a conventional problem, and to provide an input data error verification system and method that can prevent the input of error data to build a more reliable database.

In order to achieve the above object, the input data error verification system according to the present invention is a data receiver which receives the input data, and if the same data is repeatedly input a plurality of times through the data receiver and the duplicated input data do not match with each other, It includes a data processing unit for receiving a confirmation input for the data item.

This configuration makes it possible to detect the input of error data due to a mistake of the inputter by receiving the same data a plurality of times and comparing the data input at different times with each other. The system can receive the correct data by having the data inputter re-enter confirmation input for data items that are inconsistent with each other.

The confirmation input may be a re-entry of inconsistent data items, a positive or negative for a recently entered data item, or any form of input that allows you to check the data values of other inconsistent data items. It is possible.

The data processing unit may receive a confirmation input for a data item that violates a predetermined rule among the input data, and the predetermined rule may be set by using a relationship between the input data items. Not only the error data input by error input by the user but also the error data input due to the error of the original data can be detected, and the user who is not used to the input data can input the error-free data.

The predetermined rule is that if some items of data contain valid range information of some other data items, some other data items exist within the valid range, or if some items of data contain the same information, the content of the information may be Or the frequency of the data values of some items of data may be below a predetermined number of times.

In addition, if some items of data contain the same information and all of the information values do not match, the information can be matched with the most matching information value. It is possible to correct an error using only existing data without requesting input of new data.

The data can be either academic or sexual data and can be sent over the Internet. Since it can be input through the Internet, it is possible to receive a service for inputting data without error at a remote location.

In addition, an invention in which the input data error verification system according to the present invention is implemented in the form of a method is disclosed.

Hereinafter, exemplary embodiments of the present invention will be described with reference to the accompanying drawings.

1 is a schematic block diagram of one embodiment of an input data error verification system in accordance with the present invention.

In FIG. 1, the input data error verification system 100 is connected to the data input terminal 200 through the communication network 300, and therein, the data receiving unit 110, the data processing unit 120, and the data storage unit 130. , And command transmission unit 140.

The data receiver 110 receives data input from the data input terminal 200. The data processing unit 120 receives the same data multiple times through the data receiving unit 110 repeatedly, and receives a confirmation input for a mismatched data item when the overlapped data does not coincide with each other.

When inputting data for computerization of data, the data on the original data is fine, but error data may be input by mistake or mistake of the data inputter.

In this case, when the same data is input a plurality of times, and the same data input at each time is compared with each other, an error input can be detected when a different data item is found.

The number of inputs is generally two, but more than three inputs are possible. Also, if the data entered in different times are not the same, it is preferable to request confirmation or re-entry of different data items, but the number of initial inputs is three or more times and the data values of the same data items do not all match. In this case, it is also possible to configure the data value of the data item as the most matched data value.

The command transmitter 130 transmits a data re-input command to the data input terminal 200 when data re-input is required by the data processor 120, and the data storage unit 140 checks the input data and error verification. Save finished final data.

In the present embodiment, the data receiver 110 and the command transmitter 130 are implemented as separate devices, but other embodiments may be implemented in the same device.

The data processor 120 may receive a confirmation input for a data item that violates a predetermined rule among the input data. This is not to judge the data input error but to determine the validity of the data itself.

The error data is detected according to a predetermined rule, so that not only the user's error input but also the error data due to the error of the original data can be detected, and even an inputter who does not have expertise in the input data field can input the correct data. do.

The predetermined rule may be set by using the relationship between the input data items, thereby allowing the error to be detected only by the input data.

The predetermined rule may be that some other data items are within the valid range if some items of data contain valid range information of the other some data items.

The valid range may be a range in which a data item may exist or may be a range of data values of the data item.

2 and 3 are examples of a data input screen displayed on a display screen of the input terminal of FIG. 1, respectively.

The input data may be grade data or grade data, and FIGS. 2 and 3 are screens for inputting grade data and grade data, respectively. In FIG. 2 and FIG. 3, the screens for inputting the grades and grades are separately displayed, but the grades data and grades data may be crossed with each other to determine an error input.

 Names, universities, and the like shown in FIG. 2 are individual data items of the academic data, and Kim Jong-nam and family universities indicated in the data items are data values of the data items.

For example, the high school graduation date contains information about the validity of the college entrance date. In other words, the date of college entrance cannot be earlier than the date of high school graduation. Similarly, college graduation days also include coverage information for college admission dates.

If the university entrance date is input before the high school graduation date or after the university graduation date, the data processor 120 detects an error of the data.

As another example, the graduation date of the graduates shown in FIG. 3 is February 23, 1998. If the grade of the graduate, which is the data value, is recorded in the first semester of 1998, the data item 120 also detects an error of the input data because it is also outside the valid range of the data item.

The first example above is an example of determining an effective range of a data value of a data item, and the second example is an example of determining an effective range of a data item itself.

The predetermined rule may be that the contents of the information match when some items of data include the same information.

For example, the first six digits of a social security number contain information about the person's date of birth, the first digit of the last digit is gender information, the second to fifth digits of the birth notification area, and the sixth digit of the birth declaration within that area on the day of birth. Contains information.

If the gender of the graduate of FIG. 2 is entered as a female and the gender information included in the social security number is a male, the data processing unit 120 detects an error of the input data.

In another example, if the gender of the graduate is a male and the high school of the graduate is a high school girl, the data processing unit 120 also detects an error of the input data.

The data item including the same information may be a data item directly input, or may be a data item calculated using the data input by the data processor 120.

For example, the data processor 120 may determine an error input by comparing a data item calculated using data items of individual graduates who have completed a predetermined course with data items calculated from other data items described in the register.

Further, the predetermined rule may be that the frequency of the data value of some items of data is below a predetermined number of times.

For example, if few graduates have completed the courses, other graduates rarely complete the courses, and the courses completed by some graduates have a high probability of error entry.

The predetermined number may be set uniformly or may be set as a ratio for the data item on the entire register.

If some items of data contain the same information and all of the information values do not coincide with each other, the information may be matched with the most matching information value among the data items without receiving the data item again.

 In this case, the error can be corrected only with the existing data without requiring the data inputter to input new data again to correct the data.

However, this process can be applied when there are a large number of data items containing the same information. This is because the larger the number of data items including the same information, the higher the probability that the correct data is larger than the error data.

As an example of validating input data due to an error of original data, the following may be considered.

High School Graduation or Admission (Enrollment) Date Verification, Gender Verification, Graduation Count Verification, Certificate Number Duplication, Degree Certificate Duplication, Graduation Thesis, Registration Later than Graduation Year, First Year of Graduation Validation of enrollment, enrollment for the first semester of the second semester, enrollment prior to the date of enrollment (entry), verification of discrepancies between the date of enrollment and the initial enrollment year, and verification of inconsistency between the applicant and his / her father may be considered.

Grade test, year, semester, classification, course, credit, grade verification, grade year verification, total grade verification by semester grade, verifiers, total grade credit verification, seasonal semester verification, completion division verification, ledger error verification Etc. may be considered.

In addition, subjects can be verified by subjects, undergraduate or graduate subjects, corrected subjects, duplicated subjects, new subjects, year-by-year subject division verification, curriculum change verification, and subject list verification. In this regard, we can consider verifying the list of all new courses, verifying the list of all undergraduate courses, verifying the list of new undergraduate courses, verifying the list of all new courses, and verifying the list of revised courses.

The verifications given above are merely examples and any other data item and data applicable to those skilled in the art may be considered.

Data can be transmitted over a communication network, especially the Internet. Since the input of data may be performed via the Internet, the data input terminal 200 may perform data input from a remote location away from the system 100.

Not only does the system 100 of the present invention provide a service for preventing error data input by itself, but also the data input terminal 200 is connected to the system 100 at a position away from the system 100 so that the system 100 Because the service provided by) can be used, even non-experts can input data easily and accurately at their workplace.

4 is a schematic flowchart for performing an embodiment of an input data error verification method according to the present invention.

First, in FIG. 4, the same data is repeatedly input plural times (410). The number of inputs is generally two, but may be three or more times.

Next, the data input in each time is compared with each other in the same data item (420). If the duplicated input data does not match with each other as a result of the comparison, a re-input is requested for the mismatched data item and received again (430).

In the present embodiment, a configuration for receiving re-input for an inconsistent data item is made, but in another embodiment, a different form of confirmation input for an inconsistent item may be received.

Once the input error by mistake or error of the data inputter is verified, the input data is validated (440). The validity check is to check whether there is a data item in the input data that violates the preset rule, and to detect error data due to an error of the original data itself, not an error by the data inputter.

The predetermined predetermined rule may be set by using the relationship between the input data items. If some items of data include valid range information of other some data items, the other some data items exist within the valid range. When some items of data include the same information, the information may be identical, or the frequency of data values of some items of data may be below a predetermined number of times.

If there is a data item that violates a predetermined rule as a result of the inspection, a request for re-entering the data item is received and input again (450). Similarly, in this embodiment, a configuration for re-input of an inconsistent data item is made, but in another embodiment, a different type of confirmation input may be received.

Although not shown in FIG. 4, when some items of the data include the same information and the information values do not all match instead of the process of re-entering the data item 450, the data that does not match the most matched information value does not match. You can also perform the process of matching the information of the items.

This process requires more attention because more data items containing the same information are more accurate, but less data items are less accurate.

The input data can be either academic or sexual data, particularly useful for large amounts of historical data that have not been computerized.

In addition, the input data error verification process may be performed in a separate terminal, but may also be performed between the client and the server through a communication network, in particular, the Internet. In the case of data input through the Internet, accurate data can be input even at a remote location, so non-specialists can input reliable data at their own location.

Finally, the reliable input data in which the error input and the data are validated are stored in the database (460).

According to the present invention, it is possible to prevent the input of error data due to an error of an inputter and error data due to an original data error, thereby constructing a more reliable database.

In addition, since error-free data can be input from a remote location via the Internet, even an expert on the input data can directly input data without error.

Although the present invention has been described in terms of some embodiments of the invention, the scope of the invention should not be limited thereby and should be constrained by modifications or improvements of the above embodiments supported by the claims.

Claims (20)

A data receiving unit which receives the input data; And An input data error verification system for constructing a database including a data processing unit which receives the same data multiple times through the data receiving unit repeatedly, and receives confirmation input for an inconsistent data item when the input data does not coincide with each other. , And the data processing unit receives a confirmation input for a data item in violation of a predetermined rule set by using the relationship between the input data items among the input data. delete delete The method of claim 1, And said predetermined rule is that said some other data items are within said valid range when some items of said data contain valid range information of some other data items. The method of claim 1, The predetermined rule is input data error verification system, characterized in that the content of the information is matched when some items of the data contain the same information. The method of claim 1, And the predetermined rule is that a frequency of data values of some items of the data is below a predetermined number of times. The method of claim 1, And the data processing unit matches the information with the most matching information value when some items of the data include the same information and do not all match the information values. The method of claim 1, And wherein the data is historical data. The method of claim 1, And the data is grade data. The method of claim 1, The input data error verification system, characterized in that the input data is received via the Internet. Receiving the same data multiple times repeatedly; And An input data error verification method for constructing a database comprising receiving a confirmation input for a mismatched data item when the duplicated input data do not coincide with each other. And receiving a confirmation input for a data item that breaches a predetermined rule set by using the relationship between the input data items among the input data. delete delete The method of claim 11, And the predetermined rule is that some other data items exist within the valid range if some items of the data include valid range information of other some data items. The method of claim 11, The predetermined rule is input data error verification method, characterized in that the content of the information is matched when some items of the data includes the same information. The method of claim 11, And the predetermined rule is that a frequency of data values of some items of the data is below a predetermined number of times. The method of claim 11, And when some items of the data include the same information and the information values do not all coincide with each other, the information is matched with the most matching information value. The method of claim 11, And the data is historical data. The method of claim 11, And the data is grade data. The method of claim 11, The input data error verification method, characterized in that receiving the transmission via the Internet.

Images