Data Warehouse Back-End Tools
نویسندگان
چکیده
The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. They are known under the general term extraction, transformation and loading (ETL) tools. In all the phases of an ETL process (extraction and exportation, transformation and cleaning, and loading), individual issues arise and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.
منابع مشابه
Data Warehousing and Olap Technology
DATA WAREHOUSING and Online Analytical Processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Data Warehouse provides an effective way for the analysis and statistic to the mass data and helps to do the decision making. Many commercial products and services are now available and all of the principal database management syste...
متن کاملReduce The Wastage of Data During Movement in Data Warehouse
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 marketa...
متن کاملWarehouse Creation - A Potential Roadblock to Data Warehousing
Data warehousing is gaining in popularity as organizations realize the benefits of being able to perform sophisticated analyses of their data. Recent years have seen the introduction of a number of data-warehousing engines, from both established database vendors as well as new players. The engines themselves are relatively easy to use and come with a good set of end-user tools. However, there i...
متن کاملNovice Evaluation and Comparative Survey on Database Management System, Data Warehousing and Data Mining
A Data management is the progression and execution of frameworks, approaches, processes and measures in order to control the information lifecycle requires for a business in a creative method. A Database Management System, Data Mining and Data warehouse which intrinsically concentrate on the management and maintenance of data in modern world. Different enterprise services with various methods a...
متن کاملNovice Evaluation and Comparative Survey on Database Management System, Data Warehousing and Data Mining
A Data management is the progression and execution of frameworks, approaches, processes and measures in order to control the information lifecycle requires for a business in a creative method. A Database Management System, Data Mining and Data warehouse which intrinsically concentrate on the management and maintenance of data in modern world. Different enterprise services with various methods a...
متن کامل