KR100415173B1 - Method for a automatic standardization of a client information by comparison and analysis of change data using refirement control system of data - Google Patents

Abstract

The present invention relates to an automatic standardization method of customer contact information which allows standardization, duplication and householdization of data by automatic standardization of data changed by comparing a plurality of customer database information.

The automatic standardization method of customer contact information according to the comparative extraction of the variation data using the data purification management system of the present invention is performed by processing the string of the input information when the data by the customer's contact information is input through the customer's input or an external database. Selecting a table to be analyzed, a reference table corresponding to an information table broken down for each customer data, and calling a comparison of the character strings stored in the reference table with information for each item of the customer data; Cleaning and automatically changing data of the customer contact information data based on a standardized character string of the user; generating refinement data; generating refinement data for another reference database in the system; and refining data by name. to Deduplication processing by deleting or consolidating duplicate records by item in a table and sorting by item, and data furniture by furniture duplication based on residential information of customer data assigned with administrative code in the data refining step. It consists of a sequential configuration.

The automatic standardization method of customer contact information according to the comparative extraction of the variation data using the data refining management system of the present invention establishes a standardized database by refining contact data including various personal information of a plurality of customers, In addition to enabling efficient customer marketing, there is an advantage that can increase the efficiency of the marketing program generated later by maximizing the utilization of the optimization of the marketing database.

Description

Method for a automatic standardization of a client information by comparison and analysis of change data using refirement control system of data}

The present invention is to standardize, duplicate and furniture the data by automatic standardization of data changed by comparing a plurality of customer database information, more specifically, input data by the customer contact information is name, address, telephone number The standardized reference database is created by subdividing each item into a standard table by data correction and addition and garbage processing through a reference table. The data is integrated by extracting the matched information of the integrated data, and by updating the residence information by checking the latest change data by tracking, so that the accuracy of the initial contact information can be improved. Contact with information It is about automatic standardization of customer contact information by comparing and extracting fluctuation data using the data refining management system that enables the standardized database to be constructed through data processing and efficient customer marketing using the purified database information. In general, customer data is accumulated in customer-targeted companies, but these data are managed in different forms according to their source and use, which makes it difficult to effectively organize and integrate these data. In addition, in many cases, because of the high rate of movement in Korea (25% per year), the customer address or telephone number is not properly updated, and many excellent customers are just sitting and lost.

In the current contact information data management, there is no system that standardizes company-wide due to various and exceptions, and the existing technology for analysis and management for customer marketing is a method of identifying and modifying visually. In some cases, customer contact information was not managed because of the cost and time wasted.

As a result, many companies are confident about the volume of their data, but they are not confident about the integration of the entire customer data, as well as the true customer information of actual accuracy, freshness, and redundancy.

Accordingly, the present invention was devised to solve the above-mentioned disadvantages and problems in the conventional customer management system, and the first input data based on the customer contact information is broken down by item so that data correction and addition and garbage through the reference table can be made. A standardized reference database is created by data purification of garbage processing, and the data obtained by the comparison and extraction of the reference database information is subjected to the redundancy processing of a single data and the furniture generation by matching information extraction of integrated data. It is an object of the present invention to provide a method for automatically standardizing customer contact information according to comparative extraction of variation data using a data purification management system that enables efficient customer management using purified database information.

In addition, another object of the present invention is not only to secure the accuracy and diversity of customer information by standardizing, integrating, and furnishing contact information of customer data, but also to manage e-mail standardization and residential analysis according to each company's needs. The addition of local codes and the addition of an optional process to distinguish work addresses in the address section.

1 is an overall system configuration of a method for automatically standardizing customer contact information according to the present invention.

2 is a flow chart illustrating a sub-process for processing standardized partial social security numbers in accordance with the present invention.

3 is a flow chart showing a subprocess in which the name of standardization is processed in accordance with the present invention;

Figure 4 is a flow chart illustrating a subprocess in which the telephone number of standardization according to the present invention is processed.

Figure 5 is a flow chart illustrating a subprocess in which the postal code of standardization according to the present invention is processed.

