Research On Application Of ITRF Data Management Based On Oracle Database

With the constant improvement of the level of science and technology,measuring technique,the ITRF data scale expands unceasingly,ITRF data management is becoming very important,security and reliability of the system,the integrity of the data,and meanwhile,higher query speed and convenient operation and so on as the key of the database management system is good or not,in recent years has caused wide attention of many scholars and research.Oracle database system is Oracle launched the world's first commercial relational database management system,using the structured query,support a variety of data types in the database and user operation platform,Oracle has a complete data management function,make it very clear the relationship between the data,also has the function of distributed processing.On the basis of previous studies,this paper USES Oracle database to process some data in ITRF2014.The main work and conclusions are as follows:1.Analyze and discuss the drawbacks of ITRF's previous file management methods,such as the difficulty of data preservation,lack of sharing and independence,etc.According to the characteristics that more than 95% of ITRF data are symmetric matrices,a symmetry-relational database theory is proposed to solve the drawbacks of the previous file management methods.2.Analyze and discuss the advantages and disadvantages of various databases,as well as the advantages and disadvantages of data management methods and other methods.This paper illustrates the advantages of using database management system to manage ITRF result data.ITRF2014,the latest ITRF data framework used,has a broader time span.3.Python has the advantages of simple code,comprehensive class library and high development efficiency.In this paper,the principle of symmetry-matrix relational database proposed by predecessors is utilized.4.On the Oracle SQL Developer platform for ITRF2014-IGS-agency.SNX establish database,the original data file is one piece at a time into a relational table structure,because of the huge amount of data,2014 SINEX(Solution INdependent EXchange Format)maximum 14.7 GB of data,because the machine memory limitations prone to cause system crash of memory,it is necessary to clean up the data to ensure smooth written to the database.