Ran Ran, Jun Qi, Qiang Gao, Yubo Liu, Liang Bai, Xiaoqiang Liu
{"title":"Research on enterprise level cross domain integrated data inventory method based on DMAIC model","authors":"Ran Ran, Jun Qi, Qiang Gao, Yubo Liu, Liang Bai, Xiaoqiang Liu","doi":"10.1109/ECIE52353.2021.00066","DOIUrl":null,"url":null,"abstract":"When traditional inventory methods sort out the data, the data format is not standardized, which leads to the long query time of inventory data. To solve this problem, this paper proposes an enterprise level cross domain integrated database storage method based on DMAIC model. Through the collection of cross domain integrated data for filtering and integration, the data are transferred to the central database in turn, and the data warehouse is established. The core data in the collected data is identified by using DMAIC model, and the core data is summarized into the inventory range. Then, the relevant data with high similarity are matched, and labels and data catalog are made to provide support for data positioning and query. The results show that compared with the traditional method, the query time of inventory data is shortened by 0.57s.","PeriodicalId":219763,"journal":{"name":"2021 International Conference on Electronics, Circuits and Information Engineering (ECIE)","volume":"53 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-01-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2021 International Conference on Electronics, Circuits and Information Engineering (ECIE)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ECIE52353.2021.00066","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
When traditional inventory methods sort out the data, the data format is not standardized, which leads to the long query time of inventory data. To solve this problem, this paper proposes an enterprise level cross domain integrated database storage method based on DMAIC model. Through the collection of cross domain integrated data for filtering and integration, the data are transferred to the central database in turn, and the data warehouse is established. The core data in the collected data is identified by using DMAIC model, and the core data is summarized into the inventory range. Then, the relevant data with high similarity are matched, and labels and data catalog are made to provide support for data positioning and query. The results show that compared with the traditional method, the query time of inventory data is shortened by 0.57s.