A method for constructing a business assessment data bitmap index, a query method and a device

By constructing a bitmap index for business assessment data and using multi-dimensional query bitmap index, the problem of inefficient analysis of task target execution progress data in customer marketing management of commercial banks is solved, and the rapid retrieval and query of task execution progress data is realized, which improves the Data analysis efficiency.

CN117609249BActive Publication Date: 2024-11-15BEIJING PACTERA JINXIN TECH LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202311676670.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-12-07
Publication Date
2024-11-15
Estimated Expiration
2043-12-07

AI Technical Summary

Technical Problem

It is difficult for commercial banks to quickly find and analyze the execution progress of task goals in customer marketing management, resulting in inefficient data analysis of task execution progress.

Method used

By building a business assessment data bitmap index, using indicator configuration data tables, assessment object configuration tables and task configuration data tables, to create multi-dimensional query bitmap indexes to achieve rapid retrieval and query of task execution progress records.

Benefits of technology

It improves data retrieval efficiency and query efficiency, reduces complex data search process, and realizes rapid positioning and analysis of task execution progress data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117609249B_ABST
    Figure CN117609249B_ABST
Patent Text Reader

Abstract

The present application provides a method for constructing a bitmap index of business assessment data, a query method and a device, which determines the indicator execution schedule of the performance assessment object recorded in the assessment object configuration table by associating the indicator configuration data table, the assessment object configuration table and the indicator execution data table; determines the task execution schedule of the performance assessment object by associating the task configuration data table using the identification identifier configured for the indicator execution schedule; based on the object identifier of the performance assessment object, the indicator identifier of the performance assessment indicator and the task identifier of the performance assessment task, creates a multidimensional query bitmap index of the task execution schedule by classifying and processing multiple task execution progress records, so as to realize the retrieval of the task execution progress records in the task execution schedule by using the multidimensional query bitmap index. In this way, the query of data in the task execution schedule can be realized in multiple dimensions with the help of the multidimensional query bitmap index, thereby improving the efficiency and timeliness of data retrieval.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method for constructing, a method for querying, and a device for bitmap indexing of business assessment data. Background Art

[0002] In the process of customer marketing management, commercial banks often need to supervise the marketing process of sales staff. In the process of supervision, they often only focus on the statistics of the actual performance data of sales staff, but ignore the comparison and correlation analysis with the task objectives. When it is necessary to statistically analyze the execution progress of each task objective, users are usually required to select the task objective and then calculate the task objective execution progress data independently. When there are many task objectives, it is difficult to quickly find the task objectives that need to be associated when performing correlation analysis on sales staff, and the calculation process is time-consuming and laborious, making the efficiency of task execution progress data analysis low. Summary of the invention

[0003] In view of this, the purpose of the present application is to provide a method for constructing a business assessment data bitmap index, a query method and a device, which can quickly realize the rapid retrieval of task execution progress records with the help of a pre-built multi-dimensional query bitmap index and improve data retrieval efficiency.

[0004] The present application embodiment provides a method for constructing a business assessment data bitmap index, the construction method comprising:

[0005] Using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, by associating the appraisal object configuration table and the indicator execution data table, determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table;

[0006] Using the identification mark configured for the indicator execution schedule, by associating the task configuration data table, the task execution schedule of the performance appraisal object is determined; wherein the task execution schedule includes a plurality of task execution progress records;

[0007] Based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, the multiple task execution progress records are classified and processed to create a multidimensional query bitmap index of the task execution schedule table, so as to utilize the multidimensional query bitmap index to realize the retrieval of the task execution progress records in the task execution schedule table.

[0008] In a possible implementation manner, the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table is used to determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table, including:

[0009] Using the indicator identifier of each performance appraisal indicator, the performance appraisal object in the appraisal object configuration table that needs to complete the performance appraisal indicator is associated to determine the indicator set data of the performance appraisal object;

[0010] Using the indicator identifier of each performance appraisal indicator in the indicator set data, associating the indicator execution progress data recorded in the indicator execution data table, and determining the indicator execution detail data of each performance appraisal indicator of the performance appraisal object;

[0011] The indicator set data of the performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object are integrated to generate an indicator execution schedule for the performance appraisal object.

[0012] In a possible implementation manner, the identification mark of the indicator execution schedule is determined by the following steps:

[0013] The identification mark of the indicator execution schedule is formed by combining the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule.

[0014] In a possible implementation, the determining the task execution schedule of the performance appraisal object by using the identification mark configured for the indicator execution schedule and associating the task configuration data table includes:

[0015] Using the identification mark of the indicator execution schedule, the performance appraisal task to be completed by the performance appraisal object in the task configuration data table is associated to determine the task execution detail data of the performance appraisal object;

[0016] The indicator execution schedule and the task execution detail data are integrated to determine the task execution schedule of the performance appraisal object.

[0017] In a possible implementation, the multidimensional query bitmap index of the task execution schedule is created by classifying the plurality of task execution progress records based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task, including:

[0018] Using the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in each task execution progress record, the task execution progress records having the same object identifier, the same indicator identifier, and the same task identifier are divided into the same bitmap index group;

[0019] For each bitmap index group, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group are determined as the multidimensional subquery bitmap index of the bitmap index group, so as to realize the query of the task execution progress record in the bitmap index group by using the multidimensional subquery bitmap index;

[0020] Based on the multidimensional sub-query bitmap index of each bitmap index group, a multidimensional query bitmap index for obtaining the task execution schedule is created.

[0021] The present application also provides a method for querying business assessment data, the query method comprising:

[0022] In response to receiving the assessment data retrieval request, reading a data retrieval condition from the assessment data retrieval request;

[0023] Using the data retrieval condition, by querying the data query results cached in the memory cache, determining whether there is a data query result in the memory cache that meets the data retrieval condition;

[0024] If not, generating a search SQL statement by identifying the object identifier of the performance appraisal object queried by the appraisal data search request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator from the data search condition;

[0025] By executing the retrieval SQL statement, with the help of the multidimensional query bitmap index of the task execution schedule in the database, a data query result that meets the data retrieval condition is obtained from the task execution schedule; wherein the multidimensional query bitmap index of the task execution schedule is constructed by the above-mentioned method for constructing the business assessment data bitmap index;

