Medical index data calculation method, device and equipment

Abstract

The invention provides a medical index data calculation method, device and equipment, and relates to the technical field of medical treatment. The method comprises the steps of obtaining a medical index calculation request; according to the name of the target medical index, adopting a preset first calculation engine to generate a first query language script of the target medical index; analyzing the main calculation logic in the first query language script by adopting a preset second calculation engine to obtain a second query language script of each query index corresponding to the target medical index; executing the second query language script by adopting a preset second calculation engine, and executing data query operation on the business database of the target medical institution to obtain data of each query index; and executing the main calculation logic according to the data of each query index by adopting a preset second calculation engine to obtain statistical data of the target medical index. Therefore, the ambiguity of the index data is eliminated, and the utilization efficiency of the medical data is improved.

Description

Technical Field

[0001] The present invention relates to the field of medical technology, and in particular to a method, device and equipment for calculating medical indicator data. Background Art

[0002] As the degree of digitalization of hospitals continues to improve and business product forms become increasingly diversified, the scale of business data is also becoming increasingly complex. In this context, hospitals need to use business data to conduct data statistics and analysis in areas such as daily hospital operations and medical business management. When faced with daily application scenarios, there are often problems such as ambiguity of indicators (such as: number of visits, which can be calculated by the patient's first visit time, patient check-in time, last visit time, etc.), low data utilization efficiency, low data application value, and difficulty in indicator development. The above problems are particularly prominent in the medical industry. Depending on the size of the hospital, the management model, and the type of hospital, there will be differences in the hospital's medical indicators. In addition, the large amount of data leads to low efficiency in the use of medical data. Summary of the invention

[0003] The purpose of the present invention is to provide a medical indicator data calculation method, device and equipment to address the deficiencies in the above-mentioned prior art, so as to solve the problems in the prior art that lead to low efficiency in medical data utilization.

[0004] To achieve the above purpose, the technical solution adopted in the embodiment of the present application is as follows:

[0005] In a first aspect, an embodiment of the present application provides a method for calculating medical indicator data, the method comprising:

[0006] Obtaining a medical indicator calculation request, wherein the medical indicator calculation request includes: a name of a target medical indicator and a name of a target medical institution;

[0007] According to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator, wherein the first query language script includes: a main calculation logic of the target medical indicator and the name of the target medical institution;

[0008] Using a preset second computing engine, the main computing logic in the first query language script is parsed to obtain a second query language script for each query indicator corresponding to the target medical indicator;

[0009] Using the preset second computing engine, executing the second query language script, performing a data query operation on the business database of the target medical institution, and obtaining data of each query indicator;

[0010] The preset second computing engine is used to execute the main computing logic according to the data of each query indicator to obtain statistical data of the target medical indicator.

[0011] Optionally, the step of generating a first query language script for the target medical indicator by using a preset first computing engine according to the name of the target medical indicator includes:

[0012] Using the preset first calculation engine, according to the name of the target medical indicator, obtaining the indicator definition rule of the target medical indicator;

[0013] Using the preset first computing engine, obtaining the statistical dimension of the target medical indicator and the main computing logic from the indicator definition rule, and generating the first query language script according to the statistical dimension and the main computing logic;

[0014] The method of using the preset second computing engine to execute the main computing logic according to the data of each query indicator to obtain the statistical data of the target medical indicator includes:

[0015] The preset second computing engine is used to execute the main computing logic according to the data of each query indicator and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension.

[0016] Optionally, the medical indicator calculation request further includes: information on business application scenarios;

[0017] The adopting the preset first calculation engine to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator includes:

[0018] The preset first calculation engine is used to obtain the indicator definition rule of the target medical indicator in the target application scenario according to the name of the target medical indicator and the information of the target application scenario.

[0019] Optionally, the medical indicator calculation request further includes: calculation conditions and statistical period;

[0020] The generating the first query language script according to the statistical dimension and the main calculation logic includes:

[0021] The first query language is generated according to the statistical dimension, the main calculation logic, the calculation condition and the statistical period.

[0022] Optionally, if the indicator definition rule further includes: auxiliary calculation logic of the target medical indicator;

[0023] The generating the first query language script according to the statistical dimension and the main calculation logic includes:

[0024] Generate the first query language script according to the statistical dimension, the main calculation logic and the auxiliary calculation logic;

[0025] The using of the preset second computing engine to execute the main computing logic according to the data of each query indicator and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension includes:

[0026] The preset second computing engine is used to execute the auxiliary computing logic according to the data of each query indicator, and the main computing logic is executed according to the indicator data after the auxiliary calculation and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension.

[0027] Optionally, the medical indicator calculation request further includes: result calculation logic, and the method further includes:

[0028] The preset first calculation engine is used to execute the result calculation logic according to the statistical data of the target medical indicator to obtain the statistical calculation result of the target medical indicator.

[0029] Optionally, before adopting the preset first calculation engine to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator, the method further includes:

[0030] According to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table, the target medical indicator is configured with rules using a visual interface to obtain the indicator definition rules of the target medical indicator under the target application scenario, wherein the preset summary logic table records information on multiple summary methods, the preset statistical dimension logic table records information on at least two statistical dimensions, and the preset business fact detail table records information on at least two indicators.

[0031] Optionally, before configuring the target medical indicator rules using a visual interface according to the preset summary logic table, the preset statistical dimension logic table, and the preset business fact detail table, and obtaining the indicator definition rules of the target medical indicator in the target application scenario, the method further includes:

[0032] Obtain data on multiple existing medical indicators;

[0033] Performing data domain division on the plurality of existing medical indicator data to obtain information of the at least two statistical dimensions and medical indicator data of at least two medical business behaviors;

[0034] Constructing the preset statistical dimension logic table according to the information of the at least two statistical dimensions;

[0035] According to the medical indicator data of the at least two medical business behaviors, the preset business fact detail tables of the at least two medical business behaviors are respectively constructed.

[0036] In a second aspect, an embodiment of the present application provides a medical indicator data calculation device, the device comprising:

[0037] An acquisition module, used for acquiring a medical indicator calculation request, wherein the medical indicator calculation request includes: a name of a target medical indicator and a name of a target medical institution;

[0038] A generating module, configured to generate a first query language script for the target medical indicator according to the name of the target medical indicator by using a preset first computing engine, wherein the first query language script includes: a main computing logic for the target medical indicator and the name of the target medical institution;

[0039] A parsing module, configured to parse the main computing logic in the first query language script using a preset second computing engine, and obtain a second query language script for each query indicator corresponding to the target medical indicator;

[0040] A query module, used to use the preset second computing engine to execute the second query language script, perform a data query operation on the business database of the target medical institution, and obtain the data of each query indicator;

[0041] The calculation module is used to use the preset second calculation engine to execute the main calculation logic according to the data of each query indicator to obtain the statistical data of the target medical indicator.

[0042] In a third aspect, an embodiment of the present application provides an electronic device, comprising: a processor and a storage medium, wherein the processor and the storage medium are communicatively connected via a bus, the storage medium stores program instructions executable by the processor, and the processor calls the program stored in the storage medium to execute the steps of the medical indicator data calculation method as described in any one of the first aspects.

[0043] Compared with the prior art, this application has the following beneficial effects:

[0044] The present application provides a method, device and equipment for calculating medical indicator data. The method obtains a medical indicator calculation request, which includes: the name of the target medical indicator and the name of the target medical institution; according to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator, and the first query language script includes: the main calculation logic of the target medical indicator and the name of the target medical institution; a preset second calculation engine is used to parse the main calculation logic in the first query language script to obtain a second query language script for each query indicator corresponding to the target medical indicator; a preset second calculation engine is used to execute the second query language script, and a data query operation is performed on the business database of the target medical institution to obtain the data of each query indicator; a preset second calculation engine is used to execute the main calculation logic according to the data of each query indicator to obtain the statistical data of the target medical indicator. Thus, the ambiguity of indicator data is eliminated, and the indicator caliber is unified for medical institutions, thereby avoiding duplication of indicators, saving indicator research and development costs, and at the same time ensuring the identity of indicator caliber, improving the utilization efficiency of medical data, and avoiding duplication of work. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention 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 creative work.

[0046] Figure 1 A flowchart of a method for calculating medical indicator data provided in an embodiment of the present application;

[0047] Figure 2 A flowchart of a method for generating a first query language script for a target medical indicator provided by the present application;

[0048] Figure 3 A flowchart of another method for generating a first query language script for a target medical indicator provided by the present application;

[0049] Figure 4 A flowchart of a method for constructing a preset statistical dimension logic table and a preset business fact detail table provided for this application;

[0050] Figure 5 A schematic diagram of atomic indicator configuration provided in an embodiment of the present application;

[0051] Figure 6 A schematic diagram of the derived indicator configuration provided in the embodiment of the present application;

[0052] Figure 7 A schematic diagram of the composite index configuration provided in the embodiment of the present application;

[0053] Figure 8 A schematic diagram of a medical indicator data calculation device provided in an embodiment of the present application;

[0054] Fig. 9 A schematic diagram of an electronic device provided in an embodiment of the present application.

[0055] Icons: 801 - acquisition module, 802 - generation module, 803 - parsing module, 804 - query module, 805 - calculation module, 901 - processor, 902 - storage medium. DETAILED DESCRIPTION

[0056] In order to make the purpose, technical scheme and advantages of the embodiments of the present invention 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 part of the embodiments of the present application, rather than all the embodiments. The components of the embodiments of the present application described and shown in the drawings here can be arranged and designed in various different configurations.

[0057] Therefore, the following detailed description of the embodiments of the present application provided in the accompanying drawings is not intended to limit the scope of the present application for protection, but merely represents selected embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present application.

[0058] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.

[0059] In addition, the terms “first”, “second”, etc., if used, are merely used to distinguish between the descriptions and should not be understood as indicating or implying relative importance.

[0060] It should be noted that, in the absence of conflict, the features in the embodiments of the present invention may be combined with each other.

[0061] The following is an explanation of a medical indicator data calculation method provided in this application through a specific example. Figure 1 The following is a flow chart of a method for calculating medical indicator data provided by an embodiment of the present application. The method is applied to electronic devices, for example, the electronic devices may be desktop computers or tablet computers. Figure 1 As shown, the method includes:

[0062] S101. Obtain a medical indicator calculation request.

[0063] The medical indicator calculation request includes: the name of the target medical indicator and the name of the target medical institution.

[0064] The user can input a medical indicator calculation request through the visual operation interface. Specifically, input the name of the target medical indicator and the name of the target medical institution, so as to obtain and calculate the target medical indicator data of the target medical institution in the subsequent steps.

[0065] For example, the name of the medical indicator is the number of outpatient and emergency registration operations, and the target medical institution is the First People's Hospital.

[0066] S102. According to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator.

[0067] The first query language script includes: the main calculation logic of the target medical indicator and the name of the target medical institution. The main calculation logic of the medical indicator can be a calculation expression of the medical indicator.

[0068] Each medical indicator has a corresponding main calculation logic, through which the data of the medical indicator can be calculated. The data of the medical indicator can be further limited by the name of the medical institution, and the data of the medical indicator can be obtained as required. Therefore, there is no need to rewrite the language script for the medical indicator, saving R&D costs.

[0069] By way of example, the first query language is DQL (Data Query Language).

[0070] S103. Use a preset second computing engine to parse the main computing logic in the first query language script to obtain a second query language script for each query indicator corresponding to the target medical indicator.

[0071] The main calculation logic of medical indicators calculates medical indicators through multiple query indicators. Therefore, the main calculation logic will include at least one query indicator. The query indicator is a pre-set standardized indicator. Medical staff will operate according to the standardized query indicator in daily operations. Therefore, by setting the query indicator, the hospital can unify the indicator caliber and avoid duplication of indicators.

[0072] The second query language of each query indicator is used to query and obtain data of each query indicator. For example, the second query language is Structured Query Language.

[0073] For example, a divide-and-conquer algorithm is used to disassemble the main calculation logic in the first query language script step by step to obtain query indicators that can be queried in the database. By parsing the query language corresponding to the target medical indicator, the query indicator is obtained, making the indicator query more accurate and avoiding the ambiguity of medical indicators (inconsistent caliber and definition).

[0074] S104. Use a preset second computing engine to execute a second query language script, perform a data query operation on the business database of the target medical institution, and obtain data of each query indicator.

[0075] S105. Use the preset second calculation engine to execute the main calculation logic according to the data of each query indicator to obtain statistical data of the target medical indicator.

[0076] After obtaining the data of each query indicator, according to the calculation relationship between the target medical indicator and each query indicator in the main calculation logic, the statistical data of the target medical indicator is calculated based on the data of each query indicator.

[0077] For example, the target medical index is the number of valid registrations, and the query indicators are the number of registrations received and the number of outpatient and emergency department registration cancellations. The calculation relationship between the target medical index and the query indicators is: the number of valid registrations = the number of registrations received - the number of outpatient and emergency department registration cancellations.

[0078] Thus, the ambiguity of indicator data is eliminated, and the indicator caliber is unified for medical institutions, thereby avoiding duplication of indicators and saving indicator research and development costs, while ensuring the identity of indicator caliber and avoiding duplication of work.

[0079] In summary, in this embodiment, a medical indicator calculation request is obtained, and the medical indicator calculation request includes: the name of the target medical indicator and the name of the target medical institution; according to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator, and the first query language script includes: the main calculation logic of the target medical indicator and the name of the target medical institution; a preset second calculation engine is used to parse the main calculation logic in the first query language script to obtain a second query language script for each query indicator corresponding to the target medical indicator; a preset second calculation engine is used to execute the second query language script, and a data query operation is performed on the business database of the target medical institution to obtain the data of each query indicator; a preset second calculation engine is used to execute the main calculation logic according to the data of each query indicator to obtain the statistical data of the target medical indicator. Thus, the ambiguity of indicator data is eliminated, and the indicator caliber is unified for medical institutions, thereby avoiding duplication of indicators, saving indicator research and development costs, and at the same time ensuring the identity of indicator caliber, improving the utilization efficiency of medical data, and avoiding duplication of work.

[0080] In the above Figure 1Based on the corresponding embodiments, the present application also provides a method for generating a first query language script for a target medical indicator. Figure 2 The flowchart of the method for generating a first query language script of a target medical indicator provided by the present application is as follows. Figure 2 As shown, in S102, according to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator, including:

[0081] S201. Using a preset first calculation engine, and according to the name of the target medical indicator, obtaining an indicator definition rule of the target medical indicator.

[0082] The indicator definition rules include the definition of the indicator, the query indicators from which the indicator is calculated, and how the indicator is calculated.

[0083] S202. Using a preset first computing engine, obtain the statistical dimension and main computing logic of the target medical indicator from the indicator definition rule, and generate a first query language script according to the statistical dimension and the main computing logic.

[0084] The statistical dimension refers to the angle from which the indicator data is counted (for example, the statistical dimension may be department or gender).

[0085] In S105, the preset second calculation engine is used to execute the main calculation logic according to the data of each query indicator to obtain the statistical data of the target medical indicator, including:

[0086] S203. Use the preset second computing engine to execute the main computing logic according to the data and statistical dimensions of each query indicator to obtain the statistical data of the target medical indicator under the statistical dimension.

[0087] The statistical data are limited by the statistical dimensions so that the statistical data meet the statistical needs of users. At the same time, it is also convenient to display the statistical data by using the statistical dimensions.

[0088] In summary, in this embodiment, the preset first calculation engine is used to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator; the preset first calculation engine is used to obtain the statistical dimension and main calculation logic of the target medical indicator from the indicator definition rule, and the first query language script is generated according to the statistical dimension and the main calculation logic; the preset second calculation engine is used to execute the main calculation logic according to the data and statistical dimension of each query indicator to obtain the statistical data of the target medical indicator under the statistical dimension. Thus, the statistical data under each statistical dimension can be calculated more accurately.

[0089] In the above Figure 2 On the basis of the corresponding embodiment, in another embodiment of the present application, the medical indicator calculation request also includes: information on business application scenarios.

[0090] In S201, the preset first calculation engine is used to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator, including:

[0091] A preset first calculation engine is used to obtain an indicator definition rule of the target medical indicator in the target application scenario according to the name of the target medical indicator and information of the target application scenario.

[0092] By setting application scenarios, corresponding statistical data can be generated according to different application scenarios.

[0093] For example, the medical indicator in the business application scenario is: the settlement amount of the whole hospital. Then business application scenario 1 is: according to the hospital business type, it can be statistically calculated according to the outpatient, emergency, and inpatient business types. Business application scenario 2: according to the hospital business department, it can be statistically calculated according to the pediatrics, obstetrics and gynecology, rheumatology and immunology departments and other business departments.

[0094] In summary, in this embodiment, the medical indicator calculation request also includes: information about the business application scenario; using a preset first calculation engine, according to the name of the target medical indicator and the information about the target application scenario, obtaining the indicator definition rule of the target medical indicator in the target application scenario. Thus, statistical data of different application scenarios are displayed.

[0095] In the above Figure 2 On the basis of the corresponding embodiment, in another embodiment of the present application, the medical indicator calculation request further includes: calculation conditions and statistical period.

[0096] In S202, a first query language script is generated according to the statistical dimension and the main calculation logic, including:

[0097] A first query language is generated according to the statistical dimension, main calculation logic, calculation conditions and statistical period.

[0098] For example, the statistical cycle is a statistical time period, for example, statistics of data from last month.

[0099] For example, if the medical indicator is: the settlement amount of the entire hospital, the calculation condition is: the filter that can be calculated according to the accounting department, medical insurance type, etc.

[0100] In summary, in this embodiment, the medical index calculation request also includes: calculation conditions and statistical period; and generating the first query language according to the statistical dimension, main calculation logic, calculation conditions and statistical period, so as to limit the statistical data in a personalized manner.

[0101] In the above Figure 2Based on the corresponding embodiment, the present application also provides another method for generating a first query language script for a target medical indicator. Figure 3 A flowchart of another method for generating a first query language script for a target medical indicator provided by the present application. Figure 3 As shown, if the indicator definition rule also includes: auxiliary calculation logic of the target medical indicator.

[0102] In S202, a first query language script is generated according to the statistical dimension and the main calculation logic, including:

[0103] S301. Generate a first query language script according to the statistical dimension, the main calculation logic and the auxiliary calculation logic.

[0104] Among them, the auxiliary calculation logic is the calculation logic added on the basis of the main calculation logic, such as auxiliary calculations such as completing dimension data and field sorting.

[0105] In S203, the preset second calculation engine is used to execute the main calculation logic according to the data and statistical dimensions of each query indicator to obtain the statistical data of the target medical indicator under the statistical dimension, including:

[0106] S302. Use the preset second calculation engine to execute the auxiliary calculation logic according to the data of each query indicator, and execute the main calculation logic according to the indicator data and statistical dimension after the auxiliary calculation to obtain the statistical data of the target medical indicator under the statistical dimension.

[0107] In summary, in this embodiment, if the indicator definition rule also includes: auxiliary calculation logic of the target medical indicator; generating a first query language script according to the statistical dimension, the main calculation logic and the auxiliary calculation logic; using the preset second calculation engine, executing the auxiliary calculation logic according to the data of each query indicator, and executing the main calculation logic according to the indicator data and statistical dimension after the auxiliary calculation, to obtain the statistical data of the target medical indicator under the statistical dimension. Thus, by introducing the auxiliary calculation logic, the statistical data can be accurately calculated.

[0108] In the above Figure 1 On the basis of the corresponding embodiment, in another embodiment of the present application, the medical indicator calculation request further includes: result calculation logic, and the method further includes:

[0109] A preset first calculation engine is used to execute result calculation logic according to the statistical data of the target medical indicator to obtain the statistical calculation result of the target medical indicator.

[0110] The result calculation logic is to process the calculated statistical data, such as format checking the statistical data to form a unified data format.

[0111] In summary, in this embodiment, the medical indicator calculation request also includes: result calculation logic, using a preset first calculation engine, executing the result calculation logic according to the statistical data of the target medical indicator, and obtaining the statistical calculation result of the target medical indicator. Thus, by introducing the result calculation logic, the statistical data can be accurately calculated.

[0112] On the basis of the above embodiment, in another embodiment of the present application, before adopting the preset first calculation engine in S201 to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator, the method further includes:

[0113] According to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table, a visual interface is used to configure the rules of the target medical indicators to obtain the indicator definition rules of the target medical indicators in the target application scenario.

[0114] Among them, the preset summary logic table records information on multiple summary methods, the preset statistical dimension logic table records information on at least two statistical dimensions, and the preset business fact detail table records information on at least two indicators.

[0115] The aggregation method is the calculation method, such as counting, summing, and average. The preset business fact detail table is used to store quantitative business data (such as registration records, medical order records, etc.). The preset statistical dimension logic table is used to store descriptive data (such as department, gender, etc.). The aggregation logic table is large, which is convenient for fast data query. The analysis dimension model table is small and provides a statistical perspective.

[0116] For example, the user can modify the preset summary logic table, preset statistical dimension logic table and preset business fact detail table through the visual interface, for example, delete the flag, organization, creation time, change time, modify the business occurrence date, modify the business occurrence time, and modify the channel code.

[0117] Based on the above embodiments, the present application also provides a method for constructing a preset statistical dimension logic table and a preset business fact detail table. Figure 4 A flowchart of a method for constructing a preset statistical dimension logic table and a preset business fact detail table provided in this application. Figure 4 As shown, according to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table, the target medical indicator is configured with a visual interface to obtain the indicator definition rule of the target medical indicator in the target application scenario, and the method also includes:

[0118] S401. Acquire multiple existing medical indicator data.

[0119] Conduct indicator searches and surveys on existing medical institutions to generate medical indicator data.

[0120] For example, let's take the medical indicator of effective registration number as an example. The calculation logic of effective registration number in each hospital is different. Now, through the investigation and analysis of the indicators used by a certain hospital in the past, we have obtained the example indicator: effective registration number = number of registrations received - number of outpatient and emergency department registration cancellations. Three indicators are analyzed from the effective registration number, namely the number of outpatient and emergency department registration operations, the number of registrations received, and the number of outpatient and emergency department registration cancellations.

[0121] S402. Divide the data domains of the plurality of existing medical indicator data to obtain information of at least two statistical dimensions and medical indicator data of at least two medical business behaviors.

[0122] Divide multiple existing medical indicator data according to statistical dimensions to obtain statistical dimensions corresponding to each medical indicator Divide multiple existing medical indicator data according to medical business behaviors to obtain medical business behaviors corresponding to each medical indicator.

[0123] S403: Construct a preset statistical dimension logic table according to information of at least two statistical dimensions.

[0124] S404: Construct preset business fact detail tables of at least two medical business behaviors respectively according to the medical indicator data of at least two medical business behaviors.

[0125] In summary, in this embodiment, multiple existing medical indicator data are obtained; multiple existing medical indicator data are divided into data domains to obtain information of at least two statistical dimensions and medical indicator data of at least two medical business behaviors; a preset statistical dimension logic table is constructed based on the information of at least two statistical dimensions; and at least two preset business fact detail tables of medical business behaviors are respectively constructed based on the medical indicator data of at least two medical business behaviors. Thus, the preset statistical dimension logic table and the preset business fact detail table are accurately obtained.

[0126] Furthermore, in another embodiment of the present application, medical indicators are divided into three categories: atomic indicators, derived indicators, and composite indicators.

[0127] Figure 5 This is a schematic diagram of the atomic indicator configuration provided in the embodiment of this application. Figure 5 As shown, the basic information of atomic indicators includes: name, unit, indicator result data type, indicator identifier, indicator code, and label; related information includes: business domain, business activity, business behavior, data source, measurement method, measurement field, and calculation method; dimensions include: medical subject service type, employee, etc.; interpretation information includes: description and interpretation script.

[0128] Figure 6This is a schematic diagram of the derived indicator configuration provided in the embodiment of this application. Figure 6 As shown in the figure, the configuration of derived indicators includes not only basic information and interpretation scripts, but also logical caliber. Logical caliber includes calculation logic and indicator caliber.

[0129] Figure 7 This is a schematic diagram of the composite indicator configuration provided in the embodiment of this application. Figure 7 As shown, the configuration of the composite indicator includes: basic information, logical caliber, and interpretation information.

[0130] Atomic indicators include: simple aggregation indicators and operation aggregation indicators. Simple aggregation indicators: sum, count, average, maximum, minimum, etc. Operation aggregation indicators: inter-field operations, such as: waiting time for consultation = check-in time - consultation time.

[0131] Derived indicators include: common derived indicators and complex derived indicators. Common derivation: atomic indicators + modifiers. Complex derivation: operations between multiple atomic indicators and multiple derived indicators.

[0132] Composite indicators include: common composite indicators and special composite indicators. Common composite indicators: operations between atomic indicators and derived indicators. Special composite indicators: native SQL.

[0133] The following is a description of the medical indicator data calculation device, electronic device, storage medium, etc. provided in this application for execution. The specific implementation process and technical effects are described above and will not be repeated below.

[0134] Figure 8 Schematic diagram of a medical indicator data calculation device provided in an embodiment of the present application. Figure 8 As shown, the device comprises:

[0135] The acquisition module 801 is used to acquire a medical indicator calculation request, which includes: the name of the target medical indicator and the name of the target medical institution.

[0136] The generation module 802 is used to generate a first query language script of the target medical indicator according to the name of the target medical indicator by using a preset first calculation engine. The first query language script includes: the main calculation logic of the target medical indicator and the name of the target medical institution.

[0137] The parsing module 803 is used to use a preset second computing engine to parse the main computing logic in the first query language script to obtain a second query language script for each query indicator corresponding to the target medical indicator.

[0138] The query module 804 is used to use a preset second computing engine to execute a second query language script, perform a data query operation on the business database of the target medical institution, and obtain data of each query indicator.

[0139] The calculation module 805 is used to use a preset second calculation engine to execute the main calculation logic according to the data of each query indicator to obtain statistical data of the target medical indicator.

[0140] Furthermore, generation module 802 is specifically used to adopt a preset first computing engine to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator; adopt the preset first computing engine to obtain the statistical dimension and main computing logic of the target medical indicator from the indicator definition rule, and generate a first query language script according to the statistical dimension and the main computing logic; adopt the preset second computing engine to execute the main computing logic according to the data and statistical dimension of each query indicator to obtain the statistical data of the target medical indicator under the statistical dimension.

[0141] Furthermore, the generation module 802 is specifically used for the medical indicator calculation request to also include: information on the business application scenario; using a preset first calculation engine to obtain the indicator definition rules of the target medical indicator under the target application scenario based on the name of the target medical indicator and the information on the target application scenario.

[0142] Furthermore, the generation module 802 is specifically used for the medical indicator calculation request to further include: calculation conditions and statistical periods; and to generate a first query language according to the statistical dimension, the main calculation logic, the calculation conditions and the statistical period.

[0143] Furthermore, the generation module 802 is specifically used if the indicator definition rule also includes: auxiliary calculation logic of the target medical indicator; generating a first query language script according to the statistical dimension, the main calculation logic and the auxiliary calculation logic; using a preset second calculation engine, executing the main calculation logic according to the data and statistical dimension of each query indicator, and obtaining statistical data of the target medical indicator under the statistical dimension, including: using a preset second calculation engine, executing the auxiliary calculation logic according to the data of each query indicator, and executing the main calculation logic according to the indicator data and statistical dimension after the auxiliary calculation, to obtain statistical data of the target medical indicator under the statistical dimension.

[0144] Furthermore, the calculation module 805 is also used for the medical indicator calculation request and further includes: result calculation logic, using a preset first calculation engine, executing the result calculation logic according to the statistical data of the target medical indicator to obtain the statistical calculation result of the target medical indicator.

[0145] Furthermore, the acquisition module 801 is also used to configure the rules of the target medical indicators using a visual interface according to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table, so as to obtain the indicator definition rules of the target medical indicators in the target application scenario, wherein the preset summary logic table records information on multiple summary methods, the preset statistical dimension logic table records information on at least two statistical dimensions, and the preset business fact detail table records information on at least two indicators.

[0146] Furthermore, the acquisition module 801 is also used to acquire multiple existing medical indicator data; divide the data domain of the multiple existing medical indicator data to obtain information of at least two statistical dimensions and medical indicator data of at least two medical business behaviors; construct a preset statistical dimension logic table based on the information of at least two statistical dimensions; and construct at least two preset business fact detail tables of medical business behaviors respectively based on the medical indicator data of at least two medical business behaviors.

[0147] Fig. 9 A schematic diagram of an electronic device provided in an embodiment of the present application, which electronic device may be a device with computing and processing functions.

[0148] The electronic device includes: a processor 901 and a storage medium 902. The processor 901 and the storage medium 902 are connected via a bus.

[0149] The storage medium 902 is used to store programs, and the processor 901 calls the programs stored in the storage medium 902 to execute the above method embodiment. The specific implementation method and technical effect are similar and will not be repeated here.

[0150] Optionally, the present invention also provides a storage medium, including a program, which is used to execute the above-mentioned method embodiment when executed by a processor. In the several embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, 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, such as 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 interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0151] 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.

[0152] In addition, each functional unit in each embodiment of the present invention 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. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of hardware plus software functional units.

[0153] The above-mentioned integrated unit implemented in the form of a software functional unit can be stored in a storage medium. The above-mentioned software functional unit is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) or a processor (English: processor) to perform some steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (English: Read-Only Memory, abbreviated: ROM), random access memory (English: Random Access Memory, abbreviated: RAM), disk or optical disk and other media that can store program codes.

Claims

1. A method for calculating medical indicator data, It is characterized in that The method comprises: Obtaining a medical indicator calculation request, wherein the medical indicator calculation request includes: a name of a target medical indicator and a name of a target medical institution; According to the name of the target medical indicator, a preset first calculation engine is used to generate a first query language script for the target medical indicator, wherein the first query language script includes: a main calculation logic of the target medical indicator and the name of the target medical institution; Using a preset second computing engine, the main computing logic in the first query language script is parsed to obtain a second query language script for each query indicator corresponding to the target medical indicator; Using the preset second computing engine, executing the second query language script, performing a data query operation on the business database of the target medical institution, and obtaining data of each query indicator; The preset second computing engine is used to execute the main computing logic according to the data of each query indicator to obtain statistical data of the target medical indicator.

2. The method according to claim 1, It is characterized in that The step of generating a first query language script for the target medical indicator by using a preset first computing engine according to the name of the target medical indicator includes: Using the preset first calculation engine, according to the name of the target medical indicator, obtaining the indicator definition rule of the target medical indicator; Using the preset first computing engine, obtaining the statistical dimension of the target medical indicator and the main computing logic from the indicator definition rule, and generating the first query language script according to the statistical dimension and the main computing logic; The method of using the preset second computing engine to execute the main computing logic according to the data of each query indicator to obtain the statistical data of the target medical indicator includes: The preset second computing engine is used to execute the main computing logic according to the data of each query indicator and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension.

