表題番号:2016K-149 日付:2017/04/14
研究課題『情報処理実態調査』と『経済センサス活動調査』の名寄せを効率化する仕組みの研究
研究者所属(当時) 資格 氏名
(代表者) 商学学術院 大学院経営管理研究科 教授 平野 雅章
研究成果概要

The applicant was using two governmental data bases, ‘Current Status of Information Processing’ survey by METI and ‘Economic Census’ by the MIAC for his research.  As the data structure of these databases, as well as their field names are not consistent, collating firm records in these two databases were a time-consuming process.  Due to their confidentiality, it was not possible to outsource recompilation, involving some 500 Excel tables, forcing the applicant to do the work himself manually.  This project aimed at automating the process of recompilation, or at least simplifying the manual recompilation.  The main difficulty was that the codes allocated to sample firms were totally different between the two databases.  Using the firm name was problematic as there were number of firms with the same names.  Combining the firm name and the address was not satisfactory either because the way address was written was not unique, requiring human judgement.  Overall, efficiency gain of about 50% was achieved in term of the process time, by improving the manual process with some automation.  The summary of the project and its result and discussions are planned to be reported at the September meeting of JASMIN.