ASE & Replication Server Product Futures

1. ASE & Replication Server Product Futures • .

2. Confidential Information This presentation is a Sybase Confidential document and is being given under NDA. Do not distribute this information or share it with third parties. The contents of this presentation are for informational purposes only and should not be construed as creating a contractual or binding obligation on behalf of Sybase.

3. Presentation Overview • ASE Product Vision & Strategy • ASE Product Direction • ASE 12.X, 15.0: Work in Progress • ASE Roadmap • Replication Server Product Direction • Replication Server Roadmap • Q&A

4. ASE – Product Vision ASE is the best operational RDBMS solution Basically, what this means ….. • ASE is operationally scalable: • good performance and scalability with more processors or machines and new architectures • Improvements in manageability keeping pace with growth in data sizes • ASE has the lowest total cost of ownership (TCO)

5. ASE – Product Strategy • Leverage hardware and software trends to • Improve performance • Drive down cost of operations • Meet customer requirements • Attract ISV packaged solutions on ASE

6. Hardware TrendsASE Focus

7. Software Trends • Operating systems will continue to move up the value chain, by incorporating more of the middleware services in the operating system layer • Increasing push from database systems vendors to incorporate application server technology • Sybase provides an embedded EJB Server in ASE • Linux is increasingly moving beyond LAN services to application services While a n-tier architecture will be the norm, it is highly likely that some of the services executed solely in the middleware layer now will also be executed in the database and/or in the OS in the future.

8. Lowering Cost of Operations • Increase speed of transactions over consolidated and distributed hardware architectures • Improve speed of database maintenance operations • Reduce need of maintenance operations (self –management)

9. ASE Product Direction

10. ASE DirectionBest Operational RDBMS with Low TCO Adaptive Server Enterprise RDBMS for ICM Open Dev Support Easy Operations SCALABLE, HIGH PERFORMANCE SQL PLATFORM

11. ASE – Best Operational RDBMSFeature Set for 2002-2004 Integrated Content Management • XML Queries, Messages and result sets • Management of unstructured data in files • Integrated workflow and event handling Open Development Environment Ease of Operations for Low TCO • Self Tuning and Dynamic configuration • Operational Scalability • Tools – performance monitoring, Job Scheduling • Support for Java, EJB and Web Svcs • Packaged application support • Developer’s version • Solution based option packaging • Tier1 support for Linux & MacOS Database Requirements Scalable, High-Performance RDBMS • Fast Query Processor • Hash indexes & Star Joins • VLDB Support • New,Intelligent Optimizer • Partitions and Distributed Views • Support for SMP, NUMA, Blades

12. Integrated Content ManagementXML Solutions - Searching Business Need With XML increasingly becoming the standard format of information exchange between disparate solutions, an operational RDBMS system must be able to process, store and generate XML content. ASE is the first RDBMS solution with integrated, native XML support: • Ease of use and zero maintenance • Infrastructure that will allow users to focus on business logic and not on XML handling support • Document and index location independence • XML documents and indexes can be flat files, stored in RDBMS or located at an URL • Encapsulation of results in an object, which allows for further processing easily • XML query parser, index generation and search results are Unicode compliant • Data and index caching for user scalability

13. Integrated Content ManagementXML Futures – Storage Side • Performance enhancements and support for multi-document queries • XQUERY Support • Global indexing, providing enhanced query performance; upgrades to our Full-Text Search service to be more XML-aware, as well as optimal handling of the XQUERY syntax • Support for “for XML” clause that is SQLX complaint • Representation of SQL result sets in XML, including mappings for SQL names, datatypes, and values. • A new “XML” datatype for SQL

14. Integrated Content Management • Business Need • An integrated solution that manages all structured (relational) and unstructured (text, image, video) data is required to facilitate business processes, making them efficient and cost-effective. • Examples • Financial services • Insurance claims, analyst research and e-payment services • Manual lookup of disparate types and sources of data is a hindrance to greater customer satisfaction • CAD/CAM • Boeing’s 777 design center has approximately 1.5 million parts and each part has its own designs (drawings); typically the parts data is managed in RDBMS and the associated geometric drawings are kept in regular file system.A system managed integrity mechanism will fulfill the business need to maintain consistency across structured and unstructured data

15. Integrated Content ManagementSybase DataLink Manager • Enables referential integrity constraints • No renaming or deletion of external files that referenced in the database • Enables authorization checks • DBMS roles and permissions can be applied to access control of external files • Performs create/delete operations with transactional semantics • Changes that affect both relational and external data are handled in a transactional context • Supports coordinated backup/recovery • Backing up relational table also backs up file pointed at In ASE 12.5, creating, deleting, reading and writing of flat files through TSQL is supported. For the next two years in this area, focus will be on supporting Content Management/Digital Asset Management vendors such as Documentum and Northern Plains.

16. Ease of Operations to Reduce TCO

17. Reduce TCO Business Need For customers to utilize databases in greater numbers and sizes, TCO must be reduced at all levels – license, maintenance and hardware costs. Focus on reducing DBA and data center operation costs that account for 40% of all costs.

18. Reduce TCOHomeostatic Systems Business Need While storage and performance needs for growing data sizes are being met through advancements in technology, the current models of human based management of data still ignore • Need for 24X7 availability with reduced maintenance window • Continuing shortage of skilled labor • Increasing complexity with growth in data sizes Solution Homeostatic (self-managed) systems will reduce database administration workload and alleviate the problem of skilled labor shortage.

19. Reduce TCOHomeostatic Systems - Components

20. clients Reduce TCO: ASE with Blade Hardware Distributed Table Partition Support • Data is distributed across blades • Clients can login to any node and select, insert,update delete from table transparently • Distributed transaction support • Linux RH 7.2 • Asynchronous I/O • Large File System • Large Memory (64GB) • Intelligent optimizer/Component Integration Service • ASE optimized to scale up with 4-8 way systems

21. Reduce TCO: Operational ScalabilityMultiple TempDBs • Multiple TempDBs will alleviate contention issues • DBA can configure multiple tempDBs that can be bound to an application or user • If more than one Tempdb is bound to an application group, users from that application group are assigned a tempDB in round robin • Binding of tempDB per user will override the default • DBA can bind tempDB at runtime • Useful for DBA to login when other tempDBs are full

22. Reduce TCO: Operational ScalabilityGarbage Collection • REORG RECLAIM_SPACE did not reliably remove empty pages. • Tables seemed to grow without bound. • Lead to unnecessary use of REORG REBUILD • REORG removes all empty pages which did not hold data deleted by an active transaction. • REORG RECLAIM_SPACE can now be used to reliably control table growth as was originally intended. • Housekeeper task per database option to ensure GC

23. Reduce TCO: Operational ScalabilitySampling for fast Update Statistics • Sampling will speed up the gathering of column level statistics • Selected pages are read instead of reading all pages – less I/O • The percentage of pages to be sampled can be specified update statistics tab_name sampling = X percent • X is the percentage of pages you want to sample • The resulting histogram will be based on the values that are sampled • Using sampling is something of a trade off – update statistics runs faster, but the resulting histograms may not lead to the most efficient query plans

24. Reduce TCOSystem Management Support SNMP Sub- Agent Sybase Central ASE Plugin SQL Expert Migration Tool DDLGen SQL Debugger MDA Tables Historical Server Monitor Server ASE ASE ASE System Management Tools

25. Reduce TCOSystems Management: Job Scheduler • Create jobs and execute them according to a schedule • Perform backups, DBCC’s, update statistics, reorgs, reports, etc. on a scheduled – hands-off - basis • Job results are logged to allow problem analysis • Job and Schedule definitions can be shared by multiple users • Supports job definition through: • GUI Interface in Sybase Central • SQL Language interface

26. Job Scheduler: Example Review Scheduler Status Create Scheduled Jobs Manage Job Properties

