The invention relates to the technical field of
big data storage, and discloses a multi-
level data storage and mixed query method and
system, a storage medium and equipment, and the method comprises the steps: collecting original buried
point data, carrying out real-time
stream processing, storing the processed real-
time data in a hot storage layer, carrying out timing offline
batch processing on historical buried
point data, and storing the processed real-
time data in a hot storage layer; converting into an optimized storage format and storing in an
object storage system; an extended
metadata management system is constructed, and structure information, partition information and
access frequency information of data in the
object storage system are automatically extracted and managed; executing query, and reducing the data scanning amount through a
query optimization strategy; automatically migrating data among different storage
layers through a dynamic cold and hot data layering mechanism; a unified query interface is provided, a query request is distributed to a corresponding real-
time processing system or an offline query system based on an intelligent routing strategy, and a query result is cached and returned, so that high-performance and low-cost storage and second-level query of data are realized.