DWSA Rapid Warehouse Solutions Solution Requirements A Different Approach to Building a Data Warehouse RWS Architecture RWS Matrix Technology Features Value Proposition Metadata - Magic or Myth RWS Metadata RWS Unplugged Staging and Test Area Integration Transformation Architecture Transformation Process Our Architecture Our Capabilities Meeting Your Needs Take The Tour

Our Architecture

Non Proprietary Architecture

The DWSA Rapid Warehouse Solution toolset leverages the power of modern multi- tasking operating systems and advanced storage solutions to provide scalable data environments that can operate in near real time and provide rapid access to complex queries in business time.

ETL Strengths

ETL has full units of parallelism
Multi staged ETL developed as one process
- Implemented as different streams
  - SAS
  - Utilities
  - SQL
  - C ⁄ Cobol
Sophisticated high speed pattern matching
- Matrix Input Loader
- Generic Data Conversion Module
- Saves tens of thousands of lines of code
Generated code is error free
- Metadata driven
- End to end – including warehouse definition

Elements of Compatibility

STORAGE
- Disk ⁄ tape ⁄ CD-rom
- Appear as RDBMS views
- Low cost storage
- Suitable for transactional histories
DATA ARCHITECTURE
- Normalised data models
- Star Schemas
- Snowflake Schemas
DATA STORAGE
- Mix and match capability
- Oracle ⁄ DB2 ⁄ Teradata⁄SAS
- Native file systems