Method and apparatus for online migration of telecommunications data

Abstract

The online telecommunications data migration method and device provided in this embodiment of the invention obtains the users to be migrated, locks the telecommunications data of the users to be migrated at the source end, and records the telecommunications data of the users to be migrated in a migration detail table; performs a migrationability verification on the telecommunications data of the users to be migrated, and if the verification passes, converts the telecommunications data according to the data format that the receiving end can receive, and records the converted telecommunications data in a conversion intermediate table; migrates the telecommunications data in the conversion intermediate table to the receiving end, records the telecommunications data migrated to the receiving end in a migration detail table, and locks it; after the telecommunications data migration is completed, unlocks the telecommunications data in the migration detail table, and deletes the migration detail table and the corresponding telecommunications data at the source end. The method provided in this embodiment enables the migration of user information without system shutdown, does not affect business development, and ensures resource consistency.

Description

Technical Field

[0001] This application relates to database migration technology, and more particularly to a method and apparatus for online migration of telecommunications data. Background Technology

[0002] With the continuous development of the telecommunications industry, various database systems are also constantly being updated and iterated. The migration of telecommunications data is the foundation for ensuring data security.

[0003] In existing technologies, migrating a large number of production users from a database requires a shutdown cutover process. However, since telecommunications services cannot be provided during this cutover, it severely impacts user experience and hinders industry development. Furthermore, there are no automated tools to automatically migrate and repair inconsistencies that arise during user information migration, requiring manual intervention from operations and maintenance personnel, thus increasing their workload.

[0004] Therefore, designing a suitable telecommunications data migration algorithm to perform telecommunications data migration as seamlessly as possible while ensuring data security has become an urgent problem to be solved. Summary of the Invention

[0005] This invention provides a method and device for online migration of telecommunications data, enabling real-time migration of user data without system downtime.

[0006] In a first aspect, embodiments of the present invention provide a method for online migration of telecommunications data, comprising:

[0007] The number of users to be migrated is determined based on the duration of a single migration, and multiple telecommunications data migrations are performed continuously within a preset period until the data migration is completed.

[0008] The telecommunications data of the user to be transferred at the source end is locked, and the telecommunications data of the user to be transferred is recorded in the transfer details table. The locked telecommunications data is in an inoperable state.

[0009] The transferability of the telecommunications data of the user to be transferred is verified. If the verification passes, the telecommunications data is converted according to the data format that the receiving end can receive, and the converted telecommunications data is recorded in the conversion intermediate table.

[0010] The telecommunications data in the intermediate conversion table is transferred to the receiving end, and the transferred telecommunications data is recorded in the migration details table. The telecommunications data in the migration details table is then locked.

[0011] After the telecommunications data migration is completed, the telecommunications data in the migration details table is unlocked, and the migration details table and the corresponding source telecommunications data are deleted.

[0012] In one possible design, obtaining the users to be migrated includes:

[0013] Obtain the active time period, wherein the active time period is a period during which more than a preset number of user active operations occur;

[0014] Inactive users are identified during the active period, and users to be migrated are determined based on the duration of a single migration.

[0015] Obtain active users other than the inactive users, and during inactive periods, determine users to be migrated based on the duration of a single migration, wherein the inactive period is a period outside the active period.

[0016] In one possible design, the telecommunications data includes at least two source data items; locking the telecommunications data of the user to be migrated at the source end includes:

[0017] Each source data item in the telecommunications data is locked individually;

[0018] If locking is successful, proceed with the transitionability check;

[0019] If locking at least one source data item of the target user fails, the locked source data of the target user is unlocked, the telecommunications data of the target user is released, and the telecommunications data of the target user is deleted from the migration details table.

[0020] In one possible design, the migrationability verification of the telecommunications data of the user to be migrated includes:

[0021] The transferable verification rules are sequentially obtained from the verification rule base, wherein the verification rule base includes at least relationship-based verification rules, risk-based verification rules, and business processing verification rules; the relationship-based verification rules are used to indicate that users who have a relationship with other users fail the verification; the risk-based verification rules are used to indicate that users with credit risk fail the verification; and the business processing verification rules are used to indicate that users who are currently processing business fail the verification.