Figure 6 is a flow chart illustrating a subprocess for processing address entries of normalization in accordance with the present invention.

Fig. 7 is a flowchart showing the administrative code processing subprocess of standardization according to the present invention.

Fig. 8 is a flowchart showing a subprocess for standardizing E-mail processing information according to the present invention.

9 is a flow chart illustrating a sub-process for redundant processing of standardization in accordance with the present invention.

10 is a flow chart illustrating a subprocess for the integration of standardized data in accordance with the present invention.

Figure 11 is a flow chart illustrating the subprocess of data furnishing in accordance with the present invention.

The above object of the present invention is a step of selecting a table of the data analysis work target by processing the string of the input information when the data by the customer input or contact information of the customer through the external database is selected, and broken down by customer data A reference table corresponding to the information table is called to compare the information stored in the reference table with item-specific information of the customer data, and to clean and data the customer contact information data based on the standardized character string of the reference table. An automatic change is performed to generate purified data, the purified data is sequentially sorted by item based on a name, and a duplicater processing step is performed by deleting or consolidating a duplicate record for each item in a table; Home of coded customer data It is achieved by including a step of data furnishing by furniture duplication based on the information. The customer input data or the customer contact data extracted from an external database in which the standardization of data is performed by the present invention is performed in the repeated standardization process. Based on the generated reference database information, the information is compared and extracted and converted into refined data suitable for character strings of the reference tables for each item. The reference database stores the information of each item stored by each reference table. Only data standardized by the consolidation operation is stored, and a plurality of reference databases are created in succession according to the string comparison of each reference table to achieve consolidation among the databases. By comparing the information of each item according to the sequential sorting of the data of each item included in the normalized data information, the deletion of duplicate data and the integration of data are performed, and by age, gender, and name information based on residence information between the rearranged data The family relationship according to the furniture can be inferred by judging the family status between the customer data. For the above purpose of the automatic standardization method of the customer contact information according to the comparative extraction of the variation data using the data purification management system of the present invention. The matters related to the operational effects, including the technical configuration, will be clearly understood by the following detailed description with reference to the drawings in which preferred embodiments of the present invention are shown. Refer to reference table by separating by number / zip / address The process was to show the progress of the flowchart.

First, FIG. 1 is an overall system configuration diagram of a method for automatically standardizing customer contact information according to the present invention. As shown in FIG. The step of inputting the data by the customer's contact information through the step, the step of selecting the item-specific table of the data analysis target by the string processing of the input information, and the reference table corresponding to the information table broken down by customer data is called Comparing the character string information stored in the reference table with item information of the customer data, and cleaning and automatically changing the data of the customer contact information based on the standardized character string of the reference table to generate purified data. The purification data is stored in the system. Creating a reference database, processing the duplicated data by sorting the purified data sequentially by item based on a name, deleting or merging duplicate records of each item in a table, and providing a customer administration code in the data refining step Based on the information of the residence of the data is configured to include the data furnishing step by the duplication of the furniture, at the bottom of each step of the process there is a sub-reference containing the data processing step by step and the base string information of the reference The standardization process of each step data by using is as follows.

2 is a flowchart illustrating a sub-process for processing a standardized partial social security number according to the present invention. As shown in FIG. 2, characters except for numbers are removed by analysis of previously input social security number information. The first six digits of birth date are checked and the first seven digits are used to distinguish the genders of males and females.In addition, social security numbers classified by basic information of birth date and gender identification number are Mod (11- Mod (1). Digit * 2 + 2 Digits * 3 + 3 Digits * 4 + 4 Digits * 5 + 5 Digits * 6 + 6 Digits * 7 + 7 Digits * 8 + 8 Digits * 9 + 9 Digits * 2 + 10 Digits * 3 + 11 Digits Digit * 4 + 12 digits * 5,11)-13 digits, 10) = 0 is calculated by the formula to determine the accuracy of the classification.

