E104 Enterprise Data Warehouse Reference Architecture - PowerPoint PPT Presentation

Loading...

PPT – E104 Enterprise Data Warehouse Reference Architecture PowerPoint presentation | free to download - id: f35be-MTg0Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

E104 Enterprise Data Warehouse Reference Architecture

Description:

Business Intelligence, Data Warehousing Market. Enterprise Data Warehouse ... Sybase and Sun have demonstrated technical acumen that increases business value. ... – PowerPoint PPT presentation

Number of Views:1008
Avg rating:3.0/5.0
Slides: 21
Provided by: Kar9252
Learn more at: http://download.sybase.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: E104 Enterprise Data Warehouse Reference Architecture


1
E104Enterprise Data Warehouse Reference
Architecture
  • A.J. Mahajan, Dan Nissenbaum
  • Sun Microsystems, Inc.
  • aj.mahajan_at_sun.com
  • dan.nissenbaum_at_sun.com

2
Agenda
  • Business Intelligence, Data Warehousing Market
  • Enterprise Data Warehouse Reference Architecture
  • Customer Benefits
  • Summary

3
Understanding BIDW
Data Warehouse
BIDW
Data Integration
Enterprise Data
Data Mart
Data Mining
Reporting
Analysis
Customer Service
Predictive Modeling
ETL
Data Cleansing
Marketing
Meta Data
Portal
Inventory
OLAP
Shipping/ Distribution
Billings/AR
Where...?
Manufac- turing
What ....?
How..?
Which...?
Who..?
If..., then...?
General Ledger
When ....?
Whom.?
Business Decisions
Users
4
Understanding BIDW
5
Enterprise BIDW Market
  • DW/BI Market (USbillions, Source IDC)
  • 2000 2005
  • Servers 8.6 12.2 (30 is large DW)
  • Software 6.4 16.6
  • Services 4.5 10.9
  • Storage 6.5 9.1
  • Trends
  • Enterprise applications are generating data at a
    very fast rate
  • Time windows to collect/integrate/analyze/act on
    this data are shrinking rapidly
  • Fast implementation, continuous scalability, ease
    of management and lower TCO are becoming more
    important
  • In current slowing economy, BIDW market is still
    strong

6
Sun's BIDW Industry Leadership
  • Sun leads in the largest BIDW server market
    segment (UNIX servers)
  • BIDW Reference Architecture Program
  • Global Alliances with Leading BIDW Independent
    Software Vendors (ISVs) and Systems Integrators
  • World Record Industry Benchmarks
  • Best Performance with Leading BIDW ISVs
  • iForce BIDW Global Competency Center, Menlo Park

7
iForce Ready Centers
  • Menlo Park Competency Centers
  • Business Intelligence Data Warehousing
  • Customer Relationship Management (CRM)
  • Exchanges/Portals
  • i2
  • Sun ONE
  • PeopleSoft
  • Supply Chain Management (SCM)
  • SAP
  • Oracle Applications (SOATC)

8
BIDW Reference Architecture Program
  • Program Goals
  • Sun and leading 3rd party software and hardware
    providers offer reference architecture solution
    sets for customers, consisting of jointly
    designed, integrated, tested, tuned and
    documented high quality products and services.
  • Provides a recommended solution targeted _at_
    selected markets, allowing choice for the
    customers
  • Introduced Enterprise Data Integration Reference
    Architecture in May 2001
  • Introduced Enterprise Data Warehouse Reference
    Architecture in November 2001
  • Introduced Enterprise Business Intelligence
    Reference Architecture in May 2002

9
(No Transcript)
10
Sun is Providing Customers With...
  • Better integrated DW/BI infrastructure solutions
  • Rapid deployment
  • Ease of management
  • Minimize Risk
  • Appropriately sized
  • Can scale as amount of data and number of users
    grow without re-architecting
  • Improved availability
  • Investment Protection
  • Best-of-breed products and solution providers
  • Do more with less money and resources lower TCO