[0026] Determining the task completion degree of the performance appraisal object based on the data query result;

[0027] The task completion degree and the data query result are fed back to the client.

[0028] In a possible implementation manner, determining the task completion degree of the performance appraisal object based on the data query result includes:

[0029] Analyze the data query results to determine the expected task value and actual completion value of the performance appraisal task of the performance appraisal object;

[0030] Based on the expected task value and the actual completion value, the task completion degree of the performance appraisal object is determined.

[0031] In a possible implementation, the query method further includes:

[0032] Counting the number of task execution progress records included in the data query result;

[0033] When the number of records is less than a preset number threshold, the data query result is cached in the memory cache.

[0034] The embodiment of the present application also provides a device for constructing a business assessment data bitmap index, the device comprising:

[0035] A first association module is used to determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table and associating the appraisal object configuration table with the indicator execution data table;

[0036] A second associating module is used to determine the task execution schedule of the performance appraisal object by associating the task configuration data table with the identification identifier configured for the indicator execution schedule; wherein the task execution schedule includes a plurality of task execution progress records;

[0037] A bitmap index creation module is used to create a multidimensional query bitmap index of the task execution schedule based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, by classifying the multiple task execution progress records, so as to realize the retrieval of the task execution progress records in the task execution schedule using the multidimensional query bitmap index.

[0038] In a possible implementation manner, when the first association module is used to determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, the first association module is used to:

[0039] Using the indicator identifier of each performance appraisal indicator, the performance appraisal object in the appraisal object configuration table that needs to complete the performance appraisal indicator is associated to determine the indicator set data of the performance appraisal object;

[0040] Using the indicator identifier of each performance appraisal indicator in the indicator set data, associating the indicator execution progress data recorded in the indicator execution data table, and determining the indicator execution detail data of each performance appraisal indicator of the performance appraisal object;

[0041] The indicator set data of the performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object are integrated to generate an indicator execution schedule for the performance appraisal object.

[0042] In a possible implementation manner, the first association module is used to determine the identification mark of the indicator execution schedule through the following steps:

[0043] The identification mark of the indicator execution schedule is formed by combining the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule.

[0044] In a possible implementation manner, when the second association module is used to determine the task execution schedule of the performance appraisal object by associating the task configuration data table using the identification identifier configured for the indicator execution schedule, the second association module is used to:

[0045] Using the identification mark of the indicator execution schedule, the performance appraisal task to be completed by the performance appraisal object in the task configuration data table is associated to determine the task execution detail data of the performance appraisal object;

[0046] The indicator execution schedule and the task execution detail data are integrated to determine the task execution schedule of the performance appraisal object.

[0047] In a possible implementation, when the bitmap index creation module is used to create a multidimensional query bitmap index for the task execution schedule by classifying the plurality of task execution progress records based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task, the bitmap index creation module is used to:

[0048] Using the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in each task execution progress record, the task execution progress records having the same object identifier, the same indicator identifier, and the same task identifier are divided into the same bitmap index group;

[0049] For each bitmap index group, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group are determined as the multidimensional subquery bitmap index of the bitmap index group, so as to realize the query of the task execution progress record in the bitmap index group by using the multidimensional subquery bitmap index;

[0050] Based on the multidimensional sub-query bitmap index of each bitmap index group, a multidimensional query bitmap index for obtaining the task execution schedule is created.

[0051] The embodiment of the present application also provides a device for querying business assessment data, the query device comprising:

[0052] A data reading module, configured to read data retrieval conditions from the assessment data retrieval request in response to receiving the assessment data retrieval request;

[0053] A first query module, configured to use the data retrieval condition to determine whether there is a data query result that meets the data retrieval condition in the memory cache by querying the data query results cached in the memory cache;

[0054] A statement generation module, for generating a search SQL statement by identifying, from the data search conditions, the object identifier of the performance appraisal object queried by the appraisal data search request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator;

[0055] The second query module is used to obtain data query results that meet the data retrieval conditions from the task execution schedule by executing the retrieval SQL statement with the help of the multidimensional query bitmap index of the task execution schedule in the database; wherein the multidimensional query bitmap index of the task execution schedule is constructed by the construction device of the business assessment data bitmap index described above;

[0056] A calculation module, used to determine the task completion degree of the performance appraisal object based on the data query result;

[0057] The result feedback module is used to feed back the task completion degree and the data query result to the client.

[0058] In a possible implementation manner, when the calculation module is used to determine the task completion degree of the performance appraisal object based on the data query result, the calculation module is used to:

[0059] Analyze the data query results to determine the expected task value and actual completion value of the performance appraisal task of the performance appraisal object;

[0060] Based on the expected task value and the actual completion value, the task completion degree of the performance appraisal object is determined.

[0061] In a possible implementation, the query device further includes a cache module, and the cache module is used to:

[0062] Counting the number of task execution progress records included in the data query result;

[0063] When the number of records is less than a preset number threshold, the data query result is cached in the memory cache.

[0064] An embodiment of the present application also provides an electronic device, including: a processor, a memory and a bus, wherein the memory stores machine-readable instructions executable by the processor, and when the electronic device is running, the processor and the memory communicate through the bus, and when the machine-readable instructions are executed by the processor, the steps of the method for constructing a bitmap index of business assessment data and the steps of the method for querying business assessment data are performed as described above.

[0065] An embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the method for constructing a bitmap index of business assessment data and the steps of the method for querying business assessment data are executed.

[0066] The embodiments of the present application provide a method for constructing a business appraisal data bitmap index, a query method and a device, which utilize the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, and determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table; utilize the identification identifier configured for the indicator execution schedule table, and determine the task execution schedule of the performance appraisal object by associating the task configuration data table; based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, a multidimensional query bitmap index for the task execution schedule is created by classifying and processing multiple task execution progress records, so as to realize the retrieval of the task execution progress record in the task execution schedule by utilizing the multidimensional query bitmap index. In this way, when there is a query demand, the multi-dimensional query bitmap index can be used to query the task execution schedule in multiple dimensions, thereby improving the retrieval efficiency and timeliness of data under huge data volumes; and, by matching the multi-dimensional query bitmap index, data query can be achieved, and there is no need to traverse the query memory data, so that the data query results can be quickly located and queried, thereby reducing the complex data search process and improving the feedback efficiency of the data query results.

