• DocumentCode
    2875514
  • Title

    Implementation of Data Warehouse at Domestic Large Aeronautic Hub for Flight Information

  • Author

    Wang, Hong ; Lv, Xiaojie

  • Author_Institution
    Sch. of Comput. Sci. & Technol., Civil Aviation Univ. of China, Tianjin, China
  • fYear
    2009
  • fDate
    11-13 Dec. 2009
  • Firstpage
    1
  • Lastpage
    4
  • Abstract
    For the flight information at a large aeronautic hub, we utilized star-shaped structure, designed and created a data warehouse, obtained the data about flight delay for data warehouse from the original data through ETL process, completed the preprocessing and loading data, created OLAP data cube for slicing and drilling, provided a decision support for the airport management staff of flight operation. In the final statements, we created delay drill-down report by quarter.
  • Keywords
    data mining; data warehouses; OLAP data cube; airport management staff; data warehouse; decision support; flight delay; flight information; flight operation; large aeronautic hub; star-shaped structure; Aircraft; Airports; Computer science; Data analysis; Data mining; Data warehouses; Databases; Delay effects; Information analysis; Multidimensional systems;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computational Intelligence and Software Engineering, 2009. CiSE 2009. International Conference on
  • Conference_Location
    Wuhan
  • Print_ISBN
    978-1-4244-4507-3
  • Electronic_ISBN
    978-1-4244-4507-3
  • Type

    conf

  • DOI
    10.1109/CISE.2009.5366924
  • Filename
    5366924