CN113094379B

CN113094379B - Anchored user data maintenance method, device, equipment and medium

Info

Publication number: CN113094379B
Application number: CN202110310439.4A
Authority: CN
Inventors: 胡玉彪; 金聪
Original assignee: Hangzhou Electronic Soul Network Technology Co Ltd
Current assignee: Hangzhou Electronic Soul Network Technology Co Ltd
Priority date: 2021-03-23
Filing date: 2021-03-23
Publication date: 2023-08-01
Anticipated expiration: 2041-03-23
Also published as: CN113094379A

Abstract

The invention discloses an anchor type user data maintenance method, an anchor type user data maintenance device, electronic equipment and a computer storage medium, relates to the technical field of data processing, and aims to achieve accurate gear returning of data. The method comprises the following steps: acquiring operation data and software and hardware environment data of each player in a game; carrying out real-time collaborative analysis on operation data and software and hardware environment data of each player, and judging whether players with negative game behaviors exist in a game pair; if the player with the negative game behavior exists, generating a corresponding analysis file according to the abnormal data of the player with the negative game behavior after the game is ended; and reporting the analysis file.

Description

Anchored user data maintenance method, device, equipment and medium

Technical Field

The present invention relates to the field of data processing technologies, and in particular, to an anchored user data maintenance method, apparatus, device, and medium.

Background

In the online operation process of game items, data errors are often caused by BUG or GM misoperation and the like, so that normal operation and player experience are seriously affected, and a backstop is necessary for the data errors. However, in the past data file returning mode, large-scale database file returning is generally performed, the influence range is large, normal users can be influenced, and even misoperation risks exist in the file returning process.

Therefore, how to realize accurate data return is a problem to be solved at present.

Disclosure of Invention

The embodiment of the invention provides an anchor type user data maintenance method, device, equipment and medium, which are used for at least realizing accurate gear returning of data.

In a first aspect, an embodiment of the present invention provides an anchored user data maintenance method, including the following steps:

recording SQL sentences successfully executed by each user;

establishing an index of the SQL sentence successfully executed by each user by taking the ID of each user as an index value;

receiving the ID of a target user, and inquiring the SQL statement successfully executed by the target user through the index according to the ID of the target user;

and carrying out data maintenance on the SQL sentences successfully executed by the target user according to the maintenance requirement.

In some embodiments, before recording the SQL statement that each user executed successfully, the method includes:

respectively executing database operations of all users through SQL sentences of all users;

judging whether the database operation of each user is successfully executed or not;

if the execution is successful, writing SQL sentences successfully executed by each user into a log system, and running execution success logic;

otherwise, execute failure logic.

In some embodiments, the recording the SQL statement that each user executed successfully includes:

acquiring SQL sentences successfully executed by each user from the log system;

and recording the SQL sentences successfully executed by each user into the SQL execution records of each user respectively.

In some embodiments, the establishing an index of the SQL statement that the users successfully execute with the ID of the users as an index value includes:

and establishing an index of the SQL execution record of each user by taking the ID of each user as an index value.

In some embodiments, the querying the target user through the index for the SQL statement that was executed successfully includes:

and acquiring the SQL statement successfully executed by the target user within the target time range.

In some embodiments, the performing data maintenance on the SQL statement that is successful for the target user includes:

and returning the SQL sentence successfully executed by the target user.

In some embodiments, the maintaining requirement is that the file is returned to a preset time point, and according to the maintaining requirement, performing data maintenance on the SQL statement that is successfully executed by the target user includes:

and returning the SQL sentence successfully executed by the target user to a preset time point.

In a second aspect, an embodiment of the present invention provides an anchored user data maintenance device, including:

the SQL sentence recording module is used for recording SQL sentences successfully executed by each user;

the index establishing module is used for establishing an index of the SQL statement successfully executed by each user by taking the ID of each user as an index value;

the SQL sentence backtracking module is used for receiving the ID of the target user, and inquiring the SQL sentence successfully executed by the target user through the index according to the ID of the target user;

and the data maintenance module is used for carrying out data maintenance on the SQL sentences successfully executed by the target user according to the maintenance requirement.

In a third aspect, an embodiment of the present invention provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the anchored user data maintenance method according to the first aspect described above when executing the computer program.

In a fourth aspect, embodiments of the present invention provide a computer readable storage medium having stored thereon a computer program which when executed by a processor implements the anchored user data maintenance method as described in the first aspect above.

Compared with the prior art, the embodiment of the invention provides an anchoring type user data maintenance method, device, equipment and medium, which can independently inquire and maintain SQL sentences executed by specific users by recording SQL sentences executed successfully by each user and establishing indexes of the SQL sentences executed successfully by each user based on the IDs of each user, thereby realizing accurate file returning of data and reducing maintenance cost; and will not affect the user data without maintenance, can reduce the risk of misoperation of the data,