27. Reduce TCOSystems Management: Migration Tool • Introduced in ASE 12.5.0.1 release • Use to move existing data from an ASE using 2K page size to one using larger page size • Copies table or database definitions and data across ASE servers • Automates schema and data movement processes • Generates and applies database DDL • Copies data to target server using CIS • Easier than recreating database and using BCP • Future: support migration across platforms

28. Reduce TCOSystems Management: SNMP Subagent • SNMP Version 2c support • Support for standard MIBS: • RDBMS MIB RFC 1697 • Network Service MIB RFC 2248 • Implementation of Sybase Proprietary MIB • Server monitoring and trap notification for server state changes. • Trap notification for ASE errors through sp_errornotify • Monitoring of Sybase ASE and Open Servers. • Available first for Apple OS X, followed by other platforms

29. Reduce TCOSystems Management: Performance Monitoring • Integrated with Sybase Central • Separately purchasable option • Targeted for ASE 12.5.0.3

30. Open Development Environment

31. Standards Based Application Development Support • New EJB engine that supports EJB 2.0 • Support for Web Services – UDDI and SOAP support • Web Services toolkit for publishing functionality supported by RDBMS • stored procedures • remote data access • XML Search on docs • JDK 1.3 support IIOP SQL SM Segment HTTP/S SQL Engine JDBC via SM Segment TDS SQL Engine EJB Engine

32. Application Development • Developer’s Edition of ASE at a low price • Integrated development environment package • ASE Developers Edition • PowerBuilder • PowerDesigner • Support for new platforms • ASE and OC for MacOS

33. Solution Based Packaging • New packages • Disaster Recovery (ASE+RS) • XML Management (Java/XML+EJB) • Content Management (XFS) • E-business (XML + Content Management + Dir&Security) • Directory & Security ( LDAP + Security) • Options • High Availability • SQL Expert • Distributed Transaction Management(DTM) • Full Text Search

34. Scalable, High Performance SQL Platform

35. Scalability with Leading OLTP Performance Business Need Web-based data management provides the opportunity to capture consumer and supplier behavior that can be mined for market intelligence by competing firms. This indicates the need for a scalable, operational RDBMS with complex query support and rapid response times. Solution VLDB and Complex Query Enhancements in ASE

36. Scalability SolutionVLDB Enhancements • Segment-based Partitions & Increased Limits • Partitioned tables • Range, Hash partition support • Add/Drop one or more partitions • Clustered/Non-Clustered Indexes • Global and local indexes on partitions • Update statistics on one or all partitions • Truncate partition • Optimizer and Execution support for partitioned tables

37. Scalability SolutionVLDB Enhancements • New Limits • More than 256 devices • More than 32 segments • Object Level Recovery • Recover database objects from database dumps • Make database consistency checks (DBCC) as an offline activity • Ability to do dbcc on a database dump • Row locked system catalogs

38. Scalability and Performance Complex Query Enhancements • New Optimizer/Execution Engine • Optimizer and Execution Engine enhancements to process complex queries across the enterprise • Statement cache • Derived tables

39. Scalability and PerformanceComplex Query Enhancements • Volcano Model execution engine with property and cost encapsulated optimizer • Effectively deal with several large federated database systems • Optimizer can weigh in the load of other databases across the entire enterprise for joins across multiple servers • Significant projected performance improvement on remote joins using Component Integration Services • Star joins

40. High Availability & Disaster Recovery Business Need Reducing server downtime is a critical need for most businesses….particularly e-businesses, while leveraging existing IT infrastructure. Solution Enhance the performance of the innovative 2-node cluster solution, while supporting additional popular cluster platforms. Additional features that enhance high availability of maintenance operations will be supported.

41. High Availability Trends • Increased attention to Business Continuity as a whole rather than simple system availability • Increased requirement for distributed systems to eliminate single geographic points of failure • Increased emphasis on multiple layers of defense rather than a singular defensive strategy • Increased use of directory and switching technologies to direct clients to active data centers • Tradeoffs between solutions and costs will continue to drive a balancing act of how much protection a business can afford

