Design And Realization Of Database In Satellite Navigation System Ground Station

Based on the problem that the requirements change rapidly during the development of the high availability database in the satellite navigation system ground station, this dissertation focuses on the application and modification of agile method applied in database design. To sum up, some important conclusions are as follows:First, the process model of agile database method is established and improved. Concretely, an interactive model based on communication and cooperation of the agile software team, stressing the conversion from traditional DBA to agile DBA, is proposed. A team structure with agile DBA as the communication center and chief developer is established. A method of performance assess is proposed that the DBA and the team of application are treated as a whole and the user story card is substituted with user auditing card to make clear that the duty of requirements analysis never be transferred to the client agents. At last, a practical process model of agile database method implementation is providedSecond, two main kinds of agile database method implementation technology are deeply researched in the development of the database satellite navigation system ground station: database refactoring and design pattern.(1) The principle of database refactoring is summarized, including the encapsulation of database access, control of changing risk and the strategy of conversion time. Database refactoring is applied in the evolution of database schema to adapt the change of requirements and satisfy the design target. And take the solution of"satellite data fast storage problem"as example, the process of refactoring is demonstrated. What's more, the result of refactoring can be considered as a low-cost solution to this problem.(2) Because design pattern can promote the maintainability software, it's regarded as a relational technology of agile database method. The classification of design as function design and structure design is claimed and the latter is the application field of design pattern to gain software flexibility, which is effective in avoiding large scale refactoring in the late stage of software development, and at the same time design pattern act as the object and edge of refactoring.Third, the effect of the final release and the schedule control of agile database method itself is analyzed. EVM(earned value method) is applied to track the schedule of software development. Thanks to the point that agile method consistently provides useable small release, the precision of EVM in the agile process is apparently higher than the traditional process. EVM, together with agile method, act as a effective solution in the development and implementation of database project.The results of this dissertation has already been applied in the construction of the database in the ground station of our satellite navigation system and be used for reference by other high availability database system.