空中交通管理信息数据库系统
|
摘要
国际民航组织鉴于在新航行系统的实施与发展过程中出现的问题和对未来航行系统的发展趋势提出了空中交通管理信息服务的自动化、一体化的要求。空中交通管理信息服务的自动化、一体化、网络化是全球趋势，也是未来我国航行空中交通管理信息系统建设的发展方向。
本文从数据库技术和数据库应用开发的角度对空中交通管理信息系统进行了研究，建立了空中交通管理信息系统的概念模型和空中交通管理信息数据库的数据模型。重点建立了空中交通管制系统的数据库概念结构，逻辑结构和物理结构，并进行了应用开发。对于空中交通管理系统中的航空公司数据库和机场数据库建立了概念结构和逻辑结构。本文采用Octree算法对于空中交通管理信息资源和其他空中交通信息建立了数据库数据模型。
本文应用面向对象的大型关系数据库产品Oracle9i建立了空中交通管理信息数据库的数据模型，将空中交通信息导入空中交通管理信息数据库，同时根据数据库应用开发的需要建立了应用开发视图。
本文在所建立的数据库基础之上应用面向对象的开发语言进行了数据库的应用开发，对我国的空中交通流量进行了模拟分析。该分析为解决空中交通流量问题提供了一种易于实行并有相当成效的解决方法，对于提高机场运营效率，减少飞机的空中等待，从而减少航空公司的运营成本等都有着重要的意义。
For solving the problems those will emerge from the implementation of the CNS, ICAO proposed the future development of the automation and one-system trend of the air transportation information system to all its members. The automation and one-system trend have been an international trend which is also very meaningful to the development of air transportation management in China.
The thesis made a research on air transportation information system from the point of view of the database. The thesis built a conceptual model of the air transportation information system and a datatype model of the air transportation information system database. The emphases were on the building of the conceptual structure, logical structure, physical structure and application development of the database of the air traffic control system. The conceptual structure and logical structure of the airline and the airport database were also built. The thesis got the advantage of the Octree algorithm to make a common indexing system of the air transportation information resources.
The thesis has implemented the datatype model of the air transportation information system database with the objected-oriented relational database Oracle9i using the structured query language, loaded the air transportation information into the database and built the view of the database considering the needs of the application.
Based on the built air transportation information database system, the writer has developed an application to analysis the air traffic flow of our country at the end of the thesis. The analysis provided a method of solving the congestion of the air transportation with considerable e ffectiveness and. an acceptable cost. The analysis were also meaningful to improve the efficiency of the airport, reduce the in-flight delay of the airplane and reduce the operational costs of the airline.
本文从数据库技术和数据库应用开发的角度对空中交通管理信息系统进行了研究，建立了空中交通管理信息系统的概念模型和空中交通管理信息数据库的数据模型。重点建立了空中交通管制系统的数据库概念结构，逻辑结构和物理结构，并进行了应用开发。对于空中交通管理系统中的航空公司数据库和机场数据库建立了概念结构和逻辑结构。本文采用Octree算法对于空中交通管理信息资源和其他空中交通信息建立了数据库数据模型。
本文应用面向对象的大型关系数据库产品Oracle9i建立了空中交通管理信息数据库的数据模型，将空中交通信息导入空中交通管理信息数据库，同时根据数据库应用开发的需要建立了应用开发视图。
本文在所建立的数据库基础之上应用面向对象的开发语言进行了数据库的应用开发，对我国的空中交通流量进行了模拟分析。该分析为解决空中交通流量问题提供了一种易于实行并有相当成效的解决方法，对于提高机场运营效率，减少飞机的空中等待，从而减少航空公司的运营成本等都有着重要的意义。
For solving the problems those will emerge from the implementation of the CNS, ICAO proposed the future development of the automation and one-system trend of the air transportation information system to all its members. The automation and one-system trend have been an international trend which is also very meaningful to the development of air transportation management in China.
The thesis made a research on air transportation information system from the point of view of the database. The thesis built a conceptual model of the air transportation information system and a datatype model of the air transportation information system database. The emphases were on the building of the conceptual structure, logical structure, physical structure and application development of the database of the air traffic control system. The conceptual structure and logical structure of the airline and the airport database were also built. The thesis got the advantage of the Octree algorithm to make a common indexing system of the air transportation information resources.
The thesis has implemented the datatype model of the air transportation information system database with the objected-oriented relational database Oracle9i using the structured query language, loaded the air transportation information into the database and built the view of the database considering the needs of the application.
Based on the built air transportation information database system, the writer has developed an application to analysis the air traffic flow of our country at the end of the thesis. The analysis provided a method of solving the congestion of the air transportation with considerable e ffectiveness and. an acceptable cost. The analysis were also meaningful to improve the efficiency of the airport, reduce the in-flight delay of the airplane and reduce the operational costs of the airline.
引文
[1] 《CNS/ATM SYSTEMS》 Rio de Janeiro, World Wide CNS/ATM System Implementation Conference, May 11-18 1998
[2] 《Agenda Item 12: Aeronautical information services and aeronautical charts (Annex 15-Aeronautical Information Service;Annex 4-Aeronautical Charts)》 ICAO, CAR/SAM/3-WP/45 27/07/99,Third Caribbean/South American Regional Air Navigation Meeting Buenos Aires, 5-15 October 1999
[3] 《NASA's Free Flight Air Traffic Management Research》, NASA Free Flight/DAG-ATM Workshop, May 22-24, 2000
[4] Speech by Jeff Hmara to the American Institute of Aeronautics and Astronautics Tuesday April 25, 2002
[5] 《European AIS Database-A major step towards a single sky for Europe》 http://www. frequentis.com
[6] 《中国民航信息系统建设“十五”计划和2010年远景规划》 民航总局
[7] 《A relational model of data for large shared data banks》, Codd EF. CACM,1970
[8] 《An Introuction to Database Systems》 C.J. Date. Seventh Edition. 机械工业出版社，2000
[9] 《数据库系统概论》萨师煊 高等教育出版社
[10] 《Object/Relational DBMSs: Trackbig the Next Great Wave》 (2nd edition). Michael Stonebraker and Paul Brown (with Dorothy Moore )San Francisco, Calif.: Morgan Kaufmann (1999)
[11] 《Data Base Systems》 Courant Computer Science Symposia Series 6. Englewood Cliffs, N.J. PrenticeHall (1972).
[12] 《Oracle9i Database Concepts》, Release 2(9.2), Part No. A96524-01, Michele Cyran, Oracle Corporation.
[13] 《The Common ATM Information State Space-A unified data management
system for the entire NAS resources based on an indexing system》 Ian Crook, Diana Liang, Zak Tibichte; ATM-2001
[14] 《Visual Modeling with Rational Rose 2002 and UML》 Terry Quatrani Addison Wesley
[15] 《Fundamentals of Database Systems》 Ramez Elmasri, 人民邮电出版社
[16] 《UML Distilled Second Edition A Brief Guide to the Standard Object Modeling》 (Second Edition) Martin Fowler, Kendall Scott; Addison Wesley.
[17] 《UML for Database Design》 Eric J. Naiburg, Robert A. Maksimchuk, Addison Wesley.
[18] 《UML Distilled Second Edition A Brief Guide to the Standard Object Modeling》 (Second Edition) Martin Fowler, Kendall Scott; Addison Wesley.
[19] 《UML for Database Design》 Eric J. Naiburg, Robert A. Maksimchuk, Addison Wesley.
[20] 《Oracle管理员手册》 Oracle Corporation
[21] 《数据库系统教程》 施伯乐 高等教育出版社
[22] 《Oracle9i Database Administrator's Guide》 Release 2(9.2), (March 2002, Part No. A96521-01), Ruth Baylis, Oracle Corporation.
[23] 《Oracle Enterprise Manager Administrator's Guide》, Release 9.2.0 Part No. A96670-01, Oracle Corporation.
[24] 《Oracle Enterprise Manager Configuration Guide》, Release 9.2.0.2, Part No. A96673-02, Oracle Corporation.
[25] 《Oracle Enterprise Manager Getting Started with the Oracle Management Pack for Oracle Applications》, Release 9.0.1
[26] 《Oracle9i SQL Reference》, Release 2(9.2), Part No. A96540-02, Diana Lorentz, Oracle Corporation.
[27] 《Oracle9i Database Utilities》, Release 2(9.2), Part No. A96652-01, Kathy Rich, Oracle Corporation
[28] 《Oracle Enterprise Manager Concepts Guide》, Release 9.2.0, Part No. A96674-01, Oracle Corporation. Part No. A88720-01, Jacqueline Gosselin,Oracle Corporation.
[29] 《Database Programming with JDBC and Java》, Second Edition George.Reese O'Reilly & Associates, Inc.
[30] 《Borland(?) JBuilderTM Developer's Guide》 Michael Landy, Saleem Siddiqui, Jeff Swisher Sams
[31] 《Oracle9i JDBC Developer' s Guide and Reference》, Release 2 (9.2) Part No. A96654-01, Elizabeth Hanes Perry, Mike Sanko, Brian Wright, Thomas Pfaeffle, Oracle Corporation.
[32] 《JavaTM Examples in a Nutshell》, Second Edition David Flanagan O'Reilly & Associates, Inc.
[33] 《JavaTM in a Nutshell》, Fourth Edition David Flanagan O'Reilly & Associates, Inc.
[34] 《空中交通管制系统与计算机网络》 宋福臣 中国民航出版社
[2] 《Agenda Item 12: Aeronautical information services and aeronautical charts (Annex 15-Aeronautical Information Service;Annex 4-Aeronautical Charts)》 ICAO, CAR/SAM/3-WP/45 27/07/99,Third Caribbean/South American Regional Air Navigation Meeting Buenos Aires, 5-15 October 1999
[3] 《NASA's Free Flight Air Traffic Management Research》, NASA Free Flight/DAG-ATM Workshop, May 22-24, 2000
[4] Speech by Jeff Hmara to the American Institute of Aeronautics and Astronautics Tuesday April 25, 2002
[5] 《European AIS Database-A major step towards a single sky for Europe》 http://www. frequentis.com
[6] 《中国民航信息系统建设“十五”计划和2010年远景规划》 民航总局
[7] 《A relational model of data for large shared data banks》, Codd EF. CACM,1970
[8] 《An Introuction to Database Systems》 C.J. Date. Seventh Edition. 机械工业出版社，2000
[9] 《数据库系统概论》萨师煊 高等教育出版社
[10] 《Object/Relational DBMSs: Trackbig the Next Great Wave》 (2nd edition). Michael Stonebraker and Paul Brown (with Dorothy Moore )San Francisco, Calif.: Morgan Kaufmann (1999)
[11] 《Data Base Systems》 Courant Computer Science Symposia Series 6. Englewood Cliffs, N.J. PrenticeHall (1972).
[12] 《Oracle9i Database Concepts》, Release 2(9.2), Part No. A96524-01, Michele Cyran, Oracle Corporation.
[13] 《The Common ATM Information State Space-A unified data management
system for the entire NAS resources based on an indexing system》 Ian Crook, Diana Liang, Zak Tibichte; ATM-2001
[14] 《Visual Modeling with Rational Rose 2002 and UML》 Terry Quatrani Addison Wesley
[15] 《Fundamentals of Database Systems》 Ramez Elmasri, 人民邮电出版社
[16] 《UML Distilled Second Edition A Brief Guide to the Standard Object Modeling》 (Second Edition) Martin Fowler, Kendall Scott; Addison Wesley.
[17] 《UML for Database Design》 Eric J. Naiburg, Robert A. Maksimchuk, Addison Wesley.
[18] 《UML Distilled Second Edition A Brief Guide to the Standard Object Modeling》 (Second Edition) Martin Fowler, Kendall Scott; Addison Wesley.
[19] 《UML for Database Design》 Eric J. Naiburg, Robert A. Maksimchuk, Addison Wesley.
[20] 《Oracle管理员手册》 Oracle Corporation
[21] 《数据库系统教程》 施伯乐 高等教育出版社
[22] 《Oracle9i Database Administrator's Guide》 Release 2(9.2), (March 2002, Part No. A96521-01), Ruth Baylis, Oracle Corporation.
[23] 《Oracle Enterprise Manager Administrator's Guide》, Release 9.2.0 Part No. A96670-01, Oracle Corporation.
[24] 《Oracle Enterprise Manager Configuration Guide》, Release 9.2.0.2, Part No. A96673-02, Oracle Corporation.
[25] 《Oracle Enterprise Manager Getting Started with the Oracle Management Pack for Oracle Applications》, Release 9.0.1
[26] 《Oracle9i SQL Reference》, Release 2(9.2), Part No. A96540-02, Diana Lorentz, Oracle Corporation.
[27] 《Oracle9i Database Utilities》, Release 2(9.2), Part No. A96652-01, Kathy Rich, Oracle Corporation
[28] 《Oracle Enterprise Manager Concepts Guide》, Release 9.2.0, Part No. A96674-01, Oracle Corporation. Part No. A88720-01, Jacqueline Gosselin,Oracle Corporation.
[29] 《Database Programming with JDBC and Java》, Second Edition George.Reese O'Reilly & Associates, Inc.
[30] 《Borland(?) JBuilderTM Developer's Guide》 Michael Landy, Saleem Siddiqui, Jeff Swisher Sams
[31] 《Oracle9i JDBC Developer' s Guide and Reference》, Release 2 (9.2) Part No. A96654-01, Elizabeth Hanes Perry, Mike Sanko, Brian Wright, Thomas Pfaeffle, Oracle Corporation.
[32] 《JavaTM Examples in a Nutshell》, Second Edition David Flanagan O'Reilly & Associates, Inc.
[33] 《JavaTM in a Nutshell》, Fourth Edition David Flanagan O'Reilly & Associates, Inc.
[34] 《空中交通管制系统与计算机网络》 宋福臣 中国民航出版社