DM219 Adaptive Server Enterprise 12.5 -The Portal-Ready Database

1. DM219Adaptive Server Enterprise 12.5 -The Portal-Ready Database • Sumit Kundu • Staff Product Manager • Enterprise Solutions Division • kundu@sybase.com

2. RDBMS market prospects Competitive offerings ASE 12.5 release focus ASE 12.5 - the Portal-Ready Database Security and LDAP services Productivity enhancements Enterprise class services Presentation Outline

3. RDBMS software license market will be $11B by 2003[IDC] NT will overtake Unix in market share percent Need to expand data server capabilities incorporate component processing architectures incorporate unstructured and semi-structured data management RDBMS Market Trends

4. Oracle Market dominance: 61% Unix, 35% NT Big server strategy Oracle 8i Release 2 Data warehousing enhancements Internet computing: Java2, XML parsers and class generators, multi-byte charsets HA: performance optimized 2 node OPS, but at a significant cost Competition

5. IBM Strong e-business focus Key strengths in query optimization and scalability Recent gains on Sun/Solaris IBM UDB 6.1 Scalability from Win 95 to mainframes Administration tools in Java and web-accessible Comprehensive performance monitoring tools Smart Index tuning tools Competition

6. Microsoft Low cost leader with impressive price/performance Strengths in middle market and pushing towards a distributed architecture MS SQL Server 7.0 True low-level locking 8KB page sizes - improved I/O performance Intra-query parallelism Self-tuning: automatic memory distribution between procedure and data cache Competition

7. Open Extensible architecture Relatively easy maintenance with key mixed-workload support Unparalleled scalability and performance on SMP systems ASE 12.0 Unique High Availability solution Content management using Java facilities Portal-ready database Sybase

8. Open architecture and equal consideration of all technologies and platforms (against Microsoft) Price/Performance (against Oracle) Pure HA solution with no strings (against Oracle) Best mixed-workload support Best OLTP performance on SMP systems Enterprise Portal enhancements and targeting key e-business technologies Sybase’s Key Competitive Advantages

9. Internet security Communication security Row level and column level security Web application development Java stored procedures Dynamic web content generation from XML Execution of Enterprise Java Beans in ASE Enterprise e-business capabilities HA enhancements Self-tuning and dynamic reconfiguration ASE 12.5: Database for Business on the Internet

10. Adaptive Server Enterprise 12.5 ASE: The Portal-Ready Database for Business on the Internet Directory & Security Enterprise Class • Continuous Availability • JVM Performance • Quality of Service • Relaxed Server Limits • Support for UTF-16 • LDAP • PKI & SSL • Row Level Security Database Requirements Productivity • XML Queries • EJB • SQLJ • External File Systems

11. LDAP Public Key Infrastructure & Secure Socket Layer Row Level Security Integrated Internet Directory And Security Services ASE 12.5 Directory & Security

12. Business Need:Cost-effectively manage and authenticate users of ASE applications and have a unified way of storing ASE information Current solutions: ASE information is stored in interfaces file whose format is different for different platforms. Manageability issue for customers with hundreds of servers on different platforms Application information is stored both in ASE and an LDAP server: issues of synchronization and cost. Directory Services in ASEWhy?

13. Integrated directory services with ASE will ensure cost-effective management of client and server information. Key Benefits: Server information that is spread in multiple interfaces files can potentially be available from a single ASE/LDAP server Instant synchronization of ASE and LDAP data, obviating the need for explicit transfer and synchronization of data between the two stores Directory Services in ASEValue Proposition

14. A 3rd party LDAP server will be integrated so that ASE is used as store of directory information The same directory information is available from SQL and LDAP interfaces - no explicit synchronization needed Directory Services in ASESolution in ASE 12.5 JNDI/ TSQL LDAP API LDAP API ASE LDAP CTLib/ ODBC

15. Business need:With explosion of e-business, there is a critical need for security to ensure that only valid and trusted users are able to access data securely in ASE. Current solution: No communication level security Only column level security Security Services in ASEWhy?

16. New security services in ASE will ensure access control and secure transactions over the Internet. Key Benefits: Communication level security using Secure Socket Layer protocol Industry standard Public Key Infrastructure based security using a Certificate Authority for authentication, encryption and end-to-end security Full row level security based on user defined rules Security Services in ASEValue Proposition

17. SSL v3.0.7 integrated with Ctlib and ASE Support digital certificates from CA like Entrust and Verisign Row level security will utilize user defined constraints User defines constraint rules Powerful constraints can be built using Java Association of user with constraint made at login time Security ServicesSolution in ASE 12.5

