Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Designing a Data Warehouse : Supporting Customer Relationship Management

Buy

The main subject of this book is data warehousing. A data warehouse is a special kind of database that, in recent years, has attracted a great deal of interest in the information technology industry. Quite a few books have been published about data warehousing generally, but very few have focused on the design of data warehouses. There are some notable exceptions, and these will be cited in this book, which concentrates, principally, on the design aspects of data warehousing.

Data warehousing is all about making information available. No one doubts the value of information, and everyone agrees that most organizations have a potential “Aladdin's Cave” of information that is locked away within their operational systems. A data warehouse can be the key that opens the door to this information.

There is strong evidence to suggest that our early foray in the field of data warehousing, what I refer to as first-generation data warehouses, has not been entirely successful. As is often the case with new ideas, especially in the information technology (IT) industry, the IT practitioners were quick to spot the potential, and they tried hard to secure the competitive advantage for their organizations that the data warehouse promised. In doing so I believe two points were overlooked. The first point is that, at first sight, a data warehouse can appear to be quite a simple application. In reality it is anything but simple. Quite apart from the basic issue of sheer scale (data warehouse databases are amongst the largest on earth) and the consequent performance difficulties presented by this, the data structures are inherently more complex than the early pioneers of these systems realized. As a result, there was a tendency to over-simplify the design so that, although the database was simple to understand and use, many important questions could not be asked.

The second point is that data warehouses are unlike other operational systems in that it is not possible to define the requirements precisely. This is at odds with conventional systems where it is the specification of requirements that drives the whole development lifecycle. Our approach to systems design is still, largely, founded on a thorough understanding of requirements–the “hard” systems approach. In data warehousing we often don't know what the problems are that we are trying to solve. Part of the role of the data warehouse should be to help organizations to understand what their problems are.

Ultimately it comes down to design and, again, there are two main points to consider. The first concerns the data warehouse itself. Just how do we ensure that the data structures will enable us to ask the difficult questions? Secondly, the hard systems approach has been shown to be too restrictive and a softer technique is required. So not only do we need to improve our design of data warehouses, we also need to improve the way in which we approach the design.

It is in response to these two needs that this book has been written.

(HTML tags aren't allowed.)

Blackberry Hacks
Blackberry Hacks

The BlackBerry has become an invaluable tool for those of us who need to stay connected and in the loop. But most people take advantage of only a few features that this marvelous communications device offers. What if you could do much more with your BlackBerry than just web surfing and email?

...
The Dating Game: One Man's Search for the Age of the Earth (Canto Classics)
The Dating Game: One Man's Search for the Age of the Earth (Canto Classics)

In this book, Cherry Lewis skilfully blends the history of gauging the age of the earth with a biography of Arthur Holmes, a British geologist who was a pioneer of geochronology. When it was deeply unfashionable to do so in the early twentieth century, he spent many years trying to prove the great antiquity of the earth, stating that it was...

GLSL Essentials (Community Experience Distilled)
GLSL Essentials (Community Experience Distilled)

Enrich your 3D scenes with the power of GLSL!

Overview

  • Learn about shaders in a step-by-step, interactive manner
  • Create stunning visual effects using vertex and fragment shaders
  • Simplify your CPU code and improve your overall performance with instanced drawing through the use...

Office 2003 XML for Power Users (Books for Professionals by Professionals)
Office 2003 XML for Power Users (Books for Professionals by Professionals)
SINCE ITS INTRODUCTION in the late 1990s, XML has revolutionized the way data is stored, manipulated, and shared. XML has made it possible for applications written in different programming languages (and running on different operating systems) to exchange any type of information. XML also allows different organizations to...
Designing Solutions for Microsoft SharePoint 2010: Making the right architecture and implementation decisions
Designing Solutions for Microsoft SharePoint 2010: Making the right architecture and implementation decisions

Microsoft® SharePoint® 2010 is the fourth incarnation of the popular collaboration and content management platform from Microsoft. With each release, the reach and capabilities of SharePoint products and technologies have grown, offering new tools to organizations and new opportunities to developers. With SharePoint 2010, you...

Wireless Security: Know It All
Wireless Security: Know It All
The latest technologies - the leading experts - proven real-world design solutions - together in one must-have volume!

The Newnes Know It All Series takes the best of what our authors have written to create hard-working desk references that will be an engineer's first port of call for key information, design techniques and
...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy