CN104766223A - Method for automatically compiling marketing client addresses on basis of address bank - Google Patents
Method for automatically compiling marketing client addresses on basis of address bank Download PDFInfo
- Publication number
- CN104766223A CN104766223A CN201510150194.8A CN201510150194A CN104766223A CN 104766223 A CN104766223 A CN 104766223A CN 201510150194 A CN201510150194 A CN 201510150194A CN 104766223 A CN104766223 A CN 104766223A
- Authority
- CN
- China
- Prior art keywords
- address
- information
- code
- province
- automatically
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method for automatically compiling marketing client addresses on the basis of an address bank. The method comprises the following steps that S1, the address bank is compiled; S2, the address clearing rule is made, and according to the management attribute of clients of the whole province, user address decomposition information is perfected; S3, the condition that address clearing is carried out automatically is deployed; S4, the client addresses are automatically cleared, and the specific time period of each day is set to be working time for background address clearing service; the number of cleared data of the addresses of each day is 500000; S5, a client address decomposition information table is updated. According to the method, the power utilization addresses of the clients can be automatically disassembled into specific formats, the Chinese addresses of the clients can be automatically disassembled and stored into the power utilization address decomposition table, and therefore the purpose of reducing labor force greatly is achieved.
Description
Technical field
the present invention relates to the automatic process field of electric power enterprise customer information, particularly a kind of method of based on address base, marketing customer address being carried out to automatic compiling.
Background technology
at present for the disposal route that marketing customer address decomposes and sorts out, mostly be artificial treatment.Because the whole province of Fujian Province user reaches 1,400 ten thousand families, to decompose its address one by one and classified and stored in electricity consumption Address Resolution table, certainly will will spend huge human resources, waste a lot of valuable time.Therefore it is very important for finding out a kind of method that customer address of marketing carries out automatic compiling.
Summary of the invention
In view of this, the object of this invention is to provide a kind of method of based on address base, marketing customer address being carried out to automatic compiling, reach the object significantly reducing manual labor.
Device of the present invention adopts following scheme to realize: a kind of method of based on address base, marketing customer address being carried out to automatic compiling, comprises the following steps:
Step S1: establishment address base;
Step S2: formulate address cleaning rule, according to the management attribute of the whole province client, improve station address decomposed information;
Step S3: dispose address cleaning process automatically;
Step S4: customer address cleans automatically, setting specific time period every day is the working time of address, backstage cleaning service; Every day, the cleaning data of address were 500,000;
Step S5: upgrade customer address decomposed information table.
Further, described step S1 is further comprising the steps of:
Step S11: download specific province administrative division coded data, comprises province, city, district, street, neighbourhood committee 5 category information;
Step S12: described specific province administrative division coded data is stored with XLS document form, and imports in system database;
Step S13: automatically add establishment province code, city's code, district code, street code, neighbourhood committee's code respectively according to the information that natural serial number is each classification.
Further, described step S2 is further comprising the steps of:
Step S21: according to the on-site management unit of customer address be this client Address Resolution code on automatically add " province, city, district " information.
Step S22: when customer address occurs with street printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding street code.
Step S23: when customer address occurs with neighbourhood committee's printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding neighbourhood committee code.
Further, described step S3 comprises service one and service two; Described service one, for using instr function, disposes the filtering services to street code and neighbourhood committee's code; Described service two is according to the number information of user at electric power enterprise, disposes the incidence relation table of Customs Assigned Number correspondence " province, city, district " management unit.
Further, described service one and service two are deployed to during database background application serves.
Further, described step S4 is further comprising the steps of:
Step S41: read the family information of user and management unit's information, corresponds to corresponding " province, city, district " information in incidence relation table, for province's code information of this client, city's code information, district code information give corresponding code respectively;
Step S42: according to inst: function, when electricity consumption address comprises street information, gives this user by described address base street code;
Step S43: according to instr function, when electricity consumption address comprises neighbourhood committee's information, gives this user by the neighbourhood committee's code in described address base.
Further, described step S5 is further comprising the steps of:
S51: whole user profile is read in circulation successively, obtains a result, and use UPDATE database command to write results in the Address Resolution information table of user according to step S4;
S52: the result of selective examination automatically generated data.
Especially, above-mentioned street also can be small towns, and above-mentioned neighbourhood committee also can be villagers' committee.
Compared with prior art, the present invention provides and automatically can carry out to the electricity consumption address (Chinese character string) of client the function that automatic disassemble is specific format, according to electric power enterprise inner management requirement, need the whole province 1,400 ten thousand customer address by " economizing, city, district (county), street, neighbourhood committee, road, the form of community (natural village) is disassembled, this technology is intended to use keyword match technology, use the electricity consumption address automatic cleaning function that backstage is disposed, automatic disassemble is carried out to the Chinese address of user and is stored in electricity consumption Address Resolution table, significantly reduce manual labor.
Accompanying drawing explanation
Fig. 1 is process flow diagram of the present invention.
Embodiment
Below in conjunction with drawings and Examples, the present invention will be further described.
As shown in Figure 1, the present embodiment provides a kind of method of based on address base, marketing customer address being carried out to automatic compiling, comprises the following steps:
Step S1: establishment address base;
Step S2: formulate address cleaning rule, according to the management attribute of the whole province client, improve station address decomposed information;
Step S3: dispose address cleaning process automatically;
Step S4: customer address cleans automatically, setting specific time period every day is the working time of address, backstage cleaning service; Every day, the cleaning data of address were 500,000;
Step S5: upgrade customer address decomposed information table.
In the present embodiment, described step S1 is further comprising the steps of:
Step S11: download specific province administrative division coded data, comprises province, city, district, street, neighbourhood committee 5 category information;
Step S12: described specific province administrative division coded data is stored with XLS document form, and imports in system database;
Step S13: automatically add establishment province code, city's code, district code, street code, neighbourhood committee's code respectively according to the information that natural serial number is each classification.
In the present embodiment, described step S2 is further comprising the steps of:
Step S21: according to the on-site management unit of customer address be this client Address Resolution code on automatically add " province, city, district " information.
Step S22: when customer address occurs with street printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding street code.
Step S23: when customer address occurs with neighbourhood committee's printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding neighbourhood committee code.
In the present embodiment, described step S3 comprises service one and service two; Described service one, for using instr function, disposes the filtering services to street code and neighbourhood committee's code; Described service two is according to the number information of user at electric power enterprise, disposes the incidence relation table of Customs Assigned Number correspondence " province, city, district " management unit.
In the present embodiment, described service one and service two are deployed to during database background application serves.
In the present embodiment, described step S4 is further comprising the steps of:
Step S41: read the family information of user and management unit's information, corresponds to corresponding " province, city, district " information in incidence relation table, for province's code information of this client, city's code information, district code information give corresponding code respectively;
Step S42: according to inst: function, when electricity consumption address comprises street information, gives this user by described address base street code;
Step S43: according to instr function, when electricity consumption address comprises neighbourhood committee's information, gives this user by the neighbourhood committee's code in described address base.
In the present embodiment, described step S5 is further comprising the steps of:
S51: whole user profile is read in circulation successively, obtains a result, and use UPDATE database command to write results in the Address Resolution information table of user according to step S4;
S52: the result of selective examination automatically generated data.
Especially, above-mentioned street also can be small towns, and above-mentioned neighbourhood committee also can be villagers' committee.
Preferably, the present embodiment, for Fujian Province, sets forth the above method further:
Step S1 is districts and cities of establishment Fujian Province storehouse, specifically comprise: download Fujian Province's administrative division coded data from national statistics board web, comprise province, city, district, street (small towns), neighbourhood committee (villagers' committee) 5 category information, after storing with XLS document form, this 5 category information is imported in system database, and automatically adds establishment province code, city's code, district code, street (small towns) code, neighbourhood committee (villagers' committee) code respectively according to the information that natural serial number is each classification.
Step S2, for formulating address cleaning rule, according to the management attribute of the whole province client, improves station address decomposed information; Specifically comprise: (1) is that the Address Resolution code of this client adds " province, city, district " information automatically by the on-site management unit of customer address.(2) when customer address occurs with street (small towns) printed words information corresponding to address base, then for customer address divides decoding to add above corresponding street (small towns) code.(3) when customer address occurs with neighbourhood committee (villagers' committee) printed words information corresponding to address base, then for customer address divides decoding to add above corresponding neighbourhood committee (villagers' committee) code.
Step S3, for disposing address cleaning process automatically, specifically comprises: service 1: use instr (station address, key word) function, dispose the filtering services to street (small towns) and neighbourhood committee (villagers' committee) code.Service 2: according to the number information of user at electric power enterprise, disposes the incidence relation table of Customs Assigned Number correspondence " province, city, district " management unit.And above rule is deployed in database background application service.
Step S4 is that customer address cleans automatically, specifically comprises: setting 0 .-5 working time for the cleaning service of address, backstage of morning every day; Every day, the cleaning data of address were 500,000; (1) read the family information of user and management unit's information, in incidence relation table, correspond to corresponding " province, city, district " information, for province's code information of this client, city's code information, district code information give corresponding code respectively.(2) according to instr (station address, key word) function, when electricity consumption address comprises street (small towns) information, this user is given by street (small towns) code in Fujian Province's address base.(3) according to instr (station address, key word) function, when electricity consumption address comprises neighbourhood committee (villagers' committee) information, this user is given by neighbourhood committee (villagers' committee) code in Fujian Province's address base.
Step S5 is for upgrading customer address decomposed information table, specifically comprise: circulation is read from 0-50 ten thousand user profile successively, according to the result of cleaning automatically, UPDATE database command is used to write results in the Address Resolution information table of user, until the whole province 1400 general-purpose family all processes.Electric power enterprise inner management personnel spot-check the result of automatically generated data every day.
It is specific format that the present invention can carry out automatic disassemble to the electricity consumption address of client automatically, carries out automatic disassemble and is stored in electricity consumption Address Resolution table, reach the object significantly reducing manual labor to the Chinese address of user.
The foregoing is only preferred embodiment of the present invention, all equalizations done according to the present patent application the scope of the claims change and modify, and all should belong to covering scope of the present invention.
Claims (7)
1. based on address base, marketing customer address is carried out to the method for automatic compiling, it is characterized in that comprising the following steps:
Step S1: establishment address base;
Step S2: formulate address cleaning rule, according to the management attribute of the whole province client, improve station address decomposed information;
Step S3: dispose address cleaning process automatically;
Step S4: customer address cleans automatically, setting specific time period every day is the working time of address, backstage cleaning service; Every day, the cleaning data of address were 500,000;
Step S5: upgrade customer address decomposed information table.
2. a kind of method of based on address base, marketing customer address being carried out to automatic compiling according to claim 1, is characterized in that: described step S1 is further comprising the steps of:
Step S11: download specific province administrative division coded data, comprises province, city, district, street, neighbourhood committee 5 category information;
Step S12: described specific province administrative division coded data is stored with XLS document form, and imports in system database;
Step S13: automatically add establishment province code, city's code, district code, street code, neighbourhood committee's code respectively according to the information that natural serial number is each classification.
3. a kind of method of based on address base, marketing customer address being carried out to automatic compiling according to claim 1, is characterized in that: described step S2 is further comprising the steps of:
Step S21: according to the on-site management unit of customer address be this client Address Resolution code on automatically add " province, city, district " information;
Step S22: when customer address occurs with street printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding street code;
Step S23: when customer address occurs with neighbourhood committee's printed words information corresponding to described address base, then for customer address divides decoding to add above corresponding neighbourhood committee code.
4. a kind of method of based on address base, marketing customer address being carried out to automatic compiling according to claim 1, is characterized in that: described step S3 comprises service one and service two; Described service one, for using instr function, disposes the filtering services to street code and neighbourhood committee's code; Described service two is according to the number information of user at electric power enterprise, disposes the incidence relation table of Customs Assigned Number correspondence " province, city, district " management unit.
5. according to claim 4ly a kind ofly based on address base, the method for automatic compiling is carried out to marketing customer address, it is characterized in that: described service one and service two are deployed to during database background application serves.
6. a kind of method of based on address base, marketing customer address being carried out to automatic compiling according to claim 1, is characterized in that: described step S4 is further comprising the steps of:
Step S41: read the family information of user and management unit's information, corresponds to corresponding " province, city, district " information in incidence relation table, for province's code information of this client, city's code information, district code information give corresponding code respectively;
Step S42: according to inst: function, when electricity consumption address comprises street information, gives this user by described address base street code;
Step S43: according to instr function, when electricity consumption address comprises neighbourhood committee's information, gives this user by the neighbourhood committee's code in described address base.
7. a kind of method of based on address base, marketing customer address being carried out to automatic compiling according to claim 1, is characterized in that: described step S5 is further comprising the steps of:
S51: whole user profile is read in circulation successively, obtains a result, and use UPDATE database command to write results in the Address Resolution information table of user according to step S4;
S52: the result of selective examination automatically generated data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510150194.8A CN104766223B (en) | 2015-04-01 | 2015-04-01 | The method compiled automatically to marketing customer address based on address base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510150194.8A CN104766223B (en) | 2015-04-01 | 2015-04-01 | The method compiled automatically to marketing customer address based on address base |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104766223A true CN104766223A (en) | 2015-07-08 |
| CN104766223B CN104766223B (en) | 2018-05-04 |
Family
ID=53648036
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510150194.8A Active CN104766223B (en) | 2015-04-01 | 2015-04-01 | The method compiled automatically to marketing customer address based on address base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104766223B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109698504A (en) * | 2019-03-08 | 2019-04-30 | 张文韬 | Calculation of tidal current analysis method and system |
| CN112600665A (en) * | 2020-12-25 | 2021-04-02 | 江苏通付盾区块链科技有限公司 | Covert communication method, device and system based on block chain and encryption technology |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877087A (en) * | 2009-04-23 | 2010-11-03 | 中国科学院地理科学与资源研究所 | System and method for monitoring and surveying floating population based on space position |
-
2015
- 2015-04-01 CN CN201510150194.8A patent/CN104766223B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877087A (en) * | 2009-04-23 | 2010-11-03 | 中国科学院地理科学与资源研究所 | System and method for monitoring and surveying floating population based on space position |
Non-Patent Citations (3)
| Title |
|---|
| 李明: "《数据清洗技术在文本挖掘中的应用》", 《中国优秀硕士论文电子期刊网 信息科技辑》 * |
| 郭文龙: "《数据清洗中中文地址分词技术研究》", 《齐齐哈尔大学学报》 * |
| 郭文龙等: "《一种基于编码规则的中文地址清洗方法》", 《闽江学院学报》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109698504A (en) * | 2019-03-08 | 2019-04-30 | 张文韬 | Calculation of tidal current analysis method and system |
| CN112600665A (en) * | 2020-12-25 | 2021-04-02 | 江苏通付盾区块链科技有限公司 | Covert communication method, device and system based on block chain and encryption technology |
| CN112600665B (en) * | 2020-12-25 | 2023-12-01 | 江苏通付盾区块链科技有限公司 | Hidden communication method, device and system based on block chain and encryption technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104766223B (en) | 2018-05-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102024024B (en) | Method and device for constructing address database | |
| CN103678494A (en) | Method and device for client side and server side data synchronization | |
| CN105138501A (en) | Configurable dynamic report generating method and system | |
| CN102710795B (en) | Hotspot collecting method and device | |
| ATE457493T1 (en) | METHOD AND APPARATUS FOR SEARCHING BACKUP DATA BASED ON CONTENT AND ATTRIBUTES | |
| CN104281702A (en) | Power keyword segmentation based data retrieval method and device | |
| CN101996247A (en) | Method and device for constructing address database | |
| CN110457579B (en) | Webpage denoising method and system based on cooperative work of template and classifier | |
| CN102591880A (en) | Information providing method and device | |
| CN102253972A (en) | Web crawler-based geographical name database maintenance method | |
| CN104602274A (en) | Method and system for dynamic identification on terminal brand and terminal type | |
| CN103177036A (en) | Method and system for label automatic extraction | |
| CN106844782B (en) | Network-oriented multi-channel big data acquisition system and method | |
| CN104346331A (en) | Retrieval method and system for XML database | |
| CN101984432A (en) | Method and device for constructing address database | |
| CN106528641A (en) | Data storage method and device and communication gateway machine | |
| CN111523433B (en) | Standardized processing method, device and equipment for end address of express mail | |
| CN105550253A (en) | Method and device for obtaining type relation | |
| CN106021393A (en) | Mobile device-oriented power grid equipment standard information retrieval method and system | |
| CN104766223A (en) | Method for automatically compiling marketing client addresses on basis of address bank | |
| CN105528345A (en) | Terminal, server and character complementing method | |
| CN112069824B (en) | Region identification method, device and medium based on context probability and citation | |
| CN103853770A (en) | Method and system for abstracting information of posts from forum website | |
| CN107579976A (en) | The method and device of self-defined detection website sensitive information | |
| CN102831135B (en) | A kind of method of novel Chinese news pages incremental crawler and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: 100030 Beijing Xicheng District West Chang'an Avenue 86 Co-patentee after: STATE GRID FUJIAN ELECTRIC POWER Co.,Ltd. Patentee after: STATE GRID CORPORATION OF CHINA Co-patentee after: STATE GRID FUJIAN ELECTRIC POWER Research Institute Address before: 100031 West Chang'an Avenue, Xicheng District, Xicheng District, Beijing Co-patentee before: STATE GRID FUJIAN ELECTRIC POWER Co.,Ltd. Patentee before: State Grid Corporation of China Co-patentee before: STATE GRID FUJIAN ELECTRIC POWER Research Institute |
|
| CP03 | Change of name, title or address | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20181102 Address after: 100030 Beijing Xicheng District West Chang'an Avenue 86 Co-patentee after: STATE GRID FUJIAN ELECTRIC POWER Co.,Ltd. Patentee after: STATE GRID CORPORATION OF CHINA Co-patentee after: STATE GRID FUJIAN ELECTRIC POWER Research Institute Co-patentee after: STATE GRID FUJIAN ECONOMIC Research Institute Address before: 100030 Beijing Xicheng District West Chang'an Avenue 86 Co-patentee before: STATE GRID FUJIAN ELECTRIC POWER Co.,Ltd. Patentee before: State Grid Corporation of China Co-patentee before: STATE GRID FUJIAN ELECTRIC POWER Research Institute |
|
| TR01 | Transfer of patent right |