[0022] For each user's telecommunications data, the transferability is verified sequentially using transferability verification rules. If any verification rule fails, the verification fails, the user's telecommunications data is released, and the user's telecommunications data that failed verification is deleted from the transfer details table. If all verification rules in the verification rule library succeed, the verification passes.

[0023] In one possible design, the step of converting the telecommunication data according to the data format that the receiving end can receive, and recording the converted telecommunication data in a conversion intermediate table, includes:

[0024] The central control service sends each source data item to the corresponding sub-control service via MQ messages, so that each sub-control service can convert the format of the source data and record the converted telecommunications data in the conversion intermediate table corresponding to each source data item.

[0025] In one possible design, the method further includes:

[0026] If at least one source data format conversion for a target user fails, the target user's telecommunications data is released, the target user's telecommunications data is deleted from the migration details table, and the source data of the target user whose format has been converted is deleted from the conversion intermediate table.

[0027] In one possible design, the method further includes:

[0028] If at least one source data migration for a target user fails, the target user's telecommunications data is released, and the target user's telecommunications data is deleted from the migration details table and the intermediate conversion table, as well as the source data of the target user that has been migrated from the migration details table.

[0029] In a second aspect, embodiments of the present invention provide an online telecommunications data migration device, comprising:

[0030] The acquisition module is used to acquire users to be migrated this time. The number of users to be migrated is determined based on the duration of a single migration. Multiple telecommunications data migrations are performed continuously within a preset period until the data migration is completed.

[0031] The locking module is used to lock the telecommunications data of the user to be transferred at the source end and record the telecommunications data of the user to be transferred in the transfer details table. The locked telecommunications data is in an inoperable state.

[0032] The verification and conversion module is used to verify the transferability of the telecommunications data of the user to be transferred. If the verification is successful, the telecommunications data is converted according to the data format that the receiving end can receive, and the converted telecommunications data is recorded in the conversion intermediate table.

[0033] The migration module is used to migrate the telecommunications data in the intermediate conversion table to the receiving end, record the telecommunications data migrated to the receiving end in the migration details table, and lock the telecommunications data in the migration details table.

[0034] The unlocking module unlocks the telecommunications data in the migration details table after the telecommunications data migration is completed, and deletes the migration details table and the corresponding source telecommunications data.

[0035] In one possible design, the acquisition module is specifically used for:

[0036] Obtain the active time period, wherein the active time period is a period during which more than a preset number of user active operations occur;

[0037] Inactive users are identified during the active period, and users to be migrated are determined based on the duration of a single migration.

[0038] Obtain active users other than the inactive users, and during inactive periods, determine users to be migrated based on the duration of a single migration, wherein the inactive period is a period outside the active period.

[0039] In one possible design, the locking module is specifically used for:

[0040] Each source data item in the telecommunications data is locked individually;

[0041] If locking is successful, proceed with the transitionability check;

[0042] If locking at least one source data item of the target user fails, the locked source data of the target user is unlocked, the telecommunications data of the target user is released, and the telecommunications data of the target user is deleted from the migration details table.

[0043] In one possible design, the verification conversion module is specifically used for:

[0044] The transferable verification rules are sequentially obtained from the verification rule base, wherein the verification rule base includes at least relationship-based verification rules, risk-based verification rules, and business processing verification rules; the relationship-based verification rules are used to indicate that users who have a relationship with other users fail the verification; the risk-based verification rules are used to indicate that users with credit risk fail the verification; and the business processing verification rules are used to indicate that users who are currently processing business fail the verification.

[0045] For each user's telecommunications data, the transferability is verified sequentially using transferability verification rules. If any verification rule fails, the verification fails, the user's telecommunications data is released, and the user's telecommunications data that failed verification is deleted from the transfer details table. If all verification rules in the verification rule library succeed, the verification passes.

[0046] In one possible design, the verification conversion module is further specifically used for:

[0047] The central control service sends each source data item to the corresponding sub-control service via MQ messages, so that each sub-control service can convert the format of the source data and record the converted telecommunications data in the conversion intermediate table corresponding to each source data item.

[0048] In one possible design, the verification conversion module is further specifically used for:

[0049] If at least one source data format conversion for a target user fails, the target user's telecommunications data is released, the target user's telecommunications data is deleted from the migration details table, and the source data of the target user whose format has been converted is deleted from the conversion intermediate table.

[0050] In one possible design, the transition module is specifically used for:

[0051] If at least one source data migration for a target user fails, the target user's telecommunications data is released, and the target user's telecommunications data is deleted from the migration details table and the intermediate conversion table, as well as the source data of the target user that has been migrated from the migration details table.

[0052] Thirdly, embodiments of the present invention provide an online telecommunications data transfer device, comprising: at least one processor and a memory;

[0053] The memory stores computer-executed instructions;

[0054] The at least one processor executes computer execution instructions stored in the memory, causing the at least one processor to perform the online telecommunications data transfer method as described in the first aspect and various possible designs of the first aspect.

[0055] Fourthly, embodiments of the present invention provide a computer-readable storage medium, characterized in that the computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, implement the online telecommunications data transfer method described in the first aspect and various possible designs of the first aspect.

[0056] The online telecommunications data migration method and device provided in this embodiment obtains the users to be migrated, the number of which is determined based on the duration of a single migration. Multiple telecommunications data migrations are performed continuously within a preset period until completion. Each migration is short, almost imperceptible to users, and does not affect business operations. The telecommunications data of the users to be migrated at the source end is locked and recorded in a migration details table. The migration feasibility of the telecommunications data is verified. If the verification passes, the telecommunications data is format-converted according to the data format acceptable to the receiving end, and the converted data is recorded in a conversion intermediate table. The telecommunications data in the conversion intermediate table is migrated to the receiving end, and the migrated data is recorded in a migration details table. The telecommunications data in the migration details table is locked to prevent modification of user telecommunications data during the migration process, ensuring resource consistency. After the telecommunications data migration is completed, the telecommunications data in the migration details table is unlocked, and the migration details table and the corresponding source-end telecommunications data are deleted. The method provided in this embodiment enables the migration of user information without system downtime, ensuring business continuity and unaffected business development. Attached Figure Description

[0057] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0058] Figure 1 This is a schematic diagram illustrating an application scenario for online telecom data migration provided in an embodiment of this application.

[0059] Figure 2 This is the online telecommunications data migration method flow provided in the embodiments of this application. Figure 1 .

[0060] Figure 3 This is the online telecommunications data migration method flow provided in the embodiments of this application. Figure 2 .

[0061] Figure 4 This is a schematic diagram of the structure of an online telecommunications data transfer device provided in an embodiment of the present invention.

[0062] Figure 5 This is a hardware schematic diagram of an online telecommunications data migration device provided in an embodiment of the present invention.

[0063] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0064] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.

[0065] With the continuous development of the telecommunications industry, various database systems are also constantly being updated and iterated. The migration of telecommunications data is the foundation for ensuring data security.

[0066] In existing technologies, migrating a large number of production users from a database requires a shutdown cutover process. However, due to the large number of users to be migrated and the extensive data for each individual user, business operations cannot be conducted during the cutover, severely impacting user experience and hindering business development. Furthermore, there are no automated tools to automatically migrate and repair inconsistencies or other data issues that arise during user information migration, requiring manual intervention from operations and maintenance personnel, thus increasing their workload.

[0067] To address this issue, this invention designs a method for online migration of telecommunications data. Through a migration master control service, it unifies the scheduling and control of multiple migration master control services such as locking, verification, conversion, relocation, unlocking, and cleanup to complete the migration process. This enables real-time migration of user information without system downtime, without affecting business development. In case of migration failure, it immediately rolls back to ensure the consistency of user information resources and reduces the burden of operations.

