CN111356122A - Service data processing method and device - Google Patents
Service data processing method and device Download PDFInfo
- Publication number
- CN111356122A CN111356122A CN201811581364.8A CN201811581364A CN111356122A CN 111356122 A CN111356122 A CN 111356122A CN 201811581364 A CN201811581364 A CN 201811581364A CN 111356122 A CN111356122 A CN 111356122A
- Authority
- CN
- China
- Prior art keywords
- mobile phone
- phone number
- detected
- time
- cleaning
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title description 23
- 238000004140 cleaning Methods 0.000 claims abstract description 136
- 238000000034 method Methods 0.000 claims abstract description 49
- 238000004590 computer program Methods 0.000 claims description 16
- 238000003860 storage Methods 0.000 claims description 12
- 230000008030 elimination Effects 0.000 abstract description 2
- 238000003379 elimination reaction Methods 0.000 abstract description 2
- 230000008569 process Effects 0.000 description 19
- 238000010586 diagram Methods 0.000 description 16
- 238000001514 detection method Methods 0.000 description 15
- 230000006870 function Effects 0.000 description 7
- 230000001960 triggered effect Effects 0.000 description 6
- 230000006399 behavior Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 230000007488 abnormal function Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008014 freezing Effects 0.000 description 1
- 238000007710 freezing Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008447 perception Effects 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W8/00—Network data management
- H04W8/18—Processing of user or subscriber data, e.g. subscribed services, user preferences or user profiles; Transfer of user or subscriber data
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W60/00—Affiliation to network, e.g. registration; Terminating affiliation with the network, e.g. de-registration
- H04W60/04—Affiliation to network, e.g. registration; Terminating affiliation with the network, e.g. de-registration using triggered events
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W60/00—Affiliation to network, e.g. registration; Terminating affiliation with the network, e.g. de-registration
- H04W60/06—De-registration or detaching
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W8/00—Network data management
- H04W8/22—Processing or transfer of terminal data, e.g. status or physical capabilities
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W8/00—Network data management
- H04W8/26—Network addressing or numbering for mobility support
Abstract
The invention relates to the technical field of networks, in particular to a method and a device for processing service data, wherein the method comprises the steps of acquiring the number placing time of a mobile phone number to be detected and the associated time in a service system when a preset cleaning triggering condition is met; the mobile phone number to be detected is a related mobile phone number in a service system; determining whether the mobile phone number to be detected belongs to secondary number allocation or not according to the number allocation time and the associated time in the service system; and if the mobile phone number belongs to the secondary number allocation, cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system, so that the mobile phone number belonging to the secondary number allocation can be actively detected and found without manual passive elimination and judgment, and correspondingly cleaning the service data, thereby improving the processing efficiency, saving the time and improving the user experience.
Description
Technical Field
The present invention relates to the field of network technologies, and in particular, to a method and an apparatus for processing service data.
Background
At present, business systems such as various websites and Application programs (APPs) can mostly support the registration of an account number by using a mobile phone number, but the mobile phone number is not always permanently associated with a current user, for example, when the user logs out the mobile phone number and is disassociated in an operator system, the mobile phone number cannot represent the user actually. In addition, after a certain time, the operator will generally re-release the previously cancelled number for the new user to open an account, that is, called secondary number release, at this time, if the service data of the previous user is not cleared in the service system, the use of the new user and information leakage will be affected.
In the prior art, a service data processing method in a service system generally solves problems through user feedback, and according to the problems fed back by a user, manual detection is performed to check whether a mobile phone number associated in the service system belongs to secondary number allocation or not, and processing is performed.
Disclosure of Invention
The embodiment of the invention provides a method and a device for processing service data, which aim to solve the problems that in the prior art, the service data corresponding to secondary number allocation can be manually detected and only can be passively cleaned, and the processing efficiency is low.
The embodiment of the invention provides the following specific technical scheme:
a service data processing method comprises the following steps:
when a preset cleaning triggering condition is met, acquiring the number placing time of the mobile phone number to be detected and the correlation time in a service system; the mobile phone number to be detected is a related mobile phone number in a service system;
determining whether the mobile phone number to be detected belongs to secondary number allocation or not according to the number allocation time and the associated time in the service system;
and if the mobile phone number belongs to the secondary number allocation, cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system.
Optionally, meeting the preset cleaning triggering condition specifically includes:
when a preset period is reached, determining that a preset cleaning triggering condition is met; or the like, or, alternatively,
and when the cleaning request sent by the service system is determined to be received, determining that a preset cleaning triggering condition is met.
Optionally, the time for placing the number of the mobile phone to be detected is obtained, which specifically includes:
if the number allocation time of the mobile phone number to be detected is determined to be cached locally, directly acquiring the number allocation time of the mobile phone number to be detected from the local;
and if the number allocation time of the mobile phone number to be detected is determined not to be cached locally, acquiring the number allocation time of the mobile phone number to be detected from a corresponding operator system, and caching the number allocation time to the local.
Optionally, further comprising: and updating the number placing time of the locally cached mobile phone number according to the preset caching duration.
Optionally, determining whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the association time in the service system, specifically including: and if the number allocation time is determined to be later than the associated time in the service system, determining that the mobile phone number to be detected belongs to secondary number allocation.
Optionally, before the service data of the user corresponding to the mobile phone number to be detected is cleaned from the service system, the method further includes: and backing up the service data of the user corresponding to the mobile phone number to be detected.
Optionally, further comprising: and caching the result of determining whether the mobile phone number to be detected belongs to the secondary number allocation.
A service data processing apparatus, comprising:
the acquisition module is used for acquiring the number placing time of the mobile phone number to be detected and the associated time in the service system when the preset cleaning triggering condition is met; the mobile phone number to be detected is a related mobile phone number in a service system;
the determining module is used for determining whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the associated time in the service system;
and the cleaning module is used for cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system if the secondary number allocation is determined.
An electronic device, comprising:
at least one memory for storing a computer program;
at least one processor for implementing the steps of any of the above-described service data processing methods when executing a computer program stored in a memory.
A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of any of the above-mentioned service data processing methods.
In the embodiment of the invention, when the preset cleaning triggering condition is met, the number placing time of the mobile phone number to be detected and the associated time in the service system are obtained; the mobile phone number to be detected is a related mobile phone number in a service system; determining whether the mobile phone number to be detected belongs to secondary number allocation or not according to the number allocation time and the associated time in the service system; and if the mobile phone number belongs to the secondary number allocation, cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system, so that the mobile phone number belonging to the secondary number allocation can be actively detected and found without manual passive elimination and judgment, and correspondingly cleaning the service data, thereby improving the processing efficiency, saving the time and improving the user experience.
Drawings
Fig. 1 is a schematic diagram of an application architecture of a service data processing method according to an embodiment of the present invention;
fig. 2 is a flowchart of a service data processing method according to an embodiment of the present invention;
FIG. 3 is a flow chart of the cleaning execution logic in an embodiment of the present invention;
fig. 4 is a flowchart of another service data processing method based on the active cleaning mode in the embodiment of the present invention;
fig. 5 is a flowchart of another service data processing method based on a service system triggered cleaning mode in the embodiment of the present invention;
fig. 6 is a schematic structural diagram of a service data processing apparatus according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of an electronic device in an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
At present, a user may register in a service system or bind a mobile phone number based on the mobile phone number, but the user may still be associated with the service system after not using the mobile phone number for a certain period of time, for example, the user may not use the service system for a long time and the mobile phone number is not used, and then the association in the service system may not be released. However, after a freezing period, the unused mobile phone number or the cancelled mobile phone number is generally released again by the operator for the new user to open an account, which is called secondary number release. If the service data of the previous user is not cleaned up in the service system, it may cause: 1) abnormal functions, such as the inability of a new user account to register or the inability to activate certain functions; 2) data confusion, for example, seeing that there is an operation record of non-self after logging in; 3) information leakage, such as seeing some private information or records of the previous user account after login, etc.
In the prior art, usually, the user problem feedback can be only used, whether the mobile phone number is released for the second time or not is manually detected again, and corresponding processing is carried out, but in the mode, the following problems can be caused by manual passive detection and cleaning: 1) the cleaning is not timely, and the cleaning is not friendly to new users. For example, a problem that a mobile phone number belonging to secondary number allocation cannot be registered occurs, a customer service needs to be contacted, and technical personnel process the mobile phone number in the background; 2) the cleaning is incomplete. For example, only the user information is cleared, but the user order information is not cleared, if the inquiry function provides inquiry according to the mobile phone number, the situation that the old user order is found may occur; 3) and (4) mistakenly cleaning. For example, when a second-hand transaction system clears the service data corresponding to a certain secondary number, the transaction information with others is erroneously cleared, so that the transaction records are lost by others. 4) The program is compiled to carry out database operation, the coupling with the system is strong, and the cleaning process is not transparent enough. 5) The cleaning process is not recorded, and the problem of rechecking is difficult.
In the embodiment of the invention, based on the above problems, a service data processing method is provided, when a preset cleaning triggering condition is met, whether secondary number allocation is adopted is detected and cleaned, active detection and cleaning are performed, manual operation is not needed, efficiency is improved, old service data can be cleaned in time, a configurable cleaning triggering condition and a cleaning strategy can be supported, and integrity and accuracy of cleaning are ensured.
In addition, the embodiment of the invention can also provide a cache strategy, such as cache number allocation time, secondary number allocation determination results and service data of users needing to be cleaned, thereby improving the performance and the processing efficiency.
Fig. 1 is a schematic diagram of an application architecture of a service data processing method in an embodiment of the present invention, which at least includes a service System, a database, a Business & Operation Support System (BOSS) System, and a cleaning System.
The service system may be any service system that can provide services for the user, such as various APPs, website systems, and the like, and the embodiments of the present invention are not limited thereto. In the embodiment of the invention, the user can register the account number by using the mobile phone number in the service system, or bind the mobile phone number to the registered account number, namely, the mobile phone number can be associated to the corresponding account number in the service system to identify the user. And the service systems can communicate with each other through the database, and the service systems can read and write data from the database.
The database is a database of the service system, and can be used for storing service data and other data of each user in the service system, wherein the service data includes registration time, operation behavior data and the like.
The operator BOSS system is an operator system corresponding to the mobile phone number of the user, for example, an operator system of china mobile, and can provide the number placing time of the mobile phone number.
The cleaning system is a system for executing the service data processing method in the embodiment of the invention, the service system can be communicated with the cleaning system to call corresponding functions, for example, the service system triggers the cleaning system to start executing the service data processing method; the database and the cleaning system can also communicate with each other, for example, when cleaning the service data, the cleaning system executes the reading, writing and storing processes from the database; the cleaning system and the operator BOSS system are communicated with each other, and the service system can inquire the number placing time of the mobile phone number from the operator BOSS system.
Specifically, the cleaning system may include 5 modules, which are respectively a number allocation time detection module, a cache module, a policy module, a cleaning execution module, and a cleaning history management module.
Wherein, 1) time detection module of placing a number: for enabling detection by invoking an interface provided by the operator BOSS system. Inputting parameters: the mobile phone number outputs the result: number placing time.
2) A cache module: the method is used for caching the number placing time of the mobile phone number, and can also be used for caching the result of whether the mobile phone number is placed for the second time, and the like.
In this way, the detection frequency can be reduced, for example, for a mobile phone number whose number placing time is within 1 month, a preset cache duration can be cached, for example, several months, because one number is not repeatedly placed within several months.
Of course, the cache duration may be configured according to actual conditions and requirements, and is not limited in the embodiment of the present invention.
3) A policy module: the method is mainly used for managing specific cleaning execution modes, and comprises a secondary number allocation detection rule, a rule for triggering a cleaning condition in an active cleaning mode, a condition or quantity of users to be detected in a service system and the like.
For example, in the active cleaning mode, it may be set that the mobile phone numbers of the users whose registration time is 100 times a year ago are pulled from the service system at a time, where the registration time refers to the time of registration in the service system.
4) A cleaning execution module: the module is the core of the cleaning system, defines the storage process in advance at the database side, and carries out remote calling when cleaning is required to be executed.
The stored procedures are business-related and may be composed of a plurality of Structured Query Language (SQL) statements and join transactions, as will be described in more detail below.
5) A cleaning history management module: the method is used for storing the cleaning history, namely the business data of the user to be cleaned can be stored before cleaning, so that the follow-up is facilitated.
It should be noted that the application architecture diagram in the embodiment of the present invention is used to more clearly illustrate the technical solution in the embodiment of the present invention, and does not limit the technical solution provided in the embodiment of the present invention, and for other application architectures and service applications, the technical solution provided in the embodiment of the present invention is also applicable to similar problems.
In the embodiments of the present invention, the service data processing method is schematically illustrated by using the application architecture diagram shown in fig. 1 as an example.
Based on the above embodiment, referring to fig. 2, a specific flow of the service data processing method in the embodiment of the present invention is as follows:
step 200: when a preset cleaning triggering condition is met, acquiring the number placing time of the mobile phone number to be detected and the correlation time in a service system; and the mobile phone number to be detected is the associated mobile phone number in the service system.
When step 200 is executed, the method specifically includes:
1) and determining that a preset cleaning triggering condition is met.
Specifically, the preset cleaning triggering condition may include, but is not limited to, the following two ways:
the first mode is as follows: and when the preset period is reached, determining that the preset cleaning triggering condition is met.
That is to say, in the embodiment of the present invention, the service data processing method may be actively executed at regular time, that is, the service data is cleaned, and of course, other trigger conditions for active cleaning besides the timed cleaning may also be set, for example, when it is detected that the load is low, it is determined that the cleaning trigger condition is satisfied, and the embodiment of the present invention is not limited.
Therefore, an active cleaning mode is set, cleaning can be actively triggered, and the service data of the user can be actively processed when the service system load and the operator BOSS system load are low, so that the user can not sense and can be timely processed.
The second mode is as follows: and when the cleaning request sent by the service system is determined to be received, determining that a preset cleaning triggering condition is met.
That is to say, in the embodiment of the present invention, the service system may trigger the cleaning system to execute the service data processing method, so as to clean the service data, for example, when a technician needs to detect whether a mobile phone number associated in the service system is a secondary number allocation and clean related service data, the technician submits a cleaning request, where the cleaning request at least includes the mobile phone number, the association time, and other related information, and further determines that the triggering condition is met.
Therefore, the service system triggers the cleaning mode, so that the user can process key operations such as registration and the like, the relevant data of the user can be cleaned, the perception of the user is reduced, and the use of a new user is not influenced.
2) And acquiring the number allocation time of the mobile phone number to be detected and the associated time in the service system.
The mobile phone number to be detected is a mobile phone number associated with the user account in the service system, and the mobile phone number to be detected and the association time of the mobile phone number to be detected in the service system can be directly pulled from the service system or reported by the service system.
Further, the obtained association time in the service system may also be cached, and specifically, the association time may be cached permanently because the association time is inconvenient.
The number placing time of the mobile phone number to be detected is obtained, and the number placing time can be divided into the following two conditions:
in the first case: and if the number allocation time of the mobile phone number to be detected cached locally is determined, directly acquiring the number allocation time of the mobile phone number to be detected from the local.
In the second case: and if the number allocation time of the mobile phone number to be detected is determined not to be cached locally, acquiring the number allocation time of the mobile phone number to be detected from the corresponding operator system, and caching the number allocation time to the local.
In the embodiment of the invention, a cache mechanism is arranged, and the number allocation time acquired from the corresponding operator system can be cached locally, so that the detection frequency of interaction with the operator can be reduced, the time is saved, the pressure of the BOSS system of the operator is reduced, the efficiency is improved, if the number allocation time of the mobile phone number to be detected is cached locally, the mobile phone number can be acquired directly, and if the number allocation time is not acquired from the operator system.
Further, in order to improve cache effectiveness and save memory occupation, the embodiment of the present invention further provides a possible implementation manner, and the number allocation time of the locally cached mobile phone number is updated according to the preset cache duration.
For example, the preset caching duration is several months, which is not limited in the embodiment of the present invention, and the dynamic adjustment may be performed according to the second number allocation policy of the operator BOSS system.
Step 210: and determining whether the mobile phone number to be detected belongs to secondary number allocation or not according to the number allocation time and the associated time in the service system.
When step 210 is executed, the method specifically includes: and if the number allocation time is determined to be later than the associated time in the service system, determining that the mobile phone number to be detected belongs to secondary number allocation.
The association time in the service system is, for example, user registration time using the mobile phone number, or mobile phone number binding time, and the like, and the embodiment of the present invention is not limited, and is mainly used for comparing with the number allocation time to determine whether the mobile phone number belongs to secondary number allocation.
For example, if the number allocation time of a certain mobile phone number is determined to be 2018.5.6, and the registration time for using the mobile phone number in the service system is obtained to be 2017.8.9, then the number allocation time 2018.5.6 is determined to be later than the registration time 2017.8.9, which indicates that the mobile phone number is a secondary number allocation, and the user registered in the previous service system is no longer the actual user of the mobile phone number, so that the service data of the previous user needs to be cleaned.
Further, in order to improve efficiency, in the embodiment of the present invention, the result of determining whether the mobile phone number to be detected belongs to the secondary number allocation may be cached.
The secondary number allocation detection result of the mobile phone number to be detected can be dynamically adjusted according to the behavior operation active time of the user in the service system, for example, the behavior operation is a bill behavior, and the closer the bill active time is, the longer the cache time is set, so that the accuracy can also be improved.
In addition, the data transmission and database query operations with the BOSS system of the operator can be greatly reduced, the performance can be improved, and the time can be saved.
Step 220: and if the mobile phone number belongs to the secondary number allocation, cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system.
When step 220 is executed, specifically, there may be the following two ways:
the first mode is as follows: and directly deleting the service data of the user, and deleting other associated data of the user, such as login records, operation records and the like.
This approach is simple and can be applied to systems that are not sensitive to user information and data.
The second mode is as follows: the business data of the user is not deleted, the user is only marked in the database as deleted, and other associated data of the user are marked as invalid data, such as order records, consumption records, operation records and the like.
The mode is more applicable, and misoperation can be prevented.
Further, before the service data of the user corresponding to the mobile phone number to be detected is cleaned from the service system, the method further includes: the method and the device for the mobile phone number backup have the advantages that the service data of the user corresponding to the mobile phone number to be detected are backed up, so that in the embodiment of the invention, the backup is firstly carried out when cleaning is carried out, the storage process is predefined on the database side, the service data of the old user with the secondary number discharge is cleaned based on the storage process, the cleaning process is recorded in detail, and the recheck is convenient.
Specifically, referring to fig. 3, a process of cleaning service data of a user corresponding to a mobile phone number to be detected is a flow chart of a cleaning execution logic in an embodiment of the present invention, and the process includes:
step 300: and starting.
Step 301: a clear status flag is declared.
Specifically, the state of the service data corresponding to the mobile phone number to be detected, which is determined to belong to the secondary number allocation, is modified into the cleaning state, that is, a cleaning state flag is declared, the cleaning state flag can be used for returning to the calling party, and the service data set as the cleaning state flag is the service data to be cleaned.
Step 302: exception handling is declared.
The statement exception handling is used for defining a handling behavior after error reporting in a storage process, and specifically includes: and setting a cleaning state flag as failure after error reporting for finally rolling back all operations.
Step 303: the transaction is opened.
In the embodiment of the invention, the whole process aiming at all the service data to be cleaned in one cleaning process, including the storage process and the cleaning process, can be used as one transaction.
Step 304: and migrating the service data to be cleaned to the backup table.
Step 305: and deleting the service data to be cleaned from the original table.
That is, when the transaction is started to clean, the service data to be cleaned is backed up and then deleted from the original table, and one table is operated each time, so that all the service data to be cleaned are processed in a circulating manner.
Step 306: and if so, returning to continue executing the step 304, otherwise, executing the step 307.
Step 307: it is determined whether an error is reported, if yes, step 308 is performed, otherwise, step 310 is performed.
Step 308: the cleaning status is set to fail.
Step 309: the transaction is rolled back.
That is, if it is determined that the transaction is opened, the step 304 and 306 indicate whether an error is reported, and if an error is reported, the transaction is rolled back, and the transaction is rolled back to the state before the opening, so that the accuracy of cleaning can be ensured.
Step 310: the cleaning status is set to successful.
Step 311: the transaction is committed.
Namely, the cleaning process of the data to be cleaned is completed.
Step 312: and (6) ending.
Therefore, in the embodiment of the invention, when the cleaning triggering condition is met, the mobile phone number to be detected is detected, whether the mobile phone number belongs to secondary number allocation is determined, and if the mobile phone number belongs to secondary number allocation, the service data of the user corresponding to the mobile phone number to be detected is cleaned from the service system, manual checking and judgment are not needed when the user feeds back problems, whether the mobile phone number belongs to secondary number allocation can be actively detected, the service data belonging to secondary number allocation is actively cleaned, and the processing efficiency is improved.
Based on two cleaning triggering modes in the embodiment of the present invention, several specific application scenarios are used for description below.
The first cleaning mode: active cleaning mode. Based on the foregoing embodiment, specifically referring to fig. 4, a flowchart of another service data processing method based on an active cleaning mode in the embodiment of the present invention specifically includes:
step 400: the cleaning system determines whether a cleaning trigger condition is met.
Here, the cleaning triggering condition is, for example, a condition that reaches a preset period, and the like, and is automatically triggered by the cleaning system.
Step 401: and when the cleaning system determines that the cleaning triggering condition is met, acquiring a user list from the service system.
The user list at least comprises the mobile phone number, the associated time and the like of the user.
And may also set the number of users in the user list and conditions, for example, acquiring 100 users whose registration time was half a year ago.
Step 402: the service system returns a user list to the cleaning system.
Step 403: the clearing system queries the operator BOSS system for the time of the number assignment.
Step 404: and the operator BOSS system returns the number placing time to the clearing system.
Step 405: clearing the system cache number placing time.
Step 406: the cleaning system detects whether the mobile phone number in the user list belongs to secondary number allocation.
Step 407: the cleaning system initiates execution cleaning to the database.
Step 408: the database performs a stored procedure.
That is, in the embodiment of the present invention, when the service data is cleared, the service data of the secondary number is cleared using the storage process, that is, the service data is backed up to the backup table first, and then the service data is deleted from the original table.
Step 409: and the database returns an execution result to the cleaning system.
The second cleaning mode is as follows: the cleanup mode is triggered by the business system. Based on the foregoing embodiment, specifically referring to fig. 5, a flowchart of another service data processing method based on a service system triggered cleaning mode in the embodiment of the present invention specifically includes:
step 500: and the service system sends a secondary number allocation detection request to the cleaning system.
Step 501: the cleaning system determines whether the corresponding number placing time is cached locally.
Step 502: and if the cleaning system determines that the corresponding number placing time is not cached locally, inquiring the number placing time from the BOSS system of the operator.
Step 503: and the operator BOSS system returns the number placing time to the clearing system.
Step 504: clearing the system cache number placing time.
Step 505: and the cleaning system returns a detection result of whether the secondary number allocation is performed to the service system.
Step 506: and the service system initiates a cleaning request to the cleaning system.
In the embodiment of the present invention, when the service system triggers the cleaning, the triggering is divided into two stages, which are a secondary number allocation detection request and a cleaning request, respectively, and certainly, the service system may trigger only once, so as to execute the whole service data processing flow.
Step 507: the cleaning system initiates execution cleaning to the database.
Step 508: the database performs a stored procedure.
Step 509: and the database returns an execution result to the cleaning system.
Step 510: and the cleaning system returns a cleaning result to the service system.
Therefore, the embodiment of the invention provides two cleaning modes, namely the active cleaning mode and the cleaning mode triggered by the service system, which is beneficial to the flexible operation of the system and can be effectively applied to various scenes.
Based on the foregoing embodiments, referring to fig. 6, in an embodiment of the present invention, a service data processing apparatus specifically includes:
the obtaining module 60 is configured to obtain the number placing time of the mobile phone number to be detected and the association time in the service system when a preset cleaning triggering condition is met; the mobile phone number to be detected is a related mobile phone number in a service system;
a determining module 61, configured to determine whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the association time in the service system;
and the cleaning module 62 is configured to clean the service data of the user corresponding to the mobile phone number to be detected from the service system if it is determined that the mobile phone number belongs to the secondary number allocation.
Optionally, when a preset cleaning triggering condition is met, the method further includes: a trigger determination module 63 configured to:
when a preset period is reached, determining that a preset cleaning triggering condition is met; or the like, or, alternatively,
and when the cleaning request sent by the service system is determined to be received, determining that a preset cleaning triggering condition is met.
Optionally, when the number placing time of the mobile phone number to be detected is obtained, the obtaining module 60 is specifically configured to:
if the number allocation time of the mobile phone number to be detected is determined to be cached locally, directly acquiring the number allocation time of the mobile phone number to be detected from the local;
and if the number allocation time of the mobile phone number to be detected is determined not to be cached locally, acquiring the number allocation time of the mobile phone number to be detected from a corresponding operator system, and caching the number allocation time to the local.
Optionally, further comprising:
and the cache module 64 is configured to update the number allocation time of the locally cached mobile phone number according to a preset cache duration.
Optionally, when determining whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the association time in the service system, the determining module 61 is specifically configured to: and if the number allocation time is determined to be later than the associated time in the service system, determining that the mobile phone number to be detected belongs to secondary number allocation.
Optionally, before the service data of the user corresponding to the mobile phone number to be detected is cleaned from the service system, the method further includes: and the backup module 65 is configured to backup the service data of the user corresponding to the mobile phone number to be detected.
Optionally, the cache module 64 is further configured to: and caching the result of determining whether the mobile phone number to be detected belongs to the secondary number allocation.
It should be noted that, in the embodiment of the present invention, each module in the service data processing apparatus may correspond to each module in the cleaning system in the application architecture diagram corresponding to fig. 1, for example, the obtaining module 60 may correspond to the number allocation time detecting module in fig. 1, and may obtain the number allocation time, the caching module 64 may correspond to the caching module in fig. 1, and may be configured to cache the number allocation time and the secondary number allocation detection result, and the like, the determining module 62 may correspond to the policy module in fig. 1, for example, determine whether the number is the secondary number allocation according to the secondary number allocation detection rule in the policy module, the cleaning module 62 may correspond to the cleaning execution module in fig. 1, and the backup module 65 may correspond to the cleaning history management module in fig. 1.
Referring to fig. 7, in an embodiment of the invention, a structural schematic diagram of an electronic device is shown.
Embodiments of the present invention provide an electronic device, which may include a processor 710 (CPU), a memory 720, an input device 730, an output device 740, and the like, wherein the input device 730 may include a keyboard, a mouse, a touch screen, and the like, and the output device 740 may include a display device, such as a Liquid Crystal Display (LCD), a Cathode Ray Tube (CRT), and the like.
The processor 710 is configured to execute any of the above-mentioned service data processing methods according to the obtained program instructions by calling the program instructions stored in the memory 720.
Based on the foregoing embodiments, in the embodiments of the present invention, a computer-readable storage medium is provided, on which a computer program is stored, and the computer program, when executed by a processor, implements the service data processing method in any of the above-described method embodiments.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various modifications and variations can be made in the embodiments of the present invention without departing from the spirit or scope of the embodiments of the invention. Thus, if such modifications and variations of the embodiments of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to encompass such modifications and variations.
Claims (10)
1. A method for processing service data is characterized by comprising the following steps:
when a preset cleaning triggering condition is met, acquiring the number placing time of the mobile phone number to be detected and the correlation time in a service system; the mobile phone number to be detected is a related mobile phone number in a service system;
determining whether the mobile phone number to be detected belongs to secondary number allocation or not according to the number allocation time and the associated time in the service system;
and if the mobile phone number belongs to the secondary number allocation, cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system.
2. The method according to claim 1, wherein meeting a predetermined cleaning trigger condition specifically comprises:
when a preset period is reached, determining that a preset cleaning triggering condition is met; or the like, or, alternatively,
and when the cleaning request sent by the service system is determined to be received, determining that a preset cleaning triggering condition is met.
3. The method of claim 1, wherein the obtaining of the number allocation time of the mobile phone number to be detected specifically comprises:
if the number allocation time of the mobile phone number to be detected is determined to be cached locally, directly acquiring the number allocation time of the mobile phone number to be detected from the local;
and if the number allocation time of the mobile phone number to be detected is determined not to be cached locally, acquiring the number allocation time of the mobile phone number to be detected from a corresponding operator system, and caching the number allocation time to the local.
4. The method of claim 3, further comprising:
and updating the number placing time of the locally cached mobile phone number according to the preset caching duration.
5. The method according to any one of claims 1 to 4, wherein determining whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the association time in the service system specifically comprises:
and if the number allocation time is determined to be later than the associated time in the service system, determining that the mobile phone number to be detected belongs to secondary number allocation.
6. The method as claimed in claim 1, wherein before the step of cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system, the method further comprises:
and backing up the service data of the user corresponding to the mobile phone number to be detected.
7. The method of claim 1, further comprising:
and caching the result of determining whether the mobile phone number to be detected belongs to the secondary number allocation.
8. A service data processing apparatus, comprising:
the acquisition module is used for acquiring the number placing time of the mobile phone number to be detected and the associated time in the service system when the preset cleaning triggering condition is met; the mobile phone number to be detected is a related mobile phone number in a service system;
the determining module is used for determining whether the mobile phone number to be detected belongs to secondary number allocation according to the number allocation time and the associated time in the service system;
and the cleaning module is used for cleaning the service data of the user corresponding to the mobile phone number to be detected from the service system if the secondary number allocation is determined.
9. An electronic device, comprising:
at least one memory for storing a computer program;
at least one processor adapted to implement the steps of the method according to any of claims 1-7 when executing a computer program stored in a memory.
10. A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program realizing the steps of the method according to any one of claims 1-7 when executed by a processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811581364.8A CN111356122A (en) | 2018-12-24 | 2018-12-24 | Service data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811581364.8A CN111356122A (en) | 2018-12-24 | 2018-12-24 | Service data processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111356122A true CN111356122A (en) | 2020-06-30 |
Family
ID=71197898
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811581364.8A Pending CN111356122A (en) | 2018-12-24 | 2018-12-24 | Service data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111356122A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150324579A1 (en) * | 2014-05-06 | 2015-11-12 | Alibaba Group Holding Limited | Method, apparatus, and system for managing user accounts |
| CN106921957A (en) * | 2017-03-23 | 2017-07-04 | 中国联合网络通信集团有限公司 | The recognition methods of secondary number of distributing telephone numbers and device |
| CN107846679A (en) * | 2016-09-20 | 2018-03-27 | 中国电信股份有限公司 | The telephone number secondary processing method distributed telephone numbers, system and business system |
| CN107979569A (en) * | 2016-10-24 | 2018-05-01 | 中国移动通信有限公司研究院 | A kind of registered information managing device of the Internet, applications, method and system |
| CN108306882A (en) * | 2018-01-31 | 2018-07-20 | 中国联合网络通信集团有限公司 | A kind of method and the network equipment of terminal access business |
| CN108933789A (en) * | 2018-07-05 | 2018-12-04 | 赵朝胜 | A kind of method and third-party application server preventing personal information leakage |
-
2018
- 2018-12-24 CN CN201811581364.8A patent/CN111356122A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150324579A1 (en) * | 2014-05-06 | 2015-11-12 | Alibaba Group Holding Limited | Method, apparatus, and system for managing user accounts |
| CN107846679A (en) * | 2016-09-20 | 2018-03-27 | 中国电信股份有限公司 | The telephone number secondary processing method distributed telephone numbers, system and business system |
| CN107979569A (en) * | 2016-10-24 | 2018-05-01 | 中国移动通信有限公司研究院 | A kind of registered information managing device of the Internet, applications, method and system |
| CN106921957A (en) * | 2017-03-23 | 2017-07-04 | 中国联合网络通信集团有限公司 | The recognition methods of secondary number of distributing telephone numbers and device |
| CN108306882A (en) * | 2018-01-31 | 2018-07-20 | 中国联合网络通信集团有限公司 | A kind of method and the network equipment of terminal access business |
| CN108933789A (en) * | 2018-07-05 | 2018-12-04 | 赵朝胜 | A kind of method and third-party application server preventing personal information leakage |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11023448B2 (en) | Data scrubbing method and apparatus, and computer readable storage medium | |
| US8108343B2 (en) | De-duplication and completeness in multi-log based replication | |
| US9141680B2 (en) | Data consistency and rollback for cloud analytics | |
| CN111177165B (en) | Method, device and equipment for detecting data consistency | |
| CN108255620B (en) | Service logic processing method, device, service server and system | |
| EP2797014A1 (en) | Database update execution according to power management schemes | |
| CN106570027B (en) | Transactional task processing method and device | |
| EP3270301A1 (en) | Platform-based data segregation | |
| CN107451202B (en) | Data access method and equipment | |
| CN111356122A (en) | Service data processing method and device | |
| CN113407356A (en) | Data processing method and device, electronic equipment and storage medium | |
| US10503752B2 (en) | Delta replication | |
| WO2020147334A1 (en) | Method and system for data query based on ignite cache architecture | |
| CN110851398B (en) | Garbage data recovery processing method and device and electronic equipment | |
| CN115858668A (en) | Distributed transaction processing method, device, electronic device and storage medium | |
| CN113868194B (en) | Management method, device, system and medium for local user group of storage equipment | |
| CN113238815B (en) | Interface access control method, device, equipment and storage medium | |
| CN110457272B (en) | Bill batch processing method and device | |
| CN110851421B (en) | Method and device for reducing time consumption of data migration, storage medium and electronic equipment | |
| JP2001356946A (en) | Method, device for executing work flow and recording medium in which work flow execution program is recorded | |
| CN106682223A (en) | Method and device for detecting data validity and method and device for intelligent interaction | |
| CN112597354A (en) | Method, device, system and storage medium for providing configuration parameters | |
| US20180173805A1 (en) | Application programming interface for detection and extraction of data changes | |
| CN107239474B (en) | Data recording method and device | |
| CN113849133B (en) | Processing method and device of privacy data, electronic equipment and storage 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200630 |
|
| RJ01 | Rejection of invention patent application after publication |