| The VR(virtual reality)simulation platform of underwater oil and gas production process applies the virtual reality technology to realize the virtual operation training for the staff through the integration of underwater dynamics simulation and multiple simulation systems.As the simulation platform is difficult to effective management,in order to solve the problem of data management in the simulation platform,this article in view of the underwater oil and gas production process data management problem in virtual reality simulation platform,for the first application of spatio-temporal database technology in virtual reality simulation system,to develop a suitable for the virtual reality simulation platform of data management system,the main research content is as follows:(1)Data flow analysis was carried out on the VR simulation platform of underwater oil and gas production process.Based on the demand analysis of the data management system and the overall design of the C/S architecture,the spatial and temporal trajectory database and the basic information database of the system are constructed.(2)Propose a hybrid index based on spatial R-tree and one-dimensional time index,and the update method of the documented spatial R-tree and the corresponding spatiotemporal query method are designed.The index module is tested by query performance and comparison.(3)Designed the system UI and refined each module of the system,realized the functions of each module through the.net Framework and C# language programming,designed the encryption of the system database,and finally conducted the functional test of the system.After query test and system function test,the spatio-temporal index constructed in this paper has a considerable improvement effect on the query speed of track data,and the improvement effect becomes more obvious when the data set is larger.The system can effectively manage all kinds of data and information in the VR simulation platform. |