CN117376303A - Intelligent number data management system and method based on cold and hot data isolation technology - Google Patents
Intelligent number data management system and method based on cold and hot data isolation technology Download PDFInfo
- Publication number
- CN117376303A CN117376303A CN202311261003.6A CN202311261003A CN117376303A CN 117376303 A CN117376303 A CN 117376303A CN 202311261003 A CN202311261003 A CN 202311261003A CN 117376303 A CN117376303 A CN 117376303A
- Authority
- CN
- China
- Prior art keywords
- mobile phone
- data
- managed
- phone number
- cold
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L61/00—Network arrangements, protocols or services for addressing or naming
- H04L61/30—Managing network names, e.g. use of aliases or nicknames
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/70—Protecting specific internal or peripheral components, in which the protection of a component leads to protection of the entire computer
- G06F21/78—Protecting specific internal or peripheral components, in which the protection of a component leads to protection of the entire computer to assure secure storage of data
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L2101/00—Indexing scheme associated with group H04L61/00
- H04L2101/60—Types of network addresses
- H04L2101/618—Details of network addresses
- H04L2101/65—Telephone numbers
Landscapes
- Engineering & Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Mobile Radio Communication Systems (AREA)
Abstract
The invention discloses a number data intelligent management system and method based on a cold and hot data isolation technology, relates to the field of communication, solves the problem of low processing efficiency of different storage and management strategies on the number data, and specifically comprises the following steps: the number scoring module is used for identifying and scoring the number data of the mobile phone number to be managed; the number classification module is used for carrying out cold and hot data isolation judgment on the mobile phone number to be managed; the number storage allocation module is used for carrying out memory allocation according to the set of each mobile phone number to be managed; the number resource sharing module is used for sharing the number resources stored in the number storage allocation module; according to the invention, hot data and cold data are respectively stored in different storage media through a cold and hot data isolation technology; storage resources are effectively utilized, data storage efficiency and data access performance are improved, and data security is enhanced.
Description
Technical Field
The invention belongs to the field of data management, relates to a cold and hot data isolation technology, and in particular relates to a number data intelligent management system and method based on the cold and hot data isolation technology.
Background
The number is a digital code for identifying and identifying telephone communication terminals (such as telephone sets and mobile phones), the earliest telephone systems use manual operators to connect two parties of conversation, no fixed number system exists, the invention of an automatic telephone exchange enables telephone communication to be more convenient and popular along with the progress of technology, telephone numbers are introduced for managing and identifying the continuously growing telephone users, the telephone numbers are divided into different areas and parts so as to distinguish different geographic areas, telephone service providers and telephone types, the number of telephone users is rapidly increased along with the rapid development of economy, and corresponding numbers and number data are also increased, so that the rationalization management of the numbers and the number data related to the numbers is very important.
In the current stage, there are some unreasonable places for number data management, for example, two number data with larger consumption habit are stored in the data space with the same access priority, when the user needs to check the number data, more users consume the same response time length as the common user, which is obviously unreasonable; or the number data of the number which is not used for a long time and the number data of the number with higher recent activity are stored in the data space with the same access priority, so that the problem of occupying space resources exists, and obviously, the number data which is not used for a long time can be stored in the data space with low priority.
Therefore, we propose a number data intelligent management system and method based on cold and hot data isolation technology.
Disclosure of Invention
The invention aims at: the invention provides a number data intelligent management system and method based on a cold and hot data isolation technology, which aim to improve the management efficiency of a network operator on the number data.
The intelligent number data management system based on the cold and hot data isolation technology is characterized in that the system comprises:
the number scoring module is used for identifying and scoring the number data of the mobile phone number to be managed;
the number classification module is used for carrying out cold and hot data isolation judgment on the mobile phone number to be managed;
the number storage allocation module is used for carrying out memory allocation according to the set of each mobile phone number to be managed;
and the number resource sharing module is used for sharing the number resources stored in the number storage and distribution module.
Further, the mobile phone number management system also comprises a database, wherein the database stores the number data of all the mobile phone numbers to be managed, and the number data is the number per se, the number state, the number attribution, the call record, the total payment amount and the complaint times of the mobile phone numbers to be managed; the number state is whether the mobile phone number is stopped or not, and the call records are the number of incoming calls, the number of outgoing calls and the total duration of the call.
Further, the number scoring module works as follows:
acquiring the number state of each mobile phone number to be managed, and dividing the mobile phone number to be managed into a cold data set if the number state of the mobile phone number to be managed is shutdown;
acquiring call records of each mobile phone number to be managed, marking incoming number as HURn, calling number as HUCn, marking total duration of call as THSn, wherein n is the number n=1, 2, … …, z and z of each mobile phone number to be managed as positive integers;
acquiring complaint times of each mobile phone number to be managed, recording the complaint times as TSn, and simultaneously acquiring the total payment amount of each mobile phone number to be managed;
calculating a number grading value HMFn of each mobile phone number to be managed based on the number of incoming calls HURn, the number of outgoing calls HUCn, the total duration THSn of the call, and the fixed proportion coefficient a1, the fixed proportion coefficient a2 of the number of outgoing calls and the fixed proportion coefficient a3 of the total duration of the call;
the calculation result of the flow M14 is sent to the number classification module.
Further, the calculation step of the fixed proportionality coefficient is as follows:
the number scoring module obtains the total calling times, the total calling times and the total call time of all mobile phone numbers to be managed in the database in the previous year; respectively denoted as m21, m22, m23;
the number scoring module obtains the total calling times, the total calling times and the total call time of all the mobile phone numbers to be managed in the database in the last year; respectively denoted as m11, m12, m13;
the number scoring module obtains the number of all the mobile phone numbers to be managed in the previous year in the database and records the number as m24; the number of all the mobile phone numbers to be managed in the last year is recorded as m14;
respectively calculating first fixed proportion coefficients n11, n12 and n13 (first proportion coefficients for short) of calling times, calling times and total duration of conversation;
calculating the value of n11+n12+n13, denoted b1; judging whether b1 is equal to 1 or between 0.90 and 1.0; if b1 is equal to 1 or between 0.90 and 1.0, then n11 is taken as a1; n12 is a2; n13 is a3; if b1 is not equal to 1 or is between 0.90 and 1.0, calculating the historical number of the mobile phone number to be managed, and recording as c;
calculating second scaling factors n21, n22, n23 based on c;
bringing n21, n22, n23 into n11, n12, n13, repeating the checking flow of n11, n12, n13 until the second scaling factor n21, n22, n23 satisfies the value n21+n22+n23 equal to 1 or between 0.90 and 1.0;
the end result of loop execution is: n21 as the number of incoming calls a1, n22 as the number of outgoing calls a2, n23 as a fixed scaling factor a3 of the total duration of the call.
Further, the number classification module comprises the following working steps:
the number classification module receives the calculation result HMFn of the flow M14;
analysis of HMFn:
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
the number classification module sends the set of each mobile phone number to be managed to the number storage and distribution module.
Further, the number storage and distribution module works as follows:
acquiring a hot data set, a warm data set and a cold data set;
resetting the data format of the number data in the hot data set, the warm data set and the cold data set;
the number data in the processed hot data set is stored into a cache server in a memory; the number data in the warm data set is stored in the disk; the number data in the warm data set and the cold data set are stored in the database.
Further, the step of resetting the data format is as follows:
extracting all number data in the hot data set, the warm data set and the cold data set;
extracting the number of the mobile phone number to be managed in the number data;
extracting the first three network identification codes of the mobile phone number, the region codes of the fourth bit to the seventh bit, and the user numbers of the eighth bit to the eleventh bit;
establishing a network identification code for mobile phone numbers in a hot data set, a warm data set and a cold data set, and marking the area code and the user number as x;
selecting the mapping with the same mobile phone network identification code in x, and marking as x1;
selecting the mapping with the same mobile phone network identification code in x1, and marking as x2;
creating Graph data relation for mobile phone numbers in the hot data set according to the data mapping relation of x2; creating Graph data relationship for mobile phone numbers in the warm data set;
and cutting off the mobile phone number in the warm data set and the mobile phone number in the cold data set according to the data mapping relation of x 2.
Further, the storing step of the Graph data relationship is as follows:
storing a mobile phone number network identification code in a cache server or a disk array to obtain a first address code;
opening up a new storage space in a cache server or a disk array, and obtaining a second address code by storing mobile phone number area codes;
opening up new storage space in the cache server or the disk array again, and obtaining a third ground code by storing the mobile phone number and the user number;
reading the data mapping relation of x2 in the process M328, and setting the rear index of the network identification code corresponding to the mobile phone number as a second address code; setting a front index corresponding to the mobile phone number region code as a first address code and a rear index as a second address code; the front index of the user number corresponding to the mobile number is set to the second address code.
Further, the number resource sharing module works as follows:
obtaining geographic position information, data receiving port information and type information of each network operator;
and classifying the mobile phone numbers stored in the number storage and distribution module according to the types of network operators. Obtaining a classification result;
classifying the mobile phone numbers stored in the number storage allocation module according to the specific regions according to the classification results;
and according to the classification result, the number data is sent to the data receiving ports of the network operators corresponding to each place, so that the distributed number resource sharing is realized.
The intelligent management system method for the number data based on the cold and hot data isolation technology is characterized by comprising the following steps of:
step S1: calculating a fixed proportion coefficient of the number data participating in scoring the mobile phone number;
step S2: scoring the mobile phone number according to the number data;
step S3: classifying the mobile phone numbers according to the number classification values of the mobile phone numbers;
step S4: resetting the data format of the number data;
step S5: memory allocation is carried out according to the set of each mobile phone number to be managed;
step S6: and sharing the number resource by using a cache server.
Further, the complete classification criteria of the step S3 are:
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number grading value of a certain mobile phone number to be managed is larger than the first grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a temperature data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to a second grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, the mobile phone number to be managed is divided into a cold data set.
Further, in the step S6, the processing ideas of the data in the cache server and the disk are shared:
the network identification number field, the area number field and the user number field of the specific mobile phone number in the cache server are converted into corresponding int type data by using a hash function; the network operators of each place send the geographical position information and the data receiving port information of the network operators to corresponding network operator headquarters, and the headquarters upload the geographical position information and the data receiving port information of the network operators of each place to the number resource sharing module, and then the number resource sharing module analyzes the geographical position information and the data receiving port information and sends the geographical position information and the data receiving port information to the network operators of each place.
In summary, due to the adoption of the technical scheme, the beneficial effects of the invention are as follows:
1. the hot data and the cold data are stored in different storage media respectively through a cold and hot data isolation technology. Hot data is typically frequently accessed and updated data, while cold data is infrequently accessed and updated data, effectively utilizing storage resources, improving efficiency and cost effectiveness of data storage.
2. Data access performance is improved: the hot data is stored in a high-performance storage medium, so that the read-write speed and response time of the data can be improved, and the method is very important for application scenes needing to quickly access and process the number data, such as number inquiry, number allocation and the like.
3. Data security enhancement: sensitive and important data can be stored in a storage medium with higher security through a cold and hot data isolation technology, and better data protection and security are provided.
Drawings
The present invention is further described below with reference to the accompanying drawings for the convenience of understanding by those skilled in the art.
FIG. 1 is a block diagram of a management system of the present invention;
FIG. 2 is a step diagram of a management method according to the present invention;
fig. 3 is an illustration of a data node of the present invention.
Detailed Description
The technical solutions of the present invention will be clearly and completely described in connection with the embodiments, and it is obvious that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Example 1
Referring to fig. 1, the present invention provides a technical solution: the intelligent management system for the number data based on the cold and hot data isolation technology comprises a database, a number scoring module, a number classifying module, a number storage and distribution module and a number resource sharing module;
the database stores the number data of all the mobile phone numbers to be managed, wherein the number data is the number per se, the number state, the number attribution, the call record, the total payment amount and the complaint times of the mobile phone numbers; the number state is whether the mobile phone number is stopped or not, and the call records are the number of incoming calls, the number of outgoing calls and the total duration of the call;
scheme M1: the number scoring module is used for identifying and scoring the number data of the mobile phone number to be managed, and the working steps are as follows:
scheme M11: firstly, obtaining the number state of each mobile phone number to be managed, and if the number state of the mobile phone number to be managed is shutdown, dividing the mobile phone number to be managed into a cold data set;
scheme M12: acquiring call records of each mobile phone number to be managed, marking incoming number as HURn, calling number as HUCn, marking total duration of call as THSn, wherein n is the number n=1, 2, … …, z and z of each mobile phone number to be managed as positive integers;
scheme M13: acquiring complaint times of each mobile phone number to be managed, recording the complaint times as TSn, and simultaneously acquiring the total payment amount of each mobile phone number to be managed;
scheme M14: please refer to the consumption systemThe number reference table calculates the number grading value HMFn of each mobile phone number to be managed according to the formula, wherein the formula is specifically as follows:wherein a1, a2 and a3 are fixed proportion coefficients of incoming times, outgoing times and total duration of conversation, values of a1, a2 and a3 are all larger than 0, a1+a2+a3=1, and lambda is a consumption coefficient corresponding to different consumption amounts of mobile phone numbers to be managed;
wherein, the consumption coefficient reference table is:
scheme M15: the calculation result of the flow M14 is sent to a number classification module;
the calculation process of the proportionality coefficient in the flow M14 is as follows:
scheme M141: the number scoring module obtains the total calling times, the total calling times and the total call time of all mobile phone numbers to be managed in the database in the previous year; respectively denoted as m21, m22, m23;
scheme M142: the number scoring module obtains the total calling times, the total calling times and the total call time of all the mobile phone numbers to be managed in the database in the last year; respectively denoted as m11, m12, m13;
scheme M143: the number scoring module obtains the number of all the mobile phone numbers to be managed in the previous year in the database and records the number as m24; the number of all the mobile phone numbers to be managed in the last year is recorded as m14;
scheme M144: respectively calculating first fixed proportion coefficients n11, n12 and n13 (first proportion coefficients for short) of calling times, calling times and total duration of conversation; n1=m21/m 11; n2=m22/m 12; n3=m23/m 13;
scheme M145: calculating the value of n11+n12+n13, denoted b1; judging whether b1 is equal to 1 or between 0.90 and 1.0; if b1 is equal to 1 or between 0.90 and 1.0, then n11 is taken as a1; n12 is a2; n13 is a3; if b1 is not equal to 1 or is between 0.90 and 1.0, calculating the historical number of the mobile phone number to be managed, and recording as c; c= (m24+m14)/2, go to flow M146;
scheme M146: calculating second scaling factors n21, n22, n23; n21=n11- (1/c); n22=n12- (1/c); n23=n13- (1/c);
scheme M147: taking the calculation result of the flow M146 into the flow M145, and repeatedly executing the flows M145-M147; until the second scaling factors n21, n22, n23 meet that the value of n21+n22+n23 is equal to 1 or between 0.90 and 1.0;
scheme M148: the end result of loop execution of flow M147: n21 as the number of incoming calls a1, n22 as the number of outgoing calls a2, n23 as a fixed scaling factor a3 of the total duration of the call.
Scheme M2: the number classification module is used for carrying out cold and hot data isolation judgment on the mobile phone number to be managed, and the working steps are as follows:
scheme M21: the number classification module receives the calculation result HMFn of the flow M14;
scheme M22: please refer to the classification reference table, analyze the HMFn;
wherein, the classification reference table specifically comprises:
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number grading value of a certain mobile phone number to be managed is larger than the first grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a temperature data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to a second grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
it should be noted that, the first classification threshold and the second classification threshold are data pre-stored in the database, and generally, the first classification threshold is taken as 89.9, and the second classification threshold is taken as 79.9; if the network operator has specific parameters of different levels of thresholds or a sound different level of threshold division system, setting the thresholds in the process M15 according to the specification of the network operator;
it should be noted that, if the mobile phone number to be managed is in the hot data set, it is indicated that the mobile phone number to be managed has high frequency of recent use and no bad use record, and the mobile phone number user to be managed is a high-quality user, and needs to provide high-quality service for the user; if the mobile phone number to be managed is in the warm data set, the mobile phone number to be managed is higher in use frequency or fewer in bad use records, and the mobile phone number user to be managed is a good user and needs to be provided with excellent service; if the mobile phone number to be managed is in the warm data set, the mobile phone number to be managed is higher in use frequency or fewer in bad use records, and the mobile phone number user to be managed is a general user and needs to be provided with common service; if the mobile phone number to be managed is in the cold data set, the mobile phone number to be managed is extremely few in use times or has a plurality of bad use records, is complained for a plurality of times, and only needs to provide basic service for the mobile phone number to be managed;
scheme M23: the number classification module sends the set of each mobile phone number to be managed to the number storage and distribution module;
scheme M3: the number storage allocation module is used for performing memory allocation according to the set of each mobile phone number to be managed, and the specific allocation process is as follows:
scheme M31: acquiring a hot data set, a warm data set and a cold data set;
scheme M32: resetting the data format of the number data in the hot data set, the warm data set and the cold data set;
scheme M33: the number data in the hot data set processed by the process M32 is stored into a cache server in a memory; the number data in the warm data set is stored in the disk; the number data in the warm data set and the cold data set are stored in a database;
it should be noted that, the access speed of the cache server in the memory is greater than the access speed of the disk, and the access speed of the disk is greater than the access speed of the database; when the number data is accessed, the cache server in the memory is accessed preferentially, then the disk is accessed, and finally the database is accessed; the cache server in the memory adopts a distributed storage architecture, the number data are distributed on a plurality of nodes, each storage node stores a part of the number data and provides a corresponding data access interface, and when the access is carried out, the number data can be obtained only through the access interface, so that the performance is improved;
the data format resetting process of the number data in the flow M32 is as follows:
scheme M321: extracting all number data in the hot data set, the warm data set and the cold data set;
scheme M322: extracting the number of the mobile phone number to be managed in the number data;
scheme M323: extracting the first three network identification codes of the mobile phone number, the region codes of the fourth bit to the seventh bit, and the user numbers of the eighth bit to the eleventh bit;
scheme M324: establishing a network identification code for mobile phone numbers in a hot data set, a warm data set and a cold data set, and marking the area code and the user number as x;
flow M325: referring to the network identification number list of the mobile phone number, selecting the mapping with the same mobile phone network identification code in x, and marking as x1;
the mobile phone number network identification number list specifically comprises:
scheme M326: referring to table 4, selecting the same mapping of the mobile phone network identification codes in x1, and marking as x2; the region number reference table is specifically as follows:
scheme M327: referring to fig. 3, according to the data mapping relationship of x2, creating a Graph data relationship for the mobile phone number in the hot data set; creating Graph data relationship for mobile phone numbers in the warm data set;
scheme M328: referring to a mobile phone number storage table, according to the data mapping relation of x2, cutting off the mobile phone numbers in the warm data set and the mobile phone numbers in the cold data set;
the mobile phone number storage table is specifically as follows:
in the present application, if a number appears in a table or a drawing, the number is merely a sample demonstration and no real meaning is provided.
The number data storage process of the Graph data relationship in the flow M33 is as follows:
scheme M331: storing a mobile phone number network identification code in a cache server or a disk array to obtain a first address code;
scheme M332: opening up a new storage space in a cache server or a disk array, and obtaining a second address code by storing mobile phone number area codes;
scheme M333: opening up new storage space in the cache server or the disk array again, and obtaining a third ground code by storing the mobile phone number and the user number;
flow M334: reading the data mapping relation of x2 in the process M328, and setting the rear index of the network identification code corresponding to the mobile phone number as a second address code; setting a front index corresponding to the mobile phone number region code as a first address code and a rear index as a second address code; the front index of the user number corresponding to the mobile number is set to the second address code.
Scheme M4: the number resource sharing module is used for sharing the number resources stored in the number storage allocation module;
scheme M41: obtaining geographic location information, data receiving port information and type information of each network operator (type information refers to specific network operators, such as mobile, communication and telecom … …);
scheme M42: the mobile phone numbers stored in the number storage allocation module are classified according to the types of network operators, and the main SQL sentences are as follows: a GROUP BY network identification number of a SELECT complete mobile phone number FROM mobile phone number storage list;
scheme M43: the mobile phone numbers stored in the number storage allocation module are classified according to specific regions according to the classification result of the flow M42, and the main SQL sentences are as follows: a SELECT complete phone number FROM phone number storage table GROUP BY region number in (SELECT complete phone number FROM phone number storage table GROUP BY network identification number);
scheme M44: and sending the number data to the data receiving ports of the network operators corresponding to each place according to the classification result of the flow M43, and realizing distributed number resource sharing.
Example two
Referring to fig. 2, the intelligent management method for the number data based on the cold and hot data isolation technology comprises the following steps:
step S1: calculating a fixed proportion coefficient of the number data participating in scoring the mobile phone number;
step S11: the number scoring module obtains the total calling times, the total calling times and the total call time of all mobile phone numbers to be managed in the database in the previous year; respectively denoted as m21, m22, m23;
step S12: the number scoring module obtains the total calling times, the total calling times and the total call time of all the mobile phone numbers to be managed in the database in the last year; respectively denoted as m11, m12, m13;
step S13: the number scoring module obtains the number of all the mobile phone numbers to be managed in the previous year in the database and records the number as m24; the number of all the mobile phone numbers to be managed in the last year is recorded as m14;
step S14: respectively calculating first fixed proportion coefficients n11, n12 and n13 (first proportion coefficients for short) of calling times, calling times and total duration of conversation; n1=m21/m 11; n2=m22/m 12; n3=m23/m 13;
step S15: calculating the value of n11+n12+n13, denoted b1; judging whether b1 is equal to 1 or between 0.90 and 1.0; if b1 is equal to 1 or between 0.90 and 1.0, then n11 is taken as a1; n12 is a2; n13 is a3; if b1 is not equal to 1 or is between 0.90 and 1.0, calculating the historical number of the mobile phone number to be managed, and recording as c; c= (m24+m14)/2, go to flow M146;
step S16: calculating second scaling factors n21, n22, n23; n21=n11- (1/c); n22=n12- (1/c); n23=n13- (1/c);
step S17: step S15, the calculation result of the step S16 is carried into the step S15, and the steps S15 to S17 are repeatedly executed; until the second scaling factors n21, n22, n23 meet that the value of n21+n22+n23 is equal to 1 or between 0.90 and 1.0;
step S18: the final result of loop execution of step S17: n21 as the number of incoming calls a1, n22 as the number of outgoing calls a2, n23 as a fixed scaling factor a3 of the total duration of the call.
Step S2: scoring the mobile phone number according to the number data;
step S21: acquiring the number state of each mobile phone number to be managed, and dividing the mobile phone number to be managed into a cold data set if the number state of the mobile phone number to be managed is shutdown;
step S22: acquiring call records of each mobile phone number to be managed, marking incoming number as HURn, calling number as HUCn, marking total duration of call as THSn, wherein n is the number n=1, 2, … …, z and z of each mobile phone number to be managed as positive integers;
step S23: acquiring complaint times of each mobile phone number to be managed, recording the complaint times as TSn, and simultaneously acquiring the total payment amount of each mobile phone number to be managed;
step S24: referring to the consumption coefficient reference table, the number classification value HMFn of each mobile phone number to be managed is calculated according to the formula, where the formula is specifically:wherein a1, a2 and a3 are fixed proportion coefficients of incoming times, outgoing times and total duration of conversation, values of a1, a2 and a3 are all larger than 0, a1+a2+a3=1, and lambda is a consumption coefficient corresponding to different consumption amounts of mobile phone numbers to be managed;
step S3: classifying the mobile phone numbers according to the number classification values of the mobile phone numbers;
please refer to the above-mentioned classification reference table, to analyze HMFn;
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number grading value of a certain mobile phone number to be managed is larger than the first grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a temperature data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to a second grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, the mobile phone number to be managed is divided into a cold data set.
Step S4: resetting the data format of the number data;
step S41: extracting all number data in the hot data set, the warm data set and the cold data set;
step S42: extracting the number of the mobile phone number to be managed in the number data;
step S43: extracting the first three network identification codes of the mobile phone number, the region codes of the fourth bit to the seventh bit, and the user numbers of the eighth bit to the eleventh bit;
step S44: establishing a network identification code for mobile phone numbers in a hot data set, a warm data set and a cold data set, and marking the area code and the user number as x;
step S45: referring to the above-mentioned mobile phone number network identification number list, selecting the mapping of the same mobile phone network identification code in x, and recording as x1;
step S46: referring to the region number reference table, selecting the same mapping of the mobile phone network identification code in x1, and marking as x2;
step S47: referring to fig. 3, according to the data mapping relationship of x2, creating a Graph data relationship for the mobile phone number in the hot data set; creating Graph data relationship for mobile phone numbers in the warm data set;
step S48: referring to the mobile phone number storage table, according to the data mapping relation of x2, mobile phone numbers in the warm data set and mobile phone numbers in the cold data set are truncated.
Step S5: memory allocation is carried out according to the set of each mobile phone number to be managed;
step S51: acquiring a hot data set, a warm data set and a cold data set;
step S52: resetting the data format of the number data in the hot data set, the warm data set and the cold data set;
step S53: storing the number data in the hot data set processed in the step S52 into a cache server in a memory; the number data in the warm data set is stored in the disk; the number data in the warm data set and the cold data set are stored in a database;
step S6: sharing the number resource by using a cache server;
step S61: obtaining geographic position information, data receiving port information and type information of each network operator;
step S62: the mobile phone numbers stored in the number storage allocation module are classified according to the types of network operators, and the main SQL sentences are as follows: a GROUP BY network identification number of a SELECT complete mobile phone number FROM mobile phone number storage list;
step S63: according to the classification result of step S62, the mobile phone numbers stored in the number storage allocation module are classified according to specific regions, and the main SQL statement is as follows: a SELECT complete phone number FROM phone number storage table GROUP BY region number in (SELECT complete phone number FROM phone number storage table GROUP BY network identification number);
step S64: and (3) sending the number data to the data receiving ports of the corresponding network operators in each place according to the classification result in the step (S63) to realize distributed number resource sharing.
The preferred embodiments of the invention disclosed above are intended only to assist in the explanation of the invention. The preferred embodiments are not intended to be exhaustive or to limit the invention to the precise form disclosed.
It should be noted that, since there is no unified query statement format, the cache server and the data in the disk refer to and illustrate the corresponding processing concept:
the network identification number field, the area number field and the user number field of the specific mobile phone number in the cache server are converted into corresponding int type data by using a hash function; the network operators of each place send the geographical position information and the data receiving port information of the network operators to corresponding network operator headquarters, and the headquarters upload the geographical position information and the data receiving port information of the network operators of each place to the number resource sharing module, and then the number resource sharing module analyzes the geographical position information and the data receiving port information and sends the geographical position information and the data receiving port information to the network operators of each place.
In the present application, if a corresponding calculation formula appears, the calculation formulas are all dimensionalized and take numerical calculation, and the coefficients such as a weight coefficient, a scaling factor and the like in the formulas are set to be a result value obtained by quantizing each parameter, and the sizes of the weight coefficient and the scaling factor are only required to not influence the proportional relation between the parameter and the result value.
Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best understand and utilize the invention. The invention is limited only by the claims and the full scope and equivalents thereof.
Claims (12)
1. The intelligent number data management system based on the cold and hot data isolation technology is characterized in that the system comprises:
the number scoring module is used for identifying and scoring the number data of the mobile phone number to be managed;
the number classification module is used for carrying out cold and hot data isolation judgment on the mobile phone number to be managed;
the number storage allocation module is used for carrying out memory allocation according to the set of each mobile phone number to be managed;
and the number resource sharing module is used for sharing the number resources stored in the number storage and distribution module.
2. The intelligent management system for number data based on cold and hot data isolation technology according to claim 1, further comprising a database for storing number data of all mobile phone numbers to be managed, wherein the number data is number per se, number status, number attribution, call record, total payment amount and number of complaints of each mobile phone number to be managed; the number state is whether the mobile phone number is stopped or not, the call records are the number of incoming calls, the number of outgoing calls and the total duration of the call, and the number data of the mobile phone number to be managed are identified and scored through a number scoring module.
3. The intelligent management system for number data based on cold and hot data isolation technology according to claim 1, wherein the number scoring module identifies and scores the following working procedures:
acquiring the number state of each mobile phone number to be managed, and dividing the mobile phone number to be managed into a cold data set if the number state of the mobile phone number to be managed is shutdown;
acquiring call records of each mobile phone number to be managed, marking incoming number as HURn, calling number as HUCn, marking total duration of call as THSn, wherein n is the number n=1, 2, … …, z and z of each mobile phone number to be managed as positive integers;
acquiring complaint times of each mobile phone number to be managed, recording the complaint times as TSn, and simultaneously acquiring the total payment amount of each mobile phone number to be managed;
calculating a number grading value HMFn of each mobile phone number to be managed based on the number of incoming calls HURn, the number of outgoing calls HUCn, the total duration THSn of the call, and the fixed proportion coefficient a1, the fixed proportion coefficient a2 of the number of outgoing calls and the fixed proportion coefficient a3 of the total duration of the call;
and sending the calculation result to a number classification module.
4. The intelligent management system for number data based on cold and hot data isolation technology according to claim 3, wherein the step of calculating the fixed proportionality coefficient is as follows:
the number scoring module obtains the total calling times, the total calling times and the total call time of all mobile phone numbers to be managed in the database in the previous year; respectively denoted as m21, m22, m23;
the number scoring module obtains the total calling times, the total calling times and the total call time of all the mobile phone numbers to be managed in the database in the last year; respectively denoted as m11, m12, m13;
the number scoring module obtains the number of all the mobile phone numbers to be managed in the previous year in the database and records the number as m24; the number of all the mobile phone numbers to be managed in the last year is recorded as m14;
respectively calculating first proportional coefficients n11, n12 and n13 of the number of incoming calls, the number of outgoing calls and the total duration of the call;
calculating the value of n11+n12+n13, denoted b1; judging whether b1 is equal to 1 or between 0.90 and 1.0; if b1 is equal to 1 or between 0.90 and 1.0, then n11 is taken as a1; n12 is a2; n13 is a3; if b1 is not equal to 1 or is between 0.90 and 1.0, calculating the historical number of the mobile phone number to be managed, and recording as c;
calculating second scaling factors n21, n22, n23 based on c;
bringing n21, n22, n23 into n11, n12, n13, repeating the checking flow of n11, n12, n13 until the second scaling factor n21, n22, n23 satisfies the value n21+n22+n23 equal to 1 or between 0.90 and 1.0;
the end result of loop execution is: n21 as the number of incoming calls a1, n22 as the number of outgoing calls a2, n23 as a fixed scaling factor a3 of the total duration of the call.
5. The intelligent management system for number data based on cold and hot data isolation technology according to claim 3, wherein the number classification module comprises the following working steps:
the number classification module receives a calculation result HMFn;
analysis of HMFn:
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
the number classification module sends the set of each mobile phone number to be managed to the number storage and distribution module.
6. The intelligent management system for number data based on cold and hot data isolation technology according to claim 5, wherein the working process of the number storage and distribution module is as follows:
acquiring a hot data set, a warm data set and a cold data set;
resetting the data format of the number data in the hot data set, the warm data set and the cold data set;
the number data in the processed hot data set is stored into a cache server in a memory; the number data in the warm data set is stored in the disk; the number data in the warm data set and the cold data set are stored in the database.
7. The intelligent management system for number data based on cold and hot data isolation technology according to claim 6, wherein the step of resetting the data format is as follows:
extracting all number data in the hot data set, the warm data set and the cold data set;
extracting the number of the mobile phone number to be managed in the number data;
extracting the first three network identification codes of the mobile phone number, the region codes of the fourth bit to the seventh bit, and the user numbers of the eighth bit to the eleventh bit;
establishing a network identification code for mobile phone numbers in a hot data set, a warm data set and a cold data set, and marking the area code and the user number as x;
selecting the mapping with the same mobile phone network identification code in x, and marking as x1;
selecting the mapping with the same mobile phone network identification code in x1, and marking as x2;
creating Graph data relation for mobile phone numbers in the hot data set according to the data mapping relation of x2; creating Graph data relationship for mobile phone numbers in the warm data set;
and cutting off the mobile phone number in the warm data set and the mobile phone number in the cold data set according to the data mapping relation of x 2.
8. The intelligent management system for number data based on cold and hot data isolation technology according to claim 7, wherein the storing step of the Graph data relationship is as follows:
storing a mobile phone number network identification code in a cache server or a disk array to obtain a first address code;
opening up a new storage space in a cache server or a disk array, and obtaining a second address code by storing mobile phone number area codes;
opening up new storage space in the cache server or the disk array again, and obtaining a third ground code by storing the mobile phone number and the user number;
reading the data mapping relation of x2, and setting the rear index of the network identification code corresponding to the mobile phone number as a second address code; setting a front index corresponding to the mobile phone number region code as a first address code and a rear index as a second address code; the front index of the user number corresponding to the mobile number is set to the second address code.
9. The intelligent management system for number data based on cold and hot data isolation technology according to claim 1, wherein the number resource sharing module works as follows:
obtaining geographic position information, data receiving port information and type information of each network operator;
classifying the mobile phone numbers stored in the number storage and distribution module according to the types of network operators to obtain classification results;
classifying the mobile phone numbers stored in the number storage allocation module according to the specific regions according to the classification results;
and according to the classification result, the number data is sent to the data receiving ports of the network operators corresponding to each place, so that the distributed number resource sharing is realized.
10. The intelligent management method for the number data based on the cold and hot data isolation technology is characterized by being applicable to the intelligent management system for the number data based on the cold and hot data isolation technology as claimed in any one of claims 1 to 9, and the management system method comprises the following steps:
step S1: calculating a fixed proportion coefficient of the number data participating in scoring the mobile phone number;
step S2: scoring the mobile phone number according to the number data;
step S3: classifying the mobile phone numbers according to the number classification values of the mobile phone numbers;
step S4: resetting the data format of the number data;
step S5: memory allocation is carried out according to the set of each mobile phone number to be managed;
step S6: and sharing the number resource by using a cache server.
11. The intelligent management method for number data based on cold and hot data isolation technology according to claim 10, wherein the complete classification criteria of step S3 are as follows:
if the number grading value of a certain mobile phone number to be managed is larger than a first grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a hot data set;
if the number grading value of a certain mobile phone number to be managed is larger than the first grading threshold value but complaint records exist, dividing the mobile phone number to be managed into a temperature data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number classification value of a certain mobile phone number to be managed is larger than the second classification threshold value and smaller than or equal to the first classification threshold value but complaint records exist, dividing the mobile phone number to be managed into a cold data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to a second grading threshold value and no complaint record exists, dividing the mobile phone number to be managed into a warm data set;
if the number grading value of a certain mobile phone number to be managed is smaller than or equal to the second grading threshold value but complaint records exist, the mobile phone number to be managed is divided into a cold data set.
12. The intelligent management method for the number data based on the cold and hot data isolation technology according to claim 10, wherein in the step S6, the processing ideas of the data in the cache server and the disk are shared:
the network identification number field, the area number field and the user number field of the specific mobile phone number in the cache server are converted into corresponding int type data by using a hash function; the network operators of each place send the geographical position information and the data receiving port information of the network operators to corresponding network operator headquarters, and the headquarters upload the geographical position information and the data receiving port information of the network operators of each place to the number resource sharing module, and then the number resource sharing module analyzes the geographical position information and the data receiving port information and sends the geographical position information and the data receiving port information to the network operators of each place.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311261003.6A CN117376303B (en) | 2023-09-27 | 2023-09-27 | Intelligent number data management system and method based on cold and hot data isolation technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311261003.6A CN117376303B (en) | 2023-09-27 | 2023-09-27 | Intelligent number data management system and method based on cold and hot data isolation technology |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117376303A true CN117376303A (en) | 2024-01-09 |
| CN117376303B CN117376303B (en) | 2024-10-01 |
Family
ID=89399419
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311261003.6A Active CN117376303B (en) | 2023-09-27 | 2023-09-27 | Intelligent number data management system and method based on cold and hot data isolation technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117376303B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006311556A (en) * | 2005-04-27 | 2006-11-09 | Lg Electronics Inc | Phonebook search method executed by mobile communication terminal and phonebook search means in mobile communication terminal |
| CN104704505A (en) * | 2012-08-28 | 2015-06-10 | 维萨国际服务协会 | Protecting assets on a device |
| CN106934001A (en) * | 2017-03-03 | 2017-07-07 | 广州天源迪科信息技术有限公司 | Distributed quick inventory inquiry system and method |
| US20180324297A1 (en) * | 2016-11-01 | 2018-11-08 | Transaction Network Services, Inc. | Systems and methods for automatically conducting risk assessments for telephony communications |
-
2023
- 2023-09-27 CN CN202311261003.6A patent/CN117376303B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006311556A (en) * | 2005-04-27 | 2006-11-09 | Lg Electronics Inc | Phonebook search method executed by mobile communication terminal and phonebook search means in mobile communication terminal |
| CN104704505A (en) * | 2012-08-28 | 2015-06-10 | 维萨国际服务协会 | Protecting assets on a device |
| US20180324297A1 (en) * | 2016-11-01 | 2018-11-08 | Transaction Network Services, Inc. | Systems and methods for automatically conducting risk assessments for telephony communications |
| CN106934001A (en) * | 2017-03-03 | 2017-07-07 | 广州天源迪科信息技术有限公司 | Distributed quick inventory inquiry system and method |
Non-Patent Citations (1)
| Title |
|---|
| 葛微;罗圣美;周文辉;赵;唐云;周娟;曲文武;袁春风;黄宜华;: "HiBase:一种基于分层式索引的高效HBase查询技术与系统", 计算机学报, no. 01, 30 January 2016 (2016-01-30) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117376303B (en) | 2024-10-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102906751B (en) | Method and device for data storage and data query | |
| CN105227793B (en) | Circuit selecting method and device | |
| CN102083010B (en) | Method and equipment for screening user information | |
| CN113297269B (en) | Data query method and device | |
| CN101778180B (en) | Interactive voice response system business node dynamic adjustment control method | |
| CN101000677A (en) | Matching method and system of marketing business recommended | |
| CN104113466A (en) | Harassing phone call identification method, client, server and system | |
| CN111328082A (en) | Base station planning method, device, equipment and storage medium | |
| CN113850630B (en) | Satisfaction prediction method and device, storage medium and electronic equipment | |
| CN108376143A (en) | A kind of novel OLAP precomputations model and the method for generating precomputation result | |
| CN113891336B (en) | Method, device, computer equipment and storage medium for frequency reduction and denetting of communication network | |
| CN106570108A (en) | Adaptive reading optimization method and system for mass data under cloud storage environment | |
| CN108390929A (en) | Method and device for acquiring user's resident location | |
| CN108897796A (en) | A kind of operation system calls method, storage medium and the server of influxdb database | |
| CN111062422B (en) | Method and device for identifying set-way loan system | |
| CN112182021B (en) | User data query method, device and system | |
| CN100371931C (en) | A Method of Fast Access to Database | |
| CN117376303B (en) | Intelligent number data management system and method based on cold and hot data isolation technology | |
| CN112307075B (en) | User relationship identification method and device | |
| CN112996015B (en) | A method and device for constructing indicator correlation relationships | |
| CN101729929A (en) | System for accessing mass data with intelligent network business libraries, device and method | |
| CN115955528B (en) | A method, apparatus and readable storage medium for identifying a number | |
| CN109840802B (en) | Communication method and device, real estate system, computer and readable storage medium | |
| CN100488219C (en) | Method for traffic data gathering and analysis statistic | |
| CN117082452A (en) | Method and device for determining residence position of user, electronic equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |