Managing scanning of databases in data storage systems

摘要

A method, system, and program, product for managing scanning of databases in data storage system, the method comprising receiving a query request from an application server to a data storage system, scanning data stored in the data storage system and based on the query request, returning a set of data to the application server, wherein the set of data corresponds to the query request.

主权项

1. A method for use in managing scanning of databases in data storage systems, the method comprising:
receiving a query request from an application server to a data storage system, wherein the application server includes a database logic, wherein the application server queries a set of databases based on the database logic, wherein the database logic includes a query planner and a query optimizer; managing scanning of data within the data storage system instead of transferring the data to the application server for scanning by scanning data blocks stored in the data storage system within the data storage system, wherein the data blocks are organized on a set of logical volumes, wherein the set of databases is organized on the set of logical volumes, wherein the data storage system processes the data blocks associated with the query request inside the data storage system by using a scan processor and a data block retrieval logic included in the data storage system, wherein the data storage system uses information associated with the data blocks for processing the data blocks and creating a result set, wherein the scanning of the data blocks is performed inside the data storage system by the scan processor, wherein the data blocks are retrieved from the data storage system by using the data block retrieval logic in a cache of the data storage system, wherein the scan processor evaluates the data blocks retrieved by the data block retrieval logic in the cache for determining whether a subset of the data blocks corresponds to the query request, wherein the result set includes a portion of the data blocks processed by the data storage system; storing information associated with the scanning of data blocks for optimizing subsequent query requests received from the application server, wherein the information associated with the scanning of the data blocks for optimizing subsequent query requests include data block processing patterns, wherein optimizing the subsequent query requests include scan optimizations, wherein the data storage system minimizes amount of data transferred to the application server in the result set by using the scan optimizations; and based on the query request, the data storage system provides the result set to the application server, wherein the result set corresponds to the query request, wherein the result set includes the subset of the data blocks.