the details of one or more embodiments of the invention are set forth in the accompanying drawings and the description below to provide a more thorough understanding of the other features, objects, and advantages of the invention.

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 specification, illustrate embodiments of the invention and together with the description serve to explain the invention. In the drawings:

FIG. 1 is a flow chart of an anchored user data maintenance method of the present invention;

FIG. 2 is a flow chart of recording SQL statements in an embodiment of the invention;

FIG. 3 is a flow chart of a data maintenance process in an embodiment of the invention;

FIG. 4 is a block diagram of an anchored user data maintenance device of an embodiment of the present invention;

fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

For the purpose of making the objects and technical solutions of the present application more apparent, the present invention will be described and illustrated below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments provided herein without inventive faculty, are intended to be within the scope of the present application.

It is apparent that the drawings in the following description are only some examples or embodiments of the present application, and it is possible for those of ordinary skill in the art to apply the present application to other similar situations according to these drawings without inventive effort. Moreover, it should be appreciated that while such a development effort might be complex and lengthy, it would nevertheless be a routine undertaking of design, fabrication, or manufacture for those of ordinary skill having the benefit of this disclosure, and thus should not be construed as having the benefit of this disclosure.

Reference in the specification to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. It is to be expressly and implicitly understood by those of ordinary skill in the art that the embodiments described herein can be combined with other embodiments without conflict.

Example 1

Based on the above principle, the present embodiment provides a method for maintaining anchored user data, and fig. 1 is a flowchart of the anchored user data maintenance method of the present invention.

As shown in fig. 1, the anchored user data maintenance method is applied to a game client, and comprises the following steps:

s101, recording SQL sentences successfully executed by each user;

in implementing the anchored user data maintenance method of the present embodiment, first, related functions of database operations are integrated into a separate service, for example, into a DBS, where the DBS refers to a computer system with a database and performs data management using database technology. Then, a separate log system (SQL log system) is added to the DBS for recording the executed SQL statements to anchor the data change of the user at each moment. Because the SQL statement that fails execution does not cause a change in the database data, the log system typically records an SQL statement that executed successfully.

If the anchored user data maintenance method of the present embodiment is applied to a game operation scenario, when a game player (user) performs related database operations, each operated SQL statement is recorded through a log system, that is, each user successfully performs the SQL statement.

S102, establishing indexes of SQL sentences successfully executed by the users by taking the IDs of the users as index values.

The SQL statements that each user (gamer) executed successfully are saved in a configured file directory, which in this embodiment is a file system located on the server's local resources. By taking the ID of each user as an index value, the index of the SQL sentence successfully executed by each user is established, so that the corresponding record can be quickly inquired from the server local resource file system through the index value, and the subsequent inquiry and acquisition of the SQL sentence successfully executed by each user are facilitated.

S103, receiving the ID of the target user, and inquiring the SQL statement successfully executed by the target user through indexes according to the ID of the target user.

In the online operation process of the game item, if data errors occur, the data of the relevant players can be maintained by only calling SQL sentences executed by the players with relevant problems in the file catalogue. Namely, the problem player is taken as a target user, and the target user (problem player) can inquire that the target user executes a successful SQL sentence for data maintenance through the index.

And S104, carrying out data maintenance on the SQL sentences successfully executed by the target user according to the maintenance requirement.

Different data errors correspond to different maintenance requirements, and based on the different maintenance requirements, different processing can be performed on SQL sentences successfully executed by the target user. In this embodiment, if the maintenance requirement is a data file return, then according to the maintenance requirement, a file return is performed on the SQL statement that is successfully executed by the target user, so as to implement data maintenance.

In other embodiments, if the maintenance requirement is to modify the SQL statement successfully executed by the target user and then re-execute the SQL statement, the modification is directly performed on the SQL statement successfully executed by the target user, so as to implement data maintenance.

According to the anchored user data maintenance method, by respectively recording the SQL sentences executed by each user, when problems occur, the SQL sentences of the target user can be independently acquired, and the SQL sentences of the target user are accurately returned, so that the accurate maintenance of data is realized.

Preferably, before recording the SQL statement that each user executed successfully, it includes:

otherwise, execute failure logic.

Preferably, recording the SQL statement that each user successfully executes, including:

acquiring SQL sentences successfully executed by each user from a log system;

As shown in fig. 2, in the daily operation scenario of the game, when the game server updates the player status, the SQL statement is executed in the DBS, the database is operated by executing the SQL (persisted to the database), that is, the MYSQL database in the graph is operated, if the database operation is executed successfully, the SQL statement that is executed successfully is written into the log system and fed back to the game server, the execution success logic is executed, and the SQL statement that is executed successfully is recorded into the SQL execution record of the player, and it is noted that the SQL execution record of the player is saved in the server local resource file system. If the database operation fails to be executed, the failure logic is fed back to the game server, and the game server executes the failure logic.

