CN117807084A

CN117807084A - Verification method for index configuration data and related equipment

Info

Publication number: CN117807084A
Application number: CN202311800734.3A
Authority: CN
Inventors: 周育彬; 李锋
Original assignee: BOE Technology Group Co Ltd
Current assignee: BOE Technology Group Co Ltd
Priority date: 2023-12-25
Filing date: 2023-12-25
Publication date: 2024-04-02

Abstract

The application provides a verification method and related equipment for index configuration data, wherein index configuration data aiming at a first index is obtained, a first index scale value of the first index is calculated according to the index configuration data, then a second index and service data related to the second index are obtained according to the first index, the service data are processed by the second index to generate a second index scale value of the second index, a comparison result capable of indicating the accuracy of the index configuration data can be obtained by comparing the first index scale value with the second index scale value, and then a corresponding verification result can be obtained according to the comparison result, so that data analysis by using more accurate index configuration data can be guaranteed, and influence on data analysis is avoided.

Description

Verification method for index configuration data and related equipment

Technical Field

The present disclosure relates to the field of data processing technologies, and in particular, to a method and related device for checking index configuration data.

Background

In the processing process of data analysis, the data center station is often required to rely on, and the data center station does not generate data, so that data source detection is required to be carried out, and the obtained index configuration data is accessed to the data center station.

Based on the above situation, the data source detection mode in the prior art needs to be manually matched and output, so that the accuracy of index configuration data cannot be ensured, and the data analysis can be influenced.

Disclosure of Invention

Accordingly, an objective of the present application is to provide a method and related device for checking index configuration data, which are used for solving the above-mentioned technical problems.

Based on the above object, a first aspect of the present application provides a method for checking index configuration data, including:

acquiring index configuration data aiming at a first index, and calculating a first index scale value of the first index according to the index configuration data;

acquiring a second index and service data associated with the second index according to the first index, and processing the service data by utilizing the second index to generate a second index value of the second index, wherein the second index is acquired from a target system and corresponds to the first index;

comparing the first index scale value with the second index scale value, generating a comparison result, and obtaining a verification result according to the comparison result.

Optionally, after obtaining a second index according to the first index and service data associated with the second index, the method further includes:

Performing format verification on the second index according to a preset index format to obtain a format verification result;

and responding to the format verification result that the format verification is passed, processing the service data by using the second index to generate a second index value of the second index.

Optionally, the obtaining the second index according to the first index includes:

determining an index path of a second index corresponding to the first index and an application program interface address corresponding to the index path, and determining a target application program interface according to the application program interface address;

and acquiring a second index from the target system through the target program interface according to the index path.

Optionally, the processing the service data with the second index to generate a second index value of the second index includes:

acquiring a screening condition enumeration value corresponding to the second index, wherein the screening condition enumeration value comprises a plurality of screening conditions and a screening condition field value corresponding to each screening condition;

receiving a selection instruction aiming at the enumeration value of the screening conditions, selecting at least one target screening condition from the plurality of screening conditions according to the selection instruction, and acquiring a target screening condition field value corresponding to the at least one target screening condition;

Calculating the service data based on the target screening condition field value to obtain a calculation result;

and synthesizing the target screening condition field value and the calculation result to generate a second index scale value of the second index.

Optionally, the acquiring the index configuration data for the first index includes:

writing initial index configuration data for the first index;

and carrying out quantization processing on the initial index configuration data according to a preset storage format to generate the index configuration data.

Optionally, the index configuration data includes a service data name corresponding to the first index, and arithmetic logic for calculating a first index scale value of the first index;

the calculating a first index scale value of the first index according to the index configuration data comprises:

acquiring a physical table field value of a service data name corresponding to the first index from a preset physical table;

performing de-duplication treatment on the physical table field value to obtain a physical table field value subjected to de-duplication;

and calculating the physical table field value subjected to the duplication elimination by utilizing the operation logic, and generating a first index scale value of the first index.

Optionally, the calculating, by using the arithmetic logic, the physical table field value subjected to the deduplication, to generate a first finger scale value of the first indicator, including:

splitting the first index to obtain a plurality of split indexes, and calling physical table field values corresponding to the split indexes from the physical table field values subjected to duplication removal;

and carrying out combination calculation on the physical table field values corresponding to the split indexes through a preset aggregation function to generate a first index scale value of the first index.

Optionally, the comparing the first finger scale value with the second finger scale value and generating a comparison result, and obtaining a verification result according to the comparison result includes:

comparing the first index scale value with the second index scale value to obtain a comparison result;

responding to the comparison result that the first index scale value is the same as the second index scale value, and the verification result is verification passing; or,