[0068] Figure 1 This is a schematic diagram illustrating an application scenario for online telecommunications data migration provided in this embodiment. As shown in Figure 1, the application scenario provided in this embodiment includes server 101, migration system 102, and server 103. In this online telecommunications data migration application scenario, server 101 is the server where the source database is located, and server 103 is the server where the peer database is located. During the migration process, the telecommunications data to be migrated is migrated out of server 101 and into server 103 through migration system 102.

[0069] The technical solution of this application and how the technical solution of this application solves the above-mentioned technical problems are described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will now be described with reference to the accompanying drawings.

[0070] Figure 2 This is the online telecommunications data migration method flow provided in the embodiments of this application. Figure 1 The method flow of this embodiment can be derived from... Figure 1 The migration system in the embodiment is executed. For example... Figure 2 As shown, the method includes:

[0071] S201. Obtain the users to be migrated this time, wherein the number of users to be migrated is determined based on the duration of a single migration, and multiple telecommunications data migrations are performed continuously within a preset period until the data migration is completed.

[0072] In this embodiment, the migration time is divided into active and inactive periods. Users to be migrated are determined based on their activity levels during these periods. Specifically, periods during which a user's active actions exceed a preset number are designated as active periods, while periods outside of these active periods are designated as inactive periods. Inactive users are identified during active periods, and users to be migrated are determined based on the duration of each migration. Conversely, active users are identified during inactive periods, and users to be migrated are determined based on the duration of each migration.

[0073] For example, if the active period is set from 6:00 to 22:00 and the inactive period is from 22:00 to 6:00 the next day, in this case, the number of user operations during the active period is greater than the number of user operations during the inactive period. In order to reduce the impact of migration on business, this application embodiment migrates inactive users during the active period and migrates active users who are active during the active period during the inactive period.

[0074] User activity is determined by the likelihood of a user conducting business recently. For example, activity can be judged based on whether a user has conducted business in the past three months. If a user has not conducted business in the past three months, the user is considered an inactive user; if the user has conducted business in the past three months, the user is considered an active user.

[0075] S202. Lock the telecommunications data of the user to be transferred at the source end, and record the telecommunications data of the user to be transferred in the transfer details table, wherein the locked telecommunications data is in an inoperable state.

[0076] Specifically, the user's telecommunications data includes, but is not limited to, user source information, customer source information, account source information, credit control information, and order information. In this embodiment, the telecommunications data status of the users to be migrated is marked as locked, at which point operations on the user's telecommunications data are not allowed, and the user's telecommunications data is recorded in the migration details table, which is used to indicate the telecommunications data of users who have entered the migration process.

[0077] If the above-mentioned locking of the user's telecommunications data is successful, the migrationability verification can continue. If the locking of at least one source data of the target user fails, the locked source data of the target user will be unlocked, the telecommunications data of the target user will be released, and the telecommunications data of the target user will be deleted from the migration details table.

[0078] Specifically, before locking a user's telecommunications data, a simple check of the user's status is performed. For example, whether the user is an invalid user will cause the locking of the user's telecommunications data to fail.

[0079] S203. Perform a migrationability check on the telecommunications data of the user to be migrated. If the check passes, convert the telecommunications data according to the data format that the receiving end can receive, and record the converted telecommunications data in the conversion intermediate table.

[0080] Specifically, the central control service calls different rule factors to perform migrationability verification on users based on the rules recorded in the verification rule base. When all verification rules pass, it means that the user can be migrated. According to the data format acceptable to the telecommunications data receiving end, the source telecommunications data is format converted so that the user's telecommunications data can be migrated to a database with a different format than the source database. Finally, the format-converted telecommunications data is recorded in the conversion intermediate table.

[0081] S204. Transfer the telecommunications data in the intermediate conversion table to the receiving end, record the transferred telecommunications data to the receiving end in the relocation details table, and lock the telecommunications data in the relocation details table.

[0082] Specifically, after the user's telecommunications data is successfully converted, the telecommunications data in the intermediate conversion table is sequentially transferred to the database receiving end, and the successfully transferred telecommunications data is recorded in the migration details table. The successfully transferred telecommunications data is also locked to maintain data consistency.

