CN117085336A - Game operation data deriving method, device, equipment and storage medium - Google Patents

Game operation data deriving method, device, equipment and storage medium Download PDF

Info

Publication number
CN117085336A
CN117085336A CN202310910051.7A CN202310910051A CN117085336A CN 117085336 A CN117085336 A CN 117085336A CN 202310910051 A CN202310910051 A CN 202310910051A CN 117085336 A CN117085336 A CN 117085336A
Authority
CN
China
Prior art keywords
operation data
data
game
batch
minimum
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202310910051.7A
Other languages
Chinese (zh)
Other versions
CN117085336B (en
Inventor
洪中桂
赖玮
周光
杨杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Yingfeng Network Technology Co ltd
Original Assignee
Guangzhou Yingfeng Network Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Guangzhou Yingfeng Network Technology Co ltd filed Critical Guangzhou Yingfeng Network Technology Co ltd
Priority to CN202310910051.7A priority Critical patent/CN117085336B/en
Priority claimed from CN202310910051.7A external-priority patent/CN117085336B/en
Publication of CN117085336A publication Critical patent/CN117085336A/en
Application granted granted Critical
Publication of CN117085336B publication Critical patent/CN117085336B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • A—HUMAN NECESSITIES
    • A63—SPORTS; GAMES; AMUSEMENTS
    • A63F—CARD, BOARD, OR ROULETTE GAMES; INDOOR GAMES USING SMALL MOVING PLAYING BODIES; VIDEO GAMES; GAMES NOT OTHERWISE PROVIDED FOR
    • A63F13/00—Video games, i.e. games using an electronically generated display having two or more dimensions
    • A63F13/70—Game security or game management aspects
    • A63F13/77—Game security or game management aspects involving data related to game devices or game servers, e.g. configuration data, software version or amount of memory

Abstract

The application discloses a method, a device, equipment and a storage medium for deriving game operation data, and relates to the technical field of computer games. The method comprises the following steps: parameters of target operation data to be exported are obtained, wherein the parameters comprise starting time, ending time, game names and export fields; inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time; acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire target operation data; and exporting the target operation data according to the export field. Through the technical means, the problem that the export mode of the game operation data in the prior art cannot meet the service requirement is solved, the labor cost is reduced, and the data acquisition efficiency is improved.

Description

Game operation data deriving method, device, equipment and storage medium
Technical Field
The present application relates to the field of computer games, and in particular, to a method, an apparatus, a device, and a storage medium for deriving game operation data.
Background
The game operation is a process of pushing a game into the market on a game platform, and the user can get the game from touching, knowing and going to an operation of solving the actual line through the operation of the game, and finally becomes a faithful player of the game. The work drive of the game operation is derived from game operation data, and the game operation needs to collect a large amount of data to summarize rules and changes, and an optimal game operation strategy is formulated according to the summarized rules and changes.
In the prior art, game operation data is directly queried and derived through a management background php (computer programming language) script of a game platform. However, in general, the background management system manages a plurality of games, which can generate a huge amount of game operation data, and as the demand for deriving appropriate data from the huge amount of game operation data according to operation demands increases, the derived data types are quite different, and if the game operation data are derived through the php script, the game operation data are each time required to be rewritten and realized, and the consumed labor cost is high, so that the current service demand cannot be satisfied in the manner of deriving the game operation data through the php script.
Disclosure of Invention
The application provides a game operation data export method, a device, equipment and a storage medium, which can dynamically adjust parameters according to different operation requirements to rapidly export game operation data meeting the operation requirements without re-writing script codes, solve the problem that the export mode of the game operation data in the prior art cannot meet the service requirements, reduce the labor cost and improve the data export efficiency.
In a first aspect, the present application provides a game operation data deriving method, including:
acquiring parameters of target operation data to be exported, wherein the parameters comprise starting time, ending time, game name and export field;
inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time;
acquiring the plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire the target operation data;
and exporting the target operation data according to the export field.
In a second aspect, the present application provides a game operation data deriving apparatus comprising:
a parameter acquisition module configured to acquire parameters of target operation data to be exported, the parameters including a start time, an end time, a game name, and an export field;
the identification determining module is configured to query a minimum data identification and a maximum data identification of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time;
the data screening module is configured to acquire the plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and perform parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire the target operation data;
a data export module configured to export the target operational data according to the export field.
In a third aspect, the present application provides a game operation data deriving apparatus comprising:
one or more processors;
a memory storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the game play data derivation method as described in the first aspect.
In a fourth aspect, the present application provides a storage medium containing computer executable instructions which, when executed by a computer processor, are used to perform the game play data derivation method as described in the first aspect.
In the application, parameters of target operation data to be exported are obtained, wherein the parameters comprise a starting time, an ending time, a game name and an exported field; inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time; acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire target operation data; and exporting the target operation data according to the export field. Through the technical means, the user can configure parameters in the management background according to the operation requirements, the management background can dynamically adjust the parameters according to different operation requirements so as to quickly derive game operation data meeting the operation requirements, script codes do not need to be rewritten, and labor cost is reduced. The management background acquires the first operation data in batches, and carries out parallel screening on the first operation data acquired in batches through Golang's multiple cooperative passes to obtain target operation data.
Drawings
FIG. 1 is a flow chart of a method for deriving game operation data provided by an embodiment of the present application;
FIG. 2 is a flow chart of batch acquisition of first operational data provided by an embodiment of the present application;
FIG. 3 is a flowchart of acquiring first operation data of a first lot according to an embodiment of the present application;
FIG. 4 is a schematic flow chart of Golang multi-pass parallel screening data according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a game operation data deriving device according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a game operation data deriving device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the following detailed description of specific embodiments of the present application is given with reference to the accompanying drawings. It is to be understood that the specific embodiments described herein are merely illustrative of the application and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the matters related to the present application are shown in the accompanying drawings. Before discussing exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart depicts operations (or steps) as a sequential process, many of the operations can be performed in parallel, concurrently, or at the same time. Furthermore, the order of the operations may be rearranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figures. The processes may correspond to methods, functions, procedures, subroutines, and the like.
The terms first, second and the like in the description and in the claims, 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 may be interchanged, as appropriate, such that embodiments of the present application may be implemented in sequences other than those illustrated or described herein, and that the objects identified by "first," "second," etc. are generally of a type, and are not limited to the number of objects, such as the first object may be one or more. Furthermore, in the description and claims, "and/or" means at least one of the connected objects, and the character "/", generally means that the associated object is an "or" relationship.
In a more common existing implementation, game operational data is queried and derived by managing a background php (computer programming language) script. However, the general management platform manages a plurality of games, which can generate a huge amount of game operation data, and as the demand for deriving appropriate data from the huge amount of game operation data according to operation demands increases, the derived data types are quite different, if the game operation data are derived through the php script, the game operation data need to be rewritten each time, and the consumed labor cost is high, so that the current service demand cannot be met in the manner of deriving the game operation data through the php script.
In order to solve the above-mentioned problems, the present embodiment provides a method for deriving game operation data, which can dynamically adjust parameters according to different operation requirements to rapidly derive game operation data meeting the operation requirements.
The game operation data deriving method provided in this embodiment may be executed by a game operation data deriving device, where the game operation data deriving device may be implemented in software and/or hardware, and the game operation data deriving device may be configured by two or more physical entities or may be configured by one physical entity. For example, the game operation data derivation device may be a management background or a computer running the management background.
The game operation data deriving device is provided with at least one type of operating system, wherein the operating system comprises, but is not limited to, an android system, a Linux system and a Windows system. The game operation data deriving device may install at least one application program based on the operating system, and the application program may be an application program carried by the operating system, or may be an application program downloaded from a third party device or a server. In this embodiment, the game operation data derivation device has at least an application program that can execute the game operation data derivation method.
For ease of understanding, the present embodiment will be described taking the management background as an example of a main body that executes the game operation data derivation method.
Fig. 1 is a flowchart of a game operation data deriving method according to an embodiment of the present application. Referring to fig. 1, the game operation data deriving method specifically includes:
s110, acquiring parameters of target operation data to be exported, wherein the parameters comprise a start time, an end time, a game name and an export field.
The target operation data refers to game operation data which is required to be acquired by an operator and meets operation requirements. The operator opens a window for configuring the parameters of the target operation data in the management background, inputs or selects the parameters of the target operation data in the window, and the management background obtains the parameters of the target operation data according to the input operation or the selection operation of the operator.
The starting time and the ending time in the parameters of the target operation data are used for acquiring the game operation data generated in the corresponding time period, the game name in the parameters of the target operation data is used for acquiring the game operation data of the corresponding game, and the derived field is used for representing the data attribute of the target operation data and is used for acquiring the operation data conforming to the corresponding attribute. The data attribute of the game operation data is related to the service type of the game operation data, for example, the data attribute of the game operation data related to the recharging service comprises a player identifier, a district service where the player is located, a recharging amount, a recharging result, a placing time, a payment time, a recharging order and the like; the data attributes of the game operation data related to the online time service include player identification, player's presence, online time point, offline time point, online activity, etc. Operators can input or select the export field of the target operation data as the data attribute of the corresponding service type according to the service requirement.
The present embodiment will be described taking as an example the game operation data that the operator needs to derive all of the 11-month game a regarding the recharge service. The starting time and the ending time of the operator in the management background configuration target operation data are respectively 11 months, 1 day and 11 months, 30 days, the game name of the configuration target operation data is game A, and the export field of the configuration target operation data is player identification, player's local service, recharging amount, recharging result, ordering time, payment time, recharging order and the like. After the operator completes the parameter configuration of the target operation data, the management background acquires the starting time, the ending time, the game name and the derived field of the target operation data.
S120, inquiring the minimum data identification and the maximum data identification of the first operation data generated in the corresponding time period according to the starting time and the ending time.
Wherein the first operation data refers to game operation data of each game generated by the game platform in a starting time and an ending time. The different game operation data correspond to different data identifications, the data identifications of the game operation data are related to the generation sequence of the game operation data, the game platform increases the data identifications of the game operation data according to the generation sequence of the game operation data, for example, the data identifications of the game operation data generated at a certain moment are 10, and the data identifications of the game operation data generated at the next moment are 11.
The management platform inquires the data identification of the game operation data generated at the first moment of the starting time, determines the data identification as the minimum data identification of a plurality of first operation data, inquires the data identification of the game operation data generated at the last moment of the ending time, and determines the data identification as the maximum data identification of the plurality of first operation data. For example, at the start time and the end time of 11 months 1 day and 11 months 30 days, respectively, the data identification of the game operation data generated earliest on the day of 11 months 1 is taken as the minimum data identification of the plurality of first operation data generated between 11 months 1 day and 11 months 30 days, and the data identification of the game operation data generated latest on the day of 11 months 30 days is taken as the maximum data identification of the plurality of first operation data generated between 11 months 1 day and 11 months 30 days.
S130, acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple passes of the game name and Golang to acquire target operation data.
Where Golang (Golanguage) is a programming language, the coroutine (or user-level thread) in Golang is a thread that is emulated at the application layer. Golang's grammar and runtime have built-in support for multiple coprocessors directly, through which data can be processed in parallel. In order to improve the data screening efficiency, the acquired multiple first operation data are screened in parallel based on the game names through multiple passes of Golang to obtain the target operation data of the corresponding game. Because the data amount of the first operation data generated in the time period corresponding to the starting time and the ending time is more, the screening of a large amount of data at one time is easy to cause data blocking and affects the data screening efficiency, the embodiment provides that the first operation data in the corresponding time period is obtained in batches, and the parallel screening is performed through the first operation data obtained in batches before the multi-protocol Cheng Duidang, so that the data blocking is avoided, and the data screening efficiency is improved.
In an embodiment, when the first operation data is obtained in batches, the total number of the first operation data generated in the time period corresponding to the start time and the end time may be determined based on the minimum data identifier and the maximum data identifier of the plurality of first operation data, and the number of the first operation data obtained in each batch may be uniformly distributed according to the total number. And determining the minimum data identifier and the maximum data identifier of the first operation data of each batch according to the minimum data identifier, the maximum data identifier and the number of the first operation data acquired by each batch, and sequentially inquiring the first operation data of the corresponding batch according to the minimum data identifier and the maximum data identifier of the first operation data of the current batch. For example, the total number of the plurality of first operation data generated between 11 months 1 day and 11 months 30 days is 12200, the first operation data is obtained by dividing the first operation data into 20 batches, and 610 first operation data are obtained for each batch. The minimum data identifier and the maximum data identifier of the plurality of first operation data generated between 11 months 1 and 11 months 30 are 10051 and 22250 respectively, then the minimum data identifier and the maximum data identifier of the first operation data of the first batch are 10051 and 10660 respectively, the minimum data identifier and the maximum data identifier of the first operation data of the second batch are 10661 and 11270 respectively, and so on, the minimum data identifier and the maximum data identifier of the first operation data of the rest batches can be obtained.
In another embodiment, fig. 2 is a flowchart of batch acquisition of first operation data according to an embodiment of the present application. As shown in fig. 2, the step of acquiring the first operation data in batches based on the preset number specifically includes S1301-S1303:
s1301, based on the minimum data identifiers of a plurality of first operation data, acquiring first operation data with gradually increased data identifiers of a preset number as first operation data of a first batch, and determining the minimum data identifier of first operation data of a next batch according to the maximum data identifier of the first operation data of the first batch.
By way of example, the preset number may be understood as the maximum number of first operational data acquired per batch. Assuming that the preset number is 1000, the minimum data identifier and the maximum data identifier of a plurality of first operation data generated between 11 months 1 day and 11 months 30 days are 10051 and 22250 respectively, inquiring the first operation data corresponding to the data identifier 10051, adding 1 to 10051 to obtain 10052, inquiring the first operation data corresponding to the data identifier 10052, and so on, until 1000 first operation data are inquired, suspending inquiry and taking the first operation data which are inquired up to 1000 as the first operation data of the first batch. Whereas the maximum data identification of the first operational data of the first lot is 11050, then the minimum data identification of the first operational data of the second lot may be determined to be 11051.
In this embodiment, fig. 3 is a flowchart of acquiring first operation data of a first lot according to an embodiment of the present application. As shown in fig. 3, the step of acquiring the first operation data of the first lot specifically includes S13011-S13032:
s13011, inquiring corresponding first operation data based on the minimum data identification of the plurality of first operation data through the first coroutine, and writing the inquired first operation data into the channel.
S13032, gradually increasing the minimum data identification of the plurality of first operation data to inquire the corresponding first operation data, and writing the inquired first operation data into the channel until the preset number of first operation data are inquired in the current batch.
The first coroutine is a Golang coroutine for inquiring operation data, and a channel (channel) is used for carrying out Golang coroutine communication. Illustratively, the management background queries, through a first protocol, first operation data corresponding to the data identifier 10051 in a database corresponding to the game operation data stored in the game platform, and writes the queried first operation data into the channel. And adding 1 to 10051 to obtain 10052, inquiring first operation data corresponding to the data identifier 10052 in the database through a first cooperative program, writing the inquired first operation data into the channel, and pushing the same, and suspending the inquiry after the 1000 th first operation data is inquired in the first batch by the first cooperative program and the first operation data is written into the channel.
After the first operation data of the first batch is written into the channel through the first cooperation process, screening processing can be performed on the first operation data of the first batch through the multiple cooperation processes. By way of example, the first operation data of the first batch in the plurality of second cooperative parallel reading channels are screened out in parallel according to the game names, and the target operation data in the first operation data of the first batch is screened out. The second coroutine is the Golang coroutine used for screening out the target operation data. Fig. 4 is a schematic flow chart of Golang's multi-pass parallel screening data according to an embodiment of the present application. As shown in fig. 4, the first co-program queries the first operation data of the first batch from the database, writes the first operation data of the first batch into the channel, and the plurality of second co-programs read the first operation data of the first batch from the channel and screen the first operation data of the first batch according to the game name to obtain the target operation data.
S1302, under the condition that the number of the first operation data between the minimum data identification of the first operation data of the next batch and the maximum data identification of the plurality of first operation data is larger than or equal to the preset number, based on the minimum data identification of the first operation data of the next batch, acquiring the first operation data with the gradually increased preset number of data identifications as the first operation data of the corresponding batch.
In this embodiment, when the second cooperative distance finishes reading the first operation data of the first batch in the channel, the first operation data of the next batch is queried through the first cooperative distance, and the queried first operation data is written into the channel. For example, when the first operation data of the second batch is passed through the first protocol Cheng Chaxun, the first operation data corresponding to the minimum data identifier 11051 corresponding to the second batch is queried in the database through the first protocol, and the first operation data is written into the channel. Adding 1 to 11051 to 11052 to obtain first operation data corresponding to the query data identifier 11052, and so on until the 1000 th first operation data is queried, suspending the query and taking the 1000 first operation data queried previously as first operation data of a second batch. While the maximum data identification of the first operational data of the second lot is 12050, then the minimum data identification of the first operational data of the third lot may be determined to be 13051.
After the first operation data of the next batch is written into the channel through the first cooperation, the first operation data of the next batch in the channel is read in parallel through a plurality of second cooperation, and the first operation data of the next batch is screened according to the game name, so that the target operation data is obtained. Similarly, referring to fig. 4, the first co-program queries the database for the first operation data of the second lot, writes the first operation data of the second lot into the channel, and the plurality of second co-programs read the first operation data of the second lot from the channel and screen the first operation data of the second lot according to the game name to obtain the target operation data.
S1303, when the number of the first operation data between the minimum data identifier of the first operation data of the next batch and the maximum data identifiers of the plurality of first operation data is smaller than the preset number, acquiring the first operation data between the minimum data identifier of the first operation data of the next batch and the maximum data identifiers of the plurality of first operation data as the first operation data of the corresponding batch.
For example, when the minimum data identifier of the thirteenth lot of the first operation data is 22051 and the first lot of the first operation data passes through the first protocol Cheng Chaxun, the first operation data corresponding to the data identifier 22051 is queried in the database through the first protocol, and the first operation data is written into the channel. Adding 1 to 22051 to obtain 22052, querying first operation data corresponding to the data identifier 22052, and so on until the first operation data corresponding to the data identifier 22250 is queried and written into the channel, and stopping querying.
After the first operation data of the thirteenth batch is written into the channel through the first cooperative distance, the first operation data of the thirteenth batch in the channel are read in parallel through a plurality of second cooperative distances, and target operation data in the first operation data of the thirteenth batch are screened out in parallel according to the game name. When a certain second cooperative distance finishes reading the first operation data of the thirteenth batch in the channel, notifying other second cooperative distances to stop reading the data in the channel through the channel, and stopping screening after the corresponding first operation data are processed.
And S140, exporting the target operation data according to the export field.
For example, after the target operation data is obtained, the data attribute of the target operation data is obtained according to the export field, and the data attribute, the generation time and the game name corresponding to the target operation data are exported to the operator for viewing.
In an embodiment, the target operation data is exported to the operation data table based on the anti-concurrency lock mode. It can be appreciated that in a multi-pass environment, when multiple passes access the same shared resource, a data contention problem is likely to occur, resulting in unexpected errors in the program, so that the security and correctness of the data can be ensured by the lock. In this embodiment, the operation data table is provided with cells corresponding to data attributes corresponding to each export field of the target operation data, so that the data attributes of the export fields corresponding to the target operation data can be exported to the cells of the operation data table to generate the operation data table, so that operators can conveniently view the target operation data. In addition, the operation data table is provided with a data identification of the target operation data, a generation time, and a cell of the game name. Table 1 is a schematic diagram of an operation data table provided in an embodiment of the present application.
TABLE 1
Data identification Time of generation Game name Player identification Game area suit Amount of money charged
10661 11 months and 10 days Game A X1 No. 1 50
10662 11 months and 10 days Game A X2 No. 3 120
10663 11 months and 10 days Game A X3 No. 5 20
As shown in Table 1, the data identifier, the generation time, the game name and the data attribute corresponding to the derived field of one target operation data are arranged in the same row, so that operators can conveniently and quickly inquire the data identifier, the generation time, the game name and the data attribute of the target operation data. The operation data table shows the game operation data of all the 11-month game a of the game a regarding the recharging service, satisfying the requirement that the operator wants to derive the game operation data of all the 11-month game a regarding the recharging service.
In summary, according to the game operation data export method provided by the embodiment of the application, parameters of target operation data to be exported are obtained, wherein the parameters comprise starting time, ending time, game name and export field; inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time; acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire target operation data; and exporting the target operation data according to the export field. Through the technical means, the user can configure parameters in the management background according to the operation requirements, the management background can dynamically adjust the parameters according to different operation requirements so as to quickly derive game operation data meeting the operation requirements, script codes do not need to be rewritten, and labor cost is reduced. The management background acquires the first operation data in batches, and carries out parallel screening on the first operation data acquired in batches through Golang's multiple cooperative passes to obtain target operation data.
On the basis of the above embodiments, fig. 5 is a schematic structural diagram of a game operation data deriving device according to an embodiment of the present application. Referring to fig. 5, the game operation data deriving device provided in this embodiment specifically includes: a parameter acquisition module 21, an identification determination module 22, a data screening module 23 and a data derivation module 24.
Wherein, the parameter obtaining module 21 is configured to obtain parameters of the target operation data to be exported, the parameters include a start time, an end time, a game name and an export field;
an identification determining module 22 configured to query a minimum data identification and a maximum data identification of the plurality of first operation data generated for the corresponding time period according to the start time and the end time;
the data screening module 23 is configured to obtain a plurality of first operation data in batches based on the minimum data identifier and the maximum data identifier of the plurality of first operation data, and perform parallel screening on the first operation data obtained in each batch through multiple cooperative passes of the game name and Golang to obtain target operation data;
the data export module 24 is configured to export the target operational data based on the export field.
On the basis of the above embodiment, the data screening module 23 includes: the first batch acquisition unit is configured to acquire first operation data with gradually increased data identifiers of a preset number as first operation data of a first batch based on the minimum data identifiers of a plurality of first operation data, and determine the minimum data identifier of first operation data of a next batch according to the maximum data identifier of the first operation data of the first batch; the second batch obtaining unit is configured to obtain first operation data with gradually increased data identifiers of the preset number as first operation data of a corresponding batch based on the minimum data identifiers of the first operation data of the next batch when the first operation data number between the minimum data identifiers of the first operation data of the next batch and the maximum data identifiers of the plurality of first operation data is larger than or equal to the preset number; the third batch obtaining unit is configured to obtain, as the first operation data of the corresponding batch, the first operation data between the minimum data identifier of the first operation data of the next batch and the maximum data identifier of the plurality of first operation data, if the first operation data amount between the minimum data identifier of the first operation data of the next batch and the maximum data identifier of the plurality of first operation data is smaller than the preset amount.
On the basis of the above embodiment, the first batch acquisition unit includes: the first query subunit is configured to query corresponding first operation data based on the minimum data identification of the plurality of first operation data through the first coroutine, and write the queried first operation data into the channel; the second query subunit is configured to gradually increase the minimum data identifier of the plurality of first operation data to query the corresponding first operation data, and write the queried first operation data into the channel until the current batch queries the preset number of first operation data.
On the basis of the above embodiment, the data screening module 23 includes: the first data screening unit is configured to concurrently screen target operation data in the first operation data of the first batch according to the game names by concurrently reading the first operation data of the first batch in the channels through a plurality of second coroutines.
On the basis of the above embodiment, the data screening module 23 further includes: a fourth batch acquisition unit configured to search, after the target operation data in the first operation data of the first batch is screened in parallel according to the game name, for the first operation data of the next batch through the first coroutine under the condition that the first operation data of the first batch in the channel is read, and write the searched first operation data into the channel; the second data screening unit is configured to read the first operation data of the next batch in the channels in parallel through a plurality of second coroutines, and screen the first operation data of the next batch according to the game name to obtain target operation data.
On the basis of the above embodiment, the data deriving module 24 includes: and the table export unit is configured to export the target operation data into the operation data table based on the anti-concurrency locking mode.
On the basis of the above embodiment, the table deriving unit includes: and the table export subunit is configured to export the data attribute of the export field corresponding to the target operation data into the cells of the operation data table to generate the operation data table.
In the above, the game operation data deriving device provided by the embodiment of the present application obtains the parameters of the target operation data to be derived, where the parameters include a start time, an end time, a game name and a derived field; inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time; acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire target operation data; and exporting the target operation data according to the export field. Through the technical means, the user can configure parameters in the management background according to the operation requirements, the management background can dynamically adjust the parameters according to different operation requirements so as to quickly derive game operation data meeting the operation requirements, script codes do not need to be rewritten, and labor cost is reduced. The management background acquires the first operation data in batches, and carries out parallel screening on the first operation data acquired in batches through Golang's multiple cooperative passes to obtain target operation data.
The game operation data deriving device provided by the embodiment of the application can be used for executing the game operation data deriving method provided by the embodiment, and has corresponding functions and beneficial effects.
Fig. 6 is a schematic structural diagram of a game operation data deriving device according to an embodiment of the present application, and referring to fig. 6, the game operation data deriving device includes: a processor 31, a memory 32, a communication device 33, an input device 34 and an output device 35. The number of processors 31 in the game operation data derivation device may be one or more, and the number of memories 32 in the game operation data derivation device may be one or more. The processor 31, the memory 32, the communication means 33, the input means 34 and the output means 35 of the game play data deriving device may be connected by a bus or other means.
The memory 32 is a computer-readable storage medium, and may be used to store software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the game operation data derivation method according to any embodiment of the present application (for example, the parameter acquisition module 21, the identification determination module 22, the data filtering module 23, and the data derivation module 24 in the game operation data derivation device). The memory 32 may mainly include a storage program area that may store an operating system, at least one application program required for functions, and a storage data area; the storage data area may store data created according to the use of the device, etc. In addition, memory 32 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some examples, the memory may further include memory remotely located with respect to the processor, the remote memory being connectable to the device through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The communication means 33 are for data transmission.
The processor 31 executes various functional applications of the apparatus and data processing by executing software programs, instructions and modules stored in the memory 32, i.e., implements the above-described game operation data deriving method.
The input means 34 may be used to receive entered numeric or character information and to generate key signal inputs related to user settings and function control of the device. The output means 35 may comprise a display device such as a display screen.
The game operation data deriving device provided by the embodiment can be used for executing the game operation data deriving method provided by the embodiment, and has corresponding functions and beneficial effects.
The embodiments of the present application also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are for performing a game operation data derivation method comprising: parameters of target operation data to be exported are obtained, wherein the parameters comprise starting time, ending time, game names and export fields; inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time; acquiring a plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire target operation data; and exporting the target operation data according to the export field.
Storage media-any of various types of memory devices or storage devices. The term "storage medium" is intended to include: mounting media such as CD-ROM, floppy disk or tape devices; computer system memory or random access memory such as DRAM, DDR RAM, SRAM, EDO RAM, lanbas (Rambus) RAM, etc.; nonvolatile memory such as flash memory, magnetic media (e.g., hard disk or optical storage); registers or other similar types of memory elements, etc. The storage medium may also include other types of memory or combinations thereof. In addition, the storage medium may be located in a first computer system in which the program is executed, or may be located in a second, different computer system connected to the first computer system through a network such as the internet. The second computer system may provide program instructions to the first computer for execution. The term "storage medium" may include two or more storage media residing in different locations (e.g., in different computer systems connected by a network). The storage medium may store program instructions (e.g., embodied as a computer program) executable by one or more processors.
Of course, the storage medium containing the computer executable instructions provided in the embodiments of the present application is not limited to the above-mentioned game operation data export method, and may also perform the relevant operations in the game operation data export method provided in any embodiment of the present application.
The game operation data deriving device, the storage medium and the game operation data deriving apparatus provided in the above embodiments may perform the game operation data deriving method provided in any embodiment of the present application, and technical details not described in detail in the above embodiments may be referred to the game operation data deriving method provided in any embodiment of the present application.
The foregoing description is only of the preferred embodiments of the application and the technical principles employed. The present application is not limited to the specific embodiments described herein, but is capable of numerous modifications, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the application. Therefore, while the application has been described in connection with the above embodiments, the application is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit of the application, the scope of which is set forth in the following claims.

Claims (10)

1. A game operation data deriving method, comprising:
acquiring parameters of target operation data to be exported, wherein the parameters comprise starting time, ending time, game name and export field;
inquiring minimum data identifiers and maximum data identifiers of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time;
acquiring the plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and carrying out parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire the target operation data;
and exporting the target operation data according to the export field.
2. The game operation data deriving method according to claim 1, wherein the batch acquisition of the plurality of first operation data based on a minimum data identifier and a maximum data identifier of the plurality of first operation data comprises:
based on the minimum data identifiers of the plurality of first operation data, acquiring first operation data with gradually increased data identifiers of a preset number as first operation data of a first batch, and determining the minimum data identifier of first operation data of a next batch according to the maximum data identifier of the first operation data of the first batch;
acquiring first operation data with gradually increased data identifications of a preset number as first operation data of a corresponding batch based on the minimum data identifications of the first operation data of the next batch under the condition that the first operation data number between the minimum data identifications of the first operation data of the next batch and the maximum data identifications of the first operation data is larger than or equal to the preset number;
and under the condition that the first operation data quantity between the minimum data identifier of the first operation data of the next batch and the maximum data identifiers of the first operation data is smaller than the preset quantity, acquiring the first operation data between the minimum data identifier of the first operation data of the next batch and the maximum data identifiers of the first operation data as the first operation data of the corresponding batch.
3. The game operation data deriving method according to claim 2, wherein the obtaining, based on the smallest data identifier of the plurality of first operation data, first operation data with a preset number of progressively larger data identifiers as the first operation data of the first lot includes:
inquiring corresponding first operation data through the minimum data identification of the plurality of first operation data by a first protocol Cheng Jiyu, and writing the inquired first operation data into a channel;
gradually increasing the minimum data identification of the plurality of first operation data to inquire the corresponding first operation data, and writing the inquired first operation data into the channel until the preset number of first operation data are inquired in the current batch.
4. The game operation data deriving method according to claim 3, wherein the parallel screening of the first operation data obtained in each batch through the multiple cooperative passes of the game name and Golang to obtain the target operation data includes:
and reading first operation data of the first batch in the channel in parallel through a plurality of second coroutines, and screening out the target operation data in the first operation data of the first batch in parallel according to the game names.
5. The game operation data deriving method according to claim 4, further comprising, after the parallel screening of the target operation data in the first operation data of the first lot according to the game name:
under the condition that the first operation data of the first batch in the channel is read, inquiring the first operation data of the next batch through the first coroutine, and writing the inquired first operation data into the channel;
and reading the first operation data of the next batch in the channel in parallel through a plurality of second coroutines, and screening the first operation data of the next batch according to the game name to obtain the target operation data.
6. The game operation data derivation method according to claim 1, characterized in that the deriving the target operation data from the derivation field includes:
and based on the anti-concurrency locking mode, the target operation data are exported to an operation data table.
7. The game operation data exporting method according to claim 6, wherein exporting the target operation data into an operation data table comprises:
and exporting the data attribute of the export field corresponding to the target operation data to a cell of an operation data table to generate the operation data table.
8. A game operation data deriving apparatus, comprising:
a parameter acquisition module configured to acquire parameters of target operation data to be exported, the parameters including a start time, an end time, a game name, and an export field;
the identification determining module is configured to query a minimum data identification and a maximum data identification of a plurality of first operation data generated in a corresponding time period according to the starting time and the ending time;
the data screening module is configured to acquire the plurality of first operation data in batches based on the minimum data identification and the maximum data identification of the plurality of first operation data, and perform parallel screening on the first operation data acquired in each batch through multiple cooperative passes of the game name and Golang to acquire the target operation data;
a data export module configured to export the target operational data according to the export field.
9. A game operation data deriving apparatus, comprising:
one or more processors;
a memory storing one or more programs that, when executed by the one or more processors, cause the one or more processors to implement the game play data derivation method of any one of claims 1-7.
10. A storage medium containing computer executable instructions which, when executed by a computer processor, are for performing the game play data derivation method of any one of claims 1-7.
CN202310910051.7A 2023-07-21 Game operation data deriving method, device, equipment and storage medium Active CN117085336B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310910051.7A CN117085336B (en) 2023-07-21 Game operation data deriving method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310910051.7A CN117085336B (en) 2023-07-21 Game operation data deriving method, device, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN117085336A true CN117085336A (en) 2023-11-21
CN117085336B CN117085336B (en) 2024-05-17

Family

ID=

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111151008A (en) * 2019-12-27 2020-05-15 深圳市其乐游戏科技有限公司 Game operation data verification method, device, configuration background and medium
CN112632163A (en) * 2020-12-18 2021-04-09 平安普惠企业管理有限公司 Big data report exporting method and related equipment
CN114259725A (en) * 2021-12-24 2022-04-01 苏州紫焰网络科技有限公司 Method, device, equipment and storage medium for issuing operation activities
CN114661811A (en) * 2022-03-07 2022-06-24 深圳市欢太数字科技有限公司 Data display method and device, electronic equipment and storage medium
US20230032554A1 (en) * 2020-08-28 2023-02-02 Tencent Technology (Shenzhen) Company Limited Data processing method and apparatus, and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111151008A (en) * 2019-12-27 2020-05-15 深圳市其乐游戏科技有限公司 Game operation data verification method, device, configuration background and medium
US20230032554A1 (en) * 2020-08-28 2023-02-02 Tencent Technology (Shenzhen) Company Limited Data processing method and apparatus, and storage medium
CN112632163A (en) * 2020-12-18 2021-04-09 平安普惠企业管理有限公司 Big data report exporting method and related equipment
CN114259725A (en) * 2021-12-24 2022-04-01 苏州紫焰网络科技有限公司 Method, device, equipment and storage medium for issuing operation activities
CN114661811A (en) * 2022-03-07 2022-06-24 深圳市欢太数字科技有限公司 Data display method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
US10152500B2 (en) Read mostly instances
CN111240763A (en) Configuration updating method, device, equipment and storage medium
CN103294479A (en) Distribution type transaction processing method and system
CN109857723B (en) Dynamic data migration method based on expandable database cluster and related equipment
CN109299101B (en) Data retrieval method, device, server and storage medium
CN112612523A (en) Embedded equipment driving system and method
US20190138633A1 (en) System and method for committing and rolling back database requests
CN111385370A (en) ID allocation method, device, storage medium and ID allocation system
CN106874343B (en) Data deletion method and system for time sequence database
CN112968793B (en) Equipment upgrading method, device, equipment and storage medium based on Internet of things
CN117085336B (en) Game operation data deriving method, device, equipment and storage medium
CN108280134B (en) Data circulation system and method based on account limit control, storage medium and terminal
CN117085336A (en) Game operation data deriving method, device, equipment and storage medium
CN115984022A (en) Unified account checking method and device for distributed payment system
CN110781137A (en) Directory reading method and device for distributed system, server and storage medium
CN115114325A (en) Data query method and device, electronic equipment and storage medium
CN111400266A (en) Data processing method and system, and diagnosis processing method and device of operation event
CN114168595A (en) Data analysis method and device
CN114116908A (en) Data management method and device and electronic equipment
CN112445600A (en) Method and system for issuing offline data processing task
CN107239474B (en) Data recording method and device
CN112968792B (en) Method and device for controlling upgrading of equipment of Internet of things
US11947539B2 (en) Concurrency and cancellation in distributed asynchronous graph processing
CN111538492B (en) Method and device for calling policy implementation, electronic equipment and storage medium
CN112818059B (en) Information real-time synchronization method and device based on container release platform

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant