eBook By Category (Data Warehouse)

Aimed at helping business and IT managers clearly communicate with each other, this helpful book addresses concerns straight-on and provides practical methods to building a collaborative data warehouse

You?ll get clear explanations of the goals and objectives of each stage of the data warehouse lifecycle while learning the roles that both business managers and technicians play at each stage

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it

Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice

The RDBMS used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later

As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product

While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoretically sound, is not especially easy

That?

The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects Covers advanced topics, including data monitoring and testing Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

User review
Provides basic generic advice
As other reviers have mentioned, this book covers wide, but not that deep

Like many books, it gives advice so generic as to be useless, but an easy to understand overview has its importance too, so perhaps this is a good place to start



So you will see the basic problems of combining data from different sources into one place, but not necessarily how to do it

The data warehousing bible updated for the new millennium
Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing `bible` provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses

Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques



User review
Provides basic generic advice
As other reviers have mentioned, this book covers wide, but not that deep

The official guide to programming with the revolutionary data-sharing technology
The Common Warehouse Metamodel (CWM) is the new OMG standard that makes the sharing of data seamless

The CWM standard development team provides developers with a complete overview of what CWM is and how it works

After acquainting readers with the CWM architecture and how each CWM component fits into existing database and data warehouse architectures, the authors provide expert guidance on how to plan for, implement, and deploy CWM technologies

Data warehouses and online analytical processing (OLAP) are emerging key technologies for enterprise decision support systems

They provide sophisticated technologies from data integration, data collection and retrieval, query optimization, and data analysis to advanced user interfaces

New research and technological achievements in the area of data warehousing are implemented in commercial database management systems, and organizations are developing data warehouse systems into their information system infrastructures

Through dozens of case studies and real-world examples, this clearly written guide shows telecommunications managers how to build more effective data warehouses without wasting time and money on impractical, untenable approaches

The book provides practical, step-by-step instructions on how to engineer and implement a warehouse/mining strategy that reduces costs, maximizes profits, and supports long-term corporate goals Pub: 8/97



User review
Entertaining and singular perspective of DW/DM in Telecoms
Hello Amazon,

The author, who has written extentsively on the subjects of DW and DM is also associated with Sequent Computer Systems, a respected manufacturer and vendor of high-end Enterprise Data Centers, and a highly experienced player in the DW, CRM, DSS space

This book constitutes the refereed proceedings of the 10th International Conference on Data Warehousing and Knowledge Discovery, DaWak 2008, held in Turin, Italy, in September 2008

The 40 revised full papers presented were carefully reviewed and selected from 143 submissions

The papers are organized in topical sections on conceptual design and modeling, olap and cube processing, distributed data warehouse, data privacy in data warehouse, data warehouse and data mining, clustering, mining data streams, classification, text mining and taxonomy, machine learning techniques, and data mining applications

Data warehousing is one of the hottest business topics, and there?s more to understanding data warehousing technologies than you might think

Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition

Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses

Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance

They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations

Presents a thorough overview of today's best solutions, & a reliable step-by-step process for building warehouses that meet their objectives

CD-ROM included



User review
Great introduction for technical and non-technical readers
This is a good introduction to data warehousing for business process owners, project managers and service delivery and support professionals

Data warehousing is about transforming the data which an organization possesses and turning it into information of strategic significance

Data Warehousing explores the most pressing issue in business today ? the means to improve strategic decision making

At 70 terabytes and growing, Wal-Mart's data warehouse is still the world's largest, most ambitious, and arguably most successful commercial database

Written by one of the key figures in its design and construction, Data Warehousing: Using the Wal-Mart Model gives you an insider's view of this enormous project

Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization's own data warehouse project, however large or small

Data Warehousing has been around for 20 years and has become part of the information technology infrastructure

Data warehousing originally grew in response to the corporate need for information--not data--and it supplies integrated, granular, and historical data to the corporation



There are many kinds of data warehouses, in large part due to evolution and different paths of software and hardware vendors

Data Warehousing and Mining (DWM) is the science of managing and analyzing large datasets and discovering novel patterns and in recent years has emerged as a particularly exciting and industrially relevant area of research

Prodigious amounts of data are now being generated in domains as diverse as market research, functional genomics and pharmaceuticals; intelligently analyzing these data, with the aim of answering crucial questions and helping make informed decisions, is the challenge that lies ahead

The Encyclopedia of Data Warehousing and Mining provides a comprehensive, critical and descriptive examination of concepts, issues, trends, and challenges in this rapidly expanding field of data warehousing and mining (DWM)

* Reviews planning and designing architecture and implementing the data warehouse


* Includes discussions on how and why to apply IBM tools


* Offers tips, tricks, and workarounds to ensure maximum performance

This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

User review
So, you want to make your data warehouse queries run faster?
This book answers the question of how can I make my data warehouse queries run faster

There is no magic to this, just pre-compute the data that you want to query and store that in your data warehouse

* A cutting-edge response to Ralph Kimball's challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing
* Written by one of the best-known exponents of the Bill Inmon approach to data warehousing
* Addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems
* Weighs the pros and cons of relational vs

dimensional modeling techniques
* Focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality

User review
Excellent guide to implementation
While I have read a lot of books on this topic, this one goes above and beyond all

The emphasis on the practical aspects of how to implement a data warehouse was extremely useful, since all the steps are clearly laid out

Most of modern enterprises, institutions, and organizations rely on knowledge-based management systems

In these systems, knowledge is gained from data analysis

Nowadays, knowledge-based management systems include data warehouses as their core components

Strategic Data Warehousing: Achieving Alignment with Business provides an integrated approach to achieving successful and sustainable alignment of data warehouses and business goals

It details the roles and responsibilities of the data warehouse and business managers in achieving strategic alignment, technical integration, and improved flexibility

  Complete with case studies depicting real-world scenarios, the text examines the organizational, user, data, and technological factors proven to promote successful data warehousing, provides actionable solutions for achieving strategic alignment, and includes a model that readers can apply in aligning their own data warehouse needs and business goals

Single most authoritative guide from the inventor of the technique


* Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance


* Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate

This groundbreaking book is the first in the Kimball Toolkit series to be product-specific

Microsoft?s BI toolset has undergone significant changes in the SQL Server 2005 development cycle