Design And Realization Of Software Database Of Airborne TCAS Equipment Testing System

In recent years,with the development of the aviation industry,the flight path has become more and more complex,and the safety of air traffic has gradually been paid attention to by many countries.The air collision avoidance system can effectively avoid collisions between aircraft,and is mandatory to be installed on every large civil aircraft.In order to ensure the normal operation of Traffic Alert and Collision Avoidance Systema（TCAS）equipment,a series of tests are required.The content of the relevant tests is numerous and complex,which is constantly being updated and improved,and the data records generated during the tests also need to be properly stored and managed.Designing reasonable test software and establishing a dedicated database to manage test data is not only conducive to the statistical analysis of test results,but also helps to improve test efficiency.According to the idea of modularization,this thesis has gone through the whole process from demand analysis,overall design,detailed design and implementation to system testing,completed the design of the test database for TCAS test equipment,and provided the visual host computer software.The whole system development adopts the front-end and back-end separation mode,the host computer interface is designed by Lab Windows/CVI,and the back end is built by Spring Boot framework.The main work contents are as follows:1.The working principle of the secondary radar is deeply studied,and the work flow and data storage requirements of the TCAS test are refined.On the basis of traditional form file storage,a database is constructed for data statistics management,which has the application prospect that can meet the subsequent storage iteration requirements.2.Facing the problem of big data storage,based on the traditional sharding middleware,this thesis adopts the scheme based on proxy mode and interceptor to independently design and realize the operation of sharding,which solves the problem of poor database response performance caused by that the amount of data stored in single table exceeding one million,and reduced the data storage pressure of the database.3.Studied and designed a distributed ID generation scheme for database based on snowflake algorithm,completed data encryption processing using Elgamal algorithm,realized SQL parsing,SQL routing operation to assist database for data storage,and completed the design of routing policy algorithms such as small table broadcasting.4.Designed and implemented the equipment information setting of the database system,the basic parameter setting of the signal generator,the scene simulation test,the answering machine test,the message packet transmission test and other functions,and provided report printing,backup and restoration,import and export of key data services.In this thesis,relevant functional,performance and security tests are conducted on the TCAS test database system.According to the test verification results,the whole database system meets the design expectations and provides a certain reference for similar database design.