CN111314417A

CN111314417A - Application data processing method and device, storage medium and processor

Info

Publication number: CN111314417A
Application number: CN202010036588.1A
Authority: CN
Inventors: 屠文翔
Original assignee: Netease Hangzhou Network Co Ltd
Current assignee: Netease Hangzhou Network Co Ltd
Priority date: 2020-01-14
Filing date: 2020-01-14
Publication date: 2020-06-19
Anticipated expiration: 2040-01-14
Also published as: CN111314417B

Abstract

The invention discloses a method and a device for processing application data, a storage medium and a processor. Wherein, the method comprises the following steps: creating a second storage area matched with the first storage area, wherein the first storage area is used for storing all application data generated during the running of the target application, and the second storage area is used for storing partial application data copied from the first storage area; and responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area. The invention solves the technical problem that when the target application is periodically tested in the related technology, a large amount of time is consumed for copying the whole application data stored in the online database to the offline server, so that the test is difficult.

Description

Application data processing method and device, storage medium and processor

Technical Field

The invention relates to the technical field of internet, in particular to a method and a device for processing application data, a storage medium and a processor.

Background

The network game server needs to be periodically maintained in a shutdown state. Maintenance downtime typically goes through several steps: 1. closing the external network gateway and kicking the player off the line; 2. stopping the game server; 3. updating the code version; 4. starting a game server; 5. logging in a game server by Quality Assurance personnel/testers (QA for short) in the project group for testing; 6. and opening the external network to allow the player to log in.

The most time consuming down maintenance is step 5, the QA test part, of the above steps. Generally, QA will complete the testing work on the internal server. However, the internal server has fewer personnel, and the game behavior of the internal personnel is different from that of the external real player, so that the game data of the internal server is not as comprehensive as that of the external formal server. Therefore, the QA staff logs in to the formal server to perform the test after the external server is opened and before the external network is opened.

By adopting the method, the QA personnel can use the real data to test in the real environment. However, this approach has two disadvantages: 1. because the online environment is tested, the data cannot be forged by the cheating codes, otherwise, the online data can be influenced. 2. The test time is very urgent because the longer the test time, the longer the maintenance time is taken out of service. Generally, the test needs to be completed within 1 hour.

Disclosure of Invention

The embodiment of the invention provides an application data processing method and device, a storage medium and a processor, which are used for at least solving the technical problem that when a target application is periodically tested in the related art, a large amount of time is consumed for copying the whole amount of application data stored in an online database to an offline server, so that the test is difficult.

According to an aspect of an embodiment of the present invention, there is provided a method for processing application data, including: creating a second storage area matched with the first storage area, wherein the first storage area is used for storing all application data generated during the running of a target application, and the second storage area is used for storing partial application data copied from the first storage area; and responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area.

Optionally, the performing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: in response to a test instruction for testing the target application, querying the second storage area for target data related to the test instruction; if the target data exists in the second storage area, the target data in the second storage area is used as data to be operated; if the target data does not exist in the second storage area, acquiring the target data from the first storage area and storing the target data into the second storage area; and executing data control operation corresponding to the test instruction on the data to be operated in the second storage area.

Optionally, the method for processing application data further includes: and establishing a connection relation between a test server and the first storage area and between the test server and the second storage area respectively, wherein the first storage area is connected with the online server of the target application at the same time.

Optionally, the performing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: responding to a test instruction for testing the target application, and acquiring user login information corresponding to the test instruction; and entering the target application in a development environment based on the user login information, and writing the application data of the user corresponding to the user login information into the second storage area from the first storage area.

Optionally, the test instruction includes an instruction for data insertion for the target application; the executing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: and responding to an instruction for performing data insertion on the target application, and inserting the data to be inserted corresponding to the instruction for performing data insertion into the second storage area for storage.

Optionally, the test instruction includes an instruction for performing data query on the target application; the executing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: in response to an instruction of data query for the target application, searching data matched with the instruction of the data query from the second storage area according to the instruction of the data query; receiving data queried from the second storage area.

Optionally, the searching, according to the instruction of the data query, for data matching the instruction of the data query from the second storage area includes: searching data from the second storage area according to the instruction of the data query; if the data searched from the second storage area meets the preset conditions, the data searched is used as a query result; and if the data searched from the second storage area does not meet the preset condition, searching the data from the first storage area according to the data query instruction, taking the data searched from the first storage area as the data to be transported, copying the data to be transported from the first storage area to the second storage area, and taking the data copied from the first storage area as the query result searched from the second storage area.

Optionally, after the data searched from the first storage area is stored in the second storage area and before the data copied from the first storage area is used as the query result searched from the second storage area, the method for processing application data further includes: and searching data from the second storage area according to the instruction of the data query.

Optionally, the test instruction includes an instruction for updating data for the target application; the executing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: in response to an instruction for updating data for the target application, taking the data to be updated corresponding to the instruction for updating data as the data to be transported, and copying the data to be transported from the first storage area to the second storage area; updating the data to be updated in the second storage area.

