Research and Implementation of QAR Data Warehouse

被引：0
|
作者：
Wang Hong [1 ,2 ]
Huan Xiuxia [1 ]
Wang Hongwei [1 ]
Changbing Jiang [1 ]
Yang Peng
机构：
[1] Civil Aviat Univ China, Sch Comp Sci & Technol, Tianjin 300300, Peoples R China
[2] Tianjin Univ, Sch Management, Tianjin 300072, Peoples R China
来源：
2008 INTERNATIONAL SYMPOSIUM ON INTELLIGENT INFORMATION TECHNOLOGY APPLICATION, VOL III, PROCEEDINGS | 2008年
基金：
中国国家自然科学基金;
关键词：
D O I：
10.1109/IITA.2008.533
中图分类号：
TP18 [人工智能理论];
学科分类号：
081104 ; 0812 ; 0835 ; 1405 ;
摘要：
Aiming at the practical questions of airline companies, such as the platform used to analyze the QAR data is not unified, lots of missing values, duplicate records and noise data in decoded QAR data, which seriously affect the efficiency of analysis of the QAR data. Thus, in this paper we present to analyze the data by designing QAR data warehouse, describe how to define the QAR data subjects, put forward a star schema, propose a cleaning framework of data preprocessing based on subjects and introduce the cleaning methods that are appropriate to QAR data and design multidimensional model by ETL, implement the farther research on QAR data through analyzing exceed the limits, so this can improve flight character and factor of safety for airline companies.
引用
收藏
页码：156 / +
页数：2
相关论文
共 50 条
  • [1] An atomic approach to the design and implementation of a research data warehouse
    Visweswaran, Shyam
    McLay, Brian
    Cappella, Nickie
    Morris, Michele
    Milnes, John T.
    Reis, Steven E.
    Silverstein, Jonathan C.
    Becich, Michael J.
    JOURNAL OF THE AMERICAN MEDICAL INFORMATICS ASSOCIATION, 2022, 29 (04) : 601 - 608
  • [2] Research and implementation of data warehouse in stock exchange system
    Liu, Mingji
    Zhang, Xiaojing
    Liu, Hongjie
    Wang, Xiufeng
    Wang, Zhibao
    Jisuanji Gongcheng/Computer Engineering, 2000, 26 (02): : 47 - 49
  • [3] Research and implementation of data warehouse and data mining in decision support systems
    Wang, Bingqing
    Huai, Jinpeng
    Ruan Jian Xue Bao/Journal of Software, 1998, 9 (05): : 399 - 402
  • [4] Evaluation of Radiology Data Warehouse Implementation on Education, Research, and Quality Assurance
    Georgiana, Vina
    Kartawiguna, Daniel
    Indrajani
    2016 INTERNATIONAL CONFERENCE ON INFORMATION MANAGEMENT AND TECHNOLOGY (ICIMTECH), 2016, : 277 - 280
  • [5] Implementation and Case Study of a Clinical Research Data Warehouse in Radiation Oncology
    Qu, V.
    Wood, D. J.
    Henry, A. S.
    Brain, S.
    Noakes, C.
    Baniel, C. C.
    Frick, M. A.
    Buyyounouski, M.
    Bagshaw, H. P.
    Horst, K. C.
    Marquez, C. M.
    Vitzthum, L.
    Pollom, E.
    INTERNATIONAL JOURNAL OF RADIATION ONCOLOGY BIOLOGY PHYSICS, 2022, 114 (03): : E109 - E109
  • [6] Critical success factors for data warehouse implementation: A framework for analysis and research
    Hwang, MI
    INFORMATION TECHNOLOGY AND ORGANIZATIONS: TRENDS, ISSUES, CHALLENGES AND SOLUTIONS, VOLS 1 AND 2, 2003, : 195 - 196
  • [7] Modeling and implementation of data warehouse systems
    Rautenstrauch, C
    EFFECTIVE UTILIZATION AND MANAGEMENT OF EMERGING INFORMATION TECHNOLOGIES, 1998, : 325 - 333
  • [8] Data warehouse implementation with the SAS® system
    Brown, T
    PROCEEDINGS OF THE TWENTY-SECOND ANNUAL SAS USERS GROUP INTERNATIONAL CONFERENCE, 1997, : 611 - 621
  • [9] On the Research of Data Warehouse in Big Data
    Qin, Hai-fei
    Qian, Zhi-ming
    Zhao, Yong-chao
    2015 INTERNATIONAL CONFERENCE ON NETWORK AND INFORMATION SYSTEMS FOR COMPUTERS (ICNISC), 2015, : 354 - 357
  • [10] Design and implementation of a climatic data warehouse
    Velázquez-Alvarez, J
    Torres-Jiménez, J
    DATA MINING III, 2002, 6 : 407 - 416
12345