Data calculation method and device

By storing standard parameters as common parameter tables according to dimension characteristics and calculating them, the problem of high redundant storage and management costs in the existing technology is solved, data standardization and calculation flexibility is realized, and data calculation efficiency of the overall system is improved. .

CN119106034APending Publication Date: 2024-12-10BEIJING JINGDONG YUANSHENG TECH CO LTD

Patent Information

Application Number
CN202411170691.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-23
Publication Date
2024-12-10

Smart Images

  • Figure CN119106034A_ABST
    Figure CN119106034A_ABST
Patent Text Reader

Abstract

The invention discloses a data calculation method and device, and relates to the technical field of computers. A specific embodiment of the method comprises the following steps: in response to a received parameter calculation request sent by a task scheduling system, calling a form template and calculation logic corresponding to a target calculation parameter; determining a target standard parameter required for calculating the target calculation parameter according to the calculation logic, determining a public parameter table according to the dimension feature of the target standard parameter, and querying a corresponding parameter value from the public parameter table; and according to the parameter value of the target standard parameter and the parameter value of the service atomic parameter in the form template, performing calculation and result return according to calculation logic, so that a task scheduling system performs data calculation according to the calculation result. According to the implementation mode, standard and flexible data calculation is achieved, the standard parameters are stored as the public parameter table according to the dimension features, storage resources are saved, standardization of the standard data is achieved, and data calculation of the whole system is better facilitated.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a data calculation method and device. Background Art

[0002] With the development and promotion of information technology, all walks of life have higher and higher expectations for digital information systems. They need not only data collection, statistics and calculation capabilities, but also flexible customization and scalability. The realization of these capabilities is inseparable from the standard and specification design of the underlying basic data. In existing digital information systems, various common basic data are usually stored and used according to the dimensions of the user. For example, if both users A and B need to use standard charging data, then A will establish a standard charging table to store and use standard charging data, and B will also establish a standard charging table to store and use standard charging data.

[0003] In the process of implementing the present invention, the inventors found that the prior art has the following problems:

[0004] The existing method of processing common basic data is to store the same data redundantly, which not only occupies storage resources and increases the cost of data management, but also the way in which each user manages the common basic data is not conducive to the construction of data standardization, which in turn causes difficulties in collaboration between users and is not conducive to data calculation of the overall system. Summary of the invention

[0005] In view of this, an embodiment of the present invention provides a data calculation method and device, which realizes standard and flexible data calculation, stores standard parameters as a public parameter table according to dimensional characteristics, saves storage resources and management costs, realizes the standardization of standard data, and is more conducive to data calculation of the overall system. At the same time, the configurability of form templates and calculation logic also ensures the flexibility of calculation.

[0006] To achieve the above object, according to one aspect of an embodiment of the present invention, a data calculation method is provided, which is applied to a task execution system, and includes:

[0007] In response to receiving a parameter calculation request sent by the task scheduling system, parsing the target calculation parameter from the parameter calculation request, and retrieving a form template and calculation logic corresponding to the target calculation parameter;

[0008] According to the calculation logic, the target standard parameters required for calculating the target calculation parameters are determined, and according to the dimensional characteristics of the target standard parameters, a public parameter table is determined, and the parameter value of the target standard parameter is queried from the public parameter table, wherein the public parameter table is used to store various standard parameters with the same dimensional characteristics;

[0009] According to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template, calculation is performed according to the calculation logic to obtain the calculation results of the target calculation parameters, and the calculation results are returned to the task scheduling system so that the task scheduling system performs data calculation according to the obtained calculation results of the target calculation parameters.

[0010] Optionally, before determining the common parameter table according to the dimensional characteristics of the standard parameters, the method also includes: obtaining various standard data of the specified business, and grouping the various standard data according to the dimensional characteristics of the various standard data; storing the various standard data in the same group in the same common parameter table according to a specified storage structure, and marking the dimensional characteristics of the standard data stored in the common parameter table on the common parameter table.

[0011] Optionally, after grouping the various standard data, the method further includes: determining the system properties of the task execution system corresponding to the various standard data in the same group, and marking the system properties of the task execution system on the corresponding standard data; querying the parameter value of the target standard parameter from the public parameter table includes: sending a query request to the public parameter table, so that the public parameter table obtains the system properties of the task execution system from the query request and returns various standard data marked with the system properties of the task execution system; receiving the various standard data returned by the public parameter table, and querying the parameter value of the target standard parameter from the various standard data.

[0012] Optionally, the form template is composed of various business atomic parameters, and the business atomic parameters are obtained by splitting the business parameters at the atomic level; the calculation logic is determined in the following way: according to the business meaning of the target calculation parameters, the required target standard parameters are determined, and the target business atomic parameters are selected from the business atomic parameter set obtained by the split; the calculation logic is generated by defining the logical operation rules between the target business atomic parameters and the target standard parameters.

[0013] Optionally, after obtaining the calculation result of the target calculation parameter, the method further includes: filling the calculation result back into the result item in the form template and displaying it so as to check and review the calculation result.

[0014] Optionally, the method further includes: in response to receiving an update request of the computing logic, obtaining updated target standard parameters and / or updated business atomic parameters; and updating the updated target standard parameters and / or the updated business atomic parameters to the computing logic.

[0015] According to a second aspect of an embodiment of the present invention, there is provided a data calculation method, which is applied to a task scheduling system, and includes: determining target calculation parameters required for data calculation according to a data calculation task, and assigning a corresponding task execution system to the target calculation parameters, and sending a parameter calculation request to the task execution system; in response to receiving a calculation result of the target calculation parameter returned by the task execution system, summarizing and calculating the calculation results to obtain a calculation result of the data calculation task.

[0016] According to a third aspect of an embodiment of the present invention, there is provided a data computing device, comprising:

[0017] A preprocessing module, configured to, in response to receiving a parameter calculation request sent by a task scheduling system, parse the target calculation parameter from the parameter calculation request, and retrieve a form template and calculation logic corresponding to the target calculation parameter;

[0018] A query module, used to determine the target standard parameters required to calculate the target calculation parameters according to the calculation logic, and determine a common parameter table according to the dimensional characteristics of the target standard parameters, and query the parameter value of the target standard parameters from the common parameter table, wherein the common parameter table is used to store various standard parameters with the same dimensional characteristics;

[0019] A calculation module is used to perform calculations according to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template in accordance with the calculation logic to obtain the calculation results of the target calculation parameters, and return the calculation results to the task scheduling system so that the task scheduling system performs data calculations according to the obtained calculation results of the target calculation parameters.

[0020] According to a fourth aspect of an embodiment of the present invention, there is provided an electronic device for data calculation, including:

[0021] one or more processors;

[0022] a storage device for storing one or more programs,

[0023] When the one or more programs are executed by the one or more processors, the one or more processors implement the method provided in the first aspect of the embodiment of the present invention.

[0024] According to a fifth aspect of an embodiment of the present invention, there is provided a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the method provided in the first aspect of the embodiment of the present invention is implemented.

[0025] An embodiment of the invention has the following advantages or beneficial effects: by responding to a parameter calculation request sent by a task scheduling system, parsing the target calculation parameter from the parameter calculation request, and calling the form template and calculation logic corresponding to the target calculation parameter; according to the calculation logic, determining the target standard parameter required for calculating the target calculation parameter, and according to the dimensional characteristics of the target standard parameter, determining the public parameter table, and querying the parameter value of the target standard parameter from the public parameter table, wherein the public parameter table is used to store various standard parameters with the same dimensional characteristics; according to the parameter value of the target standard parameter and the parameter value of the business atomic parameter in the form template, calculating according to the calculation logic to obtain the calculation result of the target calculation parameter, and returning the calculation result to the task scheduling system, so that the task scheduling system performs data calculation according to the obtained calculation result of the target calculation parameter. The technical solution realizes a standard and flexible data calculation method, stores the standard parameters as a public parameter table according to the dimensional characteristics, saves storage resources and management costs, realizes the standardization of standard data, and is more conducive to the data calculation of the overall system. At the same time, the configurability of the form template and the calculation logic also ensures the flexibility of calculation. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] The accompanying drawings are used to better understand the present invention and do not constitute an improper limitation of the present invention.

[0027] Figure 1 is a schematic diagram of the main process of the data calculation method according to an embodiment of the present invention;

[0028] Figure 2 is a schematic diagram of the splitting process of the service parameters in an embodiment of the present invention;

[0029] Figure 3 is a schematic diagram of the composition of the computing logic of an embodiment of the present invention;

[0030] Figure 4 is a schematic diagram of constructing a common parameter table according to an embodiment of the present invention;

[0031] Figure 5 is a schematic diagram of the overall construction of a form template according to an embodiment of the present invention;

[0032] Figure 6 It is a schematic diagram of the overall process of data calculation in an embodiment of the present invention;

[0033] Figure 7 It is a schematic diagram of the principle of the data calculation method of an embodiment of the present invention;

[0034] Figure 8 It is a schematic diagram of the overall flow of the data calculation method according to an embodiment of the present invention;

[0035] Fig. 9is a schematic diagram of main modules of a data computing device according to an embodiment of the present invention;

[0036] Fig.10 is an exemplary system architecture diagram to which embodiments of the present invention may be applied;

[0037] Fig.11 It is a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. DETAILED DESCRIPTION

[0038] It should be noted that in the technical solution of the present invention, the collection / collection, update, analysis, use, transmission, storage and other aspects of user personal information involved are in compliance with the provisions of relevant laws and regulations, are used for legal and reasonable purposes, are not shared, leaked or sold outside of these legal uses, and are subject to supervision and management by national regulatory authorities. Necessary measures should be taken for user personal information to selectively block the use or access to personal information data to prevent illegal access to such personal information data, ensure that persons who have access to personal information data comply with the provisions of relevant laws and regulations, and ensure the security of user personal information. In addition, once these user personal information data are no longer needed, the risks should be minimized by limiting or even prohibiting data collection and / or deleting data.

[0039] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.

[0040] The existing method of processing common basic data is to store the same data redundantly, which not only occupies storage resources and increases the cost of data management, but also the way in which each user manages the common basic data is not conducive to the construction of data standardization, which in turn causes difficulties in collaboration between users, is not conducive to the data calculation of the overall system, and cannot meet the actual application requirements.

[0041] In order to solve the above problems existing in the prior art, the present invention proposes a data calculation method. On the premise that all standard parameters of the same dimensional feature are stored in a common parameter table, the target standard parameters required for calculating the target calculation parameters are determined from the configured form template, and the corresponding common parameter table is determined according to the dimensional feature of the target standard parameter. The parameter value of the target standard parameter is searched from the common parameter table, and then the target calculation parameter is calculated according to the configured calculation logic, and the calculation result is returned to the task scheduling system so that the task scheduling system can perform data calculation of the entire system according to the calculation result. A standard and flexible data calculation method is implemented, and the standard parameters are stored as a common parameter table according to the dimensional feature, which saves storage resources and management costs, realizes the standardization of standard data, and is more conducive to the data calculation of the entire system. At the same time, the configurability of the form template and the calculation logic also ensures the flexibility of the calculation.

[0042] Figure 1 is a schematic diagram of the main process of the data calculation method according to an embodiment of the present invention, such as Figure 1 As shown, the data calculation method of the embodiment of the present invention includes the following steps S101 to S103.

[0043] Step S101: in response to receiving a parameter calculation request sent by a task scheduling system, parsing a target calculation parameter from the parameter calculation request, and retrieving a form template and calculation logic corresponding to the target calculation parameter.

[0044] Specifically, when the task scheduling system receives a task that requires the task execution system to assist or collaborate in data calculation, it specifies the various target calculation parameters required for the data calculation and sends a parameter calculation request to the task execution system in the overall system. It is understandable that the task scheduling system may only need to send a parameter calculation request to one task execution system, or may need to send a parameter calculation request to multiple task execution systems. The processing and calculation process of the target calculation parameters of each task execution system is similar. The embodiment of the present invention takes the processing and calculation of the target calculation parameters of a task execution system as an example for explanation.

[0045] In addition, it can be understood that the task scheduling system and task execution system of the embodiment of the present invention can be applied to various business scenarios, such as the calculation of route operation data in an air transportation scenario (including total operating cost, total flight cost, total maintenance cost, etc.), the calculation of delivery data in an express delivery scenario (including the total delivery cost of a specified area, the total delivery maintenance cost of a specified area, etc.), the calculation of development projects in a real estate business scenario (including total building area, total construction cost, total infrastructure cost, etc.), the calculation of projects in a product development business scenario (including total development cost, total development time, total labor cost, total material cost, etc.), etc. The embodiment of the present invention specifically takes the calculation of route operation data in an air transportation scenario as an example to illustrate the data calculation method.

[0046] Furthermore, when the task execution system receives the parameter calculation request sent by the task scheduling system, it will parse the target calculation parameters that need to be calculated by the task execution system according to the preset data format, such as the total operating cost in the calculation of the route operation data, and then retrieve the pre-configured form template corresponding to the calculation of the total operating cost and the pre-configured corresponding calculation logic. The specific retrieval method can query the pre-associated form template and calculation logic through the target calculation parameters, or through the name of the form template and calculation logic, which is not specifically limited in the embodiment of the present invention.

[0047] According to one embodiment of the present invention, the form template is composed of various business atomic parameters, and the business atomic parameters are obtained by splitting the business parameters at the atomic level; the calculation logic is determined in the following manner: according to the business meaning of the target calculation parameters, the required target standard parameters are determined, and the target business atomic parameters are selected from the business atomic parameter set obtained by the split; the calculation logic is generated by defining the logical operation rules between the target business atomic parameters and the target standard parameters.

[0048] Specifically, before the task scheduling system executes the data calculation task, the embodiment of the present invention will determine in advance the various business parameters required for the data calculation of the business scenario, such as the service fee of the aircraft route, the flight preparation time, etc. Some of these business parameters need to be calculated from multiple sub-business parameters, that is, these business parameters may be non-atomic and divisible. In order to facilitate parameter reuse and improve the flexibility and scalability of calculation, the embodiment of the present invention performs atomic-level splitting processing on the business parameters with the smallest granularity and the most complete structure, and the parameters with the smallest granularity after splitting are business atomic parameters.

[0049] Figure 2It is a schematic diagram of the splitting process of the business parameters of an embodiment of the present invention. The business parameters of multiple business systems are aggregated into a table, code represents the field representation of each business parameter, and des is the corresponding semantic description. Each business parameter in the table is split at an atomic level. For example, the service fee of an airplane route can be split into coordination fees, water truck fees, sewage truck fees, and other hourly fees for each time unit. These split parameters are business atomic parameters. The id identifier is determined according to the parameter name of the business parameter, and the split business atomic parameters are filled in the position corresponding to the id identifier to obtain a business atomic parameter set, thereby completing the splitting and storage of the business parameters.

[0050] Accordingly, the determination of the calculation logic is mainly based on the specific business meaning of the target calculation parameters. Under normal circumstances, the calculation of the target calculation parameters is inseparable from the standard parameters stipulated by the industry, such as charging standards, charging guidance prices, etc. First, the parameter names of the target standard parameters required for the target calculation parameters are clarified, and the target business atomic parameters are selected from the business atomic parameter set split at the atomic level of the above business data; then, based on the business meaning of the target calculation parameters, the specific logical operation rules of the target business atomic parameters and the target standard parameters are defined, such as common quantitative operation methods such as addition, subtraction, multiplication, and division, or logical operation methods such as and, or, and not, to obtain the specific calculation logic of the constructed calculation target calculation parameters, and this calculation logic is sent down and configured to the task execution system that has the authority to calculate the target calculation parameters.

[0051] Figure 3 It is a schematic diagram of the composition of the calculation logic of the embodiment of the present invention. It can be seen that each target calculation parameter is determined by different calculation methods between the business atomic parameters and the standard parameters, and different business atomic parameters can be used in combination with the standard parameters to determine the target calculation parameters. The business atomic parameter set and standard parameters of the embodiment of the present invention together provide flexible and complete data support for the determination of the calculation logic of various target calculation parameters.

[0052] Step S102: according to the calculation logic, determine the target standard parameters required to calculate the target calculation parameters, and according to the dimensional characteristics of the target standard parameters, determine a common parameter table, and query the parameter value of the target standard parameter from the common parameter table, wherein the common parameter table is used to store various standard parameters with the same dimensional characteristics.

[0053] Specifically, based on the retrieved calculation logic, the target standard parameters required for calculating the target calculation parameters are obtained. It can be understood that the calculation of the target calculation parameters is inseparable from various standard parameters in the specific business field. For example, when calculating the above-mentioned total operating cost, the business expense expenditures must comply with the industry standards. Accordingly, the corresponding business charging standard parameters will be clearly defined in its calculation logic. In the embodiment of the present invention, some or all of the standard parameters involved in the same business scenario are stored in different public parameter tables according to the dimensional feature differences, allowing the task execution system with query authority to query and use them. The task execution system determines the public parameter table to be searched according to the dimensional features of the target standard parameters in the calculation logic. If the target standard parameter is a one-dimensional parameter, for example, the route category is a first-class, second-class, or third-class route, then the one-dimensional public parameter table is locked. The public parameter table stores the data name and corresponding data value of each standard data with the same dimensional feature. The task execution system can query the parameter value of the target standard parameter from the determined public parameter table under the condition of having query authority.

[0054] According to one embodiment of the present invention, before determining the common parameter table according to the dimensional characteristics of the standard parameters, the method also includes: obtaining various standard data of the specified business, and grouping the various standard data according to the dimensional characteristics of the various standard data; storing the various standard data in the same group in the same common parameter table according to a specified storage structure, and marking the dimensional characteristics of the standard data stored in the common parameter table on the common parameter table.

[0055] Specifically, for the construction of a public parameter table, before determining the public parameter table according to the dimensional characteristics of the standard parameters, it is necessary to collect the standard data or all the standard data required by this business scenario. Different standard data may have different dimensional characteristics. For example, airport classification: Class I, Class II, and Class III are one-dimensional standard data; the standard flight speed of an aircraft depends on two factors: the aircraft model and weight, which is two-dimensional standard data. According to the dimensional characteristics of each standard data (one-dimensional, two-dimensional, three-dimensional, etc.), each standard data is divided into groups with different dimensional characteristics, that is, the standard data in a group has the same dimensional characteristics. Then, each standard data in the same group is stored in the same public parameter table according to the specified storage structure (such as key-value), and the dimensional characteristics of the standard data stored in the public parameter table are added to the table ID, so that the task execution system can quickly find the public parameter table with the corresponding dimensional characteristics according to the dimensional characteristics.

[0056] Figure 4It is a schematic diagram of constructing a common parameter table in an embodiment of the present invention. Obtain the standard data contained in the guidance documents, standard documents and specification documents involved in the business scenario, and group each standard data according to its dimensional characteristics. For the standard data of three dimensions and above in the aviation transportation scenario, most of them are universal standard parameters, so the standard data of three dimensions and above (collectively referred to as multi-dimensional) are stored in a multi-dimensional common table. Accordingly, the key is determined according to the data name of each standard data in the group, and the corresponding data value is stored as the value in the common parameter table. It can be understood that for a two-dimensional common parameter table, each two-dimensional standard parameter has two quantities to record the specific two-dimensional information in addition to the key and the corresponding value. The embodiment of the present invention uses col and row to record them respectively, and multi-dimensional is similar, using multiple quantities to record the corresponding dimensional information.

[0057] According to another embodiment of the present invention, after grouping the various standard data, the method further includes: determining the system properties of the task execution system corresponding to the various standard data in the same group, and marking the system properties of the task execution system on the corresponding standard data; querying the parameter value of the target standard parameter from the common parameter table includes: sending a query request to the common parameter table, so that the common parameter table obtains the system properties of the task execution system from the query request and returns various standard data marked with the system properties of the task execution system; receiving the various standard data returned by the common parameter table, and querying the parameter value of the target standard parameter from the various standard data.

[0058] Specifically, considering that standard data may have local applicability, and in order to improve the query efficiency of target standard parameters, after grouping each standard data, it is also possible to assign the system attributes of the corresponding task execution system to each standard data in a targeted manner, which is equivalent to assigning a task execution system with query authority to each standard data. The system attribute of the task execution system is similar to an identity attribute, and the determined system attribute is marked on the corresponding standard data. For example, standard data 1 is mainly used in task execution system S1, so S1 is marked on the standard data. It is understandable that, considering that each standard file and specification file has version information, different versions of standard data may be different. In order to distinguish different versions of standard data, the version number of the source file of the standard data can also be marked on the corresponding standard data.

[0059] Furthermore, when querying the parameter value of the target standard parameter from the public parameter table, a query request is first sent to the public parameter table, and the public parameter table parses the query request to obtain the system attribute of the task execution system that sent the query request, and filters out all standard data marked with the system attribute from the public parameter table according to the system attribute, and returns these standard data to the task execution system. The task execution system receives the various standard data returned by the public parameter table that are consistent with the system attribute of the task execution system, and then queries the standard data with the same parameter name as the target standard parameter from the various received standard data, and uses the value of the standard data as the parameter value of the target standard parameter to complete the query process.

[0060] The embodiment of the present invention uses the method of system attribute marking to effectively control the use rights of standard parameters and avoid the problem of deviation in calculation results caused by incorrect definition of similar standard parameters in different business scopes in the calculation logic, but also can improve the efficiency of the task execution system in querying the parameter values ​​of the target standard parameters and save internal resources.

[0061] Step S103: perform calculation according to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template, according to the calculation logic, obtain the calculation results of the target calculation parameters, and return the calculation results to the task scheduling system, so that the task scheduling system performs data calculation according to the obtained calculation results of the target calculation parameters.

[0062] Specifically, the task execution system pulls the corresponding parameter values ​​from the internal according to the business atomic parameters contained in the form template called above, and then combines the parameter values ​​of the target standard parameters queried above, and calculates the calculation results of the target calculation parameters according to the logical calculation rules between the business atomic parameters and the target standard parameters in the configured calculation logic, and returns the calculation results to the task scheduling system. The task scheduling system performs data calculation based on the calculation results of the target calculation parameters returned by the task execution system.