Optionally, the test instruction includes an instruction for deleting data for the target application; the executing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes: and in response to the instruction of deleting the data aiming at the target application, deleting the data to be deleted corresponding to the instruction of deleting the data from the second storage area.

Optionally, after the data to be deleted corresponding to the instruction to delete data is deleted from the second storage area, the method for processing application data further includes: and searching the data to be deleted from the first storage area according to the data deleting instruction, and if the data to be deleted exists in the first storage area, recording the data to be deleted in a preset deleting record table.

Optionally, before copying the data to be handled from the first storage area to the second storage area, the method for applying data processing further includes: and confirming that the data to be transported is not inquired from a preset deletion record table, wherein the deletion record table is used for recording the data deleted from the second storage area and existing in the first storage area.

According to another aspect of the embodiments of the present invention, there is also provided an apparatus for processing application data, including: the device comprises a creating unit, a storage unit and a processing unit, wherein the creating unit is used for creating a second storage area matched with a first storage area, the first storage area is used for storing all application data generated during the running of a target application, and the second storage area is used for storing partial application data copied from the first storage area; and the execution unit is used for responding to a test instruction for testing the target application and executing data control operation corresponding to the test instruction on the second storage area.

Optionally, the execution unit includes: a first response module, configured to, in response to a test instruction for testing the target application, query the second storage area for target data related to the test instruction; a first determining module, configured to, when the target data exists in the second storage area, use the target data in the second storage area as data to be operated; a first obtaining module, configured to, if the target data does not exist in the second storage area, obtain the target data from the first storage area and store the target data in the second storage area; and the execution module is used for executing data control operation corresponding to the test instruction on the data to be operated in the second storage area.

Optionally, the apparatus for applying data processing further includes: and the creating unit is used for creating a connection relation between the test server and the first storage area and between the test server and the second storage area respectively, wherein the first storage area is connected with the online server of the target application at the same time.

Optionally, the execution unit includes: the second response module is used for responding to a test instruction for testing the target application and acquiring user login information corresponding to the test instruction; and the writing module is used for entering the target application in a development environment based on the user login information and writing the application data of the user corresponding to the user login information into the second storage area from the first storage area.

Optionally, the test instruction includes an instruction for data insertion for the target application; the execution unit includes: and the inserting module is used for responding to an instruction for performing data insertion on the target application, and inserting the data to be inserted corresponding to the instruction for performing data insertion into the second storage area for storage.

Optionally, the test instruction includes an instruction for performing data query on the target application; the execution unit includes: the searching module is used for responding to an instruction of data query for the target application and searching data matched with the instruction of the data query from the second storage area according to the instruction of the data query; and the receiving module is used for receiving the data inquired from the second storage area.

Optionally, the search module includes: the first searching submodule is used for searching data from the second storage area according to the instruction of the data query; the first determining submodule is used for taking the searched data as a query result if the data searched from the second storage area meets a preset condition; and the second determining submodule is used for searching data from the first storage area according to the data query instruction if the data searched from the second storage area does not meet the preset condition, taking the data searched from the first storage area as the data to be transported, copying the data to be transported from the first storage area to the second storage area, and taking the data copied from the first storage area as the query result searched from the second storage area.

Optionally, the apparatus further comprises: and the second searching submodule is used for searching data from the second storage area according to the instruction of the data query after the data searched from the first storage area is stored in the second storage area and before the data copied from the first storage area is used as the query result searched from the second storage area.

Optionally, the test instruction includes an instruction for updating data for the target application; the execution unit includes: the copying module is used for responding to a command for updating data aiming at the target application, taking the data to be updated corresponding to the command for updating data as the data to be carried, and copying the data to be carried from the first storage area to the second storage area; and the updating module is used for updating the data to be updated in the second storage area.

Optionally, the test instruction includes an instruction for deleting data for the target application; the execution unit includes: and the deleting module is used for responding to a command for deleting the data aiming at the target application and deleting the data to be deleted corresponding to the command for deleting the data from the second storage area.

Optionally, the apparatus for applying data processing further includes: and the recording module is used for searching the data to be deleted from the first storage area according to the data deleting instruction after the data to be deleted corresponding to the data deleting instruction is deleted from the second storage area, and recording the data to be deleted in a preset deleting record table if the data to be deleted exists in the first storage area.

Optionally, the apparatus for applying data processing further includes: the determining module is configured to determine that the data to be transported is not queried from a preset deletion record table before the data to be transported is copied from the first storage area to the second storage area, where the deletion record table is used to record the data deleted from the second storage area and existing in the first storage area.

According to another aspect of the embodiments of the present invention, there is also provided a storage medium for storing a program, where the program, when executed by a processor, controls a device in which the storage medium is located to perform the method for processing application data described in any one of the above.

According to another aspect of the embodiment of the present invention, there is also provided a processor, configured to execute a program, where the program executes to perform the method for processing application data described in any one of the above.

According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the method of application data processing of any of the above via execution of the executable instructions.

