Data processing method, device and equipment

Abstract

The embodiment of the invention provides a data processing method, device and equipment. According to the invention, when the set time for monitoring the contract performance progress is reached, the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance indexes can be determined based on the to-be-processed data according to a plurality of preset monitoring dimensions and the contract performance index corresponding to each monitoring dimension; therefore, the contract performance index data corresponding to the to-be-delivered items are organized by taking the to-be-delivered items as indexes, and the contract performance index data of the same to-be-delivered item under different monitoring dimensions and different contract performance index items are stored in an associated manner. And only the data corresponding to the newly added index item needs to be added under the stored contract performance index data of each item to be delivered, so that the workload of newly adding the statistical index is reduced, and the processing efficiency of newly adding the statistical index item is improved.

Description

Technical Field

[0001] Embodiments of the present invention relate to the technical field of data processing. More specifically, embodiments of the present invention relate to a data processing method, apparatus, and device. Background Art

[0002] This section aims to provide background or context for the embodiments of the present invention described in the claims. The description herein is not admitted to be prior art merely by inclusion in this section.

[0003] In project management and contract management, the contract performance progress is a key indicator used to measure the progress of a project team or supplier in completing work within the contract period. Taking the contract performance progress monitoring of an audio playback software as an example, for the enterprise to which the audio playback software belongs, monitoring the contract performance progress can ensure the timely execution of the agreement with the copyright owner, avoid copyright disputes or content supply interruptions, and guarantee the continuity and stability of the platform content and user experience.

[0004] In the related art, a series of predefined statistical index items can be used to perform statistics on relevant data to obtain the index statistical data of the contract performance progress, helping users intuitively understand the contract performance progress.

[0005] In the above implementation process, if new statistical index items need to be added, the established data structure needs to be modified, resulting in a large workload for adding new statistical index items and thus a low processing efficiency for adding new statistical index items. Summary of the Invention

[0006] In this context, embodiments of the present invention are expected to provide a data processing method, apparatus, and device, aiming to reduce the workload of adding new index items and thus improve the processing efficiency of adding new index items.

[0007] In a first aspect of the embodiments of the present invention, a data processing method is provided. The method includes:

[0008] In response to reaching the set time for monitoring the contract performance progress, obtain the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time as the data to be processed;

[0009] Based on the data to be processed, determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items according to a plurality of pre-set monitoring dimensions and the contract performance index items corresponding to each monitoring dimension;

[0010] Organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators with each item to be delivered as an index, so as to associatively store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance indicators.

[0011] In one embodiment of the present invention, the organizing the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators with each item to be delivered as an index, so as to associatively store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance indicators includes:

[0012] Use each item to be delivered as a column index, and in a column storage manner, store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance indicators in the same storage location.

[0013] In one embodiment of the present invention, the method further includes:

[0014] Store the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators through the Clickhouse database.

[0015] In one embodiment of the present invention, the determining the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators based on the data to be processed according to a plurality of preset monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension includes:

[0016] Generate first index data of each item to be delivered under the contract performance indicator items corresponding to different monitoring dimensions based on the contract performance indicator items corresponding to each monitoring dimension;

[0017] For any contract performance indicator, generate first statistical index data of each item to be delivered under the contract performance indicator based on the first index data of each item to be delivered under the contract performance indicator items corresponding to different monitoring dimensions;

[0018] For any monitoring dimension, generate second statistical index data of each item to be delivered under the monitoring dimension based on the first index data of each item to be delivered under different contract performance indicator items corresponding to the monitoring dimension;

[0019] Determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items based on the first index data of each item to be delivered under the contract performance index corresponding to different monitoring dimensions, the first statistical index data of each item to be delivered under different contract performance index items, and the second statistical index data of each item to be delivered under different monitoring dimensions.

[0020] In one embodiment of the present invention, the step of, in response to reaching the set time for monitoring the contract performance progress, obtaining the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time as the data to be processed includes:

[0021] In response to reaching the target time, perform snapshot saving based on the actual delivery data of each item to be delivered in the target contract at the set time to obtain the offline data of the actual delivery data, so as to use the agreed delivery data and the actual delivery data of each delivery item as the data to be processed.

[0022] In one embodiment of the present invention, before the step of obtaining the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time as the data to be processed, the method further includes:

[0023] Based on the pre-set filtering information, screen out the target contract that meets the filtering information from the target database for storing multiple contracts; wherein, the filtering information is used to indicate at least one of the contract type, contract status, contract source, and contract signing mode of the target contract to be screened out.

[0024] In one embodiment of the present invention, the item to be delivered is audio data, and the multiple monitoring dimensions include word dimension, music dimension, recording dimension, singing dimension, and video dimension.

[0025] In one embodiment of the present invention, before the step of determining the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items based on the data to be processed according to the pre-set multiple monitoring dimensions and the contract performance index items corresponding to each monitoring dimension, the method further includes:

[0026] Provide a first function page, which is used to provide an editing function for monitoring dimensions and / or contract performance index items;

[0027] In response to the editing of monitoring dimensions and / or contract performance index items in the first function page, obtain the pre-set multiple monitoring dimensions and the contract performance index items corresponding to each monitoring dimension.

[0028] In one embodiment of the present invention, after organizing the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators with each item to be delivered as an index and associatively storing the contract performance index data of the same item to be delivered under different contract performance indicators, the method further includes:

[0029] Providing a second function page to display the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators in the second function page.

[0030] In one embodiment of the present invention, the second function page is further used to provide a query function for the contract performance index data;

[0031] The method further includes:

[0032] In response to a query operation of a target account in the second function page, obtaining a query request, where the query request is used to query the contract performance index data based on at least one of an item to be delivered, a monitoring dimension, and a contract performance indicator item.

[0033] In one embodiment of the present invention, after obtaining the query request in response to the query operation of the target account in the second function page, the method further includes:

[0034] Generating an SQL statement based on the query conditions carried in the query request;

[0035] Querying in the stored contract performance index data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data;

[0036] Displaying the target contract performance data in the second function page.

[0037] In one embodiment of the present invention, when generating the SQL statement, the method further includes:

[0038] Generating the SQL statement based on the query conditions carried in the query request and the account information of the target account.

[0039] In one embodiment of the present invention, the querying in the stored contract performance index data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data includes:

[0040] When the account information indicated by the SQL statement meets the query requirements, query in the stored contract performance index data based on the SQL statement to determine the target contract performance data that matches the query conditions from the stored contract performance data.

[0041] In the second aspect of the embodiments of the present invention, a data processing device is provided. The device includes:

[0042] An acquisition module, configured to, in response to reaching the set time for monitoring the contract performance progress, acquire the agreed delivery data of each to-be-delivered item in the target contract and the actual delivery data of each to-be-delivered item in the target contract at the set time as the data to be processed;

[0043] A determination module, configured to determine the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance index items based on the data to be processed according to a plurality of pre-set monitoring dimensions and the contract performance index items corresponding to each monitoring dimension;

[0044] A storage module, configured to organize the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance index items with each to-be-delivered item as an index, so as to perform associated storage on the contract performance index data of the same to-be-delivered item under different monitoring dimensions and different contract performance index items.

[0045] In the third aspect of the embodiments of the present invention, a computing device is provided. The computing device includes a memory, a processor, and a computer program stored on the memory and executable on the processor. Wherein, when the processor executes the program, it implements the operations performed by the data processing method described in the first aspect and any embodiment in the first aspect.

[0046] In the fourth aspect of the embodiments of the present invention, a computer-readable storage medium is provided. A program is stored on the computer-readable storage medium, and when the program is executed by a processor, it implements the operations performed by the data processing method described in the first aspect and any embodiment in the first aspect.

[0047] In the fifth aspect of the embodiments of the present invention, a computer program product is provided. The computer program product includes a computer program, and when the computer program is executed by a processor, it implements the operations performed by the data processing method described in the first aspect and any embodiment in the first aspect.

[0048] According to the data processing method of the embodiments of the present invention, when the set time for monitoring the contract performance progress is reached, the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time can be obtained as the data to be processed, so as to determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items based on the data to be processed according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension. Thus, the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items are organized with each item to be delivered as an index, so as to store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items in an associated manner, so that the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items can be stored together. Therefore, when a new index item is added subsequently, only the data corresponding to the new index item needs to be added under the contract performance index data already stored for each item to be delivered, without modifying the established data structure, thereby reducing the workload of adding statistical indexes and improving the processing efficiency when adding statistical index items. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] By referring to the drawings and reading the detailed description below, the above and other objects, features, and advantages of the exemplary embodiments of the present invention will become readily understood. In the drawings, several embodiments of the present invention are shown by way of example and not limitation, wherein:

[0050] Figure 1 Schematically shows a schematic diagram of an application scenario of a data processing method according to an embodiment of the present invention;

[0051] Figure 2 Schematically shows a flowchart of a data processing method according to an embodiment of the present invention;

[0052] Figure 3 Schematically shows a flowchart of a process for generating and submitting contract performance index data according to an embodiment of the present invention;

[0053] Figure 4 Schematically shows a flowchart of a process for querying contract performance index data according to an embodiment of the present invention;

[0054] Figure 5 Schematically shows a flowchart of a data processing method according to an embodiment of the present invention;

[0055] Figure 6 Schematically shows a block diagram of a data processing according to an embodiment of the present invention;

[0056] Figure 7 FIG. is a schematic diagram showing a computer-readable storage medium according to an embodiment of the present invention;

[0057] Figure 8 FIG. is a schematic diagram showing a computing device according to an embodiment of the present invention.

[0058] In the drawings, the same or corresponding reference numerals indicate the same or corresponding parts. Detailed Embodiments

[0059] The principles and spirit of the present invention will be described below with reference to several exemplary embodiments. It should be understood that these embodiments are provided only to enable those skilled in the art to better understand and then implement the present invention, and do not limit the scope of the present invention in any way. On the contrary, these embodiments are provided to make the present disclosure more thorough and complete, and to be able to convey the scope of the present disclosure fully to those skilled in the art.

[0060] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, apparatus, device, method, or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: completely hardware, completely software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0061] According to an embodiment of the present invention, a data processing method, apparatus, and device are provided.

[0062] In this article, it should be understood that the term "contract performance" refers to the execution of the obligations stipulated in the contract. The execution of any obligation stipulated in the contract is a contract performance act, including terms such as the copyright owner, the performing party, the performance method, the performance period, the supervision of contract performance, and the performance guarantee. The statistics of contract performance indicators help to clarify the rights and obligations of all parties in the contract, as well as the supervision and management during the performance process.

[0063] Taking the contract related to the audio playback software as an example, the term "performance materials" involved refers to the material information stipulated in the performance, including the agreed song information and authorization information, such as the agreed quantity of songs, delivery time, nature of authorization, authorization period, sound quality, payment situation, locking situation, etc. The term "song rights and interests" involved refers to the rights and interests scenarios in which the song can be played, including secondary creation such as being used for singing rewards, song lyrics, demos, etc. For example, it is used for live broadcasts, music festivals, offline performances, etc., or for scenarios such as covering the lyrics and music of songs, customizing songs, etc. The term "song rights" involved can be divided into three parts: lyrics rights, music rights, and recording rights. The rights of these three parts stipulate the specific authorization ratio and authorization time, which can be used to restrict the rights use of the song during the specified time period. The term "asset ledger" involved refers to the ledger that records the content of fixed assets, which can be used to record the information and price of purchased fixed assets, such as recording the purchase time, price, song rights, etc. of the song, and can also be used to collect the usage information of the song to track through the usage of various performance materials.

[0064] In addition, the quantity of any element in the attached drawings is for illustration rather than limitation, and any naming is only for distinction and does not have any limiting meaning.

[0065] Next, with reference to several representative embodiments of the present invention, the principles and spirit of the present invention will be explained in detail. Summary of the Invention

[0067] The inventor of the present invention found that in the related art, monitoring the progress of contract performance is a key link to ensure that all parties to the contract fulfill their responsibilities according to the agreed terms and time nodes. Timely tracking of the contract performance progress helps all parties to the contract discover potential problems in a timely manner and avoid disputes or losses caused by delays or non-compliance. By monitoring the contract performance progress, the contract performing party can ensure that the project is completed on time and with quality, enhance the trust of the cooperation party, and at the same time provide a basis for timely adjusting resources and coping with risks, thus ensuring the smooth realization of the contract objectives.

[0068] In related technologies, there are mainly four methods for quantifying the progress of contract performance: the percentage completion method, the physical measurement method, the output value measurement method, and the time progress method. Among them, the percentage completion method refers to comparing the completed workload (such as tasks, engineering quantities, etc.) with the total task volume according to the contract agreement, calculating the completed percentage. Optionally, the percentage can be measured based on indicators such as workload, quantity, time, and value. The physical measurement method can measure the performance progress by calculating the proportion of the delivered material information in all the material information to be delivered. The output value measurement method can calculate the performance progress according to the work scope and payment conditions agreed in the contract, based on the actually completed workload or the value generated. For example, it can be calculated according to the completed workload or the realized value, following a pre-determined price system, to convert the completed workload or the realized value into a percentage of the performance progress. The time progress method calculates the performance progress according to the schedule, construction period, or calculation progress agreed in the contract. For example, it can calculate the completed percentage based on the proportion between the actually completed time period and the total duration agreed in the contract.

