IBM Warehousing and DW 2.0

radiographerfictionData Management

Oct 31, 2013 (3 years and 9 months ago)

68 views

© 2008 IBM Corporation
IBM Warehousing and DW 2.0
Phil Downey
Program Manager InfoSphere Warehouse
October, 2008
2
Information Management Software
DW 2.0 is Dynamic Warehousing for IBM
Accelerating the Leveraging of Information
Dynamic
Warehousing
Traditional Data
Warehousing
OLAP & Data Mining
to Understand Why and
Recommend Future Action
Query & Reporting
to Understand
What Happened
Information On Demand
to Optimize Real-Time
Processes
Dynamic Warehousing Requires:
1. Real-time access – in context
2. Analytics – as part of a business process
3. Unstructured information – extracted knowledge
4. Extended infrastructure – tightly integrated
3
Information Management Software
Information On Demand
Unlocking the Business Value of Information for Competitive Advantage
Flexible Architecture for Leveraging Existing Investments
Optimization
Better Business
Outcomes
Automation
Establish accurate, trusted
information for a single version of
the truth, managed over time
Leverage information to better
understand and optimize
business performance
An efficient and solid foundation
for managing data and content
over its lifecycle
Customer & Product
Profitability
Workforce
Optimization
Dynamic
Supply Chain
Multi-Channel
Marketing
Financial
Risk Insight
Business Optimization
4
Information Management Software
Unlocking the Business Value of Information
Customer & Product
Profitability
Multi-channel
Marketing
Workforce
Optimization
Dynamic
Supply Chain
Financial
Risk Insight
Flexible Architecture
5
Information Management Software
Why Dynamic Warehousing and Enterprise MDM are inseparable
Multiform Master Data Management
Collaborate Operationalize Analyze
Party (Customer, citizen, prospect, organization, supplier, distributor, etc.)
Product (good, service, product bundle, catalogue, product component, etc.)
Account (Agreement, financial account, reward program, etc.)
Define, create and synchronize Master
Information
Deliver Master Information as a service
for business operations
Drive real time business
insight
Application-unique
Functionality & Data
Common
Functionality & Data
Application-unique
Functionality & Data
Common
Functionality & Data
Application-unique
Functionality & Data
Common
Functionality & Data
Application-unique
Functionality & Data
Common
Functionality & Data
Operational Business Applications
Real-time SOA data access
Operational
Data Usage
Application-unique
Functionality & Data
Common
Functionality & Data
Data Creators
Collaborative
Data Usage
Analytical
Data Usage
Data
Warehouse
Reporting &
Analytics
6
Information Management Software
Dynamic Warehousing and Information Management Lifecycle
 Ensuring your Master Data
Components provide the content you
need for your Industry
 Ensures that all aspects of your
Business information is in Sync
 Leveraging the IBM approach with
Dynamic Warehousing bringing
together Master Data Management
and Data Warehousing to provide a
complete approach to delivering the
analytical component of information
Lifecycle management
Information
Lifecycle
Management
Operational
Analytical
Collaborative
Banking Insurance Government Healthcare Retail Telco
7
Information Management Software
Why is it Important ?
Information Authors

Take feedback from Information the
Warehouse
• Require Analytics in their business
Processes
•Are measured through the warehouse
•Have Audit & Compliance requirements
Information Analysts

Create Analytical Applications/Views for all
Business Users
•Need to understand the information they
are analyzing
•Need to be able to effectively communicate
with Information Authors
•Have Audit & Compliance requirements
8
Information Management Software
What do I need to think about when building my warehouse ?
Warehouses are a Program’s of work not Projects !
Business
Requirements
Warehouse
Function
Warehouse
Operations
Business
Futures
Warehouse
Platform
Direct Impact
Influence
Re-evaluate
Regularly
9
Information Management Software
Without Method there is Madness ?
Planning
Business
Requirements
Analysis
Data
Analysis
Data
Modeling
Design
Construction
Test and
Load
Training
Project Manager
•Effective Communication
•Requirements
•Scope
•Dependencies
•Audit ability & Compliance !
10
Information Management Software
OLAP
Reports
Data marts
Conceptual or Physical
Warehouse
Data Integration
Source Systems
1 Analyze source systems for data structure, content, quality, and relationships
2
Map sources to reference Industry Model and glossary
3
Use Industry Models as basis to define logical data models for warehouse and marts
4
Generate physical models and deploy to InfoSphere Warehouse
5
Define specifications for moving data from sources to warehouse and to marts
6 Generate integration logic to move data into warehouse and into marts
7 Use Industry Models as basis for defining reporting requirements
8
Develop measure/dimension model and design reports
9 Trace lineage from report fields all the way to sources
10 Provide end-to-end data governance
1
2
3
4
5
6
7
8
9
10
11
Information Management Software
Cross-platform Integration:
Where does a field of data in this report come from?
Source Tables
IBM Information Server
 Import and Browse Cognos Report Metadata
 Navigate through report attributes
 Visually navigate through data lineage across tools
 Increases trust and understanding of business information