In the embodiment of the invention, a second storage area matched with a first storage area is created, wherein the first storage area is used for storing all application data generated during the running of a target application, and the second storage area is used for storing partial application data copied from the first storage area; and responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area. By the method for processing the application data, when the target application needs to be tested, the second storage area is started, and partial online data is acquired from the first storage area by the second storage area, so that the aim of testing the target application by using the online data in the internal server is fulfilled, all the online data do not need to be copied to the internal server, the pressure of data copying is reduced, the testing efficiency is improved, and the requirement on the hardware configuration of the database is reduced.

Drawings

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:

FIG. 1 is a flow diagram of a method of applying data processing according to an embodiment of the invention;

fig. 2 is an architecture diagram of an overall server corresponding to a method of applying data processing according to an embodiment of the present invention;

FIG. 3 is a flow diagram of a data query operation in a method of applying data processing according to an embodiment of the invention;

FIG. 4 is a flow diagram of a data update operation in a method of applying data processing according to an embodiment of the present invention;

FIG. 5 is a flow diagram of a data delete operation in a method of applying data processing according to an embodiment of the present invention;

FIG. 6 is a flow diagram of a data delete operation in an alternative method of applying data processing in accordance with an embodiment of the present invention;

fig. 7 is a schematic diagram of an apparatus for applying data processing according to an embodiment of the present invention.

Detailed Description

In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

The inventor has found that the full amount of the online formal server database can be copied to the database of some internal server in order to enable QA to perform a test using external data in the internal server. The database is then used to launch the server so that QA can use the external data for testing. However, the amount of data in the online formal server database is very large. The amount of database data for online official services may reach TB or PB depending on the magnitude of the registered players. Copying such huge data to an internal server requires a whole set of databases with performance comparable to that of the on-line databases to be built in the internal server. Moreover, copying such a large amount of data takes a very long time, which also makes testing difficult.

The method and the device aim at the problem that when the network game is periodically tested in the related technology, a large amount of time is consumed for copying the whole amount of data stored in the online database to the database of the internal server, so that the testing is difficult. The present invention provides a method and an apparatus for processing application data, and the following will specifically describe the method and the apparatus for processing application data.

According to an aspect of embodiments of the invention, there is provided an embodiment of a method of applying data processing, it being noted that the steps illustrated in the flowchart of the drawings may be performed in a computer system such as a set of computer-executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than here.

Fig. 1 is a flowchart of a method of applying data processing according to an embodiment of the present invention, as shown in fig. 1, the method of applying data processing including the steps of:

step S102, a second storage area matched with the first storage area is created, wherein the first storage area is used for storing all application data generated during the running of the target application, and the second storage area is used for storing part of the application data copied from the first storage area.

Alternatively, the target application may be a game.

Optionally, when the target application is a game, the first storage area may be an online database in an online game environment, and in the online game environment, in the process of running the online server corresponding to the game, all game data (i.e., all application data) of the online player are stored in the first storage area, i.e., the online database in real time.

Optionally, the second storage area may be a mirror database of the online database, but the mirror database in the present invention is used to store part of the application data stored in the online database, for example, the data of the online database is continuously transferred to the mirror database of the internal server during the operation of the game server. Rather than copying all of the data in the online database to the mirror database after the game server is started or running.

In one application scenario, upon acquisition of a request message that requires testing of a target application (e.g., a game), a mirror database corresponding to an online database is created.

In addition, the mirror database may be created in advance, and when the request message is acquired, the mirror database may be directly started in response to the request message, and part of the application data in the online database is transported to the mirror database and stored, so that a subsequent tester may test the target application by using the data.

And step S104, responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area.

As can be seen from the above, in the embodiment of the present invention, by creating the second storage area matched with the first storage area, wherein the first storage area is used for storing all application data generated during the running of the target application, and the second storage area is used for storing part of application data copied from the first storage area; and responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area so as to achieve the purpose of testing the target application by using the online data in the internal server.

It should be noted that, when a target application needs to be tested, a second storage area matching the first storage area may be created, and in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction may be executed on the second storage area to test the target application, so that the target application may be tested in a development environment by using a part of application data in the second storage area created in the development environment, and it is not necessary to copy the entire application data in the first storage area in the online environment to the development environment, thereby reducing the requirement for configuration of an additional storage area, and the first storage area and the second storage area are located in the online environment and the development environment, respectively, so that a tester may relive from using a cheat code to accelerate a test process, thereby implementing in an internal server, the online data are used for testing the target application, and all the online data do not need to be copied to an internal server, so that the data copying pressure is reduced, and the testing efficiency is improved.

Therefore, the method for processing the application data provided by the embodiment of the invention solves the technical problem that when the target application is periodically tested in the related art, a large amount of time is consumed for copying the whole amount of the application data stored in the online database to the offline server, so that the test is difficult.

According to the above embodiment of the present invention, in step S104, in response to a test instruction for testing a target application, performing a data control operation corresponding to the test instruction on the second storage area includes: in response to a test instruction for testing the target application, querying the second storage area for target data related to the test instruction; if the target data exists in the second storage area, the target data in the second storage area is used as data to be operated; if the target data does not exist in the second storage area, acquiring the target data from the first storage area and storing the target data into the second storage area; and executing data control operation corresponding to the test instruction on the data to be operated in the second storage area.