[0067] In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, preferred embodiments are specifically cited below and described in detail with reference to the attached drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0068] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0069] Figure 1 A flowchart of a method for constructing a business assessment data bitmap index provided in an embodiment of the present application;

[0070] Figure 2 A flowchart of a method for querying business assessment data provided in an embodiment of the present application;

[0071] Figure 3 A schematic diagram of a performance data query process provided in an embodiment of the present application;

[0072] Figure 4 A schematic diagram of the structure of a device for constructing a bitmap index of business assessment data provided in an embodiment of the present application;

[0073] Figure 5 A schematic diagram of the structure of a device for querying business assessment data provided in an embodiment of the present application;

[0074] Figure 6 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0075] To make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application usually described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, each other embodiment obtained by those skilled in the art without making creative work belongs to the scope of protection of the present application.

[0076] According to research, commercial banks often need to supervise the marketing process of sales staff in customer marketing management. In the process of supervision, they often only focus on the statistics of the actual performance data of sales staff, but ignore the comparison and correlation analysis with the task goals. When it is necessary to statistically analyze the execution progress of each task goal, users are usually required to select the task goal and then calculate the task goal execution progress data independently. When there are many task goals, it is difficult to quickly find the task goals that need to be associated when performing correlation analysis on sales staff, and the calculation process is time-consuming and laborious, making the efficiency of task execution progress data analysis low.

[0077] Based on this, an embodiment of the present application provides a method for constructing a bitmap index of business assessment data, by associating an indicator configuration data table, an assessment object configuration table, an indicator execution data table, and a task configuration data table, to obtain a task execution schedule table that records the task execution progress records of the performance assessment objects; and by using the object identifier of the performance assessment object, the indicator identifier of the performance assessment indicator, and the task identifier of the performance assessment task, to create a multidimensional query bitmap index for the task execution schedule table, so that when there is a query requirement, the multidimensional query bitmap index can be used to realize the query of the task execution schedule table in multiple dimensions, thereby improving the retrieval efficiency and timeliness of data under huge data volumes.

[0078] See also Figure 1 , Figure 1 A flowchart of a method for constructing a business assessment data bitmap index provided in an embodiment of the present application. Figure 1 As shown in , the method for constructing a business assessment data bitmap index provided in the embodiment of the present application includes:

[0079] S101. Using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, by associating the appraisal object configuration table and the indicator execution data table, determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table.

[0080] S102. Determine the task execution schedule of the performance appraisal object by using the identification identifier configured for the indicator execution schedule and associating the task configuration data table; wherein the task execution schedule includes a plurality of task execution progress records.

[0081] S103. Based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, the multiple task execution progress records are classified and processed to create a multidimensional query bitmap index of the task execution schedule table, so as to use the multidimensional query bitmap index to realize the retrieval of the task execution progress records in the task execution schedule table.

[0082] A method for constructing a bitmap index of business appraisal data provided in an embodiment of the present application can establish a task execution schedule for a performance appraisal object by associating an indicator configuration data table, an appraisal object configuration table, an indicator execution data table, and a task configuration data table, so as to reflect the execution data of the performance appraisal object on each performance appraisal task through the task execution progress records in the task execution schedule; and use the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task to create a multidimensional query bitmap index for the task execution schedule, so that when there is a query demand, the multidimensional query bitmap index can be used to realize the query of the task execution schedule in multiple dimensions, thereby improving the retrieval efficiency and timeliness of data under huge data volumes.

[0083] In step S101, the database (MPP) pre-stores an indicator configuration data table, an assessment object configuration table, and an indicator execution data table; the indicator configuration data table records the indicator identifier, indicator name, assessment object targeted by the indicator, and other data of each business test indicator; the assessment object configuration table records the object identifier, object name, department to which the performance assessment object belongs, performance assessment indicators involved, and other data; the indicator execution data table records the indicator identifier, indicator name, actual completion value, and other data of each business test indicator.

[0084] By using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, the appraisal object configuration table and the indicator execution data table are respectively associated to realize the integration of the data in the above three data tables, and obtain the indicator execution progress table of the performance appraisal object recorded in the appraisal object configuration table; wherein, the indicator execution progress table can reflect the execution data of the performance appraisal object on each performance appraisal indicator.

[0085] In one implementation, step S101 includes:

[0086] S1011. Utilize the indicator identifier of each performance appraisal indicator to associate the performance appraisal object in the appraisal object configuration table with the performance appraisal object that needs to complete the performance appraisal indicator, and determine the indicator set data of the performance appraisal object.

[0087] In this step, given that the performance appraisal indicators involved in the performance appraisal objects are clearly recorded in the appraisal object configuration table, when associating the appraisal object configuration table, the indicator identifier of each performance appraisal indicator in the indicator configuration data table can be used to associate the performance appraisal objects recorded in the appraisal object configuration table to determine the performance appraisal indicators used as the basis for performance appraisal of the performance appraisal objects; that is, determine the indicator set data of the performance appraisal indicators involved in the performance appraisal objects.

[0088] S1012. Utilize the indicator identifier of each performance appraisal indicator in the indicator set data, associate with the indicator execution progress data recorded in the indicator execution data table, and determine the indicator execution detail data of each performance appraisal indicator of the performance appraisal object.

[0089] In this step, given that the indicator execution data of each performance appraisal indicator is clearly recorded in the indicator execution data table, when associating the indicator execution data table, the indicator identifier of each performance appraisal indicator in the indicator set data can be used to associate the indicator execution detail data of each performance appraisal indicator recorded in the indicator execution data table to determine the indicator execution detail data of the performance appraisal object under each performance appraisal indicator.

[0090] S1013: Integrate the indicator set data of the performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object to generate an indicator execution schedule for the performance appraisal object.

[0091] In this step, the indicator set data of the determined performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object are integrated into the same data table to obtain the indicator execution schedule of the performance appraisal object, so as to reflect the execution progress of the performance appraisal personnel under each performance appraisal indicator through the indicator execution schedule.

