Method and system for data virtualization with smart cache recommendation using an advanced query acceleration (quacc) layer

Abstract

A method for managing data items includes: obtaining a query log; initiating performance of a first recommendation cycle (RC) by analyzing the query log to generate a recommendation list (RL) including at least a data item with a high-level cache reward; providing the RL to an administrator via a graphical user interface (GUI); providing an administrator-confirmed recommendation list (ACRL) to a cache engine, in which the ACRL is received from the administrator in response to the RL being provided to the administrator; receiving a refreshment policy of the data item included in the ACRL from the administrator; storing, based on the ACRL, the data item as a cached data item in a storage device.