In this research paper so as to handle Data in warehousing as well as reduce the wastage of data and provide a better results which takes more and more turn into a focal point of the data source business. Data warehousing and on-line analytical processing (OLAP) are vital fundamentals of resolution hold, which has more and more become a focal point of the database manufacturing. Lots of marketable yield and services be at the present accessible, and the entire primary database management organization vendor nowadays have contributions in the area assessment hold up spaces some quite dissimilar necessities on record technology compare to conventional on-line transaction giving out application. This article gives a general idea of data warehousing and OLAP technologies, with the highlighting on top of their latest necessities. So tools which is used for extract, clean-up and load information into back end of a information warehouse; multidimensional data model usual of OLAP; front end client tools for querying and data analysis; server extension for proficient query processing; and tools for data managing and for administration the warehouse. In adding to survey the circumstances of the art, this article also identify a number of capable research issue, a few which are interrelated to data wastage troubles. In this paper use some new techniques to reduce the wastage of data, provide better results. In this paper take some values, put in anova table and give results through graphs which shows performance.
翻译:在本研究文件中,为了处理仓储中的数据以及减少数据浪费,提供更好的结果,使数据源业务越来越越来越成为协调中心。数据仓和在线分析处理(OLAP)是解决方案持有的重要基础,越来越成为数据库制造的协调中心。目前可以销售的产量和服务很多,而且整个数据库管理组织的主要供应商在地区评估方面的贡献使记录技术与传统的在线交易应用相比,在记录技术方面存在着一些非常不同的需要。这一文章提供了一个数据仓和OLAP技术的一般概念,并突出了它们的最新需要。因此,用于提取、清理和将信息装入信息仓库后端的工具越来越成为解决方案的协调中心;多维数据模型是OLAP的常用做法;查询和数据分析的前端客户工具;查询和数据处理的服务器扩展;以及数据管理和行政仓库的工具。在对艺术环境的调查中,本文章还列出了一些有能力的研究问题,其中有一些与数据仓库的最近需要相联的工具。在纸面上显示一些工作结果。在纸面上显示一些与纸面结果,在纸面上显示一些结果。