[0069] It should be noted that regardless of which quantification method is adopted, it is necessary to give the contract performance index items to be calculated in the existing contract agreement text, and process the data according to the given contract performance index items to determine the contract performance progress under different index items. Taking the monitoring of the contract performance progress involved in an audio playback software as an example, the contract performance index items can include the agreed number of songs, delivery progress, locked content, song quality, etc., but are not limited to these.

[0070] Optionally, after calculating the performance progress data corresponding to each contract performance index item, it can be modified on the original table for storing contract data to write the calculated performance progress data into the table for subsequent viewing. In addition, when new data indicators need to be added, modifications also need to be made on the original table to achieve the addition of data indicators.

[0071] Among them, the name of the contract performance index item is not limited, such as "statistical index item", etc.

[0072] However, for the solution of adding new data indicators by modifying the original table, it is necessary to modify the established data structure to record the performance progress data, resulting in a large workload when adding new indicator items. Moreover, in related technologies, the T+1 method is often used to calculate the performance progress data. That is, for the material data generated within time T, the performance progress data corresponding to the material data generated within time T is calculated at time T+1. For data with deviations caused by input errors, manual intervention cannot be performed in a timely manner, resulting in inaccurate data updates. In addition, in related technologies, when displaying the performance progress data corresponding to each defined performance progress indicator item, the performance progress data corresponding to all performance progress indicator items are displayed together, with poor display flexibility, which brings great inconvenience to users' browsing.

[0073] In view of this, the present invention expects to provide a data processing method to reduce the workload when adding new indicator items and improve the processing efficiency when adding new indicator items; and, it can provide a manual intervention function during the calculation of performance progress data to monitor and intervene in the performance data with problems in a timely manner to ensure the accuracy of data updates; in addition, it provides a function to support flexible query and screening, making the data display more comprehensive.

[0074] After introducing the basic principle of the present invention, the various non-limiting embodiments of the present invention will be specifically introduced below.

[0075] Overview of Application Scenarios

[0076] First, refer to Figure 1 , Figure 1 which schematically shows a schematic diagram of the application scenario of a data processing method according to an embodiment of the present invention. As Figure 1 shown, the data processing provided by the embodiments of the present invention can be applied to the application scenario as Figure 1 shown. This application scenario can be composed of a terminal 101 and a server 102. Among them, the terminal 101 can be a desktop computer, a portable computer, a laptop computer, a tablet computer, a smart phone, a smart watch, etc., and the server 102 can be a single server, multiple servers, a server cluster, a cloud computing platform, etc. Among them, the server 102 can be used as a computing device for the data processing method provided by the present invention to implement data processing by the server 102.

[0077] Optionally, a contract can be uploaded to the server 102 through the terminal 101. The server can be associated with a database for storing the uploaded contracts. Among them, the contract can stipulate the agreed delivery data of each item to be delivered. In addition, the performance materials completed according to the contract can also be uploaded through the terminal 101, so that the terminal 101 can upload the completed performance materials to the server 102 to calculate the performance progress. Alternatively, the performance materials can be directly generated on the terminal 101, and the terminal 101 can automatically upload the completed performance materials during the operation thereon to upload the completed performance materials to the server 102 to calculate the performance progress, etc., but not limited thereto.

[0078] Optionally, the contract can be a song delivery contract, a music copyright contract, a performance contract, a music licensing contract, a lease contract, a service contract, a copyright transfer contract, a technology development contract, an insurance contract, etc. The specific type of the contract is not limited in the present invention.

[0079] Exemplary Method

[0080] The following Figure 1 application scenario is referred to Figure 2 to describe the data processing method according to the exemplary embodiments of the present invention. It should be noted that the above application scenario is only shown for the convenience of understanding the spirit and principle of the present invention, and the embodiments of the present invention are not limited in this regard. On the contrary, the embodiments of the present invention can be applied to any applicable scenario.

[0081] Refer to Figure 2 , Figure 2 which schematically shows a flowchart of a data processing method according to an embodiment of the present invention. As Figure 2 shown, the method includes:

[0082] Step S201, in response to reaching the set time for monitoring the performance progress of the contract, obtain the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time as the data to be processed.

[0083] In some embodiments, the process of monitoring the performance progress of the contract can be set to be periodic, that is, it can be set to monitor the performance progress of the contract every set duration. Then, every set duration, the set time for monitoring the performance progress of the contract will be reached, so that the performance progress of the contract can be monitored through the subsequent process every time the set time is reached.

[0084] In some embodiments, a computing device may be associated with a target database for storing contract data of generated contracts. The contract data may be used to indicate each item to be delivered within the contract and the agreed delivery data for each item to be delivered. Optionally, the database may be a relational database, such as a MySQL database, but is not limited thereto.

[0085] Among them, the name of the target database is not limited, and it may be, for example, a "copyright library" or the like.

[0086] Optionally, the items to be delivered may be products, services, work results, etc. that need to be completed and delivered to the other party according to the agreed time or conditions during the performance of the contract, but are not limited thereto. Taking a contract for song delivery as an example, the item to be delivered may be a song; taking a contract for lease as an example, the item to be delivered may be the leased object (such as a house, equipment, vehicle, etc., but not limited thereto); taking a service contract as an example, the item to be delivered may be the service to be provided to the other party, and so on. The specific type of the item to be delivered in the embodiments of the present invention is not limited.

[0087] Optionally, for any item to be delivered, the agreed delivery data may be data clearly listed in the contract that requires one party to provide to the other party according to the agreed time, manner, and standard. For example, the agreed delivery data may be the quantity, time, product performance, etc. that the item to be delivered needs to be delivered as stipulated in the contract, but is not limited thereto.

[0088] Optionally, for any item to be delivered, the actual delivery data may be the data that has been provided to the other party and the time of data provision, etc. under the current development and creation progress. For example, the actual delivery data may be the quantity currently delivered for the item to be delivered, the actual delivery time, the product performance of the actually delivered product, etc., but is not limited thereto. It should be noted that as the contract performance process continues to deepen, the actual delivery data of each item to be delivered will be continuously updated.

[0089] In some embodiments, when the set time for monitoring the contract performance progress is reached, the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered at the set time may be obtained as the data to be processed for calculating the performance progress.

[0090] Step S202, based on the data to be processed, determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items according to a plurality of pre-set monitoring dimensions and the contract performance index items corresponding to each monitoring dimension.

[0091] In some embodiments, the monitoring dimensions can be preset according to actual business requirements. For example, the monitoring dimensions can be set according to the types of items to be delivered in a contract. Taking the item to be delivered as audio data (such as a song) as an example, the monitoring dimensions are set for the audio data, including but not limited to the lyrics dimension, the music dimension, the recording dimension, the singing dimension, and the video (i.e., Music Video (MV)) dimension, etc.; taking the item to be delivered as a house for lease as an example, the monitoring dimensions are set for the house, including but not limited to the public facilities in the community where the house belongs, the furniture configuration of the house, the household appliance configuration of the house, etc.

[0092] It should be noted that for each item to be delivered, multiple monitoring dimensions can be set, and when monitoring the performance progress, one or more of the set monitoring dimensions can be used as the monitoring dimensions for monitoring the performance progress. In addition, it should be noted that the monitoring dimensions for monitoring the performance progress can be determined according to the contract agreement. For example, taking a song delivery contract as an example, if the contract stipulates that the lyrics, music, and video of the song need to be delivered, then the lyrics dimension, the music dimension, and the video dimension can be used as the monitoring dimensions for monitoring the performance progress.

[0093] In some embodiments, multiple contract performance indicator items can be set according to actual business needs. The set contract performance indicator items can be common to different monitoring dimensions or specific to one or several specific monitoring dimensions. Taking the pre-set monitoring dimension 1, monitoring dimension 2, and monitoring dimension 3 as an example, 2 contract performance indicator items (denoted as contract performance indicator item 1 and contract performance indicator item 2) that are common to these three monitoring dimensions can be set. That is, there are two contract performance indicator items, namely contract performance indicator item 1 and contract performance indicator item 2, under each of monitoring dimension 1, monitoring dimension 2, and monitoring dimension 3; or, contract performance indicator item 1 and contract performance indicator item 2 that are common to monitoring dimension 1, monitoring dimension 2, and monitoring dimension 3 can be set, and contract performance indicator item 3 specific to monitoring dimension 1 can be set. The embodiments of the present invention do not limit the ownership relationship between the monitoring dimensions and the contract performance indicator items.

[0094] Optionally, the contract performance indicator items can include the delivery quantity, delivery deadline, authorization time, delivery rate, etc., but are not limited thereto.

[0095] In some embodiments, calculations can be performed based on the data to be processed according to the pre-set multiple monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension, so as to determine the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items.

[0096] Step S203: Organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items with each item to be delivered as an index, so as to store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items in an associated manner.

[0097] In some embodiments, each item to be delivered can be used as an index to organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items, so as to store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items in the same location, so as to realize the associated storage of the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items.

[0098] Through the solution provided by the embodiments of the present invention, when the set time for monitoring the contract performance progress is reached, the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time can be obtained as data to be processed, and based on the multiple preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension, the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items can be determined from the data to be processed. Thus, each item to be delivered is used as an index to organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items, so as to store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items in an associated manner, so that the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items can be stored together. Therefore, when adding new index items subsequently, it is only necessary to add the data corresponding to the new index items under the contract performance index data already stored for each item to be delivered, without modifying the established data structure, thereby reducing the workload of adding new statistical indicators and improving the processing efficiency when adding new statistical index items.

[0099] After introducing the basic implementation process of the present invention, the following introduces the various optional embodiments of the present invention.

[0100] It should be noted that for the target database associated with the computing device and used to store multiple generated contracts, there may be a relatively large number of contracts stored therein, but not all of the contracts stored therein need to be monitored for the contract performance progress. For example, the target database may store various contracts such as informal contracts, pre-contracts, temporary contracts, and large copyright contracts. Moreover, the contract sources (or procurement sources) and contract signing modes of different contracts are different. However, when actually monitoring the contract performance progress, it may only be necessary to monitor the performance progress of contracts of specific types, specific sources, and specific signing modes, and there is no need to monitor the contract performance progress for other contracts. Therefore, in some embodiments, before step S201, target contracts that need to be monitored for contract performance progress can also be screened out from the target database used to store multiple contracts.

[0101] In some embodiments, based on the pre-set filtering information, target contracts that meet the filtering information can be screened out from the target database used to store multiple contracts, so that subsequent data processing processes can be performed based on the screened target contracts.

[0102] In some embodiments, the filtering information can be used to indicate the contract information of the target contracts that need to be screened out. The contract information can be at least one of contract type, contract status, contract source, and contract signing mode, but is not limited thereto.

[0103] For example, the filtering information can be set to indicate that the contract type of the target contracts that need to be screened out is large copyright contracts, so that based on the set filtering information, large copyright contracts that need to be monitored for contract performance progress can be screened out from the target database as target contracts.

[0104] In some embodiments, after screening out the target contracts according to the filtering information, through step S201, in response to reaching the set time for monitoring the contract performance progress, the agreed delivery data of each to-be-delivered item in the target contract and the actual delivery data of each to-be-delivered item in the target contract at the set time are obtained as the data to be processed. For the introduction of the set time, agreed delivery data, and actual delivery data, reference can be made to the foregoing, and details are not described herein again.

[0105] In some embodiments, for step S201, when, in response to reaching the set time for monitoring the contract performance progress, the agreed delivery data of each to-be-delivered item in the target contract and the actual delivery data of each to-be-delivered item in the target contract at the set time are obtained as the data to be processed, for the agreed delivery data of each to-be-delivered item in the target contract, it can be directly obtained from the contract data of the target contract stored in the target database, while for the actual delivery data of each to-be-delivered item in the target contract, it can be implemented by means of data offline snapshots.

[0106] That is, in response to reaching the target time, the agreed delivery data of each item to be delivered in the target contract can be obtained from the target database, and in response to reaching the target time, a snapshot can be saved based on the actual delivery data of each item to be delivered in the target contract at the set time to obtain the offline data of the actual delivery data, so as to use the agreed delivery data and the actual delivery data of each delivery item as the data to be processed.

[0107] In some embodiments, after the data to be processed is obtained, through step S202, according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension, the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items can be determined based on the data to be processed.

[0108] In some embodiments, a corresponding function page can be provided by a computing device for a user to set the monitoring dimensions and / or the contract performance index items.

[0109] In some embodiments, a first function page can be provided to provide an editing function for the monitoring dimensions and / or the contract performance index items through the first function page. For example, before determining the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension based on the data to be processed, the monitoring dimensions and / or the contract performance index items can be edited through the first function page, but not limited to this. The present invention does not limit the timing of editing the monitoring dimensions and / or the contract performance index items.

[0110] In some embodiments, before determining the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension based on the data to be processed, in the case of editing the preset monitoring dimensions and / or the contract performance index items through the first function page, in response to the editing of the monitoring dimensions and / or the contract performance index items in the first function page, the plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension can be obtained.

[0111] By providing the first function page, the user can intervene in the contract entry situation in a timely manner according to business requirements to obtain the monitoring dimensions and contract performance index items that meet the statistical requirements.

[0112] For the introduction of the monitoring dimensions and the contract performance index items, reference can be made to the foregoing, which will not be elaborated here.

[0113] In some embodiments, for step S202, when determining the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance index items according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension, it is possible to first count the contract performance of each to-be-delivered item under the contract performance index items corresponding to different dimensions based on the to-be-processed data, so as to achieve a finer-grained statistics of the contract performance, and then, based on the finer-grained contract performance statistics results, aggregate the contract performance statistics results of each to-be-delivered item under different monitoring dimensions and the contract performance statistics results of each to-be-delivered item under different contract performance index items.

[0114] In some embodiments, it is possible to generate first index data of each to-be-delivered item under the contract performance index items corresponding to different monitoring dimensions based on the contract performance index items corresponding to each monitoring dimension; further, for any contract performance index, it is possible to generate first statistical index data of each to-be-delivered item under the contract performance index based on the first index data of each to-be-delivered item under the contract performance index corresponding to different monitoring dimensions, and for any monitoring dimension, it is possible to generate second statistical index data of each to-be-delivered item under the monitoring dimension based on the first index data of each to-be-delivered item under different contract performance index items corresponding to the monitoring dimension, so as to obtain the first statistical index data as the aggregated statistical results of each to-be-delivered item under different contract performance index items and the second statistical index data as the aggregated statistical results of each to-be-delivered item under different monitoring dimensions; then, it is possible to determine the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance index items based on the first index data of each to-be-delivered item under the contract performance index items corresponding to different monitoring dimensions, the first statistical index data of each to-be-delivered item under different contract performance index items, and the second statistical index data of each to-be-delivered item under different monitoring dimensions. Optionally, it is possible to directly use the first index data of each to-be-delivered item under the contract performance index items corresponding to different monitoring dimensions, the first statistical index data of each to-be-delivered item under different contract performance index items, and the second statistical index data of each to-be-delivered item under different monitoring dimensions as the contract performance index data of each to-be-delivered item under different monitoring dimensions and different contract performance index items.

[0115] Optionally, when calculating the index data, it is possible to use various quantification methods such as the percentage completion method, physical measurement method, output value measurement method, time progress method, etc. to achieve the calculation of the index data. The present invention does not limit the specific quantification method used. For the introduction of various quantification methods, reference can be made to the foregoing, and details are not elaborated here.

[0116] Taking the item to be delivered as audio data as an example, if multiple monitoring dimensions include the word dimension, the music dimension, the recording dimension, the singing dimension, and the video dimension, and multiple contract performance indicator items include the agreed delivery quantity, the agreed delivery deadline, the authorization time, etc., then for each item to be delivered, the contract performance indicator items corresponding to different monitoring dimensions can include 15 fine-grained contract performance indicator items such as the word delivery rate, the word delivery status, the word authorization time, the music delivery rate, the music delivery status, the music authorization time, the recording delivery rate, the recording delivery status, the recording authorization time, the singing delivery rate, the singing delivery status, the singing authorization time, the video delivery rate, the video delivery status, and the video authorization time. Thus, the contract performance situation can be statistically calculated based on the data to be processed according to these 15 fine-grained contract performance indicator items, so as to obtain the first indicator data of each audio data to be delivered under these 15 fine-grained contract performance indicator items. Among them, the delivery rate is used to indicate the percentage of the workload that has been completed for a certain item to be delivered in the total workload. The delivery status can be undelivered, normally delivered, delivered with a delay, etc., but is not limited to this.

[0117] Furthermore, for any contract performance indicator item, the contract performance situations of this contract performance indicator item under each monitoring dimension can be aggregated to determine the aggregated contract performance situation corresponding to this contract performance indicator item. Taking the contract performance indicator item of the agreed delivery deadline as an example, the five more fine-grained contract performance indicator items of the word delivery status, the music delivery status, the recording delivery status, the singing delivery status, and the video delivery status corresponding to the agreed delivery deadline can be integrated to determine the comprehensive delivery status of each audio data.

[0118] It should be noted that for the case where the item to be delivered is audio data, after data processing is performed according to contract performance indicator items such as the agreed delivery quantity, the agreed delivery deadline, the authorization time, etc., the statistical results are aggregated according to the contract performance indicator items, so that the songs and MV information authorized in the contract can be obtained according to the authorization list associated with the contract, and data comparison can be performed in combination with the agreed contract performance indicator items to obtain the song information of normal delivery and delayed delivery, so as to obtain the delivery information in different song states. In addition, the delivery progress can also be statistically calculated from the time dimension. Among them, the authorization list can be used to indicate the copyright information of the songs involved in the contract, such as the authorization time, the authorization ratio, the settlement time, the settlement ratio, etc.

[0119] Moreover, for any monitoring dimension, the performance situations of each contract performance indicator item under this monitoring dimension can be aggregated to determine the aggregated contract performance situation corresponding to this monitoring dimension. Taking the word dimension as the monitoring dimension as an example, the three more fine-grained contract performance indicator items of the word delivery rate, the word delivery status, and the word authorization time under the word dimension can be integrated to determine the delivery situation of each audio data in the word dimension.

[0120] It should be noted that for the case where the item to be delivered is audio data, after processing the data according to the contract performance indicator items such as the agreed delivery quantity, the agreed delivery deadline, and the authorization time, and aggregating the statistical results according to the monitoring dimensions, the performance data of resources such as videos, accompaniments (i.e., music), and lyrics can be obtained.

[0121] Through the above embodiments, the refinement of the contract performance indicator items can be achieved from multiple levels, so as to realize the statistics of the contract performance situation from multiple levels, thereby improving the flexibility and diversity of the statistical results.

[0122] In some embodiments, after generating the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items through step S202, step S203 can be used to organize the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items with each item to be delivered as the index, so as to store the contract performance indicator data of the same item to be delivered under different monitoring dimensions and different contract performance indicator items in an associated manner.

[0123] In some embodiments, for step S203, when organizing the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items with each item to be delivered as the index to store the contract performance indicator data of the same item to be delivered under different monitoring dimensions and different contract performance indicator items in an associated manner, each item to be delivered can be used as the column index, and in a column storage manner, the contract performance indicator data of the same item to be delivered under different monitoring dimensions and different contract performance indicator items can be stored in the same storage location.

