Browse Prior Art Database

Way of improving database queries performance by automated way of creating efficient Materialized Views (containing subset of the columns)

IP.com Disclosure Number: IPCOM000227926D
Publication Date: 2013-May-29
Document File: 4 page(s) / 64K

Publishing Venue

The IP.com Prior Art Database

Abstract

The slowest part in every Data Warehouse based on MPP architecture is disk drive. Thus many DB warehouse vendors provide number of ways in order to minimize IO processing which directly influence on the performance. One of the well known solutions is Matarialized View containing 'cached' results of the query/table. There are many types of Materialized Views, in this invention we want to focus on the materialized views built on tables (storing only subset of the columns for one table), especially on the process of automatically creation of those.