Computer Science ›› 2020, Vol. 47 ›› Issue (11A): 570-572.doi: 10.11896/jsjkx.200400040

• Software Engineering • Previous Articles     Next Articles

Study on Mapping Transformation from Geometric Aviation Data to Relational Database

LAI Xin, ZENG Ji-wei   

  1. Air Traffic Management College,Civil Aviation Flight University of China,Guanghan,Sichuan 618307,China
  • Online:2020-11-15 Published:2020-11-17
  • About author:LAI Xin,born in 1977,Ph.D,associate professor.Her main research interests include transportation planning & management and aeronautical information management.
  • Supported by:
    This work was supported by the Civil Aviation Technology Innovation and Education Training Fund (0251812) and Central College Education and Teaching Reform Special Fund (E2019035).

Abstract: The aeronautical data exchange model based on GML is the foundation of future aeronautical information management.Aeronautical information service system currently used is mainly based on the relational model database.On the transitional stage,the expression of aeronautical information data with GML standard geometric characteristics in the relational database must be considered.The structural characteristics of geometric aeronautical data in the aeronautical information exchange model and the differences among geometric data representations in a relational database are analyzed.The feasibility of mapping between the two types of data is indicated.And then a mapping scheme of geometric aviation data to a relational database is proposed,and available technologies such as Linq to XML are used to verify the feasibility of the mapping scheme.

Key words: AIXM, GML, Relational database, Spatial data, XML

CLC Number: 

  • TP311.13
[1] EUROCONTROL.Aeronautical Information Exchange Mode[EB/OL].[2019-12].http://www.aixm.aero/sites/aixm.aero.
[2] FENG Y,DU X H,CAO L F G.Multi-type Data Object Access Control Based on XML[J].Computer Engineering and Design,2015,36(2):335-340,362.
[3] WANG P.A XML Based method of Data transformation be-tween heterogeneous Databases[J].Journal of Xi An University of Posts and Telecommunications,2011,16(3):73-76.
[4] ZHOU Y,LU A J.Conversion between XML and Object Relational model[J].Communications Technology,2019,52(6):1541-1548.
[5] ZHAO D,YUAN Y,SU L J.Design and implementation of target multidimensional feature database[J].Modern Electronic Technique,2017,40(20):10-11,13,17.
[6] Open Geospatial Consortium.Geography Markup LanguageSpecification [EB/OL].[2019-12].http://www.opengeospatial.org/standards/gml.
[7] Microsoft Developer Network.Spatial Data Types Overview [EB/OL].[2019-12].https://msdn.microsoft.com/en-us/library/bb964711.aspx.
[8] KRILL P.Microsoft open-sources Entity Framework:Code release of.Net application development tool is being handled by Microsoft Open Technologies [EB/OL].[2019-12].http://www.infoworld.com/article/2617690/microsoft-net/microsoft-open-sources-entity-framework.html.
[1] MA Dong, LI Xin-yuan, CHEN Hong-mei, XIAO Qing. Mining Spatial co-location Patterns with Star High Influence [J]. Computer Science, 2022, 49(1): 166-174.
[2] LIU Xin-bin, WANG Li-zhen, ZHOU Li-hua. MLCPM-UC:A Multi-level Co-location Pattern Mining Algorithm Based on Uniform Coefficient of Pattern Instance Distribution [J]. Computer Science, 2021, 48(11): 208-218.
[3] E Hai-hong, HAN Peng-hao, SONG Mei-na. Conversion Method from Relational Database to Graph Database [J]. Computer Science, 2021, 48(10): 140-144.
[4] LU Jia-wen, YAN Li. Mapping Method from Object-relational Database to RDF(S) [J]. Computer Science, 2021, 48(10): 145-151.
[5] HU Lei, YAN Li. Uncertain XML Model Based on Fuzzy Sets and Probability Distribution and Its Algebraic Operations [J]. Computer Science, 2020, 47(7): 21-30.
[6] TAN Li-xing, WANG Fu-jun. On Logic of Graded Argumentation System [J]. Computer Science, 2020, 47(5): 27-31.
[7] XU He, WU Hao, LI Peng. Design of Temporal-spatial Data Processing Algorithm for IoT [J]. Computer Science, 2020, 47(11): 310-315.
[8] GUO Ying-ying, ZHANG Li-ping, LI Song. Group Nearest Neighbor Query Method of Line Segment in Obstacle Space [J]. Computer Science, 2018, 45(6): 172-175.
[9] LI Ting and CHENG Hai-tao. Research of Approximate Keyword Query on Fuzzy XML Documents [J]. Computer Science, 2017, 44(9): 216-221.
[10] YANG De-xian, SUN Hua, YU Jiong and GUO Bing-lei. Relational Database Energy Prediction Model Based on MBRC [J]. Computer Science, 2017, 44(7): 161-166.
[11] TANG Jia, FU Yun-qing and WAN Xuan-min. Visual Custom Report Model Based on Single Data Source [J]. Computer Science, 2017, 44(5): 184-188.
[12] QIAO De-ji and XIAO Wei-dong. Task Driven Data Transmission and Synchronization Method Based on XML [J]. Computer Science, 2016, 43(Z6): 489-492.
[13] HUANG Shou-meng. Query Optimized Operation Model of XML Based on Cost [J]. Computer Science, 2016, 43(Z11): 529-531.
[14] GE Wei-yi, ZONG Shi-qiang and YIN Wen-ke. Keyword Search for Relational Databases Based on Offline Index [J]. Computer Science, 2016, 43(4): 182-187.
[15] LI Ning, GAO Xiao-guang, HOU Xia, ZHANG Wei and TIAN Ying-ai. Research on Parallel Transform of XML Data Based on XSLT Stylesheet Partitioning [J]. Computer Science, 2016, 43(3): 231-237.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!