For example, when a test instruction for testing the target application is received, first, target data related to the test instruction (i.e., data for testing the target application) is searched in the second storage area; in one aspect, when the query result is that the target data exists in the second storage area, the target data in the second storage area is used as the data to be operated; on the other hand, when the target data does not exist in the second storage area, the target data may be acquired from the first storage area and stored in the second storage area, so that a data control operation corresponding to the test instruction, such as a data insertion operation, a data query operation, a data update operation, a data deletion operation, or the like, may be performed on the data to be operated in the second storage area. The specific implementation manner of the data control operation is described in detail in the following embodiments, and is not described herein again.

The target data is acquired from the first storage area and stored in the second storage area, and the data deletion record table in the second storage area can be queried by using an original query statement (namely, an instruction for data handling of the target application), and when a query result meeting the requirement of the original query statement exists in the data deletion record table according to the query result, the data deletion record table is determined to be the data deletion record table; filtering corresponding data in the original query sentence by using a main key to obtain a filtering result; generating a new query statement (namely, a modified data carrying instruction) according to the filtering result, and executing a query operation in the first storage area by using the new query statement to obtain a query result; skipping data records in the query result that already exist in the second storage area, and inserting data records in the query result that do not exist in the second storage area into the second storage area.

The above data processing may be understood as a transfer operation of copying application data that does not originally exist in the second storage area from the first storage area to the second storage area, and in the embodiment of the present invention, the transfer operation refers to a process of copying the application data from the online official database to the mirror database. The handling operation consists of the following steps: 1) firstly, using original query statement to query the _ delete table in mirror database; 2) if the query result exists in the step 1, filtering out the corresponding item in the original query statement by using the main key; 3) querying an online formal database using the new query statement; 4) executing the following operations on the query results item by item: a) skipping the operation if there is a record in the mirror database; b) and if the mirror database does not have the corresponding record, inserting the query result into the mirror database.

In the embodiment of the invention, one query statement can query a plurality of pieces of data, for example, one query statement can query three pieces of data (a, B, C) at the same time, and if the query result a exists in the deletion record table, the data corresponding to the query result a is filtered, that is, the data corresponding to the query result a is not queried any more, and the query result a is not carried; and continuing to query the data B and C which do not exist in the query result, namely, the query statement only queries the data which do not exist in the query result. Specifically, if the deletion record table has a query result, the corresponding item in the original query statement is filtered out by using the primary key.

Through the embodiment of the invention, when the test instruction for testing the target application is received, the target data related to the test instruction can be inquired from the second storage area; when the target data exists in the second storage area, the target data in the second storage area is used as data to be operated; on the contrary, when the target data does not exist in the second storage area, the target data is acquired from the first storage area and stored in the second storage area, and the data control operation corresponding to the test instruction is executed on the data to be operated in the second storage area, so that when the target application is tested, all application data generated in the running process of the target application and stored in the first storage area are not copied to the second storage area, but data transportation is carried out according to the test requirement. Namely, when part of the application data stored in the second storage area cannot meet the test requirement, data transportation is carried out in real time based on the test requirement, so that the purposes of carrying the application data as required and carrying the application data in real time when the target application is tested are achieved, the pressure of data copying is reduced, and the test efficiency is improved.

In order to implement application data interaction between the online database (i.e., the first storage area) and the mirror database (i.e., the second storage area), between the online database and the online server, and between the mirror database and the internal server (i.e., the test server), in an embodiment of the present invention, the method for processing application data may further include: and establishing a connection relation between the test server and the first storage area and between the test server and the second storage area respectively, wherein the first storage area is connected with the on-line server of the target application at the same time.

According to the above embodiment of the present invention, in step S104, in response to a test instruction for testing a target application, performing a data control operation corresponding to the test instruction on the second storage area includes: responding to a test instruction for testing the target application, and acquiring user login information corresponding to the test instruction; and entering the target application in the development environment based on the user login information, and writing the application data of the user corresponding to the user login information into the second storage area from the first storage area.

For example, the tester may obtain login information of an online player of a game in the online environment, and login a target application in the development environment by using the login information in the development environment, and simultaneously write game data (i.e., application data) of the online player from the first storage area into the second storage area for the tester to perform a test.

In addition, since the tester logs in the target application in the development environment, when the online player is playing the game online (i.e., the target application), the tester can use the second storage area to start an offline server and can use the cheating code to help the tester to add 1000 coins, and in the process, the online player cannot be kicked off by the tester and cannot increase 1000 coins due to the operation of the tester.

Therefore, in the embodiment of the invention, the first storage area and the second storage area are respectively located in different environments, that is, the application data stored in the first storage area and the application data stored in the second storage area are isolated, so that a tester can use the cheating codes to accelerate the test process with confidence.