18. Support for XML Queries Support for EJB SQLJ Standard Support External File System Management Internet Application Productivity Enhancements ASE 12.5 Productivity

19. Support for XML QueriesWhy? • Business Need:Dynamically generate content for web pages • Current solutions: • Inflexible: content in HTML encapsulate both content and presentation style • Tedious: data extraction requires coding • Custom-built: a data extraction application needs to be customized for a specific schema • Non-optimized: Data searches are not efficient

20. Increased productivity from using a query language tool to dynamically access desired information in a XML document. Key benefits: Flexible: separation of content and presentation in XML along with query language support ensures dynamic and different web content generation from same data Simple: Java classes to extract data are provided General: extraction can be generalized Optimized: New query engine that is optimized for store once, query many times Support for XML QueriesValue Proposition

21. String result = Xql.query(“/bookstore”, “<xml>…</xml>”); URL xmlURL = new URL(“http://doc.xml”); String result = Xql.query(“/bookstore”, xmlURL.openStream()); JXml xDoc = new JXml (“<xml> .. </xml>”); String result = Xql.query(“/bookstore”, xDoc); Platform is Java Generic solutions can be run on any VM Independent of ASE standalone client JDBC app (storage can be ASE) EJB component result is a well-formed XML document Support for XML QueriesSolution: Generic

22. SybXmlStream xmlStream = Xql.parse(“<xml>..</xml>”); String result = Xql.query(“/bookstore”, xmlStream); insert XMLtable values (…, sybase.utils.parse(“<xml..</xml>”, …)) select jcs.xml.Xql.query(“…”, xmlcol) from XMLtable where... SybXmlStream benefits parsed document can be stored in memory or in a file for fast access suitable for “store once, query many times” (caching) parser will validate against supplied DTD with some restrictions integration with SQL parsed output stored in text/image cols Inserts, updates, deletes supported Support for XML QueriesSolution: ASE Value-Add

23. The query() method of Xql class can be run against ASE 12.0’s JXml class objects Columns storing raw XML docs in ASE 12.0 can be converted to parsed docs for use by Xql alter table XMLtable add xmldoc IMAGE null update XMLtable set xmldoc = jcs.xml.Xql.parse(xmlcol) Embedded JVM in ASE 12.5 will be faster Support for XML QueriesLeveraging ASE 12.0 Capabilities

24. Business Need: Faster deployment of applications that are data centric and utilize a component model for development Requirements Support popular component models and leverage Java Support technology that makes development easier through implicit support of such issues as security, transaction, multi-threading, etc. Integration with data server technology, as appropriate, for security and performance reasons and providing additional flexibility of deployment Support For Enterprise Java BeansWhy?

25. Support for EJB in ASE will ensure faster development of applications that utilize the EJB component model, additionally providing a secure and performance optimized environment. Key Benefits: Completely secure - its in Java! Additionally, execution is within ASE environment EJB is a popular component model Leverages ASE’s open architecture: not dependent on embedded JVM PowerJ support to deploy EJBs Support For Enterprise Java BeansValue Proposition

26. Support For Enterprise Java BeansSolution: Leverage Sybase’s Open Architecture IIOP HTTP/S SQL SM Segment SQL Engine TDS JDBC via SM Segment SQL Engine EJB Engine Adaptive Server Enterprise

27. Support for EJB 1.1 standard Stateless and stateful sessions beans Entity beans Support For Enterprise Java BeansSolution in ASE 12.5

28. Business need:Standardization of Java object-relational technology ensures portability of applications and enables further application development Current Solution SQL wrapper needed for using Java methods as stored procedures No support for embedded SQL in Java SQLJ Standard SupportWhy?

29. Compliance with Part 0 and Part 1 of SQLJ standards will ensure cost savings on Java based, object-oriented application development, porting and training for customers Key Benefits: Ability to create Java procedure similar to SQL procedure that can return output params and result sets Embedded SQL applications can be run against ASE Security checks on Java function creation & calls SQLJ Standard SupportValue Proposition

30. Create procedure <sql procedure name> <sql parameters> dynamic result sets integer language java parameter style java external name <method name> <method params> Example: create procedure ranked_emps(region integer) dynamic result sets 1 language java parameter style java external name ‘Routine.orderedEmps’; SQLJ Standard SupportSolution in ASE 12.5

31. Business need:There are many types of unstructured data that has traditionally resided in flat files and outside the scope of a RDBMS. With exploding information content, it has become extremely difficult to maintain the integrity of data in these files. Current solutions Impractical: move unstructured data into RDBMS Costly: Custom software to maintain data integrity Support for External File SystemsWhy?

32. Support for external files in ASE will ensure an easy and cost-effective way of managing data that is used in e-commerce and typically stored in files Key Benefits: Provides referential integrity, access control, coordinated backup and transaction consistency Integrated with Verity Text Search and XQL support Sybase Central support Support for External File SystemsValue Proposition

33. Support for External File SystemsArchitecture Command Shell Client SQL Client Internal FSAPI ASE File System System Traps OS Kernel Files

34. SQL access to file system directories and files create proxy_table <table_name> external directory at “directory pathname” The proxy table contains the following columns: Support for External File SystemsSolution: Phase I: SQL Access of Files

35. Operations select for file attributes insert to create new files delete to remove files update to change file name readtext to retrieve contents of file writetext to modify contents of file Support for External File SystemsSolution: Phase I: SQL Access of Files

36. Referential integrity and access control implemented with support from Operating System Coordinated backup to backup content of files managed by ASE Transaction consistency Sybase Central support for file management Support for External File SystemsSol: Phase 2: Complete Solution (in a future release)

37. Non-Stop Enhancements Quality of Service Extensible Server Limits JVM Performance Enhancement Unicode (UCS-2) support Database for the Enterprise ASE 12.5 Enterprise

38. Business need:Adoption of Java based object-relational technology in ASE is gated by performance of embedded JVM. Need performance enhancements of embedded JVM to further utilize Java technology in ASE. Current Issue: Execution of Java classes in ASE need to be faster. JVM Performance EnhancementsWhy?

39. Performance enhancements in embedded JVM will enable applications that use Java based object relational technology in ASE. Key Benefit: Significant performance gains that will enable applications that utilize support for SQLJ and XQL Support in ASE. JVM Performance EnhancementsValue Proposition

40. New JIT compilation technology in embedded JVM to speed up performance by more than 10 times in average cases JIT compilation done selectively on Java methods that are most frequently used Transparent to the client JVM Performance EnhancementsSolution in ASE 12.5

41. Business need: It is prohibitively expensive for small installations to maintain dedicated personnel to manage ASE. Current Solution: Many ASE configuration parameters are static, requiring reboot of server following adjustments Manual monitoring is required due to lack of automatic tuning of ASE Quality of ServiceWhy?

42. Dynamic reconfiguration and self-tuning capability will reduce server downtime and will save server maintenance costs. Key Benefits: Need to reboot server is reduced Automatically adjust configuration parameters to deal with server load changes Quality of ServiceValue Proposition

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

44. Business need: As businesses become global there is increasing need for efficient representation of major non-English languages. Current solutions: Space inefficiency: Representation of characters in UTF-8 format, which may require 1,2 and 3 byte representations Processing inefficiency: Implicit conversions are needed in Unilib for UTF-8 representations Support for UCS-2Why?

45. Support for UCS-2 will enable ASE to process character data in English and foreign languages more efficiently thereby facilitating global commerce. Key Benefits: Universal and efficient representation of all languages in 2 byte encoding Improved performance by avoiding conversions Match UTF-16 support for characters in Java Support for UCS-2Value Proposition

46. New data type UNICHAR to be used anywhere CHAR can be used; similarly for UNIVARCHAR Full integration with other data types implicit conversions so that functions and sub-queries returning UNICHAR can participate in mixed-mode expressions conversions between Java and UNICHAR types builtins modified to accept UNICHAR arguments joins between columns of UNICHAR and other types Support for UCS-2Solution in ASE 12.5

47. Interfaces File HA System S2 Establish Companion Replicate Users/Logins SystemDB systemprocs security Master Establish Proxy DBs User Enhancements to HA Solution Interfaces File S1 SystemDB systemprocs security Master User User

48. Business need:Reducing server downtime is a critical need for most businesses….particularly e-businesses (ask ebay!), while leveraging existing IT infrastructure. Current solution Restricted by operating system support of disk subsystems Enhancements to HA SolutionWhy?

49. Sybase supports an unique solution that is targeted purely at reducing ASE downtime. Key Benefits: Reduced server downtime Enhancements to HA SolutionValue Proposition

50. Integrated solutions with disk vendors - EMC and Veritas Solutions that leverage 3rd party cluster heartbeat mechanisms like RSF on Linux Transportable Database capability to further reduce overall server downtime More transparent client failover Enhancements to HA SolutionWhat is new in ASE 12.5?