JP2019168860A - Data analysis device and program - Google Patents

Abstract

To provide a multi-dimensional analysis by collecting information on a plurality of fields in a unitary manner and traversing the plurality of fields from a plurality of conditions.SOLUTION: A data analysis device for analyzing data related to resident health welfare reads a resident basic information table which can specify a resident, a first health welfare table including business information on the health welfare of the resident and a second health welfare table, generates collective management information for associating data associated with one another among the first health welfare table, the second health welfare table and the resident basic information table from data of the resident basic information table, the first health welfare table and the second health welfare table, generates first and second multi-dimensional business tables from data obtained by complementing the data of the first and second health welfare in a time series, and generates a third multi-dimensional business table from data obtained by complementing the data of the resident basic information table in a time series.SELECTED DRAWING: Figure 4

Description

  The present invention relates to a technique for centrally aggregating a wide variety of health and welfare data such as population, medical care, nursing care, and medical examinations held by local governments and insurers and analyzing the data.

  Local governments, wide-area unions, medical insurers, and insurers comprehensively evaluate medical plans, nursing care insurance, and prevention projects for community issues and social problems that are complicated by the aging of residents. Therefore, it is required to implement measures and secure financial resources promptly.

  In addition, the enforcement of the Basic Law for the Promotion of Public-Private Data Utilization will help prefectures and municipalities realize a society that can provide more detailed services to each citizen than ever by promoting smooth data distribution beyond the barriers of data ownership. It is necessary to work on it.

  Against this backdrop, it is required to analyze issues by multi-dimensional factors such as time-series changes and regions and ages, simultaneously and across multiple health and welfare fields.

JP 2016-48553 A JP 2008-276465 A JP 2012-98878 A

  However, local governments handle data such as “resident information”, “medical insurance information”, “care insurance information”, and “medical examination information” because the organization in charge differs depending on the business (or business system). Since the computer system is individually developed and operated, the business is limited to using data individually for each business field.

  In other words, we analyze the public services that individuals use continuously according to aging and illness, such as population, medical examination, medical care, nursing care, etc. for each individual field by the person in charge or outsourcing. The problem is that we cannot find a group that has a high interest in administrative policy across the board.

  Specifically, it is a problem that multi-dimensional analysis that can specify a group by specifying complex conditions on the regional axis and time axis such as elementary school districts and self-governing districts as well as business axes across the health and welfare fields is an issue. ing.

  For example, we analyzed the time axis in the same field such as “How did the 80-year-old group with the level of care required 3 in 2015 have the level of care required in 2013?” “What was the result of the 2005 medical checkup for those who were?” And analyzes such as “What is the current medical expenses for people in the autonomous district in 2013?” Detailed regional analysis has not been realized at present.

  In Patent Document 1, although medical data and medical examination data in a group of medical examinees can be analyzed at a specific medical institution, cross-sectional analysis in the care field and regional analysis such as elementary school districts and autonomous districts cannot be performed.

  In Patent Document 2, it is possible to collect information on medical insurance and care insurance system information of different insurers. For example, analysis of a time axis in which no data exists without using medical insurance or care insurance has no data. An analysis focusing on the time axis is not possible.

  In Patent Document 3, it becomes possible to analyze the medical insurance and medical examination data of the insurance subscriber, but it is not possible to analyze the interaction with the extended care insurance data and the future estimation information.

  Therefore, the present invention consolidates information in a plurality of fields such as resident information, medical insurance information, care insurance information, and medical examination information from a plurality of conditions such as time series, resident attributes, and regional attributes. The purpose is to easily realize multidimensional analysis across multiple fields.

  The present invention relates to a data analysis apparatus that includes a processor and a memory and analyzes data relating to residents 'health and welfare, wherein the processor relates to a residents basic information table that can identify the residents and to the residents' health and welfare. A first health and welfare table including business information and a second health and welfare table including business information relating to the health and welfare of the inhabitants are read, and the processor includes the basic resident information table, the first health and welfare table, and The processor generates group management information for associating data related to each other between the first health and welfare table, the second health and welfare table, and the basic resident information table from the data of the second health and welfare table. The first multi-dimensional business table is generated from the data supplemented in time series for the data of the first health and welfare table. The processor generates a second multidimensional business table from the data supplemented in time series for the data in the second health and welfare table, and the processor in time series for the data in the basic resident information table. A third multidimensional business table is generated from the complemented data.

  Therefore, the present invention can analyze multidimensional data under desired conditions across a plurality of fields such as resident information, medical insurance information, care insurance information, and medical examination information. For example, it becomes possible to grasp trends and breakdowns of medical expenses, nursing care expenses, the number of patients, and the number of various service users by various attributes of residents such as for each region and each year. As a result, it is possible to grasp the excess or deficiency of resources such as medical facilities, nursing care facilities, and professionals that can be used by the target residents, and to prevent preventable diseases. Make business decisions and budget allocation without waste. As a result, it is possible to suppress an increase in medical expenses and nursing care costs and to maintain and improve the health of residents.

It is a block diagram which shows the Example of this invention and shows an example of an analysis system. It is a figure which shows the Example of this invention and shows an example of the procedure of the preparation process of a multidimensional work table. It is a figure which shows the Example of this invention and shows an example of a multidimensional population table. It is a figure which shows the Example of this invention and shows an example of a multidimensional medical examination table. It is a figure which shows the Example of this invention and shows an example of a multidimensional care table. It is a figure which shows the Example of this invention and shows an example of a multidimensional medical table. It is a figure which shows the Example of this invention and shows a detailed example of a multidimensional population table. It is a figure which shows the Example of this invention and shows a detailed example of a multidimensional medical examination table. It is a figure which shows the Example of this invention and shows a detailed example of a multidimensional care table. It is a figure which shows the Example of this invention and shows a detailed example of a multidimensional medical table. It is a figure which shows the Example of this invention and shows a detailed example of a group management part. It is a figure which shows the Example of this invention and shows the relationship between a group management part and each multidimensional work table. It is a flowchart which shows the Example of this invention and shows an example of an analysis process. It is a figure which shows the Example of this invention and shows an example of a cross-business analysis screen. It is a flowchart which shows the Example of this invention and shows an example of a recursive analysis process. It is a figure which shows the Example of this invention and shows an example of a recursive analysis process screen. It is a figure which shows the Example of this invention and shows an example of an analysis menu. It is a flowchart which shows the Example of this invention and shows an example of map analysis processing. It is a figure which shows the Example of this invention and shows an example of the map analysis screen which displays the result of a map analysis process. It is a flowchart which shows the Example of this invention and shows an example of the comparative analysis process of a group. It is a figure which shows the Example of this invention and shows an example of the screen which displays the result of a group comparative analysis process.