3. The method according to claim 2, It is characterized in that The medical indicator calculation request also includes: information on business application scenarios; The adopting the preset first calculation engine to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator includes: The preset first calculation engine is used to obtain the indicator definition rule of the target medical indicator in the target application scenario according to the name of the target medical indicator and the information of the target application scenario.

4. The method according to claim 2, It is characterized in that The medical index calculation request also includes: calculation conditions and statistical period; The generating the first query language script according to the statistical dimension and the main calculation logic includes: The first query language is generated according to the statistical dimension, the main calculation logic, the calculation condition and the statistical period.

5. The method according to claim 2, It is characterized in that If the indicator definition rule further includes: auxiliary calculation logic of the target medical indicator; The generating the first query language script according to the statistical dimension and the main calculation logic includes: Generate the first query language script according to the statistical dimension, the main calculation logic and the auxiliary calculation logic; The using of the preset second computing engine to execute the main computing logic according to the data of each query indicator and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension includes: The preset second computing engine is used to execute the auxiliary computing logic according to the data of each query indicator, and the main computing logic is executed according to the indicator data after the auxiliary calculation and the statistical dimension to obtain the statistical data of the target medical indicator under the statistical dimension.

6. The method according to claim 1, It is characterized in that The medical indicator calculation request further includes: result calculation logic, and the method further includes: The preset first calculation engine is used to execute the result calculation logic according to the statistical data of the target medical indicator to obtain the statistical calculation result of the target medical indicator.