Fig. 2 is an architecture diagram of an overall server corresponding to a method of applying data processing according to an embodiment of the present invention, and as shown in fig. 2, an entire environment may include an online environment part and a development environment part; among them, there are an online database (i.e., a first storage area) and a formal server (i.e., an online server) in an online environment, and a mirror database (a second storage area) and an internal server (i.e., an offline database) in a development environment. As shown in fig. 2, in the online environment, the formal game server is connected to the online database and has a read-write permission for the online database; in a development environment, an internal server is connected with an online database and a mirror database at the same time, and has a read-only permission for the online database and a read-write permission for the mirror database.

In an optional embodiment, when the test instruction includes an instruction for data insertion for the target application, in response to the test instruction for testing the target application, performing a data control operation corresponding to the test instruction on the second storage area includes: and responding to an instruction for performing data insertion on the target application, and inserting the data to be inserted corresponding to the instruction for performing data insertion into the second storage area for storage.

In another alternative embodiment, the test instruction includes an instruction for performing data query on the target application, and in response to the test instruction for performing test on the target application, the performing a data control operation corresponding to the test instruction on the second storage area includes: in response to the instruction of data query for the target application, searching data matched with the instruction of data query from the second storage area according to the instruction of data query; data queried from the second storage area is received.

Searching data matched with the data query instruction from the second storage area according to the data query instruction, wherein the searching comprises the following steps: searching data from the second storage area according to the data query instruction; if the data searched from the second storage area meets the preset conditions, the searched data is used as a query result; and if the data searched from the second storage area does not meet the preset condition, searching the data from the first storage area according to the data query instruction, taking the data searched from the first storage area as the data to be transported, copying the data to be transported from the first storage area to the second storage area, and taking the data copied from the first storage area as the query result searched from the second storage area.

In the above embodiment, after storing the data searched from the first storage area into the second storage area and before using the data copied from the first storage area as the query result searched from the second storage area, the method for applying data processing may further include: and searching data from the second storage area according to the instruction of data query.

The data operation corresponding to the instruction for performing data query on the target application may be a data query operation, and specifically, the data query operation refers to requesting one or more data records from a database through a query statement. In the embodiment of the present invention, the data query operation may be implemented according to the following steps: 1) route query statements to the mirror database (e.g., query statements are to query 5 players whose names contain "Wangma"); 2) if the number of returned results of the mirror database meets the expectations (i.e., the narrative conditions) (e.g., 5 results are returned), directly feeding back the query results; 3) if the number of results returned does not meet expectations (e.g., only 3 results returned), a data-moving operation from the online database to the mirror database is triggered; 4) query the mirror database with the same query statement, wherein the query structure is returned regardless of whether the query information satisfies the expectation.

Fig. 3 is a flowchart of a data query operation in the method for processing application data according to the embodiment of the present invention, and as shown in fig. 3, queries a mirror database based on a query statement, and determines whether a result returned by the mirror database meets a requirement; if yes, returning a query result; if not, copying part of game data from the formal database to the mirror database; and executing query operation to the mirror database by using the query statement again, and returning a query result.

The copying of the application data of the online database to the mirror database is referred to as a transfer operation. If a certain data record exists in the mirror database, the data handling operation does not cover the data record existing in the mirror database.

In addition, when the query operation is performed on the mirror database by the same query statement, the query result is returned regardless of whether the query result meets the expectation. This is because, if there has been one transport operation before that, if the returned data is still insufficient, it indicates that the data in the online database is also so, and therefore, it is sufficient to directly return the feedback result.

In an alternative embodiment, the test instructions include instructions to perform data updates for the target application; in response to a test instruction for testing the target application, performing a data control operation corresponding to the test instruction on the second storage area, including: in response to an instruction for updating data for a target application, taking the data to be updated corresponding to the instruction for updating data as the data to be transported, and copying the data to be transported from the first storage area to the second storage area; and updating the data to be updated in the second storage area.

Fig. 4 is a flowchart of a data update operation in the method for processing application data according to the embodiment of the present invention, and as shown in fig. 4, data corresponding to a query statement (i.e., an instruction for updating data for a target application) is copied from a formal database to a mirror database, and the mirror database is directly modified by using the copied data, and a query result is returned.

That is, the operation executed by the instruction for updating data of the target application may be an update operation, and the update operation refers to modifying one or more data records in the mirror database. In the embodiment of the present invention, the update operation may be implemented according to the following steps: firstly, triggering a carrying operation, and copying corresponding data in an online database to a mirror database; modifying data in the mirror database; and returning a modification result.

It should be noted that if a certain data record exists in the mirror database, the data record existing in the mirror database is not covered by the transport operation.

Because many records can be updated in batches by the updating operation, the existing data in the mirror database cannot be covered by the carrying operation, and the records which do not exist in the mirror database are copied firstly and then updated together.

In an optional embodiment, the test instruction includes an instruction to delete data for the target application, and in response to the test instruction to test the target application, the data control operation corresponding to the test instruction is performed on the second storage area, including: and in response to the instruction of deleting the data aiming at the target application, deleting the data to be deleted corresponding to the instruction of deleting the data from the second storage area.

