Data processing method and device during game co-service, electronic equipment and storage medium

Abstract

The invention provides a data processing method and device during game co-service, electronic equipment and a storage medium. The method comprises the following steps: firstly, determining a game data table needing conflict processing and generating a conflict registration data table; generating a backup data table corresponding to the game data table in the combined game server and constructing a conflict transfer data table; based on all names under the name field name in the game data table of the target game server, searching whether names exist under the name field name in the backup data table; if yes, generating a new name for the name, and writing the new name and a unique code corresponding to the name in the backup data table into a conflict transfer data table; and modifying the backup data table of the merged game server according to the conflict transfer data table, and merging the content of the modified backup data table into the game data table of the target game server. According to the method, only the data tables and the fields registered in the conflict registry need to be processed, and all the fields of each data table do not need to be detected and processed independently, so that the efficiency can be improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, device, electronic device and storage medium for processing data during game server merging. Background Art

[0002] With the increasing development of online games, the number of players is also increasing. In order to deal with this situation, game operators usually merge game servers, that is, merge multiple servers into one, so that the game server can carry more players while ensuring the smoothness of the game. Since players in different game servers may use the same name, the problem of player names being repeated may occur during the server merging process. Therefore, when these servers are merged, the name conflict problem needs to be resolved.

[0003] The current way to handle the problem of duplicate names during server merging is to manually add duplicate name detection processing logic to each table used to store player information in the database. In addition, each table needs to be checked and processed separately during server merging. This way of developing and maintaining a single data table is repetitive, greatly reducing development and operation efficiency.

[0004] Therefore, how to provide an automated processing mechanism for duplicate name fields during server merging to improve development and operation efficiency is a technical problem that needs to be solved. Summary of the invention

[0005] In view of this, the purpose of the present invention is to provide a data processing method, device, electronic device and storage medium when merging games, which can improve the efficiency of processing duplicate name fields when merging games and the development and operation efficiency of game data tables.

[0006] In order to achieve the above object, the technical solution adopted by the present invention is as follows:

[0007] In a first aspect, the present invention provides a data processing method when merging games, the method comprising: determining a game data table that needs to be conflict processed, and generating a conflict registration data table according to the game data table name and the name field name; generating a backup data table corresponding to the game data table in the merged game server and constructing a conflict transfer data table; according to the conflict registration data table, based on all the names under the name field name in the game data table of the target game server, searching under the name field name in the backup data table to see whether the name exists; if so, generating a new name for the name, and writing the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table; modifying the backup data table of the merged game server according to the conflict transfer data table, and then merging the contents of the modified backup data table into the game data table of the target game server.

[0008] In a second aspect, the present invention provides a data processing device for game server merging, comprising: a conflict registration module and a naming conflict processing module; the conflict registration module is used to determine a game data table that needs to be conflict processed, and generate a conflict registration data table according to the game data table name and the name field name; the conflict registration module is also used to generate a backup data table corresponding to the game data table in the merged game server; the naming conflict processing module is used to construct a conflict transfer data table; the naming conflict processing module is also used to retrieve whether the name exists under the name field name in the backup data table based on all the names under the name field name in the game data table of the target game server according to the conflict registration data table; the naming conflict processing module is also used to generate a new name for the name if it exists, and write the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table; the naming conflict processing module is also used to modify the backup data table of the merged game server according to the conflict transfer data table, and then merge the contents of the modified backup data table into the game data table of the target game server.

[0009] In a third aspect, the present invention provides an electronic device comprising a processor and a memory, wherein the memory stores machine executable instructions that can be executed by the processor, and the processor can execute the machine executable instructions to implement the data processing method when merging games according to the first aspect.

[0010] In a fourth aspect, the present invention provides a storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the data processing method when merging games with servers as described in the first aspect.

