KR20110009817A - Apparatus and method for standard managing data of company name - Google Patents

Abstract

PURPOSE: An apparatus and a method for managing standardization of company name data are provided to standardize and sort unstandardized company names, thereby reducing data management costs and information reliability. CONSTITUTION: A reference database unit(13) stores a standard company name and company name pattern information corresponding to variously expressed company names. A standardization engine unit(20) compares an original company name extracted from an original copy database(11) with the standard company name and analyzes a company name pattern to change the original company name to a standardized company name. A standard database(15) stores original company name data.

Description

Company name Data standardization management apparatus and method {APPARATUS AND METHOD FOR STANDARD MANAGING DATA OF COMPANY NAME}

The present invention relates to a company name data standardization management apparatus and method, and more particularly, to a company name data standardization management apparatus and method for changing and managing the same company name managed in various notation formats to a standardized name.

In general, companies related to the service industry and other companies manage database of customer information to manage customers.

In this case, there may be a database in which the customer information accumulated for many years is not regularly updated or there are many sales employees to hold the company name data input in various forms.

That is, since the company name data of the customers are obtained through various paths, the same company name is represented in different forms and thus retains duplicate company name data.

However, such a conventional database of customer information often has duplicate company name data. Therefore, when marketing activities using customer information, only the name of the company is different, but only for customers belonging to the same company. Sending a large number of emails and mail, there was a problem that the marketing effect is reduced.

That is, in addition to the problem of cost, time, and manpower loss in terms of marketing companies, customer complaints increase due to inaccurate data, and marketing effects are reduced, thereby lowering the accuracy of data analysis.

The present invention has been made in view of the above problems, to provide a company name data standardization management apparatus and method for managing customer information by changing the same company name managed in various notation forms into a standardized name. The purpose is.

Another object of the present invention is to standardize information recorded under different company names by the same company by performing the task of standardizing the company name of the customer by comparing and analyzing the company name information and the reference company name information of the file in which the customer information is recorded. The present invention provides a company name data standardization management apparatus and method for generating standardized company name data.

Technical problems of the present invention are not limited to the technical problems mentioned above, and other technical problems not mentioned will be clearly understood by those skilled in the art from the following description.

Company name data standardization management apparatus according to an aspect of the present invention for achieving the above object, the original company name data (file) recorded with the original company name corresponding to the customer information with the customer information of the customers that enterprises must manage DB is stored is stored in DB; A reference DB unit for storing the standard company name corresponding to the company name that can be variously expressed and the pattern information of the company name for the standardization of the company name as DB; A standardization engine unit for extracting an original company name from the original company name data, comparing the extracted original company name with a standard company name, and analyzing a pattern for each company name to change the original company name to a standardized company name; And a standardization DB unit configured to store company name data including the standardized company name.

Here, the reference DB unit, under the control of the standardization engine unit, the information is stored based on the overall function of the registration, modification, update and deletion of the standard company name information associated with the original company name.

Here, the reference DB unit includes standardized name information of company name standardized job history information management, standardized company result information of job result information management such as original company name, final company name, change method, standard company name, type of business, telephone No. Company name master information of information management, standard company name where no company name overlaps, company name information of information management, company name changed through standardization work Change history information management changed, and change when company name changed At least one of the changed company name information of the company name history information management before and after the change and the word conversion information of the conversion information management for words frequently used in the company name are stored.

The standardization engine unit may include: a search unit that searches whether a standard company name identical to the original company name exists from the reference DB unit, and outputs information on whether the standard company name identical to the original company name exists as a search result; A parsing unit for parsing the original company name and outputting information on the existence of the same company name as the standard company name if a search result of the search unit does not exist with the same standard company name as the original company name; If the standard company name identical to the original company name does not exist by the searching unit and the parsing unit, converting unit for outputting information on the existence of the same company name as the standard company name by changing the pattern of the original company name; And receiving information indicating that the information is the same as the standard company name from any one of the searching unit, the parsing unit, and the converting unit, and generates the standardized company name data by mapping the corresponding company name and the standard company name corresponding to the received information. It includes a mapping unit stored in the DB unit.