[0092] Here, taking into account that when conducting performance evaluation on the performance appraisal object, it is necessary to further refer to the performance appraisal tasks pre-set for the business appraisal, and then, comprehensively integrate the completion data of the performance appraisal object on the performance appraisal tasks to achieve the performance evaluation of the performance appraisal object; therefore, in order to improve the appraisal data involved in the performance appraisal object, the task configuration data table can be further associated on the basis of the indicator execution schedule to reflect the configuration status of the performance appraisal tasks of the performance appraisal object.

[0093] In step S102, the database (MPP) also pre-stores a task configuration data table, in which data such as task identification, task name, total task target value of the indicator, task value of each period of the indicator are recorded;

[0094] By using the identification mark configured for the indicator execution schedule, the stored task configuration data table is associated, and on the basis of the indicator execution schedule, the task execution progress of each performance appraisal task involved in each performance appraisal indicator of the performance appraisal object is further improved to obtain the task execution schedule of the performance appraisal object.

[0095] The task execution schedule includes multiple task execution progress records.

[0096] Among them, the task execution schedule includes multiple task execution progress records; each task execution progress record can reflect the task execution results of the performance appraisal object on each performance appraisal task, and the task execution progress record records data such as task identification, task name, total task target value of the indicator, task value of each period of the indicator, actual completion value of the indicator, etc.

[0097] Here, in order to quickly achieve the matching between task configuration data, performance evaluation indicators and performance evaluation objects, when associating the task configuration data table, only the identification mark configured for the indicator execution schedule is used; it can be seen that the identification mark of the indicator execution schedule can accurately locate each indicator execution progress record included in the indicator execution schedule.

[0098] In one embodiment, the identification mark of the indicator execution schedule is determined by the following steps: the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule are combined to form the identification mark of the indicator execution schedule.

[0099] In this step, in order to ensure that the identification identifier configured for the indicator execution schedule can clearly reflect the performance appraisal object involved in the indicator execution schedule and the performance appraisal indicators involved in each indicator execution progress record included in the indicator execution schedule, the identification identifier of the indicator execution schedule is formed by combining the object identifier of the performance appraisal object and the indicator identifier of the performance appraisal indicators involved in each indicator execution progress record; that is, the identification identifier of the indicator execution schedule is a character string formed by combining the object identifier and the indicator identifier.

[0100] In one implementation, step S102 includes:

[0101] S1021. Utilize the identification mark of the indicator execution schedule to associate the performance appraisal tasks to be completed by the performance appraisal subject in the task configuration data table, and determine the task execution detail data of the performance appraisal subject.

[0102] In this step, given that the task configuration data table records the execution details of different appraisal objects under each performance appraisal task, and on the premise that the identification mark of the indicator execution schedule has clearly defined the performance appraisal object and the performance appraisal indicator, the identification mark of the indicator execution schedule is used to associate the performance appraisal tasks that the performance appraisal object in the task configuration data table needs to complete under the performance appraisal indicator, so as to determine the task execution details data of the performance appraisal object.

[0103] S1022. Integrate the indicator execution schedule and the task execution detail data to determine the task execution schedule of the performance appraisal object.

[0104] In this step, the indicator execution schedule and task execution details data are integrated into the same data table to obtain the task execution schedule of the performance appraisal object, so as to reflect the execution progress of the performance appraisal tasks that the performance appraisal personnel need to complete under each performance appraisal indicator through the task execution schedule.

[0105] Here, we can further use the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task to construct a multidimensional query bitmap index for the task execution schedule, so as to assist the data retrieval process with the multidimensional query bitmap index.

[0106] In step S103, multiple task execution progress records are classified and processed using the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task. By assigning sub-query bitmap indexes to task execution progress records with the same object identifier, indicator identifier, and task identifier, a multi-dimensional query bitmap index of the task execution progress table is created. Furthermore, in the process of data retrieval, the query bitmap index can be used to achieve rapid query of related task execution progress records in the task execution progress table.

[0107] In one implementation, step S103 includes:

[0108] S1031. Using the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in each task execution progress record, the task execution progress records having the same object identifier, indicator identifier, and task identifier are divided into the same bitmap index group.

[0109] In this step, the task execution progress records in the task execution schedule are classified based on the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task involved in each task execution progress record, and the task execution progress records with the same object identifier, indicator identifier and task identifier are divided into the same bitmap index group; that is, the task execution progress records with the same object identifier, indicator identifier and task identifier are divided into the same bitmap index group.

[0110] S1032. For each bitmap index group, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group are determined as the multidimensional subquery bitmap index of the bitmap index group, so as to use the multidimensional subquery bitmap index to realize the query of the task execution progress record in the bitmap index group.

[0111] In this step, for each bitmap index group, since the task execution progress records in the bitmap index group have the same object identifier, indicator identifier and task identifier, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group can be determined as the subquery bitmap index of the bitmap index group; so that in the process of data retrieval, the task execution progress records in the bitmap index group can be accurately located and queried with the help of the subquery bitmap index.

[0112] S1033: Based on the multidimensional sub-query bitmap index of each bitmap index group, a multidimensional query bitmap index for obtaining the task execution schedule is created.

[0113] The method for constructing a business appraisal data bitmap index provided in the embodiment of the present application utilizes the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, and determines the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table; utilizes the identification identifier configured for the indicator execution schedule table, and determines the task execution schedule of the performance appraisal object by associating the task configuration data table; based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task, a multidimensional query bitmap index for the task execution schedule is created by classifying and processing multiple task execution progress records, so as to utilize the multidimensional query bitmap index to realize the retrieval of the task execution progress record in the task execution schedule. In this way, when there is a query demand, the multi-dimensional query bitmap index can be used to query the task execution schedule in multiple dimensions, thereby improving the retrieval efficiency and timeliness of data under huge data volumes; and, by matching the multi-dimensional query bitmap index, data query can be achieved, and there is no need to traverse the query memory data, so that the data query results can be quickly located and queried, thereby reducing the complex data search process and improving the feedback efficiency of the data query results.

[0114] See also Figure 2 , Figure 2 A flowchart of a method for querying business assessment data provided by an embodiment of the present application. Figure 2 As shown in , the query method of business assessment data provided by the embodiment of the present application includes:

[0115] S201. In response to receiving an assessment data retrieval request, read a data retrieval condition from the assessment data retrieval request.