For the deletion operation, after the data to be deleted corresponding to the data deletion instruction is deleted from the second storage area, the method for processing the application data further includes: and searching data to be deleted from the first storage area according to the data deleting instruction, and recording the data to be deleted in a preset deleting record table if the data to be deleted exists in the first storage area.

In addition, before copying the data to be transported from the first storage area to the second storage area, the method for applying data processing further includes: and confirming that the data to be transported is not inquired from a preset deletion record table, wherein the deletion record table is used for recording the data deleted from the second storage area and existing in the first storage area.

As can be seen from the above, if there is no data to be deleted in the first storage area, there is no need to add the data to be deleted to the deletion record table. That is, in the embodiment of the present invention, the deletion of the record table mainly plays a role of preventing the conveyance operation from being triggered by mistake. Whether a certain item of data is deleted or not carried can be determined according to the deletion record table, if a record exists in the deletion record table, the item of data is deleted, and if no record exists in the deletion record table, the item of data is not carried.

Fig. 5 is a flowchart of a data deletion operation in the method for processing application data according to the embodiment of the present invention, and as shown in fig. 5, delete a data record in a deletion statement (i.e., an instruction for deleting data for a target application) in a mirror database, query an online database, determine whether a data record corresponding to the deletion statement exists in the online database according to a query result, if so, insert the data record into a new table named < table name > _ delete, and feed back a result; and otherwise, determining that the deleted data record is the newly added data in the mirror image data, and directly returning the result.

The operation executed by the instruction for deleting data from the target application may be a deleting operation, where the deleting operation refers to deleting one or more data records in the mirror database. It should be noted that simply deleting a data record from the mirror database is not sufficient. Therefore, if a record does not exist in the mirror database, a transfer operation is triggered, and therefore, in order to distinguish whether a data record is deleted or not transferred, a series of tables need to be introduced into the mirror database to mark the deleted data record.

In addition, for each table in the mirror database, a new table with a _ delete suffix is added. If the data record to be deleted exists in the online database, a new record is added to the < table name > _ delete for filtering the results in the query.

Specifically, the deletion operation is performed according to the following steps: 1) deleting the corresponding data record in the mirror database; 2) querying the online formal database with the delete statement; 3) if the corresponding data record exists in the on-line formal database, the data record is transferred to the table of < table name > _ delete in the mirror database.

The following explains the implementation steps of the delete operation with a specific example.

For example, there is a table in the online database, with the table name: player _ name _ delete, where there are two records,

id

1 and 2 respectively. Now, the following operations are performed in order in the internal server: 1) delete record 1; 2) query record 2; 3) delete record 2.

After the above three steps are performed, the content in the database finally becomes as shown in fig. 6 (where fig. 6 is a flowchart of a data deleting operation in the optional method for applying data processing according to the embodiment of the present invention). That is, in performing step 1), record 1 in the mirror database is first deleted. Detecting that record 1 does exist in the formal database, so adding a deleted record of record 1 to the player _ name _ delete table; when the step 2) is executed, the record 2 is found not to exist in the mirror database, so the record 2 is transported to the mirror database from the online database; when step 3) is executed, it is found that there is no record 1 in the mirror database, but when an attempt is made to transport record 1 from the main database, it is found that there is record 1 in the player _ name _ delete table, and therefore the transport is stopped.

The method for processing the application data provided by the embodiment of the invention solves the following problems: 1) allowing a tester to use the online data to perform a test at an internal server; 2) no full online data needs to be copied to the internal server, thus requiring less additional database hardware configuration; 3) the data is copied on demand when the game server is running, without extra time for copying the data; 4) the internal server data is isolated from the online official server data, and the tester can use the cheating code to accelerate the test process.

In the embodiment of the invention, an additional database is used for testing assistance, namely, the mirror database, and the offline server is simultaneously connected with the online formal database and the mirror database. The inquiry of the bottom-layer database of the modified game server is mainly realized by the following steps: a) when inquiring, firstly inquiring the mirror database. If the data exists in the mirror database, the data is directly returned. Otherwise, the corresponding data is firstly transported to the mirror database from the online formal database, and then the data is returned. b) When modifying, firstly, the mirror database is queried. If data exists in the mirror database, the data is modified directly. Otherwise, the corresponding data is firstly transported to the mirror database from the online formal database, and then the data is modified.

In addition, the data of the online formal database is continuously transported to the internal server in the running process of the game server. Because the number of testers is small, and the data are all carried as required when being inquired (or modified), the data carrying amount is small. Therefore, the hardware configuration of the mirror database does not need to be high-end, and the influence of the query process on the online database is small.

According to another aspect of the embodiments of the present invention, there is further provided an embodiment of an apparatus for performing the method for processing application data in embodiment 1, and fig. 7 is a schematic diagram of an apparatus for processing application data according to an embodiment of the present invention, and as shown in fig. 7, the apparatus for processing application data may include: a creation unit 71 and an execution unit 73. The apparatus for applying data processing will be described in detail below.

