HOME  |  SITE MAP  |  CONTACT US

  TECHNOLOGY - DATA WAREHOUSING
Overview | Hyperion Solutions | Microsoft | MicroStrategy | Data Warehousing | Portal Development
 
 

Dimensional Technologies is pleased to offer data warehousing solutions based on technologies from leading software vendors. Using our BIOSAAT™ methodology coupled with years of consulting experience, Dimensional Technologies data warehouse architects help companies manage their analytical requirements quickly and properly using well adapted data warehouse designs.

 

   
 

THE CLASSIC DATA WAREHOUSE SOLUTION
The classic data warehouse architecture delivers a single data source that serves as an enterprise information hub.  Data from all required sources is standardized and consolidated into a streamlined enterprise view of information.  Specific business requirements are then addressed using data mart and reporting technologies.  The following diagram depicts a sample architecture using the Classic Data Warehouse Solution. 

> Classic Data Warehouse Diagram

BENEFITS:

  • Standard enterprise view of information, shared across the entire organization.
  • Strategic repository of information for supporting future business requirements and projects.
  • Streamlined methodology and processes for data management.
  • Centralized information exchange between current and future systems.
  • Elimination of data redundancies and consolidation of data processing.
  • Extensible solution adaptable to changes in corporate technology direction.
     
 

THE DATA MART CENTRIC SOLUTION
The data mart centric architecture provides a standard methodology for the consolidation of information.  Data from required sources is prepared for consolidation using intermediate data sources.  Requirement driven data marts are consolidated by the information required for addressing specific business requirements.  The following diagram depicts a sample architecture using the Data Mart Centric Solution. 

> Data Mart Centric Diagram

BENEFITS:

  • Business requirements driven investment and tactical application of budgets.
  • Shorter time-to-market for project iterations.
  • Moderate impact from minor business requirement changes.
  • Flexible presentation of business entities and relationships, solving specific business needs.
  • Proven and understood implementation.
  • New or replacement technology platforms can be easily phased in. 
     
 

THE APPLICATION CENTRIC SOLUTION
The application centric architecture provides a standard approach for information access.  Data from required sources is prepared for consolidation using intermediate data sources.  Data driven data marts are created for enabling access to information.  Customized software applications consolidate the information required fro addressing specific business requirements.  The following diagram depicts the application centric architecture. 

> Application Centric Diagram

BENEFITS:

  • Straightforward processing and storage of information.
  • Highly flexible presentation of dissimilar information.
  • Supports information sharing and collaboration requirements.
  • Simple introduction of new data sources.
  • Limited impact from small changes in business requirements.
  • Reduced overhead of data storage support.
     

Please contact us for information about data warehouse solutions.
 

© 2006 Dimensional Technologies Inc. All rights reserved. Terms of Use