Problems described in the case study
The Hewlett Packard Company (HP) faces the problem of data management especially in the Information technology departments. Data management has brought about the main problem of the company’s expenditure overall issue. Initially the control and processing of data occurred at various terminals where the system directs one’s request to particular points of concern. This is a major hit to management because of the encountered delays, loss of information as well as total inaccessibility or important data or information.
The issue of data warehousing entails the architectural, algorithmic and protocols used in managing data or information. In line with the HP case study, the expenditures were high due to unstructured information technology setting, exaggerated systems in terms of number of hubs involved, amount of servers as well as information infrastructure.
Factors facilitating the problem
Evidently, from the case analysis, the processing and exchange of information at the HP Company occurred from various processing points as opposed to single repository and processing unit. The excess expenditures were because of multiple systems covering processes meant for one multitasking system.
The management failed to deliver due to lack of synthesized system where information is output within the least possible time for use in decision-making. If the managers make judgment from stale and unprocessed data, then the cost is eventually economical.
Hewlett Packard Company (HP) solutions to the problem
HP came up with the central data depository system referred to as the “mega data warehouse”, which has now become prominent theory in the database world, where direct querying and analysis of information occurs in real time.
This has been a major boost on the decision-making procedures since the manager does not require waiting for data to make precise conclusions. Initially as indicated in the case study, the managers were not in a position of finding important information such as the total expenses or total sales for the Information technology department.
The system allows for advance extraction of information for translation and production of appropriate output. Comparison of information from other sources is easily for the enterprise when access is from a central point.
The logical centralized repository reduces the dormant terminals by converging processes, which can be multi-processed. One major advantage of the central warehousing of data includes evaluation of data. Posting of queries involve direct evaluation at the repository without a need for referencing other original or raw sources.
How HP database experience and technology will assist in developing an all-inclusive warehouse
Many companies have tried to implement the centrally handled database system without much success. The success of HP enterprise-wide data warehouse brought many benefits to not only the business but also the clients and other companies. HP Company implemented the “Neoview management and monitoring tool” which was of great help to others like the Wal-Mart to manage information from there retail outlets and the Bon-Ton companies.
The single warehousing system is therefore appropriate for the clients who require specific or prediction of parts of accessible information and for those who require high query performance since it offers better high accessible speeds. The requirements for high-speed inquiry from multiple sources of the organization’s information requires a warehouse that offers multi-source queries executions since data resides and processing is at the same point.
How Neoview assists HP and other clients in creating enterprise-wide data warehouses
The need for central data warehousing seem to originate from company’s need and desire to decompose all the data to a middle point for ease in management, processing and analysis. People wish to decouple their internal and private data from the internet sources such as the web.
With the current advancement of technology online data exchange, transfer and processing poses grate risk to important or confidential information. One of the primary uses of data warehousing is to allow complex analytical processes involving complex queries within a limited period.
The wide data warehouse implementation procedure
To implement such a warehouse there is urgent need to connect all the existing terminals and collect data to the central repository. Any notable or client’s requested changes over data type need reporting to the integrator.
One of the common cause of failure on implementation of such system lies on the implementers/integrators. For any complex and technologically advanced system, the company ought to consider experts or professionals services. To avoid its collapse, the users also need training before they begin working on the system.
The system integrators should consider the best style to use for instance having a prototype before the main system, or parallel implementation where the old system runs concurrently with the new system until the company achieves full integration as opposed to changing to the new system directly.