[0011] The data processing method, device, electronic device and storage medium provided by the present invention for merging games first generate a conflict registration data table to register all game data tables that need to be processed for conflicts. Subsequently, a backup data table is generated for the relevant game data tables in the merged game server, and a conflict transfer data table is constructed. Then, based on the information in the conflict registration data table, conflict detection is performed in the backup data table for all names under the registered name field of the registered game data in the target game server. Once a naming conflict is found, new names are generated for these names, and these new names and the corresponding unique codes in the backup data table are recorded in the conflict transfer data table. Finally, according to the conflict transfer data table, the backup data table of the merged game server is updated, and the updated content is merged into the game data table of the target game server. The whole process only involves conflict detection and processing of data tables and fields registered in the conflict registration data table, and no additional conflict detection and processing is required for other data tables or unregistered fields. In addition, by using the backup data table, it is convenient to modify the fields with name conflicts separately, avoiding comprehensive processing of all fields, thereby significantly improving processing efficiency.

[0012] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0013] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0014] Figure 1 A schematic flow chart of a data processing method for game server merging provided by an embodiment of the present invention;

[0015] Figure 2 A schematic diagram of a naming conflict handling process provided by an embodiment of the present invention;

[0016] Figure 3 A functional module diagram of a data processing device for game server merging provided by an embodiment of the present invention;

[0017] Figure 4 This is a structural block diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0018] The following will be combined with the accompanying drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Generally, the components of the embodiments of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.

[0019] Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the invention claimed for protection, but merely represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative work are within the scope of protection of the present invention.

[0020] It should be noted that relational terms such as "first" and "second" are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprises" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.

[0021] The existing mechanism for processing duplicate name fields during server merging is to perform duplicate name detection on each table in the database separately. Considering that each data table only has different fields with duplicate names, the development and maintenance processing for a single data table is repetitive, which greatly reduces the development and operation efficiency. An embodiment of the present invention provides an automatic processing mechanism for duplicate name fields during game server merging, which automates manual repetitive operations and improves development and operation efficiency.

[0022] See also Figure 1 , Figure 1 This is a schematic flow chart of a data processing method for game server merging provided in an embodiment of the present invention. The execution subject of the method may be a technical electronic device with data processing capability, and mainly includes the following steps:

[0023] S101: Determine the game data table that needs to be processed for conflict, and generate a conflict registration data table according to the game data table name and name field name;

[0024] S102: Generate a backup data table corresponding to the game data table in the merged game server and build a conflict transfer data table;

[0025] S103: According to the conflicting registration data table, based on all the names under the name field in the game data table of the target game server, searching whether there is a name under the name field in the backup data table;

[0026] It can be understood that the so-called merged game server refers to the server that needs to export and integrate the game data, while the target game server refers to the server responsible for receiving the imported game data and finally completing the merging work.

[0027] S104: If it exists, generate a new name for the name, and write the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table;

[0028] S105: modifying the backup data table of the merged game server according to the conflict transfer data table, and then merging the content of the modified backup data table into the game data table of the target game server.

[0029] In the method of steps S101 to S105 provided by the embodiment of the present invention. First, a conflict registration data table is generated to register all game data tables that need to be conflict processed. Subsequently, a backup data table is generated for the relevant game data tables in the merged game server, and a conflict transfer data table is constructed. Then, based on the information in the conflict registration data table, conflict detection is performed in the backup data table for all names under the registered name field of the registered game data in the target game server. Once a naming conflict is found, new names will be generated for these names, and these new names and the corresponding unique codes in the backup data table will be recorded in the conflict transfer data table. Finally, according to the conflict transfer data table, the backup data table of the merged game server is updated, and the updated content is merged into the game data table of the target game server. The whole process only involves conflict detection and processing of data tables and fields registered in the conflict registration data table, and no additional conflict detection and processing is required for other data tables or unregistered fields. In addition, by using the backup data table, it is convenient to modify the fields with name conflicts separately, avoiding comprehensive processing of all fields, thereby significantly improving processing efficiency.

[0030] The above data processing process provided by the embodiment of the present invention will be described in detail and clearly below in conjunction with relevant drawings.

