Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Tuesday, 16 July 2013

Datawarehouse Disadvantages

By on 12:38:00

Many of the vendors spend a great deal of time talking about the advantages of data warehouses, and why companies need them if they wish to survive in the global market. While there is a degree of truth in the statements made by many vendors, it is important for companies to realize that data warehouses are not a panacea, and find a solution to all the problems you will encounter the company.

To be able to maximize the efficiency of the data warehouse requires the company to look at it from multiple perspectives, and that includes those that are both positive and negative.

The ultimate goal of the data warehouse system for storing historical information about the transactions of the company, and provide these إينفورمتين in a way that will allow the business to make important decisions. However, these data do not constitute only a small part of the information that it needs to operate, and its value, but may be limited. In some cases, the end user does not have a strong interest in the old data processing, and a lot of this data is provided in the basic reports. Many of the markets that operate in today's companies are in constant transition. Depending on the circumstances, it may not be necessary to use a historical system.

In other words, data warehouses may be too much for most companies. This is especially true for many small businesses and medium-sized businesses that are analyzing their dealings with the need for expensive programs. One of the criticisms that are usually made of data warehouses is complexity. Implementation of a data warehouse can be complex so that they can make business processes more difficult to deal with. Some experts said that even these complications can ultimately stifle business. If the company is able to put less emphasis on some of the processes, the data warehouse can cause in the business environment to become more cluttered than that.

The second problem which has become very common with data stores is its cost. Like all the advanced technology, and when it was displayed for the first time data warehouses, and can only be for wealthy companies really afford it. Even today, most data warehouses are outside the price range of companies that do not fall under the Fortune 500 or 1000 class. While sellers in recent years begun tailoring their products to small businesses and medium-sized enterprises, many of these companies may not see the need for use that are very complicated. Given the speed in the world of business, and many companies are not patient enough to wait for the implementation of the data warehouse.

In the past, it was not uncommon for a data warehouse project to take several months to implement. In one case, it took 18 months to fully implement the system. Most of today's companies want results, and they want them quickly. They do not see the need to wait for months on the system did not prove, and can become inevitably fail. The return on investment for data warehouse projects are usually much lower than the sellers promise, and it will take a long time before the company begins to see a return on their investment. Many companies simply do not have the patience to wait for the returns.

It is also important for companies to pay attention to the data side of the warehouse. Because of the complexity of these systems, it can be said that data warehouses can take on a life of their own. It must be emphasized that the development of the data in the data warehouse for adding not for any specific purpose can reduce its value.

When you combine this with the fact that the costs involved with maintaining a data warehouse can become bigger, it is easy to see why companies should be careful in their decision to use it.

Data warehouses is a technology that has brought a great deal of success for many companies. However, many of the vendors paint a rosy picture, and fail to talk about the challenges facing the company. This is done because of the fact that the seller wants to sell the product. Companies must carefully analyze the organization to decide whether the data warehouse is conducive to their needs. Only after they've done this analysis can decide whether the data warehouse and really worth the time and cost.


Post a Comment

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)