[0116] S202: Using the data retrieval condition, by querying the data query results cached in the memory cache, determine whether there is a data query result that meets the data retrieval condition in the memory cache.

[0117] S203. If not, generate a search SQL statement by identifying from the data search conditions the object identifier of the performance appraisal object queried by the appraisal data search request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator.

[0118] S204: By executing the search SQL statement, with the help of the multi-dimensional query bitmap index of the task execution schedule in the database, a data query result that meets the data search condition is obtained from the task execution schedule.

[0119] S205, determining the task completion degree of the performance appraisal object based on the data query result;

[0120] S206: Feedback the task completion degree and the data query result to the client.

[0121] A method for querying business assessment data provided in an embodiment of the present application, when receiving an assessment data retrieval request, if there is no data query result that meets the data retrieval conditions in the memory cache, then with the help of a multi-dimensional query bitmap index in the task execution schedule, the data query result in the task execution schedule can be quickly located and queried, thereby improving the feedback efficiency of the data query result.

[0122] In step S201, the business service interface analyzes the assessment data retrieval request in response to receiving the assessment data retrieval request sent by the client, reads the data retrieval condition from the assessment data retrieval request, and uses the data retrieval condition to realize fast retrieval of data in the memory cache.

[0123] Here, in order to quickly respond to users' data retrieval requests and improve the feedback efficiency of data query results, during the historical retrieval process, some historical retrieval results will be cached in the memory cache, so that in the subsequent data retrieval process, if a data retrieval request with the same data retrieval conditions is received, the data query results can be fed back without searching the database; therefore, when a data retrieval request is received, data retrieval in the memory cache must be prioritized.

[0124] In step S202, the extracted data retrieval condition is used to query the data query results cached in the memory cache and obtained in the historical retrieval process to determine whether there are data query results that meet the data retrieval condition in the memory cache.

[0125] If there are data query results that meet the data retrieval conditions in the memory cache, the data query results can be directly obtained from the memory cache and feedback of the data query results can be realized, thereby simplifying the data retrieval process and improving data query efficiency.

[0126] Here, if there is no data query result that meets the data retrieval condition in the memory cache, it is necessary to further query the task execution schedule in the database to obtain the data query result that meets the data retrieval condition; at this time, it is necessary to further generate a retrieval SQL statement for searching the database;

[0127] At the same time, in order to be able to use the multidimensional query bitmap index of the task execution schedule to achieve rapid query of data query results, considering that the multidimensional query bitmap index of the task execution schedule is composed of three parts: object identifier, indicator identifier and task identifier, therefore, when generating a retrieval SQL statement, it is also necessary to identify from the data retrieval conditions the object identifier of the performance appraisal object queried by the appraisal data retrieval request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator, so as to facilitate comparison with the multidimensional query bitmap index of the task execution schedule.

[0128] In step S203, if there is no data query result that meets the data retrieval condition in the memory cache, the SQL encapsulation unit can be called to identify the object identifier of the performance appraisal object queried by the appraisal data retrieval request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator from the data retrieval condition, and generate a retrieval SQL statement for data query in the database.

[0129] In step S204, the data query control unit executes the generated retrieval SQL statement, calls the query method interface of the database (MPP), and completes the query in the task execution schedule with the help of the multidimensional query bitmap index of the task execution schedule in the database, so as to obtain the data query results that meet the data retrieval conditions from the task execution schedule.

[0130] The multi-dimensional query bitmap index of the task execution schedule is constructed by the method for constructing the business assessment data bitmap index described in the above embodiment.

[0131] In one implementation, step S204 includes:

[0132] S2041. By executing the retrieval SQL statement, and by comparing the object identifier, task identifier and indicator identifier carried in the retrieval SQL statement with the multidimensional query bitmap index of the task execution schedule in the database, determine the sub-query bitmap index including the object identifier, the task identifier and the indicator identifier in the multidimensional query bitmap index.

[0133] S2042: Determine the task execution progress record in the target bitmap index group corresponding to the sub-query bitmap index as a data query result that satisfies the data retrieval condition.

[0134] In this step, each task execution progress record is pre-divided into multiple bitmap index groups in the task execution progress table, and the task execution progress records in each bitmap index group have the same object identifier, task identifier and indicator identifier, and the sub-query bitmap index of the bitmap index group is the object identifier, task identifier and indicator identifier of any task execution progress record in the bitmap index group; it can be seen that if the sub-query bitmap index of the target bitmap index group includes the object identifier, task identifier and indicator identifier identified from the data retrieval condition, it can be explained that the task execution progress records in the target bitmap index group are all data query results that meet the data retrieval condition corresponding to the data retrieval threshold.

[0135] In step S205, after obtaining the data query results that meet the data retrieval conditions, the task completion degree of the performance appraisal object can be determined with the help of the business execution data of the business appraisal object in the data query results.

[0136] In one implementation, step S205 includes:

[0137] S2051. Analyze the data query results to determine the expected task value and actual completion value of the performance appraisal task of the performance appraisal object.

[0138] In this step, by analyzing the data query results, the expected task value and actual completion value of the performance appraisal task involved in the performance appraisal object are extracted from the data query results; wherein the performance appraisal task is the designated appraisal task that the performance appraisal object needs to complete under the performance appraisal indicators involved.

[0139] S2052. Determine the task completion degree of the performance appraisal object based on the expected task value and the actual completion value.

[0140] In this step, the progress completion percentage calculation module is called to calculate the task completion percentage (i.e., task completion degree) of the performance appraisal object under the performance appraisal task according to the calculation formula of actual completion value / expected task value.

[0141] In step S206, the task completion degree and data query results are fed back to the client so that the user can view the query results.

[0142] Here, in order to facilitate the user to perform data query, the data query results can be cached in the memory cache based on the actual situation of the data retrieval results, so that in the subsequent retrieval process, the data retrieval results can be quickly fed back.

[0143] Considering that if the data query results with a large data stream are stored in the memory cache, it will affect the number of data query results cached in the memory cache. In order to cache as many data query results as possible, after obtaining the data query results, you can choose whether to cache the data query results obtained from this query in the memory cache based on the number of data in the data query results.

