Materialized View Generation Using Apriori Algorithm

Data analysis is an important issue in business world in many respects. Different business organizations\udhave data scientists, knowledge workers to analyze the business patterns and the customer behavior.\udScrutinizing the past data to predict the future result has many aspects and understanding the nature of the\udquery is one of them. Business analysts try to do this from a big data set which may be stored in the form of\uddata warehouse. In this context, analysis of historical data has become a subject of interest. Regarding this,\uddifferent techniques are being developed to study the pattern of customer behavior. Materialized view is a\uddatabase object which can be extensively used in data analysis. Different approaches are there to generate\udoptimum materialized view. This paper proposes an algorithm which generates a materialized view by\udconsidering the frequencies of the attributes taken from a database with the help of Apriori algorithm