TRAJECTORY GENERATION METHOD AND SYSTEM BASED ON REAL-TIME DATABASE POSITIONING, AND DEVICE AND MEDIUM

摘要

A trajectory generation method and system based on real-time database positioning, and a device and a medium. The method comprises: a database creating new data tables A and B (S1); a data collector collecting positioning information of users, and storing the positioning information in the data table B (S2); the data collector recollecting the latest positioning information of the users, and storing the latest positioning information in the data table A (S3); a timer of the database comparing whether the positioning information in the data table B is the same as the positioning information in the data table A (S4); if so, updating the positioning information in the data table B to be the positioning information in the data table A (S7); and if not, creating a new data table C in the database, sequentially combining the positioning information in the data table B with the positioning information in the data table A to form a two-dimensional array, and storing same in the data table C (S5); and querying a primary key of the data table C to obtain the two-dimensional array, so as to obtain a trajectory. By means of the method, a trajectory is generated by directly using a database, and background support is not required, such that background pressure can be reduced; additionally, by means of the method, positioning information is combined to form a two-dimensional array to form a trajectory, thereby also reducing the data volume of the database, and improving the querying speed.