[0031] In step S101, the game data table that needs to be processed for conflict is first determined, and then a conflict registration data table is generated.

[0032] In one embodiment of the present invention, the game developer can manually enter the game data table names to be processed and the field names of the conflict names in the conflict registration data table. It should be pointed out that the data tables registered in the conflict registration data table do not mean that they have passed the conflict detection and confirmed that they need to be processed, but are pre-set by the game developer before the server merging operation, and are planned to be conflict detected and processed.

[0033] For example, suppose there are two game servers, Server X and Server Y, and now they are to be merged into Server Z. In Server X, Server Y and Server X, Server Y, there is a game data table named "Players" for storing player names, and the corresponding field name is "Username". When it is determined that the game data table named "Players" needs to be conflict-handled, "Players" and "Username" are manually filled into the conflict registration data table.

[0034] It is understandable that in the conflict registration data table, multiple game data table names that need to be conflict-handled can be registered simultaneously, as shown in Table 1.

[0035] Table 1

[0036]

[0037]

[0038] Through the conflict registration data table, it is possible to quickly locate which game data tables in the merged server need to be conflict processed. Game data tables that are not in the conflict registration data table do not need to be detected and processed, avoiding the need to perform a separate conflict detection process for each data table, thereby improving efficiency.

[0039] In step S102, the embodiment of the present invention first generates a backup data table for the game data table registered in the merged server. The table structure and data of the backup table are completely consistent with those of the original game data table, but the table name is different. In one embodiment, the table name of the backup data table can be expressed by adding the suffix "_temp" to the original table name. For example, if the original game data table name is "Players", then the corresponding table name of the backup data table can be "Players_temp". It should be understood that this method is only an example, and the game developer can set it flexibly, and the embodiment of the present invention does not limit this.

[0040] In one embodiment of the present invention, in addition to generating a backup data table, a conflict transfer data table is also generated in advance, and its name can also be flexibly set based on the original game data table name. For example: the original game data table name is "Players", then the corresponding conflict transfer data table name can be "Players_conflict", and the specific setting can be customized by the game developer, and the embodiment of the present invention does not limit it here.

[0041] The conflict transfer data table is shown in Table 2. The fields in the table are divided into two columns, one for key and the other for name. The key field is used to maintain the unique code of the conflicting name in the backup data table, and the name field is used to maintain the new name generated based on the conflicting name.

[0042] Table 2

[0043] Key name 20 Sun 1 … …

[0044] Through the conflict transfer data table, new names and unique codes corresponding to the conflicting names in the backup data table can be maintained, which provides a basis for subsequent rapid modification of the conflicting names in the backup data table and can improve processing efficiency.

[0045] After completing the above preparations, the data tables in the merged server can be imported into the database of the target game server. Before data import, it is necessary to export the game data tables of the merged game server. In the implementation of the present invention, a multi-threaded mode can be used for data export, which can be implemented as follows:

[0046] Step a1: Obtain the size of each data table of the merged game server;

[0047] Step a2: Allocate threads to each data table according to the size of the data table and the total number of threads;

[0048] Step a3: Export the data tables based on the threads corresponding to the data tables.

[0049] That is to say, during the startup process, the size of each data table of the merged game server can be obtained through the database interface. Based on the multi-threading capability supported by the database, these data tables are evenly distributed to each thread according to the data volume to achieve automatic data export. Among them, the data tables and backup data tables in the merged game server that do not require conflict processing will be completely exported to the block export files corresponding to the total number of threads for subsequent import.

[0050] During the data import process, the embodiment of the present invention can also adopt a multi-threaded mode to import the pre-exported data, that is, the data table that does not need to be processed in the merged game server and the backup data table, into the database of the target game server in parallel. After the data import is completed, the naming conflict processing process can be executed, that is, step S103 is executed.

[0051] In step S103, according to the conflicting registration data table, based on all the names under the name field in the game data table of the target game server, a search is performed to determine whether a name exists under the name field in the backup data table.