Company name data standardization management method according to another aspect of the present invention, in the company name data standardization management method of the company name data standardization management unit under the control of the standardization engine, the original company name is extracted from the customer information data stored in the original DB Searching for whether a standard company name identical to the original company name exists; Judging whether a standard company name identical to the original company name exists and if the same standard company name as the original company name exists, storing the original company name as a standard company name in a standardized DB; If the standard company name identical to the original company name does not exist, parsing the original company name, and determining whether the parsed company name is the same company name as the standard company name; If the parsed company name is the same as the standard company name, mapping the original company name and the standard company name of the parsed object and storing them in a standardized DB; If the parsed company name is not the same as the standard company name, changing the pattern of the original company name, and determining whether the same standard company name as the changed company name exists; And if the standard company name identical to the company name of which the pattern is changed exists as a result of the determination, mapping and storing the original company name and the standard company name of the pattern change target.

According to another aspect of the present invention, a recording medium having a computer-readable program recorded thereon includes: extracting an original company name from customer information data stored in an original DB on a computer and searching for whether a standard company name identical to the original company name exists; Judging whether a standard company name identical to the original company name exists and if the same standard company name as the original company name exists, storing the original company name as a standard company name in a standardized DB; If the standard company name identical to the original company name does not exist, parsing the original company name, and determining whether the parsed company name is the same company name as the standard company name; If the parsed company name is the same as the standard company name, mapping the original company name and the standard company name of the parsed object and storing them in a standardized DB; If the parsed company name is not the same as the standard company name, changing the pattern of the original company name, and determining whether the same standard company name as the changed company name exists; And if the standard company name identical to the company name of which the pattern is changed is present as a result of the determination, mapping and storing the original company name and the standard company name of the pattern change target.

According to the above-mentioned problem solving means, the present invention organizes the non-standardized company name possessed by the company to be standardized by the standardized company name, thereby reducing data management cost and improving information reliability, thereby improving work productivity. There is.

Company name data standardization management apparatus and method of the present invention proposes a technical configuration that can be managed by changing the non-standardized company name for the same company name of the customer who is managed in various notation format to a standardized company name.

In the following description, specific details of the company name data standardization management apparatus and method of the present invention are shown to provide a more general understanding of the present invention, and the present invention may be readily implemented without these specific details and by their modifications. It will be apparent to one skilled in the art.

On the other hand, in the following description to illustrate the standardization of the original company name of the original company name data to help the understanding of the present invention as an example, customer information (telephone number, business type, address information, etc.) stored together in the standard company name data You should be aware that

In addition, in the following description, the standard company name is composed of Korean characters, and there is no space between syllables forming the company name.

Hereinafter, preferred embodiments according to the present invention will be described in detail with reference to the accompanying drawings, with reference to the parts necessary for understanding the operation and operation according to the present invention.

1 is a block diagram of a company name data standardization management apparatus according to an embodiment of the present invention.

Referring to FIG. 1, the company name data standardization management apparatus 100 according to the present invention includes an original DB unit 11, a reference DB unit 13, a standardization engine unit 20, and a standardization DB unit 15. And the like.

First, the original DB unit 11 stores the original company name data (file) recorded with the original company name corresponding to the customer information together with the customer information of the customers to be managed by the DB.

In the reference DB unit 13, a standard company name corresponding to a company name that can be variously expressed is stored in a DB. At this time, the pattern information of the company name that can be variously expressed is stored together, so that the company name can be standardized. The pattern information of the company name will be described in detail below. In addition, the reference DB unit 13 stores information based on the overall functions of registration, modification, update and deletion of standard company name information related to the original company name. That is, the reference DB unit 13 stores company name information in the form shown in Table 1 below.

Database name Explanation Standardized Person Information Company Name Standardized Job History Information Management Standardization work result information Manage job result information such as original company name, final company name, and change method Company Name Master Information Standard company name, business type, phone number information management Company Name Information Standard company name information management with no duplicate company names Change history information Changed company name history information through standardization Company Name Changed Management of company name history information before and after change when company name is changed Word conversion information Manage conversion information for words commonly used in company names

