首页>
外国专利>
Automated and dynamic management of query views for database workloads
Automated and dynamic management of query views for database workloads
展开▼
机译:自动化和动态管理数据库工作负载的查询视图
展开▼
页面导航
摘要
著录项
相似文献
摘要
The embodiments of the invention provide a method, program storage device, etc. for automated and dynamic management of query views for database workloads. More specifically, a method begins by executing queries, which includes accessing a set of data tables for each of the queries. During the executing of the queries, the method accesses a required data table from a cache if the required data table is present in the cache and creates the required data table if the required data table is not present in the cache. The accessing of the required data table from the cache has a lower processing cost than accessing the required data table from a base table. Also during the executing of the queries, created data tables are stored in the cache, wherein one or more of the created data tables are removed from the cache when the cache becomes full.
展开▼