Novel Analytics Framework for Universal Healthcare Insurance Database

Medical insurance claims data is one of the most useful data sources that can offer a big-picture view of a nation-wide healthcare system. Form the viewpoint of medical policy planning, Japan’s Ministry of Health, Labour and Welfare has been continuously collecting claims data. However, claims data in Japan has an ordered nested tuple format, and a method for describing the logic to analyze this form in a simple and clear manner has not been established yet. In the present work, we construct a novel analytics framework based on previous analyses that we conducted with medical researchers and design a UI that facilitates the construction of the processing logic in a simple and clear manner. By showing the execution result of typical analyses of claim data, we demonstrate the effectiveness of the developed tool