[0052] In one embodiment of the present invention, the specific game data table corresponding to the game data table name recorded in the conflicting registration data table can be located in the target game server. Then, according to the name field of the record, all names under the corresponding name field in the game data table are read, and the same name field in the backup data table is checked to see whether these read names already exist. If it is found that these names already exist in the backup table, the program will execute step S104; if not, no processing is required.

[0053] In step S104, if there is a duplicate name, the process of generating a new name for the name provided by the embodiment of the present invention is executed, see Figure 2 , Figure 2 A schematic diagram of a naming conflict handling process provided by an embodiment of the present invention includes the following steps:

[0054] Step b1: determine whether the name exceeds the preset maximum name length;

[0055] In one embodiment of the present invention, the maximum length of the name can be flexibly set according to actual needs and is not limited here.

[0056] If yes, execute step b5: after deleting at least one character of the name, return to step b2.

[0057] If not, executing step b2: determining a target character as the suffix of the name according to the character order of the preset character sequence to obtain a candidate name;

[0058] In the embodiment of the present invention, the preset character sequence can be a sequence of any of numbers, letters, symbols, and their combinations. For example, the number sequence is in the form of 1, 2, 3, ..., N, and the letter sequence is in the form of a, b, c, d ... z, etc. Of course, the letters in the letter sequence can also be uppercase letters, which is not limited here.

[0059] It is understandable that when determining the target character, the character sequence can be selected in order or in reverse order. For example, in a digital sequence, the target character is first determined as 1 in order from front to back, and the target character is selected as 2 in the next selection, and so on.

[0060] Step b3: Detecting whether a candidate name exists in the game data table, or in the game data table and the conflict transfer data table;

[0061] In the embodiment of the present invention, if the conflict transfer data table is empty, then a check is performed in the game data table under the name field to see if there is a candidate name;

[0062] If the conflict transfer data table is not empty, check whether there is a candidate name under the name field of the game data table and in the conflict transfer data table.

[0063] It is understandable that the conflict transfer data table is an empty table when it is initially constructed. If there are multiple merged game servers, then for the first merged server, if there is a duplicate name during the conflict handling process, the conflict transfer data table will be empty when the new name is generated. For subsequent merged game servers, the conflict transfer server is not empty when the new name is generated, so it is necessary to check whether the new name is still conflicting in both the game data table and the conflict transfer table.

[0064] If it does not exist, then execute step b4: use the candidate name as the new name;

[0065] If it exists, return to step b2;

[0066] In the embodiment of the present invention, in the process of deleting characters, characters at any character position can be deleted, and then a target character is determined from the character sequence according to the character sequence as a suffix to form a new name. It can be understood that the target character selected this time is the next character of the target character determined last time.

[0067] To understand the above process more intuitively, take an example: Suppose the name with the same name is "Sun". First, check whether this name exceeds the preset length limit, such as 5 characters. If the length does not exceed, then a number sequence 1, 2, 3...N will be used as a suffix when generating a new name. First, use the number 1 as the suffix to generate the candidate name "Sun 1". If "Sun 1" does not have the same name, then it can be determined as the final new name. If "Sun 1" still has the same name, then continue to use the number 2 as the suffix to generate '"Sun 2", and so on, until a new name without the same name is found. If the name with the same name is "The sun emits light", and its length exceeds 5 characters, then the last character'mang' will be deleted to get "The sun emits light", and then continue to generate a new name according to the above method until a final new name without the same name is obtained.

[0068] After generating a new name through the above steps b1 to b6, the new name and the unique code corresponding to the name with the same name in the backup data table are written into the conflict transfer data table.

[0069] After traversing each target game data table in the conflict registration data table, the backup data table can be renamed and replaced in combination with the conflict transfer data table, and then the data merging is completed based on the replaced backup data table, that is, step S105 is executed.

[0070] In step S105, the names with conflicts in the merged game server can be modified in the following way:

[0071] Step c1: Traverse the conflict transfer data table, and extract each new name and the unique code corresponding to the new name;

[0072] Step c2: Retrieve the name corresponding to the unique code in the backup data table of the merged game server according to the unique code, and replace the name corresponding to the unique code with the new name.

[0073] It can be understood that when all the names with conflicts in the backup data table are replaced, the content of the entire backup data table can be imported into the game data table with the same name in the target game server until all the backup data tables are merged.

[0074] In summary, the data processing method for game server merging provided by the embodiment of the present invention has the following advantages: generating a conflict registration data table, in which all data tables and their conflict fields that need to handle naming conflicts are registered, and realizing automatic backup conversion of data tables that need to handle naming conflicts. Running in multi-threaded mode, it can evenly distribute data to multiple export file blocks according to the amount of data in the data table to improve data processing efficiency. Automatically read the backup data table and compare it with the name field of the data table with the same name in the target server. Through cyclic comparison and matching, duplicate name conflicts will be automatically handled until the uniqueness of the new name is ensured.

[0075] In order to execute the corresponding steps in the above embodiments and various possible methods, a method for implementing the data processing device 30 when merging games is given below. Figure 3 , Figure 3 This is a functional module diagram of a data processing device for merging games provided in an embodiment of the present invention. It should be noted that the basic principle and technical effects of the data processing device 30 for merging games provided in this embodiment are the same as those in the above embodiments. For the sake of brief description, for parts not mentioned in this embodiment, reference can be made to the corresponding contents in the above embodiments. The data processing device 30 for merging games includes: a conflict registration module 301 and a naming conflict handling module 302;

[0076] The conflict registration module 301 is used to determine the game data table that needs to be conflict processed, and generate a conflict registration data table according to the game data table name and name field name;

[0077] The conflict registration module 301 is also used to generate a backup data table corresponding to the game data table in the merged game server;

[0078] A naming conflict handling module 302 is used to construct a conflict transfer data table;

[0079] The naming conflict processing module 303 is further used to search whether there is a name under the name field name in the backup data table based on all the names under the name field name in the game data table of the target game server according to the conflict registration data table;

[0080] The naming conflict handling module 303 is further used to generate a new name for the name if it exists, and write the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table;

[0081] The naming conflict processing module 303 is further used to modify the backup data table of the merged game server according to the conflict transfer data table, and then merge the content of the modified backup data table into the game data table of the target game server.

[0082] It is understandable that the conflict registration module 301 and the naming conflict handling module 302 can be executed in coordination. Figure 1 Each step in the process is performed to achieve the corresponding technical effect.

[0083] In an optional implementation, the naming conflict handling module 302 can also be used to perform the following steps: Figure 2 Steps b1 to b6 are shown to achieve corresponding technical effects.

[0084] In an optional implementation, the naming conflict processing module 302 is further specifically used to detect whether a candidate name exists under the name field in the game data table if the conflict transfer data table is empty; if the conflict transfer data table is not empty, detect whether a candidate name exists under the name field in the game data table and in the conflict transfer data table.

[0085] In an optional embodiment, the naming conflict handling module 302 is also used to traverse the conflict transfer data table, extract each new name and the unique code corresponding to the new name; retrieve the name corresponding to the unique code in the backup data table of the merged game server according to the unique code, and replace the name corresponding to the unique code with the new name.

[0086] In an optional embodiment, the data processing device 30 during the game server merging also includes a data export module, which is used to obtain the size of each data table of the merged game servers; allocate threads to each data table based on the size of the data table and the total number of threads; and export the data table based on the threads corresponding to each data table.

[0087] In an optional implementation, the data processing device 30 during game server merging further includes a data import module for importing the data exported by each thread in parallel into the database of the target game server.

[0088] It should be noted that the division of modules in the above embodiments of the present application is schematic and is only a logical function division. There may be other division methods in actual implementation. In addition, each functional unit in each embodiment of the present application may be integrated into a processing unit, or may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of a software functional unit.