[0083] S205. After the telecommunications data migration is completed, the telecommunications data in the migration details table is unlocked, and the migration details table and the corresponding source telecommunications data are deleted.

[0084] Specifically, once all of a user's telecommunications data has been successfully migrated, the migrated telecommunications data is unlocked, and the migrated telecommunications data in the migration details table, as well as the corresponding telecommunications data in the source database, are deleted. At this point, the migration process of the user's telecommunications data is complete.

[0085] The online telecommunications data migration method provided in this embodiment obtains the users to be migrated, the number of which is determined based on the duration of each migration. Multiple migrations are performed continuously within a preset period until completion. Each migration is short, virtually imperceptible to users, and does not affect business operations. The method locks the telecommunications data of the users to be migrated at the source end and records this data in a migration details table. A migration feasibility check is performed on the telecommunications data. If the check passes, the data is format-converted according to the receiving end's acceptable data format, and the converted data is recorded in a conversion intermediate table. The telecommunications data in the conversion intermediate table is migrated to the receiving end, and the migrated data is recorded in a migration details table. The data in the migration details table is locked to prevent modification of user telecommunications data during migration, ensuring resource consistency. After the telecommunications data migration is complete, the data in the migration details table is unlocked, and the migration details table and the corresponding source-end telecommunications data are deleted. The method provided in this embodiment enables the migration of user information without system downtime, ensuring business continuity and unaffected business development.

[0086] Figure 3 This is the online telecommunications data migration method flow provided in the embodiments of this application. Figure 2 This embodiment provides a detailed description of the online migration process for telecommunications data. The method includes:

[0087] S301. Obtain inactive users during active periods and determine users to be migrated during active periods based on the duration of a single migration.

[0088] S302. Obtain active users other than inactive users, and during inactive periods, determine the users to be migrated during inactive periods based on the duration of a single migration.

[0089] For example, inactive users identified during the migration process from 6:00 to 22:00 are migrated to active users between 22:00 and 6:00 the next day. The judgment rule can be whether the user has conducted business in the past three months. If the user has conducted business, the user is considered an active user; otherwise, the user is considered an inactive user.

[0090] S303. Lock the telecommunications data of the user to be transferred at the source end, and record the telecommunications data of the user to be transferred in the transfer details table.

[0091] S304. Determine whether each source data item of the user to be migrated has been successfully locked. If yes, execute S306; otherwise, execute 305.

[0092] S305. Unlock the source data that the target user has locked, release the target user's telecommunications data, delete the target user's telecommunications data in the migration details table, and return to the initial state.

[0093] Specifically, if locking at least one source data item of the target user fails, the migration process for the target user fails. The target user's telecommunications data is released, the user's telecommunications data is deleted from the migration details table, and the user returns to the initial state, waiting for the next migration.

[0094] S306. Sequentially obtain transferable verification rules from the verification rule base, wherein the verification rule base includes at least relational verification rules, risk-based verification rules, and business processing verification rules.

[0095] Specifically, relationship-based verification rules are used to indicate that users who have connections with other users fail verification. For example, if a user has a kinship or group relationship with other users, the user's transferability verification will fail. Similarly, risk-based verification rules are used to indicate that users with credit risk fail verification, and business processing verification rules are used to indicate that users who are currently processing business fail verification.

[0096] S307. For each user's telecommunications data, the transferability is verified sequentially using the transferability verification rules.

[0097] S308. Determine whether the migrationability check performed on the user to be migrated has passed. If yes, execute S310; otherwise, execute S309.

[0098] S309. If any verification rule fails, the verification fails, the user's telecommunications data is released, and the telecommunications data of the user who failed the verification is deleted from the migration details table.

[0099] S310. The main control service sends each source data item to the corresponding sub-control service via MQ messages, so that each sub-control service can convert the format of the source data and record the converted telecommunications data in the conversion intermediate table corresponding to each source data item.

[0100] Specifically, after a user's migrationability verification is passed, since the data format of the database being migrated out may differ from that of the database being migrated into, it is necessary to perform format conversion on each of the user's source data items. Only data that has been successfully converted can be migrated.