[0144] In one embodiment, the data query method further includes: counting the number of records of task execution progress records included in the data query result; and caching the data query result in the memory cache when the number of records is less than a preset number threshold.

[0145] In this step, after obtaining the data query results that meet the data retrieval conditions, the number of records of the task execution progress records included in the statistical data query results can be cached in the memory cache if the number of records is less than a preset threshold (for example, the number of data is less than 10,000). If the number of records is greater than or equal to the preset threshold (for example, the number of data is greater than or equal to 10,000), the data query results are cached.

[0146] The query method of business assessment data provided by the embodiment of the present application is responsive to receiving an assessment data retrieval request, reading out data retrieval conditions from the assessment data retrieval request; using the data retrieval conditions, by querying the cached data query results in the memory cache, determining whether there is a data query result that meets the data retrieval conditions in the memory cache; if not, by identifying the object identifier of the performance assessment object queried by the assessment data retrieval request, the task identifier of the performance assessment task involved in the performance assessment object, and the indicator identifier of the performance assessment indicator from the data retrieval conditions, a retrieval SQL statement is generated; by executing the retrieval SQL statement, by means of the multidimensional query bitmap index of the task execution schedule, the data query result that meets the data retrieval conditions is obtained from the task execution schedule; based on the data query results, the task completion of the performance assessment object is determined; and the task completion and data query results are fed back to the client. In this way, the multidimensional query bitmap index of the task execution schedule can be used to realize the rapid positioning and query of the task execution progress record in the task execution schedule and the task completion of the performance assessment object, thereby improving the feedback efficiency of the data query results.

[0147] See also Figure 3 , Figure 3 A performance data query flow diagram provided in the embodiment of the present application. Figure 3 As shown, the performance data query process involves the client, memory cache, application service module and database (MPP) used by the user; the user sends an assessment data retrieval request through the client; the data query module receives the assessment data retrieval request through the business service interface, and queries whether there is a data query result in the memory cache that meets the data retrieval condition indicated by the assessment data retrieval request; if so, the data query module directly returns the data query result to the client through the business service interface; if not, a retrieval SQL statement for data query is generated through the SQL encapsulation unit; the data query control unit executes the generated retrieval SQL statement, calls the query method interface of the database (MPP), and obtains the data query result that meets the data retrieval condition from the application data table in the database with the help of the query bitmap index of the application data table in the database; and determines the task completion degree of the performance assessment object based on the obtained data query result.

[0148] The database (MPP) is pre-stored with an indicator configuration data table, an assessment object configuration table, an indicator execution data table and a task configuration data table; first, the indicator configuration data table, the assessment object configuration table and the indicator execution data table are associated with the indicator identifier to determine the indicator execution schedule of the performance assessment object; secondly, the task configuration data in the task configuration data table is associated with the identification identifier (indicator identifier and object identifier) ​​configured for the indicator execution schedule to determine the task execution schedule of the performance assessment object; a multi-dimensional query bitmap index of the task execution schedule is created using the object identifier of the performance assessment object, the indicator identifier of the performance assessment indicator and the task identifier of the performance assessment task.

[0149] See also Figure 4 , Figure 4 A schematic diagram of a structure of a device for constructing a bitmap index of business assessment data provided in an embodiment of the present application. Figure 4 As shown in , the construction device 400 includes:

[0150] The first association module 410 is used to determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration table;

[0151] The second associating module 420 is used to determine the task execution schedule of the performance appraisal object by associating the task configuration data table with the identification identifier configured for the indicator execution schedule; wherein the task execution schedule includes a plurality of task execution progress records;

[0152] The bitmap index creation module 430 is used to create a multidimensional query bitmap index of the task execution schedule based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, by classifying the multiple task execution progress records, so as to use the multidimensional query bitmap index to realize the retrieval of the task execution progress records in the task execution schedule.

[0153] Further, when the first association module 410 is used to determine the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, the first association module 410 is used to:

[0154] Using the indicator identifier of each performance appraisal indicator, the performance appraisal object in the appraisal object configuration table that needs to complete the performance appraisal indicator is associated to determine the indicator set data of the performance appraisal object;

[0155] Using the indicator identifier of each performance appraisal indicator in the indicator set data, associating the indicator execution progress data recorded in the indicator execution data table, and determining the indicator execution detail data of each performance appraisal indicator of the performance appraisal object;

[0156] The indicator set data of the performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object are integrated to generate an indicator execution schedule for the performance appraisal object.

[0157] Furthermore, the first association module 410 is used to determine the identification mark of the indicator execution schedule through the following steps:

[0158] The identification mark of the indicator execution schedule is formed by combining the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule.

[0159] Furthermore, when the second associating module 420 is used to determine the task execution schedule of the performance appraisal object by associating the task configuration data table with the identification identifier configured for the indicator execution schedule, the second associating module 420 is used to:

[0160] Using the identification mark of the indicator execution schedule, the performance appraisal task to be completed by the performance appraisal object in the task configuration data table is associated to determine the task execution detail data of the performance appraisal object;

[0161] The indicator execution schedule and the task execution detail data are integrated to determine the task execution schedule of the performance appraisal object.

[0162] Furthermore, when the bitmap index creation module 430 is used to create a multidimensional query bitmap index for the task execution schedule table by classifying the plurality of task execution progress records based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task, the bitmap index creation module 430 is used to:

[0163] Using the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in each task execution progress record, the task execution progress records having the same object identifier, the same indicator identifier, and the same task identifier are divided into the same bitmap index group;

[0164] For each bitmap index group, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group are determined as the multidimensional subquery bitmap index of the bitmap index group, so as to realize the query of the task execution progress record in the bitmap index group by using the multidimensional subquery bitmap index;

[0165] Based on the multidimensional sub-query bitmap index of each bitmap index group, a multidimensional query bitmap index for obtaining the task execution schedule is created.

