benefits and problems of data warehousing

1: - The biggest advantage of data warehousing is that users who have access to the source of large information can help solve many problems.

2: -It increases business intelligence.

3: -The system's performance and queries increase.

4: -We can access data on time.

5: -The quality of the data increases and the continuity increases.

6: -With more than we can afford, we can earn more from it.

7: -Companies make good and smart decisions by this

8: -It supports ad hoc reporting and enquiry.

9: -We can access data quickly and easily.

benefits and problems of data warehousing 

problems of data warehouse

The following are the problems in the data warehouse.

1: - Sometimes it takes longer to sort, clear, and load the data in the warehouse. Which is one of the biggest problems of data warehouses.

2: - Data Warehouse is a system that needs high quality maintenance and the cost of this maintenance is very high.

3: - Data comes from many organizational and sources in Data Warehouse. In which a lot of data is inconsistent and duplicate, which reduces the quality of data which is a major problem.

4: -In conceptual schema for documenting the project is not enough. This requires multiline and integrated approaches.

5: Testing in Data Warehousing is like a big challenge, it takes a lot of time to do testing in such a large database.

benefits and problems of data warehousing  

Problems with Data WareHousing 

i).Data quality:-In a data warehouse, data is coming from many disparate sources from all facts of an organization. 

When a data warehouses tries to combine inconsistent data from disparate sources, it encounters error. 

ii).Designing the data warehouse:-People generally don’t want to “waste” their time defining the requirements necessary for proper data warehouse design. 

iii).Testing the data warehouse:-Testing in data warehousing is a real challenges.

It takes  lot of time to test them.

One of the reasons why testing is trickily is due to the reason that a top level object in data warehouse.

iv).Under estimation of resources of data loading:-Sometimes we under estimate the tie required extracting, clean and loading the data into the warehouse.

 benefits and problems of data warehousing    

v).Hidden problems with source systems:-sometimes hidden problems associated with the source systems feeding the data warehouse may be indentified of ten years of being untested.

vi).Required data not captured:-In some cases, the required data is not captured by the source systems which may be very important for the data warehouse purpose. For example-the data of registration of the property may be not used in source system but it may be very important for analysis purpose.

vii).Increased end-user demands:-After satisfying some of end users queries, requests for support from staff may increase rather than decrease. This is caused by an increasing awareness of the users on the capability and value of the data warehouse.

viii).High demand for resources:-The data warehouse requires large amounts of dat.

ix). Complexity of integration:-The most important area for the management of data warehouse is the integration capabilities. This can be very difficult task, as there are a number of tools for every operation of the data warehouse.

x).High maintenance:-Data warehouses are high maintenance systems. Any reorganization of the business processes and the source systems may affect the data warehouse and it results in high maintenance.