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.)

WCDMA (UMTS) Deployment Handbook: Planning and Optimization Aspects
WCDMA (UMTS) Deployment Handbook: Planning and Optimization Aspects
A complete and practical guide to WCDMA/UMTS cellular network deployment.

After introducing the network architecture of such a system, the WCDMA (UMTS) Deployment Handbook defines the coverage and capacity concepts associated with the dimensioning and design phases. Progressing to a discussion of the main system parameters...

Amazon S3 Cookbook
Amazon S3 Cookbook

Over 30 hands-on recipes that will get you up and running with Amazon Simple Storage Service (S3) efficiently

About This Book

  • Learn how to store, manage, and access your data with AWS SDKs
  • Study the Amazon S3 pricing model and learn how to calculate costs by simulating practical...
Principles of Lasers
Principles of Lasers

This new Fifth Edition of Principles of Lasers incorporates corrections to the previous edition. The text’s essential mission remains the same: to provide a wide-ranging yet unified description of laser behavior, physics, technology, and current applications. Dr. Svelto emphasizes the physical rather than the mathematical...


Word 2013 Bible
Word 2013 Bible

Top-to-bottom coverage of the top-selling Microsoft Officeapplication

If you want to use Microsoft Word to create more than justsimple documents, start with this ultimate Word guide. Packed withthe in-depth content that is the hallmark of all Wiley Bibles, thisbook covers it all. You'll first find out what's new in...

Beginning Php 4 (Programmer to Programmer)
Beginning Php 4 (Programmer to Programmer)
PHP is a rapidly growing Web technology which enables web designers to build dynamic, interactive web applications, incorporating information from a host of databases, and including features such as e-mail integration and dynamically generated images. PHP4 added tons of features to make web application development even easier, and this book will...
Buying a Computer For Dummies
Buying a Computer For Dummies
Flat display? Satellite modem? What do YOU need?

Decide what you want your computer to do, and then pick the parts that get you there

If your top priority is cool multimedia, you have different computer needs from your pal who can't wait to play games online. Follow Dan's proven system, and you'll come out with the right stuff, buy...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy