A New Breed of Data Warehouse

Source:
Servers / Blades
Published:
Apr 13, 2009
Pages:
8

The potential benefits of enterprise data warehouse technology are clear: organizations can store and access huge volumes of historical and current information that provide end-users with unprecedented business insight and help them make more informed and timely decisions.

But many organizations today are struggling with challenges that can significantly undermine their investments in enterprise data warehouse technology and keep them from getting optimum payback from these deployments. Among the key challenges are the lack of a viable way to track information end to end, and the general frailty of data warehouse solutions that, in the long term, prevents organizations from getting the value they anticipated out of the technology. In some cases, this can even lead to a disuse of the data
warehouse solution altogether.

Many data warehouse projects fail because of the complexities involved. Several years ago a leading research firm predicted that more than half of data warehouse projects would have limited acceptance-or would be outright failures-as a result of data quality issues. Many organizations fail to recognize that they have an issue with data quality, focusing only on identifying, extracting, and loading data into the data warehouse but not taking the
time to assess quality, the firm said. Similarly, a Cutter Consortium survey reports that only 15% of respondents classified their data warehousing projects as a success, while 46% of respondents said that these resource-intensive expenditures added little or no value.

Organizations are spending more money on enterprise data warehouses and associated technologies than they thought they would. By the time they factor in labor costs, business intelligence applications, enterprise metadata management, costs to create dashboards, and various services related to data warehouse implementation, the total cost of ownership (TCO) ends up being much greater than expected.

Because enterprise data warehouses are evolving along different dimensions, organizations need to effectively manage metadata to ensure successful use of their data warehouse systems. But current data warehouse offerings on the market limit organizations' ability to manage metadata.

A new breed of data warehouse technology is emerging that addresses many of the implementation challenges organizations face. ASG's BSPTM Data Warehouse, offered by ASG Software Solutions,combines metadata federation technology with the fastest growing database platform, Microsoft® SQL Server®. It relies on technology from ASG-Rochade®, the world's leading metadata repository. The result: an effective data warehouse technology that equips enterprises to realize the true value of their data warehouse investments.

This white paper looks at some of the key challenges organizations face in getting the most out of their enterprise data warehouses and describes an emerging solution that will enable them to maximize
their sizable investments in these vast stores of information.

To download the full whitepaper/case study, please provide the following information:

Other Servers / Blades White Papers

Re-engineering Legacy to Web Application

Reengineering of software is described as the examination and alteration of a system to reconstitute in a new form. The approach is to renovate and extend the current application into new technology to best support the needs of the current business. Application modernization should be achieved by leveraging the existing investment in application infrastructure and reposition the product advantageously for the future. The challenge on hand is to convert legacy application to web application by reengineering legacy components to re-usable components. The web application can be easily integrated with web technologies.