3 is a flow chart showing a sub-process in which the name of standardization is processed according to the present invention. As shown in FIG. 3, the number of digits deleted by deleting the space between names and reading the number of digits of the entire name by data analysis of the name item is shown. If the value is 5 or more, a part of the name except for a three- or four-digit name, for example, 'you', 'your', or 'to', is removed by the name classification reference table call. In the case of unread names, special exceptions are recognized, and standardization by manual operation of the system administrator by error handling is performed. Is performed.

4 is a flowchart illustrating a sub-process in which standardized telephone numbers are processed according to the present invention, and when the telephone number data is string-processed by selecting a refining operation, as shown, it is divided into an area code, a station number, and an individual number. The area code and the station number are automatically updated with the area code and the station number referring to the address in conjunction with the address separator of the item that can be read simultaneously.For example, in Seoul, where the area code is '02', the changed three digits In case of areas except Seoul by the area code reference table, the conventional 4-digit area code is a 3-digit area code based on the address system, and the 2-digit station code is a changed 3-digit station number. Cell phone number is judged by each cell number reference table updated and called separately and transferred to standardized reference database. On the other hand, the area code of the area inferred through the address update process is added to the phone number without the area code, and the area code of the area is updated using the area code reference table. It is classified into a work phone number, a mobile phone number, and a fax number to standardize phone number items.

5 is a flowchart illustrating a sub-process in which a postal code of standardization is processed according to the present invention. As shown in FIG. Add or update the postal code of the region by checking the address, address, and address.This is the address / ri, the building (apartment), and the east / eup, which are constructed as reference tables by the national postal code system issued by the Ministry of Information and Communication. The new zip code is updated by sorting and searching in the order of / page.

FIG. 6 is a flowchart illustrating a subprocess for processing address items of standardization according to the present invention, in which the front of the input address data is divided in the order of city, city, ward, eup-myeon dong, and ridge as shown in the figure. / Ho, ban / ban, house name, type of residence, and dong / ho, with the exception of the address displayed behind the address and the distinguishable character strings such as lake and barrel, ban, apartment, and dongho. The standardization of the data behind the address is done by calling the delimiter reference table of the partitioned address delimiter, which is stored in the delimiter reference table for the number of characters that can be used. As an exception of delimiter, delimiters such as APT, ⓐ, APT are stored in delimiter reference table and compared with delimiters behind the divided address. In addition, standardization of the address of 'xx apartment' is completed. When standardization of address items is completed, the postal code by address or building is added or updated in accordance with the postal code standardization step of FIG. By the way, the storage is completed in the reference database of the work hydrogen items based on the determination of the work address.

7 is a flowchart illustrating a sub-process administrative code processing standardization according to the present invention. As shown in FIG. By comparing and checking the reference table, administrative codes arranged as serial numbers are assigned to separate reference tables, and if there is no address in the input address information, administrative codes for statutory buildings are imposed or added with reference to the standardization step of the address item.

8 is a flowchart illustrating a sub-process for standardizing E-mail processing information according to the present invention. As shown in FIG. E-mail accounts with standardized domains are unified by one domain name, which is represented by a domain reference table call that separates domain names and classifies criteria for domain names. It is stored in the fund database.

9 and 10 are flowcharts showing a sub-process for standardization of duplicater processing according to the present invention. As shown in FIG. By arranging numbers and phone numbers in ascending order, duplicate records are searched by comparing and reviewing each record, and finally, duplicated data processing is performed by deleting or merging duplicate records by comparison by address item.

In addition, the data of the single item that has been standardized through the above steps are compared and compared between the data consolidated by FIG. 9 and the external affiliate data by the complex items of name, social security number, name and telephone number, name and address. An integrated customer number is assigned to each matched record and stored in an integrated database along with duplicate processing such as deletion or consolidation.

FIG. 11 is a flowchart illustrating a subprocess of data furnishing according to the present invention. As shown in FIG. 11, purified data of a phone number and an address item is extracted through data integrated through the redundancy processing step, and the phone number and The data is furnitureized based on the concept of a family member by the overlapping telephone number and the address item based on the address data, and is performed by a data comparison method similar to the duplicater processing step.

As described above, the automatic standardization method of the customer contact information according to the comparative extraction of the variation data using the data purification management system of the present invention is the first input data by the customer contact information is subdivided by item and the data correction through the reference table A standardized reference database is created by data addition and garbage processing, and data reconciliation is performed by the overlapping processing of a single data and the matching information extraction of integrated data by comparing and extracting information between the reference database information. In this way, a standardized database can be established by refining contact data including various personal information of a plurality of customers, and efficient marketing can be carried out using the purified database information. Maximizing the utility of the optimization of the has the advantage that can increase the efficiency of the generated marketing program.

In addition, the present invention by reducing and standardizing errors, such as the telephone number or address of the customer by reducing the defect rate, return rate of marketing programs such as DM, TM, EM, etc., minimizing the waste of the cost of telephone research or mailing By renewing the phone number, address, etc. of the reactivated marketing, there is an economic advantage of reactivation of dormant customers.

In addition, the standardized reference database according to the present invention has an effect of performing strategic and more effective database marketing through various integration and interworking with various data.

Claims (6)

Selecting data for a data analysis work target by processing a string of the input information when data based on the contact information of the customer through the input of the customer or the external database is input; Calling a reference table corresponding to an information table broken down by customer data and comparing the character string information stored in the reference table with information of each item of the customer data; Cleaning and automatically changing data of customer contact information data based on the standardized character string of the reference table to generate purified data; The purified data creating another reference database in the system; A process of processing duplicaters by deleting or merging the duplicate records of each item of the table by sequentially sorting the purified data by item based on a name; The customer contact information according to the comparative extraction of the variation data using the data refining management system, characterized in that it comprises a step of the data furnishing by overlapping the furniture based on the residential information of the customer data given the administrative building code in the data refining step Automatic standardization method The method of claim 1, wherein the generating of the purified data comprises standardizing itemized data such as name, social security number, telephone number, address, and postal code of customer contact information by reference table for each item in which standard strings are defined. An automatic standardization method of customer contact information according to comparative extraction of variation data using a data purification management system. The method of claim 1 or 2, wherein the standardization of the name entry comprises the steps of: deleting spaces between names by name string analysis; When the name digit is read by more than five digits, the name classification reference table is called. Automatic standardization method of customer contact information according to comparative extraction of variation data using data refining management system, characterized in that the step of removing words of three or four digits except the name. The method of claim 1 or 2, wherein the standardization of the social security number item includes removing characters except for numbers by analyzing the input social security data; The date of birth is confirmed by the first six digits of the social security number, and the gender is distinguished by the first seven digits of the rear, An automatic standardization method of customer contact information according to comparative extraction of variation data using a data refining management system, characterized in that the accuracy is determined by a separate calculation formula of classified social security numbers. The method of claim 1 or 2, wherein the standardization of the telephone number entry comprises the steps of dividing the telephone number data stringed by the selection of the purification item into a station number and an individual number; Updating the area code and the station number by referring to the address data of the customer by interworking with the address separator so that the area code and the station number can be read simultaneously; At this time, whether the mobile number is determined by the call of the mobile number reference table is transmitted to the reference database, and the data purification management system comprising the steps of storing and classifying into the home phone number and work phone number fax number based on the address data Automatic standardization method of customer contact information according to comparative extraction of fluctuation data. According to claim 1 or 2, wherein the standardization of the address item is input address data is divided in the order of city, city, ward, eupmundong-dong, Lee in front of the address / arc, dong / ban, house name , Dwelling type, subdivision in order of house / house, Addresses displayed after the address and characters that may contain exceptions of distinguishable strings such as lakes, barrels, vans, apartments, and hohos are stored in the delimiter reference table and are addressed by calling the delimiter reference table of the divided address delimiters. The data behind is compared, When the standardization of the address item is completed, the postal code for each address or building is added or updated, and the data is characterized in that it is stored in the reference database of the work hydrogen items by determining the work address by the work classification reference table Automatic standardization of customer contact information by comparative extraction of variation data using refining management system.