[0063] According to an embodiment of the present invention, after obtaining the calculation result of the target calculation parameter, the method further includes: filling the calculation result back into the result item in the form template and displaying it so as to check and review the calculation result.

[0064] Specifically, in order to ensure the reliability and accuracy of the calculation results of the target calculation parameters, the embodiment of the present invention can also define corresponding result items in the form template. Based on this, the parameter values ​​pulled from the inside according to the business atomic parameters contained in the form template can be backfilled into the business atomic parameter items corresponding to the form template, and the calculation results can also be backfilled into the result items of the form template, thereby completely recording the calculation items of the target calculation parameters. This can facilitate manual data verification and review, and improve the accuracy of the calculation results. It can be understood that for the need to display key data in the target calculation parameters, the required display fields can also be added to the form template to facilitate the use of data. In addition, the display of the result items can also be stored by separately configuring a result data table corresponding to the form template, and the displayed display fields are also added to the result data table.

[0065] It can be understood that the task scheduling system of the embodiment of the present invention can send parameter calculation requests to only one task execution system as needed, or it can send parameter calculation requests to multiple task execution systems, and each task execution system has a form template under the authority corresponding to the system attributes. Specific parameter calculation requests can be sent using a message queue to ensure that each task execution system can receive accurate and consistent request data.

[0066] Figure 5 It is a schematic diagram of the overall construction of the form template of the embodiment of the present invention. Based on the atomic-level decomposition of business parameters, a set of business atomic parameters is obtained, a form template with corresponding permissions is configured for each task execution system, and an association relationship between the target calculation parameters and the form template is established. The form template of each task execution system contains the business atomic parameters required for calculating the target calculation parameters, such as the average oil price, air rights coordination fees, and project preliminary inspection fees in the task execution system S1 in the figure. In addition, the embodiment of the present invention also configures a corresponding result data table for the form template of each task execution system, which contains result items for storing the calculation results of the target calculation parameters, as well as display fields that need to be displayed.

[0067] According to another embodiment of the present invention, the method further includes: in response to receiving an update request for the computing logic, obtaining updated target standard parameters and / or updated business atomic parameters; and updating the updated target standard parameters and / or the updated business atomic parameters to the computing logic.

[0068] Specifically, the embodiments of the present invention ensure the orderliness, flexibility and scalability of data calculation of the overall system through standardized processing of standard data, atomic-level decomposition of business parameters, configuration of form templates and calculation logic, and permission management of each task execution system. When the calculation logic in the business execution system needs to be updated, the updated target standard parameters and / or updated business atomic parameters can be obtained according to the update request. It is only necessary to update the updated target standard parameters and / or updated business atomic parameters to the calculation logic, and other calculation logics without update requirements remain unchanged, thereby realizing flexible and highly scalable calculation of target calculation parameters.

[0069] Based on the calculation of the target calculation parameters of the task execution system mentioned above, an embodiment of the present invention also provides a method for data calculation of a task scheduling system, which is applied to the task scheduling system, including: determining the target calculation parameters required for data calculation according to the data calculation task, and assigning a corresponding task execution system to the target calculation parameters, and sending a parameter calculation request to the task execution system; in response to receiving the calculation results of the target calculation parameters returned by the task execution system, summarizing and calculating the calculation results to obtain the calculation results of the data calculation task.

[0070] Specifically, when the task scheduling system receives a data calculation task, it analyzes the specific target calculation parameters required by the data calculation task, and determines the corresponding task execution system according to the business area to which each target calculation parameter belongs. Usually, the entire system consists of a task scheduling system and multiple task execution systems. Each task execution system is relatively independent, and each corresponds to a different business area, and has the operation authority for the parameters of the business area to which it belongs. For example, cost statistics belongs to the business of task execution system S1, and time statistics belongs to the business of task execution system S2. The task scheduling system uniformly schedules and manages each task execution system. After determining the task execution system, the task scheduling system encapsulates the target calculation parameters as parameter calculation requests and sends them to the corresponding task execution system. After each task execution system completes the calculation of the target calculation parameters, it returns the verified and reviewed calculation results to the task scheduling system. The task scheduling system receives the calculation results returned by each task execution system, summarizes the calculation results, and performs overall processing and calculation as needed to obtain the calculation results of the data calculation task and complete this data calculation.

[0071] Figure 6It is a schematic diagram of the overall process of data calculation in an embodiment of the present invention. Each task execution system determines the target calculation parameter according to the received parameter calculation request, and calls the corresponding form template according to the target calculation parameter, obtains the corresponding business atomic parameter value according to the name of the business atomic parameter in the form template, and fills the business atomic parameter value back into the form template for saving. Each task execution system determines the target standard parameter according to the saved form template and the corresponding calculation logic, and queries the parameter value of the target standard parameter from the corresponding public parameter table according to the dimensional characteristics of the target standard parameter, and then calculates according to the calculation logic to obtain the calculation result of the target calculation parameter.

[0072] Furthermore, each task execution system will fill the calculation results back into the result item and submit it for verification and review. After the verification and review are passed, each task execution system will return the verified and reviewed calculation results to the task scheduling system. The task scheduling system will summarize and organize the calculation results returned by each task execution system to obtain the final data calculation results.

[0073] Figure 7 It is a principle diagram of the data calculation method of an embodiment of the present invention. The task scheduling system receives a calculation task for route operation data, wherein the target calculation parameters include flight time, taxi time, block time, maximum take-off weight, route fees, command fees, operating expenses, etc., and sends parameter calculation requests for these target calculation parameters to the corresponding task execution system according to the business authority of each task execution system. Each task execution system determines the corresponding target calculation parameters according to the received parameter calculation request, and calls the form template and calculation logic corresponding to the target calculation parameters. The target standard parameters are determined according to the calculation logic, and the parameter values ​​of the target standard parameters are queried from the public parameter table according to the dimensional characteristics of the target standard parameters. According to the parameter values ​​of the target standard parameters and the business atomic parameters contained in the form template, the target calculation parameters are calculated according to the called calculation logic to obtain the calculation results.

[0074] It should be noted that for the task execution system S4, since it is mainly used for statistical summary, the calculation results of the task execution systems S1, S2, and S3 in this figure need to be summarized to S4, and the calculation logic of S4 needs to perform secondary logical operations on the summary results, so there are two calculation logics. Finally, S4 submits the final summary data to the task execution system S5, and S5 is responsible for returning the final summary data to the task scheduling system.

[0075] Figure 8It is a schematic diagram of the overall process of the data calculation method of an embodiment of the present invention. The initiator of the data calculation task sends a request to fill in the route data information filling form to the background system. The background system performs a normative check on the received route data information filling form. If the check fails, the request will no longer be processed. If the check passes, the request is sent to the task scheduling system. The task scheduling system generates a data calculation task based on the route data information filling form, determines the target calculation parameters required for the data calculation, and allocates the corresponding task execution system to the target calculation parameters. The parameter calculation request is sent to the task execution system. Specifically, the parameter calculation request can be sent to each task execution system in the form of a message queue to ensure that the parameter calculation request can reach each task execution system accurately and consistently. At the same time, it monitors whether the parameter calculation request is sent successfully.

[0076] If the data is not sent successfully, you can try to send it according to the number of times set by the retry mechanism. If the data is still not sent successfully after the specified number of times, the data calculation ends and the reason for the unsuccessful sending is checked. If the data is sent successfully, each task execution system determines the target calculation parameters according to the received parameter calculation request, and calls the corresponding form template according to the target calculation parameters, obtains the corresponding business atomic parameter values ​​according to the names of the business atomic parameters in the form template, and fills the business atomic parameter values ​​back into the form template for saving. Each task execution system determines the target standard parameters according to the saved form template and the corresponding calculation logic, and queries the parameter values ​​of the target standard parameters from the corresponding public parameter table according to the dimensional characteristics of the target standard parameters, and then calculates according to the calculation logic to obtain the calculation results of the target calculation parameters, and displays the calculation results for verification and review. If the verification and review fails, the target calculation parameters are recalculated. If the verification and review passes, the calculation results are returned to the task scheduling system. The task scheduling system aggregates and processes the calculation results received from various task execution systems, obtains the final data calculation results, saves them, and returns them to the background system for filling in the route data information form.

[0077] The embodiment of the present invention implements a standard and flexible data calculation method based on the atomic splitting of business parameters, the configurability of form templates and calculation logic, the standardized processing of standard data, and the business authority allocation of each task execution system. The standard parameters are stored as a public parameter table according to dimensional characteristics, which saves storage resources and management costs, realizes the standardization of standard data, and is more conducive to the data calculation of the overall system. At the same time, the configurability of form templates and calculation logic also ensures the flexibility of calculation.

[0078] Fig. 9 Schematic diagram of the main modules of the data computing device according to an embodiment of the present invention. Fig. 9As shown, the data computing device 900 mainly includes a preprocessing module 901 , a query module 902 and a computing module 903 .

[0079] The preprocessing module 901 is used for, in response to receiving a parameter calculation request sent by the task scheduling system, parsing the target calculation parameter from the parameter calculation request, and retrieving the form template and calculation logic corresponding to the target calculation parameter;

[0080] A query module 902 is used to determine the target standard parameters required to calculate the target calculation parameters according to the calculation logic, and determine a common parameter table according to the dimensional characteristics of the target standard parameters, and query the parameter value of the target standard parameters from the common parameter table, wherein the common parameter table is used to store various standard parameters with the same dimensional characteristics;

[0081] The calculation module 903 is used to perform calculations according to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template according to the calculation logic, obtain the calculation results of the target calculation parameters, and return the calculation results to the task scheduling system so that the task scheduling system performs data calculations according to the obtained calculation results of the target calculation parameters.

[0082] According to one embodiment of the present invention, the data calculation device 900 also includes a common parameter table construction module (not shown in the figure), which is used to: before determining the common parameter table according to the dimensional characteristics of the standard parameters, obtain various standard data of the specified business, and group the various standard data according to the dimensional characteristics of the various standard data; store the various standard data in the same group in the same common parameter table according to the specified storage structure, and mark the dimensional characteristics of the standard data stored in the common parameter table on the common parameter table.

[0083] According to another embodiment of the present invention, the data computing device 900 also includes a system property marking module (not shown in the figure), which is used to: after grouping the various standard data, determine the system properties of the task execution system corresponding to the various standard data in the same group, and mark the system properties of the task execution system on the corresponding standard data; the query module 902 is also used to: send a query request to the common parameter table, so that the common parameter table obtains the system properties of the task execution system from the query request and returns various standard data marked with the system properties of the task execution system; after receiving the various standard data returned by the common parameter table, query the parameter value of the target standard parameter from the various standard data.

[0084] According to another embodiment of the present invention, the form template is composed of various business atomic parameters, and the business atomic parameters are obtained by splitting the business parameters at the atomic level; the calculation logic is determined in the following manner: according to the business meaning of the target calculation parameters, the required target standard parameters are determined, and the target business atomic parameters are selected from the business atomic parameter set obtained by the split; the calculation logic is generated by defining the logical operation rules between the target business atomic parameters and the target standard parameters.

