JP6677756B2 - Data analysis device and program - Google Patents

Description

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

  Local governments, regional federations, health care insurers and insurers evaluate medical plans, long-term care insurance, and preventive care in an integrated manner to address complex regional and social issues due to the aging of the population. In addition, it is required to plan policies and secure financial resources promptly.

  In addition, the enforcement of the Basic Law on the Use of Public-Private Data has enabled prefectures and municipalities to realize a society that can provide more detailed services to individual citizens by promoting smooth data distribution beyond the barriers of data holders. It is necessary to work on it.

  Against this background, it is required to analyze issues simultaneously and across multiple fields of health and welfare, based on time-series changes and multidimensional factors such as area and age.

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

  However, local governments, etc., handle different data such as "resident information", "medical insurance information", "care insurance information", and "medical checkup information" because the organization in charge is different for each business (or business system). Since the computer systems are developed and operated individually, the business is limited to data that is individually used for each business field.

  In other words, public services, such as population, medical examination, medical care, and nursing care, which individuals use continuously according to aging and morbidity, are analyzed by individual staff and outsourced for each individual field. The issue is that it is not possible to find groups with high interest in administrative policy across the country.

  Specifically, the issue is that it is not possible to perform multidimensional analysis that can specify a group by specifying complex conditions on the work axis that crosses the health and welfare field, the regional axis such as elementary school districts and self-government districts, and the time axis. ing.

  For example, a regression analysis of the time axis of the same field, such as "What was the need for nursing care in 2013 for a group of 80-year-olds who needed nursing care 3 in 2015?" Cross-disciplinary analysis such as "What was the result of the medical check-up in 2005?" And "What are the current medical expenses for people in the autonomous district in 2013?" Detailed regional analysis has not been realized at present.

  According to Patent Literature 1, although medical data and medical examination data of a group of examinees can be analyzed at a specific medical institution, cross-sectional analysis of the nursing field and regional analysis of elementary school districts and self-governing districts cannot be performed.

  In Patent Literature 2, medical insurance and care insurance system information of different insurers can be identified. For example, analysis of a time axis in which data does not exist without using medical insurance or care insurance is performed because data does not exist. Analysis focusing on the time axis cannot be performed.

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

  Therefore, the present invention collectively integrates information in a plurality of fields such as resident information, medical insurance information, care insurance information, and medical examination information, and obtains information from a plurality of conditions such as time series, attributes of residents and attributes of a region. An object is to easily realize multidimensional analysis across a plurality of fields.

The present invention is a data analysis device that includes a processor and a memory and analyzes data related to the health and welfare of residents, wherein the processor includes a residents basic information table including a personal number capable of identifying the residents, A medical insurance table including information on medical care and a personal number capable of identifying an individual, a care insurance table including information on the care of the inhabitant and a personal number capable of identifying the individual, information on the health check of the inhabitant and the individual The medical examination table containing the identifiable personal number is read, and the entry of the resident basic information table, the entry of the medical insurance table, the entry of the nursing insurance table, and the entry of the medical examination table of the inhabitants having the same personal number are uniquely identified. by applying a personal unique information to generate a population management information that associates the, the processor is either the resident information table The multi-dimensional population table is generated by obtaining personal information on the individual of the inhabitant, regional information on the address, and time-series demographic information, and the processor generates personal information on the individual of the inhabitant from the medical insurance table. And obtaining regional information on the address and medical service information on time-series medical care to generate a multi-dimensional medical table, wherein the processor obtains the personal information on the individual of the inhabitant from the care insurance table and the area on the address. Information and nursing care information relating to nursing care in time series to generate a multidimensional nursing care table, wherein the processor is configured to provide personal information on the inhabitants' individual from the medical examination table, regional information on addresses, and time series. To obtain a multi-dimensional medical check-up table by obtaining medical check-up operation information related to the medical check-up, and the processor Extracting data corresponding to the analysis conditions from any of the multidimensional medical table, the multidimensional care table, and the multidimensional medical examination table designated by the analysis conditions, and the processor Corresponding individual unique information is obtained from the group management information, and information associated with the analysis conditions is extracted from the multidimensional population table, the multidimensional medical table, the multidimensional care table, and the multidimensional medical examination table .

  Therefore, the present invention can perform multidimensional data analysis under desired conditions across a plurality of fields such as resident information, medical insurance information, care insurance information, and medical examination information. For example, medical attributes, nursing costs, the number of patients, and the trends and breakdowns of the number of various service users can be ascertained based on various attributes of residents such as each region and each year. In this way, we can grasp the excess and deficiency of resources, such as medical facilities, nursing homes, and professionals, that can be targeted by the target residents, and prevent diseases that can be prevented, and share regional priorities with related parties in a timely and timely manner. Lean business decisions and budget allocation. As a result, it is possible to suppress increases in medical expenses and nursing care expenses and to maintain and promote the health of residents.

