|
|
 |
|
MetaCensus® - Our Philosophy
The Warehouse Component Triangle
|
MetaCensus integrates and balances three crucial components of a successful Data warehouse: Physical Implementation, Logical Model and Metadata. Before MetaCensus, these components were disparate.
Physical Implementation - the engine behind a warehouse, Teradata can only be as good
as the Physical Data Model put in place. A good PDM is universal and leverages the
Teradata architecture to maximize efficiency. Frequently, what is intuitive to the
users may have serious performance implications and thus merit a more complicated
implementation.
Logical Model - the brain behind the business, an enterprise model strives to
communicate, in technological terms, how a business conducts its day-to-day
operations and how it plans for the future. A truly enterprise-wide model
oftentimes spans so many business areas and relevant detail that it becomes
nearly impossible to explain such complexity to the users.
|
|
|
Metadata - the roadmap to the warehouse, metadata is used to describe
any information collected regarding the warehouse. The challenge soon becomes
determining the relevant metadata and providing and effective delivery mechanism
to the users. Too often, however, metadata is presented in a detached manner
from the technology and loses all relevance and thus effectiveness.
MetaCensus - The art of warehousing strives for a true balance between the
above components. A perfectly normalized model almost always interferes
with quick access and application delivery and thus requires a level of give
and take. As both the model and Teradata evolve, complexity facing the users
increases exponentially. In order to simplify this complexity, metadata must
become succinct and meaningful; not necessarily abundant. The management and
balance of these components can become a monumental effort for the warehouse,
frequently resulting in scenarios where efforts are directed towards maintaining
the warehouse instead of using it. MetaCensus is the only Teradata-specific
solution that consolidates these elements to present a truly unified view of a
warehouse.
Continue for MetaCensus History.
|
|
|