[0166] The device for constructing a business appraisal data bitmap index provided in the embodiment of the present application utilizes the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, and determines the indicator execution schedule of the performance appraisal object recorded in the appraisal object configuration table by associating the appraisal object configuration table and the indicator execution data table; utilizes the identification identifier configured for the indicator execution schedule table, and determines the task execution schedule of the performance appraisal object by associating the task configuration data table; based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task, a multidimensional query bitmap index for the task execution schedule is created by classifying and processing multiple task execution progress records, so as to utilize the multidimensional query bitmap index to realize the retrieval of the task execution progress record in the task execution schedule. In this way, when there is a query demand, the multi-dimensional query bitmap index can be used to query the task execution schedule in multiple dimensions, thereby improving the retrieval efficiency and timeliness of data under huge data volumes; and, by matching the multi-dimensional query bitmap index, data query can be achieved, and there is no need to traverse the query memory data, so that the data query results can be quickly located and queried, thereby reducing the complex data search process and improving the feedback efficiency of the data query results.

[0167] See also Figure 5 , Figure 5 This is a schematic diagram of a structure of a device for querying business assessment data provided by an embodiment of the present application. Figure 5 As shown in , the query device 500 includes:

[0168] The data reading module 510 is used to read the data retrieval condition from the assessment data retrieval request in response to receiving the assessment data retrieval request;

[0169] A first query module 520 is used to use the data retrieval condition to determine whether there is a data query result that meets the data retrieval condition in the memory cache by querying the data query results cached in the memory cache;

[0170] A statement generation module 530 is used to generate a search SQL statement by identifying the object identifier of the performance appraisal object queried by the appraisal data retrieval request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator from the data retrieval condition if no;

[0171] The second query module 540 is used to obtain data query results that meet the data retrieval condition from the task execution schedule by executing the retrieval SQL statement with the help of the multidimensional query bitmap index of the task execution schedule in the database; wherein the multidimensional query bitmap index of the task execution schedule is constructed by the business assessment data bitmap index construction device described above;

[0172] A calculation module 550, for determining the task completion degree of the performance appraisal object based on the data query result;

[0173] The result feedback module 560 is used to feed back the task completion degree and the data query result to the client.

[0174] Furthermore, when the calculation module 550 is used to determine the task completion degree of the performance appraisal object based on the data query result, the calculation module 550 is used to:

[0175] Analyze the data query results to determine the expected task value and actual completion value of the performance appraisal task of the performance appraisal object;

[0176] Based on the expected task value and the actual completion value, the task completion degree of the performance appraisal object is determined.

[0177] Furthermore, the query device 500 further includes a cache module (not shown in the figure), and the cache module is used to:

[0178] Counting the number of task execution progress records included in the data query result;

[0179] When the number of records is less than a preset number threshold, the data query result is cached in the memory cache.

[0180] The query device for business assessment data provided by the embodiment of the present application, in response to receiving an assessment data retrieval request, reads out data retrieval conditions from the assessment data retrieval request; uses the data retrieval conditions to query the cached data query results in the memory cache to determine whether there is a data query result that meets the data retrieval conditions in the memory cache; if not, generates a retrieval SQL statement by identifying the object identifier of the performance assessment object queried by the assessment data retrieval request, the task identifier of the performance assessment task involved in the performance assessment object, and the indicator identifier of the performance assessment indicator from the data retrieval conditions; by executing the retrieval SQL statement, obtains the data query result that meets the data retrieval conditions from the task execution schedule by means of the multidimensional query bitmap index of the task execution schedule; determines the task completion of the performance assessment object based on the data query result; and feeds back the task completion and the data query result to the client. In this way, the multidimensional query bitmap index of the task execution schedule can be used to realize the rapid positioning and query of the task execution progress record in the task execution schedule and the task completion of the performance assessment object, thereby improving the feedback efficiency of the data query result.

[0181] See also Figure 6 , Figure 6 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 6 As shown in , the electronic device 600 includes a processor 610 , a memory 620 and a bus 630 .

[0182] The memory 620 stores machine-readable instructions executable by the processor 610. When the electronic device 600 is running, the processor 610 communicates with the memory 620 via the bus 630. When the machine-readable instructions are executed by the processor 610, the above-mentioned Figure 1 The steps of the method for constructing the business assessment data bitmap index in the method embodiment shown and Figure 2 The steps of the method for querying business assessment data in the method embodiment shown, the specific implementation method can be found in the method embodiment, and will not be repeated here.

[0183] The present application also provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the computer program can execute the above-mentioned Figure 1 The steps of the method for constructing the business assessment data bitmap index in the method embodiment shown and Figure 2 The steps of the method for querying business assessment data in the method embodiment shown, the specific implementation method can be found in the method embodiment, and will not be repeated here.

[0184] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0185] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of devices or units can be electrical, mechanical or other forms.

[0186] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0187] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0188] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a non-volatile computer-readable storage medium that is executable by a processor. Based on this understanding, the technical solution of the present application can essentially be embodied in the form of a software product, or in other words, the part that contributes to the prior art or the part of the technical solution. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0189] Finally, it should be noted that the above-described embodiments are only specific implementation methods of the present application, which are used to illustrate the technical solutions of the present application, rather than to limit them. The protection scope of the present application is not limited thereto. Although the present application is described in detail with reference to the above-mentioned embodiments, ordinary technicians in the field should understand that any technician familiar with the technical field can still modify the technical solutions recorded in the above-mentioned embodiments within the technical scope disclosed in the present application, or can easily think of changes, or make equivalent replacements for some of the technical features therein; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.

Claims

1. A method for constructing a bitmap index of business assessment data, characterized in that: The construction method comprises: Using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table, the performance appraisal object that needs to complete the performance appraisal indicator in the appraisal object configuration table is associated, and then using the indicator identifier of each performance appraisal indicator, the indicator execution progress data of each performance appraisal indicator that needs to be completed by the performance appraisal object in the indicator execution data table is associated to determine the indicator execution progress table of the performance appraisal object recorded in the appraisal object configuration table; By using the identification mark configured for the indicator execution schedule, the indicator execution schedule is associated with the performance appraisal task to be completed by the performance appraisal object in the task configuration data table to determine the task execution schedule of the performance appraisal object; wherein the task execution schedule includes a plurality of task execution progress records; Based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, a multidimensional query bitmap index of the task execution schedule is created by classifying the plurality of task execution progress records, so as to realize the retrieval of the task execution progress records in the task execution schedule by using the multidimensional query bitmap index; The identification mark of the indicator execution schedule is determined by the following steps: The identification mark of the indicator execution schedule is formed by combining the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule.

