针对卫星海量测控数据以时间区间检索、结果按时间排序的需求,提出了基于数据库时间分区表与索引组织表(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.