Main Article Content
Abstract
-Multidimensional databases are used mostly for Online Analytical Processing (OLAP) and data warehousing. These can be used to show multiple dimensions of data to users. A multidimensional database is created from multiple relational databases and these relational databases allow users to access data in the form of different queries. These multidimensional databases also allow users to ask analytical questions related to business or market trends. The multidimensional database uses multidimensional online analytical processing to access its data. The stock market is one of the most unpredictable place in this world which directly or indirectly attracts many eyes due to its sensitivity and direct market involvement. There are several analytical systems to analyze this type of huge amount of data. Clustering of these types of data is more popular to analyze these data to carry out various researches and to produce meaningful result. The data in multidimensional databases is stored in a data cube format. This means that data can be seen and understood from many dimensions and many perspectives. A K-means clustering technique is one of the popular techniques for the clustering of these data to calculate the essentiality and the diversity of various clusters. K-means clustering is the simplest and popular unsupervised machine learning algorithms in which the K-means algorithm identifies k number of centroids, and then allocates every data point to the nearest cluster, with keeping the centroids as small as possible. The stock exchange data are different from each other by their uniqueness, so each data should be assign to the particular cluster so as to reach an optimized result. The stock exchange data analysis provides the price and demand of a particular product as well as the market trend of a company. It also provides the shares value as well as historical trends of variouscompany and products. In this paper we have applied k-means clustering and linear regression basically for the market rate analysis and demand of Gold in India according to theprice.This will provide information to merchants and share holders about the price and demand of Gold from time to time for various states in India to invest in Gold and purchase shares.