2. The construction method according to claim 1, characterized in that: The method of using the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table to associate the performance appraisal object that needs to complete the performance appraisal indicator in the appraisal object configuration table, and then using the indicator identifier of each performance appraisal indicator to associate the indicator execution progress data of each performance appraisal indicator that needs to be completed by the performance appraisal object in the indicator execution data table, and determining the indicator execution progress table of the performance appraisal object recorded in the appraisal object configuration table, includes: Using the indicator identifier of each performance appraisal indicator, the performance appraisal object in the appraisal object configuration table that needs to complete the performance appraisal indicator is associated to determine the indicator set data of the performance appraisal object; Using the indicator identifier of each performance appraisal indicator in the indicator set data, associating the indicator execution progress data recorded in the indicator execution data table, and determining the indicator execution detail data of each performance appraisal indicator of the performance appraisal object; The indicator set data of the performance appraisal object and the indicator execution detail data of each performance appraisal indicator involved in the performance appraisal object are integrated to generate an indicator execution schedule for the performance appraisal object.

3. The construction method according to claim 1, characterized in that: The step of using the identification mark configured for the indicator execution schedule to associate the indicator execution schedule with the performance appraisal task to be completed by the performance appraisal object in the task configuration data table to determine the task execution schedule of the performance appraisal object includes: Using the identification mark of the indicator execution schedule, the performance appraisal task to be completed by the performance appraisal object in the task configuration data table is associated to determine the task execution detail data of the performance appraisal object; The indicator execution schedule and the task execution detail data are integrated to determine the task execution schedule of the performance appraisal object.

4. The construction method according to claim 1, characterized in that: The method of creating a multidimensional query bitmap index of the task execution schedule table by classifying the plurality of task execution progress records based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task comprises: Using the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in each task execution progress record, the task execution progress records having the same object identifier, the same indicator identifier, and the same task identifier are divided into the same bitmap index group; For each bitmap index group, the object identifier of the performance appraisal object, the indicator identifier of the performance appraisal indicator, and the task identifier of the performance appraisal task involved in any task execution progress record in the bitmap index group are determined as the multidimensional subquery bitmap index of the bitmap index group, so as to realize the query of the task execution progress record in the bitmap index group by using the multidimensional subquery bitmap index; Based on the multidimensional sub-query bitmap index of each bitmap index group, a multidimensional query bitmap index for obtaining the task execution schedule is created.

5. A method for querying business assessment data, characterized in that: The query method comprises: In response to receiving the assessment data retrieval request, reading a data retrieval condition from the assessment data retrieval request; Using the data retrieval condition, by querying the data query results cached in the memory cache, determining whether there is a data query result in the memory cache that meets the data retrieval condition; If not, generating a search SQL statement by identifying the object identifier of the performance appraisal object queried by the appraisal data search request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator from the data search condition; By executing the retrieval SQL statement, with the help of the multidimensional query bitmap index of the task execution schedule in the database, a data query result that meets the data retrieval condition is obtained from the task execution schedule; wherein the multidimensional query bitmap index of the task execution schedule is constructed by the method for constructing the business assessment data bitmap index according to any one of claims 1 to 4; Determining the task completion degree of the performance appraisal object based on the data query result; The task completion degree and the data query result are fed back to the client.

6. The query method according to claim 5, characterized in that: Determining the task completion degree of the performance appraisal object based on the data query result includes: Analyze the data query results to determine the expected task value and actual completion value of the performance appraisal task of the performance appraisal object; Based on the expected task value and the actual completion value, the task completion degree of the performance appraisal object is determined.

7. The query method according to claim 5, characterized in that: The query method further includes: Counting the number of task execution progress records included in the data query result; When the number of records is less than a preset number threshold, the data query result is cached in the memory cache.

8. A device for constructing a bitmap index of business assessment data, characterized in that: The construction device comprises: The first association module is used to use the indicator identifier of each performance appraisal indicator recorded in the indicator configuration data table to associate the performance appraisal object that needs to complete the performance appraisal indicator in the appraisal object configuration table, and then use the indicator identifier of each performance appraisal indicator to associate the indicator execution progress data of each performance appraisal indicator that needs to be completed by the performance appraisal object in the indicator execution data table, and determine the indicator execution progress table of the performance appraisal object recorded in the appraisal object configuration table; A second association module is used to use the identification identifier configured for the indicator execution schedule to associate the indicator execution schedule with the performance assessment task to be completed by the performance assessment object in the task configuration data table, and determine the task execution schedule of the performance assessment object; wherein the task execution schedule includes a plurality of task execution progress records; A bitmap index creation module is used to create a multidimensional query bitmap index for the task execution schedule based on the object identifier of the performance appraisal object involved in each task execution progress record, the indicator identifier of the performance appraisal indicator and the task identifier of the performance appraisal task, by classifying the plurality of task execution progress records, so as to realize the retrieval of the task execution progress records in the task execution schedule by using the multidimensional query bitmap index; The first association module is used to determine the identification mark of the indicator execution schedule through the following steps: The identification mark of the indicator execution schedule is formed by combining the object mark of the performance appraisal object and the indicator mark of the performance appraisal indicator involved in each indicator execution progress record recorded in the indicator execution schedule.

9. A device for querying business assessment data, characterized in that: The query device comprises: A data reading module, configured to read data retrieval conditions from the assessment data retrieval request in response to receiving the assessment data retrieval request; A first query module, configured to use the data retrieval condition to determine whether there is a data query result that meets the data retrieval condition in the memory cache by querying the data query results cached in the memory cache; A statement generation module, for generating a search SQL statement by identifying, from the data search conditions, the object identifier of the performance appraisal object queried by the appraisal data search request, the task identifier of the performance appraisal task involved in the performance appraisal object, and the indicator identifier of the performance appraisal indicator; A second query module is used to obtain data query results that meet the data retrieval conditions from the task execution schedule by executing the retrieval SQL statement with the help of the multidimensional query bitmap index of the task execution schedule in the database; wherein the multidimensional query bitmap index of the task execution schedule is constructed by the construction device of the business assessment data bitmap index according to any one of claim 8; A calculation module, used to determine the task completion degree of the performance appraisal object based on the data query result; The result feedback module is used to feed back the task completion degree and the data query result to the client.