计算机科学 ›› 2020, Vol. 47 ›› Issue (11A): 570-572.doi: 10.11896/jsjkx.200400040

• 软件工程&数据库 • 上一篇    下一篇

几何类航空数据与关系型数据库映射转换研究

赖欣, 曾纪炜   

  1. 中国民用航空飞行学院空中交通管理学院 四川 广汉 618307
  • 出版日期:2020-11-15 发布日期:2020-11-17
  • 通讯作者: 赖欣(lxrzg@163.com)
  • 基金资助:
    民航技术创新和教育培训基金(0251812);中央高校教育教学改革专项基金(E2019035)

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).

摘要: 现有航空情报服务系统主要基于关系型数据库,而未来航空情报管理是基于GML的航空数据交换模型AIXM。在从航空情报服务向航空情报管理的过渡发展阶段须考虑具有GML标准几何特征的航空情报数据在关系型数据库中的表达。文中分析了航空情报交换模型中定义的几何类航空数据结构特点,以及与关系型数据库中几何类数据表达之间差异,研究了两种类型数据间进行映射转化的可行性,提出了一种将几何类航空数据向关系数据库映射的方案,并选用Linq to XML等可用技术对该方案的可行性进行了验证。

关键词: 地理标记语言, 关系型数据库, 航空数据交换模型, 可扩展标记语言, 空间数据

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

中图分类号: 

  • 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] 马董, 李新源, 陈红梅, 肖清.
星型高影响的空间co-location模式挖掘
Mining Spatial co-location Patterns with Star High Influence
计算机科学, 2022, 49(1): 166-174. https://doi.org/10.11896/jsjkx.201000186
[2] 刘新斌, 王丽珍, 周丽华.
MLCPM-UC:一种基于模式实例分布均匀系数的多级co-location模式挖掘算法
MLCPM-UC:A Multi-level Co-location Pattern Mining Algorithm Based on Uniform Coefficient of Pattern Instance Distribution
计算机科学, 2021, 48(11): 208-218. https://doi.org/10.11896/jsjkx.201000097
[3] 鄂海红, 韩鹏昊, 宋美娜.
关系型数据库向图数据库的转换方法
Conversion Method from Relational Database to Graph Database
计算机科学, 2021, 48(10): 140-144. https://doi.org/10.11896/jsjkx.201100073
[4] 郭莹莹, 张丽平, 李松.
障碍环境中线段组最近邻查询方法研究
Group Nearest Neighbor Query Method of Line Segment in Obstacle Space
计算机科学, 2018, 45(6): 172-175. https://doi.org/10.11896/j.issn.1002-137X.2018.06.030
[5] 潘明明,李丁丁,汤庸,刘海.
一种基于中间件的异构数据库融合访问方法及系统
Design and Implemention of Accessing Hybrid Database Systems Based on Middleware
计算机科学, 2018, 45(5): 163-167. https://doi.org/10.11896/j.issn.1002-137X.2018.05.027
[6] 杨晶,周双娥.
一种基于XML的非结构化数据转换方法
Method for Unstructured Data Transformation Based on XML Technology
计算机科学, 2017, 44(Z11): 414-417. https://doi.org/10.11896/j.issn.1002-137X.2017.11A.088
[7] 杨德先,孙华,于炯,国冰磊.
一种基于MBRC值的关系型数据库负载能耗预测模型
Relational Database Energy Prediction Model Based on MBRC
计算机科学, 2017, 44(7): 161-166. https://doi.org/10.11896/j.issn.1002-137X.2017.07.029
[8] 周剑云,王丽珍,杨增芳.
基于加权欧氏距离的空间Co-location模式挖掘算法研究
Algorithm of Mining Spatial Co-location Patterns Based on Weighted Euclidean Distance
计算机科学, 2014, 41(Z6): 425-428.
[9] 李松,张丽平,朱德龙,郝晓红.
动态受限区域内的单纯型连续近邻链查询方法
Simple Continues Near Neighbor Chain Query in Dynamic Constrained Regions
计算机科学, 2014, 41(6): 136-141. https://doi.org/10.11896/j.issn.1002-137X.2014.06.027
[10] 付鹏,蒋夏军,皮德常.
一种新的支持XML文档更新的编码方法
Novel Labeling Scheme for XML Update-supporting
计算机科学, 2014, 41(3): 193-197.
[11] 侯士江,张玉江,刘国华.
基于位置敏感哈希分割的空间K-匿名共匿算法
Spatial K-Anonymity Reciprocal Algorithm Based on Locality-sensitive Hashing Partition
计算机科学, 2013, 40(8): 115-118.
[12] 许斌,关佶红.
基于MapReduce的GML并行查询
GML Parallel Query Based on MapReduce
计算机科学, 2013, 40(11): 203-207.
[13] 刘 丹,谢文君.
一种基于P2P的空间数据索引方法
Spatial Data Index Method Based on P2P
计算机科学, 2012, 39(8): 186-190.
[14] 杜根远,苗 放,熊德兰.
一种基于剖分的空间数据存储调度服务模型
Service Model of Spatial Data Storage Scheduling Based on Subdivision Theory
计算机科学, 2012, 39(8): 263-267.
[15] 杨泽雪,郝忠孝.
基于Voronoi图的线段最近对查询
Line Segment Closest Pair Queries Based on Voronoi Diagram
计算机科学, 2012, 39(6): 143-146.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!