[0101] S311. Determine whether all source data of the user to be migrated has been successfully converted. If yes, execute S313; otherwise, execute S312.

[0102] S312. If at least one source data format conversion for a target user fails, the target user's telecommunications data is released, the target user's telecommunications data is deleted from the migration details table, and the source data of the target user whose format has been converted is deleted from the conversion intermediate table.

[0103] S313. Transfer the telecommunications data in the intermediate conversion table to the receiving end, record the transferred telecommunications data to the receiving end in the relocation details table, and lock the telecommunications data in the relocation details table.

[0104] S314. Determine whether all source data of the target user has been successfully migrated. If yes, execute S316; otherwise, execute S315.

[0105] S315. After the telecommunications data migration is completed, the telecommunications data in the migration details table is unlocked, and the migration details table and the corresponding source telecommunications data are deleted.

[0106] S316. Release the telecommunications data of the target user, and delete the telecommunications data of the target user in the migration details table and the conversion intermediate table, as well as delete the source data of the target user that has been migrated in the migration details table.

[0107] The online telecom data migration method provided in this embodiment uses a migration master control service to uniformly schedule and control multiple migration master control services such as locking, verification, conversion, relocation, unlocking, and cleanup to complete the migration process.

[0108] Figure 4 This is a schematic diagram of the structure of an online telecommunications data migration device provided in an embodiment of the present invention. Figure 4 As shown, the voice interaction device 40 includes: an acquisition module 401, a locking module 402, a verification and conversion module 403, a transfer module 404, and an unlocking module 405.

[0109] The acquisition module 401 is used to acquire the users to be migrated this time. The number of users to be migrated is determined according to the duration of a single migration. Multiple telecommunications data migrations are performed continuously within a preset period until the data migration is completed.

[0110] The locking module 402 is used to lock the telecommunications data of the user to be transferred at the source end and record the telecommunications data of the user to be transferred in the transfer details table, wherein the locked telecommunications data is in an inoperable state.

[0111] The verification and conversion module 403 is used to verify the transferability of the telecommunications data of the user to be transferred. If the verification is successful, the telecommunications data is converted according to the data format that the receiving end can receive, and the converted telecommunications data is recorded in the conversion intermediate table.

[0112] The migration module 404 is used to migrate the telecommunications data in the intermediate conversion table to the receiving end, record the telecommunications data migrated to the receiving end in the migration details table, and lock the telecommunications data in the migration details table.

[0113] The unlocking module 405 is used to unlock the telecommunications data in the migration details table after the telecommunications data migration is completed, and delete the migration details table and the corresponding source telecommunications data.

[0114] In one possible design, the acquisition module 401 is specifically used for:

[0115] Obtain the active time period, wherein the active time period is a period during which more than a preset number of user active operations occur;

[0116] Inactive users are identified during the active period, and users to be migrated are determined based on the duration of a single migration.

[0117] Obtain active users other than the inactive users, and during inactive periods, determine users to be migrated based on the duration of a single migration, wherein the inactive period is a period outside the active period.

[0118] In one possible design, the locking module 402 is specifically used for:

[0119] Each source data item in the telecommunications data is locked individually;

[0120] If locking is successful, proceed with the transitionability check;

[0121] If locking at least one source data item of the target user fails, the locked source data of the target user is unlocked, the telecommunications data of the target user is released, and the telecommunications data of the target user is deleted from the migration details table.

[0122] In one possible design, the verification conversion module 403 is specifically used for:

[0123] The transferable verification rules are sequentially obtained from the verification rule base, wherein the verification rule base includes at least relationship-based verification rules, risk-based verification rules, and business processing verification rules; the relationship-based verification rules are used to indicate that users who have a relationship with other users fail the verification; the risk-based verification rules are used to indicate that users with credit risk fail the verification; and the business processing verification rules are used to indicate that users who are currently processing business fail the verification.

[0124] For each user's telecommunications data, the transferability is verified sequentially using transferability verification rules. If any verification rule fails, the verification fails, the user's telecommunications data is released, and the user's telecommunications data that failed verification is deleted from the transfer details table. If all verification rules in the verification rule library succeed, the verification passes.