The standardization engine unit 20 extracts the original company name from the original company name data in which the original company name is recorded from the original DB unit 11, compares the extracted original company name with the standard company name, and analyzes the pattern by company name. Change the original company name to a standardized company name. Thus, it is possible to change the non-standardized company name and the standardized company name for a plurality of company names expressed by various expression methods for the same company. In addition, the standardization engine unit 20 controls to manage the above-described information of Table 1, and stores the corresponding information in the reference DB unit (13).

The standardization DB unit 15 stores the final standard company name data composed of company names standardized by the standardization engine unit 20.

Here, the original DB unit 11, the reference DB unit 13 and the standardized DB unit 15 may be composed of one integrated integrated DB unit 10. That is, by changing the original company name of the original company name data to the standard company name through one integrated DB unit 10 to store and manage the standard company name data consisting of the standard company name.

2 is a block diagram showing the internal configuration of the standardization engine in FIG.

Referring to FIG. 2, the standardization engine 20 according to the present invention includes a searcher 21, a parser 23, a converting unit 25, and a mapping unit 27.

The search unit 21 searches whether the standard company name identical to the original company name exists from the reference DB unit 13, and outputs information on the existence of the same standard company name as the original company name as the search result.

The parsing unit 23 parses the original company name if the search result of the search unit 21 does not exist, and outputs information on whether the same company name as the standard company name exists.

If the converting unit 25 does not exist by the search unit 21 and the parsing unit 23, the standard company name identical to the original company name, and changes the pattern of the original company name and outputs information on the existence of the same company name as the standard company name do.

When the mapping unit 27 receives the information indicating that the same as the standard company name from any one of the search unit 21, the parser 23 and the converting unit 25, the mapping unit 27 and the corresponding company name and the standard company corresponding to the received information The names are mapped and stored in the standardized DB unit 15.

That is, the mapping unit 27 generates finally standardized company name data through standardization of the original company name. The standard company name data generated therein is stored in the standardization DB unit 15.

The operation of the company name data standardization management apparatus according to the present invention described above will be described in detail with reference to the accompanying drawings.

3 is an exemplary view for explaining the operation of the company name data standardization management apparatus according to an embodiment of the present invention.

Referring to FIG. 3, first, data of an object to be standardized (Excel, CSV, DB) is obtained and the original company name is first extracted from the data of the object without processing. Search whether the standard company name identical to the extracted original company name exists from the standard company name (①, ②).

After that, if the standard company name identical to the original company name exists, the original company name is maintained as it is.

However, as a result of the search, if there is no standard company name that is not the same as the original company name, the original company name must be processed, so that parsing and converting are performed through the parsing unit 23 and the converting unit 25 (③, ④ ).

The parsing and converting operation is standardized with reference to FIG. 4.

In other words, parsing and converting in consideration of the fact that the original company name can have a pattern that can be expressed as "expression before and after the company name of (corporate), (company), (current), (re) or company name + corporation". Do this. As an example, parsing and converting the original company names such as Gongyoung DBM, Gongyoung DBM, Gongyoung DBM, Gongyoung DBM Co., Ltd., and completing the processing with the standard company name of GongDong DM.

In addition, parsing and converting are performed in consideration of a pattern that can be expressed as "Company Name + Branch Name, Business Name, Region Name, Chain Store Name, Department Name, Job Name". For example, Kookmin Bank's Gasan-Dong branch is Kookmin Bank, SK Telecom Gangbuk Sales Center is SK Telecom, LS Cable & System IN4S operation team is LS Cable, and Namyangju City Hall 8272 Civil Complaint Office is completed with standard company names.

In addition, parsing and converting are performed in consideration of having a pattern that can be expressed as a "shorthand expression". For example, Microsoft completes the process under standard company names, such as Microsoft Korea and SKT, SK Telecom.