Preferably, the step of establishing an index of the SQL statement successfully executed by each user by taking the ID of each user as an index value comprises the following steps:

By establishing the index of the SQL execution record of each user in the server local resource file system, the SQL execution record of the relevant user can be quickly called from the file system based on the ID of the user, namely based on the index value, so that SQL sentences successfully executed by the relevant user can be quickly obtained.

Preferably, querying the target user through index for a successful SQL statement includes:

When the data error time is determined, the SQL statement which is successfully executed by the target user in the target time range (error time) can be directly acquired, so that more accurate data maintenance is realized.

It should be noted that the target user may be one user or a plurality of users. For example, when the anchored user data maintenance method of this embodiment is applied to a game daily operation scenario, as shown in fig. 3, if data anomalies occur between player a and player B, then the ID of player a and the ID of player B are used as index values, the SQL execution records of the two players are obtained in the server local resource file system through the index, and the data maintenance is performed on the data of player a and player B in the MYSQL database by modifying the data. And the maintenance of the player A and the player B can not affect the player C, so that the data maintenance of any problem player data can be realized at low risk and low cost on the premise of not affecting other players, namely, the data of any problem player is returned to any moment.

Preferably, performing data maintenance on the SQL statement successfully executed by the target user comprises:

and returning the SQL statement successfully executed by the target user.

And the data in the database is maintained by returning the SQL statement successfully executed by the target user.

Preferably, the maintaining requirement is that the return file is returned to a preset time point, and the data maintenance is performed on the SQL statement that is successfully executed by the target user according to the maintaining requirement, including:

Under the condition that the time point of data errors is determined, the maintenance requirement can be configured in advance to return to the preset time point, and the SQL statement (data) of the accurate return target user can be realized to the preset time point. The preset time point can be flexibly set to any time point as long as the preset time point is smaller than the time point of data error.

Example 2

The present embodiment provides an anchored user data maintenance device, which is used to implement the foregoing embodiments and the preferred embodiments, and is not described herein, and the terms "module," "unit," "subunit," and the like used below may be a combination of software and/or hardware that may implement a predetermined function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.

Fig. 4 is a block diagram of an anchored user data maintenance device according to an embodiment of the present invention, as shown in fig. 4, comprising:

the SQL sentence recording module 41 is used for recording SQL sentences successfully executed by each user;

the index establishing module 42 is configured to establish an index of the SQL statement that each user successfully executes, with the ID of each user as an index value;

the SQL sentence backtracking module 43 is configured to receive an ID of the target user, and query the target user for successful execution of the SQL sentence by indexing according to the ID of the target user;

the data maintenance module 44 is configured to perform data maintenance on the SQL statement that is successfully executed by the target user according to the maintenance requirement.

The above-described respective modules may be functional modules or program modules, and may be implemented by software or hardware. For modules implemented in hardware, the various modules described above may be located in the same processor; or the above modules may be located in different processors in any combination.

Example 3

Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 5, an electronic device is provided, and an internal structure diagram of the electronic device may be shown in fig. 5. The electronic device comprises a processor, a memory, an input device and an output device; wherein the number of processors in the electronic device may be one or more, one processor is exemplified in fig. 5; the processors, memory, input devices, and output devices in the electronic device may be coupled by a bus or other means, with bus coupling being illustrated in fig. 5.

The memory may include, as a computer readable storage medium, a high-speed random access memory, a nonvolatile memory, etc., and may be used to store an operating system, a software program, a computer executable program, and a database, such as program instructions/modules corresponding to the anchored user data maintenance method of embodiment 1 of the present invention, and may further include a memory, which may be used to provide an operating environment for the operating system and the computer program. In some examples, the memory may further include memory remotely located with respect to the processor, the remote memory being connectable to the electronic device through a network.

The processor, which is used to provide computing and control capabilities, may include a Central Processing Unit (CPU), or an application specific integrated circuit (Application Specific Integrated Circuit, abbreviated as ASIC), or may be configured to implement one or more integrated circuits of embodiments of the present application. The processor executes various functional applications of the electronic device and data processing, i.e., implements the anchored user data maintenance method of embodiment 1, by running computer-executable programs, software programs, instructions, and modules stored in the memory.

The output device of the electronic equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the electronic equipment can be a touch layer covered on the display screen, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

The electronic device may further comprise a network interface/communication interface for communicating with an external terminal via a network connection. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

It will be appreciated by those skilled in the art that the structure shown in fig. 5 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the electronic device to which the present application is applied, and that a particular electronic device may include more or fewer components than those shown, or may combine certain components, or have a different arrangement of components.

Those skilled in the art will appreciate that the implementation of all or part of the flow of the anchored user data maintenance method of embodiment 1 can be accomplished by way of a computer program stored on a non-volatile computer readable storage medium, which when executed, can comprise the flow of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.