[0125] In one possible design, the verification conversion module 403 is specifically used for:

[0126] The central control service sends each source data item to the corresponding sub-control service via MQ messages, so that each sub-control service can convert the format of the source data and record the converted telecommunications data in the conversion intermediate table corresponding to each source data item.

[0127] In one possible design, the verification conversion module 403 is further specifically used for:

[0128] If at least one source data format conversion for a target user fails, the target user's telecommunications data is released, the target user's telecommunications data is deleted from the migration details table, and the source data of the target user whose format has been converted is deleted from the conversion intermediate table.

[0129] In one possible design, the transition module 404 is specifically used for:

[0130] If at least one source data migration for a target user fails, the target user's telecommunications data is released, and the target user's telecommunications data is deleted from the migration details table and the intermediate conversion table, as well as the source data of the target user that has been migrated from the migration details table.

[0131] The device provided in this embodiment can be used to execute the technical solutions of the above method embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0132] Figure 5 This is a hardware schematic diagram of an online telecommunications data migration device provided in an embodiment of the present invention. Figure 5 As shown, the online telecommunications data transfer device 50 provided in this embodiment includes at least one processor 501 and a memory 502. The device 50 also includes a communication component 503. The processor 501, memory 502, and communication component 503 are connected via a bus 504.

[0133] In the specific implementation process, at least one processor 501 executes the computer execution instructions stored in the memory 502, causing at least one processor 501 to execute the above-mentioned method for online transfer of telecommunications data.

[0134] The specific implementation process of processor 501 can be found in the above method embodiments, and its implementation principle and technical effect are similar. It will not be repeated here.

[0135] In the above Figure 5 In the illustrated embodiments, it should be understood that the processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. The general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly implemented by a hardware processor, or implemented by a combination of hardware and software modules within the processor.

[0136] The memory may include high-speed RAM, and may also include non-volatile storage (NVM), such as at least one disk storage.

[0137] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.

[0138] This application also provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the above-described online telecommunications data transfer method.

[0139] The aforementioned computer-readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The readable storage medium can be any available medium accessible to a general-purpose or special-purpose computer.

[0140] An exemplary readable storage medium is coupled to a processor, enabling the processor to read information from and write information to the readable storage medium. Of course, the readable storage medium can also be a component of the processor. The processor and the readable storage medium can reside in an application-specific integrated circuit (ASIC). Alternatively, the processor and the readable storage medium can exist as discrete components in device 50.

[0141] Those skilled in the art will understand that all or part of the steps of the above-described method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When executed, the program performs the steps of the above-described method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disks, or optical disks.

[0142] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for online migration of telecommunication data, characterized by, The method comprises: acquiring this time of users to be migrated, wherein the number of the users to be migrated is determined according to a single migration duration, and the migration of the telecommunication data is continuously performed for multiple times in a preset period until the migration of the telecommunication data is completed; locking the telecommunication data of the users to be migrated at a source end, and recording the telecommunication data of the users to be migrated to a migration detail table, wherein the locked telecommunication data is in an inoperable state; performing a migratability check on the telecommunication data of the users to be migrated, if the check is passed, performing format conversion on the telecommunication data according to a data format receivable by a receiving end, and recording the telecommunication data after the format conversion to a conversion intermediate table; migrating the telecommunication data in the conversion intermediate table to the receiving end, recording the telecommunication data migrated to the receiving end to a migration detail table, and locking the telecommunication data in the migration detail table; after the migration of the telecommunication data is completed, unlocking the telecommunication data in the migration detail table, and deleting the migration detail table and the corresponding telecommunication data at the source end; the telecommunication data comprises at least two items of source data; the locking of the telecommunication data of the users to be migrated at the source end comprises locking each item of the source data in the telecommunication data respectively; if at least one item of source data of a target user fails to be locked, unlocking the source data of the target user that has been locked, releasing the telecommunication data of the target user, and deleting the telecommunication data of the target user in the migration detail table; the method further comprises: if at least one item of source data of a target user fails to be converted in format, releasing the telecommunication data of the target user, deleting the telecommunication data of the target user in the migration detail table, and deleting the source data of the target user that has been converted in format in the conversion intermediate table; if at least one item of source data of a target user fails to be migrated, releasing the telecommunication data of the target user, deleting the telecommunication data of the target user in the migration detail table and the conversion intermediate table, and deleting the source data of the target user that has been migrated in the migration detail table.