[0085] According to another embodiment of the present invention, the data calculation device 900 also includes a result display module (not shown in the figure), which is used to: after obtaining the calculation results of the target calculation parameters, fill in the calculation results into the result items in the form template and display them so as to check and review the calculation results.

[0086] According to another embodiment of the present invention, the data computing device 900 also includes a result update module (not shown in the figure), which is used to: obtain updated target standard parameters and / or updated business atomic parameters in response to receiving an update request for the computing logic; and update the updated target standard parameters and / or the updated business atomic parameters to the computing logic.

[0087] Fig.10 is an exemplary system architecture diagram to which embodiments of the present invention can be applied.

[0088] like Fig.10 As shown, the system architecture 1000 may include terminal devices 1001, 1002, 1003, a network 1004, and a server 1005. The network 1004 is used to provide a medium for communication links between the terminal devices 1001, 1002, 1003 and the server 1005. The network 1004 may include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0089] Users can use terminal devices 1001, 1002, 1003 to interact with server 1005 through network 1004 to receive or send messages, etc. Various communication client applications, such as data computing applications, etc., can be installed on terminal devices 1001, 1002, 1003 (only as examples).

[0090] The terminal devices 1001 , 1002 , and 1003 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers, etc.

[0091] The server 1005 may be a server that provides various services, such as a background management server (only for example) that provides support for data calculations performed by users using terminal devices 1001, 1002, and 1003. In response to receiving a parameter calculation request sent by the task scheduling system, the background management server may parse the target calculation parameter from the parameter calculation request, and retrieve the form template and calculation logic corresponding to the target calculation parameter; determine the target standard parameter required for calculating the target calculation parameter according to the calculation logic, and determine the public parameter table according to the dimensional characteristics of the target standard parameter, and query the parameter value of the target standard parameter from the public parameter table, wherein the public parameter table is used to store various standard parameters with the same dimensional characteristics; calculate according to the parameter value of the target standard parameter and the parameter value of the business atomic parameter in the form template according to the calculation logic, obtain the calculation result of the target calculation parameter, and return the calculation result to the task scheduling system, so that the task scheduling system performs data calculation and other processing according to the obtained calculation result of the target calculation parameter, and feeds back the processing result (such as the calculation result, etc. - only for example) to the terminal device.

[0092] It should be noted that the data calculation method provided in the embodiment of the present invention is generally executed by the server 1005 , and accordingly, the data calculation device is generally set in the server 1005 .

[0093] It should be understood that Fig.10 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0094] Reference below Fig.11 , which shows a schematic diagram of the structure of a computer system of a terminal device or a server suitable for implementing an embodiment of the present invention. Fig.11 The terminal device or server shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0095] like Fig.11 As shown, the computer system 1100 includes a central processing unit (CPU) 1101, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 1102 or a program loaded from a storage portion 1108 into a random access memory (RAM) 1103. In the RAM 1103, various programs and data required for the operation of the system 1100 are also stored. The CPU 1101, the ROM 1102, and the RAM 1103 are connected to each other via a bus 1104. An input / output (I / O) interface 1105 is also connected to the bus 1104.

[0096] The following components are connected to the I / O interface 1105: an input section 1106 including a keyboard, a mouse, etc.; an output section 1107 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 1108 including a hard disk, etc.; and a communication section 1109 including a network interface card such as a LAN card, a modem, etc. The communication section 1109 performs communication processing via a network such as the Internet. A drive 1110 is also connected to the I / O interface 1105 as needed. A removable medium 1111, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 1110 as needed, so that a computer program read therefrom is installed into the storage section 1108 as needed.

[0097] In particular, according to the embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 1109, and / or installed from the removable medium 1111. When the computer program is executed by the central processing unit (CPU) 1101, the above-mentioned functions defined in the system of the present invention are executed.

[0098] It should be noted that the computer-readable medium shown in the present invention may be a computer-readable signal medium or a computer-readable storage medium or any combination of the two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present invention, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In the present invention, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer-readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, optical cable, RF, etc., or any suitable combination thereof.

[0099] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a sequence different from that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0100] The units involved in the embodiments of the present invention may be implemented by software or hardware. The units described may also be arranged in a processor, for example, it may be described as follows: a processor includes a preprocessing module, a query module and a calculation module.

[0101] Among them, the names of these modules do not constitute a limitation of the modules themselves in certain cases. For example, the preprocessing module can also be described as "a module for responding to a parameter calculation request sent by a task scheduling system, parsing target calculation parameters from the parameter calculation request, and retrieving the form template and calculation logic corresponding to the target calculation parameters."

[0102] On the other hand, the present invention also provides a computer-readable medium, which may be included in the device described in the embodiment; or may exist independently and not be assembled into the device. The computer-readable medium carries one or more programs, and when the one or more programs are executed by a device, the device includes: in response to receiving a parameter calculation request sent by a task scheduling system, parsing the target calculation parameter from the parameter calculation request, calling the form template and calculation logic corresponding to the target calculation parameter; according to the calculation logic, determining the target standard parameter required to calculate the target calculation parameter, and according to the dimensional characteristics of the target standard parameter, determining a public parameter table, querying the parameter value of the target standard parameter from the public parameter table, wherein the public parameter table is used to store each standard parameter with the same dimensional characteristics; according to the parameter value of the target standard parameter and the parameter value of the business atomic parameter in the form template, calculating according to the calculation logic, obtaining the calculation result of the target calculation parameter, and returning the calculation result to the task scheduling system, so that the task scheduling system performs data calculation according to the obtained calculation result of the target calculation parameter.

[0103] The technical solution according to the embodiment of the present invention has the following advantages or beneficial effects: by responding to a parameter calculation request sent by a task scheduling system, parsing the target calculation parameter from the parameter calculation request, and calling the form template and calculation logic corresponding to the target calculation parameter; determining the target standard parameter required for calculating the target calculation parameter according to the calculation logic, and determining the public parameter table according to the dimensional characteristics of the target standard parameter, and querying the parameter value of the target standard parameter from the public parameter table, wherein the public parameter table is used to store various standard parameters with the same dimensional characteristics; calculating according to the parameter value of the target standard parameter and the parameter value of the business atomic parameter in the form template according to the calculation logic to obtain the calculation result of the target calculation parameter, and returning the calculation result to the task scheduling system, so that the task scheduling system performs data calculation according to the obtained calculation result of the target calculation parameter. The technical solution realizes a standard and flexible data calculation method, stores the standard parameters as a public parameter table according to the dimensional characteristics, saves storage resources and management costs, realizes the standardization of standard data, and is more conducive to the data calculation of the overall system. At the same time, the configurability of the form template and the calculation logic also ensures the flexibility of calculation.

[0104] The specific implementation methods described herein do not constitute limitations on the scope of protection of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention shall be included in the scope of protection of the present invention.

Claims

1. A data calculation method, characterized in that: Applied to task execution systems, including: In response to receiving a parameter calculation request sent by the task scheduling system, parsing the target calculation parameter from the parameter calculation request, and retrieving a form template and calculation logic corresponding to the target calculation parameter; According to the calculation logic, the target standard parameters required for calculating the target calculation parameters are determined, and according to the dimensional characteristics of the target standard parameters, a public parameter table is determined, and the parameter value of the target standard parameter is queried from the public parameter table, wherein the public parameter table is used to store various standard parameters with the same dimensional characteristics; According to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template, calculation is performed according to the calculation logic to obtain the calculation results of the target calculation parameters, and the calculation results are returned to the task scheduling system so that the task scheduling system performs data calculation according to the obtained calculation results of the target calculation parameters.

2. The method according to claim 1, characterized in that Before determining the common parameter table according to the dimensional characteristics of the standard parameters, the method further includes: Acquire various standard data of the specified business, and group the various standard data according to the dimensional features of the various standard data; The various standard data in the same group are stored in the same public parameter table according to the specified storage structure, and the dimension features of the standard data stored in the public parameter table are marked on the public parameter table.

3. The method according to claim 2, characterized in that After grouping the various standard data, the method further includes: Determine the system attribute of the task execution system corresponding to each standard data in the same group, and mark the system attribute of the task execution system on the corresponding standard data; The querying the parameter value of the target standard parameter from the public parameter table includes: Sending a query request to the common parameter table, so that the common parameter table obtains the system properties of the task execution system from the query request and returns each standard data marked with the system properties of the task execution system; The various standard data returned by the common parameter table are received, and the parameter value of the target standard parameter is queried from the various standard data.

4. The method according to claim 1, characterized in that The form template is composed of various business atomic parameters, and the business atomic parameters are obtained by splitting the business parameters at the atomic level; The calculation logic is determined by: According to the business meaning of the target calculation parameter, the required target standard parameter is determined, and the target business atomic parameter is selected from the business atomic parameter set obtained by splitting; The calculation logic is generated by defining the logical operation rules between the target business atomic parameters and the target standard parameters.

5. The method according to claim 1, after obtaining the calculation result of the target calculation parameter, the method further comprises: The calculation result is filled back into the result item in the form template and displayed so as to check and review the calculation result.

6. The method according to claim 1, characterized in that The method further comprises: In response to receiving an update request of the computing logic, acquiring updated target standard parameters and / or updated business atomic parameters; The updated target standard parameters and / or the updated business atomic parameters are updated to the calculation logic.

7. A data calculation method, characterized in that: Applied to task scheduling systems, including: Determine the target calculation parameters required for data calculation according to the data calculation task, assign a corresponding task execution system to the target calculation parameters, and send a parameter calculation request to the task execution system; In response to receiving the calculation result of the target calculation parameter returned by the task execution system, the calculation results are aggregated and calculated to obtain the calculation result of the data calculation task.

8. A data computing device, characterized in that: include: A preprocessing module, configured to, in response to receiving a parameter calculation request sent by a task scheduling system, parse the target calculation parameter from the parameter calculation request, and retrieve a form template and calculation logic corresponding to the target calculation parameter; A query module, used to determine the target standard parameters required to calculate the target calculation parameters according to the calculation logic, and determine a common parameter table according to the dimensional characteristics of the target standard parameters, and query the parameter value of the target standard parameters from the common parameter table, wherein the common parameter table is used to store various standard parameters with the same dimensional characteristics; A calculation module is used to perform calculations according to the parameter values ​​of the target standard parameters and the parameter values ​​of the business atomic parameters in the form template in accordance with the calculation logic to obtain the calculation results of the target calculation parameters, and return the calculation results to the task scheduling system so that the task scheduling system performs data calculations according to the obtained calculation results of the target calculation parameters.

9. A mobile electronic device terminal, characterized in that: include: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 7.

10. A computer readable medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • Data processing method and device and computer equipment

    CN109522521A

  • Index calculation engine implementation method based on dimension model

    CN116166686A

  • Business data early warning method and device, computer equipment and storage medium

    CN116483822A

Cited By

  • Transition index-based information generation method and apparatus, and electronic device

    CN119477485A