In Japan, since the Next Generation Medical Infrastructure Act regarding anonymized medical data contributing to R&D came into force in 2018, it is expected to exploit medical data for R&D. The Millennial Medical Record Project has been collected a large amount of standardized medical data of a number of hospitals stored in a database under the act. In order for users to widely exploit the medical data when carrying out trial-and-error, there is a difficulty of data access because of a highly secured management of non-anonymous medical data. To solve the data access problem, we develop a general statistical analytical system for executing a variety of statistical significance tests with statistical power analysis in an environment of trial-and-error for users' analyses without programming. In the analytical system, the front-end is a registration form as the input and the analysis results as the output on Microsoft Excel, and the back-end is based on Python, R and SQL. Although the fixed registration form covers limited application for the analysis, since the analysis results using the stored Millennial Medical Record data is provided in a short time without collecting the necessary data for the analysis, the exploitation of medical data could widely and rapidly promote by medical experts/researchers in the manner of trial-and-error. The developed system could apply to make protocols for clinical research and clinical trial, and the potential to discover real-world evidence could be increased.
Keywords: General statistical analytical system; Millennial Medical Record Project; Statistical power analysis; Statistical significance tests.