2. The method of claim 1, wherein, the acquisition of the users to be migrated this time comprises: acquiring an active time period, wherein the active time period is a time period in which more than a preset number of users are active; acquiring users that are not active in the active time period, and determining the users to be migrated according to a single migration duration; acquiring active users other than the users that are not active, and determining the users to be migrated according to a single migration duration in a non-active time period, wherein the non-active time period is a time period other than the active time period.

3. The method of claim 1, wherein, the migratability check on the telecommunication data of the users to be migrated comprises: sequentially acquiring migratability check rules from a check rule library, wherein the check rule library comprises at least relational check rules, risk check rules and service handling check rules; the relational check rules are used to indicate that a user having an association with other users is not passed in the check, the risk check rules are used to indicate that a user having a credit risk is not passed in the check, and the service handling check rules are used to indicate that a user handling a service is not passed in the check; The telecommunication data of each user is sequentially checked for migration by the transferable checking rule; if any checking rule fails, the checking is not passed, the telecommunication data of the user is released, and the telecommunication data of the user not passed is deleted from the migration detail table; if all the checking rules in the checking rule library are passed, the checking is passed.

4. The method of claim 1, wherein, The telecommunication data is converted according to the data format that can be received by the receiving end, and the converted telecommunication data is recorded in the conversion intermediate table. The total control service sends each item of source data to the corresponding sub-control service through an MQ message, so that each sub-control service converts the format of the source data, and records the converted telecommunication data in the conversion intermediate table corresponding to each item of source data.

5. A telecommunications data online migration device, characterized by It comprises: The acquisition module is configured to acquire the user to be migrated this time, wherein the number of the user to be migrated is determined according to the single migration duration, and the migration of the telecommunication data is continuously performed multiple times in a preset period until the migration of the telecommunication data is completed; The locking module is configured to lock the telecommunication data of the user to be migrated in the source end, and record the telecommunication data of the user to be migrated in the migration detail table, wherein the locked telecommunication data is in an inoperable state; The checking and converting module is configured to check the migration of the telecommunication data of the user to be migrated, if the checking is passed, convert the format of the telecommunication data according to the data format that can be received by the receiving end, and record the converted telecommunication data in the conversion intermediate table; The migration module is configured to migrate the telecommunication data in the conversion intermediate table to the receiving end, record the telecommunication data migrated to the receiving end in the migration detail table, and lock the telecommunication data in the migration detail table; The unlocking module is configured to unlock the telecommunication data in the migration detail table after the migration of the telecommunication data is completed, and delete the migration detail table and the telecommunication data of the corresponding source end; The telecommunication data comprises at least two items of source data; the locking module is specifically configured to lock each item of source data in the telecommunication data respectively; if at least one item of source data of the target user fails to be locked, the locked source data of the target user is unlocked, the telecommunication data of the target user is released, and the telecommunication data of the target user is deleted from the migration detail table; The checking and converting module is further configured to release the telecommunication data of the target user and delete the telecommunication data of the target user from the migration detail table if at least one item of source data of the target user fails to be converted in format, and delete the source data converted in format of the target user in the conversion intermediate table; The migration module is further configured to release the telecommunication data of the target user and delete the telecommunication data of the target user from the migration detail table and the conversion intermediate table if at least one item of source data of the target user fails to be migrated, and delete the source data migrated of the target user in the migration detail table and the conversion intermediate table.

6. A telecommunications data online migration device, comprising: It comprises: A processor and a memory connected in communication with the processor; The memory stores computer execution instructions; The processor executes computer execution instructions stored in the memory to implement the method as described in any one of claims 1 to 4.

7. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1 to 4.

Images