[0124] In some embodiments, a columnar storage database can be used to store the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items, so as to store the contract performance indicator data in a column storage manner. That is, the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items can be submitted to the columnar storage database to store the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items through the columnar storage database.

[0125] Optionally, the columnar storage database can be a Clickhouse database. That is, the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items can be stored through the Clickhouse database, but it is not limited to this. Other columnar storage databases can also be used to store the contract performance indicator data.

[0126] In some embodiments, when submitting contract performance indicator data to the Clickhouse database, it can be implemented by means of stream task processing. For example, a Function as a Service (FaaS) task can be used to parse the contract performance indicator data into a unified storage format and save it to the Clickhouse database.

[0127] Optionally, when submitting contract performance indicator data, it can be implemented by means of asynchronous message processing.

[0128] The processing process described in the above embodiments can be referred to Figure 3 , Figure 3 which schematically shows a flowchart of the generation and submission process of a contract performance indicator data according to an embodiment of the present invention. As Figure 3 shown, contract scope processing can be performed according to contract type, contract status, contract source, and contract signing mode to filter the contracts to be processed and obtain the target contracts for which performance progress monitoring is required. Then, the preset contract performance indicator items can be split according to monitoring dimensions such as words, music, recording, singing, and video to obtain finer-grained contract performance indicator items. Furthermore, the performance progress data can be statistically analyzed according to different contract performance indicator items corresponding to different detection dimensions (i.e., finer-grained contract performance indicator items) to obtain the first indicator data. Then, based on the first indicator data, aggregation is performed to obtain the performance progress data statistical results under different contract performance indicator items and the performance progress data statistical results under different monitoring dimensions, so as to achieve multi-dimensional statistical results such as word dimension information statistics, accompaniment information dimension statistics, recording dimension information statistics, singing dimension information statistics, video dimension information statistics, and delivery progress dimension information statistics. Finally, the contract performance indicator data obtained through multi-dimensional statistics is submitted to the corresponding database.

[0129] In some embodiments, a second function page can also be provided to provide a visualization display function of the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items. That is, the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items can be organized with each item to be delivered as an index. After the contract performance indicator data of the same item to be delivered under different contract performance indicator items is associated and stored, the second function page is displayed to display the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items on the second function page.

[0130] In some embodiments, the second function page may further provide a query function for contract performance indicator data. Optionally, the user may perform a query operation on the second function page through the target account, so that the computing device can respond to the query operation of the target account on the second function page, obtain a query request, and the query request is used to query contract performance indicator data based on at least one of the items to be delivered, monitoring dimensions, and contract performance indicator items.

[0131] In some embodiments, after obtaining the query request, an SQL statement can be generated based on the query conditions carried in the query request, so as to query based on the SQL statement in the stored contract performance indicator data, and determine the target contract performance data that matches the query conditions from the stored contract performance data, so that the target contract performance data can be displayed on the second function page. Among them, the query conditions can be at least one of the items to be delivered, monitoring dimensions, and contract performance indicator items

[0132] In some embodiments, when generating an SQL statement based on the query conditions carried in the query request, the query conditions can be obtained by parsing the annotation content of the request parameter structure, and then the components of the query conditions can be assembled according to the logical fields to achieve the automatic generation of the SQL statement.

[0133] In some embodiments, for paper contracts signed offline, there are usually special agreement contents. For such contracts, the operation personnel can process the monitoring dimensions and / or contract performance indicator items through the first function page. Therefore, when generating the SQL statement, the results of the manual intervention of the operation personnel can also be integrated into it to achieve the generation of the SQL statement.

[0134] In some embodiments, since the contract itself has a privacy nature, it is necessary to distinguish the content permissions according to the person responsible for the contract to ensure the privacy of the contract data. Therefore, when querying those contract performance progress data, the permission verification of the query account can be automatically processed as a query condition into the query logic to ensure the security of the query process. That is, when generating the SQL statement, it can also be generated based on the query conditions carried in the query request and the account information of the target account. Among them, the account information of the target account can be used to indicate the position, account permissions, etc. of the target account, and the present invention does not limit this.

[0135] In some embodiments, if the account information indicated by the SQL statement does not meet the query requirements, the query request of the target account can be directly rejected to ensure that the target account without query permission cannot view this privacy data and ensure the privacy of the contract data.

[0136] In some embodiments, when the account information indicated by the SQL statement meets the query requirements, queries can be performed on the stored contract performance indicator data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data.

[0137] Among them, the query requirements can be used to indicate the positions of the accounts that can perform queries, account permissions, etc., and the present invention does not limit this.

[0138] In some embodiments, when performing a query according to the SQL statement, target contract performance indicator data can be queried in the ClickHouse database in real time based on the SQL statement, so as to automatically parse the annotation part in the statistical return structure. Through Java reflection, the queried target contract performance indicator data is recursively encapsulated and returned to the second function page of the front end through an interface, so as to display the target contract performance indicator data through the second function page.

[0139] See Figure 4 , Figure 4 which schematically shows a flowchart of a process for querying contract performance indicator data according to an embodiment of the present invention. As Figure 4 shown, when a target account initiates a data query, relevant information on query conditions in multiple aspects such as comprehensive scanning condition query annotations, contract content permission filtering, and manual intervention by operation personnel can be integrated to reflectively parse the condition combination to obtain the query conditions, so that the SQL statement can be generated by splicing the query conditions, and an online query can be performed in the Clickhouse database based on the generated SQL statement to obtain the corresponding query results. Thus, the target contract performance indicator data can be obtained by sequentially scanning statistical indicator annotations, reflectively recursively parsing the return results, and automatically assembling data, and the target contract performance indicator data is returned to the front end so that the front end can implement visual display of the target contract performance indicator data through the second function page.

[0140] Through the above embodiments, the performance statistics data can be queried by means of real-time assembling query logic, automatic structure return, etc., reducing the development workload and supporting flexible query filtering, making the data display more comprehensive.

[0141] The process of the data processing method provided by the present invention can be seen in Figure 5 , Figure 5 which schematically shows a flowchart of a data processing method according to an embodiment of the present invention. As Figure 5 shown

[0142] For the generation and submission process of performance data, contract data, authorization letter data, and settlement data can be analyzed and statistically processed, and complex contract entry situations can be intervened to generate contract performance indicator data. Through the method of asynchronous message consumption processing, the statistically generated contract performance indicator data is processed and converted by Faas tasks to parse the contract performance indicator data into a unified storage format and save it in the Clickhouse database to achieve the storage of contract performance indicator data in the database. For the query process of performance data, SQL statements can be generated by automatically parsing query conditions and combining with the restrictions of contract content permissions for real-time query in the Clickhouse database, and the query results are automatically encapsulated and transmitted to the front-end users.

[0143] Through the solution provided by the present invention, the processing of newly added indicator data can be made simple. In the case of newly added statistical indicators, changes to the original table can be avoided, and the processing and access of new data can be simplified. Moreover, when processing monitoring dimensions and contract performance indicator items, for some special situations (such as manual entry errors, special contract agreements, etc.), the ability of manual intervention can be provided to better accommodate various statistical scenarios for performance indicators. In addition, contract performance indicator data can support flexible query and screening through methods such as real-time assembly of query logic and automated structure return, making data display more comprehensive.

[0144] Exemplary Apparatus

[0145] After introducing the method of the exemplary embodiment of the present invention, next, reference is made to Figure 6 to introduce the data processing device of the exemplary embodiment of the present invention.

[0146] Reference is made to Figure 6 , Figure 6 which schematically shows a block diagram of a data processing according to an embodiment of the present invention, as shown in Figure 6 and the device includes:

[0147] An acquisition module 601, configured to obtain the agreed delivery data of each to-be-delivered item in the target contract and the actual delivery data of each to-be-delivered item in the target contract at the set time as to-be-processed data in response to reaching the set time for monitoring the contract performance progress;

[0148] A determination module 602, configured to determine the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items based on the to-be-processed data according to a plurality of preset monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension;

[0149] A storage module 603 is configured to organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items by using each item to be delivered as an index, so as to associatively store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items.

[0150] In some embodiments, when the storage module 603 is configured to organize the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items by using each item to be delivered as an index, so as to associatively store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items, it is configured to:

[0151] Using each item to be delivered as a column index and adopting a column storage method, store the contract performance index data of the same item to be delivered under different monitoring dimensions and different contract performance index items to the same storage location.

[0152] In some embodiments, the storage module 603 is further configured to store the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items through a Clickhouse database.

[0153] In some embodiments, when the determination module 602 is configured to determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance index items based on the data to be processed according to a plurality of preset monitoring dimensions and the contract performance index items corresponding to each monitoring dimension, it is configured to:

[0154] Generate first index data of each item to be delivered under the contract performance index items corresponding to different monitoring dimensions based on the contract performance index items corresponding to each monitoring dimension;

[0155] For any contract performance index, generate first statistical index data of each item to be delivered under the contract performance index based on the first index data of each item to be delivered under the contract performance index items corresponding to different monitoring dimensions;

[0156] For any monitoring dimension, generate second statistical index data of each item to be delivered under the monitoring dimension based on the first index data of each item to be delivered under different contract performance index items corresponding to the monitoring dimension;

[0157] Determine the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators based on the first index data of each item to be delivered under the contract performance indicators corresponding to different monitoring dimensions, the first statistical index data of each item to be delivered under different contract performance indicators, and the second statistical index data of each item to be delivered under different monitoring dimensions.

[0158] In some embodiments, when the obtaining module 601 is used to obtain the agreed delivery data of each item to be delivered in the target contract and the actual delivery data of each item to be delivered in the target contract at the set time in response to reaching the set time for monitoring the contract performance progress, and use them as the data to be processed, it is used for:

[0159] In response to reaching the target time, perform snapshot saving based on the actual delivery data of each item to be delivered in the target contract at the set time to obtain the offline data of the actual delivery data, so as to use the agreed delivery data and the actual delivery data of each delivery item as the data to be processed.

[0160] In some embodiments, the device further includes:

[0161] A screening module, configured to screen out the target contract that meets the filtering information from the target database for storing multiple contracts based on the pre-set filtering information; wherein, the filtering information is used to indicate at least one of the contract type, contract status, contract source, and contract signing mode of the target contract to be screened out.

[0162] In some embodiments, the item to be delivered is audio data, and the multiple monitoring dimensions include word dimension, music dimension, recording dimension, singing dimension, and video dimension.

[0163] In some embodiments, the device further includes:

[0164] A first display module, configured to provide a first function page, and the first function page is used to provide an editing function for monitoring dimensions and / or contract performance index items;

[0165] The obtaining module 601 is further configured to obtain a plurality of pre-set monitoring dimensions and the contract performance index items corresponding to each monitoring dimension in response to the editing of the monitoring dimensions and / or contract performance index items in the first function page.

[0166] In some embodiments, the device further includes:

[0167] A second display module, configured to provide a second function page to display the contract performance index data of each item to be delivered under different monitoring dimensions and different contract performance indicators in the second function page.

[0168] In some embodiments, the second function page is further configured to provide a query function for contract performance indicator data;

[0169] The obtaining module 601 is further configured to obtain a query request in response to a query operation of a target account on the second function page, where the query request is used to query contract performance indicator data based on at least one of to-be-delivered items, monitoring dimensions, and contract performance indicator items.

[0170] In some embodiments, the apparatus further includes:

[0171] A generating module, configured to generate an SQL statement based on the query conditions carried in the query request;

[0172] A query module, configured to query in the stored contract performance indicator data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data;

[0173] The second display module is further configured to display the target contract performance data on the second function page.

[0174] In some embodiments, the generating module is further configured to generate the SQL statement based on the query conditions carried in the query request and the account information of the target account.

[0175] In some embodiments, when the query module is configured to query in the stored contract performance indicator data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data, it is configured to:

[0176] When the account information indicated by the SQL statement meets the query requirements, query in the stored contract performance indicator data based on the SQL statement to determine target contract performance data that matches the query conditions from the stored contract performance data.

[0177] It should be noted that although several modules of the data processing apparatus are mentioned in the above detailed description, this division is merely exemplary and not mandatory. In fact, according to the embodiments of the present invention, the features and functions of two or more of the above-described modules may be embodied in one module. Conversely, the features and functions of one module described above may be further divided and embodied by multiple modules.

[0178] Exemplary Medium

[0179] After introducing the media of the exemplary embodiments of the present invention, next, referring toFigure 7 An introduction is made to a computer-readable storage medium for data processing according to an exemplary embodiment of the present invention.

[0180] Reference Figure 7 , Figure 7 schematically shows a schematic diagram of a computer-readable storage medium according to an embodiment of the present invention. As Figure 7 shown, a computer program 700 is stored on the computer-readable storage medium. When the computer program 700 is executed by a processor, it can execute the data processing method provided by any embodiment of the present invention.

[0181] Exemplary Device