[0089] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable an electronic device (which can be a personal computer, a server, or a network device, etc.) or a processor to perform all or part of the steps of each embodiment method of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), disk or optical disk and other media that can store program executable code.

[0090] The embodiment of the present invention further provides an electronic device 40, see Figure 4 , Figure 4 The electronic device 40 is a block diagram of a structure of an electronic device provided in an embodiment of the present invention, and includes a memory 401, a processor 402, and a communication interface 403. The memory 401, the processor 402, and the communication interface 403 are electrically connected to each other directly or indirectly to achieve data transmission or interaction. For example, these components can be electrically connected to each other through one or more communication buses or signal lines.

[0091] Optionally, the bus may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 4 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0092] In the embodiment of the present invention, the processor 402 may be a general-purpose processor, a digital signal processor, an application-specific integrated circuit, a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component, and may implement or execute the methods, steps, and logic block diagrams disclosed in the embodiment of the present invention. A general-purpose processor may be a microprocessor or any conventional processor, etc. The steps of the method disclosed in the embodiment of the present invention may be directly embodied as being executed by a hardware processor, or may be executed by a combination of hardware and software modules in the processor. The software module may be located in the memory 401, and the processor 402 reads the program instructions in the memory 401 and completes the steps of the above method in combination with its hardware.

[0093] In the embodiment of the present invention, the memory 401 may be a non-volatile memory, such as a hard disk (HDD) or a solid-state drive (SSD), etc., or a volatile memory (VolatileMemory), such as RAM. The memory may also be any other medium that can be used to carry or store the desired program executable code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto. The memory in the embodiment of the present invention may also be a circuit or any other device that can realize a storage function, for storing instructions and / or data.

[0094] The memory 401 can be used to store software programs and modules, such as the instructions / modules of the data processing device 30 when the game server is merged provided in the embodiment of the present invention, which can be stored in the memory 401 in the form of software or firmware (Firmware) or fixed in the operating system (OS) of the electronic device 40. The processor 402 executes various functional applications and data processing by executing the software programs and modules stored in the memory 401. The communication interface 403 can be used to communicate signaling or data with other node devices.

[0095] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the above-described devices and units can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0096] Understandably, Figure 4 The structure shown is for illustration only. The electronic device 40 may also include Figure 4 More or fewer components as shown, or with Figure 4 Different configurations are shown. Figure 4 The components shown may be implemented in hardware, software or a combination thereof.

[0097] The electronic device 40 may also include a network device, which includes, but is not limited to, a single game server, a server group consisting of multiple game servers, or a cloud consisting of a large number of hosts or game servers based on cloud computing.

[0098] Based on the above embodiments, the present application also provides a storage medium, in which a computer program is stored. When the computer program is executed by a computer, the computer executes the data processing method for game merging provided in the above embodiments.

[0099] Based on the above embodiments, an embodiment of the present invention further provides a computer program, which, when executed on a computer, enables the computer to execute the data processing method for game server merging provided in the above embodiments.

[0100] Based on the above embodiments, an embodiment of the present invention further provides a chip, which is used to read a computer program stored in a memory and to execute the data processing method during game server merging provided in the above embodiments.

[0101] A computer program product is also provided in an embodiment of the present invention, including instructions, which, when executed on a computer, enable the computer to execute the data processing method for game server merging provided in the above embodiment.

[0102] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by instructions. These instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0103] These computer program instructions may also be stored in a computer readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0104] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0105] The above are only specific embodiments of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by a person skilled in the art within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A data processing method for game server merging, characterized in that: The method comprises: Determine the game data table that needs to be processed for conflicts, and generate a conflict registration data table based on the game data table name and name field name; Generate a backup data table corresponding to the game data table in the merged game server and build a conflict transfer data table; According to the conflict registration data table, based on all the names under the name field in the game data table of the target game server, searching whether the name exists under the name field in the backup data table; If it exists, generate a new name for the name, and write the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table; The backup data table of the merged game server is modified according to the conflict transfer data table, and then the content of the modified backup data table is merged into the game data table of the target game server.