<Analysis system configuration>
Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings.

  In this example, the data collected from pre-collected local government data can be supplemented with missing tooth data (data lacking information), or by creating data that unifies place names by name identification, etc. An example of an analysis system that creates an analysis database to be solved and displays an analysis screen according to an operation from a user terminal will be described.

  FIG. 1 is a block diagram showing an example of the configuration of the analysis system of this embodiment.

  The analysis system of this embodiment includes a data analysis apparatus 101 and an analysis screen display terminal 130 connected to the database 120 via the communication network 50. The data analysis apparatus 101 includes an input unit 102, an output unit 103, a calculation device 104, a memory 105, and a storage medium 106.

  The input unit 102 is a human interface such as a mouse or a keyboard. The output unit 103 is a display or printer that displays the setting status of the data analysis apparatus 101. The storage medium 106 is a storage device that stores various programs for realizing data analysis processing by the data analysis device 101, execution results of the data analysis processing, and the like. ).

  In the memory 105, a program stored in the storage medium 106 is expanded. The arithmetic device 104 is an arithmetic device that executes a program loaded in the memory 105, and is, for example, a CPU, a GPU, or the like. The processing device 104 executes the processing and calculation described below.

  The analysis system of this embodiment is a computer system configured on a single computer or on a plurality of computers configured logically or physically, and is executed in separate threads on the same computer. Alternatively, it may be executed on a virtual machine constructed on a plurality of physical computer resources.

  A program executed by the arithmetic device 104 is provided to each server via a removable medium (CD-ROM, flash memory, etc.) or a network, and is stored in a nonvolatile storage device that is a non-temporary storage medium. For this reason, the computer system may include an interface for reading removable media.

  In the data analysis apparatus 101, a multidimensional population table creation program 202, a multidimensional medical examination table creation program 203, and a multidimensional medical table creation program 204 included in the multidimensional business table creation program 201 stored in the storage medium 106. And the multidimensional care table creation program 205 is made to function in cooperation.

  The multidimensional business table output program 206 receives operation information such as analysis conditions from the analysis screen display terminal 130 via the communication network 50, and numerical information on the health and welfare field of the analysis target group in the multidimensional business table storage unit 302. And information necessary for generating the analysis screen is output to the analysis screen display terminal 130.

  The arithmetic unit 104 operates as a functional unit that provides a predetermined function by performing processing according to a program of each functional unit. For example, the arithmetic unit 104 functions as a multidimensional business table creation unit by performing processing according to a multidimensional business table creation program.

  The same applies to other programs. Furthermore, the arithmetic unit 104 also operates as a function unit that provides the functions of a plurality of processes executed by each program. A computer and a computer system are an apparatus and a system including these functional units.

  The database 120 includes a multidimensional business table storage unit 302 that stores a plurality of multidimensional business tables, a group storage unit 303 that stores a group management unit 31, and related information that stores conversion information such as map information and character codes. Storage unit 304.

  The multidimensional work table storage unit 302 includes, for example, a multidimensional population table 27, a multidimensional medical examination table 28, a multidimensional care table 29, and a multidimensional medical table 30.

  The analysis screen display terminal 130 is the same as the data analysis device 101, and is a computer including an input unit, an output unit, a calculation device, and a memory (not shown).

