首页    期刊浏览 2024年11月29日 星期五
登录注册

文章基本信息

  • 标题:Design and Implementation of Multi Dimensionalized Aggregation in Horizontal Dataset Using Data Analysis Services
  • 本地全文:下载
  • 作者:R.Suguna ; S.Aiswarya ; S.Ramadevi
  • 期刊名称: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
国家哲学社会科学文献中心版权所有