Way of improving database queries performance by automated way of creating efficient Materialized Views (containing subset of the columns)
Publication Date: 2013-May-29
The IP.com Prior Art Database
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.