WhereScape RED White Papers

Data Warehouse Prototyping - Reducing Risk, Securing Commitment and Improving Project Governance

(Marc Demarest, WhereScape)

Marc Demarest looks at how to more effectively manage both the hard (requirements, budgets) and soft (user perception, internal politics) aspects of complicated data warehouse projects through the use of data driven prototyping. 

> Download ../Downloads/IDC WhereScape Paper.pdfData Warehouse Prototyping

Support the Changing Business Needs for Business Intelligence and Performance Management Through Data Warehouse Lifecycle Management

In this white paper IDC describes the latest trends in the business analytics market which includes both data warehousing and business intelligence.  It highlights the challenges faced by IT or information management departments in addressing the ever changing decision support needs of business users.  Furthermore, it introduces WhereScape Software as a provider of DW lifecycle management software, and summarizes the experiences of two organizations with WhereScape RED software.

> Download ../Downloads/IDC WhereScape Paper.pdfIDC WhereScape White Paper

WhereScape RED builds data warehouses, fast.

WhereScape RED is an Integrated Development Environment (IDE) specifically designed for data warehousing.  Unlike traditional IDEs, WhereScape RED includes support for the entire data warehouse lifecycle.  It enables developers to prototype, build and enhance data warehouses ten to one hundred times faster than any other available software. Read about how our software can deliver fast results to your data warehouse problem.

> Download ../Downloads/How_WS_RED_is_Fast[1].pdfWhereScape RED Fast

> Download ../Downloads/The_Dimensions_of_Fast[1].pdfDimensions of Fast

Understanding the Data Warehouse Lifecycle Model

(Marc Demarest, WhereScape)

Describes the common problems associated with data warehouse projects when they do not use a lifecycle model approach to development and implementation.

> Download ../Downloads/wherescape_dwlm[2].pdfLife Cycle

The WhereScape Pragmatic Data Warehousing Methodology:

WhereScape RED is a data warehouse specific Integrated Development Environment (IDE) that encourages the use of a methodology. A standard approach speeds up delivery, and a consistent implementation assists with support and speeds up enhancements.
This paper describes in summary fashion the models, methods and processes that make up the essence of WhereScape's Pragmatic Data Warehousing™ methodology as practiced by WhereScape designers and as implemented in the WhereScape RED data warehouse Integrated Development Environment. This methodology is gently suggested in WhereScape RED, but can be subjugated by other approaches if preferred.

> Download ../Downloads/pragmatic_data_warehousing[1].pdfPragmatic Data Warehousing

WhereScape RED Architectural Overview

WhereScape RED is an Integrated Development Environment for development data warehouses.  This paper provides an overview of the different WhereScape RED components.

> Download ../Downloads/Adding_OLAP[1].pdfArchitectural Overview

Adding OLAP to your data warehouse using WhereScape RED

(Douglas Barrett, WhereScape)

The benefits, the features and the architecture of adding OLAP cubes to your data warehouse using WhereScape RED.

> Download ../Downloads/Adding_OLAP[1].pdfAdding OLAP

One Size Does Not Fit All

(Adrian Jurke, Independent)

Why data warehouse developers need their own tools to publish data to business users faster.

> Download ../Downloads/One_Size_Does_Not_Fit_All[1].pdfOne Size Does Not Fit All

Handling Changed Data

(Ken Taylor, WhereScape)

This article examines the data load and processing approaches to handle changing data on the source systems.

> Download ../Downloads/Handling_Changed_Data[1].pdfHandling Changed Data

Second Tier Tables deliver big Data Warehouse ROI

(Vincent P. Donovan, Arkadia International Consulting)
Discusses how to deliver the analysis that business users want, and that (well designed) single level fact tables can not easily provide.

> Download ../Downloads/second_tier_fact_tables.pdfSecond Tier Tables

The Value of the Prototype

(David Morris, WhereScape)

Prototyping significantly reduces the risk that your data warehouse will fail by aligning data warehouse design and user expectations.

> Download ../Downloads/Value_of_the_Prototype[1].pdfPrototype

Does One Size Fit All?

(Wayne M. Richmond, WhereScape)

Discusses how data warehouse practitioners must question the techniques and tools that they use to deliver the best data warehouse for the needs of their users.

> Download ../Downloads/Does_One_Size_Fit_All[1].pdfDoes One Size Fit All?