1 is a block diagram illustrating an example of an analysis system according to an embodiment of the present invention. FIG. 9 illustrates an example of a procedure of a multidimensional business table creation process according to an embodiment of the present invention. It is a figure which shows the Example of this invention and shows an example of a multidimensional population table. It is a figure showing an example of the present invention and showing an example of a multidimensional medical examination table. It is a figure showing an example of the present invention and showing an example of a multidimensional care table. FIG. 8 is a diagram illustrating an example of a multidimensional medical table according to the embodiment of the present invention. 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 Example of this invention and shows a detailed example of a group management part. FIG. 9 illustrates the embodiment of the present invention and is a diagram illustrating a relationship between a group management unit and each multidimensional business table. 6 is a flowchart illustrating an example of the analysis process according to the embodiment of the present invention. It is a figure showing an example of the present invention and showing an example of a business crossing analysis screen. 6 is a flowchart illustrating an example of the present invention and illustrating an example of recursive analysis processing. FIG. 14 is a diagram illustrating the example of the present invention and illustrating an example of a recursive analysis processing screen. It is a figure which shows the Example of this invention and shows an example of an analysis menu. 6 is a flowchart illustrating an example of the map analysis process according to the embodiment of the present invention. 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 map analysis processing. 4 is a flowchart illustrating an example of the present invention and illustrating an example of comparative analysis processing 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 the comparative analysis process of a group.

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

  In the present embodiment, problems in the local government are solved by supplementing missing data (data with missing information) from the data accumulated information of the local government and the like collected in advance, or by creating data in which the names of places are unified by name identification and the like. 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 illustrating an example of a configuration of the analysis system according to the present embodiment.

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

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

  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 and calculation described below are performed by the calculation device 104.

  The analysis system of the present embodiment is a computer system configured on one computer or on a plurality of logically or physically configured computers, and is executed by separate threads on the same computer. And may be executed on a virtual computer constructed on a plurality of physical computer resources.

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

  In the data analyzer 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. Then, the multidimensional care table creation program 205 is made to function in cooperation.

  The multidimensional work table output program 206 receives operation information such as analysis conditions from the analysis screen display terminal 130 via the communication network 50, and obtains numerical information in the health and welfare field of the group to be analyzed in the multidimensional work table storage unit 302. Is calculated, and information necessary for generating an analysis screen is output to the analysis screen display terminal 130.

  The arithmetic device 104 operates as a functional unit that provides a predetermined function by 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. Further, the arithmetic device 104 also operates as a function unit that provides each function of a plurality of processes executed by each program. The computer and the computer system are devices and systems 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 the group management unit 31, and related information that stores conversion information such as map information and character codes. And a storage unit 304.

  The multidimensional business 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 (not shown) including an input unit, an output unit, an arithmetic unit, and a memory.

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

  In step 21, the multidimensional business table creation program 201 reads the 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 including the address of each resident, a change event such as age and transference, and a medical insurance table including a medical and dental dispensing receipt and medical insured information. 12, predetermined health care and welfare such as a care insurance table 13 for care reception, care insured person information and certification information, a medical examination and health guidance table 14 for medical examination results, a medical institution table 15, a care establishment table 16, and the like. The information of the business system in the field is read and stored in the storage medium 106.

  Further, the multi-dimensional work table creation program 201 includes information on district divisions such as school districts for each area, and a medical institution table 15 and a nursing establishment table 16 including names and locations of medical institutions and nursing establishments or service types. Is stored in the storage medium 106, and when the character codes are different between the business systems, the formats are unified by predetermined conversion software and stored in the related information storage unit 304.

  In step 22, the multidimensional business table creation program 201 sorts, for each business system table stored in the storage medium 106, key information (personal unique key) such as a personal number, which can uniquely identify each resident, in ascending order or Sorting is performed in descending order to generate group axis information (group axis 421). As a result, the group management unit 31 is generated, and it becomes possible to cooperatively process information on the same person in the business system and between the business systems.

  In step 23, the multi-dimensional business table creation program 201 executes a process for the address information included in each business system table stored in the storage medium 106, in accordance with the unified district code such as the corresponding nominal town name, school district, and self-governing district. By adding latitude / longitude information, etc., it generates regional axis data in which addresses are uniquely unified in the tables of all business systems.

  For example, even though "1-chome-2-3" is registered in the basic resident information table 11, "1-2-3" or "1-2-3" is registered in the medical insurance table 12 or the like. The present invention solves a conventional problem in which address data between business systems fluctuates, so that it is possible to perform an appropriate aggregation process for an area.

  In step 24, the multidimensional business table creation program 201 enables the business data for each inhabitant, which is generated irregularly, for each business system table stored in the storage medium 106 to be totaled at any time from past to future. In order to do this, time axis data for each inhabitant is generated at least on a monthly basis.

  For example, a resident who has medical insurance qualifications such as National Health Insurance at a certain date is eligible for a specific medical check-up for an 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 the status of qualifications at the time of the consultation month.However, in the system provided by Japan and the conventional private system, Not realized. In this processing, such a problem is solved by holding time axis data in each task.

  In the present embodiment, an example is shown in which time axis data is generated or supplemented in a cycle of every month. However, the present invention is not limited to this, and a cycle such as a week unit or a quarter may be used.

  In step 25, the multi-dimensional business table creation program 201 executes, for each business system table stored in the storage medium 106, the period before and after the generation of business data that occurs irregularly for each inhabitant, or the future of the business data. In order to implement appropriate aggregation for the period, supplementary processing of business data in the omission state is performed, and business axis data that can be aggregated is generated.

  The multidimensional business table creation program 201 firstly sets the basic residents information table 11 for the business information associated with the time axis from the past to the present so that the population and the number of insured persons at a predetermined time can be totaled. In, the business data in the period before and after the generation of the transfer data is newly generated in a time series according to the reason by searching for the change reason of the basic resident information for each individual 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 the history of gain and loss of the insurance qualification, and can change the business data in the period before and after the loss data is generated according to the reason. Complement business data by newly creating a series.

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

  Next, the multi-dimensional business table creation program 201 performs predetermined estimation processing such as machine learning and statistical processing on the stored business data in the business information associated with the time axis in the future from the date of occurrence of the stored data. In this way, business data for 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 medical examination and health guidance table 14 and the medical insurance table 12 for each individual to determine whether a medical institution related to diabetes in 2015 based on medical receipt information (0 Or take a value of 1) as an objective variable, and an estimation model can be constructed using BMI (Body Mass Index) in 2014 based on medical checkup information or fasting blood glucose (take continuous values) as an explanatory variable. .

