Design and Implementation of Stratified Storage Technology Based on Time-sequential Databases
In the actual operation process of the electric power automatic scheduling system,the continuous increase of ac-cessed data points gradually results in sluggish historical data queries or statistics.In view of this,the present work stud-ied a technological architecture of stratified storage based on time-sequential databases.It integrates the storage and query modes of the original real-time database with the establishment of a caching mechanism in the time series database to store object ID key information and recent hot data,thereby achieving hierarchical storage and queries,and accelerating query and statistical speeds.In the specific implementation process,in order to shield the differences in the use of different time-sequential databases for upper-layer applications and facilitate the selection of different types of time-sequential databases in different engineering operation sites,a dynamic loading development approach is adopted to provide a set of universal time-sequential database invocation interfaces.Upper-layer applications can use the same set of programs to complete the read and write operations for different types of time-sequential databases,effectively reducing the development workload of upper-layer applications.