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