42. Replication Server Warm Standby & Open Switch ColdStandby DisasterRecovery Catastrophic ASE HighAvailabilityClusters HighAvailability Unplanned Severity of Database Downtime OfflineMaintenance Planned ASE Dynamic Reconfiguration No Downtime ContinuousAvailability Latency of Database Recovery Sybase High Availability SolutionsOverview • Sybase provides a wide range of solutions covering all aspects of availability

43. Dynamic Reconfig params: Total memory Number of user connections Number of locks Number of open objects Procedure Cache (absolute) Disk I/O structures Online index Monitoring agent will assess the health of ASE using Systems Mgmt API and automatically apply configuration changes Continuous AvailabilityDynamic Reconfiguration in ASE 12.5 Self-Tuning assisted by Dynamic Re-configuration Load SM ASE DynamicRe-configuration Monitoring Agent

44. HA System Establish S2 S1 Companion Node 1 Node 2 Replicate Users/Logins Disk Disk Local or Shared dual ported storage Continuous AvailabilityASE Active/Active Fail-over Cluster Availability • Supports a 2 node cluster • Both nodes actively serve different applications • Companion node takes over disks and processing during failure • Cluster Architecture and Connectivity layer can switch applications (clients) • Provides Zero-latency, quick fail-over

45. Minimize/eliminate user impact Protect against unplanned outages S/W, H/W, Application failure Unforeseen circumstances like data corruption Protect against planned outages S/W, H/W, Application upgrades Enable ops to perform maintenance Recover from natural disaster Without geographic restrictions Continuous AvailabilityWarm Standby with Replication Philadelphia Operations ASE Replication Server PRIMARY DATACENTER Denver Operations ASE Replication Server SECONDARY DATACENTER Warm Standby

46. Continuous AvailabilityReplication Server Warm Standby & OpenSwitch • Replicates “transactions” from primary to secondary site(s) and Near-real time, asynchronous data movement • Fault tolerance with store and forward queues (intermediate storage) and Guaranteed delivery of transactions • OpenSwitch can fail-over applications (clients) seamlessly • replicates DDL (schema changes), supports database mirroring OpenSwitch Replication Server Standby DB Active DB Queue

47. Secondary Primary 2:00 AMquiesce database hold;<copy database usingexternal command>;quiesce database release 7:00 AMdump tran with standby_access 9:00 AMdump tran with standby_access 10:00 AMdump tran with standby_access Repeat each houruntil activity tapers off; then lengthen intervals accordingly 2:10 AMdataserver-q .. 7:05 AMload tran;online database for standby_access 9:07 AMload tran;online database for standby_access 10:10 AMload tran;online database for standby_access Standby Model using Quiesce Database Continuous Availability Standby with Quiesce Database in ASE 12.5

48. High AvailabilityEnhancements to Cluster Solution • Veritas Cluster (for Solaris) and Sun Cluster 3.0 support • Faster failover and failback • Dynamic renormalization of stored procedures will reduce failover/failback time by 10-15% • Parallel & Faster Recovery enhancements to speed up recovery upon fail-over

49. High AvailabilityTransportable Databases – Snapshot Replication • Transportable Databases allow databases to be moved between running ASE servers without requiring a reboot. • Operations • Copying a database • Moving a database • Provides Snapshot replication when used in conjunction with QuiesceDB • Storage vendor solutions such as TimeFinder can be used to copy the data quickly

50. Secondary Primary 2:00 AMquiesce database hold; <Prepare for unmount><copy database and devices>;quiesce database release 7:00 AMquiesce database hold; <copy> 9:00 AMquiesce database hold; <copy> 10:00 AMquiesce database hold; <copy> Repeat each houruntil activity tapers off; then lengthen intervals accordingly 2:10 AMmount database <db>…. 7:05 AMmount database <db> … 9:07 AMmount database <db> … 10:10 AMmount database <db> … Snapshot Replication using Transport Database and QuiesceDB Continuous Availability Snapshot Replication