Meteorological Data Warehousing and Analysis for Supporting Air Navigation
Data analysis of weather phenomena to either predict or control human imprint on the environment requires the collection of various forms of observational data ranging from historical and longitudinal to forecast. The objective of this research paper is the development of a data warehouse (DW) based...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
MDPI AG
2022-10-01
|
| Series: | Informatics |
| Subjects: | |
| Online Access: | https://www.mdpi.com/2227-9709/9/4/78 |
| _version_ | 1797457127511425024 |
|---|---|
| author | Georgia Garani Dionysios Papadatos Sotiris Kotsiantis Vassilios S. Verykios |
| author_facet | Georgia Garani Dionysios Papadatos Sotiris Kotsiantis Vassilios S. Verykios |
| author_sort | Georgia Garani |
| collection | DOAJ |
| description | Data analysis of weather phenomena to either predict or control human imprint on the environment requires the collection of various forms of observational data ranging from historical and longitudinal to forecast. The objective of this research paper is the development of a data warehouse (DW) based on a new hybrid logical schema, concerning the assimilation and maintenance of historical meteorological data from all operating airports in Greece, along with data in the Greek Flight Information Region related to flight delays and cancellations. SQL is used for querying these data and makes them easily accessible and manageable. The data from the DW are collected and used as training data for the induction of predictive models. In this study, the prediction problem is cast as a classification task, and different decision tree induction techniques are applied to build accurate models that allow flexible scheduling and planning for the minimization of waiting time and inconvenience of passengers. |
| first_indexed | 2024-03-09T16:17:43Z |
| format | Article |
| id | doaj.art-65f305c4da48436e8a3961c440a3aaf6 |
| institution | Directory Open Access Journal |
| issn | 2227-9709 |
| language | English |
| last_indexed | 2024-03-09T16:17:43Z |
| publishDate | 2022-10-01 |
| publisher | MDPI AG |
| record_format | Article |
| series | Informatics |
| spelling | doaj.art-65f305c4da48436e8a3961c440a3aaf62023-11-24T15:36:35ZengMDPI AGInformatics2227-97092022-10-01947810.3390/informatics9040078Meteorological Data Warehousing and Analysis for Supporting Air NavigationGeorgia Garani0Dionysios Papadatos1Sotiris Kotsiantis2Vassilios S. Verykios3Department of Digital Systems, University of Thessaly, 41500 Larisa, GreeceSchool of Science and Technology, Hellenic Open University, 26335 Patras, GreeceDepartment of Mathematics, University of Patras, 26504 Patras, GreeceSchool of Science and Technology, Hellenic Open University, 26335 Patras, GreeceData analysis of weather phenomena to either predict or control human imprint on the environment requires the collection of various forms of observational data ranging from historical and longitudinal to forecast. The objective of this research paper is the development of a data warehouse (DW) based on a new hybrid logical schema, concerning the assimilation and maintenance of historical meteorological data from all operating airports in Greece, along with data in the Greek Flight Information Region related to flight delays and cancellations. SQL is used for querying these data and makes them easily accessible and manageable. The data from the DW are collected and used as training data for the induction of predictive models. In this study, the prediction problem is cast as a classification task, and different decision tree induction techniques are applied to build accurate models that allow flexible scheduling and planning for the minimization of waiting time and inconvenience of passengers.https://www.mdpi.com/2227-9709/9/4/78decision support systemdata warehousedecision treefeature selection |
| spellingShingle | Georgia Garani Dionysios Papadatos Sotiris Kotsiantis Vassilios S. Verykios Meteorological Data Warehousing and Analysis for Supporting Air Navigation Informatics decision support system data warehouse decision tree feature selection |
| title | Meteorological Data Warehousing and Analysis for Supporting Air Navigation |
| title_full | Meteorological Data Warehousing and Analysis for Supporting Air Navigation |
| title_fullStr | Meteorological Data Warehousing and Analysis for Supporting Air Navigation |
| title_full_unstemmed | Meteorological Data Warehousing and Analysis for Supporting Air Navigation |
| title_short | Meteorological Data Warehousing and Analysis for Supporting Air Navigation |
| title_sort | meteorological data warehousing and analysis for supporting air navigation |
| topic | decision support system data warehouse decision tree feature selection |
| url | https://www.mdpi.com/2227-9709/9/4/78 |
| work_keys_str_mv | AT georgiagarani meteorologicaldatawarehousingandanalysisforsupportingairnavigation AT dionysiospapadatos meteorologicaldatawarehousingandanalysisforsupportingairnavigation AT sotiriskotsiantis meteorologicaldatawarehousingandanalysisforsupportingairnavigation AT vassiliossverykios meteorologicaldatawarehousingandanalysisforsupportingairnavigation |