Metadata Workbench
12
Information Management Software
Consolidated Approaches are a reality if you choose the Right Approach and tools
Reduces management cost and accelerates access to business critical information
Extreme workload
management
Deliver real-time
insight to more users
and reduce costs,
without compromising
performance
No Copy Analytics
Integrated OLAP
cubing services
Enable deeper
analysis of multiple
business variables and
dimensions to
generate insight,
while reducing cost
Integrated unstructured
analytics
More easily leverage
previously untapped
information to better
understand customer
and product issues
Reach Farther. Look Deeper. Act Faster.
13
Information Management Software
InfoSphere Warehouse
Supporting Advanced Analytics
MPP Data Server
Analytical Acceleration
No Copy
Analytics
Advanced Design &
Management
Extreme Performance
C-Class D-Class E-Class Linux/
Windows
AIX/SUN/HP
Platform
Universal Access
Advanced
Capability
Portals & Web Apps Reporting Solutions MS Office / Share-point
On-line Analytical
Processing (OLAP)
Data Mining
Design Studio
Data Compression
Workload
Management
Data Retention
Remote Data
Access
Web Services
SQL/MDX
MDX
Text Analytics
Embedded Data
Movement
14
Information Management Software
Embedding Data Mining
Unlocking Associations and Behaviors trapped in your application
InfoSphere Data Mining embed real time data mining into
your warehouse, accessible from any application
supporting SQL or ODBO.
 Benefits
– InfoSphere Warehouse can help you unlock information on
customer and product associations and behaviors captured by
your application
 Business Value
– Combined with Text Analytics it provides you with the power to
build deep insight that could be critical to your customers
business
– Examples
• Market Basket Analysis
• Customer Behavior
• Click Stream Analysis
• Disease and treatment analysis
• Customer / Claim profiles
15
Information Management Software
Text Analytics
Increasing the Insight into your Applications Information
Benefits
 Enables your Application to target specific information hidden within text
 Provides you with a competitive edge by driving further business insight
 Drives a greater ROI for your Application
Business Value examples
 Better Product categorization
 Early warning on Customer attrition
 Fraud Detection
 Product Defect Analysis
 Better customer profiling
3
Many Applications today capture vital Product, Customer, Contract Claims information in their
applications but are unable to harness it to drive insight.
InfoSphere Warehouse Text Analytics can make this happen enabling you to derive new
attributes and Dimensionality from your information for further OLAP and Data Mining Analysis
16
Information Management Software
Ashley
Crane
STR/SAR List
VIN#222-222-356
VIN#222-222-356
Kwain Sun Kim
Vendor File
ACCT#564-088-300
ACCT#564-088-300
Mitch Conner
OFAC Watch List
EIN#667-009-008
EIN#667-009-008
Conner Mitchell
TIPOFF List
P.O. Box 567
P.O. Box 567
Relationship Resolution, “Who Knows Who”
Deep Identity
A “Timeless View”
 Who is the identity?
– Today
– Yesterday
– Who will they be tomorrow
Relationship Capabilities:
Multi-Attribute
New customers…..sharing P.O.
boxes, phone numbers or credit cards,
with banned customers
Employees…and conflicts of interest,
criminal associations, organizations
Exchange students…and shared
addresses or frequent flyer numbers
with terrorist suspects
Slip and fall victims …related to
employees, witnesses, doctors,
lawyers, former claimants or felons
Job applicants …at the same mail to
address as persons you have
previously fired
17
Information Management Software
Shortening the Time to Value
Lowering the cost of implementation and management
 The InfoSphere Balanced Warehouse is a
pre-built, pre-packaged Warehouse
Offering
– Reduces Risk
• Standard Pre-tested Configuration
• Ongoing Supported Package
• Predictable performance
– Reduces your Time to Value
• Create Table Ready
• Faster to Deploy
• Built for Performance
• Easy to Integrate into any environment
– Reduces Warehouse Cost of Ownership
• Automated Management
• Single Product Support
• System Built for Performance
– Configured for your Business
Requirements
• Can be ordered in a configuration to meet
Business requirements
• Modularly expandable
• Available in different sizes
The difference between receiving a ready to go system
versus one that needs to be fully or partially built on arrival
can be dramatic in terms of time to value and project risk.
That is why the InfoSphere Balanced Warehouse offering is
the best choice for your business.
InfoSphere Balanced Warehouse
18
Information Management Software
Building a Platform For Success
 Ensure You understand your Warehousing Business Vision
– Make sure your business understands it too
– Functional and Non Functional
 Ensure the solution you invest in is worth more than the sum of the
technologies you invest in
– Your investment must scale with your vision
– The components need to grow with you
 Without Method there is Madness
– Use your tools to help implement your method