© 2006 ibm corporation information on demand informix – what next! lim kok yew information...
TRANSCRIPT
© 2006 IBM Corporation
Information On DemandInformix – What Next!
Lim Kok Yew
Information Management Technical Sales
©2006 IBM Corporation
Agenda
Information as a Service
Informix Strategy & Roadmap
2005 Informix Business Highlights
IDS v10.0 Overview
©2006 IBM Corporation
Agenda
Information as a Service
Informix Strategy & Roadmap
2005 Informix Business Highlights
IDS v10.0 Overview
©2006 IBM Corporation
Standards-based
e.g., XQuery, JCR, JDBC, Web Services...
Information On Demand Moving From a Project-Based to a Flexible Architecture
Master Data, Entity Analytics, Information Warehouses, Industry Models
Extracted or Real-time
©2006 IBM Corporation
On Demand Infrastructure SoftwareService Oriented Architecture for an agile business
©2006 IBM Corporation
IBM Information Management softwareUnmatched product portfolio
DB2
IDSU2CloudscapeIMS
Information Server
Industry Models
Product CenterCustomer Center
Content Manager Record Manager
Document Manager
CommonStoreWorkplace Forms
AlphabloxEntity AnalyticsOmniFindContent Discovery
©2006 IBM Corporation
Data is the Most Valuable Business Asset Client, employee, product and financial data… Availability and performance impacts results Secure, private access affects brand value
A Fundamental Control Point Not a commodity in most use cases Unique advantages for solution developers Cross platform integration = competitive advantage
Needed by Every Business Application No business solution works without data Essential elements of an application platform Requirements span a broad spectrum
IBM Data ServicesSecure and efficient management of structured information
Lower cost through an optimized infrastructure
©2006 IBM Corporation
Agenda
Information as a Service
Informix Strategy & Roadmap
2005 Informix Business Highlights
IDS v10.0 Overview
©2006 IBM Corporation
IDS release roadmap
IDS 7.317.31.UD10 7.31.UD11
IDS 9.4 9.40.UC8 9.40.UC9
IDS 10 10.00.UC5 10.00.UC6 10.00.UC7
2006 20082005 2007 2010
IDS vNext10.00.UC5 10.00.UC6 10.00.UC7vNext vNext+vNext
DataBlades& CSDK
©2006 IBM Corporation
IDS: Then, now, and what’s to come
IDS 10IDS 1020052005
OLTP OLTP PerformancePerformance
20062006
Enhanced Enhanced Data ServicesData Services2007 – Cheetah*2007 – Cheetah*
Hands Free, Secure Hands Free, Secure
& ALWAYS ON!!!& ALWAYS ON!!!Panther*Panther*
Fastest, most-available Informix OLTP engine ever
IDS Express
PHP driver
Baan benchmarks
Continuous advances in OLTP engine solidify market position
Enhanced memory management
Enabled for sub-capacity
Improved spatial & geodetic support to support location-based services
Performance and High Availability enhancements
Significant security certification meets Common Criteria specifications
Further reduction in TCO with improved administration functions
Enhanced support for unstructured data
Customizable footprint on installation
Intelligent administration and monitoring
Enterprise security enhancements
Enhanced enterprise data management
Matrix-based replication
Enhanced administration functions
* Subject to change
©2006 IBM Corporation
Key differentiators for new markets
Leverage existing applications development skills SQL compatibility (data types, function, SQL Dialect) Application behavioral compatibility Application API compatibility
Dramatically lower TCO (improve DBA experience) Improved disk space management Intelligent monitoring and anticipation of problems Smarter query optimization Policy driven configuration
©2006 IBM Corporation
Future development will continue to focus on key pains
Meeting security & regulatory requirements
Minimizing downtime
Ease of embeddability
Improved application development environment
Improving DBA productivity
©2006 IBM Corporation
Pain Point #1: Security & regulatory compliance
Federal/State/Country requirements for government contracts LSPP (B1), CAPP (C2) HIPPA/SOX/GLBA
Auditing capabilities Who can see what data and who has seen what data
System vulnerabilities Add additional encryption for bolstering data security
©2006 IBM Corporation
Pain Point #2: Minimizing downtime
Planned vs. unplanned outages Which takes greater time in your organization? For planned upgrades
Is it database vs. application upgrade?
Improving on long running operations Like HDR upgrade where whole backup is needed ER – even easier to deploy and manage, embedded applications
Faster recovery Has the effect of minimizing downtime System failure (transaction recovery) vs. media failure (backup/restore)
More tasks online (vs. offline) In place alters & space management
©2006 IBM Corporation
Pain Point #3: Ease of embeddability
Configurable footprint (choosing components)
Eliminate external software dependencies
Reducing configurable parameters
Easy and silent installs
Enhanced ER node deployment
©2006 IBM Corporation
Pain Point #4: Application development environment
SQL standards
Open up API’s for application development PHP, admin tasks, DRDA support
Integration with IDE’s .NET Visual Studio, Rational
4GL to EGL migration tool and integration with Rational Application Development Suite products for expanded application development capability
Migration tools for conversion from other database vendors
©2006 IBM Corporation
Pain Point #5: Increasing DBA productivity
Reduce manual intervention for: Choosing index Performance tuning Query drill down Update stats Monitoring disk usage for increasing size and reclaiming space Intelligent backup and restore selection Admin tools # of configurable parameters
©2006 IBM Corporation
Agenda
Information as a Service
Informix Strategy & Roadmap
2005 Informix Business Highlights
IDS v10.0 Overview
©2006 IBM Corporation
2005 was a busy year for Informix @ IBM
February
IDS v10.0 Introduced
April
IDS Express Introduced
August
RAD 6.0.1 w/ capabilities for 4GL to EGL migration
October
PHP Level 5 Driver for IDS
December
Oracle to IDS MTK
©2006 IBM Corporation
Feb 2005: Informix® Dynamic Server (IDS) v10.0Largest Informix release since 1999
Faster than ever!
Does more with less hardware!
Reliability
Performance
Scalability
Keep information current anywhere on your network, where and when you need it, even during application upgrades!
Maintain operations even when disaster strikes!
Handles the smallest workloads efficiently
Scalable enough to handle the most demanding workloads to keep pace as your business grows!
Manageability
Security Helps business meet regulatory compliance without costly
application modifications Basel II, Sarbanes-Oxley, HIPAA
Provides lowest Total Cost of Ownership
Over a thousand remote instances can be handled by a single DBA.
Frees critical resources for business critical tasks!
©2006 IBM Corporation
Oct 2005: PHP DriverInformix is supported in most major development environments
PDO (PHP Data Objects) abstraction layer driver
Provides developers a light-weight, consistent interface for accessing Informix Dynamic Server
+ =development partnership
PHP 5.x Informix driverfor PDO
Download PDO_INFORMIX: http://pecl.php.net/package/PDO_INFORMIX
Read the installation guide: http://www.ibm.com/developerworks/db2/zones/informix/
Learn how to use IDS & PHP with the Google Maps API
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0602lurie/
©2006 IBM Corporation
Dec 2005: Migration Toolkit from Oracle to IDS
IBM Migration Toolkit (MTK 1.4) now helps you migrate from Oracle and Sybase to IDS v10.0
IDS v10.0
MTK 1.4
©2006 IBM Corporation
2006: The first IDS 10 Redbook!
Covers all aspects of IDS 10 Overview / Architecture Installation / Configuration SQL Features / Extensibility Security / Encryption Backup / Restore Administration / Dev. Tools
and One chapter on SOA with IDS
Lots of step-by-step examples
Availability: Q4 2006
Download for free at: http://www.ibm.com/redbooks
Redbook ID: SG24-7299
©2006 IBM Corporation
Agenda
Information as a Service
Informix Strategy & Roadmap
2005 Informix Business Highlights
IDS v10.0 Overview
©2006 IBM Corporation
IDS v10.0 PerformanceBlazing OLTP performance for your mission-critical applications
Fully exploits hardware resources Dynamic Scalable Architecture
Hardened cost-based optimizer Easily handles mixed workloads
Does not require application changes as data volumes increase Partition data to increase performance Oracle requires additional Partition Option
feature, partitioning data and modifying the application
IDS v10.0 Enhancements
External optimizer directives Improves support of ISV applications
Configurable page size Improves performance of large keys Improves performance of large rows
©2006 IBM Corporation
IDS v10.0 ReliabilityEliminates costly downtime saving businesses time and money
IDS can be tuned online Add/remove system resources to handle load changes
Built-in utilities can validate and repair indexes without dropping
Rolling application upgrades with Enterprise Replication
IDS v10.0 Enhancements Online index creation and rebuild
Can reduce scheduled downtime by half
©2006 IBM Corporation
IDS v10.0 ScalabilityScales “without limits” in any direction to meet increasing workloads
Storage capacity Loading at 1 gigabyte per minute 250 years to reach IDS capacity
Linear scalability As resources on a system are doubled,
processing capacity should double (application overhead usually prevents 100% linear scalability)
Competitive products tested didn’t provide the performance or scalability of IDS
Number of users IDS is capable of handling thousands of
concurrent users.
deployment distributed across
1000s of sites
types of datano limit to new
data types
transactions 1000’s of concurrent
users
huge data volumes
©2006 IBM Corporation
Bigger Storage
The 2 GB limit on chunk size is too painful
So we’ve removed it New upper limit per chunk is 4 TB.
For 2 KB pages Could be doubled to 8 TB later
Good through about 2010.
And increased the number of chunks New upper limit is 32767
Could be doubled to 65535 later
The new upper limit on the size of an IDS instance is: 128 petabytes (128 * 1015 bytes)
©2006 IBM Corporation
Bigger Storage
How big is 128 PB? Very big! US Library of Congress holds about 10 TB printed material. 128 PB is about 12,800 times the material in the LOC. At current prices, it would cost about $3B to buy the disks.
Before mirroring or RAID is added in At a load rate of 1 TB per hour, it would take about 15 years to fill a 128
petabyte database.
VERY BIG!
©2006 IBM Corporation
IDS v10.0 SecurityMeets the demands of new regulatory and compliance requirements
Provides secure encrypted communications Client-Server Server-Server
IDS v10.0 Enhancements
Column-level encryption Helps support Sarbanes-Oxley, Basel
II, HIPAA
Secure environment Initialization ensures environment is
secure at startup
DataBlade registration restrictions Ensure DataBlades cannot be
registered by hostile individuals
©2006 IBM Corporation
IDS v10.0 ManageabilityLowers the cost of administration
Utilities Online backup High performance loader
Administrative support Fast deployment and upgrade Diagnostic tools
Scripting capabilities
IDS v10.0 Enhancements
Table-level point-in-time restore Can restore a single table or portion of a table
from a backup
Create/drop index online
Install improvements
Backup and restore enhancements
©2006 IBM Corporation
IDS v10.0 AvailabilityOffers industry-leading data availability options
High-Availability Data Replication (HDR)
Creates a duplicate copy of an IDS server
Useful for: Disaster Recovery Off-loading reports/queries
Secondary server can be local or remote
Enterprise Replication (ER)
Replicates data to any other IDS system on your network
Allows enterprise systems to feed departmental systems
Allows enterprise systems to feed regional or local systems
Allows operations across thousands of nodes
©2006 IBM Corporation
IDS v10.0 HDRHigh-Availability Data Replication for maximum availability
Two Active Machines
Primary Processes transactions Ships log entries to the other
machine
Secondary Cloned from the primary Receives and stores log entries from
the primary Re-applies the transactions Can be used for reporting
If primary fails, the secondary takes over
Primary
HDR
Secondary
©2006 IBM Corporation
IDS v10.0 ER Enterprise Replication for maximum enterprise synchronicity
Can replicate any portion of a database
Bi-directional replication
Supports complex topologies
Supports thousands of nodes
Supports WANs
Useful for departmental or hierarchical applications
Works transparently with High Availability Data Replication (HDR)
IDS v10.0 Enhancements
ER templates reduce administration Simplifies set up Speeds deployment
Re-Sync tables improves availability Repair a system where some replicated
changes failed
Alter table support Supports rolling upgrades of applications Not available with competitive products
©2006 IBM Corporation
IDS DataBladesExtends the power of IDS to create customized solutions
Object-relational server extensions integrated into the database engine core
Delivers unparalleled application functionality and outstanding performance
Spatial Geodetic TimeSeries TimeSeries Real-time Loader Excalibur Text Search MQseries Image Foundation Video Foundation Web C-ISAM
DataBlade Corner on developerWorks:http://www-128.ibm.com/developerworks/db2/zones/informix/corner_dd.html
IDS DataBlades
©2006 IBM Corporation
IDS Version ComparisonA track record of continued investment in Informix technology
Feature IDS v7.x IDS v9.4 IDS v10.0
Object Relational Database X X
Detached Indexes X X
Fuzzy Checkpoints X X
Dynamic Logging X X
Chunk size 2GB 4TB, max db size 8PB 4TB, max db size 8PB
Restartable fast recovery X X
HDR & ER interoperability X X
Buffer Manager X X
B-tree Scanner X X
Dynamic lock manager X X
Configurable page sizes X
Column-level encryption X
Point-in-time table-level restore X
Shared memory segments > 4GB X
Rename dbspaces X
Performance enhancements 15-20% greater than v7.x 5-10% greater than v9.4
Online Index creation X
©2006 IBM Corporation
IDS v10.0 Extensive Platform Support
Windows 2000, 2003 and XP on x86
AIX on pSeries Linux on xSeries, zSeries,
pSeries and iSeries
IRIX
HP-UX on PA-RISC and
Itanium Tru64 on AlphaSolaris on SPARC
©2006 IBM Corporation
Informix Product Family Homepage - http://www.ibm.com/software/data/informix/
Informix Platform Roadmap -http://www.ibm.com/software/data/informix/pubs/roadmaps.html
Informix Product Life Cycle (PLC) Roadmap - http://www.ibm.com/software/data/informix/support/plc/
Informix Developer’s Homepage - http://www.ibm.com/developerworks/db2/zones/informix/
Informix International User Group (IIUG) – http://www.iiug.org
Informix Resources
Information on DemandInformix – What Next!
Thank You