The creating unit 71 is configured to create a second storage area matching the first storage area, where the first storage area is used to store all application data generated during the running of the target application, and the second storage area is used to store a part of the application data copied from the first storage area.

And the execution unit 73 is used for responding to a test instruction for testing the target application and executing data control operation corresponding to the test instruction on the second storage area.

It should be noted here that the creating unit 71 and the executing unit 73 correspond to steps S102 to S104 in embodiment 1, and the units are the same as the examples and application scenarios realized by the corresponding steps, but are not limited to the disclosure of embodiment 1. It should be noted that the above-described elements as part of an apparatus may be implemented in a computer system, such as a set of computer-executable instructions.

As can be seen from the above, in the above embodiments of the present application, the creating unit may be used to create a second storage area matching the first storage area, where the first storage area is used to store all application data generated during the running of the target application, and the second storage area is used to store part of the application data copied from the first storage area; and executing, by the execution unit, a data control operation corresponding to the test instruction on the second storage area in response to the test instruction for testing the target application. By the application data processing device provided by the embodiment of the invention, the purpose that the target application is tested by using the online data in the internal server is realized by starting the second storage area and acquiring partial online data from the first storage area by using the second storage area when the target application needs to be tested, and the purpose that the target application is tested by using the online data is realized without copying all the online data to the internal server, so that the pressure of data copying is reduced, the testing efficiency is improved, and meanwhile, the requirement on the hardware configuration of the database is reduced, thereby solving the technical problem that a large amount of time is consumed for copying the full amount of application data stored in the online database to the offline server when the target application is periodically tested in the related technology, and the testing is difficult.

In an alternative embodiment, the execution unit includes: the first response module is used for responding to a test instruction for testing the target application and inquiring target data related to the test instruction from the second storage area; the first determining module is used for taking the target data in the second storage area as the data to be operated under the condition that the target data exists in the second storage area; the first acquisition module is used for acquiring the target data from the first storage area and storing the target data into the second storage area under the condition that the target data does not exist in the second storage area; and the execution module is used for executing data control operation corresponding to the test instruction on the data to be operated in the second storage area.

In an alternative embodiment, the apparatus for applying data processing further comprises: and the creating unit is used for creating a connection relation between the test server and the first storage area and between the test server and the second storage area respectively, wherein the first storage area is connected with the online server of the target application at the same time.

In an alternative embodiment, the execution unit includes: the second response module is used for responding to a test instruction for testing the target application and acquiring user login information corresponding to the test instruction; and the writing module is used for entering the target application in the development environment based on the user login information and writing the application data of the user corresponding to the user login information into the second storage area from the first storage area.

In an alternative embodiment, the test instructions include instructions for data insertion for the target application; an execution unit comprising: and the inserting module is used for responding to the instruction for inserting the data into the target application, and inserting the data to be inserted corresponding to the instruction for inserting the data into the second storage area for storage.

In an alternative embodiment, the test instructions include instructions to perform a data query for the target application; an execution unit comprising: the searching module is used for responding to the instruction of data query aiming at the target application and searching data matched with the instruction of the data query from the second storage area according to the instruction of the data query; and the receiving module is used for receiving the data inquired from the second storage area.

In an alternative embodiment, the lookup module includes: the first searching submodule is used for searching data from the second storage area according to the data searching instruction; the first determining submodule is used for taking the searched data as a query result if the data searched from the second storage area meets the preset condition; and the second determining submodule is used for searching data from the first storage area according to a data query instruction if the data searched from the second storage area does not meet the preset condition, taking the data searched from the first storage area as the data to be transported, copying the data to be transported from the first storage area to the second storage area, and taking the data copied from the first storage area as a query result searched from the second storage area.

In an alternative embodiment, the apparatus further comprises: and the second searching submodule is used for searching the data from the second storage area according to the instruction of data query after the data searched from the first storage area is stored in the second storage area and before the data copied from the first storage area is used as the query result searched from the second storage area.

In an alternative embodiment, the test instructions include instructions to perform data updates for the target application; an execution unit comprising: the copying module is used for responding to a command for updating data aiming at the target application, taking the data to be updated corresponding to the command for updating data as the data to be carried, and copying the data to be carried from the first storage area to the second storage area; and the updating module is used for updating the data to be updated in the second storage area.

In an optional embodiment, the test instruction comprises an instruction for deleting data for the target application; an execution unit comprising: and the deleting module is used for responding to the instruction of deleting the data aiming at the target application and deleting the data to be deleted corresponding to the instruction of deleting the data from the second storage area.

In an alternative embodiment, the apparatus for applying data processing further comprises: and the recording module is used for searching the data to be deleted from the first storage area according to the data deleting instruction after the data to be deleted corresponding to the data deleting instruction is deleted from the second storage area, and recording the data to be deleted in a preset deleting record table if the data to be deleted exists in the first storage area.

In an alternative embodiment, the apparatus for applying data processing further comprises: the determining module is used for confirming that the data to be transported is not inquired from a preset deletion record table before the data to be transported is copied from the first storage area to the second storage area, wherein the deletion record table is used for recording the data deleted from the second storage area and existing in the first storage area.