7. The method according to claim 3, It is characterized in that Before using the preset first calculation engine to obtain the indicator definition rule of the target medical indicator according to the name of the target medical indicator, the method further includes: According to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table, the target medical indicator is configured with rules using a visual interface to obtain the indicator definition rules of the target medical indicator under the target application scenario, wherein the preset summary logic table records information on multiple summary methods, the preset statistical dimension logic table records information on at least two statistical dimensions, and the preset business fact detail table records information on at least two indicators.

8. The method according to claim 7, It is characterized in that Before configuring the target medical indicator according to the preset summary logic table, the preset statistical dimension logic table and the preset business fact detail table using a visual interface to obtain the indicator definition rule of the target medical indicator in the target application scenario, the method further includes: Obtain data on multiple existing medical indicators; Performing data domain division on the plurality of existing medical indicator data to obtain information of the at least two statistical dimensions and medical indicator data of at least two medical business behaviors; Constructing the preset statistical dimension logic table according to the information of the at least two statistical dimensions; According to the medical indicator data of the at least two medical business behaviors, the preset business fact detail tables of the at least two medical business behaviors are respectively constructed.

9. A medical index data calculation device, It is characterized in that The device comprises: An acquisition module, used for acquiring a medical indicator calculation request, wherein the medical indicator calculation request includes: a name of a target medical indicator and a name of a target medical institution; A generating module, configured to generate a first query language script for the target medical indicator according to the name of the target medical indicator by using a preset first computing engine, wherein the first query language script includes: a main computing logic for the target medical indicator and the name of the target medical institution; A parsing module, configured to parse the main computing logic in the first query language script using a preset second computing engine, and obtain a second query language script for each query indicator corresponding to the target medical indicator; A query module, used to use the preset second computing engine to execute the second query language script, perform a data query operation on the business database of the target medical institution, and obtain the data of each query indicator; The calculation module is used to use the preset second calculation engine to execute the main calculation logic according to the data of each query indicator to obtain the statistical data of the target medical indicator.

10. An electronic device, It is characterized in that include: A processor and a storage medium, wherein the processor and the storage medium are connected to each other via a bus communication, the storage medium stores program instructions executable by the processor, and the processor calls the program stored in the storage medium to execute the steps of the medical indicator data calculation method as described in any one of claims 1 to 8.

Images