11
Enterprise Data Warehouse Reference Architecture
Available for testing and demo in iForce Centers
12
Enterprise Data Warehouse Reference
Architecture Advantages
  • Dramatically Lower Total Cost of Ownership
  • 80 reduction in storage needs
  • Highly efficient CPU utilization
  • High Performance
  • Up to 1000X improvement in query speed, data
    loads
  • Scalability and Availability
  • 95 linear scalability, fail over features
  • SPARC/Solaris platform designed for massive
    scalability and data-center reliability 1-100
    processors in a single-node
  • Flexibility
  • Burst capacities and long-term growth path
  • Cross-generation server/storage compatibility

13
Customer Feedback
The big advantage of the Reference Architecture
work, done by Sun and Sybase, is that it provides
the advance knowledge that this solution will
work. It also demonstrates the critical aspects
of ease of deployment, performance, scalability,
and storage cost economy. Reference Architectures
are a real boon to IT managers who are
considering solutions for a specific business
problem... - Kim Ross, CIO, Nielsen
Media Research
14
Industry Analyst Opinion
  • "Data warehousing is an exercise in tradeoffs to
    take one example, the sheer size of the data
    warehouse the terabytes of disk space it
    consumes often impacts the speed at which the
    data can be refreshed and analyzed. By improving
    analytical speed while saving disk space, Sybase
    and Sun have demonstrated technical acumen that
    increases business value. Their customers can now
    not only save money through lower cost of
    ownership, but can also tackle very large
    analytical problems. Put simply, their customers
    are getting more analysis for less money a
    winning combination."
  • Guy Creese, Director, Aberdeen Group

15
Industry Analyst Opinion
"The Sybase and Sun data warehouse reference
architecture offers unique value to companies
looking to build a high-end data warehouse by
making data warehouse projects much less risky.
Given that these projects often cost millions of
dollars in hardware, software and consulting,
this is a major benefit. The reference
architecture reduces risk because it provides a
proven blueprint to build upon, and it reduces
cost because it saves on storage requirements as
well as design and implementation time ." -
David McGoveran, Director, Alternative
Technologies
16
Industry Analyst Opinion
  • "The Sun/Sybase partnership represents a
    significant third player in VLDB along with
    Teradata and IBM. Sun's storage and server
    advantages along with Sybase IQ Multiplex's
    database advantages represent a good fit for this
    market"
  • Wayne Eckerson, Director, The Data Warehousing
    Institute (TDWI)

17
EDWRA Customers
  • Nielsen Media Research
  • Samsung Life Insurance
  • American Airlines
  • Internal Revenue Service
  • C-Net
  • Bank of Montreal
  • Vodafone/Airtel
  • PRC Taxation Office
  • Dresdner Bank
  • SNCF
  • Avis

Sun/Sybase IQ 500 Joint Customers
18
Proof of Concept
  • Available in the Menlo Park iForce Ready Center
  • Over 150 CPUs, 25 TB of usable storage
    (equivalent to 80-200 TB of storage with
    traditional DW DBMS), DW experts/specialists
  • Customers can visit/call for
  • Demonstration of the solution
  • Test and size to
  • Customers unique workload requirements
  • With their own business model and data

19
EDWRA Support, Consulting and Education
  • Deliver best practices, quick implementation
  • Sun and Sybase Assessment, planning, design,
    integration, tuning, migration and training
    workshop
  • Customer training and education
  • Core classes for the basic deployment
  • Optional classes for extended capabilities
  • Sybase is in Sun's Vendor Integration Program
    (SunVIP) for seamless cooperative support

20
Summary
A highend data warehouse reference
architecture Capable of dramatic increases in
scalability over 1000 nodes, 100,000 processors,
petabytes of storage High-performance query
speeds up to 1000x faster Significant storage
savings Radically reduces TCO Consulting services
for ease of integration and management Allows
enterprises to focus on their core competencies
About PowerShow.com