and responding to the comparison result that the first index scale value is different from the second index scale value, and if the comparison result is that the verification is failed.

Optionally, in response to the comparison result being that the first index scale value is the same as the second index scale value, the method further includes, after the verification result is verification passed:

in response to receiving a first interaction operation of a user with respect to a first index, retrieving the first index from the target system;

and assembling the first index, generating an assembling result, performing filling processing based on the first index and the first index measurement value to obtain a filling processing result, and sending the assembling result and the filling processing result to display equipment for display.

Optionally, the filling processing based on the first index and the first index measurement value, to obtain a filling processing result, includes:

obtaining screening conditions corresponding to the first index;

correlating the screening conditions corresponding to the first index with the first index measurement value to obtain a correlation result;

and filling the first index measurement value to the position of the screening condition corresponding to the first index based on the association result to obtain the filling processing result.

Optionally, in response to the comparison result being that the first finger scale value is different from the second finger scale value, the verification result is after verification fails, the method further comprises:

Generating and displaying a check list, wherein the check list comprises a plurality of correction items;

and in response to receiving a second interaction operation of a user for a target correction item in the verification list, highlighting fault location and correction description corresponding to the target correction item, wherein the target correction item is any correction item in the plurality of correction items.

Based on the same inventive concept, a second aspect of the present application provides a verification device for index configuration data, including:

a first index metric value generation module configured to obtain index configuration data for a first index, calculate a first index scale value for the first index from the index configuration data;

a second index scale value generating module configured to acquire a second index according to the first index, and service data associated with the second index, and process the service data by using the second index to generate a second index scale value of the second index, wherein the second index is acquired from a target system, and the second index corresponds to the first index;

and the index measurement value comparison module is configured to compare the first index measurement value with the second index measurement value and generate a comparison result, and a verification result is obtained according to the comparison result.

Based on the same inventive concept, the application also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable by the processor, the processor implementing the method according to the first aspect above when executing the computer program.

Based on the same inventive concept, the present application also provides a non-transitory computer readable storage medium storing computer instructions for causing a computer to perform the method as described above in the first aspect.

From the above, it can be seen that the method and the related device for checking the index configuration data provided by the present application acquire the index configuration data for the first index, calculate the first index scale value of the first index according to the index configuration data, then acquire the second index and the service data associated with the second index according to the first index, process the service data by using the second index to generate the second index scale value of the second index, and then obtain the comparison result capable of indicating the accuracy of the index configuration data by comparing the first index scale value with the second index scale value, and then obtain the corresponding check result according to the comparison result, so as to ensure that the data analysis can be performed by using the more accurate index configuration data, and avoid the influence on the data analysis.

Drawings

In order to more clearly illustrate the technical solutions of the present application or related art, the drawings that are required to be used in the description of the embodiments or related art will be briefly described below, and it is apparent that the drawings in the following description are only embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort to those of ordinary skill in the art.

FIG. 1 is a flowchart of a method for checking index configuration data according to an embodiment of the present application;

FIG. 2 is a schematic structural diagram of a verification device for index configuration data according to an embodiment of the present application;

fig. 3 is a schematic diagram of an electronic device according to an embodiment of the present application.

Detailed Description

For the purposes of making the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail below with reference to the accompanying drawings.

It should be noted that unless otherwise defined, technical or scientific terms used in the embodiments of the present application should be given the ordinary meaning as understood by one of ordinary skill in the art to which the present application belongs. The terms "first," "second," and the like, as used in embodiments of the present application, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that elements or items preceding the word are included in the element or item listed after the word and equivalents thereof, but does not exclude other elements or items. The terms "connected" or "connected," and the like, are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", etc. are used merely to indicate relative positional relationships, which may also be changed when the absolute position of the object to be described is changed.

It can be appreciated that before using the technical solutions of the embodiments in the present application, the user is informed about the type, the use range, the use scenario, etc. of the related personal information in an appropriate manner, and the authorization of the user is obtained.

For example, in response to receiving an active request from a user, a prompt is sent to the user to explicitly prompt the user that the operation it is requesting to perform will require personal information to be obtained and used with the user. Therefore, the user can select whether to provide personal information to the software or hardware such as the electronic equipment, the application program, the server or the storage medium for executing the operation of the technical scheme according to the prompt information.

As an alternative but non-limiting implementation, in response to receiving an active request from a user, the manner in which the prompt information is sent to the user may be, for example, a popup, in which the prompt information may be presented in a text manner. In addition, a selection control for the user to select to provide personal information to the electronic device in a 'consent' or 'disagreement' manner can be carried in the popup window.