In addition, parsing and converting are performed in consideration of having a pattern that can be expressed as "English expression". For example, Shinsegae I & C completes the process under the standard company name like Shinsegae I & C.

In addition, parsing and converting are performed in consideration of having a pattern that can be expressed in "difference in English pronunciation." For example, SK Communications and SK Communications complete their processing under standard company names, such as SK Communications and SK Tallink.

In addition, parsing and converting are performed in consideration of being able to have a pattern that can be represented by "user misinput". As an example, Guk Jae-Comp is finished with a standard company name, such as International Trading Co., and Gongyeong DMB.

In addition, since the "company name" may be changed, parsing and converting are performed in consideration of the pattern. As an example, Hanbit Bank completes the treatment under standard company names such as Woori Bank and Korea Mining Promotion Corporation.

In addition, parsing and converting are performed in consideration of patterns that can be represented by "special character representation". For example, New-Tech completes the process with a standard company name such as New-Tech and Salesforce.com.

It also performs parsing and converting, considering that it can have a pattern that can be represented by an "empty space". For example, the public DBM and the public D B M complete the processing under standard company names such as public DB.

In addition, parsing and converting are performed in consideration of the possibility of having a "number representation in company name" pattern. For example, the 5425 completes the process with a standard company name, such as Osio.

In addition, parsing and converting are performed in consideration of having a pattern such as "significant expression". For example, Dongwon F & B completes the process under the standard company name, such as Dongwon F & B.

Accordingly, through the above-described technique, the parsing unit 23 and the converting unit 25 perform parsing and converting by comparing the non-standardized company name with the standard company name.

Afterwards, the company's standardization of the data distribution results are checked and approved. At this time, the company name standardization result distribution inquiry can be directly corrected (manually) or automatically corrected by the user at the judgment of the user (⑤). Here, the manual method of the user directly modify is automatically modified through the management method of the company name data standardization management apparatus according to the present invention. It is an additional function adopted considering the case where you want to register and manage differently.

If this manual or automatic final approval is finally obtained, the standardization work is completed by generating standard company name data.

The standard company name data generated at this time is standardized into an Excel file, a text file CSV file, and stored in the standardized DB 15 through the export function (⑥). Here, the standard company name data stored in the standardization DB 15 serves to print the standardized theorem result in a table and a graph under the control of the standardization engine 20, or to inquire the standardized theorem result by the user's request.

5 is a flowchart illustrating a company name data standardization management method according to an embodiment of the present invention.

Referring to FIG. 5, the standardization engine unit 20 extracts an original company name from customer information data stored in the original DB 11 (S501).

Thereafter, the standardization engine unit 20 searches whether the same standard company name as the original company name exists in the reference DB unit 13 (S503), and determines whether the same standard company name as the original company name exists as a result of the search (S505).

As a result of determination, if the same standard company name as the original company name exists, the standardization engine unit 20 stores the original company name as the standard company name in the standardization DB 15 as it is (S507).

However, if it is determined that the standard company name identical to the original company name does not exist, the standardization engine unit 20 parses the original company name (S509), and determines whether the parsed company name is the same company name as the standard company name ( S511).

As a result of determination, if the parsed company name is the same as the standard company name, the standardization engine unit 20 maps and stores the original company name and the standard company name of the parsed target (S513).

However, if it is determined that the parsed company name is not the same as the standard company name, the standardization engine unit 20 changes the original company name pattern (S515), and determines whether the same standard company name as the changed company name exists (S517).

As a result, if the standard company name identical to the company name whose pattern is changed exists, the standardization engine unit 20 maps and stores the original company name and the standard company name of the changed object (S519).

Meanwhile, in the detailed description of the present invention, specific embodiments have been described, but various modifications are possible without departing from the scope of the present invention. Therefore, the scope of the present invention should not be limited to the described embodiments, but should be defined not only by the scope of the following claims, but also by the equivalents of the claims.

1 is a block diagram of a company name data standardization management apparatus according to an embodiment of the present invention.

2 is a configuration diagram showing the internal configuration of the standardization engine in Figure 1;

