CN112860709A - Service index query method, device, equipment and storage medium - Google Patents
Service index query method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112860709A CN112860709A CN202110286983.XA CN202110286983A CN112860709A CN 112860709 A CN112860709 A CN 112860709A CN 202110286983 A CN202110286983 A CN 202110286983A CN 112860709 A CN112860709 A CN 112860709A
- Authority
- CN
- China
- Prior art keywords
- index
- service
- basic
- data
- query
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 78
- 238000012545 processing Methods 0.000 claims abstract description 67
- 238000004364 calculation method Methods 0.000 claims description 107
- 238000012216 screening Methods 0.000 claims description 26
- 238000013500 data storage Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 7
- 238000011161 development Methods 0.000 description 6
- 238000010276 construction Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000006243 chemical reaction Methods 0.000 description 4
- 230000001186 cumulative effect Effects 0.000 description 4
- 238000012217 deletion Methods 0.000 description 4
- 230000037430 deletion Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000001914 filtration Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 2
- 235000019800 disodium phosphate Nutrition 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000004931 aggregating effect Effects 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 239000002184 metal Substances 0.000 description 1
- 230000000087 stabilizing effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a service index query method, a service index query device, service index query equipment and a storage medium, and relates to the technical field of data processing. The method comprises the following steps: acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises the following steps: service indexes to be inquired; basic index data corresponding to the business index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the business indexes to be queried; and determining the service index data corresponding to the service index to be inquired according to the basic index data. The scheme can effectively improve the reliability of the service index query system, thereby improving the accuracy of service index query under the condition of variable service requirements.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for querying a service index.
Background
With the continuous development of big data technology, business log data are collected from a business system, and various business indexes of the business system can be calculated through data integration analysis, so that certain guidance is provided for the development and operation of business.
At present, the existing service index calculation method calculates service index data by using basic index data acquired according to service log data, stores the calculated service index data in a database, and queries corresponding service index data from the database based on a service index query request of a user to display the service index data to the user.
However, in the above method, when the service index query requirement is variable, the accuracy of the service index query is poor.
Disclosure of Invention
An object of the present application is to provide a method, an apparatus, a device and a storage medium for querying a service index, so as to solve the problem in the prior art that the accuracy of querying the service index is poor when the service query requirement is variable.
In order to achieve the above purpose, the technical solutions adopted in the embodiments of the present application are as follows:
in a first aspect, an embodiment of the present application provides a service index query method, which is applied to a service index query system, where the service index query system includes: the method comprises the following steps:
acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises: service indexes to be inquired;
basic index data corresponding to the service index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the service indexes to be queried;
and determining the service index data corresponding to the service index to be inquired according to the basic index data.
Optionally, the retrieving, from a database of the task processing system, basic index data corresponding to the service index query request includes:
determining a target basic index corresponding to the business index to be queried according to the business index to be queried and a dependency relationship between the business index and the basic index which is pre-constructed by the task processing system;
and calling basic index data corresponding to the target basic index from a database of the task processing system, and taking the basic index data as basic index data corresponding to the service index query request.
Optionally, the task processing system is constructed in the following manner:
constructing a service index of a target service state under a target service type;
constructing an index query data table model according to each service index, wherein the index query data table model is used for indicating that basic indexes corresponding to each service index are stored according to a preset data storage format;
constructing a basic index calculation task, wherein the basic index calculation task is used for calculating basic index data corresponding to the basic index according to the dependency relationship between the basic index and a data source table; the data source table is determined according to the log data of the target service type;
and constructing the task processing system according to the basic index calculation task and the index query data table model.
Optionally, before constructing the index query data table model according to each service index, the method further includes:
and declaring the screening conditions corresponding to the service indexes, wherein each screening condition corresponds to one storage field.
Optionally, the constructing an index query data table model according to each service index includes:
splitting each service index according to a preset splitting condition to obtain a basic index;
constructing a dependency relationship between each service index and each basic index;
and establishing a corresponding relation between each basic index and the screening condition to obtain the index query data table model.
Optionally, the basic index data corresponding to the basic index has a preset data format, where the preset data format includes: the index naming format of the basic index data and the data format of the basic index data.
Optionally, the constructing a basic index calculation task includes:
constructing a dependency relationship between each basic index and a data source table to obtain an initial basic index calculation task;
and optimizing the initial basic index calculation task according to the dependency relationship to obtain the basic index calculation task.
Optionally, the constructing a dependency relationship between each basic index and the data source table to obtain an initial basic index calculation task includes:
determining a basic computing element corresponding to each basic index;
determining a data source table corresponding to each basic computing element;
and constructing a dependency relationship between each basic index and the data source table corresponding to the basic calculation element corresponding to each basic index to obtain an initial basic index calculation task.
Optionally, the optimizing the initial basic index calculation task according to the dependency relationship to obtain the basic index calculation task includes:
and combining different basic index calculation tasks with the same data source table according to the dependency relationship to obtain the basic index calculation task.
In a second aspect, an embodiment of the present application further provides a service index querying device, which is applied to a service index querying system, where the service index querying system includes: business system and task processing system, the device includes: the device comprises an acquisition module, a calling module and a determining module;
the acquiring module is used for acquiring a service index query request initiated by a user based on a client of a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises: service indexes to be inquired;
the retrieval module is used for retrieving basic index data corresponding to the service index query request from a database of the task processing system, wherein the basic index corresponding to the basic index data is used for representing basic elements forming the service index to be queried;
and the determining module is used for determining the service index data corresponding to the service index to be inquired according to the basic index data.
Optionally, the invoking module is specifically configured to determine a target basic index corresponding to the service index to be queried according to the service index to be queried and a dependency relationship between a service index and a basic index that is pre-constructed by the task processing system; and calling basic index data corresponding to the target basic index from a database of the task processing system, and taking the basic index data as basic index data corresponding to the service index query request.
Optionally, the apparatus further comprises: building a module;
the construction module is used for constructing a service index of a target service state under a target service type;
constructing an index query data table model according to each service index, wherein the index query data table model is used for indicating that basic indexes corresponding to each service index are stored according to a preset data storage format; constructing a basic index calculation task, wherein the basic index calculation task is used for calculating basic index data corresponding to the basic index according to the dependency relationship between the basic index and a data source table; the data source table is determined according to the log data of the target service type; and constructing the task processing system according to the basic index calculation task and the index query data table model.
Optionally, the apparatus further comprises: a declaration module;
the declaration module is used for declaring the screening conditions corresponding to the service indexes, and each screening condition corresponds to one storage field.
Optionally, the building module is specifically configured to split each of the service indicators according to a preset splitting condition to obtain a basic indicator; constructing a dependency relationship between each service index and each basic index; and establishing a corresponding relation between each basic index and the screening condition to obtain the index query data table model.
Optionally, the basic index data corresponding to the basic index has a preset data format, where the preset data format includes: the index naming format of the basic index data and the data format of the basic index data.
Optionally, the building module is specifically configured to build a dependency relationship between each basic index and a data source table, so as to obtain an initial basic index calculation task; and optimizing the initial basic index calculation task according to the dependency relationship to obtain the basic index calculation task.
Optionally, the building module is specifically configured to determine a basic computing element corresponding to each of the basic indexes; determining a data source table corresponding to each basic computing element; and constructing a dependency relationship between each basic index and the data source table corresponding to the basic calculation element corresponding to each basic index to obtain an initial basic index calculation task.
Optionally, the building module is specifically configured to combine different basic index calculation tasks having a dependency relationship with the same data source table according to the dependency relationship, so as to obtain the basic index calculation task.
In a third aspect, an embodiment of the present application provides an electronic device, including: a processor, a storage medium and a bus, the storage medium storing machine-readable instructions executable by the processor, the processor and the storage medium communicating via the bus when the electronic device is running, the processor executing the machine-readable instructions to perform the steps of the service indicator query method as provided in the first aspect.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, where the storage medium stores a computer program, and the computer program is executed by a processor to perform the steps of the service index query method according to the first aspect.
The beneficial effect of this application is:
the application provides a service index query method, a device, equipment and a storage medium, wherein the method comprises the following steps: acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises the following steps: service indexes to be inquired; basic index data corresponding to the business index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the business indexes to be queried; and determining the service index data corresponding to the service index to be inquired according to the basic index data. In the method, basic index data forming the service index is directly stored in a database of the task processing system, so that when the service index is calculated, the basic index data can be inquired from the database of the task processing system according to a service index inquiry request, and the service index to be inquired can be calculated and obtained at a service system layer according to the relation between the service index and the basic index. Compared with the prior art, the method and the device have the advantages that the service index data which is calculated in advance is stored in the database of the task processing system, so that the corresponding service index can be directly obtained according to the query request, in the scheme, the basic index data which form the service index are stored in the database, when the requirement of the service system changes and a new service index is added, the database does not need to be greatly changed, the newly added service index data can be obtained by obtaining the basic index data corresponding to the newly added service index from the database and calculating in real time, the condition that the newly added service index cannot be queried when the service requirement changes due to the fact that the service index is directly stored in the database is effectively avoided, the reliability of the service index query system is effectively improved, and the accuracy of querying the service index is improved under the condition that the service requirement is changeable.
And secondly, storing basic indexes in a database, wherein the service indexes are obtained by self calculation of a service system layer, deletion and modification of the service indexes occur in the service system layer, new calculation tasks and new basic indexes can be added again only under the condition that the basic indexes cannot be combined, the database layer has small change, and the storage is stable.
In addition, when the service requirement changes, new service indexes are required to be added, or the conversion standard of the original indexes is changed, and the like, the new service indexes can be conveniently modified at a service system layer according to the basic indexes stored in the database, and the basic indexes can be reused and used for combining the new service indexes.
Finally, when the business index calculation logic of the business system layer changes, only the logic of the business system layer needs to be modified, the business index stored in the database does not need to be recalculated according to the conventional design, and the business development is more agile.
The following describes a device, an apparatus, a storage medium, and the like for executing the service index query method provided by the present application, and specific implementation processes and technical effects thereof are referred to above, and are not described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.
Fig. 1 is a schematic structural diagram of a service index query system according to an embodiment of the present application;
fig. 2 is a schematic flowchart of a service index query method according to an embodiment of the present application;
fig. 3 is a schematic flowchart of another service index query method according to an embodiment of the present application;
fig. 4 is a schematic flowchart of another service index query method according to an embodiment of the present application;
fig. 5 is a schematic flowchart of another service index query method according to an embodiment of the present application;
fig. 6 is a schematic flowchart of another service index query method according to an embodiment of the present application;
fig. 7 is a dependency topology diagram provided in an embodiment of the present application;
fig. 8 is a schematic flowchart of another service index query method according to an embodiment of the present application;
fig. 9 is a schematic diagram of a service index query apparatus according to an embodiment of the present application;
fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it should be understood that the drawings in the present application are for illustrative and descriptive purposes only and are not used to limit the scope of protection of the present application. Additionally, it should be understood that the schematic drawings are not necessarily drawn to scale. The flowcharts used in this application illustrate operations implemented according to some embodiments of the present application. It should be understood that the operations of the flow diagrams may be performed out of order, and steps without logical context may be performed in reverse order or simultaneously. One skilled in the art, under the guidance of this application, may add one or more other operations to, or remove one or more operations from, the flowchart.
In addition, the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present application without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that in the embodiments of the present application, the term "comprising" is used to indicate the presence of the features stated hereinafter, but does not exclude the addition of further features.
First, some noun terms that may be referred to in the present application are explained:
DW (Data Warehouse ): the data warehouse stores the states of the data at different time points, and the states of the same data information at different time points are reserved.
DWD (Data Warehouse Detail, Data Warehouse Detail layer): the data detail layer is an isolation layer between the business layer and the data warehouse, and is also a layer closest to data in the data source, data in the data source is loaded into the layer after ETL (Extract-Transform-Load), and the layer mainly solves the problems of data quality and data integrity.
DM (date mark, data body layer): and the data main layer is used for integrating and summarizing the service data of a certain theme domain to analyze and provide subsequent business query service.
Modeling Kimball dimensions: a data warehouse modeling methodology distinguishes facts and dimensions for specific services, and the modeling process is divided into: selecting a business process; declare a granularity; determining a dimension; and determining the fact four major steps.
And (4) index query: that is, the following is a service index, and the query index has a specific service meaning and is generally proposed and set by a demand party.
Basic indexes are as follows: the specific elements used to form the query index, such as the query index X, are obtained by (a + b) × c/d calculation from the basic indexes a, b, c and d, and the basic indexes may not have individual business meanings and therefore, generally cannot be directly queried.
Fig. 1 is a schematic structural diagram of a service index query system according to an embodiment of the present application, where the following service index query method provided in the present application is applied to the service index query system, and the service index query system may include: the service system comprises a client and a service database, the client is used for providing interaction for users, service log data of the service system are stored in the service database, the task processing system comprises a task processing unit and a database, the task processing unit can acquire the service log data from the service database of the service system, extract, convert and store the service log data into the database, and the database is used for storing basic index data generated after service log data integration processing.
The user inputs a service index query request based on the client, the task processing unit queries and acquires basic index data corresponding to the service index query request from the database according to the service index query request and returns the basic index data to the service system, and the service system calculates and obtains a service index to be queried according to the basic index data and displays a query result to the user through the client.
As will be described below with reference to a plurality of specific embodiments, the construction process of the task processing system in the service index query system is described, and the service index query method of the present application can be implemented based on the constructed task processing system.
Fig. 2 is a schematic flowchart of a service index query method according to an embodiment of the present application; the execution subject of the method can be a computer or a device such as a server, and as shown in fig. 2, the method can include:
s201, acquiring a service index query request initiated by a user based on a client of a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises: and (5) service indexes to be inquired.
The service index is usually some indexes set according to service requirements, and the service index can be used for evaluating the operation condition of a service system to a certain extent and quantifying the service state.
Optionally, the user may input a service index query request through a client of the service system, where the service index query request may include: service indexes to be inquired and preset screening conditions. For the same service index to be inquired, the corresponding inquiry results are different under different screening conditions, and the service index to be inquired can be more accurately positioned through the preset screening conditions so as to obtain more accurate inquiry results.
Optionally, since the service indexes corresponding to different service types may be different, the service index query request initiated by the user generally corresponds to a target service type, and each service type may have a plurality of service states, which may be understood as a service phase, taking a taxi service as an example, and may include different service states: passenger billing, driver order taking, order fulfillment, passenger evaluation, etc. Taking the game service as an example, the service state may include: player login, player running game, player recharge, etc. The service index query request initiated by the user can be used for querying the service index in the target service state under the target service type, so that refined query is realized.
S202, basic index data corresponding to the business index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the business indexes to be queried.
Optionally, based on the obtained service index query request, basic index data corresponding to the service index query request may be obtained by querying basic indexes pre-stored in a database of the task processing system.
Generally, the service index is obtained by calculating at least two basic indexes through a preset calculation formula, where the service index is: the payment rate is obtained by dividing two basic indexes of the payment headcount and the headcount.
S203, determining the service index data corresponding to the service index to be inquired according to the basic index data.
Optionally, based on the basic index data corresponding to the service index query request obtained by the query, the service index data corresponding to the service index to be queried may be determined according to a predefined calculation formula between the service index and the basic index.
In summary, the service index query method provided in this embodiment includes: acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises the following steps: service indexes to be inquired; basic index data corresponding to the business index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the business indexes to be queried; and determining the service index data corresponding to the service index to be inquired according to the basic index data. In the method, basic index data forming the service index is directly stored in a database of the task processing system, so that when the service index is calculated, the basic index data can be inquired from the database of the task processing system according to a service index inquiry request, and the service index to be inquired can be calculated and obtained at a service system layer according to the relation between the service index and the basic index. Compared with the prior art, the method and the device have the advantages that the service index data which is calculated in advance is stored in the database of the task processing system, so that the corresponding service index can be directly obtained according to the query request, in the scheme, the basic index data which form the service index are stored in the database, when the requirement of the service system changes and a new service index is added, the database does not need to be greatly changed, the newly added service index data can be obtained by obtaining the basic index data corresponding to the newly added service index from the database and calculating in real time, the condition that the newly added service index cannot be queried when the service requirement changes due to the fact that the service index is directly stored in the database is effectively avoided, the reliability of the service index query system is effectively improved, and the accuracy of querying the service index is improved under the condition that the service requirement is changeable.
Fig. 3 is a schematic flowchart of another service index query method according to an embodiment of the present application; optionally, in step S202, retrieving basic index data corresponding to the service index query request from a database of the task processing system may include:
s301, determining a target basic index corresponding to the business index to be queried according to the business index to be queried and the dependency relationship between the business index and the basic index pre-constructed by the task processing system.
In some realizable manners, a dependency relationship between the service index and the basic index is pre-constructed in the task processing system, and the dependency relationship is used for representing the basic index corresponding to the service index, namely representing the basic index used for forming the service index.
Optionally, the basic index corresponding to the service index to be queried may be determined according to the service index to be queried included in the service index query request and according to the dependency relationship between the service index and the basic index.
S302, basic index data corresponding to the target basic index are called from a database of the task processing system, and the basic index data are used as basic index data corresponding to the service index query request.
Optionally, the basic index data of the basic index is obtained from the database based on the basic index corresponding to the determined business index to be queried, where the basic index data is also the specific numerical value corresponding to the basic index. And the obtained basic index data is used as the basic index data corresponding to the service index query request and is used for calculating to obtain the service index data to be queried.
Optionally, in the method of the present application, the basic index is stored in the database, the service system obtains the basic index data from the task processing system to perform calculation of the service index, the service index is calculated by the service system layer, deletion and modification of the service index occur in the service system layer, and a new calculation task and a new basic index are added again only when the basic index cannot be combined, the database layer has a small change and is stored stably.
When the service requirement changes, new service indexes are required to be added, or the conversion standard of the original indexes is changed, and the like, the new service indexes can be conveniently modified on a service system layer according to the basic indexes stored in the database, and the basic indexes can be reused and used for combining the new service indexes.
When the business index calculation logic of the business system layer changes, only the logic of the business system layer needs to be modified, the business index stored in the database does not need to be recalculated according to the conventional design, and the business development is more agile.
Fig. 4 is a schematic flowchart of another service index query method according to an embodiment of the present application; optionally, the task processing system in the above steps may be constructed in the following manner:
s401, constructing a service index of the target service state under the target service type.
Optionally, a target service state in the target type may be determined first, so as to construct a plurality of service indicators in the service state according to the determined service state. The plurality of service indexes in the service state can be designed according to service requirements, and the plurality of service indexes can cover and quantify all service indexes in the service state in the maximum sense.
In addition, each service index can be divided into a plurality of theme fields according to each constructed service index and the type of each service index, and each service index is classified under a corresponding theme. Taking a game service as an example, the theme zone may include: each theme field represents a theme classification, so that the business index can be inquired in the corresponding theme field, and the inquiry accuracy of the business index is improved.
S402, constructing an index query data table model according to each service index, wherein the index query data table model is used for indicating that basic indexes corresponding to each service index are stored according to a preset data storage format.
Optionally, the index query data table model is also a model for storing the basic index, and the data storage type and the data storage mode of the database in the task processing system may be defined by constructing the index query data table model, that is, the data stored in the database is stored according to the constructed index query data table model.
For example, the following steps are carried out: the assumed basic indexes are: cumulative payments, the user may view cumulative payments at different times, each viewing being a calculation for the computer, the cumulative payments seen at 9 being different from the cumulative payments seen at 10. If the accumulated payment is inquired each time, all payment amount in the data source table needs to be added once, the calculation performance is consumed, the basic index of the accumulated payment can be directly stored in the database by designing the index inquiry data table model, and therefore when the basic index is used, the basic index can be directly inquired from the database for use.
S403, constructing a basic index calculation task, wherein the basic index calculation task is used for calculating to obtain basic index data corresponding to basic indexes according to the dependency relationship between the basic indexes and the data source table; and the data source table is determined according to the log data of the target service type.
Optionally, by constructing a basic index calculation task, the constructed basic index calculation task may be utilized to obtain the basic index by calculating the service log data of the service system, that is, by constructing the basic index calculation task, the specific calculation mode of each basic index may be determined, so that the basic index is calculated and stored in the database.
The data source table is generated according to the service log data, for example, a log is generated when a player logs in a game, a data source table corresponding to the log is loaded in a field related to the log, a payment log is generated when the player pays, and a data source table corresponding to the payment log is loaded in a field related to the payment log.
The basic index can be calculated according to the service log data, and the basic index data corresponding to the basic index can be calculated according to the dependency relationship between the basic index and the data source table by constructing a basic index calculation task.
S404, a task processing system is constructed according to the basic index calculation task and the index query data table model.
Optionally, a task processing system may be constructed according to the constructed basic index calculation task and the index query data table model, the task processing system may calculate the task according to the basic index, and obtain basic index data by calculation according to the dependency relationship between the basic index and the data source table, and query the data table model according to the index, and store the calculated basic index data in a database, so as to retrieve the basic index data in real time in the service index query.
Optionally, the service index query system obtained based on the task processing system constructed by the method of the present application may have the following advantages:
and (3) stabilizing: the basic indexes are stored in the database, the service indexes are calculated by the service system layer, the deletion of the service indexes is carried out in the service system layer, new calculation tasks and new basic indexes are added again only under the condition that the basic indexes cannot be combined, the database layer is small in change, and the storage is stable.
The expansibility is good: when the service requirement changes, new service indexes are required to be added, or the conversion standard of the original indexes is changed, and the like, the new service indexes can be conveniently modified on a service system layer according to the basic indexes stored in the database, and the basic indexes can be reused and used for combining the new service indexes.
Agility: when the business index calculation logic of the business system layer changes, only the logic of the business system layer needs to be modified, the business index stored in the database does not need to be recalculated according to the conventional design, and the business development is more agile.
Optionally, in step S402, before constructing the index query data table model according to each service index, the method of the present application may further include: and declaring the screening conditions corresponding to the service indexes, wherein each screening condition corresponds to one storage field.
Optionally, the statement screening condition may also be understood as a minimum granularity of presentation of the statement service indicator, such as: for a service index, which is a certain day of a certain test belonging to a certain game, the combination of game, test id, and date is the minimum granularity of the service index.
Optionally, each filtering condition may be included in a dimension field of the database, that is, a storage field in the corresponding database, so that when the basic index data is stored in the database, corresponding storage may be performed under each storage field, so as to improve the query efficiency of the basic index.
Fig. 5 is a schematic flowchart of another service index query method according to an embodiment of the present application; optionally, in step S402, constructing an index query data table model according to each service index may include:
s501, splitting each service index according to a preset splitting condition to obtain a basic index.
In the above steps, the service indexes are constructed, and in this embodiment, different basic indexes can be split from each service index according to a preset splitting condition.
Optionally, the preset splitting condition may be: each basic index obtained by splitting can be obtained by filtering and aggregating calculation of a single data source table.
S502, establishing a dependency relationship between each business index and each basic index.
Before this, although it can be known which of the service indexes and the basic indexes are included, the dependency relationship between each service index and each basic index is not known, and then the basic index required by each service index can be constructed, and the dependency relationship between each service index and the basic index can be constructed.
S503, establishing a corresponding relation between each basic index and the screening condition to obtain an index query data table model.
In addition, as described above, each basic index is correspondingly stored in the storage field of each screening condition, and then, a corresponding relationship between each basic index and each screening condition may also be established, so that the index lookup data table model is obtained according to the dependency relationship between the service index and the basic index and the dependency relationship between the basic index and the screening condition.
It should be noted that, storing the basic index in the storage field corresponding to the screening condition can efficiently and accurately obtain the required basic index, for example: the basic index is the total number of paid people, and when the service index query request input by the user comprises the following steps: service indexes to be inquired are as follows: paying rate and screening conditions: no. 1/20, the basic indexes required to be obtained from the database comprise the total number of paid people, if a storage mode that the basic indexes are correspondingly stored under the screening condition is not adopted, the total number of paid people obtained from the database can be all the total number of paid people so far, but not the total number of paid people of No. 1/20, and therefore when the business index to be inquired is calculated according to the basic indexes, the calculation result is wrong.
Optionally, the basic index data corresponding to the basic index has a preset data format, where the preset data format includes: the index naming format of the basic index data and the data format of the basic index data.
In an implementation manner, the basic index data stored in the database needs to be stored according to a preset data format, so that the specification of the index definition is realized.
Optionally, the preset data format may include: the index naming format of the basic index data and the data format of the basic index data. The method specifically comprises the following steps: synonyms, units are consistent, structured naming and the like.
Wherein, synonyms are synonymous: the terms representing ratios are collectively described as "ratio," "rate," and the like with a fixed suffix.
The units are consistent: all the units representing the ratio need to be unified, such as all the original decimal values are stored, or all the decimal values are stored as numerical values expanded by 100%, so that the probability of operation errors can be reduced when the basic index is used elsewhere.
Structural naming: the naming format of the basic index is unified, such as the field event specific meaning, for example, the recommendation success rate, the meaning of the basic index and the generation scene thereof are expressed as much as possible, and the user understanding cost is reduced.
Of course, in actual design, the preset data format is not limited to the above listed ones, and the format requirement may be set from other aspects.
Fig. 6 is a schematic flowchart of another service index query method according to an embodiment of the present application; fig. 7 is a dependency topology diagram provided in an embodiment of the present application. Optionally, in step S403, constructing a basic index calculation task may include:
s601, establishing a dependency relationship between each basic index and the data source table to obtain an initial basic index calculation task.
In some embodiments, the dependency relationship between each basic index and the data source table may be constructed first, and how to filter and aggregate each basic index is obtained is determined, as shown in fig. 7, a topological ranking graph from the data source table to the basic index is drawn, and each step of calculation should be encapsulated into a basic task node to obtain an initial basic index calculation task.
And S602, optimizing the initial basic index calculation task according to the dependency relationship to obtain a basic index calculation task.
Optionally, since the calculation tasks of some basic indexes correspond to the same data source table, the calculation tasks of the indexes of the same filtering and aggregation granularity may be merged to optimize the overall calculation task flow, so as to obtain the basic index calculation tasks. The optimized topological sorted diagram can also be understood with reference to fig. 7. By optimizing the basic index calculation task, the calculation efficiency of the basic index can be improved, and therefore the calculation efficiency of the service index is improved.
Fig. 8 is a schematic flowchart of another service index query method according to an embodiment of the present application; optionally, in step S601, constructing a dependency relationship between each basic index and the data source table to obtain an initial basic index calculation task, which may include:
s801, determining basic computing elements corresponding to the basic indexes.
S802, determining a data source table corresponding to each basic computing element.
Optionally, the basic computing element of the basic index is also the smallest element constituting the basic index, and in the case that the basic index is the total number of players, the corresponding basic computing element may be the number of players, and the number of players may be correspondingly pulled from a data source table recording the number of online players of the game, and the total number of players may be determined according to a piece of log information in the data source table. And for the basic index as the payment headcount, the corresponding basic calculation element can be payment, and the payment data of each player can be pulled from the data source table of the game payment data corresponding to the payment, so that the payment headcount and the like are integrated.
S803, establishing the dependency relationship between each basic index and the data source table corresponding to the basic calculation element corresponding to each basic index to obtain an initial basic index calculation task.
Optionally, based on the above analysis, the dependency relationship between the base indicator and the data source table may be determined, thereby obtaining an initial base indicator calculation task.
Optionally, in step S602, optimizing the initial basic index calculation task according to the dependency relationship to obtain a basic index calculation task, which may include: and combining different basic index calculation tasks with the same data source table according to the dependency relationship to obtain the basic index calculation task.
Taking the topological graph shown in fig. 7 as an example, the basic index can be obtained according to the drawn initial basic index calculation task: the payment total number and the payment total amount correspond to the same data source table, namely correspond to the payment data source table, so that the calculation tasks of the payment total number and the payment total amount can be integrated to obtain the optimized topological graph.
For example: for the calculation of the total number of paid persons and the total amount of paid money, if the calculation is carried out according to the initial basic index calculation task, the total number of paid persons and the total amount of paid money are calculated respectively by reading data from the paid data source table twice and reading the data from the paid data source table in sequence. And by optimizing the initial basic index calculation task and calculating according to the optimized basic index calculation task, the calculation tasks of the total number of paid people and the total amount of paid money can be combined, and the calculation of the two basic indexes is completed by reading data once, so that the calculation efficiency is improved.
To sum up, the service index query method provided by the embodiment of the present application includes: acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises the following steps: service indexes to be inquired and preset screening conditions; basic index data corresponding to the business index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the business indexes to be queried; and determining the service index data corresponding to the service index to be inquired according to the basic index data. In the method, basic index data forming the service index is directly stored in a database of the task processing system, so that when the service index is calculated, the basic index data can be inquired from the database of the task processing system according to a service index inquiry request, and the service index to be inquired can be calculated and obtained at a service system layer according to the relation between the service index and the basic index. Compared with the prior art, the method and the device have the advantages that the service index data which is calculated in advance is stored in the database of the task processing system, so that the corresponding service index can be directly obtained according to the query request, in the scheme, the basic index data which form the service index are stored in the database, when the requirement of the service system changes and a new service index is added, the database does not need to be greatly changed, the newly added service index data can be obtained by obtaining the basic index data corresponding to the newly added service index from the database and calculating in real time, the condition that the newly added service index cannot be queried when the service requirement changes due to the fact that the service index is directly stored in the database is effectively avoided, the reliability of the service index query system is effectively improved, and the accuracy of querying the service index is improved under the condition that the service requirement is changeable.
And secondly, storing basic indexes in a database, wherein the service indexes are obtained by self calculation of a service system layer, deletion and modification of the service indexes occur in the service system layer, new calculation tasks and new basic indexes can be added again only under the condition that the basic indexes cannot be combined, the database layer has small change, and the storage is stable.
In addition, when the service requirement changes, new service indexes are required to be added, or the conversion standard of the original indexes is changed, and the like, the new service indexes can be conveniently modified at a service system layer according to the basic indexes stored in the database, and the basic indexes can be reused and used for combining the new service indexes.
Finally, when the business index calculation logic of the business system layer changes, only the logic of the business system layer needs to be modified, the business index stored in the database does not need to be recalculated according to the conventional design, and the business development is more agile.
The following describes a device, an apparatus, a storage medium, and the like for executing the service index query method provided by the present application, and specific implementation processes and technical effects thereof are referred to above, and are not described in detail below.
Fig. 9 is a schematic diagram of a service index query device according to an embodiment of the present application, where functions implemented by the service index query device correspond to steps executed by the foregoing method. Optionally, the apparatus may comprise: an acquisition module 910, a calling module 920 and a determining module 930;
an obtaining module 910, configured to obtain a service index query request initiated by a user based on a client of a service system, where the service index query request is used to query a service index of a target service state under a target service type, and the service index query request includes: service indexes to be inquired;
the retrieving module 920 is configured to retrieve basic index data corresponding to the service index query request from a database of the task processing system, where the basic index corresponding to the basic index data is used to represent basic elements constituting a service index to be queried;
the determining module 930 is configured to determine, according to the basic index data, service index data corresponding to the service index to be queried.
Optionally, the invoking module 920 is specifically configured to determine a target basic index corresponding to the service index to be queried according to the service index to be queried and a dependency relationship between the service index and the basic index that is pre-constructed by the task processing system; and basic index data corresponding to the target basic index is called from a database of the task processing system, and the basic index data is used as basic index data corresponding to the service index query request.
Optionally, the apparatus further comprises: building a module;
the construction module is used for constructing a service index of a target service state under the target service type;
constructing an index query data table model according to each service index, wherein the index query data table model is used for indicating that basic indexes corresponding to each service index are stored according to a preset data storage format; constructing a basic index calculation task, wherein the basic index calculation task is used for calculating to obtain basic index data corresponding to basic indexes according to the dependency relationship between the basic indexes and the data source table; the data source table is determined according to the log data of the target service type; and constructing a task processing system according to the basic index calculation task and the index query data table model.
Optionally, the apparatus further comprises: a declaration module;
and the declaration module is used for declaring the screening conditions corresponding to the service indexes, and each screening condition corresponds to one storage field.
Optionally, the construction module is specifically configured to split each service index according to a preset splitting condition to obtain a basic index; constructing a dependency relationship between each service index and each basic index; and establishing a corresponding relation between each basic index and the screening condition to obtain an index query data table model.
Optionally, the basic index data corresponding to the basic index has a preset data format, where the preset data format includes: the index naming format of the basic index data and the data format of the basic index data.
Optionally, the building module is specifically configured to build a dependency relationship between each basic index and the data source table to obtain an initial basic index calculation task; and optimizing the initial basic index calculation task according to the dependency relationship to obtain the basic index calculation task.
Optionally, the construction module is specifically configured to determine a basic computing element corresponding to each basic index; determining a data source table corresponding to each basic computing element; and constructing a dependency relationship between each basic index and the data source table corresponding to the basic computing element corresponding to each basic index to obtain an initial basic index computing task.
Optionally, the building module is specifically configured to combine different basic index calculation tasks having a dependency relationship with the same data source table according to the dependency relationship, so as to obtain a basic index calculation task.
The above-mentioned apparatus is used for executing the method provided by the foregoing embodiment, and the implementation principle and technical effect are similar, which are not described herein again.
These above modules may be one or more integrated circuits configured to implement the above methods, such as: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a Processing element scheduler code, the Processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
The modules may be connected or in communication with each other via a wired or wireless connection. The wired connection may include a metal cable, an optical cable, a hybrid cable, etc., or any combination thereof. The wireless connection may comprise a connection over a LAN, WAN, bluetooth, ZigBee, NFC, or the like, or any combination thereof. Two or more modules may be combined into a single module, and any one module may be divided into two or more units. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the system and the apparatus described above may refer to corresponding processes in the method embodiments, and are not described in detail in this application.
It should be noted that the above modules may be one or more integrated circuits configured to implement the above methods, for example: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a Processing element scheduler code, the Processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, the modules may be integrated together and implemented in the form of a System-on-a-chip (SOC).
Fig. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present application, where the electronic device may be a computing device with a data processing function.
The apparatus may include: a processor 801 and a memory 802.
The memory 802 is used for storing programs, and the processor 801 calls the programs stored in the memory 802 to execute the above-mentioned method embodiments. The specific implementation and technical effects are similar, and are not described herein again.
The memory 802 stores therein program code, which, when executed by the processor 801, causes the processor 801 to perform various steps in the service index querying method according to various exemplary embodiments of the present application described in the above section "exemplary method" of the present specification.
The Processor 801 may be a general-purpose Processor, such as a Central Processing Unit (CPU), a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware components, and may implement or execute the methods, steps, and logic blocks disclosed in the embodiments of the present Application. A general purpose processor may be a microprocessor or any conventional processor or the like. The steps of a method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware processor, or may be implemented by a combination of hardware and software modules in a processor.
Optionally, the present application also provides a program product, such as a computer readable storage medium, comprising a program which, when being executed by a processor, is adapted to carry out the above-mentioned method embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to perform some steps of the methods according to the embodiments of the present application. And the aforementioned storage medium includes: a U disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Claims (12)
1. A service index query method is applied to a service index query system, and the service index query system comprises: the method comprises the following steps:
acquiring a service index query request initiated by a client based on a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises: service indexes to be inquired;
basic index data corresponding to the service index query request are called from a database of the task processing system, and basic indexes corresponding to the basic index data are used for representing basic elements forming the service indexes to be queried;
and determining the service index data corresponding to the service index to be inquired according to the basic index data.
2. The method according to claim 1, wherein the retrieving of the basic index data corresponding to the service index query request from the database of the task processing system comprises:
determining a target basic index corresponding to the business index to be queried according to the business index to be queried and a dependency relationship between the business index and the basic index which is pre-constructed by the task processing system;
and calling basic index data corresponding to the target basic index from a database of the task processing system, and taking the basic index data as basic index data corresponding to the service index query request.
3. The method of claim 1, wherein the task processing system is constructed by:
constructing a service index of a target service state under a target service type;
constructing an index query data table model according to each service index, wherein the index query data table model is used for indicating that basic indexes corresponding to each service index are stored according to a preset data storage format;
constructing a basic index calculation task, wherein the basic index calculation task is used for calculating basic index data corresponding to the basic index according to the dependency relationship between the basic index and a data source table; the data source table is determined according to the log data of the target service type;
and constructing the task processing system according to the basic index calculation task and the index query data table model.
4. The method of claim 3, wherein before constructing the index lookup data table model based on each of the business indexes, the method further comprises:
and declaring the screening conditions corresponding to the service indexes, wherein each screening condition corresponds to one storage field.
5. The method of claim 4, wherein constructing an index look-up table model based on each of the business indexes comprises:
splitting each service index according to a preset splitting condition to obtain a basic index;
constructing a dependency relationship between each service index and each basic index;
and establishing a corresponding relation between each basic index and the screening condition to obtain the index query data table model.
6. The method according to claim 5, wherein the base indicator data corresponding to the base indicator has a preset data format, and the preset data format includes: the index naming format of the basic index data and the data format of the basic index data.
7. The method of claim 5 or 6, wherein the building a base index calculation task comprises:
constructing a dependency relationship between each basic index and a data source table to obtain an initial basic index calculation task;
and optimizing the initial basic index calculation task according to the dependency relationship to obtain the basic index calculation task.
8. The method of claim 7, wherein the constructing the dependency relationship between each of the basic indicators and the data source table to obtain an initial basic indicator calculation task comprises:
determining a basic computing element corresponding to each basic index;
determining a data source table corresponding to each basic computing element;
and constructing a dependency relationship between each basic index and the data source table corresponding to the basic calculation element corresponding to each basic index to obtain an initial basic index calculation task.
9. The method according to claim 7, wherein the optimizing the initial base index calculation task according to the dependency relationship to obtain the base index calculation task comprises:
and combining different basic index calculation tasks with the same data source table according to the dependency relationship to obtain the basic index calculation task.
10. A service index query device is applied to a service index query system, and the service index query system comprises: business system and task processing system, the device includes: the device comprises an acquisition module, a calling module and a determining module;
the acquiring module is used for acquiring a service index query request initiated by a user based on a client of a service system, wherein the service index query request is used for querying a service index of a target service state under a target service type, and the service index query request comprises: service indexes to be inquired;
the retrieval module is used for retrieving basic index data corresponding to the service index query request from a database of the task processing system, wherein the basic index corresponding to the basic index data is used for representing basic elements forming the service index to be queried;
and the determining module is used for determining the service index data corresponding to the service index to be inquired according to the basic index data.
11. An electronic device, comprising: a processor, a storage medium and a bus, wherein the storage medium stores program instructions executable by the processor, the processor and the storage medium communicate with each other through the bus when the electronic device runs, and the processor executes the program instructions to execute the steps of the service index query method according to any one of claims 1 to 9.
12. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when being executed by a processor, performs the steps of the service indicator query method according to any one of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110286983.XA CN112860709A (en) | 2021-03-17 | 2021-03-17 | Service index query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110286983.XA CN112860709A (en) | 2021-03-17 | 2021-03-17 | Service index query method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112860709A true CN112860709A (en) | 2021-05-28 |
Family
ID=75995116
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110286983.XA Pending CN112860709A (en) | 2021-03-17 | 2021-03-17 | Service index query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112860709A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113434524A (en) * | 2021-06-24 | 2021-09-24 | 江苏创源电子有限公司 | Data integration method and device, electronic equipment and storage medium |
| CN113505142A (en) * | 2021-07-08 | 2021-10-15 | 中电金信软件有限公司 | Data query method and device and server |
| CN113990068A (en) * | 2021-10-27 | 2022-01-28 | 阿波罗智联(北京)科技有限公司 | Traffic data processing method, device, equipment and storage medium |
| CN114356965A (en) * | 2022-03-18 | 2022-04-15 | 杭州湖畔网络技术有限公司 | Dynamic form generation method, system, server and storage medium |
| CN115879825A (en) * | 2023-01-30 | 2023-03-31 | 中化现代农业有限公司 | Index management method, system, device and storage medium |
| CN117149896A (en) * | 2023-10-31 | 2023-12-01 | 宁德时代新能源科技股份有限公司 | Data display method, device, equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106875110A (en) * | 2017-02-06 | 2017-06-20 | 泰康保险集团股份有限公司 | Operational indicator layered calculation method and device, distributed computing method and system |
| CN108628894A (en) * | 2017-03-21 | 2018-10-09 | 阿里巴巴集团控股有限公司 | Data target querying method in data warehouse and device |
| CN110837519A (en) * | 2019-11-18 | 2020-02-25 | 北京明略软件系统有限公司 | Index data management method and device, electronic equipment and machine-readable storage medium |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN112053058A (en) * | 2020-09-02 | 2020-12-08 | 平安银行股份有限公司 | Index model generation method and device |
| CN112330227A (en) * | 2020-12-04 | 2021-02-05 | 城云科技（中国）有限公司 | Urban management capability evaluation method and system based on digital urban management service construction |
| CN112347144A (en) * | 2021-01-04 | 2021-02-09 | 树根互联技术有限公司 | Service index query method and device and server |
| CN112418721A (en) * | 2020-12-08 | 2021-02-26 | 中国建设银行股份有限公司 | Index determination method and device |
-
2021
- 2021-03-17 CN CN202110286983.XA patent/CN112860709A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106875110A (en) * | 2017-02-06 | 2017-06-20 | 泰康保险集团股份有限公司 | Operational indicator layered calculation method and device, distributed computing method and system |
| CN108628894A (en) * | 2017-03-21 | 2018-10-09 | 阿里巴巴集团控股有限公司 | Data target querying method in data warehouse and device |
| CN110837519A (en) * | 2019-11-18 | 2020-02-25 | 北京明略软件系统有限公司 | Index data management method and device, electronic equipment and machine-readable storage medium |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN112053058A (en) * | 2020-09-02 | 2020-12-08 | 平安银行股份有限公司 | Index model generation method and device |
| CN112330227A (en) * | 2020-12-04 | 2021-02-05 | 城云科技（中国）有限公司 | Urban management capability evaluation method and system based on digital urban management service construction |
| CN112418721A (en) * | 2020-12-08 | 2021-02-26 | 中国建设银行股份有限公司 | Index determination method and device |
| CN112347144A (en) * | 2021-01-04 | 2021-02-09 | 树根互联技术有限公司 | Service index query method and device and server |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113434524A (en) * | 2021-06-24 | 2021-09-24 | 江苏创源电子有限公司 | Data integration method and device, electronic equipment and storage medium |
| CN113505142A (en) * | 2021-07-08 | 2021-10-15 | 中电金信软件有限公司 | Data query method and device and server |
| CN113505142B (en) * | 2021-07-08 | 2022-06-24 | 中电金信软件有限公司 | Data query method and device and server |
| CN113990068A (en) * | 2021-10-27 | 2022-01-28 | 阿波罗智联(北京)科技有限公司 | Traffic data processing method, device, equipment and storage medium |
| CN113990068B (en) * | 2021-10-27 | 2023-02-24 | 阿波罗智联(北京)科技有限公司 | Traffic data processing method, device, equipment and storage medium |
| CN114356965A (en) * | 2022-03-18 | 2022-04-15 | 杭州湖畔网络技术有限公司 | Dynamic form generation method, system, server and storage medium |
| CN114356965B (en) * | 2022-03-18 | 2022-06-14 | 杭州湖畔网络技术有限公司 | Method, system, server and storage medium for generating dynamic form |
| CN115879825A (en) * | 2023-01-30 | 2023-03-31 | 中化现代农业有限公司 | Index management method, system, device and storage medium |
| CN117149896A (en) * | 2023-10-31 | 2023-12-01 | 宁德时代新能源科技股份有限公司 | Data display method, device, equipment and storage medium |
| CN117149896B (en) * | 2023-10-31 | 2024-03-26 | 宁德时代新能源科技股份有限公司 | Data display method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112860709A (en) | Service index query method, device, equipment and storage medium | |
| CN112256720B (en) | Data cost calculation method, system, computer device and storage medium | |
| US20230093059A1 (en) | Green cloud computing recommendation system | |
| CN104102670A (en) | Performance indicator analytical framework | |
| CN108491408B (en) | Activity information processing method and device, electronic equipment and storage medium | |
| CN111310032A (en) | Resource recommendation method and device, computer equipment and readable storage medium | |
| CN113204712A (en) | Information pushing method, device, medium and program product based on community service | |
| CN108428138A (en) | A kind of client's survival Analysis device and analysis method based on customer grouping | |
| US20140188657A1 (en) | Establishing Customer Attributes | |
| CN116225690A (en) | Memory multidimensional database calculation load balancing method and system based on docker | |
| KR102202231B1 (en) | Apparatus for Analyzing Geographic Information and Method thereof | |
| CN114647704A (en) | Service data processing method and related equipment | |
| CN115033456A (en) | Method and device for monitoring performance of front end of intranet, computer equipment and storage medium | |
| CN114925919A (en) | Service resource processing method and device, computer equipment and storage medium | |
| JP6204923B2 (en) | Assessment device, assessment system, assessment method, and program | |
| CN113743791A (en) | Business evaluation method and device for business work order, electronic equipment and medium | |
| CN114997109A (en) | Receipt conversion method and device, computer equipment and storage medium | |
| CN114490406A (en) | Test coverage item management method, device, equipment and medium | |
| CN113362174A (en) | Data comparison method, device, equipment and storage medium | |
| CN114818843A (en) | Data analysis method and device and computing equipment | |
| CN115017185A (en) | Data processing method, device and storage medium | |
| Planting | Developing a data repository for the Climate Adaptive City Enschede | |
| US9208224B2 (en) | Business content hierarchy | |
| CN110765118B (en) | Data revision method, revision device and readable storage medium | |
| US20220253774A1 (en) | Implementing big data and artificial intelligence to determine likelihood of post-acceptance facility or service renunciation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210528 |