2. The data processing method for game server merging according to claim 1, characterized in that: Generate a new name for the name, including: Determine whether the name exceeds a preset maximum name length; If not, determining a target character as a suffix of the name according to the character order of the preset character sequence to obtain a candidate name; In the game data table, or in the game data table and the conflict transfer data table, detecting whether the candidate name exists; If it does not exist, the candidate name is used as the new name; If it exists, returning to the step of determining a target character as the suffix of the name according to the character order of the preset character sequence to obtain a candidate name, until the candidate name does not exist in the game data table, or in the game data table and the conflict transfer data table, and then using the candidate name as the new name; If so, after deleting at least one character of the name, return to the step of determining a target character as a suffix of the name according to the character order of the preset character sequence to obtain a candidate name.

3. The data processing method for game server merging according to claim 2, characterized in that: In the game data table, or in the game data table and the conflict transfer data table, detecting whether the candidate name exists includes: If the conflict transfer data table is empty, then checking whether the candidate name exists under the name field in the game data table; If the conflict transfer data table is not empty, then a check is performed under the name field of the game data table and in the conflict transfer data table to determine whether the candidate name exists.

4. The data processing method for game server merging according to claim 1, characterized in that: Modifying the backup data table of the merged game server according to the conflict transfer data table includes: Traversing the conflict transfer data table, extracting each of the new names and the unique code corresponding to the new name; The name corresponding to the unique code is retrieved from the backup data table of the merged game server according to the unique code, and the name corresponding to the unique code is replaced with the new name.

5. The data processing method for game server merging according to claim 1, characterized in that: After generating a backup data table corresponding to the game data table in the merged game server and constructing a conflict transfer data table, the method further includes: Obtaining the size of each data table of the merged game server; Allocate a thread to each of the data tables according to the size of the data tables and the total number of threads; The data tables are exported based on the threads corresponding to the data tables.

6. The data processing method for game server merging according to claim 5, characterized in that: The method further comprises: Import the data exported by each of the threads in parallel into the database of the target game server.

7. A data processing device for game server merging, characterized in that: include: Conflict registration module and naming conflict handling module; The conflict registration module is used to determine the game data table that needs to be processed for conflict, and generate a conflict registration data table according to the game data table name and the name field name; The conflict registration module is used to generate a backup data table corresponding to the game data table in the merged game server; The naming conflict processing module is used to construct a conflict transfer data table; The naming conflict processing module is further used to search whether the name exists under the name field in the backup data table based on all the names under the name field in the game data table of the target game server according to the conflict registration data table; The naming conflict processing module is further used to generate a new name for the name if it exists, and write the new name and the unique code corresponding to the name in the backup data table into the conflict transfer data table; The naming conflict processing module is further used to modify the backup data table of the merged game server according to the conflict transfer data table, and then merge the contents of the modified backup data table into the game data table of the target game server.

8. The data processing device for game server merging according to claim 7, characterized in that: The naming conflict handling module is specifically used for: Determine whether the name exceeds a preset maximum name length; If not, determining a target character as a suffix of the name according to the character order of the preset character sequence to obtain a candidate name; In the game data table, or in the game data table and the conflict transfer data table, detecting whether the candidate name exists; If it does not exist, the candidate name is used as the new name; If it exists, then returning to the step of determining a target character as the suffix of the name according to the character order of the preset character sequence to obtain a candidate name, until the candidate name does not exist in the game data table, or in the game data table and the conflict transfer data table, and then using the candidate name as the new name; If so, after deleting at least one character of the name, return to the step of determining a target character as a suffix of the name according to the character order of the preset character sequence to obtain a candidate name.

9. An electronic device, characterized in that: It includes a processor and a memory, the memory stores machine executable instructions that can be executed by the processor, and the processor can execute the machine executable instructions to implement the data processing method when merging games according to any one of claims 1-6.

10. A storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the data processing method for game merging as described in any one of claims 1 to 6 is implemented.

Images