Data Management Future Direction

1
Data Management Future Direction Roadmap
Naveen Puttagunta Senior Product
Manager 925-236-4884 Naveen.Puttagunta_at_sybase.com
2
AGENDA

• Overview
• ASE 12.5 Product Family
• New Data Management Services
• Real Time Data Services
• Dynamic Archiving
• Auditing Services
• Future Direction and Roadmap

3
ENTERPRISE DATA MANAGEMENTTodays IT Focus
Total Cost of Operations
Impacts on TCO
Operational Constraints

• Application Development
• Rapidly Evolving Business Models
• Multiple Development Options (XML, Java, SQL)
• New Legislative Requirements
• Data Management Operations
• Higher Data Availability
• More Data Online
• Growing Data Sizes
• Platform Infrastructure
• Cost Pressures
• Business Continuity

• Scarcity of Skills
• Time-to-Market
• Budget

4
THE OPERATIONAL GAP
More Data, More Transactions, Limited Resources
5
SYBASE ASE TCO Leader in Enterprise Data
Management
Based on our analysis of thousands of
applications, the total life-cycle cost of most
RDBMS applications will be, on average, more than
15 percent lower when running on Sybase ASE
versus the equivalent offering from Oracle
Corporation
- Standish Group, 2003
6
ASE DIRECTION
From Enterprise Data Server to a Data Management
Platform for the Unwired Enterprise
Application Development Costs
Web Architecture
Service Oriented Architecture
Web Services XML
Database Operational Costs
Integrated Data Delivery
Self- Management
Virtualized Data Services
Lower Cost Platforms
Provisioning
Grid Computing
ASE 12.5.1 Key Technologies
Future ASE Technologies
TCO Components
7
Sybase ASE 12.5 Family Overview
12.5.0.3
12.5.0.1
12.5

• Security
• Secure Sockets Layer
• Row based access controls
• Performance
• New Page Sizes 4K, 8K 16K pages
• Dynamic Tuning
• Availability
• Additional HA Cluster Support
• Compressed Backups
• Enhanced QuiesceDB
• Application Development
• Fast EJBs
• XML Indexing
• Access to External File System

• Availability
• ASE Replicator (built-in Replication)
• Enhanced HA
• Migration
• Migration Tools
• Application Development
• JVM XML Enhancements

• Administration
• DB-Xray
• Sampling based Statistics
• Migration
• PowerTransfer Migration Utility
• Availability
• Sun Clusters Active/Passive

8
SYBASE ASE 12.5.x DESIGN FOCUS
Higher Operational Scalability
Reduced Human Intervention
Lowering the Cost of Applications

• Simplified administration tasks
• Simpler skill sets
• Fewer user errors
• Reduced planned downtime

• Improved Developer Productivity

• Reduced learning curve
• Less coding
• Easily expose data as a service

Improved System Performance
Lower Hardware Costs

• More Throughput with Less H/W
• Manage more data and transactions
• Transition to Low Cost hardware while maintaining
  performance

Lowest TCO
9
ASE 12.5.1 12.5.2 FOCUS FEATURES
Higher Operational Scalability
Reduced Human Intervention

• Administration Improvements
• DBA Developer Tools
• Self Management
• Security Availability

Lowering the Cost of Developing Applications
Improved Developer Productivity
Improved System Performance

• Web Services
• Enhanced XML
• Derived Tables
• Globalization Enhancements
• Messaging Services

Lower Hardware Costs

• TempDB Enhancements
• I/O Enhancements
• Faster Maintenance Operations
• Linux Performance Support
• Statement Cache

Lowest TCO
Improved In ASE 12.5.2!
10
REAL TIME DATA SERVICES
11
HOW SYBASE DELIVERS REAL-TIME SERVICES

• Sybase RTDS
• Unwired Orchestrator

12
WHY REAL-TIME SERVICES
A Major Ratings Institution When ratings change,
proactively send information to Web
applications Problem Stale Data Customer
Satisfaction Affected
A Major Bank When a loan closes with
deficiencies, proactively send information to
downstream applications Problem Delayed
Actions Increased Inefficiencies
A Government Institution When a passport is
reported stolen or lost, proactively send
information out to border security, airport
security and police. Problem Limited
Awareness Increased Risk
13
HOW ARE REAL-TIME DATA SERVICES DELIVERED TODAY
Custom Applications -- Complex, Intrusive Costly
Messaging Architectures Share Information Among
Multiple Applications in real time
Customer Relationship Management
MESSAGE BUS
Real Time Fraud Detection
Custom Applications

• New code required to connect databases and
  applications to message bus
• Polling is intrusive and slows down the database

14
HOW WILL SYBASE REAL-TIME DATA SERVICES SOLUTION
HELP
Sybase RTDS Simple, Non-intrusive and Code Free
Messaging Architectures Share Information Among
Multiple Applications in real time
Customer Relationship Management
SYBASE RTDS
MESSAGE BUS
Real Time Fraud Detection
Legacy Applications