Figure 3 is an exemplary view for explaining the operation of the company name data standardization management apparatus according to an embodiment of the present invention.

4 is an exemplary view for explaining a parsing and converting operation according to an embodiment of the present invention.

5 is a flow chart showing a company name data standardization management method according to an embodiment of the present invention.

Claims (6)

An original DB unit in which original company name data (files) in which the original company name corresponding to the customer information is recorded together with the customer information of the customers to be managed by the companies are stored in a DB; A reference DB unit for storing the standard company name corresponding to the company name that can be variously expressed and the pattern information of the company name for the standardization of the company name as DB; A standardization engine unit for extracting an original company name from the original company name data, comparing the extracted original company name with a standard company name, and analyzing a pattern for each company name to change the original company name to a standardized company name; And Company name data standardization management device characterized in that it comprises a standardization DB that stores the company name data consisting of the standardized company name. The method of claim 1, wherein the reference DB unit, Under the control of the standardization engine unit, the company name data standardization management apparatus, characterized in that the information is stored based on the overall function of the registration, modification, update and deletion of the standard company name information associated with the original company name. The method of claim 2, wherein the reference DB unit, Company name standardized job history information management standardized name information, Standardized work result information of work result information management such as original company name, final company name, change method, Standard company name, type of industry, company name master information of telephone number information management, The only company name information of standard company name information management that does not exist in duplicate of the company name, Change history information of company name history information management changed through standardization work, If the company name is changed, the changed company name information in the management of the company name history information before and after the change; And at least one information of the word conversion information of the conversion information management for the words frequently used in the company name. The method of claim 1, wherein the standardization engine unit, A retrieval unit for retrieving whether a standard company name identical to the original company name exists from the reference DB unit, and outputting information on whether or not the standard company name identical to the original company name exists as a search result; A parsing unit for parsing the original company name and outputting information on whether or not the same company name exists as the standard company name if the search result of the search unit does not exist. If the standard company name identical to the original company name does not exist by the searching unit and the parsing unit, converting unit for outputting information on the existence of the same company name as the standard company name by changing the pattern of the original company name; And When receiving information indicating that the same as the standard company name from any one of the search unit, parsing unit and converting unit, by mapping the corresponding company name and the standard company name corresponding to the received information to generate standardized company name data to the standardized DB Company name data standardization management device comprising a mapping unit for storing in the unit. In the company name data standardization management method of the company name data standardization management device under the control of the standardization engine unit, Extracting the original company name from the customer information data stored in the original DB and searching for whether the same standard company name as the original company name exists; Judging whether a standard company name identical to the original company name exists and if the same standard company name as the original company name exists, storing the original company name as a standard company name in a standardized DB; If the standard company name identical to the original company name does not exist, parsing the original company name, and determining whether the parsed company name is the same company name as the standard company name; If the parsed company name is the same as the standard company name, mapping the original company name and the standard company name of the parsed object and storing them in a standardized DB; If the parsed company name is not the same as the standard company name, changing the pattern of the original company name, and determining whether the same standard company name as the changed company name exists; And And if the standard company name identical to the company name whose pattern is changed is present, determining and storing the original company name and the standard company name of the pattern-changed object. Extracting the original company name from the customer information data stored in the computer source DB and searching for whether a standard company name identical to the original company name exists; Judging whether a standard company name identical to the original company name exists and if the same standard company name as the original company name exists, storing the original company name as a standard company name in a standardized DB; If the standard company name identical to the original company name does not exist, parsing the original company name, and determining whether the parsed company name is the same company name as the standard company name; If the parsed company name is the same as the standard company name, mapping the original company name and the standard company name of the parsed object and storing them in a standardized DB; If the parsed company name is not the same as the standard company name, changing the pattern of the original company name, and determining whether the same standard company name as the changed company name exists; And And if the standard company name is the same as the company name whose pattern is changed, the computer readable recording medium having recorded thereon a program for executing the step of mapping and storing the original company name and the standard company name of the pattern change target.

Images