Design of partitioned table for VLDB in the vehicle monitoring system

As the number of vehicles in the monitoring system increases, the size of the table for storing their past data becomes very large, which brings performance troubles occurred in the systems with VLDB. To improve the data-access efficiency and keep the database stability, the original table is proposed to be partitioned. According to the functional requirements for database from the vehicle monitoring system, the range partition is suggested, with twelve partitions for one year´s historical data and each partition corresponding to a separate month. Then the partitioned table is created after finishing the definitions of the partitioning function and the partitioning schema, where the former gives a rule for partitioning and the latter specifies the storage places of partitions to different file groups. Because the data in the partitioned table is separated into several file groups, the data-access is capable of parallel processing and keeps a higher efficiency. Tests show that the partitioned table works in improving the database performance and the query time is greatly reduced compared to that cost in the original table.