According to another aspect of the embodiments of the present invention, there is also provided a storage medium for storing a program, where the program, when executed by a processor, controls an apparatus in which the storage medium is located to perform the method of application data processing in any one of the above.

According to another aspect of the embodiments of the present invention, there is also provided a processor, configured to execute a program, where the program executes a method for processing application data in any one of the above.

According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions for the processor; wherein the processor is configured to perform the method of application data processing of any of the above via execution of the executable instructions.

The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.

In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims

1. A method of application data processing, comprising:

creating a second storage area matched with the first storage area, wherein the first storage area is used for storing all application data generated during the running of a target application, and the second storage area is used for storing partial application data copied from the first storage area;

and responding to a test instruction for testing the target application, and executing data control operation corresponding to the test instruction on the second storage area.

2. The method of claim 1, wherein performing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area comprises:

in response to a test instruction for testing the target application, querying the second storage area for target data related to the test instruction;

if the target data exists in the second storage area, the target data in the second storage area is used as data to be operated;

if the target data does not exist in the second storage area, acquiring the target data from the first storage area and storing the target data into the second storage area;

and executing data control operation corresponding to the test instruction on the data to be operated in the second storage area.

3. The method of claim 1, further comprising:

and establishing a connection relation between a test server and the first storage area and between the test server and the second storage area respectively, wherein the first storage area is connected with the online server of the target application at the same time.

4. The method of claim 1, wherein performing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area comprises:

responding to a test instruction for testing the target application, and acquiring user login information corresponding to the test instruction;

and entering the target application in a development environment based on the user login information, and writing the application data of the user corresponding to the user login information into the second storage area from the first storage area.

5. The method of claim 1, wherein the test instructions comprise instructions for data insertion for the target application;

the executing, in response to a test instruction for testing the target application, a data control operation corresponding to the test instruction on the second storage area includes:

and responding to an instruction for performing data insertion on the target application, and inserting the data to be inserted corresponding to the instruction for performing data insertion into the second storage area for storage.

6. The method of claim 1, wherein the test instructions comprise instructions to perform a data query for the target application;

in response to an instruction of data query for the target application, searching data matched with the instruction of the data query from the second storage area according to the instruction of the data query;

receiving data queried from the second storage area.

7. The method of claim 6, wherein the searching for data matching the instruction of the data query from the second storage area according to the instruction of the data query comprises:

searching data from the second storage area according to the instruction of the data query;

if the data searched from the second storage area meets the preset conditions, the data searched is used as a query result;

and if the data searched from the second storage area does not meet the preset condition, searching the data from the first storage area according to the data query instruction, taking the data searched from the first storage area as the data to be transported, copying the data to be transported from the first storage area to the second storage area, and taking the data copied from the first storage area as the query result searched from the second storage area.

8. The method of claim 7, wherein after storing the data retrieved from the first storage area in the second storage area and before copying the data retrieved from the first storage area as the result of the query retrieved from the second storage area, the method further comprises:

and searching data from the second storage area according to the instruction of the data query.

9. The method of claim 1, wherein the test instructions comprise instructions to perform data updates for the target application;

in response to an instruction for updating data for the target application, taking the data to be updated corresponding to the instruction for updating data as the data to be transported, and copying the data to be transported from the first storage area to the second storage area;

updating the data to be updated in the second storage area.

10. The method of claim 1, wherein the test instructions comprise instructions for data deletion for the target application;

and in response to the instruction of deleting the data aiming at the target application, deleting the data to be deleted corresponding to the instruction of deleting the data from the second storage area.

11. The method according to claim 10, wherein after the data to be deleted corresponding to the instruction to delete the data is deleted from the second storage area, the method further comprises:

and searching the data to be deleted from the first storage area according to the data deleting instruction, and if the data to be deleted exists in the first storage area, recording the data to be deleted in a preset deleting record table.

12. The method according to claim 7 or 9, wherein before copying the data to be handled from the first storage area to the second storage area, the method further comprises:

and confirming that the data to be transported is not inquired from a preset deletion record table, wherein the deletion record table is used for recording the data deleted from the second storage area and existing in the first storage area.

13. An apparatus for applying data processing, comprising:

the device comprises a creating unit, a storage unit and a processing unit, wherein the creating unit is used for creating a second storage area matched with a first storage area, the first storage area is used for storing all application data generated during the running of a target application, and the second storage area is used for storing partial application data copied from the first storage area;

and the execution unit is used for responding to a test instruction for testing the target application and executing data control operation corresponding to the test instruction on the second storage area.

14. A storage medium for storing a program, wherein the program, when executed by a processor, controls an apparatus in which the storage medium is located to perform the method of application data processing according to any one of claims 1 to 12.

15. A processor, characterized in that the processor is configured to run a program, wherein the program when running performs the method of application data processing according to any one of claims 1 to 12.

16. An electronic device, comprising:

a processor; and

a memory for storing executable instructions of the processor;

wherein the processor is configured to perform the method of application data processing of any of claims 1 to 12 via execution of the executable instructions.