<Create multi-dimensional business table>
FIG. 2A is a diagram for explaining a procedure for creating a multidimensional business table for each business system to be imported into the data analysis apparatus 101 by the multidimensional business table creation program 201. Creation (update) of the multidimensional business table is executed when a manager of the data analysis apparatus 101 performs a predetermined operation on the input unit 102.

  In step 21, the multidimensional business table creation program 201 reads health and welfare field data from an external computer or medium and stores it in the storage medium 106. The multi-dimensional business table creation program 201 includes a basic resident information table 11 that includes information such as the address of each resident and the reason for change such as age and transfer, and a medical insurance table that similarly includes medical and dental dispensing receipts and medical insured information. 12. Further, predetermined health care and welfare such as a nursing care insurance table 13 such as a nursing care receipt, nursing care insured person information and authorization information, a health examination and health guidance table 14 such as a health examination result, a medical institution table 15 and a nursing care establishment table 16 Information on the business system in the field is read and stored in the storage medium 106.

  The multi-dimensional business table creation program 201 includes information such as school districts for each region, medical institution tables 15 including the names, locations, and service types of medical institutions and nursing care establishments, nursing care establishment tables 16, and the like. Related information, map information related to the area, and the like are stored in the storage medium 106, and when the character codes are different between business systems, the format is unified by predetermined conversion software and stored in the related information storage unit 304.

  In step 22, the multidimensional business table creation program 201 uses key information (personal unique keys) that can uniquely identify each resident, such as a personal number, in ascending order for each business system table stored in the storage medium 106. By sorting in descending order, collective axis information (collective axis 421) is generated. Thereby, the group management part 31 is produced | generated and it becomes possible to cooperate and process the information regarding the same person within a business system and between business systems.

  In step 23, the multidimensional business table creation program 201 uses the unified district code such as the corresponding nominal town name, school district and autonomous district for the address information included in each business system table stored in the storage medium 106. Latitude / longitude information is added, and regional axis data is generated that unifies addresses uniquely in all business system tables.

  For example, even though “1-2-2-3” is registered in the basic resident information table 11, it is registered as “1-2-3” or “1 no 2 3” in the medical insurance table 12. By solving this problem for the conventional problem that address data fluctuates between business systems, it is possible to perform an appropriate tabulation process for the region.

  In step 24, the multi-dimensional work table creation program 201 can collect work data for each inhabitant that occurs irregularly from past to future at any point in time for each work system table stored in the storage medium 106. Therefore, the time axis data of each resident is generated at least monthly.

  For example, residents who have medical insurance qualifications such as the National Health Insurance as of a certain date are eligible for specific medical examinations in the age group defined by law. In order for insurers to consider effective health measures, it is desirable to grasp the health checkup rate based on the residential area and status of the checkup at the time of the checkup month. However, in the system provided by Japan and the conventional private system, It has not been realized. This process solves such a problem by causing each job to hold time axis data.

  In the present embodiment, an example is shown in which time axis data is generated or supplemented in a monthly cycle, but the present invention is not limited to this, and a cycle such as weekly or quarterly may be used.

  In step 25, the multi-dimensional business table creation program 201 executes a period before and after the occurrence of business data that occurs irregularly for each resident for each business system table stored in the storage medium 106, or a future that is later than the time of capture. In order to achieve appropriate tabulation for the period, supplementary processing of missing tooth business data is performed, and business axis data that can be tabulated is generated.

  First, the multidimensional business table creation program 201 first collects the number of populations and the number of insured persons at a predetermined point in time for business information linked to the time axis from the past to the present. , By searching for the reasons for the change in the basic resident information for each individual, business data for the period before and after the occurrence of the change data is newly generated in time series according to the reason to supplement the business data.

  Similarly, the multidimensional business table creation program 201 searches the medical insurance table 12 and the long-term care insurance table 13 for insurance qualification merits and demerits, and obtains business data for a period before and after the occurrence of meritorious data according to the reason. Complement business data by creating a new series.

  The multidimensional business table creation program 201 uses business data supplemented in time series as business axis data. The business axis data is generated for each business data item in each table. For example, business axis data is generated for each data item (field) of the medical examination work information 414 and the care work information 416.

  Next, the multidimensional business table creation program 201 performs predetermined estimation processing such as machine learning and statistical processing on the stored business data in business information linked to a future time axis from the date of occurrence of stored data. In this way, business data in the future period is newly created to supplement the business axis data.

  For example, the multidimensional business table creation program 201 uses the information of the individual medical checkup and the health guidance table 14 and the medical insurance table 12 to check whether or not a medical institution related to diabetes in 2015 based on medical receipt information (0 An estimation model can be constructed with BMI (Body Mass Index) in 2014 based on medical checkup information and fasting blood glucose (taking a continuous value) as explanatory variables. .

In this way, the multidimensional business table creation program 201 builds an estimation model in which different information at the time of data acquisition is set as an explanatory variable and an objective variable, so that the BMI, fasting blood glucose, inquiry answer value, etc. information by entering the y _n, the subsequent years diabetes probability of visits to the medical institution it is possible to calculate by integration of the correlation coefficient a _nm of the future of the business-axis data of the medical residents every Data on the number of patients visited during the period can be supplemented.

Next-year hypertension visit probability = a ₁₁ × y ₁ + a ₁₂ × y ₂ + a ₁₃ × y ₃
Next-year hypertension visit probability = a ₂₁ × y ₁ + a ₂₂ × y ₂ + a ₂₃ × y ₃

Furthermore, the multidimensional business table creation program 201 aggregates the average medical cost b _n for each disease and the correction coefficient b _nm for each year, taking into account the attributes such as the age of the inhabitants for each disease and the consultation period, from the medical insurance table 12. Thus, the expected value of the annual medical expenses from the following fiscal year is generated as described below by integrating with the individual medical institution probability obtained as described above, and the medical expenses data for the future period can be supplemented.

Expected value of medical expenses for the next year (hypertension) = b ₁ x (a ₁₁ x y ₁ + a ₁₂ x y ₂ + a ₁₃ x y ₃ ...)
Expected medical expenses for the next year (hypertension) = (b ₂ x b ₁₁ ) x (a ₁₁ x y ₁ + a ₁₂ x y ₂ + a ₁₃ x y ₃ ...)

  Step 26 includes a multidimensional population table 27, a multidimensional medical examination table 28, a multidimensional medical table 30, and a multidimensional care table 29, which are generated by the multidimensional business table creation program 201 up to step 25. It is stored in the dimension work table storage unit 302.

  By the above processing, a multidimensional table is generated for each business system as shown in FIGS. 2B to 2E. FIG. 2B is a diagram illustrating an example of the multidimensional population table 27 generated based on the resident basic information table 11.

  In the multi-dimensional population table 27, for example, a population group axis 271 is generated by assigning, for example, a personal number of a resident as group axis data. As the time axis data, monthly data is generated or supplemented to generate a time axis 272. Further, the age axis 273 is generated by assigning the ages of the residents as the business axis data. The business axis data is not limited to the age axis 273, and can be appropriately generated from the population business information described later. Although illustration is omitted, regional axis data is also generated based on the address of the residents.

  In the example of FIG. 2B, the time axis 272 is set on the X axis, the group axis data (population group axis 271) is set on the Y axis, and the business axis data (age axis 273) is set on the Z axis. Show. The same applies to other multidimensional tables.

  FIG. 2C is a diagram illustrating an example of a multidimensional medical examination table 28 generated based on the medical examination and health guidance table 14.

  In the multidimensional medical examination table 28, for example, a personal number of residents is assigned as group axis data, and a medical examination group axis 281 is generated. As the time axis data, the time axis 282 is generated by generating or supplementing the data with the year and month when the medical examination is received. Further, the BMI at the time of the medical examination is assigned as the business axis data, and the BMI division axis 283 is generated.

  FIG. 2D is a diagram illustrating an example of the multidimensional care table 29 generated based on the care insurance table 13. In the multi-dimensional care table 29, for example, a personal group number of residents is assigned as group axis data, and a care group axis 291 is generated. As the time axis data, the time axis 292 is generated by generating or supplementing the data with the year and month when the care insurance service was received. In addition, care cost axis 293 is generated by assigning a cost for care as business axis data.

  FIG. 2E is a diagram illustrating an example of the multidimensional medical table 30 generated based on the medical insurance table 12. In the multi-dimensional medical table 30, for example, a personal group number of residents is assigned as group axis data, and a medical group axis 311 is generated. As the time axis data, the time axis 312 is generated by generating or supplementing the data with the year and month when the medical insurance service such as medical care is received. In addition, a medical expense axis 313 is generated by assigning expenses at the time of medical treatment as the business axis data.

  2A to 2E show an example in which the multidimensional population table 27, the multidimensional medical examination table 28, the multidimensional care table 29, and the multidimensional medical table 30 are configured in three dimensions. It is not limited.

  Each multi-dimensional business table may have, for example, a four-dimensional structure of a group axis, a regional axis, a time axis, and a business axis.

<Multidimensional business table storage unit>
FIG. 3A is a diagram showing details of the multidimensional population table 27 created by the multidimensional business table creation program 201.

  The multidimensional population table 27 includes key information 411 for specifying a group (column or axis) to be analyzed in cooperation with the attributes of other multidimensional business tables, and business information generated by the business system regarding the population. And population work information 412 to be stored.

  The key information 411 includes an individual unique key 2711 for storing an identifier for uniquely identifying an individual, and period information 2712 for storing a year and month for designating an analysis target period.

  The population work information 412 stores work information such as personal information 2713 such as gender and age that should be used as an analysis axis of population dynamics, regional information 2714 such as residence, and demographic information 2715 such as birth, death and transfer. Is done.

  FIG. 3B is a diagram showing details of the multidimensional medical examination table 28 stored in the multidimensional work table storage unit 302 in step 25.

  The multidimensional medical examination table 28 includes key information 413 for specifying a group (column or axis) to be analyzed in cooperation with the attributes of other multidimensional business tables, and business information generated by a medical business system. Medical checkup work information 414 for storing.

  The key information 413 includes an individual unique key 2811 for storing an identifier for uniquely identifying an individual, and period information 2812 for storing a year and month for making it possible to specify an analysis target period.

  The medical examination work information 414 includes personal information 2813 such as sex, age, etc., regional information 2814 such as residence, etc., basic medical examination information as a test result, which should be used as an analysis axis for the medical examination subject's medical examination status and results of the medical examination. Business information such as 2815, inquiry information 2816, examination information 2817, determination result information 2818, and health guidance information 2819 is stored.

  FIG. 3C illustrates the multidimensional care table 29 stored in the multidimensional work table storage unit 302 in step 25.

  The multidimensional care table 29 includes key information 415 for designating a group (column or axis) to be analyzed in cooperation with attributes of other multidimensional work tables, and work information generated by the work system related to care. Care service information 416 to be stored.

  The key information 415 includes an individual unique key 2911 for storing an identifier for uniquely identifying an individual, a nursing care service specific number 2912 for storing an identifier of a care insured person, and a year and month for making it possible to specify an analysis target period ( Period information 2913 for storing (care use).

  The care service information 416 includes personal information 2914 such as gender and age that should be used as an analysis axis in the long-term care insurance, regional information 2915 such as a place of residence, long-term care qualification information 2916 such as long-term care certification results, and long-term care insurance data included in the long-term care receipt data. The business information of the nursing care reception information 2917 for storing benefit costs and the like and the nursing care establishment information 2917 for storing the establishment number of the provider of the used nursing care service and the location thereof are stored.

  FIG. 3D illustrates the multidimensional medical table 30 stored in the multidimensional business table storage unit 302 in step 25.

  The multidimensional medical table 30 includes key information 417 for specifying a group (column or axis) to be analyzed in cooperation with attributes of other multidimensional business tables, and business information generated by a business system related to medical insurance. And medical service information 418 for storing.

  The key information 417 includes an individual unique key 3011 for storing an identifier for uniquely identifying an individual, a medical service unique number 3012 for storing a medical insurance identifier, a medical insurance type 3013 for storing a medical insurance type, and an analysis. It includes period information 3014 for storing the year and month (medical consultation date) for making it possible to specify the target period.

  The medical service information 418 stores personal information 3015 such as gender and age that should be used as an analysis axis in medical insurance, regional information 3016 such as a residence, medical receipt information 3017 that stores medical insurance benefit costs included in medical receipt data, and the like. And business information such as medical institution information 3013 for storing the medical institution number and the location of the medical institution are stored.

  In this embodiment, an example is shown in which the multidimensional work table includes four tables: a multidimensional population table 27, a multidimensional medical examination table 28, a multidimensional care table 29, and a multidimensional medical table 30. The data table of another business system can be further added.

<Group memory unit>
FIG. 3E is a diagram illustrating an example of the group management unit 31 stored in the group storage unit 303 of the database 120. The group management unit 31 is, for example, a table generated in step 22 in FIG. 2A.

  The group management unit 31 includes a group axis 421 that correlates individual data among multi-dimensional business tables generated from data of a plurality of business systems, an analysis target 422 that manages a target currently being analyzed, a comparison target, A comparison group 423 that holds information on a group (group or data group) to be included.

  The collective axis 421 associates the data of each resident corresponding to the search condition with respect to each of the multidimensional business tables processed in step 25.

  The collective axis 421 shown in the figure includes an individual unique key (population) 3111 obtained by adding “P” to the value of the individual unique key 2711 of the multidimensional population table 27 and the value of the individual unique key 2911 of the multidimensional care table 29 “N”. ”Plus a personal unique key (care) 3112, a personal unique key (medical) 3113 obtained by adding“ M ”to the value of the personal unique key 3011 of the multidimensional medical table 30, and a personal unique key of the multidimensional medical examination table 28. An individual unique key (medical checkup) 3114 obtained by adding “C” to the value of the key 2811 is included.

  The multidimensional business table creation program 201 uses, for example, the personal unique keys 2811, 2911, and 3001 of the person that matches the personal unique key 2711 of the multidimensional population table 27 from the personal information such as name, address, gender, and age, etc. Extracted from the examination table 28, the multidimensional care table 29, and the multidimensional medical table 30, respectively, and stored in one entry of the group management unit 31.

  As a result, the four multidimensional business tables (multidimensional population table 27, multidimensional medical examination table 28, multidimensional care table 29, multidimensional medical table 30) specify any one individual unique key, Analysis can be performed by linking the business axis data of the population business information 412, the medical examination business information 414, the care business information 416, and the medical business information 418.

  3E shows the group axis 421 shown in FIG. 2E, the population group axis 271 shown in FIG. 2B, the medical examination group axis 281 shown in FIG. 2C, the care group axis 291 shown in FIG. 2D, and FIG. An example in which the medical group axis 311 is linked is shown. The population group axis 271 is composed of individual unique keys 2711 of the multidimensional population table 27. The medical examination group axis 281 is configured by an individual unique key 2811 of the multidimensional medical examination table 28. The care group axis 291 is composed of individual unique keys 2911 of the multidimensional care table 29. The medical group axis 311 is configured by the individual unique key 3011 of the multidimensional medical table 30.

  The analysis target 422 for managing the target currently being analyzed includes a population flag 3115 and a target flag 3116. The population flag 3115 is set to “1” in an entry belonging to the population of data extracted by a search or a filter. In the target flag 3116, “1” is set in an entry that is an analysis target in a population or the like.

  The comparison group 423 is an example in which “1” is set in an entry that matches a predetermined condition to be compared, and three comparison groups of the group A 3117 to the group C 3119 are included. For example, in the group A 3117, “1” is set in the entry that matches the narrowing-down condition A for the population with the population flag 3115 = “1”. Here, the target flag 3116 = “1” is set for the result of narrowing down under the condition A, and after the result is confirmed by the analyst, “1” is moved to the group A 3117 and the next narrowing down condition B or Condition C can be executed.

  By using the group A 3117 to the group C 3119, it is possible to return to the population while holding the results of the filtering conditions A to C when the filtering is repeatedly performed.

<Multidimensional business table output program>
The multidimensional business table output program 206 receives analysis conditions such as time axis and business axis information from the analysis screen display terminal 130, and extracts a corresponding data group from the multidimensional business table.

  Further, the multidimensional business table output program 206 receives the collective axis information from the analysis screen display terminal 130, narrows down the group of each multidimensional business table with the collective axis information, and outputs the narrowed result to the analysis screen display terminal 130. .

  FIG. 4 is a diagram illustrating the relationship between the group management unit 31 and each multidimensional work table. The multi-dimensional business table includes a multi-dimensional population table 27, a multi-dimensional care table 29, a multi-dimensional medical table 30, and a multi-dimensional medical examination table 28, an aggregate of four data (multi-dimensional business table), and group management. The unit 31 is configured.

  When data analysis in other fields is added, a multidimensional business table is added, a column is added to the collective axis 421 of the collective management unit 31, and analysis is performed after the multidimensional business tables are linked. .

  Each multi-dimensional work table holds a group axis (population group axis 271, medical examination group axis 281, care group axis 291, medical group axis 311) and a time axis (272, 282, 292, 302) for identifying individuals. The business axis (273, 283, 293, 303) according to the field of each multi-dimensional business table is held (for example, a nursing cost axis for a multi-dimensional nursing table).

  As described above, the group management unit 31 links the group axes of each multidimensional task table by the group axis 421 and links the task information of each multidimensional task table. The group management unit 31 links the groups that are simultaneously analyzed in each multidimensional task table based on the correspondence of the group axis. For example, an ID that identifies an individual in each multidimensional task table When the same value is shared for (personal unique key), it is possible to have a minimum configuration that only holds the ID to be analyzed, as indicated by reference numeral 411 in the figure.

  In the analysis of each multi-dimensional work table, the group (data group) identified by the population flag 3115 is set as the population. The group to be analyzed can be narrowed down by a predetermined axis of each multidimensional work table.

  In the example of FIG. 4, the data of the group 454 narrowed down by the time axis 272 of the multidimensional population table and the business axis (age axis 273) is the analysis target. The group 454 corresponds to the individual of the population group axis 271 (individual unique key 2711) = P01 and P02 in the multidimensional population table 27.

  A user (analyst) of the analysis screen display terminal 130 using the analysis system holds the group 454 in the target flag 3116 of the group management unit 31 and specifies analysis target data in another multidimensional work table.

  The analysis target data specified by the group management unit 31 is narrowed down on the condition of the group axis in each multidimensional work table. That is, the population group axes 271 = P01 and P02 of the multidimensional population table 27 correspond to the care group axes 291 = N01 and N02 of the multidimensional care table 29, and the medical examination group axis 281 = C01 in the multidimensional medical examination table 28. , C02, and in the multidimensional medical table 30, the medical group axis 311 = M01, M02.

  The analyst of the analysis screen display terminal 130 can perform analysis by extracting a desired column value from business information of another multidimensional business table for individuals corresponding to the population group axis 271 = P01, P02.

  With the configuration in which the group management unit 31 and the group axis of each multidimensional task table are linked as described above, the same group can be simultaneously analyzed in a multidimensional manner using a plurality of multidimensional task tables.

  Further, in the analysis, it is possible to reset the analysis target data extracted under a predetermined condition as a population. This is realized by moving the target flag 3116 of the group management unit to the population flag 3115. Thereby, the target data narrowed down by the predetermined condition A can be used as a population, and can be analyzed recursively under a predetermined condition that does not depend on the condition A. Further, as described above, it is possible to set analysis target data extracted under predetermined analysis conditions as a comparison group.

  FIG. 5 is a flowchart showing an example of analysis processing performed by the multidimensional business table output program 206. This process is started based on a command from an analyst of the analysis screen display terminal 130, for example.

  In step 501, the analyst who performs the analysis uses the analysis screen display terminal 130 to analyze the business variable (analysis value) to be analyzed, the condition (condition axis) of the analysis target data, and the axis (expression axis) describing the analysis result. Set. When performing group comparison analysis, a group (data group) stored as a previous analysis result is selected as a comparison target.

  The analysis value indicates the value of the work information in the multidimensional work table, for example, the value of the population work information 412 in the multidimensional population table 27. The condition axis indicates the condition of data (such as residents) selected on the group axis 421 of the group management unit 31. The expression axis can specify the form (graph, map, or table) displayed on the output unit of the analysis screen display terminal 130.

  The data analysis apparatus 101 receives the analysis value, the condition axis, and the expression axis received from the analysis screen display terminal 130 as analysis conditions.

  In step 502, the multidimensional business table output program 206 identifies a set of individual unique keys (group axis) that matches the received analysis conditions.

  In step 503, the multidimensional business table output program 206 crosses each multidimensional business table from the collective axis 421 of the collective management unit 31 on the basis of the collective axis specified in step 502, and each multidimensional business table. Specify the collective axis with. Note that the multidimensional business table output program 206 may specify the collective axes across the multidimensional business table by the collective management unit 31 using the prestored collective axes.

  In step 504, the multidimensional business table output program 206 determines the business information axis (business axis) to which the analysis value set in step 501 belongs from each group axis crossing each multidimensional business table specified in step 503. Data).

  In step 505, the multi-dimensional work table output program 206 acquires the analysis value set in step 501 from the corresponding work information for the work information specified in step 504, and collects and statistical values as necessary. calculate.

  When calculating the statistical value, if the analysis value of the population is necessary, the analysis value for the population specified by the group management unit 31 is also calculated, and the aggregation and the statistical value are calculated as necessary.

  In step 506, the multidimensional business table output program 206 generates screen information such as graphs, maps, and tables according to the expression axis specified in step 501 based on the information acquired and calculated in step 505.

  In step 507, if the group to be compared is specified in step 501 above, the multidimensional business table output program 206 repeats the processing from step 503 to step 506 for the group to be compared.

  In step 508, the multidimensional work table output program 206 outputs the generated screen information to the analysis screen display terminal 130 when the analysis of all groups is completed.

  In step 509, when the multidimensional business table output program 206 changes the analysis conditions while maintaining the analysis target population and the comparison target group, the process returns to step 501 and performs the above processing. On the other hand, when the analyzed group axis is stored as a population or a group to be compared, the process proceeds to step 510.

  In step 510, the multidimensional task table output program 206 stores the group axis of the analysis result in the memory 105 or the like as a population or a group to be compared.

  Through the above processing, the multidimensional business table output program 206 can analyze business information (business axis data) by cross-linking a plurality of multidimensional business tables via the collective axis 421. As a result, information on multiple fields such as resident information, medical insurance information, long-term care insurance information, and medical examination information is centrally aggregated, and multiple items can be selected from combinations of multiple conditions such as time series, resident attributes, and regional attributes. Multidimensional analysis can be realized easily and quickly across the fields.

<Cross-business analysis screen>
FIG. 6 is a diagram illustrating an example of a cross-business analysis screen 90 that displays an analysis result crossing a multidimensional business table in the health and welfare field.

  An example in which the multidimensional business table output program 206 analyzes the information of the multidimensional business table stored in the multidimensional business table storage unit 302 and displays the cross-business analysis screen 90 on the output unit of the analysis screen display terminal 130. Show. The cross-business analysis screen 90 includes four display areas (population information display 91, medical examination information display 92, medical information display 93, and care information display 94) corresponding to the multidimensional business table. In addition, an analysis menu switching button 97 and a counting method switching button 95 are displayed at the top of the cross-business analysis screen 90.

  In the population information display 91, a horizontal axis indicates an academic distinction, and a vertical axis indicates a demographic graph for each age group. The analyst of the analysis screen display terminal 130 operates the input unit and clicks the display content selection button 91-1, so that the multidimensional business table output program 206 can display the number of populations, the number of households, The display contents can be changed using the attributes of the multi-dimensional population table (FIG. 3A) 27 such as the aging rate as a totaling condition.

  In addition, the analyst of the analysis screen display terminal 130 clicks the switch button 91-2 on the vertical axis, so that the multi-dimensional business table output program 206 can be set according to gender, other regions, and the total of the latest data points. It is possible to display by switching the vertical axis.

  Also, by clicking the horizontal axis switching button 91-3, the multi-dimensional work table output program 206 can display the horizontal axis by switching the horizontal axis according to year, other regions, the total of the latest data points, and the like. Is possible.

  In the medical examination information display 92, the horizontal axis indicates the distinction of the academics, and the vertical axis indicates the number of persons to be examined by age group. The analyzer of the analysis screen display terminal 130 operates the input unit and clicks the display content selection button 92-1, so that the multidimensional task table output program 206 receives the medical examination in addition to the number of medical examination subjects. It is possible to change the display content using the attributes and the like of the multidimensional medical examination table (FIG. 3B) 28 such as the number of persons and the medical examination acceptance rate as the aggregation conditions.

  In addition, as described in the population information display 91, the multi-dimensional work table output program 206 also displays the data of each axis, etc. by operating the switch button on the horizontal axis. Can be switched.

  In the medical information display 93, the horizontal axis indicates academic distinction, and the vertical axis indicates the number of patients by age group. By clicking the display content selection button 93-1, the multidimensional work table output program 206 causes the multidimensional medical table (FIG. 3D) 30 such as medical expenses and medical expenses per patient in addition to the number of patients. It is possible to change the display content using as a totaling condition.

  In addition, as described in the population information display 91, the multi-dimensional work table output program 206 also displays the data of each axis, etc. by operating the switch button on the horizontal axis. Can be switched.

  In the care information display 94, the horizontal axis indicates academic distinction, and the vertical axis indicates the number of certified caregivers by age group. The analyzer of the analysis screen display terminal 130 operates the input unit and clicks the display content selection button 94-1 so that the multidimensional business table output program 206 is not limited to the number of certified nursing caregivers. The display contents can be changed using the attributes, etc. of the multi-dimensional care table (FIG. 3C) such as the number, the care cost, and the care cost per user as the aggregation conditions.

  In addition, as described in the population information display 91, the multi-dimensional work table output program 206 also displays the data of each axis, etc. by operating the switch button on the horizontal axis. Can be switched.

  As a common function of each display area, when the analyst clicks the aggregation method switching button 95, the multidimensional business table output program 206 switches the display contents of each business information from a diagram to a table or displays values. It is possible to additionally display a ratio display for the population.

  Similarly, when the analyst clicks the analysis target narrowing / fixing button 96, the multidimensional business table output program 206 displays the attributes and the like of the multidimensional business table of each business as analysis conditions, and the analyst's Aggregated information narrowed down by selection can be displayed. Here, the narrowing-down conditions are managed as an analysis target group by the analysis target 422 of the group management unit (FIG. 3E) 31 and cooperate with each multidimensional business table. Thereby, when narrowing down by the condition of the nursing care business, the nursing care information display 94 is updated, and at the same time, the population information display 91, the medical examination information display 92, and the medical information display 93 can be updated together.

  By operating the above buttons, analysis across health and welfare services such as population, medical examination, medical care, and nursing care becomes possible.

  For example, when the analyst detects a school district 2 with a high medical cost per patient in the medical information display 93, the medical district information is taken from the medical examination information display 92 so that the school district 2 can receive a medical examination. It is possible to grasp that the rate is low and to use it for the prevention business measures. At the same time, the school district 2 can grasp that the care cost per user is high from the care information display 94 and can use it for reviewing the care service.

  By using the cross-business analysis screen 90 in this way, it is possible to perform business efficiently and effectively by analysis across other business that could not be realized by the existing business system.

<Analysis menu>
FIG. 9 is a diagram illustrating an example of the analysis menu 910. The analysis menu 910 is displayed by operating the analysis menu switching button 97 displayed on the cross-business analysis screen 90 shown in FIG.

  The analysis menu 910 is displayed by categorizing preset typical analysis processes into categories corresponding to the tasks in the multidimensional task table. The categories of the analysis menu corresponding to each business are the demographics 921 for analyzing the business information in the multidimensional population table 27, the medical examination 922 for analyzing the business information in the multidimensional medical examination table 28, and the multidimensional medical table 30. A medical insurance 923 for analyzing the business information, a care insurance 924 for analyzing the business information in the multidimensional care table 29, and other analyzes 925 are preset.

  Within each category, a submenu of analysis processing is displayed, and an icon 930 for selecting an output form (expression axis) such as a table or a graph is displayed in each submenu.

<Recursive analysis>
FIG. 7 shows that a specific analysis such as population, medical examination, medical care, and nursing care is performed, and a recursive analysis is performed by specifying an analysis condition for the group (analysis target data) again with the analysis target fixed. It is a flowchart which shows an example of an operation procedure.

  In this process, an analyst using the analysis screen display terminal 130 operates the analysis menu switching button 97 displayed on the cross-business analysis screen 90 in FIG. 6 to select a predetermined submenu from the analysis menu 910 in FIG. It is executed by selecting.

  In the task total information reading step 801, the multidimensional task table output program 206 reads task information of each multidimensional task table stored in the multidimensional task table storage unit 302 as display information on the recursive analysis screen.

  In the analysis condition setting step 802, the multidimensional task table output program 206 sets a condition for totaling the task information read in step 801. The analyst operates the analysis screen display terminal 130 and clicks the analysis target narrowing / fixing button 96 to set one or more attributes as analysis target conditions.

  For example, the multi-dimensional population table 27 selects area information such as date, gender, age group, school district and daily life area, and the multi-dimensional medical examination table 28 provides information on consultation and non-examination information such as the examination date and each test result. In the multidimensional care table 29, select the receipt information such as the date of receipt and the care service used, and the degree of care required, etc. In the multidimensional medical table 30, the date of consultation, disease classification, medical expenses, etc. Medical information such as the contents of medical receipts can be selected as a condition.

  In the fixed object determination step 803, the multidimensional task table output program 206 sets the analysis target condition determined in step 802 as a population in the group management unit 31 of the group storage unit 303. As a result, the analysis conditions can be determined again for the analysis target set in step 802.

  In the analysis condition setting step 804, the multidimensional task table output program 206 receives from the analysis screen display terminal 130 a totaling condition for analyzing the task information to be analyzed fixed in step 803 under another condition. The analyst clicks the analysis target narrowing / fixing button 96 to set conditions. The analysis screen display terminal 130 sets the same attribute as in step 802 as a totaling condition.

  In the recursive analysis screen display step 805, the multidimensional business table output program 206 executes analysis according to the analysis conditions set in step 804 and displays the screen.

  With the above processing, for example, in step 802, “analyzing person who needs nursing care 4 in 2015” is targeted, analysis target data is fixed in step 803, and “2005” is selected in step 804 as a condition. Business information can be analyzed.

  Thereby, in the recursive analysis processing screen 810 (FIG. 8) output from the data analysis apparatus 101, what kind of state the care recipient who was in need of care 4 in 2015 was in 2005, It becomes possible to analyze recursively back in time.

  In addition, the data analysis device 101 also analyzes the progress of time while fixing the target person (population) as to what kind of nursing care service usage is the next year and the target year 2015 for the analysis target that was in a specific state in 2014 It is also possible to combine with analysis across a plurality of tasks such as totaling and displaying the status of other fields such as medical care and medical examinations of the group to be analyzed.

  In this way, the multidimensional business table and the group management unit 31 enable recursive analysis that could not be realized with existing business systems and data structures, and complement the analyst's IT skills efficiently and effectively. A comparative analysis can be performed.

<Map analysis>
FIG. 10 is a flowchart illustrating an example of the map analysis process. FIG. 11 is a diagram illustrating an example of a map analysis screen 710 that displays a result of the map analysis processing. This process is executed when the analyst of the analysis screen display terminal 130 selects a predetermined submenu from the analysis menu 910 in FIG.

  First, in step 701, the multidimensional business table output program 206 includes the multidimensional business table output information stored in the multidimensional business table storage unit 302 in the fields selected by operating the analysis menu 910. Acquire business information from the dimension business table and perform a predetermined analysis. Then, the multidimensional business table output program 206 reads the map information stored in the related information storage unit 304, generates the map information and the analysis result to be displayed on the map display unit 714 in FIG. 11, and displays the analysis screen display terminal. To 130.

  Next, in step 702, if the display content of the map display unit 714 does not match the analysis purpose of the analyst of the analysis screen display terminal 130, the process proceeds to step 704, and if it matches, the process proceeds to step 703. .

  In step 704, the analyst operates the analysis target narrowing / fixing button 711 in FIG. 11 via the analysis screen display terminal 130, time series information such as the year and month to be analyzed, the place of residence, disease or health condition. The attribute contents of the work information such as the medical examination status are selected, and the multi-dimensional work table in the multi-dimensional work table storage unit 302 is re-calculated by coordinating with the group axis by the group management unit 31 of the group storage unit 303, and totaled The value is read and output to the map display unit 714.

  In addition, when it is desired to display the aggregation unit not in the whole area but in a finer unit such as each administrative district or each elementary school district, it can be selected by selecting from the analysis screen display terminal 130 with the map display content switching button 713 in FIG. The dimension work table output program 206 reads the recount result and the map information and outputs them to the map display unit 714.

  In step 703, the multidimensional task table output program 206 selects information to be superimposed on the map display unit 714. By operating the graph overlay button 712 in FIG. 11, the multidimensional business table output program 206 acquires the type information of the medical institution or the care establishment stored in the related information storage unit 304 and displays the analysis screen. By selecting the type information that the analyzer of the terminal 130 wants to superimpose and analyze, the other information 715 indicating the location of the medical institution or the nursing care office can be output on the total result of the map display unit 714 and the map. it can.

  As described above, by operating various buttons on the map analysis screen 710, the map information can be displayed in combination with the analysis result. For example, in April 2014, with a medical institution patient who has diabetes as a condition for analysis, the map display unit 714 can grasp in detail the number of diabetic patients in each district, etc., to grasp the situation of disease prevention in the region and evaluate the efforts It can be used.

  In addition, the multi-dimensional business table output program 206 displays the location status of medical institutions and nursing care facilities on the map display unit 714 in an overlapping manner, so that it is possible to grasp the actual situation such as the status of satisfaction of medical facilities that take measures against diabetes. It can be used.

  In this way, the simultaneous analysis function that combines related information such as multi-dimensional work table and map information and facility information is realized, complementing analyst's work experience, land insight and IT skills that could not be realized with existing business system This will enable efficient and effective regional analysis.

<Group comparison analysis>
FIG. 12 is a flowchart showing an example of a process of specifying and analyzing a plurality of independent groups (data groups) in the multidimensional work table at the same time. This process is executed when the analyst of the analysis screen display terminal 130 selects a predetermined submenu from the analysis menu 910 in FIG. FIG. 13 is a diagram showing an example of a group comparison screen 821 that displays the results of the group comparison analysis process.

  First, in step 811, the multidimensional business table output program 206 reads the information of the multidimensional business table in the field selected by the analysis menu 910 from the business information in the multidimensional business table storage unit 302, and the The aggregated contents are generated in a specified display form (expression axis) such as a graph or a table in the collective display unit 819 and output to the analysis screen display terminal 130.

  Next, in step 812, the multi-dimensional work table output program 206 displays the analysis conditions of the first group to be analyzed by the analyst of the analysis screen display terminal 130 as the analysis target narrowing / fixing button 822 shown in FIG. Select from the multi-dimensional work table attribute information displayed after clicking.

  When the multidimensional work table output program 206 receives an operation of the vertical axis switching button 817 and the horizontal axis switching button 818 from the analysis screen display terminal 130, the horizontal axis or vertical axis of the graph or table on the group comparison screen 821. Change the conditions.

  In response to the condition change, in step 813, the multidimensional task table output program 206 executes the multidimensional task of the group management unit 31 of the group storage unit 303 and the multidimensional task table storage unit 302 updated to the specified analysis conditions. Re-aggregate using table linkage. Then, the multidimensional task table output program 206 updates the contents of the first group display unit 819 with the result of the recounting.

  Next, in step 814, the multidimensional task table output program 206 operates the second group condition to be compared by the analyst by operating the analysis target narrowing / fixing button 822, in the same manner as in step 812. Select analysis conditions for the population.

  Then, the multi-dimensional business table output program 206 re-aggregates using the cooperation of the multi-dimensional business table in the multi-dimensional business table storage unit 302 and the multi-dimensional business table storage unit 302 updated to the specified analysis condition. To implement. The multidimensional business table output program 206 updates the contents of the second group display unit 820 with the result of the recounting.

  In step 815, the multidimensional task table output program 206 determines whether or not the difference between the average value for the population distribution of the first group and the second group is significant. This determination is performed by, for example, a known or well-known statistical method such as a pre-programmed t-test, and when it is determined as a significant difference, a predetermined part is highlighted and the first group display unit 819 and the second group display unit The display of 820 is updated.

  As described above, by operating various buttons on the group comparison screen 821, the analysis results of a plurality of groups (data groups) can be compared and displayed. For example, a patient who answered that he / she smoked in the 2014 medical examination table is group A, and a medical person who answered that he / she does not smoke in 2014 is a group B. In addition to being able to refer to comparisons between groups, statistically significant differences with respect to the population can be confirmed at a time.

  In this way, the multi-dimensional business table, the group management unit 31 and the comparison and verification functions of a plurality of groups complement the analyst's statistical skills and IT skills that could not be realized with the existing business system, making it efficient and efficient. Effective comparative analysis can be performed.

<Summary>
As described above, in the data analysis apparatus 101, each multi-dimensional business table is created by generating a group axis from business system data in a plurality of fields such as resident information, medical insurance information, care insurance information, and medical examination information. Can be linked. Each multidimensional business table generates a group axis, a time axis, and a business axis, thereby enabling business information (business axis) to be linked between different business systems.

  Thereby, multidimensional data can be analyzed under desired conditions across business systems. For example, it becomes possible to grasp trends and breakdowns of medical expenses, nursing care expenses, the number of patients, and the number of various service users by various attributes of residents such as for each region and each year. As a result, it is possible to grasp the situation of excess and deficiency of resources such as medical facilities, nursing care facilities, and professionals that can be used by the residents to be analyzed and preventable diseases. Make business decisions and budget allocations that are easy and lean. As a result, it is possible to suppress an increase in medical expenses and nursing care costs and to maintain and improve the health of residents.

  In addition, the data analysis apparatus 101 can find a date with a problem on a certain group on a recurring time axis in the future or the past. Alternatively, for a given group, areas with problems can be found by detailed regional axes such as elementary school districts and autonomous districts. Alternatively, multidimensional analysis combining business axis, time axis, and regional axis is possible. In addition, it is possible to reduce outsourcing costs for data processing work and analysis work.

  In addition, the data analysis apparatus 101 can grasp trends and breakdowns of medical expenses, nursing care expenses, the number of patients, and the number of various service users based on various attributes of residents such as each region and every year. As a result, it is possible to grasp the excess or deficiency of resources such as medical facilities, nursing care facilities, and professionals that can be received, and preventable diseases, and share local priorities with relevant stakeholders to make timely and lean business decisions. And budget allocation.

  In addition, multidimensional business table data is combined with non-insurance inhabitant service information obtained from private businesses and new administrative information such as maternal and child health, disaster prevention and education, etc. It can also be used for more integrated administrative management and policy studies such as health measures from a young age. For example, a multidimensional business table can be generated from a plurality of tables including business information related to residents managed by the government in place of the health and welfare of the residents, and the first business information managed by the government (related to taxes other than health and welfare) Information) is the first resident information table, the second business information (information about resident education) managed by the administration is the second resident information table, and the first and second resident information tables are as described above. The first and second multidimensional business tables can be generated by complementing in time series. In this case, the group management unit may associate the mutually related data between the first and second resident information tables and the basic resident information table.

  It is possible to replace a part of the data in the above embodiment with other data. Further, it is possible to add, delete or replace other data with respect to a part of the data of the above embodiment. For example, it is possible to add data such as cancer screening and comprehensive care prevention projects to the health and welfare field data.

  In addition, a country name, a prefecture name, or a city name may be added to the area information, and the information may be added to the total display conditions. Furthermore, public tax and education data, history of disasters, crimes, etc. for each address, public and private data such as the location of disaster countermeasure facilities and private business services, and the number of various professionals may be added.

  In the above embodiment, an example in which a plurality of multidimensional business tables are linked by using a personal unique key as the collective axis 421 of the collective management unit 31 is shown. However, information (data item or field) used for the collective axis 421 is shown. The name is not limited to information that uniquely identifies an individual. The information used for the collective axis 421 may be, for example, a data item that can specify or link information between a plurality of multidimensional business tables.

  Further, the information constituting the collective axis 421 of the collective management unit 31 is not limited to the same data item among a plurality of multidimensional business tables. The collective axis 421 can link a multidimensional work table with different types of information. For example, the multidimensional population table 27 uses a personal number, the multidimensional medical table 30 uses a health insurance number, and a multidimensional care table. In 29, a nursing care certification number may be used, and in the multidimensional medical examination table 28, a pension number or a personal number may be used.

  Further, the data items constituting the group axis 421 of the group management unit 31 can be changed as appropriate according to the contents of analysis. For example, the regional information (regional axis) of each multidimensional business table may be handled as a collective axis to perform analysis processing related to the region.

  In addition, this invention is not limited to an above-described Example, Various modifications are included. For example, the above-described embodiments are described in detail for easy understanding of the present invention, and are not necessarily limited to those having all the configurations described. Further, a part of the configuration of one embodiment can be replaced with the configuration of another embodiment, and the configuration of another embodiment can be added to the configuration of one embodiment. In addition, any of the additions, deletions, or substitutions of other configurations can be applied to a part of the configuration of each embodiment, either alone or in combination.

  Each of the above-described configurations, functions, processing units, processing buttons, and the like may be realized by hardware by designing a part or all of them, for example, with an integrated circuit. In addition, each of the above-described configurations, functions, and the like may be realized by software by the processor interpreting and executing a program that realizes each function. Information such as programs, tables, and files for realizing each function can be stored in a memory, a hard disk, a recording device such as an SSD (Solid State Drive), or a recording medium such as an IC card, an SD card, or a DVD.

  Further, the control lines and information lines indicate what is considered necessary for the explanation, and not all the control lines and information lines on the product are necessarily shown. Actually, it may be considered that almost all the components are connected to each other.

27 Multidimensional population table 28 Multidimensional medical examination table 29 Multidimensional care table 30 Multidimensional medical table 31 Group management unit 101 Data analysis device 104 Computing device 105 Memory 106 Storage medium 120 Database 130 Analysis screen display terminal 201 Multidimensional business table creation Program 206 Multidimensional business table output program 302 Multidimensional business table storage unit 303 Group storage unit 304 Related information storage unit

Claims (13)

A data analysis device that has a processor and a memory and analyzes data on the health and welfare of residents.
The processor includes a basic resident information table including personal information capable of identifying the resident, a first health welfare table including business information related to the health and welfare of the resident, and a second including business information related to the health and welfare of the resident. Read the health and welfare table
From the data of the basic resident information table, the first health welfare table, and the second health welfare table, the processor is provided between the first health welfare table, the second health welfare table, and the basic resident information table. Generates group management information that correlates data related to each other,
The processor generates a first multidimensional task table from data supplemented in time series for the data of the first health and welfare table,
The processor generates a second multidimensional task table from data supplemented in time series for the data of the second health and welfare table,
The data analysis apparatus, wherein the processor generates a third multidimensional business table from data supplemented in time series for the data of the basic resident information table. The data analysis device according to claim 1,
The processor receives analysis conditions, specifies data that matches the analysis conditions in the group management information,
The processor includes data of the first multidimensional task table corresponding to data specified by the group management information, data of a second multidimensional task table corresponding to data specified by the group management information, and A data analysis apparatus characterized in that each of the data of the third multidimensional work table corresponding to the data specified by the group management information is acquired and the analysis is performed according to the analysis conditions. The data analysis device according to claim 2,
The processor outputs a result of the analysis, a first display area for outputting an analysis result of the data of the first multidimensional task table, and a result of analysis of the data of the second multidimensional task table. 2 display areas and a third display area for outputting the analysis result of the data of the third multidimensional business table, and generating the first display area, the second display area, and the third display area. A data analysis apparatus characterized by outputting a result display screen including the result display screen. The data analysis device according to claim 2,
The first multi-dimensional business table, the second multi-dimensional business table, and the third multi-dimensional business table include regional information.
The data analysis apparatus, wherein the processor reads map information and outputs the analysis result in association with the map information corresponding to the area information included in the analysis result. The data analysis device according to claim 1,
The group management information has information that holds a population of the results of analysis,
The processor receives the first analysis condition, sets the data of the result of the analysis under the first analysis condition as a population in the group management information,
The processor receives a second analysis condition, compares the result analyzed under the second analysis condition with the data corresponding to the population, and the result analyzed under the first analysis condition A data analysis apparatus for comparing results analyzed under a second analysis condition. The data analysis device according to claim 1,
The first multidimensional work table and the second multidimensional work table include medical information, health insurance information, care insurance information, and medical examination information or health guidance information. Data analysis device. A computer that has a processor and a memory to analyze data on the health and welfare of residents.
A basic resident information table including personal information capable of identifying the resident, a first health welfare table including business information relating to the health and welfare of the resident, and a second health welfare table including business information relating to the health and welfare of the resident A first step of reading
The first health welfare table, the second health welfare table, and the resident basic information table are correlated with each other based on the data of the resident basic information table, the first health welfare table, and the second health welfare table. A second step of generating group management information for associating data to be performed;
A first multi-dimensional work table is generated from data supplemented in time series for the data in the first health and welfare table, and a second data from data supplemented in time series is generated for the data in the second health and welfare table. A third step of generating a multidimensional business table and generating a third multidimensional business table from the data supplemented in time series for the data of the basic resident information table;
A program for causing the computer to execute. The program according to claim 7,
A fourth step of receiving analysis conditions and identifying data that matches the analysis conditions by the group management information;
Data of the first multidimensional task table corresponding to the data specified by the group management information, data of a second multidimensional task table corresponding to the data specified by the group management information, and the group management A fifth step of respectively obtaining data of a third multidimensional business table corresponding to the data specified by the information and performing an analysis according to the analysis conditions;
The program characterized by further including. The program according to claim 8, wherein
A first display area for outputting the analysis result of the data of the first multidimensional work table, and a second display area for outputting the analysis result of the data of the second multidimensional work table And a third display area for outputting the analysis result of the data of the third multidimensional business table, and a result display screen including the first display area, the second display area, and the third display area The sixth step of outputting
Furthermore, the program characterized by including. The program according to claim 8, wherein
The first multi-dimensional business table, the second multi-dimensional business table, and the third multi-dimensional business table include regional information.
A seventh step of reading the map information and outputting the analysis result in association with the map information corresponding to the area information included in the analysis result;
Furthermore, the program characterized by including. The program according to claim 7,
The group management information has information that holds a population of the results of analysis,
An eighth step of receiving the first analysis condition and setting the data of the result of the analysis under the first analysis condition as a population in the group management information;
The second analysis condition is received, and the result analyzed under the second analysis condition is compared with the data corresponding to the population, so that the result analyzed under the first analysis condition and the second analysis are compared. A ninth step of comparing the results analyzed under the conditions;
The program characterized by further including. The program according to claim 7,
The first multidimensional work table and the second multidimensional work table include medical information, health insurance information, care insurance information, and medical examination information or health guidance information. program. A data analysis device that has a processor and a memory and analyzes data about residents,
The processor manages a basic resident information table including personal information capable of identifying the resident, a first resident information table including first business information managed by the government regarding the resident, and the government regarding the resident. Read the second resident information table containing the second business information,
From the data of the basic resident information table, the first resident information table, and the second resident information table, the processor is provided between the first resident information table, the second resident information table, and the basic resident information table. Generates group management information that correlates data related to each other,
The processor generates a first multidimensional task table from data supplemented in time series for the data of the first resident information table,
The processor generates a second multidimensional task table from data supplemented in time series for the data of the second resident information table,
The data analysis apparatus, wherein the processor generates a third multidimensional business table from data supplemented in time series for the data of the basic resident information table.