• No custom coding required to connect to message
  bus
• Eliminates need for polling.
• Proactive and non-intrusive

15
ENABLING EXISTING APPLICATIONS
Any Database to Any Message Bus

• Capabilities
• Non-intrusive
• Heterogeneous Sources
• Heterogeneous Message Bus
• No Custom Coding

ORDER ENTRY
SYBASE
SYBASE RTDS
JMS, MQSERIES, TIBCO
BILLING
DB2

• Benefits
• Eliminate polling applications, reduce cost
• Be proactively notified when changes happen,
  without coding
• Zero impact on existing applications
• Enable multiple applications

Rep Server
INVENTORY
Rep Connector
ORACLE
16
EMPOWERING NEW APPLICATIONS
ASE to JMS Natively

• Capabilities
• Leverage existing triggers
• Push events from within client apps
• Bi-directional

JMS
SYBASE RTDS

• Benefits
• Use SQL to generate events
• Applications developers dont need to learn yet
  another API
• High Performance message delivery and archiving

ASE 12.5.2
17
BRIDGING TO APPS AND PROCESSES
ORDER ENTRY
SYBASE
SYBASE RTDS

• Rich Enrichment and Routing
• Process Management
• Interfaces to Application API

BILLING
DB2
Rep Server
INVENTORY
Rep Connector
ORACLE
JMS, MQSERIES, TIBCO
Integration Orchestrator
JMS, MQSERIES, TIBCO
ASE 12.5.2
18
SYBASE REAL-TIME DATA SERVICES THE BIG PICTURE

• Applications, Processes and People get notified
  when an event occurs
• End to end Visibility From Enterprise
  Applications to Mobile Devices
• Relevant, enriched information, to the right
  people for faster decisions

Customer Relationship Management
ORDER ENTRY
SYBASE
Real Time Fraud Detection
MESSAGE BUS
BILLING
SYBASE RTDS
DB2
MESSAGE BUS
Integration Orchestrator
Real Time Sales Force Automation
Q ANYWHERE
INVENTORY
ORACLE
Real Time Notifications
Capture data events from heterogeneous data
sources
Events can be enriched with no impact to
operational systems
Standardize and distribute data events via
message bus/mobile devices without custom coding
19
REAL TIME DATA SERVICES ADVANTAGES

• No performance degradation for existing apps
• No change required to existing systems
• Fits in to the existing messaging infrastructure
• Substantially reduced development time/cost
• Enable multiple systems for bi-directional
  interaction with messaging infrastructures using
  a a hub architecture

• Archive published events in the RTDS db for
  auditing
• Consume and store subscribed events in RTDS db
  for distribution
• Enrich events using SQL via calls to other dbs
  using Component Integration Services (CIS)
• Use SQL to publish and consume events to/from
  messaging infrastructures

20
REAL TIME DATA SERVICESUNIQUE VALUE

• Makes Heterogeneous Database Systems Proactive,
  Non-Intrusively

• Fits in to the existing messaging infrastructure
• No performance degradation for existing apps
• No change required to existing systems
• Substantially reduced development time/cost

• Heterogeneous
• Any database to any message bus
• Non-Intrusive
• Capture events non-intrusively
• Impact free alerts and notifications from
  existing systems
• No custom code
• Code free integration of database to message bus
• Eliminates need to write custom polling
  applications

21
DYNAMIC ARCHIVING
22
IMPACTS OF UNMANAGED DATA GROWTH
APPLICATION SUPPORT Increased backup
window Existing resources tied up in managing
current application growth - no resources for new
initiatives Application obsolescence causes
maintenance problems Performance, scalability
bottlenecks
DATABASE MANAGEMENT Performance, Scalability
Bottlenecks Longer backups, upgrades
times Difficulty in maintaining SLA (for example,
completing nightly-maintenance tasks on time)

• DBA
• Backup times

DATA GROWTH IMPACT
INFRASTRUCTURE Increased data center costs
(hardware and storage) Use of alternate solutions
like tape drives, increases access cost Can not
support new initiatives
FUNCTIONAL MANAGEMENT Slower reporting
runtimes Increased critical process runtimes
23
SYBASE DYNAMIC ARCHIVE SOLUTION APPROACH

• Reduce the size of application production
  databases by moving inactive data to another
  online database
• while retaining access to all data
• Improves application performance
• Speeds up maintenance activities
• Reducing costs associated with storage and
  maintenance

24
DYNAMIC ARCHIVING FOR CUSTOM APPS
Archiving of inactive data from production
systems to improve performance, reduce
maintenance and cost of ownership
3
4
Monitoring Tool
User Application
25
SYBASE DYNAMIC ARCHIVING SOLUTION

• Dynamic Archiving Solution (implementation
  choices)
• ASE - ASE
• ASE - ASE with Replication Server
• ASE - IQ
• ASE - IQ with Replication Server
• Solution Components
• Product
• Archive Development and Run-time Tools (from 3rd
  party) Developer/Modeling Tool, Archival Engine,
  Monitoring Tool