Example 4

Embodiments of the present invention provide a storage medium containing computer executable instructions which, when executed by a computer processor, are for implementing an anchored user data maintenance method comprising:

recording SQL sentences successfully executed by each user;

the ID of each user is used as an index value, and the index of SQL sentences successfully executed by each user is established;

receiving the ID of the target user, and inquiring the SQL statement successfully executed by the target user through indexes according to the ID of the target user;

and according to the maintenance requirement, carrying out data maintenance on the SQL statement successfully executed by the target user.

Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present invention is not limited to the operations of the anchored user data maintenance method in the above embodiments, and may also perform the related operations in the anchored user data maintenance method provided in any embodiment of the present invention.

From the above description of embodiments, it will be clear to a person skilled in the art that the present invention may be implemented by means of software and necessary general purpose hardware, but of course also by means of hardware, although in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, etc., and include several instructions for causing an electronic device (which may be a mobile phone, a personal computer, a server, or a network device, etc.) to perform the anchored user data maintenance method according to the embodiments of the present invention.

It should be noted that, in the above embodiment of the anchored user data maintenance method, each unit and module included are only divided according to the functional logic, but not limited to the above division, so long as the corresponding functions can be implemented; in addition, the specific names of the functional units are also only for distinguishing from each other, and are not used to limit the protection scope of the present invention.

Unless defined otherwise, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this application belongs. Reference to "a," "an," "the," and similar terms herein do not denote a limitation of quantity, but rather denote the singular or plural. The terms "comprising," "including," "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, article, or apparatus that comprises a list of steps or modules (elements) is not limited to only those steps or elements but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus. The terms "connected," "coupled," and the like in this application are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. The term "plurality" as used herein refers to two or more. "and/or" describes an association relationship of an association object, meaning that there may be three relationships, e.g., "a and/or B" may mean: a exists alone, A and B exist together, and B exists alone. The character "/" generally indicates that the context-dependent object is an "or" relationship. The terms "first," "second," "third," and the like, as used herein, are merely distinguishing between similar objects and not representing a particular ordering of objects.

It will be apparent to those skilled in the art from this disclosure that various other changes and modifications can be made which are within the scope of the invention as defined in the appended claims.

Claims

1. An anchored user data maintenance method, comprising the steps of:

adding an independent log system in the DBS, and recording SQL sentences successfully executed by each user on the log system;

establishing an index of the SQL sentence successfully executed by each user by taking the ID of each user as an index value; storing the SQL sentences successfully executed by each user in a configured file directory, wherein the file directory is positioned in a server local resource file system; establishing an index of SQL sentences successfully executed by each user by taking the ID of each user as an index value, so that corresponding records are inquired from the server local resource file system through the index value;

according to the maintenance requirement, carrying out data maintenance on the SQL statement successfully executed by the target user; the step of performing data maintenance on the SQL statement successfully executed by the target user comprises the following steps: and returning the SQL sentence successfully executed by the target user.

2. The anchored user data maintenance method of claim 1, wherein said recording each user's execution of a successful SQL statement is preceded by:

otherwise, execute failure logic.

3. The anchored user data maintenance method of claim 2, wherein said recording each user's execution of a successful SQL statement comprises:

acquiring SQL sentences successfully executed by each user from the log system;

4. The anchored user data maintenance method of claim 3, wherein said establishing an index of said SQL statement that each user executed successfully with said ID of each user as an index value comprises:

5. The anchored user data maintenance method of claim 1, wherein said querying said target user through said index for a successful execution of an SQL statement comprises:

6. The method for maintaining data of an anchor user according to claim 1, wherein the maintaining requirement is that a file is returned to a preset time point, and performing data maintenance on the SQL statement successfully executed by the target user according to the maintaining requirement comprises:

7. An anchored user data maintenance device, comprising:

the SQL sentence recording module is used for adding an independent log system into the DBS and recording SQL sentences successfully executed by each user on the log system;

the index establishing module is used for establishing an index of the SQL statement successfully executed by each user by taking the ID of each user as an index value; storing the SQL sentences successfully executed by each user in a configured file directory, wherein the file directory is positioned in a server local resource file system; establishing an index of SQL sentences successfully executed by each user by taking the ID of each user as an index value, so that corresponding records are inquired from the server local resource file system through the index value;

the data maintenance module is configured to perform data maintenance on the SQL statement that is successfully executed by the target user according to a maintenance requirement, where the performing data maintenance on the SQL statement that is successfully executed by the target user includes: and returning the SQL sentence successfully executed by the target user.

8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the anchored user data maintenance method of any of claims 1 to 6 when the computer program is executed by the processor.

9. A computer readable storage medium having stored thereon a computer program, wherein the computer program when executed by a processor implements the anchored user data maintenance method of any of claims 1 to 6.