Medical insurance business index data storage and query method and system
By constructing a data warehouse-based method for storing and querying medical insurance business indicators, the problem of chaotic definitions of medical insurance business indicators was solved, the global uniqueness of indicator codes and the high efficiency of data management were achieved, and efficient data analysis and sharing were supported.
Patent Information
- Application Number
- CN202411093703.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-09
- Publication Date
- 2024-11-22
- Estimated Expiration
- 2044-08-09
AI Technical Summary
The definitions of medical insurance business indicators are inconsistent and vary from city to city, making it difficult to achieve uniformity and uniqueness in indicator definitions. This results in insufficient accuracy of results and inconvenience in classification, retrieval, and management. Traditional data storage methods are also difficult to maintain and expand.
A data warehouse-based method for storing and querying medical insurance business indicators is adopted. By defining indicator categories, modifiers, and attributes, a star schema is constructed, fact tables and dimension tables are established, and an indicator system is generated using association analysis algorithms, thus achieving clear data storage logic and global uniqueness.
It achieves global uniqueness of indicator codes, keeps the number of data tables and the amount of data in a single table within a controllable range, improves data management efficiency and analysis capabilities, supports efficient cross-analysis and data sharing, and lowers the threshold for data use.
Smart Images

Figure CN119003527A_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the field of information storage, and in particular relates to a method and system for storing and querying medical insurance business indicator data. Background Art
[0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art.
[0003] The medical insurance field covers many factors, including system construction at the provincial and municipal levels, differentiated policies, and a wide and complex business scope. The traditional model is based on the definition of coding, naming, and classification. Each party defines various information of indicators according to its own understanding. The definitions are confusing, and it is difficult to fully integrate various businesses. It is impossible to achieve the unification of indicator definitions and calibers in various cities, and it is impossible to ensure the uniqueness of indicator definitions, resulting in unclear indicator definitions, insufficient accuracy of indicator results, and the inability to classify, retrieve, and manage indicators.
[0004] It can be seen that the indicator dimension combinations generated by medical insurance business are diverse, and the combination of different dimensions produces a large number of different indicators. Traditional data storage methods are difficult to maintain and expand. In order to ensure accurate query and viewing of medical insurance business, reasonable modeling methods are used to increase the number of data tables and the amount of data in a single table within a controllable range. Ensuring clear data storage logic becomes a necessary solution, which is also helpful for the maintenance and expansion of medical insurance business data in the later stage, lowering the threshold for data use and providing support for data analysis. Summary of the invention
[0005] In order to solve the above problems, the present invention proposes a medical insurance business indicator data storage and query method and system. The present invention is based on a data warehouse model and, through a defined medical insurance indicator system, performs corresponding modeling and data storage applications, which can increase the number of data tables and the amount of data in a single table within a controllable range, and ensure clear data storage logic.
[0006] According to some embodiments, the present invention adopts the following technical solutions:
[0007] A method for storing and querying medical insurance business indicator data includes the following steps:
[0008] Obtain the definition indicator classification, definition indicator modifiers and definition indicator attributes, and build an indicator model based on the obtained information;
[0009] Based on the dimensional modeling theory, an indicator storage model is constructed using a star model. The indicator storage model is centered on the fact table, and the related dimension tables are directly connected to the fact table.
[0010] Obtain the indicator calculation parameters corresponding to the indicator model, calculate and generate indicator data by matching calculation rules, and update the indicator data into the fact table;
[0011] According to the indicators and the indicator data, the correlation between the indicators is calculated through the association analysis algorithm, the analysis results of the association relationship between the indicators are generated, and the indicator system is formed;
[0012] In response to the medical insurance business information query instruction, data related to the query instruction content and corresponding data in the relevant dimension table are extracted from the fact table according to the indicator model and indicator system.
[0013] As an optional implementation, the definition of indicator classification is to classify the indicators according to the business sector, indicator type, statistical type and evaluation type, specifically including:
[0014] Define the indicator business segment, summarize and summarize the indicators according to the business segments, refer to the relevant business normative documents, divide the business areas into different categories, and determine the business segment to which the indicator belongs by selecting the candidate value of the business segment;
[0015] Define indicator types, which are divided into atomic indicators and composite indicators;
[0016] Define the statistical type of the indicator. According to the statistical type of the indicator, the static indicator and the dynamic indicator are distinguished according to the time range of the indicator detected during statistics.
[0017] Define the evaluation type of the indicator, and divide the indicator into quantitative indicators and qualitative indicators according to the indicator evaluation type.
[0018] As an optional implementation, the definition of indicator modifiers is to abstract the business scenarios of the indicators, describe the business scenarios other than the dimensions, and uniformly encode the indicators. The specific process includes:
[0019] Define the time qualifier of the indicator, which limits the statistics of the indicator to the set time period;
[0020] Define the object word of the indicator, describing the thing or concept to which the indicator belongs;
[0021] Define the characteristic words of the indicator and describe the distinctive features of the indicator;
[0022] Define the indicator's representation words and describe the set of valid values of the indicator;
[0023] The indicator code and indicator name are formed according to the arrangement and combination of the above four types of modifiers, among which the indicator code serves as the unique identifier of the indicator.
[0024] As an optional implementation, the definition of indicator attributes includes defining business attributes, technical attributes, and management attributes of the indicator, and labeling the indicator attributes, specifically including:
[0025] Define the business attribute information of the indicator. The business attribute describes the indicator based on the business logic, including the business connotation of the indicator, the business classification to which it belongs, and the associated business action information;
[0026] Define the technical attribute information of the indicator, and describe the information related to the indicator technology, including the data source, statistical caliber and storage location of the indicator;
[0027] Define the management attribute information of the indicator and describe the information on the implementation management and maintenance of the indicator, including the source business system of the indicator, the department and person responsible for the indicator, and the indicator maintenance unit and maintenance personnel information.
[0028] As an optional implementation method, based on dimensional modeling theory, the process of building an indicator storage model with a star model includes:
[0029] By defining dimension information and attribute specifications of dimension codes, dimension names, and dimension types, common dimension attributes are extracted from business reports and business systems, and dimensions are established based on dimension attributes to construct dimension tables.
[0030] Build fact tables by defining them, combining dimensions, and assembling facts.
[0031] As an optional implementation, the process of constructing a fact table by defining the fact table, combining dimensions, and assembling facts includes:
[0032] Classify business facts, select facts whose business relevance exceeds the set value, include all indicators of the current business category in one fact table as much as possible, and only select facts related to the current business category. Only facts related to the current business should be included in one fact table;
[0033] Select dimensions that can describe business categories and combine them to form the dimensions of the fact table;
[0034] Select all facts related to the business category and whose dimensions are consistent with the dimensions of the created fact table to form a fact table;
[0035] According to the needs of data analysis, the fact table is optimized, and the dimension attributes that are used more frequently than the set value during data analysis are added to the fact table as redundant dimensions to reduce the number of table associations performed during statistical analysis.
[0036] As an optional implementation method, the process of calculating and generating indicator data by matching calculation rules and updating the indicator data into the fact table includes:
[0037] Obtain the indicator data calculation parameters, obtain the indicator data calculation trigger time based on the statistical frequency, execute the indicator data calculation task regularly according to the trigger time, match the calculation rules, and obtain the indicator data calculation time range;
[0038] The indicator data calculation time range is brought into the maintained statistical caliber calculation logic as a parameter, the calculation logic is executed in the data warehouse, the indicator result data is obtained, and the result data is updated to the fact table.
[0039] As an optional implementation method, the correlation between indicators is calculated by an association analysis algorithm to generate the analysis results of the association relationship between the indicators. The process of forming an indicator system includes:
[0040] Set the minimum support threshold, calculate the support of the item set composed of each indicator, and the itemsets with support greater than the minimum support threshold are regarded as frequent item sets;
[0041] Generate association rules based on frequent item sets, calculate confidence, and find association rules with confidence greater than the minimum confidence threshold as strong association rules;
[0042] Analyze the association rule results, calculate frequent item sets and association rules many times, and constantly adjust the thresholds to find the appropriate minimum support threshold and minimum confidence threshold;
[0043] Mining the association relationships corresponding to strong association rules to form an indicator system.
[0044] As an optional implementation, in response to the medical insurance business information query instruction, according to the indicator model and indicator system, extracting data related to the query instruction content from the fact table includes:
[0045] Get the indicator code, query dimension list, condition dimension list and calculation type parameter in the query instruction, determine the indicator for obtaining data according to the indicator code, assemble the query fields of the query SQL according to the query dimension list, assemble the condition fields of the query SQL according to the condition dimension list to query the query range of indicator data, determine the query summary value or detailed value according to the calculation type, whether to perform group aggregation, and finally execute the query to obtain indicator data, providing data support through services.
[0046] As an optional implementation, the following steps are also included:
[0047] The query results are recorded to form data sharing records, and the indicator blood relationship is constructed based on the indicator statistical caliber and data sharing records. Specifically:
[0048] The statistical caliber is segmented according to lexical analysis, and the statistical caliber is converted into an abstract syntax tree that can traverse the hierarchical structure through syntax analysis. The source table and source field of the indicator are obtained to form the upstream dependency relationship of the indicator.
[0049] The correlation between atomic indicators is obtained according to the calculation formula of composite indicators, and the downstream dependency of indicators is established according to the correlation between report forms and indicators and data sharing records. Finally, the complete blood relationship of the indicator is formed based on the upstream and downstream dependency of indicators.
[0050] A medical insurance business indicator data storage and query system, comprising:
[0051] A definition management module is configured to obtain a definition indicator classification, a definition indicator modifier, and a definition indicator attribute, and to construct an indicator model based on the obtained information;
[0052] A modeling storage module is configured to construct an indicator storage model in a star model based on dimensional modeling theory, wherein the indicator storage model is centered on a fact table, and related dimension tables are directly connected to the fact table;
[0053] An indicator data generation module is configured to obtain indicator calculation parameters corresponding to the indicator model, calculate and generate indicator data by matching calculation rules, and update the indicator data into the fact table;
[0054] The indicator application module is configured to calculate the correlation between indicators through an association analysis algorithm based on the indicators and the indicator data, generate the analysis results of the association relationship between the indicators, form an indicator system, and respond to the medical insurance business information query instruction. According to the indicator model and indicator system, the module extracts data related to the query instruction content and the corresponding data in the relevant dimension table from the fact table.
[0055] A computer-readable storage medium is used to store computer instructions, and when the computer instructions are executed by a processor, the steps in the above method are completed.
[0056] An electronic device comprises a memory and a processor, and computer instructions stored in the memory and executed on the processor. When the computer instructions are executed by the processor, the steps in the above method are completed.
[0057] Compared with the prior art, the present invention has the following beneficial effects:
[0058] (1) The present invention can unify the coding format of indicators by introducing indicator modifiers, classifications, and attribute labeling, so that meaningless coding codes can be transformed into readable, orderly, and meaningful information. An indicator can be defined by selecting a corresponding phrase, which reduces the difficulty of customizing names and codes. In addition, through the limitation of modifiers, indicators and their codes maintain global uniqueness in the system. At the same time, the correlation between modifiers and indicator classification and statistical caliber further standardizes information maintenance, solving problems such as unclear indicator definitions, failure to ensure uniqueness, inaccurate results caused by inconsistent calibers, and inconvenient indicator classification retrieval and management.
[0059] (2) The present invention stores indicator data based on a star model structure with clear storage logic, so that the number of data tables and the amount of data in a single table are within a reasonable range, with high maintainability and a lower threshold for data use; through unified management of dimensions, a globally unique dimension is established to ensure dimension consistency. When performing data analysis in the data warehouse, it is convenient to perform cross-analysis and correlation analysis on different business indicator data in different business fields and different business fields in the same business field; the fact table design is strongly associated with the business process, and the single-table business is strongly correlated, highly cohesive, and lowly coupled, thereby improving the efficiency of data warehouse data analysis.
[0060] (3) The present invention is conducive to the management and application of indicators and indicator data. Based on the data lineage established based on statistical caliber, the upstream and downstream of the data can be traced through the information flow to provide support for decision support, data quality repair, impact analysis, etc.; an indicator history record table can also be constructed to achieve the traceability of historical version information when the indicator changes.
[0061] (4) The present invention can discover potential correlations between businesses through the construction of an indicator system, and quickly and effectively support system applications, data visualization, data mining and analysis. Indicator data is shared externally through data query services to improve data utilization and data sharing efficiency, and to ensure data consistency and security; compared with traditional operational databases, data warehouses have higher data capacity and data processing efficiency. Sharing externally through data warehouse data tables can support efficient data analysis, reduce data redundancy and duplication, and improve data management efficiency.
[0062] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0063] The accompanying drawings in the specification, which constitute a part of the present invention, are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.
[0064] Figure 1 is a method flow chart of an embodiment;
[0065] Figure 2 The system structure diagram of an embodiment is shown in FIG. DETAILED DESCRIPTION
[0066] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.
[0067] It should be noted that the following detailed descriptions are all illustrative and intended to provide further explanation of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meanings as those commonly understood by those skilled in the art to which the present invention belongs.
[0068] It should be noted that the terms used herein are only for describing specific embodiments and are not intended to limit exemplary embodiments according to the present invention. As used herein, unless the context clearly indicates otherwise, the singular form is also intended to include the plural form. In addition, it should be understood that when the terms "comprising" and / or "including" are used in this specification, it indicates the presence of features, steps, operations, devices, components and / or combinations thereof.
[0069] In the absence of conflict, the embodiments in this application and the features in the embodiments may be combined with each other.
[0070] Embodiment 1
[0071] A method for storing and querying medical insurance business indicator data, such as Figure 1 As shown, the specific steps are as follows:
[0072] Step 1: Build the indicator model by defining indicator classification, defining indicator modifiers, and defining indicator attributes.
[0073] Step 1 specifically includes:
[0074] Step (1-1): Define the indicator classification, and classify the indicators according to the business sector, indicator type, statistical type, and evaluation type. The specific steps are as follows:
[0075] Step (1-1-1): Define the indicator business segment, summarize and summarize according to each business segment, refer to the relevant business normative documents, divide into different business field classifications, and determine the business segment to which the indicator belongs by selecting the business segment candidate value.
[0076] Step (1-1-2): Define the indicator type. The indicator type is divided into atomic indicators and composite indicators. Atomic indicators cannot be split in the business definition and have clear business meanings. Composite indicators can be split in the business definition and are a set of calculation indicators formed based on atomic indicators through certain operation rules.
[0077] The calculation rules mentioned in this embodiment include year-on-year CPR, month-on-month LPR, sum SUM, difference SUBTRACT, multiplication MULTIPLY, quotient DIVIDE, and combinations of the above rules.
[0078] Step (1-1-3): Define the statistical type of the indicator, and distinguish static indicators from dynamic indicators according to the statistical type of the indicator and the time range of the indicator detected during statistics. The static indicator refers to the time point number, which is a statistical indicator calculated according to a unified caliber within a certain period or a certain range at a time point, and is relatively opposite.
[0079] Dynamic indicators are process numbers, which refer to changes over a period of time. They are usually obtained by tracking or monitoring certain data and are additive. The statistical type of the indicator is determined based on the time range of the indicator statistics and whether it is additive.
[0080] Step (1-1-4): Define the evaluation type of the indicator. According to the indicator evaluation type, the indicator can be divided into quantitative indicators and qualitative indicators.
[0081] The quantitative indicators provided in this embodiment are statistical indicators that are relatively objective and can directly use numerical values or statistical data to describe transactions, and can be quantified or calculated. Qualitative indicators refer to evaluation indicators that cannot be directly quantified but need to be quantified through other means. They are used to evaluate the quality of things. The evaluation type of the indicator is selected based on whether the indicator can be quantified.
[0082] Take the indicator "the cumulative number of patients with hypertension covered by the two-disease policy among outpatient chronic and special diseases who have received benefits across the year" as an example. The business segment of this indicator is medical insurance-resident benefits. This indicator cannot be further divided in the business definition, has a clear business meaning, and the indicator type is an atomic indicator. The number of people who receive benefits is a statistical change over a period of time, which is additive and a dynamic indicator. The number of people is an objective indicator that can be directly described by numerical values and can be calculated. The evaluation type is a quantitative indicator.
[0083] Step (1-2): Define indicator modifiers, abstract the business scenarios of the indicators, describe the business scenarios other than the dimensions, and uniformly encode the indicators. The indicator modifiers include four categories: time qualifiers, object words, characteristic words, and expression words. These four types of modifiers jointly describe the business scenarios of the indicators. The time qualifiers, object words, and expression words of the indicators must exist, and characteristic words can be unspecified for indicators in some business scenarios. The specific steps are as follows:
[0084] Step (1-2-1): Define the time qualifier of the indicator, and limit the statistics of the indicator to a specific time period, such as quasi-real time, daily, monthly, cumulative across years, within the statistical period, and at the end of the statistical period. If the indicator is classified as a static indicator, it can only correspond to the time qualifiers at the beginning and end of the statistical period, and variables such as start time and end time cannot be used when performing caliber maintenance. According to the definition of time qualifiers, only one time qualifier can be defined for an indicator.
[0085] Step (1-2-2): Define the object words of the indicator to describe the things or concepts to which the indicator belongs, such as participating units. An indicator can be described by a combination of multiple object words.
[0086] Step (1-2-3): Define the characteristic words of the indicator to describe the significant and distinguishing characteristics of the indicator, such as insurance participation and payment. An indicator can be described by a combination of multiple characteristic words.
[0087] Step (1-2-4): Define the indicator's expression word, which describes the set of valid values of the indicator, such as quantity and total amount. When the expression word and the characteristic word describe a business indicator together, some duplication will occur. In this case, the part of the characteristic word that is repeated with the expression word can be deleted. For one indicator, only one expression word can be defined.
[0088] In step (1-2-5), the system forms an indicator code and an indicator name according to the arrangement and combination of the above four types of modifiers, wherein the indicator code serves as a unique identifier of the indicator.
[0089] To uniquely identify an indicator, first verify the indicator code and indicator name formed by the combination, and check whether there is an indicator with the same code and name defined in the indicator library. Then check whether there is an identical indicator in the indicator library for the four types of modifiers: time qualifiers, object words, characteristic words, and expression words. If the indicator code, indicator name, and the four types of modifiers are exactly the same, it means that the indicator already exists and cannot be further defined.
[0090] Taking the indicator "Cumulative number of residents covered by the two disease policies and patients with hypertension who use medication for the two diseases in outpatient chronic and special diseases who have enjoyed benefits over the year" as an example, this indicator counts the data from the beginning of the policy to the end of the period, so the time qualifier is "cumulative over the year (as of the end of the statistical period)", and the object words that describe the things or concepts to which the indicator belongs include "residents", "two diseases", "policy", "coverage", "hypertension", "patients", "treatment", and "outpatient chronic and special diseases". The characteristic words that describe the significant and distinctive features of the indicator include "medication" and "enjoying benefits", and the representation word that describes the set of valid values of the indicator is "number of people".
[0091] Step (1-3): Defining the indicator attributes includes defining the business attributes, technical attributes, and management attributes of the indicator, and labeling the indicator attributes.
[0092] Step (1-3-1): Define the business attribute information of the indicator, describe the indicator based on the business logic, including the business connotation of the indicator, the business classification to which it belongs, and the related business action information.
[0093] Step (1-3-2): Define the technical attribute information of the indicator, describe the information related to the indicator technology, including the data source, statistical caliber, storage location and other information of the indicator; the indicator data source describes the access layer data source of the original detailed data required to calculate the indicator data; the statistical caliber describes the calculation logic of the indicator from the access layer to summarize the indicator data, and the statistical caliber rules must match the time qualifier defined in step (1-2-1); the storage location describes the specific fact table and field where the indicator result data is stored in the database.
[0094] Step (1-3-3): Define the management attribute information of the indicator, and describe the information on the implementation management and maintenance of the indicator, including the source business system of the indicator, the department and person responsible for the indicator, the indicator maintenance unit and maintenance personnel information.
[0095] Step (1-4): Establish an indicator version record table to store indicator historical version information and historical indicator dimension relationship information, record indicator historical version information for indicator definition, change, cancellation and other operation processes, and query indicator historical version information at any time to achieve traceability of the entire life cycle of the indicator.
[0096] Step 2: Based on dimensional modeling theory, construct an indicator storage model using a star model, with the fact table as the center and related dimension tables directly connected to the fact table.
[0097] Step (2-1) constructs the dimension table: by defining dimension information and attribute specifications such as dimension code, dimension name, dimension type, etc., extracting common dimension attributes from business reports and business systems, and establishing dimensions based on dimension attributes.
[0098] The dimension types include time dimension, geographic dimension and common dimension. The time dimension includes commonly used dimensions such as year, half year, quarter, month and day to represent time information; the geographic dimension includes dimensions such as province, city and county to represent geographical division information; the common dimension refers to dimensions other than time dimension and geographic dimension.
[0099] The constructing of the dimension table also includes performing dimension uniqueness verification on repeated dimensions or dimension values based on naming, data type, and business meaning.
[0100] Dimension uniqueness check: the dimension code, dimension description, and business meaning of the newly added dimension are accurately and fuzzily matched with the corresponding attribute information of the original dimensions. If there is a dimension with a completely accurate match, the new dimension cannot be created. If there is a dimension with a fuzzy match, an approximate dimension will be prompted, and the manager will decide whether to continue creating it.
[0101] The construction of the dimension table also includes establishing a dimension hierarchy, establishing a hierarchical association relationship for dimension attributes that can be associated in a hierarchical manner or a one-to-many manner in the business, realizing data drilling through the dimension hierarchy, and based on the star model structure, merging the hierarchy of dimension attributes into a single dimension through denormalization, reducing table associations, and improving statistical analysis query performance.
[0102] Step (2-2) Construct the fact table: Construct the fact table by defining the fact table, combining dimensions, and organizing facts.
[0103] Step (2-2-1) defines the fact table, classifies business facts, selects facts with strong business relevance, includes all indicators of the current business category in one fact table as much as possible, and only selects facts related to the current business category. A fact table should only include facts related to the current business.
[0104] Step (2-2-2) Combine dimensions, select dimensions that can describe business categories and combine them to form the dimensions of the fact table. Combined dimensions can accurately define the business meaning of each row and ensure that all facts in the fact table are stored at the same granularity.
[0105] Step (2-2-3) assembles the fact table, selecting all facts related to the business category and whose dimensions are consistent with the dimensions of the created fact table to form the fact table.
[0106] Step (2-2-4) optimizes the fact table according to the needs of data analysis, adds the dimension attributes commonly used in data analysis to the fact table as redundant dimensions, reduces the number of table associations performed during statistical analysis, and improves the query efficiency of the fact table.
[0107] Taking the three indicators "the actual payment amount of individuals in this period after the implementation of unified account management", "the total amount of individual payment base after the implementation of unified account management", and "the total amount of accumulated arrears at the end of the period after the implementation of unified account management" as examples, the business segments to which the above indicators belong are all medical insurance-employee collection and payment, and the defined dimensions are all quarter, city, unit type, and small and micro enterprises. Therefore, the above three indicators should be stored in the same fact table.
[0108] S3: Obtain indicator calculation parameters, calculate and generate indicator data by matching calculation rules, and update the indicator data into the fact table.
[0109] Step (3-1) obtains the indicator data calculation parameters, obtains the indicator data calculation trigger time based on the statistical frequency, executes the indicator data calculation task regularly according to the trigger time, matches the calculation rules, and obtains the indicator data calculation time range.
[0110] The indicator data calculation parameters include: the indicator type defined in the step (1-1-2), the statistical type defined in the step (1-1-3), and the time qualifier defined in the step (1-2-1).
[0111] The specific matching calculation rules include: first determine the statistical type. If it is a static indicator, replace the date dimension parameters in the statistical scope according to the time qualifier of the static indicator, and generate an execution statement. If it is a dynamic indicator, determine the time qualifier of the indicator. If the time qualifier is a cumulative indicator at the end of the period, such as the beginning of the year to the end of the month or the beginning of the year to the end of the quarter, replace the date dimension parameters, query start date, and end date parameters in the statistical scope, and generate an execution statement. If the time qualifier is an indicator within the statistical period, such as the current month or the current year, do not replace the statistical scope parameters, and generate an execution statement.
[0112] Step (3-2) brings the statistical caliber calculation logic maintained in step (1-3-2) into the statistical caliber calculation logic maintained in step (1-3-2) as a parameter based on the indicator data calculation time range, executes the calculation logic in the data warehouse, obtains the indicator result data, and updates the result data to the fact table.
[0113] Take the indicator of large-amount unified payment amount for outpatient chronic and special diseases of employees as an example. The time modifier of this indicator is from the beginning of the year to the end of the quarter. The statistical type is a dynamic indicator. The statistical caliber includes three parameters: dimdate, :startdate and :enddate. The :dimdate parameter represents the current time dimension, and the :startdate and :enddate parameters represent the statistical start time and end time. The above parameter values are obtained according to the indicator data generation time, and the statistical caliber is generated. Based on the data warehouse specification, the statistical caliber is converted into a select query statement supported by the data warehouse, sent to the data warehouse through the data warehouse interface for execution, and the calculation results are obtained, and finally the calculation results are stored in the defined fact table.
[0114] S4: Build an indicator system based on indicators and indicator data, and provide services / applications such as indicator data sharing and indicator lineage.
[0115] The indicator system is constructed by calculating the correlation between indicators through an association analysis algorithm according to the indicator classification, indicator attributes, and dimension types, generating an analysis result of the association relationship between each indicator, and forming an indicator system.
[0116] The specific steps are as follows:
[0117] First, the minimum support threshold is set, and the support of the item set composed of each indicator is calculated. The items with a support greater than the minimum support threshold are regarded as frequent itemsets, as shown in Table 1. Secondly, association rules are generated based on frequent item sets, and the confidence is calculated. The association rules with a confidence greater than the minimum confidence threshold are found as strong association rules, as shown in Table 2. Then, the association rule results are analyzed. After multiple calculations of frequent item sets and association rules, the thresholds are continuously adjusted to find the appropriate minimum support threshold and minimum confidence threshold. The strong association rules finally obtained indicate that there is a strong correlation between the indicators, and an indicator system is formed based on the correlation in the mined rules.
[0118] Table 1
[0119]
[0120] Table 2
[0121]
[0122] The indicator data sharing in this embodiment can be shared externally through two methods: data query service and data warehouse data table.
[0123] Specific:
[0124] Among them, data query service sharing obtains indicator result data according to query indicator code, query dimension list, condition dimension list, and calculation type parameters to provide support for data analysis and BI report generation; determines the indicator to obtain data according to the indicator code, assembles the query field of the query SQL according to the query dimension list, and assembles the condition field of the query SQL according to the condition dimension list to query the query range of indicator data; determines the query summary value or detailed value according to the calculation type, and whether to perform group aggregation, and finally executes the query to obtain indicator data, providing data support through services;
[0125] The data warehouse data tables are shared, and the fact tables in dimensional modeling are synchronized to the data warehouse. By authorizing access rights to the fact tables in the data warehouse, the authorized party can freely query the fact table data corresponding to the applied indicators and organize data query logic as needed for data analysis.
[0126] In some embodiments, indicator blood relations may also be constructed based on indicator statistical caliber and external data sharing records.
[0127] Specifically: First, the statistical caliber is segmented according to lexical analysis, and then the statistical caliber is converted into an abstract syntax tree that can traverse the hierarchical structure through a syntax parser, and then the source table and source field of the indicator are obtained to form the upstream dependency relationship of the indicator. Then, the association relationship of the atomic indicator is obtained according to the composite indicator calculation formula, and the downstream dependency relationship of the indicator is established according to the association relationship between the report form and the indicator and the external sharing record, and finally the complete blood relationship of the indicator is formed based on the upstream and downstream dependency relationship of the indicator.
[0128] Embodiment 2
[0129] A medical insurance business indicator data storage and query system, such as Figure 2 As shown, it includes a definition management module 101, a modeling storage module 102, an indicator data generation module 103 and an indicator application module 104.
[0130] The definition management module 101 is used to construct an indicator model by defining indicator classification, indicator modifiers, and indicator attributes, and specifically includes an indicator classification definition module 1011 , an indicator modifier definition module 1012 , an indicator attribute definition module 1013 , and a life cycle module 1014 .
[0131] An indicator classification module 1011 is defined to classify indicators according to business sectors, indicator types, statistical types, and evaluation types.
[0132] The indicator modifier definition module 1012 is used to abstract the business scenarios of the indicators, describe the business scenarios other than the dimensions, and uniformly encode the indicators.
[0133] The indicator attribute definition module 1013 is used to define the business attributes, technical attributes, and management attributes of the indicator and label the indicator attributes.
[0134] The full life cycle module 1014 is used to establish an indicator version record table, store indicator historical version information and historical indicator dimension relationship information, and realize the tracing of the full life cycle of the indicator.
[0135] The modeling storage module 102 is used to construct an indicator storage model based on the dimensional modeling theory and the star model, with the fact table as the center and the related dimension tables directly connected to the fact table, including a dimension construction module 1021 and a fact table construction module 1022.
[0136] The dimension building module 1021 is used to extract common dimension attributes from business reports and business systems by defining dimension information and attribute specifications such as dimension codes, dimension names, and dimension types, and to establish dimensions based on the dimension attributes.
[0137] The fact table building module 1022 is used to build a fact table by defining the fact table, combining dimensions, and assembling facts.
[0138] The indicator data generation module 103 is used to obtain indicator calculation parameters, calculate indicator data by matching calculation rules, and update the indicator data into the fact table, including a calculation time range module 1031 and an indicator data generation module 1032.
[0139] The calculation time range module 1031 is used to obtain indicator data calculation parameters, obtain indicator data calculation trigger time based on statistical frequency, execute indicator data calculation tasks according to the trigger time, match calculation rules, and obtain indicator data calculation time range.
[0140] Generate indicator data module 1032, which is used to bring the indicator data calculation time range into the statistical caliber calculation logic maintained in the step (1-3-2) as a parameter, execute the calculation logic in the data warehouse, obtain the indicator result data, and update the result data to the fact table.
[0141] The indicator management application module 104 is used to construct an indicator application according to the indicators and indicator data generated by the definition management module, the modeling storage module and the indicator data generation module, and includes an indicator system module 1041, a data sharing module 1042 and a data lineage module 1043.
[0142] The indicator system module 1041 is used to calculate the correlation between indicators through an association analysis algorithm according to the indicator classification, indicator attributes, and dimension type, and generate an analysis result of the association relationship between each indicator.
[0143] The data sharing module 1042 is used to provide external sharing applications, which can be shared externally through two methods: data query service and data warehouse data table.
[0144] The data lineage module 1043 is used to construct indicator lineage relationships based on indicator statistical caliber and external data sharing records.
[0145] Each module is configured to execute the corresponding steps in the first embodiment.
[0146] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0147] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0148] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0149] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0150] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made by those skilled in the art within the spirit and principle of the present invention without creative labor shall be included in the protection scope of the present invention.
Claims
1. A method for storing and querying medical insurance business indicator data, Its characteristics are: The following steps are involved: Obtain the definition indicator classification, definition indicator modifiers and definition indicator attributes, and build an indicator model based on the obtained information; Based on the dimensional modeling theory, an indicator storage model is constructed using a star model. The indicator storage model is centered on the fact table, and the related dimension tables are directly connected to the fact table. Obtain the indicator calculation parameters corresponding to the indicator model, calculate and generate indicator data by matching calculation rules, and update the indicator data into the fact table; According to the indicators and the indicator data, the correlation between the indicators is calculated through the association analysis algorithm, the analysis results of the association relationship between the indicators are generated, and the indicator system is formed; In response to the medical insurance business information query instruction, data related to the query instruction content and corresponding data in the relevant dimension table are extracted from the fact table according to the indicator model and indicator system.
2. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: The definition of indicator classification is to classify indicators according to their business sectors, indicator types, statistical types and evaluation types, including: Define the indicator business segment, summarize and summarize the indicators according to the business segments, refer to the relevant business normative documents, divide the business areas into different categories, and determine the business segment to which the indicator belongs by selecting the candidate values of the business segment; Define indicator types, which are divided into atomic indicators and composite indicators; Define the statistical type of the indicator. According to the statistical type of the indicator, the static indicator and the dynamic indicator are distinguished according to the time range of the indicator detected during statistics. Define the evaluation type of the indicator, and divide the indicator into quantitative indicators and qualitative indicators according to the indicator evaluation type.
3. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: The definition of indicator modifiers is to abstract the business scenarios of the indicators, describe the business scenarios other than the dimensions, and uniformly encode the indicators. The specific process includes: Define the time qualifier of the indicator, which limits the statistics of the indicator to the set time period; Define the object word of the indicator, describing the thing or concept to which the indicator belongs; Define the characteristic words of the indicator and describe the distinctive features of the indicator; Define the indicator's representation words and describe the set of valid values of the indicator; The indicator code and indicator name are formed according to the arrangement and combination of the above four types of modifiers, among which the indicator code serves as the unique identifier of the indicator.
4. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: Defining the indicator attributes includes defining the business attributes, technical attributes, and management attributes of the indicator, and labeling the indicator attributes, specifically including: Define the business attribute information of the indicator. The business attribute describes the indicator based on the business logic, including the business connotation of the indicator, the business classification to which it belongs, and the associated business action information; Define the technical attribute information of the indicator, and describe the information related to the indicator technology, including the data source, statistical caliber and storage location of the indicator; Define the management attribute information of the indicator and describe the information on the implementation management and maintenance of the indicator, including the source business system of the indicator, the department and person responsible for the indicator, and the indicator maintenance unit and maintenance personnel information.
5. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: Based on dimensional modeling theory, the process of building an indicator storage model with a star model includes: By defining dimension information and attribute specifications of dimension codes, dimension names, and dimension types, common dimension attributes are extracted from business reports and business systems, and dimensions are established based on dimension attributes to construct dimension tables. Build fact tables by defining them, combining dimensions, and assembling facts; Or further, the process of building a fact table by defining the fact table, combining dimensions, and assembling facts includes: Classify business facts, select facts whose business relevance exceeds the set value, include all indicators of the current business category in one fact table as much as possible, and only select facts related to the current business category. Only facts related to the current business should be included in one fact table; Select dimensions that can describe business categories and combine them to form the dimensions of the fact table; Select all facts related to the business category and whose dimensions are consistent with the dimensions of the created fact table to form a fact table; Optimize the fact table according to the needs of data analysis, add dimension attributes that are used more frequently than the set value during data analysis to the fact table as redundant dimensions, and reduce the number of table associations performed during statistical analysis.
6. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: The process of matching calculation rules, calculating and generating indicator data, and updating the indicator data into the fact table includes: Obtain the indicator data calculation parameters, obtain the indicator data calculation trigger time based on the statistical frequency, execute the indicator data calculation task regularly according to the trigger time, match the calculation rules, and obtain the indicator data calculation time range; The indicator data calculation time range is brought into the maintained statistical caliber calculation logic as a parameter, the calculation logic is executed in the data warehouse, the indicator result data is obtained, and the result data is updated to the fact table.
7. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: The correlation between indicators is calculated by the association analysis algorithm, and the analysis results of the correlation relationship between each indicator are generated. The process of forming an indicator system includes: Set the minimum support threshold, calculate the support of the item set composed of each indicator, and the itemsets with support greater than the minimum support threshold are regarded as frequent item sets; Generate association rules based on frequent item sets, calculate confidence, and find association rules with confidence greater than the minimum confidence threshold as strong association rules; Analyze the association rule results, calculate frequent item sets and association rules many times, and constantly adjust the thresholds to find the appropriate minimum support threshold and minimum confidence threshold; Mining the association relationships corresponding to strong association rules to form an indicator system.
8. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: In response to the medical insurance business information query instruction, according to the indicator model and indicator system, data related to the query instruction content is extracted from the fact table, including: Get the indicator code, query dimension list, condition dimension list and calculation type parameter in the query instruction, determine the indicator for obtaining data according to the indicator code, assemble the query fields of the query SQL according to the query dimension list, assemble the condition fields of the query SQL according to the condition dimension list to query the query range of indicator data, determine the query summary value or detailed value according to the calculation type, whether to perform group aggregation, and finally execute the query to obtain indicator data, providing data support through services.
9. A method for storing and querying medical insurance business indicator data as claimed in claim 1, Its characteristics are: The following steps are also included: The query results are recorded to form data sharing records, and the indicator blood relationship is constructed based on the indicator statistical caliber and data sharing records. Specifically: The statistical caliber is segmented according to lexical analysis, and the statistical caliber is converted into an abstract syntax tree that can traverse the hierarchical structure through syntax analysis. The source table and source field of the indicator are obtained to form the upstream dependency relationship of the indicator. The correlation between atomic indicators is obtained according to the calculation formula of composite indicators, and the downstream dependency of indicators is established according to the correlation between report forms and indicators and data sharing records. Finally, the complete blood relationship of the indicator is formed based on the upstream and downstream dependency of indicators.
10. A medical insurance business indicator data storage and query system, Its characteristics are: include: A definition management module is configured to obtain a definition indicator classification, a definition indicator modifier, and a definition indicator attribute, and to construct an indicator model based on the obtained information; A modeling storage module is configured to construct an indicator storage model in a star model based on dimensional modeling theory, wherein the indicator storage model is centered on a fact table, and related dimension tables are directly connected to the fact table; An indicator data generation module is configured to obtain indicator calculation parameters corresponding to the indicator model, calculate and generate indicator data by matching calculation rules, and update the indicator data into the fact table; The indicator application module is configured to calculate the correlation between indicators through an association analysis algorithm based on the indicators and the indicator data, generate the analysis results of the association relationship between the indicators, form an indicator system, and respond to the medical insurance business information query instruction. According to the indicator model and indicator system, the module extracts data related to the query instruction content and the corresponding data in the relevant dimension table from the fact table.
Citation Information
Patent Citations
Dimension modeling method, dimensional modeling apparatus, device and storage medium
CN108647339A
Index data automatic calculation method and device fusing dimension model
CN115470195A
Data multi-dimensional analysis method and device for insurance industry
CN117217933A
Data management method and system based on dimension modeling
CN117573646A
Index data management method and system
CN117875547A
Cited By
Method for realizing management and query of same index of multiple fact tables based on index center
CN119201946A
Method for managing and querying same index of multi-fact table based on index center
CN119201946B
Standardized management method and device for enterprise-level index system
CN120029992A
Standardized management method and device for enterprise-level index system
CN120029992B
Multi-dimensional index calculation method based on graph database
CN120744193A