[0182] After introducing the methods, media, and devices of the exemplary embodiments of the present invention, next, reference Figure 8 is made to a computing device for data processing according to an exemplary embodiment of the present invention.

[0183] Reference Figure 8 , Figure 8 schematically shows a schematic diagram of a computing device according to an embodiment of the present invention. As Figure 8 shown, the computing device 800 may include, but is not limited to: a processor 810, a memory 820, and a bus 830 connecting different system components (including the memory 820 and the processor 810).

[0184] Among them, the memory 820 stores computer instructions, which can be executed by the processor 810, enabling the processor 810 to execute the data processing method provided by any embodiment of the present invention. The memory 820 may include a random access storage unit (Random Access Memory, RAM) 821, a cache storage unit 822, and / or a read-only storage unit (Read-Only Memory, ROM) 823. The memory 820 may further include: a program tool 827 having a set of program modules 824. The program modules 824 include, but are not limited to: an operating system, one or more application programs, other program modules, and program data. One or more combinations of these program modules may include the implementation of a network environment.

[0185] The bus 830 may include, for example, a data bus, an address bus, and a control bus, etc. The computing device 800 may also communicate with an external device 850 through an input / output (Input / Output, I / O) interface 840. The external device 850 may be, for example, a keyboard, a Bluetooth device, etc. The computing device 800 may also communicate with one or more networks through a network adapter 860. For example, the network may be a local area network, a wide area network, a public network, etc. As Figure 8As shown, the network adapter 860 can also communicate with other modules of the computing device 800 via the bus 830.

[0186] Exemplary Product

[0187] An embodiment of the present invention also provides a computer program product. The computer program product includes a computer program. When the program is executed by the processor 810 of the computing device 800, it can implement the data processing method provided by any embodiment of the present invention.

[0188] In addition, although the operations of the method of the present invention are described in a specific order in the drawings, this does not require or imply that these operations must be performed in that specific order, or that all the operations shown must be performed to achieve the desired result. Additionally or alternatively, some steps may be omitted, multiple steps may be combined into one step for execution, and / or one step may be decomposed into multiple steps for execution.

[0189] Although the spirit and principles of the present invention have been described with reference to several specific embodiments, it should be understood that the present invention is not limited to the disclosed specific embodiments, and the division of each aspect does not mean that the features in these aspects cannot be combined for benefit. This division is only for the convenience of expression. The present invention aims to cover various modifications and equivalent arrangements included within the spirit and scope of the appended claims.

Claims

1. A data processing method, characterized in that: The method comprises: In response to reaching a set time for monitoring the progress of contract performance, obtaining the agreed delivery data of each to-be-delivered item in the target contract and the actual delivery data of each to-be-delivered item in the target contract at the set time as data to be processed; According to the pre-set multiple monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension, based on the data to be processed, determine the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items; The contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items are organized using the each to-be-delivered item as an index, so as to associate and store the contract performance indicator data of the same to-be-delivered item under different monitoring dimensions and different contract performance indicator items.

2. The method according to claim 1, characterized in that: The method of organizing the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items by using each to-be-delivered item as an index, so as to associate and store the contract performance indicator data of the same to-be-delivered item under different monitoring dimensions and different contract performance indicator items, includes: The items to be delivered are used as column indexes and the contract performance indicator data of the same item to be delivered under different monitoring dimensions and different contract performance indicator items are stored in the same storage location in a column storage manner.

3. The method according to claim 1, characterized in that The step of determining the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items based on the data to be processed according to the preset multiple monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension includes: Based on the contract performance indicator items corresponding to each monitoring dimension, generating first indicator data of each of the items to be delivered under the contract performance indicator items corresponding to different monitoring dimensions; For any contract performance indicator, based on the first indicator data under the contract performance indicator item corresponding to each of the to-be-delivered items in different monitoring dimensions, generate first statistical indicator data under the contract performance indicator item for each of the to-be-delivered items; For any monitoring dimension, based on the first indicator data of each to-be-delivered item under different contract performance indicator items corresponding to the monitoring dimension, generate second statistical indicator data of each to-be-delivered item under the monitoring dimension; Based on the first indicator data of the contract performance indicator items corresponding to the various monitoring dimensions of the various items to be delivered, the first statistical indicator data of the various items to be delivered under the various contract performance indicator items, and the second statistical indicator data of the various items to be delivered under the various monitoring dimensions, the contract performance indicator data of the various items to be delivered under the various monitoring dimensions and the various contract performance indicator items are determined.

4. The method according to claim 1, characterized in that: The item to be delivered is audio data, and the multiple monitoring dimensions include lyrics dimension, music dimension, recording dimension, singing dimension and video dimension.

5. The method according to claim 1, characterized in that After organizing the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items by using each to-be-delivered item as an index to associate and store the contract performance indicator data of the same to-be-delivered item under different contract performance indicator items, the method further includes: A second function page is provided to display the contract performance indicator data of each of the items to be delivered under different monitoring dimensions and different contract performance indicator items in the second function page.

6. The method according to claim 5, characterized in that The second function page is also used to provide a query function for contract performance indicator data; The method further comprises: In response to the target account's query operation in the second function page, a query request is obtained, where the query request is used to query the contract performance indicator data based on at least one of the items to be delivered, the monitoring dimensions, and the contract performance indicator items.

7. The method according to claim 6, characterized in that After obtaining the query request in response to the query operation of the target account in the second function page, the method further includes: Generate an SQL statement based on the query conditions carried by the query request; Based on the SQL statement, query the stored contract performance indicator data to determine the target contract performance data matching the query condition from the stored contract performance data; The target contract performance data is displayed in the second function page.

8. A data processing device, characterized in that: The device comprises: an acquisition module, configured to acquire, in response to reaching a set time for monitoring the progress of contract performance, agreed delivery data of each to-be-delivered item in the target contract and actual delivery data of each to-be-delivered item in the target contract at the set time as data to be processed; A determination module, configured to determine, based on the data to be processed, the contract performance indicator data of each to-be-delivered item under different monitoring dimensions and different contract performance indicator items according to a plurality of pre-set monitoring dimensions and the contract performance indicator items corresponding to each monitoring dimension; A storage module is used to organize the contract performance indicator data of each item to be delivered under different monitoring dimensions and different contract performance indicator items using the items to be delivered as indexes, so as to associate and store the contract performance indicator data of the same item to be delivered under different monitoring dimensions and different contract performance indicator items.

9. A computing device, characterized in that The computing device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the operations performed by the data processing method according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a program, and the program is executed by a processor to implement the operations performed by the data processing method according to any one of claims 1 to 7.

Images