期刊名称:International Journal of Innovative Research in Computer and Communication Engineering
印刷版ISSN:2320-9798
电子版ISSN:2320-9801
出版年度:2014
卷号:2
期号:12
出版社:S&S Publications
摘要:P rojecting data in different dimensions is the core concept taken for this project. Preparing a data set for analysis is generally the most time consuming task in a data mining project. In the existing system they used simple, yet powerful, methods to gener ate SQL (Structured Query Language) code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row. This new class of functions is called horizontal aggregations. [1] The horizontal aggregation is evaluated using three fundamental methods: case, SPJ (Select Project Join) and pivot. Transforming normal data into knowledge cube is one of the emerging fields in the current market. In the proposed system, a new standard of pivoting option is incorpora ted using Dat a mining. This can be achieved with the tool SAAS ( SQL Server Analysis Services ). The data will be taken and it will be transformed into knowledge cubes. This can be achieved with MDX (Multi Dimensional eXpression) queries . On top of that, th e knowledge data will be customized based on "Generalized and Suppression Algorithm". In addition to this, the performance efficiency among case, SPJ and pivot methods will be analyzed.
关键词:Aggregation; data cube; pivoting; data preparation; SQL