MODELING OF AIR TRAFFIC CONTROL (ATC) DASHBOARD USING REAL TIME BUSINESS INTELLIGENCE
Keywords:
Modeling ATC, Dashboard Using Real Time, Business Intelligence
Abstract
Air Traffic Control (ATC) started in 1922, Indonesia Flight system around 1980, The rapid development of development is a company MITRE partnership network. Unfortunately, ATC Dashboard is a research done in order to implement a dashboard system that can help ATC officers Aziza and ATC Chief in making decisions, especially in arranging the landing aircraft based on the information on the ATC Dashboard. The ATC system now is able to create an estimate time of aircraft to enter the initial gate of arrival in the air, but only one aircraft data is displayed in the ATC system so it takes time to apply to all aircraft. This paper, proposes a solution ATC Dashboard with Real-time Business Intelligence is a function generated from ETL (extract, transform and loading) process is performed using the Change Data Capture (CDC) approach to change data over a certain period so the data can be moved in real-time on ATC Server. The aim this study is to provide the acceptable ATC Dashboard quality that can be used by the ATC officer and ATC Chief in order to help them making decisions, and hopefully, this can be example for other airports in arranging landing aircrafts. This research contribution in providing real-time information on Management Traffic Controller (MTC) Aircraft, especially real-time BI using Kimball to make information ATC officer and chief.
References
[1]. Blaga N. Iordanova. (2005). Business Intelligence In a Global Air Traffic, Management via Intelligence Operational Decision Support, Retrieved from : http://laga@computer.org
[2] Blaga N. Iordanova. (2005). Business Intelligence In a Global Air Traffic, Management via Intelligence Operational Decision Support, Retrieved from : http://laga@computer.org
[3] Chipo Mutongi. (2016). IOSR Journal of Business and Management (IOSR-JBM) e-ISSN: 2278-487X, p-ISSN: 2319-7668. Volume 18, Issue 7 .Ver. II (July 2016), PP 66-71
Retrieved from : http://www.iosrjournals.org/iosr-jbm/papers/Vol18-issue7/Version-2/J1807026671.pdf, DOI: 10.9790/487X-1807.
[4] Cyril Allignol, Nicalas Barnier, Piere Flener, Justin Pearson. (2012). “Constrain Programming for Air Traffic Management : A Survey in Memory of Pacal Brisset”, The Knowledge Engineering Review, Vol. 00:0, 1–2. c2012, Cambridge University Press DOI: 10.1017/S000000000000000 Printed in the United Kingdom, retrieved from : https://hal- enac.archives-ouvertes.fr/hal-00934670/document.
[5] Darudiato, Suparto. (2010). Design Data Warehouse Perancangan penjualan untuk mendukung kebutuhan informasi Ekstekutif Cemerlang, Seminar Nasional informatika 2010 (semnasIF 2010) ISSN: 1979-2328UPN ”Veteran” Yogyakarta,http://repository.upnyk.ac.id/36/1/E- 43_PERANCANGAN_DATA_WAREHOUSE_PENJUALAN_UNTUK_MENDUKUNG_ KEBUTUHAN_INFORMASI_EKSEKUTIF_CEMERLANG.pdf.
[6] Eurocontrol, “Challanges of growth 2013: Summaryreport”, http://www.eurocontrol.int/articles/challenges-growth
[7] Joonatan Piela, (2017). Key Performa Indikator Analysis and Dashboard Vizualization in A Logistics Company, School of Business and Management Industrial Engineering and Management, Master’s Thesis LAPPEENRANTA UNIVERSITY OFTECHNOLOGY.Retrieved from : http://ojs.amikom.ac.id/index.php/dasi/article/view/61
[8] J.A.D. Atkin, E.K. Burke and S. Ravizza, (2011) “A more realistic approach for airport ground movement optimisation with stand holding”, Multidisciplinary International Scheduling Conference, August 2011, Phoenix,USA.
[9] Kai Engels, Ralf Heidger, Markus Wagner, (2008), ATC over the World Wide Web, a case study and prototypical implementation, DFS Deutsche Flugsicherung GmbH, SH/T, Systemhaus, Am DFS Campus 7; 63225 Langen, Germany, Date of Conference: 3-5 Sept. 2008, Date Added to IEEE Xplore: 14 October 2008, Print ISBN: 978-88-903482-0-4, INSPEC Accession Number: 10355003, DOI:10.1109/TIWDC.2008.4649054, Retrieved from :https://ieeexplore.ieee.org/document/4649054/
[10] Kusnawi. (2011). Tinjauan Umum Metode Pendekatan Dashboard Pada Proses Business Intelligence. Open Journal System DASI Vol 12 No 2, STIMIK Amikom,Yogyakarta.
[11] Lilia Munoz,Jose-Norberto Mazon,Juan Trujillo, (2011), ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study Univ. de Alicante,Alicante,Spain. Retrieved from : https://ieeexplore.ieee.org/abstract/document/5893784/
[12] Muller, H.P and Maasdorp, C.H. (2011). Fifth IEEE International Conference on Research Challenges in Information Science Proceedings, The Data, Information, And Knowledge Hierarchy And Its Ability To Convince. (Short paper), Gosier, Guadeloupe, France, May 19- 21 2011. Retrieved from : http://ieeexplore.ieee.org/stamp/stamp.jsp?arnumber=6006875
[13] Satoru Inoue, Kazuhiko Yamazaki, Hajime Hirako dan Toshiya Sasaki, (2015). Applying Human Centered Design Process for Designing Air Traffic Control Interfaces, Proceedings, Part II, of the 4th International Conference on Design, User Experience, and Usability: Users and Interactions - Volume 9187, Pages 307 -316, Springer-Verlag New York, Inc. New York, NY, USA ©2015, table of contents ISBN: 978-3-319-20897-8 doi>10.1007/978-3-319-20898-5_30
[14] Tatjana Krstić Simić, Obrad Babić and Velibor Andrić. (2018). Influence of Airport Operations Management on Traffic Complexity and Efficiency. Division of Airports and Air Traffic Safety University of Belgrade, Faculty of Transport and Traffic Engineering Belgrade, Serbia t.krstic@sf.bg.ac.rs, o.babic@sf.bg.ac.rs,v.andric@sf.bg.ac.rs
[15] Turban, E., & Volonino, L. (2011). Information Technology for Management. Jhon Wiley & Sons, Inc. (Vol. 8). Retrieved from :http://doi.org/10.1017/CBO9781107415324.004
[16] Valentin R. Melnikov1, Valeria V. Krzhizhanovskaya1,2,3, Alexander V. Boukhanovsky4, Peter M.A. Sloot1,2,5. (2015). Data-driven modeling of transportation systems and traffic data analysis during a major power outage in the Netherlands, YSC 2015. 4th International
Young Scientists Conference on Computational Science, Volume 66, Pages 336–345, Procedia Computer Science, Elseiver.
[17] WANG Jian-bo FAN Chong-jun FU Hui-gang. (2012), Discussion on Airport Business Intelligence System Architecture WANG Jian-bo FAN Chong-jun FU Hui-gangBusiness School University of Shanghai for Science and Technology Shanghai 200093, P. R.China.
International Journal of Business and Social Science Vol. 3 No. 13; July 2012
[18] Xiaopeng Ji, Jing Hang, Ran Yang. (2014). An online method for the real-time aircraft arrival sequencing and scheduling problem, Proceeding of the 11th World Congress on Intelligent Control and Automation, June 29 2014-July 42014.https://ieeexplore.ieee.org/document/7052865/
[19] Zsolt Sándor. (2017), Functional Modelling of the Air Traffic Conttol and the Integration Perspectives of the Integrated Services, Periodica Polytechnica, TransportationEngineering, Vol : 45 No : 3, pp. 107-118, Retrieved from : https://doi.org/10.3311/PPtr.9270.
Adhitama, Stephanie. (2014). Designing Real-Time Business Intelligence For Subjects Academic Activities at Universities Using Change Data Capture. Jurnal Buana Informatika Volume 5 Nomor 2 Juli 2014. Retieved from : DOI:http://dx.doi.org/10.24002/jbi.v5i2.354
Authoni, A. Y. (2014). Dashboard capability prototype to Assist Data Analysis of College Self-election based on Key Performance Indicators (KPI) Case Study : PT X Prosiding Seminar Nasional Manajemen Teknologi XXI, (2011), 1–9.
Blaga N. Iordanova. (2005). Business Intelligence In a Global Air Traffic, Management via Intelligence Operational Decision Support, Retrieved from : http://laga@computer.org
Darudiato, S. (2010). Design of Data warehouse Sales to Support the Executive Detailed Information Needs Skin Care. SemnasIF, 350–359.
Fang Jing & Yan Ran, Ji Xiaopeng. (2014). An Online Method for the Real-time Aircraft Arrival Sequencing and Scheduling Problem, IEEE Xplore Digital Library, Proceeding of the 11th World Congress on Intelligent Control and Automation J, June 29 2014 – July 4 2014. Retrieved from : http://ieeexplore.ieee.org/document/7052865/..
Kusnawi. (2011). Overview of Dashboard Approach Methods In the Business Intelligence Process. Jurnal Dasi, 12(2). http://download.portalgaruda.org/article.php?article=91928&val=5002
Mujiasih, Subekti. (2012). Application of Business intelligence for Marine Weather Analyzing
and Forecasting. Jurnal Meteorologi dan Geofisika VOL. 14 NO. 2 Tahun 2013 : 87-98
Nurhasni, F., & Rina, T. (2003). Extract, Transform, Load (ETL) For Academic Data warehouse on Institute of Agriculture Bogor Using Kettle. Kolokium.
Turban, E., & Volonino, L. (2011). Information Technology for Management. Jhon Wiley & Sons, Inc. (Vol. 8). Retrieved from : http://doi.org/10.1017/CBO9781107415324.004
[2] Blaga N. Iordanova. (2005). Business Intelligence In a Global Air Traffic, Management via Intelligence Operational Decision Support, Retrieved from : http://laga@computer.org
[3] Chipo Mutongi. (2016). IOSR Journal of Business and Management (IOSR-JBM) e-ISSN: 2278-487X, p-ISSN: 2319-7668. Volume 18, Issue 7 .Ver. II (July 2016), PP 66-71
Retrieved from : http://www.iosrjournals.org/iosr-jbm/papers/Vol18-issue7/Version-2/J1807026671.pdf, DOI: 10.9790/487X-1807.
[4] Cyril Allignol, Nicalas Barnier, Piere Flener, Justin Pearson. (2012). “Constrain Programming for Air Traffic Management : A Survey in Memory of Pacal Brisset”, The Knowledge Engineering Review, Vol. 00:0, 1–2. c2012, Cambridge University Press DOI: 10.1017/S000000000000000 Printed in the United Kingdom, retrieved from : https://hal- enac.archives-ouvertes.fr/hal-00934670/document.
[5] Darudiato, Suparto. (2010). Design Data Warehouse Perancangan penjualan untuk mendukung kebutuhan informasi Ekstekutif Cemerlang, Seminar Nasional informatika 2010 (semnasIF 2010) ISSN: 1979-2328UPN ”Veteran” Yogyakarta,http://repository.upnyk.ac.id/36/1/E- 43_PERANCANGAN_DATA_WAREHOUSE_PENJUALAN_UNTUK_MENDUKUNG_ KEBUTUHAN_INFORMASI_EKSEKUTIF_CEMERLANG.pdf.
[6] Eurocontrol, “Challanges of growth 2013: Summaryreport”, http://www.eurocontrol.int/articles/challenges-growth
[7] Joonatan Piela, (2017). Key Performa Indikator Analysis and Dashboard Vizualization in A Logistics Company, School of Business and Management Industrial Engineering and Management, Master’s Thesis LAPPEENRANTA UNIVERSITY OFTECHNOLOGY.Retrieved from : http://ojs.amikom.ac.id/index.php/dasi/article/view/61
[8] J.A.D. Atkin, E.K. Burke and S. Ravizza, (2011) “A more realistic approach for airport ground movement optimisation with stand holding”, Multidisciplinary International Scheduling Conference, August 2011, Phoenix,USA.
[9] Kai Engels, Ralf Heidger, Markus Wagner, (2008), ATC over the World Wide Web, a case study and prototypical implementation, DFS Deutsche Flugsicherung GmbH, SH/T, Systemhaus, Am DFS Campus 7; 63225 Langen, Germany, Date of Conference: 3-5 Sept. 2008, Date Added to IEEE Xplore: 14 October 2008, Print ISBN: 978-88-903482-0-4, INSPEC Accession Number: 10355003, DOI:10.1109/TIWDC.2008.4649054, Retrieved from :https://ieeexplore.ieee.org/document/4649054/
[10] Kusnawi. (2011). Tinjauan Umum Metode Pendekatan Dashboard Pada Proses Business Intelligence. Open Journal System DASI Vol 12 No 2, STIMIK Amikom,Yogyakarta.
[11] Lilia Munoz,Jose-Norberto Mazon,Juan Trujillo, (2011), ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study Univ. de Alicante,Alicante,Spain. Retrieved from : https://ieeexplore.ieee.org/abstract/document/5893784/
[12] Muller, H.P and Maasdorp, C.H. (2011). Fifth IEEE International Conference on Research Challenges in Information Science Proceedings, The Data, Information, And Knowledge Hierarchy And Its Ability To Convince. (Short paper), Gosier, Guadeloupe, France, May 19- 21 2011. Retrieved from : http://ieeexplore.ieee.org/stamp/stamp.jsp?arnumber=6006875
[13] Satoru Inoue, Kazuhiko Yamazaki, Hajime Hirako dan Toshiya Sasaki, (2015). Applying Human Centered Design Process for Designing Air Traffic Control Interfaces, Proceedings, Part II, of the 4th International Conference on Design, User Experience, and Usability: Users and Interactions - Volume 9187, Pages 307 -316, Springer-Verlag New York, Inc. New York, NY, USA ©2015, table of contents ISBN: 978-3-319-20897-8 doi>10.1007/978-3-319-20898-5_30
[14] Tatjana Krstić Simić, Obrad Babić and Velibor Andrić. (2018). Influence of Airport Operations Management on Traffic Complexity and Efficiency. Division of Airports and Air Traffic Safety University of Belgrade, Faculty of Transport and Traffic Engineering Belgrade, Serbia t.krstic@sf.bg.ac.rs, o.babic@sf.bg.ac.rs,v.andric@sf.bg.ac.rs
[15] Turban, E., & Volonino, L. (2011). Information Technology for Management. Jhon Wiley & Sons, Inc. (Vol. 8). Retrieved from :http://doi.org/10.1017/CBO9781107415324.004
[16] Valentin R. Melnikov1, Valeria V. Krzhizhanovskaya1,2,3, Alexander V. Boukhanovsky4, Peter M.A. Sloot1,2,5. (2015). Data-driven modeling of transportation systems and traffic data analysis during a major power outage in the Netherlands, YSC 2015. 4th International
Young Scientists Conference on Computational Science, Volume 66, Pages 336–345, Procedia Computer Science, Elseiver.
[17] WANG Jian-bo FAN Chong-jun FU Hui-gang. (2012), Discussion on Airport Business Intelligence System Architecture WANG Jian-bo FAN Chong-jun FU Hui-gangBusiness School University of Shanghai for Science and Technology Shanghai 200093, P. R.China.
International Journal of Business and Social Science Vol. 3 No. 13; July 2012
[18] Xiaopeng Ji, Jing Hang, Ran Yang. (2014). An online method for the real-time aircraft arrival sequencing and scheduling problem, Proceeding of the 11th World Congress on Intelligent Control and Automation, June 29 2014-July 42014.https://ieeexplore.ieee.org/document/7052865/
[19] Zsolt Sándor. (2017), Functional Modelling of the Air Traffic Conttol and the Integration Perspectives of the Integrated Services, Periodica Polytechnica, TransportationEngineering, Vol : 45 No : 3, pp. 107-118, Retrieved from : https://doi.org/10.3311/PPtr.9270.
Adhitama, Stephanie. (2014). Designing Real-Time Business Intelligence For Subjects Academic Activities at Universities Using Change Data Capture. Jurnal Buana Informatika Volume 5 Nomor 2 Juli 2014. Retieved from : DOI:http://dx.doi.org/10.24002/jbi.v5i2.354
Authoni, A. Y. (2014). Dashboard capability prototype to Assist Data Analysis of College Self-election based on Key Performance Indicators (KPI) Case Study : PT X Prosiding Seminar Nasional Manajemen Teknologi XXI, (2011), 1–9.
Blaga N. Iordanova. (2005). Business Intelligence In a Global Air Traffic, Management via Intelligence Operational Decision Support, Retrieved from : http://laga@computer.org
Darudiato, S. (2010). Design of Data warehouse Sales to Support the Executive Detailed Information Needs Skin Care. SemnasIF, 350–359.
Fang Jing & Yan Ran, Ji Xiaopeng. (2014). An Online Method for the Real-time Aircraft Arrival Sequencing and Scheduling Problem, IEEE Xplore Digital Library, Proceeding of the 11th World Congress on Intelligent Control and Automation J, June 29 2014 – July 4 2014. Retrieved from : http://ieeexplore.ieee.org/document/7052865/..
Kusnawi. (2011). Overview of Dashboard Approach Methods In the Business Intelligence Process. Jurnal Dasi, 12(2). http://download.portalgaruda.org/article.php?article=91928&val=5002
Mujiasih, Subekti. (2012). Application of Business intelligence for Marine Weather Analyzing
and Forecasting. Jurnal Meteorologi dan Geofisika VOL. 14 NO. 2 Tahun 2013 : 87-98
Nurhasni, F., & Rina, T. (2003). Extract, Transform, Load (ETL) For Academic Data warehouse on Institute of Agriculture Bogor Using Kettle. Kolokium.
Turban, E., & Volonino, L. (2011). Information Technology for Management. Jhon Wiley & Sons, Inc. (Vol. 8). Retrieved from : http://doi.org/10.1017/CBO9781107415324.004
Published
2019-11-23
How to Cite
Sutarman, D., Joko Dewanto, I., Abimany, Y., & Azizah, N. (2019). MODELING OF AIR TRAFFIC CONTROL (ATC) DASHBOARD USING REAL TIME BUSINESS INTELLIGENCE. IJO -International Journal of Business Management ( ISSN 2811-2504 ), 2(11), 01-16. Retrieved from http://ijojournals.com/index.php/bm/article/view/253
Section
Articles
Copyright (c) 2019 IJO -International Journal of Business Management
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Author(s) and co-author(s) jointly and severally represent and warrant that the Article is original with the author(s) and does not infringe any copyright or violate any other right of any third parties and that the Article has not been published elsewhere. Author(s) agree to the terms that the IJO Journal will have the full right to remove the published article on any misconduct found in the published article.