As described above, the multidimensional business table creation program 201 constructs an estimation model in which different information at the time of data acquisition is set as an explanatory variable and an objective variable, thereby obtaining a BMI, a fasting blood glucose, a question answer value, etc. for a certain year. 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 during the period can be complemented.

Visits following year hypertension probability _{= a 11 × y 1 + a} 12 × y 2 + a 13 × y 3 ···
Visits probability of hypertension of Yokuyokunen _{= a 21 × y 1 + a} 22 × y 2 + a 23 × y 3 ···

In addition, multi-dimensional business table creation program 201 is to aggregate the correction coefficient b _nm of each average medical expenses b _n and the year of attributes and of another disease in consideration of the consultation period, such as the age of the residents by disease from the medical insurance tables 12 The expected value of the annual medical expenses for the next fiscal year or later can be generated as follows by adding the probability of consultation to the medical institution of the individual obtained as described above, and the medical expenses data for the future period can be complemented.

Expected value of the next year medical cost _{(hypertension) = b 1 × (a 11} × y 1 + a 12 × y 2 + a 13 × y 3 ···)
Expected value of medical expenses Yokuyokunen _{(hypertension) = (b 2 × b 11} ) × (a 11 × y 1 + a 12 × y 2 + a 13 × y 3 ···)

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

  Through 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 basic resident information table 11.

  In the multidimensional population table 27, a population axis 271 is generated by assigning, for example, a personal number of a resident as population axis data. As the time axis data, monthly data is generated or supplemented to generate the time axis 272. 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 not shown, regional axis data is also generated based on the addresses of the residents.

  In the example of FIG. 2B, the time axis 272 is set on the X axis, the group axis data (population 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 the 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 a resident is assigned as the population axis data, and the medical examination group axis 281 is generated. Further, as the time axis data, data is generated or supplemented with the date of the medical examination, and the time axis 282 is generated. Also, a BMI at the time of a medical examination is assigned as the work axis data, and a 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 multidimensional care table 29, for example, a personal number of a resident is assigned as group axis data, and a care group axis 291 is generated. As the time axis data, data is generated or supplemented with the date of receiving the care insurance service, and the time axis 292 is generated. In addition, the care cost is assigned as the work axis data, and the care cost axis 293 is generated.

  FIG. 2E is a diagram illustrating an example of the multidimensional medical table 30 generated based on the medical insurance table 12. In the multidimensional medical table 30, for example, a personal group number of a resident is assigned as group axis data, and a medical group axis 311 is generated. In addition, as time axis data, data is generated or supplemented with the date of receiving medical insurance service such as medical treatment, and the time axis 312 is generated. In addition, the medical expenses axis 313 is generated by assigning the medical treatment expenses as the business axis data.

  2A to 2E, an example is shown 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 multidimensional 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 another multidimensional business table, and business information generated by a business system related to population. And the population work information 412 to be stored.

  The key information 411 includes a personal unique key 2711 for storing an identifier for uniquely specifying a person, and period information 2712 for storing a year and month for specifying a period to be analyzed.

  The population operation information 412 stores business information such as personal information 2713 such as gender and age, which should be used as an analysis axis of demographics, regional information 2714 such as a place of residence, and demographic information 2715 such as birth, death, and moving in and out. Is done.

  FIG. 3B is a diagram showing details of the multidimensional medical examination table 28 stored in the multidimensional business 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 attributes of other multidimensional business tables, and business information generated by a business system related to medical care. And medical examination operation information 414 that stores

  The key information 413 includes a personal unique key 2811 for storing an identifier for uniquely specifying a person, and period information 2812 for storing a year and a month for specifying a period to be analyzed.

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

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

  The multi-dimensional care table 29 stores key information 415 for designating a group (column or axis) to be analyzed in cooperation with the attributes of another multi-dimensional work table, and business information generated by a work system related to care. Nursing service information 416 to be stored.

  The key information 415 includes a personal unique key 2911 for storing an identifier for uniquely specifying an individual, a care service unique number 2912 for storing an identifier of a care-insured person, and a date for specifying a period to be analyzed ( (Use of nursing care).

  The nursing care information 416 includes personal information 2914 such as gender and age to be analyzed in care insurance, regional information 2915 such as residence, nursing qualification information 2916 such as nursing care certification results, and nursing care insurance included in care receipt data. Business information such as nursing care receipt information 2917 for storing payment costs and the like and nursing care office information 2917 for storing the office number of the provider of the used nursing service and its location 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 the attributes of another multidimensional business table, and business information generated by the business system related to medical insurance. And medical service information 418 that stores

  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 an identifier of medical insurance, a medical insurance type 3013 for storing the type of medical insurance, and an analysis. It includes period information 3014 for storing a year (month and year of consultation) for specifying a target period.

  The medical service information 418 includes personal information 3015 such as gender and age to be analyzed in medical insurance, regional information 3016 such as a place of residence, and medical receipt information 3017 storing medical insurance payment costs and the like included in medical receipt data. And business information such as medical institution information 3013 that stores the number of the medical institution that received the medical examination and its location.

  In the present embodiment, an example is shown in which the multidimensional business table includes the four tables of the multidimensional population table 27, the multidimensional medical examination table 28, the multidimensional care table 29, and the multidimensional medical table 30. However, the present invention is not limited to this, and a 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 of FIG. 2A.

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

  The group axis 421 links the data of each inhabitant corresponding to the search condition with respect to each of the above-described multidimensional business tables processed in step 25.

  The illustrated group axis 421 includes a personal unique key (population) 3111 obtained by adding “P” to the value of the personal unique key 2711 of the multidimensional population table 27, and “N” as the value of the personal unique key 2911 of the multidimensional care table 29. ", 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 (medical care) 3113 of the multidimensional medical examination table 28. An individual unique key (medical examination) 3114 obtained by adding “C” to the value of the key 2811 is included.

  The multidimensional business table creation program 201, for example, converts the personal unique key 2811, 2911, 3001 of a person matching the personal unique key 2711 of the multidimensional population table 27 from personal information such as name, address, gender, age, etc. The information is extracted from the diagnosis 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.

  Thus, the four multidimensional business tables (the multidimensional population table 27, the multidimensional medical checkup table 28, the multidimensional care table 29, and the multidimensional medical table 30) specify one individual unique key, The analysis can be performed by linking the respective 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.

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

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

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

  By using the groups A3117 to C3119, it is possible to return to the population while retaining the results of the narrowing conditions A to C when the narrowing 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 group axis information from the analysis screen display terminal 130, narrows the group of each multidimensional business table with the group axis information, and outputs the narrowed result to the analysis screen display terminal 130. .

  FIG. 4 is a diagram showing the relationship between the group management unit 31 and each multidimensional business table. The multidimensional business table includes a multidimensional population table 27, a multidimensional nursing care table 29, a multidimensional medical table 30, a multidimensional medical examination table 28, an aggregate of four data (multidimensional business table), and group management. It is composed of a unit 31.

  When data analysis in another field is added, a multidimensional business table is added, a column is added to the group axis 421 of the group management unit 31, and the multidimensional business tables are linked to perform analysis. .

  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 specifying an individual. In this case, the business axis (273, 283, 293, 303) corresponding to the field of each multidimensional business table is held (for example, in the case of a multidimensional care table, the care cost axis, etc.).

  As described above, the group management unit 31 links the group axes of each multidimensional business table with the group axis 421, and links the business information of each multidimensional business table. Note that the group management unit 31 associates the groups to be analyzed simultaneously in each multidimensional business table based on the correspondence of the group axis. For example, an ID for specifying an individual in each multidimensional business table is used. When the same value is shared for the (personal unique key), the minimum configuration that only holds the ID of the analysis target as shown by 411 in the figure can be adopted.

  When analyzing each multidimensional business table, the population (data group) identified by the population flag 3115 is set as the population. Then, the group to be analyzed can be narrowed down on a predetermined axis of each multidimensional business table.

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

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

  The analysis target data specified by the group management unit 31 is narrowed down in each multidimensional business table on condition of the group axis. 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 the multidimensional medical table 30 corresponds to the data of the medical group axis 311 = M01, M02.

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

  With the configuration in which the group management unit 31 and the group axis of each multidimensional business table cooperate as described above, the same group can be simultaneously and multidimensionally analyzed in a plurality of multidimensional business tables.

  Also, at the time of analysis, it is possible to reset the analysis target data extracted under predetermined conditions as a population. This is realized by moving the target flag 3116 of the group management unit to the population flag 3115. This makes it possible to regressively analyze the target data narrowed down under the predetermined condition A as a population under predetermined conditions independent of the condition A. In addition, 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 illustrating an example of the analysis processing performed by the multidimensional business table output program 206. This process is started, for example, based on a command from the analyst of the analysis screen display terminal 130.

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

  The analysis value indicates the value of the business information of the multidimensional business table, for example, the value of the population business information 412 of the multidimensional population table 27. The condition axis indicates the condition of the data (resident, etc.) selected on the group axis 421 of the group management unit 31. As the expression axis, a form (a graph, a map, or a table) to be displayed on the output unit of the analysis screen display terminal 130 can be designated.

  The data analyzer 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 specifies a set (group axis) of personal unique keys that match the received analysis conditions.

  In step 503, the multidimensional business table output program 206 traverses each multidimensional business table from the collective axis 421 of the collective management unit 31 based on the collective axis specified in step 502, Specifies the group axis. Note that the multi-dimensional work table output program 206 may specify the collective axes respectively across the multi-dimensional work table in the collective management unit 31 using the collective axes stored in advance.

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

  In step 505, the multidimensional business table output program 206 obtains the analysis value set in step 501 from the business information specified in step 504, and collects the statistics and statistical values as necessary. calculate.

  In the calculation of the statistical value, when 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 tally and the statistical value are calculated as necessary.

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

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

  In step 508, the multidimensional business 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 population, the process returns to step 501 and performs the above processing. On the other hand, if the analyzed population axis is to be stored as a population or a comparison target population, the process proceeds to step 510.

  In step 510, the multidimensional business 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 linking a plurality of multidimensional business tables across the collective axis 421. As a result, information from multiple fields, such as resident information, medical insurance information, long-term care insurance information, and medical checkup information, can be centrally aggregated, and multiple combinations of multiple conditions, such as time series, attributes of residents, and regional attributes, can be used. A multidimensional analysis can be easily and quickly realized across the fields of the above.

<Cross-business analysis screen>
FIG. 6 is a diagram showing an example of the business crossing analysis screen 90 that displays the analysis result obtained by crossing the 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 business cross-sectional 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. At the top of the cross-task analysis screen 90, an analysis menu switch button 97 and a counting method switch button 95 are displayed.

  In the population information display 91, a graph of demographics is displayed on the horizontal axis, and the vertical axis represents demographics by age group. Note that 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 population, the number of households, It is possible to change the display content using the attributes and the like of the multidimensional population table (FIG. 3A) 27 such as the aging rate as the aggregation condition.

  The analyst of the analysis screen display terminal 130 clicks the switch button 91-2 on the vertical axis, and the multidimensional business table output program 206 sorts by gender, other regions, and the total of the latest data. It is possible to switch and display the vertical axis.

  By clicking the switch button 91-3 on the horizontal axis, the multidimensional business table output program 206 can switch and display the horizontal axis according to the year, other regions, the total total at the time of the latest data, and the like. It is possible.

  In the medical checkup information display 92, the horizontal axis indicates school distinction, and the vertical axis indicates the number of medical checkup targets by age group. Note that the analyst of the analysis screen display terminal 130 operates the input unit and clicks the display content selection button 92-1. The display content can be changed 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 consultation rate as the aggregation condition.

  Also, as described in the population information display 91, by operating the switch button on the vertical axis and the switch button on the horizontal axis, the multi-dimensional business table output program 206 also outputs the data of each axis. It is possible to switch.

  In the medical information display 93, the abscissa indicates the school distinction and the ordinate indicates the number of patients by age group. When the display content selection button 93-1 is clicked, the multidimensional operation table output program 206 causes the multidimensional medical table (FIG. 3D) 30 to display attributes such as medical expenses and medical expenses per patient other than the number of patients. Can be used to change the display content.

  Also, as described in the population information display 91, by operating the switch button on the vertical axis and the switch button on the horizontal axis, the multi-dimensional business table output program 206 also outputs the data of each axis. It is possible to switch.

  In the nursing care information display 94, the horizontal axis indicates school distinction, and the vertical axis indicates the number of certified caregivers by age group. The analyst of the analysis screen display terminal 130 operates the input unit and clicks the display content selection button 94-1. The display content can be changed by using the attributes of the multidimensional care table (FIG. 3C) such as the number, care cost, and care cost per user as aggregation conditions.

  Also, as described in the population information display 91, by operating the switch button on the vertical axis and the switch button on the horizontal axis, the multi-dimensional business table output program 206 also outputs the data of each axis. It is possible to switch.

  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 a value. In addition, it is possible to additionally display the 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 Total 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 are linked to each multidimensional business table. Thus, when narrowing down is performed under the conditions 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 also be updated.

  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 having a high medical cost per patient in the medical information display 93, the school district 2 receives a medical examination from the medical examination information display 92 by viewing the information of the medical examination and nursing care crosswise. It is possible to grasp that the rate is low and use it for measures for preventive business. At the same time, it is also possible to grasp that the school district 2 has a high nursing care cost per user from the nursing care information display 94 and use it for reviewing the nursing care service.

  By using the cross-business analysis screen 90 as described above, it is possible to efficiently and effectively perform the business by analyzing the other business that cannot 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 business cross-sectional analysis screen 90 shown in FIG.

  The analysis menu 910 is displayed by classifying preset standard analysis processes into categories corresponding to each task in the multidimensional task table. The categories of the analysis menu corresponding to each task include the demographics 921 for analyzing the task information in the multidimensional population table 27, the medical examination 922 for analyzing the task information in the multidimensional medical examination table 28, and the categories of the multidimensional medical table 30. Medical insurance 923 for analyzing business information, care insurance 924 for analyzing business information in the multidimensional care table 29, and other analysis 925 are set in advance.

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

<Recursive analysis>
FIG. 7 illustrates a recursive analysis of a specific task such as population, medical examination, medical care, and nursing care, by fixing an analysis target and specifying analysis conditions again for the group (data to be analyzed). It is a flowchart which shows an example of an operation procedure.

  In this process, the analyst using the analysis screen display terminal 130 operates the analysis menu switching button 97 displayed on the cross-task analysis screen 90 in FIG. 6 to switch a predetermined sub menu from the analysis menu 910 in FIG. It is performed 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 of a recursive analysis screen.

  In the analysis condition setting step 802, the multidimensional business table output program 206 sets conditions for totalizing the business 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 multidimensional population table 27 selects regional information such as year, month, gender, age class, school district and daily living area. Is selected in the multidimensional care table 29, and the certification information such as the contents of the nursing care reception and the required nursing care service and the degree of nursing care required are selected in the multidimensional nursing care table 29. Can be selected as a condition based on medical information such as the contents of a medical claim.

  In the fixed target determination step 803, the multidimensional business 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 business table output program 206 receives, from the analysis screen display terminal 130, a total condition for analyzing the business information to be analyzed fixed in step 803 under another condition. The analyst clicks the analysis target narrowing / fixing button 96 to set conditions. In the analysis screen display terminal 130, the same attribute as that in step 802 is set as the aggregation condition.

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

  By the above-described processing, for example, in step 802, the data of the subject to be analyzed is fixed in step 803 after selecting “care-requiring person who needs nursing care 4 in 2015”, and in step 804, “2005” is selected on condition. To analyze business information.

  As a result, in the recursive analysis processing screen 810 (FIG. 8) output by the data analysis apparatus 101, what kind of state was the care-requiring person who was in need of nursing care 4 in 2015 as of 2005, The analysis can be performed recursively going back in time.

  In addition, the analysis target that was in a specific state in 2014 was the next year, and what kind of nursing service usage was in 2015, the data analysis device 101 also analyzed that the time was advanced with the target person (population) fixed. This makes it possible to combine the analysis with the analysis across a plurality of tasks, such as summarizing and displaying the status of other fields such as medical care and medical examination of the group to be analyzed.

  As described above, the multidimensional business table and the group management unit 31 enable a recursive analysis that could not be realized by the existing business system or data structure, and complement the analyst's IT skills to efficiently and effectively perform the analysis. 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 the map analysis screen 710 displaying the 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 multi-dimensional business table output program 206 executes the multi-dimensional business table output program 206 from among the business information of each multi-dimensional business table stored in the multi-dimensional business table storage unit 302 for the field selected by the operation of the analysis menu 910. The business information is acquired from the dimensional business table and a predetermined analysis is performed. Then, the multidimensional business table output program 206 reads the map information stored in the related information storage unit 304, generates the map information to be displayed on the map display unit 714 in FIG. Output 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 so, the process proceeds to step 703. .

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

  When it is desired to display the aggregation unit not in the whole area but in a more detailed unit such as each administrative district or each elementary school district, by selecting the analysis screen display terminal 130 with the map display content switching button 713 in FIG. The dimension business table output program 206 reads the recount result and the map information and outputs them to the map display unit 714.

  Further, in step 703, the multidimensional business table output program 206 selects information to be superimposed on the map display unit 714. By operating the graph superimposition button 712 in FIG. 11, the multidimensional business table output program 206 acquires the type information of the medical institution and the nursing care office stored in the related information storage unit 304, and displays the analysis screen. When the analyst of the terminal 130 selects the type information to be analyzed in a superimposed manner, the other information 715 indicating the location of the medical institution or the nursing care establishment can be output on the aggregation 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, it is possible to display the map information in combination with the analysis result. For example, in April 2014, a medical institution with diabetes was used as a condition for analysis, and the number of diabetic patients in each district could be grasped in detail on the map display section 714, and the status of disease prevention in the region and the evaluation of efforts were evaluated. Can be used.

  In addition, the multidimensional business table output program 206 superimposes and displays the location of medical institutions and nursing care establishments on the map display unit 714, so that the actual situation such as the fulfillment status of medical facilities for diabetes control can be grasped. It can be used.

  In this way, the simultaneous analysis function that combines the multidimensional business table and related information such as map information and facility information complements the analyst's work experience, intuition, and IT skills that could not be realized with the existing business system. And efficient and effective regional analysis can be conducted.

<Group comparison analysis>
FIG. 12 is a flowchart illustrating an example of a process of specifying a plurality of independent groups (data groups) in the multidimensional business table and simultaneously analyzing the groups. 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 illustrating an example of the group comparison screen 821 displaying the result of the group comparison analysis process.

  First, in step 811, the multidimensional business table output program 206 reads information of the multidimensional business table of the field selected by the analysis menu 910 from the business information of the multidimensional business table storage unit 302, and The tabulation content is generated in the designated display form (expression axis) such as a graph or a table in the one-group display unit 819, and output to the analysis screen display terminal 130.

  Next, in step 812, the multidimensional operation table output program 206 sets the analysis condition of the first group to be analyzed by the analyst of the analysis screen display terminal 130 by the analysis target narrowing / fixing button 822 shown in FIG. Is clicked, the user is allowed to select from the attribute information of the multidimensional business table displayed.

  When receiving the operation of the switch button 817 on the vertical axis and the switch button 818 on the horizontal axis from the analysis screen display terminal 130, the multidimensional business table output program 206 outputs the graph or table of the group comparison screen 821 on the horizontal or vertical axis. To change the conditions.

  In step 813 in response to the condition change, the multidimensional business table output program 206 executes the multidimensional business table storage program 303 of the group storage unit 303 and the multidimensional business table storage unit 302 of the multidimensional business table storage unit 302 updated to the specified analysis conditions. Perform re-aggregation using table linkage. Then, the multidimensional business table output program 206 updates the contents of the first group display unit 819 with the result of the recount.

  Next, in step 814, the multidimensional business table output program 206 operates the analysis target narrowing / fixing button 822 to change the condition of the second group to be compared, as in step 812. Allows you to select analysis conditions for the population.

  Then, the multidimensional business table output program 206 recounts using the cooperation of the group management unit 31 of the group storage unit 303 and the multidimensional business table of the multidimensional business table storage unit 302 updated to the specified analysis condition. Is carried out. The multidimensional operation table output program 206 updates the contents of the second group display unit 820 with the result of the recount.

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

  As described above, by operating various buttons on the group comparison screen 821, analysis results of a plurality of groups (data groups) can be compared and displayed. For example, assuming that a patient who answered that he / she smoked in the 2014 medical examination consultation table is a group A, and that a person who answered that he / she does not smoke in the same 2014 medical examination visitor is a group B, the medical expenses per person and the change The comparison between groups can be referred to, and a statistically significant difference with respect to the population can be confirmed at a time.

  In this way, the multidimensional business table, the group management unit 31, and the comparison and test 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, and are efficient and efficient. Effective comparative analysis can be performed.

<Summary>
As described above, the data analysis device 101 generates a group axis from data of business systems in a plurality of fields such as resident information, medical insurance information, nursing care insurance information, and medical checkup information, thereby creating each multidimensional business table. Can work together. In each multidimensional business table, by generating a group axis, a time axis, and a business axis, respectively, it is possible to link business information (business axis) between different business systems.

  This allows multidimensional data analysis under desired conditions across business systems. For example, medical attributes, nursing costs, the number of patients, and the trends and breakdowns of the number of various service users can be ascertained based on various attributes of residents such as each region and each year. As a result, it is possible to understand the excess and deficiency of resources such as medical facilities, nursing homes, and professionals, which can be the target of the residents to be analyzed, and preventable diseases, share priority issues for each region with relevant parties, Lean and lean business decisions and budget allocation can be performed. As a result, it is possible to suppress increases in medical expenses and nursing care expenses and to maintain and promote the health of residents.

  In addition, the data analysis device 101 can find a problematic date for a certain group on a recurrent time axis in the future or the past. Alternatively, for a given group, a problematic area can be found along a detailed regional axis such as an elementary school district or a self-governing association district. Alternatively, multidimensional analysis can be performed by combining the business axis, the time axis, and the regional axis. In addition, outsourcing costs for data processing and analysis can be reduced.

  In addition, the data analysis device 101 can grasp trends and breakdowns of medical expenses and nursing expenses, the number of patients, and the number of various service users based on various attributes of residents, such as regions and years. In this way, we can grasp the excess and deficiency of resources such as medical facilities, nursing homes, and professionals that can be used as well as preventable diseases, share regional priorities with relevant stakeholders, and make timely and efficient business decisions. And budget allocation.

  In addition, the data of the multi-dimensional business table is combined with non-insurance resident 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 further integrated administrative management such as health measures from a young age and for studying measures. For example, a multidimensional business table can be generated from a plurality of tables including business information on residents managed by the government in place of the health and welfare of residents, and first business information managed by the government (such as tax on taxes other than health and welfare) can be generated. Information) as the first resident information table, the second business information (information on education of residents) managed by the government as the second resident information table, and the first and second resident information tables as described above. The first and second multidimensional business tables can be generated by complementing with 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 of 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 business to data in the field of health and welfare.

  Further, a country name, a prefectural name, or a municipal name may be added to the regional information, and may be added to the condition of the total display. Furthermore, public and private data such as the history of tax payment and education of residents, the history of disasters and crimes for each address, the location of disaster countermeasures facilities and private business services, and the number of various professionals may be added.

  Further, in the above-described embodiment, an example is described in which a plurality of multidimensional business tables are linked by using a personal unique key as the group axis 421 of the group management unit 31. However, information (data item or field) used for the group axis 421 is used. Name) is not limited to information that uniquely identifies an individual. The information used for the group axis 421 may be, for example, a data item capable of mutually identifying or cooperating information among a plurality of multidimensional business tables.

  Information constituting the group axis 421 of the group management unit 31 is not limited to the same data item among a plurality of multidimensional business tables. The group axis 421 can link a multidimensional business 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 the multidimensional care table. 29, a care certification number may be used, and the multidimensional medical examination table 28 may use a pension number or a personal number.

  The data items constituting the group axis 421 of the group management unit 31 can be changed as appropriate according to the content of the analysis. For example, the area information (area axis) of each multidimensional business table may be treated as a group axis to perform the analysis processing on the area.

  Note that the present invention is not limited to the above-described embodiment, and includes various modifications. For example, the above-described embodiments have been described in detail in order to explain the present invention in an easy-to-understand manner, and are not necessarily limited to those having all the configurations described above. Further, a part of the configuration of one embodiment can be replaced with the configuration of another embodiment, and the configuration of one embodiment can be added to the configuration of another embodiment. In addition, for a part of the configuration of each embodiment, addition, deletion, or replacement of another configuration can be applied alone or in combination.

  In addition, the above-described respective configurations, functions, processing units, processing buttons, and the like may be partially or entirely realized by hardware, for example, by designing an integrated circuit. In addition, the above-described configurations, functions, and the like may be implemented by software by a processor interpreting and executing a program that implements each function. Information such as a program, a table, and a file 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.

  In addition, control lines and information lines are shown as necessary for the description, and do not necessarily indicate all control lines and information lines on a product. In fact, it can be considered that almost all 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 Arithmetic 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 (8)

A data analysis device having a processor and a memory to analyze data on health and welfare of residents,
The processor stores a resident basic information table including a personal number capable of identifying the resident, a medical insurance table including information on the medical treatment of the resident and a personal number capable of specifying the individual, information on the care of the resident, and the individual. The nursing insurance table including the identifiable personal number, the information on the health check of the inhabitants and the medical examination table including the individual number capable of identifying the individual are read, and the inhabitants basic information table of the inhabitants having the same personal number is read. Group management information by giving personal unique information that uniquely associates the entry of the medical insurance table, the entry of the nursing insurance table, and the entry of the medical examination table ,
The processor acquires personal information on the individual of the resident from the resident basic information table, regional information on an address, and time-series demographic information to generate a multidimensional population table,
The processor, from the medical insurance table, obtains personal information on the individual of the inhabitant, regional information on the address, and medical service information on time-series medical care to generate a multidimensional medical table,
The processor obtains a multidimensional care table by acquiring personal information on the individual of the resident from the care insurance table, regional information on an address, and care service information on chronological care,
The processor, from the medical checkup table, obtains personal information on the individual of the inhabitant, regional information on the address, and medical checkup operation information on a time-series medical checkup to generate a multidimensional medical checkup table,
The processor receives the analysis condition, and extracts data corresponding to the analysis condition from any of the multidimensional medical table, the multidimensional care table, and the multidimensional medical examination table designated by the analysis condition,
The processor acquires personal unique information corresponding to the extracted data from the group management information, and stores information associated with the analysis conditions in the multidimensional population table, the multidimensional medical table, the multidimensional care table, and the A data analysis device for extracting data from a three-dimensional medical examination table . The data analyzer according to claim 1,
The data analysis device, wherein the processor complements the medical service information related to the time-series medical care, the care service information related to the time-series care, and the medical checkup information related to the time-series medical checkup at a predetermined cycle. . The data analyzer according to claim 1,
The data analyzer according to claim 1, wherein the processor reads the map information, and outputs the map information in association with the map information corresponding to the regional information included in the extracted analysis result . The data analyzer according to claim 1,
The group management information has information holding a population of the result of the analysis,
The processor receives a first analysis condition, sets data of a 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 data corresponding to the population, and analyzes the result analyzed under the first analysis condition. A data analyzer for comparing results analyzed under a second analysis condition . A computer having a processor and a memory for analyzing data on the health and welfare of residents,
  A resident basic information table including a personal number capable of identifying the inhabitants, a medical insurance table including information on the medical care of the inhabitants and a personal number capable of identifying the individual, information on the care of the inhabitants and an individual capable of identifying the individual The health insurance table including the numbers and the medical examination table including the information on the health check of the inhabitants and the personal number capable of identifying the individual are read, and the entry of the inhabitants basic information table of the inhabitants having the same personal number and the medical A first step of generating group management information by adding personal unique information that uniquely associates an entry in the insurance table, an entry in the nursing care insurance table, and an entry in the medical examination table;
  A second step of obtaining personal information on the individual of the inhabitants, regional information on addresses, and time-series demographic information from the inhabitants basic information table to generate a multidimensional population table,
  A third step of generating a multidimensional medical table by acquiring personal information on the individual of the inhabitant, regional information on an address, and medical service information on time-series medical care from the medical insurance table,
  A fourth step of obtaining the multi-dimensional care table by acquiring the personal information on the individual of the inhabitant, the regional information on the address, and the care service information on the chronological care from the care insurance table,
  A fifth step of acquiring the personal information on the individual of the inhabitant, the regional information on the address, and the medical examination operation information on the time-series medical examination from the medical examination table to generate a multidimensional medical examination table;
  A sixth step of receiving analysis conditions and extracting data corresponding to the analysis conditions from any of the multidimensional medical table, the multidimensional care table, and the multidimensional medical examination table designated by the analysis conditions;
  Acquiring personal unique information corresponding to the extracted data from the group management information, and providing information associated with the analysis conditions with the multidimensional population table, the multidimensional medical table, the multidimensional care table, and the multidimensional medical examination table. A seventh step of extracting from
For causing the computer to execute.   The program according to claim 5, wherein
A program that complements the medical service information on the time-series medical care, the care service information on the time-series care, and the medical checkup information on the time-series medical checkup at predetermined intervals. The program according to claim 5, wherein
An eighth step of reading the map information and outputting the map information corresponding to the area information included in the extracted analysis result in association with the analysis result;
A program characterized by further including: The program according to claim 5, wherein
The group management information has information holding a population of the result of the analysis,
A ninth step of receiving the first analysis condition and setting data of a result of the analysis under the first analysis condition as a population in the group management information;
By receiving a second analysis condition and comparing the result of the analysis under the second analysis condition with the data corresponding to the population, the result of the analysis under the first analysis condition is compared with the result of the second analysis. A tenth step of comparing the results analyzed under the conditions,
A program characterized by further comprising: