slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehouse Development Automation WhereScape RED PowerPoint Presentation
Download Presentation
Data Warehouse Development Automation WhereScape RED

Loading in 2 Seconds...

play fullscreen
1 / 10

Data Warehouse Development Automation WhereScape RED - PowerPoint PPT Presentation


  • 277 Views
  • Uploaded on

Data Warehouse Development Automation WhereScape RED. How data warehouse automation reduces the manual effort, time and cost of building and maintaining a data warehouse. Data Warehouse Automation. Data Warehouse Automation. Model Automation Rules based approach to design

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Data Warehouse Development Automation WhereScape RED


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1
Data Warehouse

Development Automation

WhereScape RED

How data warehouse automation reduces the manual effort, time and cost of building and maintaining a data warehouse.

data warehouse automation
Data Warehouse Automation
  • Model Automation
    • Rules based approach to design
    • Input: source model
    • Output: target model
  • Development Automation
    • Meta data driven development
      • Code generation
      • Table / Indexes
      • Documentation
demonstration 3d
Demonstration 3D
  • Showing:
    • Reverse engineer
    • Profile
    • Test data
    • Derive
  • Not :
    • Documentation
    • 3D-RED Integration
slide5

WhereScape RED

A data warehouse automation IDE

develop, refine, document, promote, operate, support and enhance

  • Results :
  • Saves time & money
  • Enables agile development
    • Iterations
    • Collaboration
  • Reduces risk
  • High quality development
  • Promotes in-house development
  • Lower TCO – manages complete lifecycle
dw development automation
DW development Automation

Built in management framework

Fast development speed

Metadata

Leverage skills

Consistency

Best Practices

Documentation

Scheduler

Low cost of change

an agile platform
An Agile platform
  • Automation enables agile projects
  • Build deployable data marts (or parts) rapidly and get in front of users - Automation
    • data and requirements exploration
    • prototype and iterate
    • workshops
  • Design Approach – requires iterations:
    • Data driven design
    • Model driven design
slide8

Agile Processing Architecture

Sales

Data xforms Business xforms

Financials

A-TV-DS

LDD

JMS

Assets

Agile

Static

Sources Foundation Data Marts

demonstration red
Demonstration RED
  • Showing:
    • Build a data mart from scratch
    • Documentation
    • Workflow
    • OLAP Cubes
  • Not :
    • Complexity
    • Multi-step operations
    • Data volumes
    • (there’s just not enough time)
slide10

Questions

  • ?
  • douglas.barrett@wherescape.com