Abstract: Data storage and query method and device are disclosed, which facilitate a quick acquisition of query results through index queries at subsequent stages by establishing indexes for columns of a table. Furthermore, by scanning data in the table to obtain statistical information of data in the columns, this facilitates using the statistical information of the data in the columns to perform cost estimation in subsequent queries, in an attempt to obtain a data query mode that has the least cost and the best performance, thus improving query efficiency.

Abstract: Data storage and query method and device are disclosed, which facilitate a quick acquisition of query results through index queries at subsequent stages by establishing indexes for columns of a table. Furthermore, by scanning data in the table to obtain statistical information of data in the columns, this facilitates using the statistical information of the data in the columns to perform cost estimation in subsequent queries, in an attempt to obtain a data query mode that has the least cost and the best performance, thus improving query efficiency.

Abstract: Embodiments of the present disclosure can provide a method and an apparatus for data hierarchical storage. The method comprises: storing one or more data files in a remote disk; acquiring, from the remote disk, a data file of the one or more data files, the data file being last accessed by a user; segmenting the data file into data blocks; caching the data blocks into a local disk; and caching the data blocks from the local disk to a local memory.

Abstract: Embodiments of the present disclosure can provide a method and an apparatus for evaluating a partition in a database. The method can include: acquiring meta information of a data partition in the database, wherein the meta information comprises an area range value of the data partition; and determining whether the data partition is a valid partition according to a query condition of a query associated with the data partition and the meta information of the data partition.