• Choice of Archive (from Sybase) ASE or IQ
• Data Movement (from Sybase) Replication Server
  (optional)

26
AUDITING SERVICES
27
AUDITING

• Enterprises are required to make their business
  transactions auditable
• This mandate is both self-regulatory and driven
  by changes in government rules/regulations
  (21CFR11/HIPAA/Sarbanes-Oxley Act)
• Timeframe to respond to disclosure has shrunk
• In some cases, enterprises are required to
  maintain auditing data for 3-7 years
• Type of information needed for auditing
• End-User Access/Modification
• Who accessed/modified data and when
• What data was accessed/modified
• If data was modified, what were the values
  old/new
• Database Administrator Changes
• Who changed schema
• Who changed access control on database objects

28
CENTRAL AUDIT REPOSITORY
Production Servers Configured for Auditing Using
SybSecurity
Audit Repository Pulls Audit Records From
Production Servers
Reporting and Analysis Using SybCentral, 3rd
Party Tools
29
CENTRAL AUDIT REPOSITORY
Source ASE
RepServer Augmented With Function Strings
Audit Repository
Reporting and Analysis
Replicate ASE
30
SYBASE AUDITING SOLUTION

• Sybase auditing solution
• Provides easy management and administration tools
  for setting up the auditing conditions, triggers
  and data collection
• Captures database activity effectively and
  continuously
• Stores and maintains activity information in a
  repository
• Publishes repository data in well-defined formats
  to make it easy to integrate with and use third
  party reporting tools
• Provides alerts on user defined conditions
• Sybase auditing solution
• Non-intrusive to the application
• Read transaction data from log file without
  impacting performance

31
ASE FUTURE DIRECTION ROADMAP
32
ASE DIRECTION
From Enterprise Data Server to a Data Management
Platform for the Unwired Enterprise
Application Development Costs
Web Architecture
Service Oriented Architecture
Web Services XML
Database Operational Costs
Integrated Data Delivery
Self- Management
Virtualized Data Services
Lower Cost Platforms
Provisioning
Grid Computing
ASE 12.5.1 Key Technologies
Future ASE Technologies
TCO Components
33
UNWIRED ENTERPRISE TRENDS IN DATA MANAGEMENT

• Volume
• Greatest data mgmt challenge 22
• Petabytes are imminent
• Decreasing access-to-storage ratio

Data is driven by the information explosion of
V3 Volume, Velocity and Variety

• Velocity
• Greatest data mgmt challenge 23
• Message queues, app servers APIs expose
  real-time transaction data
• Broadbase everywhere means users wont wait for
  data
• Real-time versus sometimes

• Variety
• Greatest data mgmt challenge 55
• Structured, semistructured unstructured
• DBMss, XML, message queues, APIs app servers, Web
  logs,
• Semantic structural incongruity
• Metadatas a must

In addition, an implicit business need is low TCO
Source Meta Group
34
ASE 15.0 FOR UNWIRED ENTERPRISE1H 2005
Volume

• Shared disk clusters
• VLDB
• Scalable QP engine
• Partitions
• Dynamic Archiving

Velocity

• Real Time Services
• Event management

Lowest TCO
Variety
Regulatory Compliance

• Improved SQL compatibility
• Multi-doc XML indexes
• Expanded Xquery support
• Web Services (.NET, HTTP)
• Computed columns/functional Indexes
• Scrollable Cursors

• Operational scalability
• Self Management

• Availability Clusters
• Column-level encryption
• PAM support
• CC/FIPS 140-2
• Auditing enhancements

35
SHARED DISK AVAILABILITY CLUSTERS

• Seamless Failover Continuous Availability
• All servers provide service to single database
  store
• Applications run on multiple nodes with shared
  data
• Fail-over Connections are directed to least
  loaded servers

S1
S2
S3
S4
Private Interconnect
SAN
Shared Disk Storage
Cluster DB
Quorum
36
LOGICAL CLUSTER WITH APPLICATION PARTITIONING

• Scalability Workload Management
• Client connections are transparently redirected
  to a logical cluster
• Cluster-aware application partitioning improves
  scalability from non- uniform access of data.
• Easy to implement Service Level Agreement

37
ASE ROADMAP 2004-2005
Clusters, VLDB SQL Compatibility (H1, 2005)
Data Services (Q2-Q4 2004)

• ASE 15.0
• Partitions
• Clusters Workload Management
• Complex Query Support
• VLDB Support Operational Scalability
• SQL Compatibility
• Self Management (Phase 2)

Real Time Services, Security Linux (May, 2004)
Dynamic Archiving Auditing

• ASE 12.5.2
• Real Time Services
• Security Kerberos
• Active Directory Support
• Linux HA VCS Support
• Linux Kerberos Support
• IA64 Linux
• Extended Memory on Linux

Encryption, Linux Migration (Nov, 2004)

• ASE 12.5.3
• Native Encryption
• Cross Platform Dump/Load

Q2 04
Q4 04
Q2 05