Home Consulting Events Contact us
9sight Logo

9sight Publications

Beyond the Data Warehouse, A Unified Information Store for Data and Content, May 2010
Sponsored by Attivio, Inc.

The worlds of data and content are on a collision course! With ever-growing hordes of content gathering in the business and on the Internet, the old civilization of the data warehouse is under siege. But, never fear! A solution is emerging—the outcome will be integration, not annihilation.

Based on over twenty years of information architecture experience from data warehousing, this paper first shows data and content as two ends of a continuum of the same business information asset and explores the depth of integration required for full business value.

We then define a unified information store (UIS) architecture as the approach to unification. The heart of this store is a core set of business information, indexes and metadata, originating from up-front enterprise modeling and text analytics of information when loaded and at the point of use, which ensure both data quality and agility. The business outcome is analytics that combine the precision of data querying with the relevance of content search, independent of the information source and structure.

Software vendors from both viewpoints—data and content—are already delivering products that blend the two worlds. Businesses that begin to implement a unified information store stand to gain early adopter advantage in this rapidly growing market.

Business Integrated Insight BI2, Reinventing enterprise information management, August 2009
Sponsored by Teradata Corporation

"Le Roi est mort. Vive le Roi!" The message of this paper is at one with this ancient proclamation: the rule of the king continues through the end of one era and the beginning of the next. The data warehouse has had a long and illustrious reign, but today a combination of business and technological change has laid the old king low. But, fear not! The young prince stands strong at his father’s bedside, ready to lead the kingdom to new victories.

This paper proposes a new architectural model for decision-making in all its guises throughout the enterprise. The new model, Business Integrated Insight (BI2), emerges directly from re-evaluating decision-making in a 21st-century business, and reviewing recent technological advances in databases, messaging, and social computing. The message is one of technology evolution, rather than revolution—current data warehouse technologies, particularly dedicated implementations, will play a central role in the new order.

We begin with a review of the prevailing business and IT paradigms from which the original data warehouse architecture emerged and evolved in the 1980s and 1990s and the problems it now faces. Section two makes the case for a new approach, and proposes five new postulates for the future. In section three, we describe the BI2 architecture, leading to a number of use cases and key considerations for implementation in section four. The final section summarizes the paper’s main points.

Collaborative Analytics, Sharing and Harvesting Analytic Insights across the Business, June 2009
Sponsored by Lyzasoft Inc.

Business analysts are, by tradition, hunter-gatherers. Independently or in small, close-knit groups, they stalk the wild data resources of the business, seeking out new and unusual facts, and building from them deep insights into the meaning of business life and events. Armed with little more than their spreadsheets, they single-handedly recalculate cells and pivot tables in search of that “ah-ha” moment when innovation emerges from its lair.

Meanwhile, IT labors hard, and often at great cost, to provide a quality-assured, comprehensive and integrated warehouse of information as the basis for corporate reporting and planning. This valuable data resource often lies ignored or distrusted by pioneering business analysts. Today’s business cannot afford the luxury of this disconnect.

This paper examines the sources of this unfortunate division and introduces the adaptive information cycle, a model that links the center-out approach of traditional data warehousing to the edge-based, emergent prototyping that characterizes today’s analytic environment. By combining concepts from integrated development environments, social networking and collaborative working, the adaptive information cycle reunites Business Intelligence and Business Analytics.

Beyond the conceptual level, Lyza™ Commons shows the real functionality needed to allow business analysts to collaborate more closely and to enable IT to harvest the fruits of their innovation for the wider user community.

Analytic Databases in the World of the Data Warehouse, BI ThoughtLeaderTM by ParAccel, April 2009

The majority of companies have implemented their business intelligence (BI) environments according to a physically layered data warehouse architecture and based on traditional general-purpose relational databases.

Specialized analytic databases using technologies such as columnar orienta-tion, massively parallel processing and other techniques have now emerged. Such new DBMSs now offer significantly improved performance for typical BI applications, enable previously impossible analyses and often lower cost implementation.

They also have the potential to challenge the current physically layered Data Warehouse architecture. This paper reexamines the trade-offs that have been made in the layered architecture and argues that analytical databases may enable a move to a simpler non-layered architecture with significant benefits in terms of lower costs of implementation, maintenance, and use.

Playmarts: Agility with Control, Reconnecting Business Analysts to the Data Warehouse, December 2008
Sponsored by Lyzasoft Inc.

One key group of potential users of Business Intelligence tools and Data Warehouse data has been seriously underserved for many years. These power business analysts resort to a mish¬mash of desktop productivity tools to support them in their search for innovative answers in the ever-growing jungles of enterprise data. IT departments trying to keep control of the corporate data asset through the data warehouse architecture denounce the “spreadmarts” thus created. Indeed, business analysts themselves also often wish that there was a better way.

This paper introduces a new category of data mart—the “playmart”—to address the needs of both business analysts and IT. In essence, a playmart provides agility for users through freeform, iterative exploration of data from multiple sources (playing with the data) in a safe, controlled and traceable environment (a mart). The goal, simply, is to provide users the freedom to innovate, while maintaining corporate auditability; to find unique business value in enterprise data and to ensure it is valid and repeatable when needed.

The playmart is more than a concept, however. A new tool—Lyza™—provides a significant first set of the functionality that the playmart requires.

Previous Work

Barry wrote the first published article describing a data warehouse architecture in 1988, based on his work in IBM Europe's internal IT division in the preceding years.

DW Book

One the seminal books on data warehousing, Barry's 1997 book contains a wealth of architectural and practical information. It continues to be relevant today and has sold over 10,000 copies.

In recent years, Barry has written a number of series of White Papers for IBM on the emergence of new trends in collaborative computing and the emergence of Service Oriented Architecture (SOA), with particular emphasis on the implications for how IT will support business in the future.

Barry is a regular contributer to the UK edition of B-Eye Network where he blogs regularly. The following series of papers can be found on his Articles Page:

  • “Business Intelligence is Dead – Long Live the Highly Evolved Business”, 3-part series, 2007
  • “Web 2.0 and the Highly Evolved Business”, 3-part series, 2007
  • “Intelligent Integration Depends on Business Intelligence”, 4-part series, 2008

Previous publications include:




Website and all content © Copyright 9sight Consulting 2008-09