基于海量卫星测控数据存储与查询方法  

The Method of Storage and Query Based on Mass Satellites TT&C Data

作　　者：杨悦[1] 

机构地区：[1]四川大学软件学院,成都610064

出　　处：《科学技术与工程》2013年第25期7352-7356,共5页Science Technology and Engineering

基　　金：国家自然科学基金项目(61074077)资助

摘　　要：针对卫星海量测控数据以时间区间检索、结果按时间排序的需求,提出了基于数据库时间分区表与索引组织表(IOT)的存储和查询方法。时间分区表采用将数据存放到多个物理表空间,在数据查询时不需每次扫描整张表,检索时间明显缩短,且查询响应时间不会随着数据量的增长而增加。索引组织表是将数据直接存放在索引中,降低了存储空间的占用,以损失较小的写入效率为代价。通过对某卫星实验和分析,证明了方法的有效性和正确性,提高了数据存储和查询的效率。As to the requirements of mass satellites TF＆C data searching with time interval, and sorting the re- suits by time, a storage and query method based on database time partition table and index organization table （IOT） is proposed. Time partition table can shorten the search time by storing data in the multiple physical table space. Furthermore, the response time cant increase with the growth of data volume. Index organization table can reduce the storage space occupancy by storing data directly in the index. However, the writing efficient is partially damaged. Through the testing and analyzing of a satellite, the validity and correctness of the method is proved. As a result, the efficiency of data storage and query is improved.

关 键 词：卫星 测控数据 存储 查询 时间分区表 索引组织表 

分 类 号：TP311.11[自动化与计算机技术—计算机软件与理论]