Research And Implementation Of Materialized Views

Materialized views will improve the database performance, it has been used in several famous DBMS succeed. materialized views is a focus on database technical research recently , many papers about materialized views have been published. PostgreSQL is a DBMS which is open-source on linux. PostgreSQL is being used in many fields , but its performance limits its useness, so lots of techinians are improving this database in many sides.We can answer many queries using materialized views, then it can give the results quickly. As a database researcher, I have studied the materialized views , and analyzed the PostgreSQL query system, then try to implement the materialized views in PostgreSQL. The follows are the major results of the paper: 1) to study the materialized views theory , algorithms and its implements in several famous DBMS,give some advoices about materialized views research.2)to give an idea to improve the materialized views, merging materialized views, then test its performance and correctness.3)to analyze the PostgreSQL query system, include four parts:parser, rewriter optimiser, exucutor. 4) to give the algorithms of the materialized views'realization in PostgreSQL,and give some examples to show these algorithms ideas and correctness.According to the testing, materialized views which are built in PostgreSQL improve its query performance.