It will be appreciated that the above-described notification and user authorization acquisition process is merely illustrative, and not limiting of the implementation of the present application, and that other ways of satisfying relevant legal regulations may be applied to the implementation of the present application.

Embodiments of the present application are described in detail below with reference to the accompanying drawings.

In the processing process of data analysis, the data center station is often required to rely on, and the data center station does not generate data, so that data source detection is required to be carried out, and the obtained index configuration data is accessed to the data center station. The data source detection mode in the related art needs to be output through manual cooperation, the accuracy of index configuration data cannot be guaranteed, and data analysis can be influenced.

The embodiment of the application provides a verification method for index configuration data, which comprises the steps of obtaining index configuration data for a first index, calculating a first index scale value of the first index according to the index configuration data, obtaining a second index according to the first index, processing business data associated with the second index by using the second index to generate a second index value of the second index, obtaining a comparison result capable of indicating the accuracy of the index configuration data by comparing the first index scale value with the second index value, and obtaining a corresponding verification result according to the comparison result, so that data analysis by using more accurate index configuration data can be ensured, and influence on data analysis is avoided.

As shown in fig. 1, the method of the present embodiment includes:

step 101, index configuration data aiming at a first index is obtained, and a first index scale value of the first index is calculated according to the index configuration data.

In this step, the index configuration data represents a description of operation information for calculating the index scale value, for example, calculation logic of the index scale value, a position, a field, a data standard, and the like of a physical table where the business data corresponding to the index is located.

The business data represents data generated by production activities of an organization, such as product input and output warehouse, manufacturing and other businesses, and when the first index is a sales achievement rate, the business data can include the actual sales and the positions and fields of the physical table where the target sales are located.

Where an organization may represent different departments under the same company.

For example, if the first index is a sales achievement rate, the index configuration data may include a location and a field of a physical table where the service data corresponding to the sales achievement rate is located, and calculation logic for calculating a first index scale value of the sales achievement rate, and calculating the field corresponding to the service data by using the calculation logic, so as to obtain the first index scale value of the first index.

Step 102, obtaining a second index according to the first index, and service data associated with the second index, and processing the service data by using the second index to generate a second index scale value of the second index, wherein the second index is obtained from a target system, and the second index corresponds to the first index.

In this step, the target system represents a system of different business domain applications, e.g., office automation (OfficeAutomation, OA) system, enterprise resource planning (Enterprise Resource Planning, ERP) system, customer management (Customer Relationship Management, CRM) system.

Business data represents data generated by production activities of an organization, such as product in-out warehouse, manufacturing, etc., where an organization may represent different departments under the same company.

And acquiring a second index according to the first index and service data associated with the second index, and performing combined query calculation on the service data by using the second index to generate a second index scale value of the second index.

The manner of combining query calculations may be to pick up the corresponding index options or to input the corresponding query conditions.

For example, if the first index is a sales achievement rate, the second index corresponding to the first index is also a sales achievement rate, and the service data associated with the second index is a data, B data, or C data.

And calculating the data A, the data B and the data C by using a calculation logic of the sales achievement rate to obtain a second index value of the second index.

And step 103, comparing the first index scale value with the second index scale value, generating a comparison result, and obtaining a verification result according to the comparison result.

In this step, the comparison result is used to indicate the accuracy of the index configuration data.

Comparing the first index scale value with the second index scale value, if the obtained comparison result is consistent, indicating that the written index configuration data is more accurate, and performing data analysis by utilizing the index configuration data, so that the influence of the index configuration data with lower accuracy on the data analysis can be avoided.

If the comparison results are inconsistent, the pre-written index configuration data is inaccurate, the data analysis cannot be performed by using the index configuration data, and the data analysis can be influenced to a certain extent.

In addition, the verification result and each verification list in the verification process can be visually and interactively presented in the form of a result report page. By clicking a certain modification item of the report page, the user can be led to modify the report page step by clicking a link to jump to the problem scene and highlight the prompt and the detailed description of the problem.

According to the scheme, the index configuration data aiming at the first index is obtained, the first index scale value of the first index is calculated according to the index configuration data, then the second index and the service data related to the second index are obtained according to the first index, the service data are processed by the second index to generate the second index scale value of the second index, the comparison result which can indicate the accuracy of the index configuration data can be obtained by comparing the first index scale value with the second index scale value, then the corresponding check result can be obtained according to the comparison result, the data analysis by using the more accurate index configuration data can be guaranteed, and the influence on the data analysis is avoided.

In some embodiments, in step 102, after obtaining a second index according to the first index, and service data associated with the second index, the method further includes:

and A1, performing format verification on the second index according to a preset index format to obtain a format verification result.

And step A2, processing the service data by using the second index to generate a second index value of the second index in response to the format verification result being that the format verification is passed.

In the scheme, the existing index construction is more dispersed, unified management and expression are lacked, and index construction can be carried out repeatedly by different organizations, so that the cooperative sharing of indexes constructed among different organizations is poor.

Therefore, the standardization of the index is carried out, the index is described through formatted data, unified management of the index is facilitated, multi-level classified nested representation of the attribute is carried out through comprehensive extraction and induction summarization, for example, the primary attribute has basic attribute, technical attribute, application system and analysis dimension, and for example, the basic attribute further comprises business attribute and management attribute, wherein the business attribute comprises index coding, index name, business definition, business attribute, index caliber, business field, statistical period, minimum management granularity and the like, and the attribute can be subdivided layer by layer and flexibly expanded based on the requirement.

The index format is as follows:

{ basic Property:

{ service Properties: { index coding, index name, service definition, service attribute, index caliber, service area, statistics period, index classification, goodness trend, minimum management granularity },

management attributes: { data security level, management purpose, index act, index responsibility department, index act, business domain where the index is located, data generation department and dockee }, others },

Technical attributes: { probe information: { Source System Page information: { data acquisition mode, source service system, service system module, interface path/transaction, screening conditions, statistics field, interface screening logic, service act }, source system database information: { Source service System, database type, physical Table field, service System technology responsible, service System background computational logic })

Development information: { floor system, data development, data update time, data update frequency, ODS information: [ { schema_1, physical table_1 }, { schema_2, physical table_2 },..: [ { schema_1, physical table_1 }, { schema_2, physical table_2 },..,

an application system: { System name, service responsible person, application Path }

Analysis dimension: [ { dimension code_1, dimension name_1, dimension description_1, table name: table_1, table_2..table_n ], dimension type_1 }, { dimension code_2, dimension name_2, dimension description_2, table name: table_1, table_2..table_n ], dimension type_2 },., { dimension code_n, dimension name_n, dimension description_n, table name: table_1, table_2..table_n ], dimension type_n }.

The index information base platform is utilized to store and manage the information of the index, support manual filling, system docking extraction and file importing, support on-line diagonal color checking and approval of the established index, and solve the problems of low on-line flow operation efficiency, incapability of sharing and viewing and the like. The method comprises the steps of realizing online change and adjustment of indexes after warehousing, and providing a multidimensional display interface to realize information visualization of the indexes, wherein an index information base platform is deployed and stored in a target system.

And the remote server background formatting verification module performs formatting verification on the attribute information of the index to be input according to the index data format defined above, and gives out formatting verification revision prompt until the verification is passed and the index is put in storage.

And performing format verification on the second index recorded and stored in the index information base platform according to the index format (namely a preset index format) to obtain a format verification result. When the format verification result is that the format verification is passed, the corresponding second index is indicated to be in an approval passing state, the second index is ensured to be stored according to a unified format expression mode, and then the second index can be uniformly managed and controlled, and a data basis is provided for executing a subsequent verification process.

And when the format verification result is that the format verification fails, generating and displaying a format verification revision prompt until the format verification result is that the format verification fails.

In some embodiments, in step 102, the obtaining a second index according to the first index includes:

and B1, determining an index path of a second index corresponding to the first index and an application program interface address corresponding to the index path, and determining a target application program interface according to the application program interface address.

And step B2, acquiring a second index from the target system through the target program interface according to the index path.

In the above scheme, the index information base platform storing the second index is in communication connection with the background of the display interface, the index path of each index in the display interface is maintained in the index information base platform, the network (Uniform Resource Locator, url) address and the access protocol of the corresponding interface are matched in the background of the display interface based on the index path, the matching of the index path to the corresponding application program (Application Programming Interface, API) interface address is realized, the second index stored in the index information base platform is called to the background of the display interface according to the index path through the determined target program interface, and the index information base platform is displayed in the display interface, wherein the index information base platform is deployed and stored in the target system.

In some embodiments, in step 102, the processing the service data with the second index to generate a second index value of the second index includes:

and step C1, acquiring a screening condition enumeration value corresponding to the second index, wherein the screening condition enumeration value comprises a plurality of screening conditions and a screening condition field value corresponding to each screening condition.

And step C2, receiving a selection instruction aiming at the enumeration value of the screening conditions, selecting at least one target screening condition from the screening conditions according to the selection instruction, and acquiring a target screening condition field value corresponding to the at least one target screening condition.

And step C3, calculating the service data based on the target screening condition field value to obtain a calculation result.

And C4, synthesizing the target screening condition field value and the calculation result to generate a second index scale value of the second index.

In the above scheme, a screening condition enumeration value corresponding to the second index is obtained, a selection instruction for the screening condition enumeration value is received, at least one target screening condition is selected from a plurality of screening conditions according to the selection instruction, a target screening condition field value corresponding to the at least one target screening condition is obtained, service data is calculated based on the target screening condition field value, a calculation result is obtained, the target screening condition field value and the calculation result are synthesized, and a second index value of the second index is generated.

For example, the second index is sales achievement rate, the enumerated values of the screening conditions corresponding to the second index include screening condition 1, screening condition 2, and screening condition 3, then the screening condition 1 is time, and the corresponding field values are time 1, time 2, and time 3.

Screening condition 2 is a product, and the corresponding field values are product 1, product 2, and product 3. Screening condition 3 is department, and the corresponding field values are department 1, department 2, department 3.

Then according to the selected screening condition 1 and/or the field value corresponding to the screening condition 2 and/or the screening condition 3, assuming that only the product 1 of the screening condition 2 (corresponding to the target screening condition field value) is selected, calculating the service data under the field value to obtain a calculation result of m, and finally obtaining a second index value of the second index as the product 1-sales achievement rate of m.

In some embodiments, in step 101, the acquiring the index configuration data for the first index includes:

step D1, writing initial-index configuration data for the first index.

And D2, carrying out quantization processing on the initial index configuration data according to a preset storage format to generate the index configuration data.

In the above scheme, since the initial index configuration data is a description of a plain text, the readability is poor, so that in order to facilitate verification, quantization processing is performed on the initial index configuration data according to a preset storage format, the initial index configuration data is disassembled to form an attribute code value and an operation formula, and the attribute code value and the operation formula which are formed by disassembly are synthesized to generate the index configuration data.

In some embodiments, the metric configuration data includes a business data name corresponding to the first metric, and arithmetic logic that calculates a first metric value for the first metric.

In step 101, the calculating a first index scale value of the first index according to the index configuration data includes:

and E1, acquiring a physical table field value of the service data name corresponding to the first index from a preset physical table.

And E2, performing de-duplication processing on the physical table field value to obtain a physical table field value subjected to de-duplication.

And E3, calculating the physical table field value subjected to the duplication elimination by utilizing the operation logic, and generating a first finger scale value of the first index.

In the above scheme, the physical table field values are de-duplicated, so that all different dimensions can be screened, each dimension is combined and automatically filled, thus the data query filter script can be automatically assembled, the de-duplicated physical table field values are generated, and then the de-duplicated physical table field values are calculated by using the arithmetic logic for calculating the first index scale value of the first index, so that the first index scale value of the first index is obtained.

In addition, before performing the deduplication processing on the physical table field value to generate the physical table field value subjected to the deduplication, association matching is further required on all the enumerated analysis dimensions, statistics fields and data association of each first index and the physical table and physical table field value of the source system, and the matching is performed through basic information of the index configuration data, so that the subsequent operation can be performed.

In some embodiments, step E3 comprises:

and E31, splitting the first index to obtain a plurality of split indexes, and calling physical table field values corresponding to the split indexes from the physical table field values subjected to de-duplication.

And E32, carrying out combination calculation on the physical table field values corresponding to the split indexes through a preset aggregation function to generate a first index scale value of the first index.

In the above scheme, when the first index includes complex computing factors, for example, including A, B, C, D, E, summing, taking a quotient, etc., the first index needs to be disassembled step by step into a plurality of computing factors (i.e., a plurality of split indexes) with simple subdivision, and the final second index value is obtained by assembling and combining the plurality of computing factors and through an aggregation function.

Since the final first finger scale value is a measurable value, it is necessary to combine the multiple sub-divided simple calculation factors disassembled by a preset aggregation function.

The predetermined aggregation function may be a SUM (SUM) function, a statistics (COUNT) function, an arithmetic Average (AVG) function, a return maximum value (MAX) function, or a return minimum value (MIN) function, and the first finger scale value may be rapidly derived.

In some embodiments, step 103 comprises:

step 1031, comparing the first index scale value with the second index scale value to obtain the comparison result.

Step 1032, in response to the comparison result being that the first finger scale value is the same as the second finger scale value, the verification result is verification pass. Or,

step 1033, if the comparison result is that the first finger scale value is different from the second finger scale value, the verification result is that the verification fails.

In the above scheme, the first index scale value is compared with the second index scale value to obtain a comparison result, if the comparison result is consistent, the pre-written index configuration data is accurate, and the method can be used for data analysis, so that the influence of the index configuration data with lower accuracy on the data analysis can be avoided.

In addition, some attributes of the index are allowed to be null, for example, if a certain index does not perform actual data development, the attribute corresponding to the index is allowed to be null.

In some embodiments, following step 1032, the method further comprises:

and F1, responding to the received first interactive operation of the user on the first index, and calling the first index from the target system.

And F2, splicing the first indexes to generate splicing results, filling the first indexes based on the first indexes and the first index measurement values to obtain filling processing results, and sending the splicing results and the filling processing results to display equipment for display.

In the above scheme, the model of the data center table is generally divided into three layers from bottom to top: a source layer (Operational Data Store, ODS), a data warehouse layer (DW) and a data mart layer (DM).

The models of all layers can be subdivided based on scenes, data are extracted and cleaned layer by layer, and finally, unified export docking data application scene presentation is performed through the data mart layer.

The first interactive operation may be a search input operation of a user on the presentation interface of the data center console, or a drag operation of the user on the presentation interface of the data center console.

When a first interactive operation of a user aiming at a first index is received, the application bottom layer of the display interface of the data center platform is in butt joint with the target system and the data center platform, unique codes (Identity document, id) of the first index are automatically matched from all indexes stored in the target system, and the first index is called from the target system.

The data mart layer of the existing data center model is usually designed by customizing the model aiming at the display style of a concrete data analysis billboard, only certain concrete analysis display requirement can be met, once the display style of the billboard is changed, the data center model and data development are required to be re-established, the input time and the labor cost are high, and the flexibility is poor.

According to the method, a database mode (schema), a physical table and an attribute field of a data mart layer in a corresponding data center model are acquired according to the first index, statistical information module section of a data query script is partially assembled, an assembly result is generated, the data center automatically associates and outputs all analysis dimensions of the data center, the analysis dimensions are subjected to format self-adaptive adaptation in a display interface of the data center, and a user is supported to modify and customize dimension presentation names. In this way, all dimensions of the first index can be presented on the interface by combining queries, and custom dragging and presentation control selection of the query module is supported.

At this time, the main interface frame is generated, but is only a static page, and each filtering condition has only a label and no actual filtering value, so that data interaction cannot be performed. Therefore, filling processing is required to be performed based on the first index and the first index measurement value, a filling processing result is obtained, the assembly result and the filling processing result are sent to display equipment for display, a display interface with interactive dynamic data is generated on the display equipment, the effect of autonomous configuration is achieved, the indexes can be multiplexed, and repeated development is not required.

In some embodiments, in step F2, the performing a filling process based on the first indicator and the first indicator metric value, to obtain a filling process result, includes:

and F21, acquiring screening conditions corresponding to the first index.

And step F22, correlating the screening conditions corresponding to the first index and the first index measurement value to obtain a correlation result.

And F23, filling the first index measurement value to the position of the screening condition corresponding to the first index based on the association result, and obtaining the filling processing result.

In the scheme, after assembly, the main interface frame is generated, but is only a static page, and each screening condition at the moment has only a label and no actual screening value, so that data interaction cannot be performed. Therefore, filling processing is needed based on the first index and the first index measurement value, the screening condition corresponding to the first index and the first index measurement value are associated to obtain an associated result, the first index measurement value is filled to the position of the screening condition corresponding to the first index based on the associated result to obtain a filling processing result, filling of different formats is realized through fuzzy inquiry and paging display, if the filling processing result is enumeration type, data is de-duplicated through removing the data layer table field where the dimension is located, and if the filling processing result is time type, the date, the week, the month, the season, the year and the like can be automatically expanded, and the same-ring comparison can be selected.

In some embodiments, after step 1033, the method further comprises:

and G1, generating and displaying a check list, wherein the check list comprises a plurality of correction items.

And G2, in response to receiving a second interaction operation of a user on a target correction item in the verification list, highlighting fault positioning and correction description corresponding to the target correction item, wherein the target correction item is any one of the correction items.

In the above scheme, if the comparison results are inconsistent, it is indicated that the pre-written index configuration data is inaccurate, the data analysis cannot be performed by using the index configuration data, and a certain influence is caused on the data analysis, so that a check list is generated.

The second interaction operation may be a voice command or a touch command.

The checklist is visually and interactively presented in the form of a results report page. By clicking on a certain correction item (i.e., a target correction item) of the verification list, the user can be led to change to the problem site (i.e., fault location) corresponding to the target correction item, highlight and specify the problem (i.e., correction description) step by step.

The highlighting mode may be highlighting, thickening, amplifying, or thickening and amplifying, or may be displaying by using a preset color as a base color.

It should be noted that, the method of the embodiments of the present application may be performed by a single device, for example, a computer or a server. The method of the embodiment can also be applied to a distributed scene, and is completed by mutually matching a plurality of devices. In the case of such a distributed scenario, one of the devices may perform only one or more steps of the methods of embodiments of the present application, and the devices may interact with each other to complete the methods.

It should be noted that some embodiments of the present application are described above. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims may be performed in a different order than in the embodiments described above and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

Based on the same inventive concept, the application also provides a verification device for the index configuration data, which corresponds to the method in any embodiment.

Referring to fig. 2, the checking device of the index configuration data includes:

a first index metric value generation module 201 configured to obtain index configuration data for a first index, calculate a first index metric value for the first index from the index configuration data;

a second index scale value generating module 202 configured to obtain a second index according to the first index, and service data associated with the second index, and process the service data with the second index, to generate a second index scale value of the second index, where the second index is obtained from a target system, and the second index corresponds to the first index;

the index metric value comparison module 203 is configured to compare the first index metric value with the second index metric value and generate a comparison result, and obtain a verification result according to the comparison result.

In some embodiments, the verification device of the index configuration data further includes a format verification module, where after obtaining a second index according to the first index and the service data associated with the second index, the format verification module is specifically configured to:

In some embodiments, the second index value generation module 202 is specifically configured to:

In some embodiments, the first metric value generation module 201 is specifically configured to:

writing initial index configuration data for the first index;

In some embodiments, the metric configuration data includes a business data name corresponding to the first metric, and arithmetic logic to calculate a first metric value for the first metric;

the first metric value generation module 201 includes:

an obtaining unit, configured to obtain a physical table field value of a service data name corresponding to the first index from a preset physical table;

the de-duplication unit is configured to perform de-duplication treatment on the physical table field value to obtain a de-duplicated physical table field value;

and a calculating unit configured to calculate the physical table field value subjected to the deduplication by using the arithmetic logic, and generate a first index scale value of the first index.

In some embodiments, the computing unit is specifically configured to:

In some embodiments, the metric value comparison module 203 is specifically configured to:

In some embodiments, the checking device of the index configuration data further includes a sending module, and in response to the comparison result being that the first index scale value is the same as the second index scale value, the sending module includes:

A retrieving unit configured to retrieve a first index from the target system in response to receiving a first interaction operation of a user with respect to the first index;

and the sending unit is configured to assemble the first index and generate an assembly result, perform filling processing based on the first index and the first index measurement value to obtain a filling processing result, and send the assembly result and the filling processing result to a display device for display.

In some embodiments, the transmitting unit is specifically configured to:

obtaining screening conditions corresponding to the first index;

In some embodiments, the verification device of the index configuration data further includes a highlighting module, and in response to the comparison result being that the first index scale value is different from the second index scale value, the highlighting module is specifically configured to:

For convenience of description, the above devices are described as being functionally divided into various modules, respectively. Of course, the functions of each module may be implemented in the same piece or pieces of software and/or hardware when implementing the present application.

The device of the foregoing embodiment is used to implement the verification method of the corresponding index configuration data in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which is not described herein.

Based on the same inventive concept, the application also provides an electronic device corresponding to the method of any embodiment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the verification method of the index configuration data of any embodiment when executing the program.

Fig. 3 shows a more specific hardware architecture of an electronic device according to this embodiment, where the device may include: a processor 301, a memory 302, an input/output interface 303, a communication interface 304 and a bus 305. Wherein the processor 301, the memory 302, the input/output interface 303 and the communication interface 304 are communicatively coupled to each other within the device via a bus 305.

The processor 301 may be implemented by a general-purpose CPU (Central Processing Unit ), a microprocessor, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or one or more integrated circuits, etc. for executing relevant programs to implement the technical solutions provided in the embodiments of the present disclosure.

The Memory 302 may be implemented in the form of ROM (Read Only Memory), RAM (RandomAccess Memory ), static storage device, dynamic storage device, or the like. Memory 302 may store an operating system and other application programs, and when the technical solutions provided in the embodiments of the present specification are implemented in software or firmware, relevant program codes are stored in memory 302 and invoked for execution by processor 301.

The input/output interface 303 is used to connect with an input/output module to realize information input and output. The input/output module may be configured as a component in a device (not shown) or may be external to the device to provide corresponding functionality. Wherein the input devices may include a keyboard, mouse, touch screen, microphone, various types of sensors, etc., and the output devices may include a display, speaker, vibrator, indicator lights, etc.

The communication interface 304 is used to connect a communication module (not shown in the figure) to enable the present device to interact with other devices. The communication module may implement communication through a wired manner (such as USB, network cable, etc.), or may implement communication through a wireless manner (such as mobile network, WIFI, bluetooth, etc.).

Bus 305 includes a path to transfer information between the various components of the device (e.g., processor 301, memory 302, input/output interface 303, and communication interface 304).

It should be noted that, although the above device only shows the processor 301, the memory 302, the input/output interface 303, the communication interface 304, and the bus 305, in the implementation, the device may further include other components necessary for achieving normal operation. Furthermore, it will be understood by those skilled in the art that the above-described apparatus may include only the components necessary to implement the embodiments of the present description, and not all the components shown in the drawings.

The electronic device of the foregoing embodiment is configured to implement the method for verifying the corresponding index configuration data in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which is not described herein.

Based on the same inventive concept, corresponding to any of the above embodiments of the method, the present application further provides a non-transitory computer readable storage medium storing computer instructions for causing the computer to perform the method for checking the index configuration data according to any of the above embodiments.

The computer readable media of the present embodiments, including both permanent and non-permanent, removable and non-removable media, may be used to implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device.

The storage medium of the foregoing embodiment stores computer instructions for causing the computer to execute the method for checking the index configuration data according to any one of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiments, which are not described herein.

Those of ordinary skill in the art will appreciate that: the discussion of any of the embodiments above is merely exemplary and is not intended to suggest that the scope of the application (including the claims) is limited to these examples; the technical features of the above embodiments or in the different embodiments may also be combined within the idea of the present application, the steps may be implemented in any order, and there are many other variations of the different aspects of the embodiments of the present application as described above, which are not provided in detail for the sake of brevity.

Additionally, well-known power/ground connections to Integrated Circuit (IC) chips and other components may or may not be shown within the provided figures, in order to simplify the illustration and discussion, and so as not to obscure the embodiments of the present application. Furthermore, the devices may be shown in block diagram form in order to avoid obscuring the embodiments of the present application, and this also takes into account the fact that specifics with respect to implementation of such block diagram devices are highly dependent upon the platform on which the embodiments of the present application are to be implemented (i.e., such specifics should be well within purview of one skilled in the art). Where specific details (e.g., circuits) are set forth in order to describe example embodiments of the application, it should be apparent to one skilled in the art that embodiments of the application can be practiced without, or with variation of, these specific details. Accordingly, the description is to be regarded as illustrative in nature and not as restrictive.

While the present application has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of those embodiments will be apparent to those skilled in the art in light of the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the embodiments discussed.

The present embodiments are intended to embrace all such alternatives, modifications and variances which fall within the broad scope of the appended claims. Accordingly, any omissions, modifications, equivalents, improvements and/or the like which are within the spirit and principles of the embodiments are intended to be included within the scope of the present application.

Claims

1. A method for verifying index configuration data, comprising:

2. The method of claim 1, wherein after obtaining a second index from the first index and service data associated with the second index, the method further comprises:

3. The method of claim 1, wherein the obtaining a second index from the first index comprises:

4. The method of claim 1, wherein said processing said traffic data with said second indicator to generate a second indicator scale value for said second indicator comprises:

5. The method of claim 1, wherein the obtaining the index configuration data for the first index comprises:

writing initial index configuration data for the first index;

6. The method of claim 1, wherein the index configuration data includes a business data name corresponding to the first index, and arithmetic logic that calculates a first index scale value for the first index;

7. The method of claim 6, wherein the computing the de-duplicated physical table field values using the arithmetic logic generates a first finger scale value for the first indicator, comprising:

8. The method of claim 1, wherein comparing the first index scale value with the second index scale value and generating a comparison result, and obtaining a verification result based on the comparison result comprises:

9. The method of claim 8, wherein in response to the comparison being that the first finger scale value is the same as the second finger scale value, the method further comprises, after the verification is passed:

10. The method of claim 9, wherein the performing a filling process based on the first indicator and the first indicator metric value results in a filling process result, comprising:

Obtaining screening conditions corresponding to the first index;

11. The method of claim 8, wherein in response to the comparison result being that the first finger scale value is not the same as the second finger scale value, the method further comprises, after the verification result is that the verification fails:

12. A verification apparatus for index configuration data, comprising:

13. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 11 when the program is executed by the processor.

14. A non-transitory computer readable storage medium storing computer instructions for causing a computer to perform the method of any one of claims 1 to 11.

15. A computer program product comprising computer program instructions which, when run on a computer, cause the computer to perform the method of any of claims 1-11.