Data correlation query method and data correlation query device

The invention provides a data correlation query device and a data correlation query method. The data correlation query device comprises a data acquisition unit, an SQL (structured query language) execution unit, a cache number-picking formula construction unit and a cache execution unit. The data acquisition unit is used for obtaining a fundamental field of a fact table and selecting a field of a dimension table based on the fundamental field to be used as an correlation field for correlation of the fact table and the dimension table; and the SQL execution unit is used for implementing query operations through SQL statements based on the fundamental field and a datasheet with the fundamental field, and obtaining a result set; the cache number-picking formula construction unit is used for obtaining a main key value corresponding to the correlation field from the result set, and constructing a cache number-picking formula in combination with a data path with the correlation field; and the cache execution unit is used for obtaining the value of the correlation field according to the cache number-picking formula and combining the value of the correlation field and the result set to obtain final query results. The fact table and the dimension table can be associated efficiently, results can be implemented efficiently, the fatal pressure on the system caused by correlation query of the fact table and the dimension table with a large number of data can be avoided, and the efficiency can be improved.