1results about How to "Capacity control" patented technology

This invention provides a method for storing big data databases in an energy management system. The database storage process is as follows: S1, create a heap table according to the data type; S2, store the data obtained from the terminal into the heap table of the corresponding data type; S3, determine if it is time for the execution of the scheduled task on the next natural day, and if so, proceed to step S4; S4, convert the heap table generated on the previous natural day into an index-organized table and store it in the database; S5, complete the storage conversion process; S6, perform a backup operation. The beneficial effects of this invention are: a method for storing big data databases in an energy management system can effectively control the storage capacity of a single database table within an ideal range.