SQL Anywhere 9 Developer Tour

1. SQL Anywhere 9 Developer Tour

2. Today’s Speakers and other iAnywhere Staff

3. Agenda 09:30 – 09:45 iAnywhere Solutions At-a-Glance 09:45 – 10:15 iAnywhere Product Overview 10:15 – 10:45 Adaptive Server Anywhere 9 New Features 10:45 – 11:00 BREAK 11:00 – 11:15 New ASA Feature continued 11:15 – 12:00 New Mobilink & Ultralite Features 12:00 – 12:25 A Quick Look At Pocket PowerBuilder 12:25 – 12:30 Wrapup

4. iAnywhere Solutions At-A-Glance Steve Fourie

5. iAnywhere Solutions at a Glance iAnywhere Solutions, a subsidiary of Sybase, Inc. (NYSE: SY), provides software and services that enable the delivery of enterprise information anywhere, at anytime. 400 iAnywhere employees worldwide In more than 50 countries worldwide Offices in > 10 countries in Europe 79 Mio. $ revenue in 2002

6. Mobile DBMS Market Vendor Shares 2001

7. Leadership Mobile database leader for six consecutive years with 73% marketshare* Mobile middleware market leader** Leading embedded database vendor More than 12,000 corporate customers in 50 countries, including 78 of the Fortune 100 8 million deployed technology licenses (SQL Anywhere Studio) More than 1,000 OEM partners worldwide More than 10 million registered subscribers of AvantGo® mobile Internet service (largest PDA application in the world)

8. One source for m-Business Database Management Synchronization Server Technology Software and Application Management - iAnywhere Solutions’ m-Business platform provides a proven architecture for implementing mobile and wireless solutions quickly, with low risk. A scalable, reliable and fault-tolerant wireless server provides the foundation to handle millions of transactions from thousands of users. - open enterprise integration services allows you to preserve your existing investments when extending your current infrastructure to mobile and wireless devices. The platform enables integration with leading database, ERP, messaging and mainframe systems. - network and device gateway provides security-rich wired and wireless connectivity between IT systems and the communication network. - Offline operation, the cornerstone of “always available” access, is enabled through data synchronization and fully transactional local data management. Our data synchronization enables the direct exchange of information between mobile devices and enterprise systems -- without the need for a PC. Workers can access information and queue up transactions offline, reducing communications costs while increasing application and battery performance. - Store-and-forward messaging provides guaranteed delivery of alerts and notifications. - For smart client applications, the platform provides support for application distribution and device management. - For thin client, browser-based applications, the platform provides content delivery services to automatically detect the type of device, and customize content to fit the appropriate size and display requirements. The platform also provides support for Wireless Application Protocol (WAP) and Short Messaging Service (SMS). - we provide support for traditional wired applications, enabling information access from any environment. - addresses end-to-end security, creating an environment of trust for the mobile user. - iAnywhere Solutions’ m-Business platform provides a proven architecture for implementing mobile and wireless solutions quickly, with low risk. A scalable, reliable and fault-tolerant wireless server provides the foundation to handle millions of transactions from thousands of users. - open enterprise integration services allows you to preserve your existing investments when extending your current infrastructure to mobile and wireless devices. The platform enables integration with leading database, ERP, messaging and mainframe systems. - network and device gateway provides security-rich wired and wireless connectivity between IT systems and the communication network. - Offline operation, the cornerstone of “always available” access, is enabled through data synchronization and fully transactional local data management. Our data synchronization enables the direct exchange of information between mobile devices and enterprise systems -- without the need for a PC. Workers can access information and queue up transactions offline, reducing communications costs while increasing application and battery performance. - Store-and-forward messaging provides guaranteed delivery of alerts and notifications. - For smart client applications, the platform provides support for application distribution and device management. - For thin client, browser-based applications, the platform provides content delivery services to automatically detect the type of device, and customize content to fit the appropriate size and display requirements. The platform also provides support for Wireless Application Protocol (WAP) and Short Messaging Service (SMS). - we provide support for traditional wired applications, enabling information access from any environment. - addresses end-to-end security, creating an environment of trust for the mobile user.

9. Offerings Industry leading mobile, embedded, and workgroup database, data management and synchronization technologies Mobile middleware m-Business solutions Management tools for e- and m-Business applications Application platforms Mobile Internet Service (AvantGo) - iAnywhere Solutions’ m-Business platform provides a proven architecture for implementing mobile and wireless solutions quickly, with low risk. A scalable, reliable and fault-tolerant wireless server provides the foundation to handle millions of transactions from thousands of users. - open enterprise integration services allows you to preserve your existing investments when extending your current infrastructure to mobile and wireless devices. The platform enables integration with leading database, ERP, messaging and mainframe systems. - network and device gateway provides security-rich wired and wireless connectivity between IT systems and the communication network. - Offline operation, the cornerstone of “always available” access, is enabled through data synchronization and fully transactional local data management. Our data synchronization enables the direct exchange of information between mobile devices and enterprise systems -- without the need for a PC. Workers can access information and queue up transactions offline, reducing communications costs while increasing application and battery performance. - Store-and-forward messaging provides guaranteed delivery of alerts and notifications. - For smart client applications, the platform provides support for application distribution and device management. - For thin client, browser-based applications, the platform provides content delivery services to automatically detect the type of device, and customize content to fit the appropriate size and display requirements. The platform also provides support for Wireless Application Protocol (WAP) and Short Messaging Service (SMS). - we provide support for traditional wired applications, enabling information access from any environment. - addresses end-to-end security, creating an environment of trust for the mobile user. - iAnywhere Solutions’ m-Business platform provides a proven architecture for implementing mobile and wireless solutions quickly, with low risk. A scalable, reliable and fault-tolerant wireless server provides the foundation to handle millions of transactions from thousands of users. - open enterprise integration services allows you to preserve your existing investments when extending your current infrastructure to mobile and wireless devices. The platform enables integration with leading database, ERP, messaging and mainframe systems. - network and device gateway provides security-rich wired and wireless connectivity between IT systems and the communication network. - Offline operation, the cornerstone of “always available” access, is enabled through data synchronization and fully transactional local data management. Our data synchronization enables the direct exchange of information between mobile devices and enterprise systems -- without the need for a PC. Workers can access information and queue up transactions offline, reducing communications costs while increasing application and battery performance. - Store-and-forward messaging provides guaranteed delivery of alerts and notifications. - For smart client applications, the platform provides support for application distribution and device management. - For thin client, browser-based applications, the platform provides content delivery services to automatically detect the type of device, and customize content to fit the appropriate size and display requirements. The platform also provides support for Wireless Application Protocol (WAP) and Short Messaging Service (SMS). - we provide support for traditional wired applications, enabling information access from any environment. - addresses end-to-end security, creating an environment of trust for the mobile user.

10. Product Lines

11. SQL Anywhere Studio Target Markets Mobile enterprise solutions Providing anytime, anywhere access to enterprise data, information and applications Embedded applications Incorporating a full-featured, small footprint enterprise database in third party applications Small to medium sized businesses Offering the power of an enterprise database to smaller companies and organizations with remote offices Web-based applications Integrating database capabilities with Web-based applications

12. Product Lines

13. Customers

14. iAnywhere Product Overview

15. Mobile Middleware Products AvantGo M-Business Server A platform for extending Web applications and services to handheld devices without recoding Manage Anywhere Studio A complete solution for managing applications and hardware from a single management console Pylon A family of solutions for providing mobile access access to PIM, e-mail, databases and custom applications

16. Pylon Anywhere

17. Mobile Enterprise Solutions Mobile Sales One-touch access to critical customer and opportunity information on handheld devices Mobile Pharma Critical drug and physician data at sales rep’s fingertips Mobile Inspection Automated, real-time solution for inspection, asset tracking, loss prevention, safety and environmental audit tasks My AvantGo Delivery of Web content and advertising to PDAs

18. iAnywhere Mobile Inspection Enables companies to reduce errors and improve productivity and data quality by replacing paper-based field data collection processes with an electronic handheld application Target Audience: Organizations that do extensive clipboard-based field data collection (government, mfg, construction, etc.) Current Customers: EPA, U.S. Geological Society, SGS

19. SQL Anywhere Overview

20. SQL Anywhere Studio Components Adaptive Server Anywhere (ASA) Small-footprint, self-managing relational database with high reliability, high performance out of the box, and a full range of SQL features across a variety of platforms. UltraLite Database system for small devices, including Palm OS, Pocket PC, and Java-based devices, providing full transaction-processing support, a choice of development models, and synchronization with enterprise data stores. MobiLink Synchronization technology for sharing information among relational databases while maintaining the integrity of transactions across the entire system.

21. SQL Anywhere Studio Design Goals Ease of use Performance out-of-the-box Embeddability Interoperability/Open architecture Cross platform support Being responsive to our customers!

22. High Performance Out-of-the-Box Self-tuning query optimizer Begins working automatically, no configuration required Devises efficient ways to execute SQL statements, based on required resource estimates and stored statistics Continually tunes selections based on past results Dynamic cache size adjustment Automatically grows when it can usefully use more memory Releases additional memory when no longer needed Graphical optimization tools Series of tools to assist in optimizing database design, including Index Consultant, Performance Monitor, and procedure profiling

23. High Performance Out-of-the-Box

24. Small Footprint, Enterprise Caliber

25. Small Footprint, Enterprise Caliber

26. Easy to Use, Easy to Administer Self-maintaining Automate common admin tasks, such as backups Auto start/stop of database server Server starts when connection attempt made Server stops when no longer any connections Ensures unused resource not tied up Simple installation Silent installation Pre-built InstallShield templates Ability to deploy pre-configured databases Transferable database files Database files are binary compatible across platforms Simplifies deployment & reduces support costs

27. Easy to Use, Easy to Administer Simple administration tools Sybase Central database management tool Interactive SQL database utility Query editor Stored procedure debugger PowerDesigner - design, generate, document, and maintain databases InfoMaker - create sophisticated and effective custom reports of data Robust reliability Automated failure recovery “The best indication we made the right decision is that we get virtually no support calls. SalesExpert with SQL Anywhere just works.” – Gary Clark, CSD Software

28. Open Tools and Technology Support Data access ADO.NET, ODBC, JDBC™, OLE DB, Sybase OpenClient™, Embedded SQL, SOAP, XML Development tools Java, Sybase PowerBuilder and Pocket PowerBuilder, Microsoft Visual Basic, Visual C++, and Visual Studio .NET, Symantec Visual Café, Borland Delphi & JBuilder, AppForge MobileVB, Metrowerks CodeWarrior and PHP & Perl drivers Platform Support Windows (32 and 64 bit), Mac OS X, Netware, Linux (32 and 64 bit) and a range of UNIX variants (32 and 64 bit) Microsoft Windows CE and Palm OS

29. Unmatched Minimum TCO Results of July 2002 TCO Study by Aberdeen Group: Full report is available from www.ianywhere.com website.

30. SQL Anywhere 9 New Feature Overview

31. ASA New Features - XML Customers can IMPORT and EXPORT XML data, allowing easier integration with other systems that use XML as a data transfer mechanism XML Export: FOR XML AUTO, FOR XML RAW, FOR XML EXPLICIT XML Import: OPEN XML( handling of XPATH queries ) SQLX functionality: xmlelement(), xmlforest(), xmlgen(), xmlconcat(), and xmlagg()

32. ASA New Features – XML Benefit to Customers OEM embedded partners can integrate with their customer’s existing system. Developers save time because they don’t have to implement all the XML parsing and generation themselves

33. ASA New Features – Web Services ASA now has an embedded HTTP server, allowing users to connect to the database server from a variety of clients, including web browsers HTTP/HTTPS Server Customers can implement web services directly inside the ASA server using standard stored procedures XML, HTML,RAW support SOAP/WSDL support

34. ASA New Features – Web Services Benefit to Customers Developers can easily create web services, with their existing database and SQL skills, and do not need to be retrained, or to install new complex server software. ASA can be integrated with open web service environments, such as .NET

35. Sixty Seconds to Create a Web Service dbinit web.db dbeng9 -xs http web.db From dbisql: CREATE SERVICE list_tables TYPE ‘html’ AUTHORIZATION OFF USER dba AS SELECT * FROM SYSTABLE Access http://localhost/web/list_tables from a web browser

36. Web Services

37. ASA New Features – ADO.NET Driver ASA now enables native connection from .NET languages Supports both .NET Framework and .NET Compact Framework Benefit to Customers Developers save time, and can access the full power of ASA, easily from their .NET application

38. ASA New Features – New Platform Support Macintosh OS X Windows 64-bit Itanium Linux 64-bit Itanium HP-UX 64-bit Itanium Complete List of ASA Supported Platforms Available At: http://www.ianywhere.com/products/supported_platforms.html

39. ASA - Enhanced Performance and Scalability Index Consultant Recommends indexes to improve query performance Permits “what-if” analysis on existing query load Can be used to find indexes that are unnecessary Enhanced Query Optimizer New cost-based optimization techniques Histogram and selectivity estimation improvements Query Execution Engine Improvements Improved sequential and index scan performance Redesigned cache management system improves scalability for large multi-user environments Implementation of different sub-query execution methods Improved hash join performance with better memory management Adaptive query optimization techniques

40. Break Try to keep break to 15 minutes.Try to keep break to 15 minutes.

41. Index Consultant Demo

42. Benefits - Enhanced Performance and Scalability  Index Consultant Provides administrators and developers with an easy-to-use way of optimizing performance by suggesting most appropriate indexes Users save time with faster running applications Enhanced Query Optimizer and Query Execution Improved performance with larger databases and more complex queries and applications Improved scalability for larger number of users and multi-processor environments

43. Performance, performance, performance

44. ASA New Features – Enhanced Functionality Support for Advanced SQL Functionality RECURSIVE UNION INTERSECT and EXCEPT SELECT over a stored procedure Support for outer references in derived tables ORDER BY, TOP N support in views and derived tables Better display output of string, date histograms OLAP support VARIANCE, STD_DEV aggregate functions ORDER BY clause for LIST aggregate function GROUP BY ROLLUP Support for multiple DISTINCT aggregate functions in a single SELECT block

45. ASA New Features – Enhanced Functionality ALTER INDEX statement can rename an index, or alter its clustering attribute Better scalability – new lock-free cache manager Support for clustered indexes (introduced in 8.0.2) Ability to create an index on a function Automatically adds a computed column “column-name” to the table Creates an index on the computed column Relies on the optimizer to replace any function occurrences with the computed column Non-transactional temporary tables Unaffected by COMMIT or ROLLBACK; no entries made to rollback log

46. ASA New Features – Enhanced Functionality Procedure, trigger, and view text can be hidden from other users by using SET HIDDEN (8.0.2) LOAD TABLE can be used on local temporary tables (8.0.2) UUIDs and GUIDs can be used as surrogate keys - see newid() function (8.0.2) XML data type Event handling improvements: Three new parameters for event_parameter: ScheduleName APPINFO DisconnectReason: ‘from client’, ‘drop connection’, ‘liveness’, ‘inactive’, ‘connect failed’

47. ASA New Features – Enhanced Functionality Benefit to Customers Developers can do more with their data, enabling richer applications solving the needs of a wider variety of businesses.

48. ASA New Features – Improved Admin Tools Faster startup time Interface redesign More tabs (right pane) to display object information Code editor and table editing in place Object-specific toolbar buttons SQL statement log and server messages window Several new wizards Stored Procedure debugger integration Benefit to Customers Developer Productivity – Faster access to the information that is needed

49. SQL Anywhere 9 New Features Mobilink & Ultralite Edwin Ramos Remaining new feature overview focuses on UltraLite/MobiLinkRemaining new feature overview focuses on UltraLite/MobiLink

50. UltraLite - Overview of New Features New development options Dynamic SQL New C++ Interface Third party tool integration (ActiveX, AppForge, .NET, Java) Schema upgrades possible Multi-process access support Concurrent synchronization Miscellaneous new features

51. UltraLite - Application Development Differences Static Interface (Traditional): Defined schema & SQL statements in an ASA database Ran ULGEN to generate code Compiled generated code with customer code to produce an application Component Interface: Define your schema Pick a development language (C++, Java, BASIC, VB.NET, C#, Java script) Access the UltraLite database via an API in that language

52. UltraLite - Dynamic SQL Queries & statements built at runtime instead of development time Support for a subset of what ASA supports SELECT, INSERT, UPDATE, DELETE No sub queries or UNION CROSS and LEFT OUTER joins supported Syntax directed optimization Prepare a statement, set parameters, execute

53. UltraLite New Features – Dynamic SQL Benefit to Customers Development more straightforward for SQL users No need for analysis step during development Data structures used to execute SQL statements can be built as required For an application with MANY SQL statements (>100), a dynamic SQL app may be smaller

54. New C++ Interface Object interface for access to the UltraLite database Defined in uliface.h Similar to ulapi.h (Connection, Table and ResultSet objects) but significant differences Adds Schema and PreparedStatement objects Looks like the component interfaces Benefit to customers New C++ interface facilitates 3rd party tools integration

55. Component Additions UltraLite.NET Very similar to Native UltraLite for Java Works with any .NET language (C# and VB.NET) ActiveX The eVB component has been tested in PocketIE Benefit to Customers Additional development options for developers

56. UltraLite – Schema Upgrades Schema file used to create new databases Schemas can be altered after apps are deployed Generated code will detect schema changes and apply them New API method allows applications to explicitly alter schema via a schema file Data will be preserved where possible

57. Multi-Process Database Access UltraLite runtime runs in its own process space (CE & Windows only) More than one client application can access an UltraLite database at a time Apps must link against a different runtime dbuleng9.exe must be deployed with the application Only available with the new interface   

58. Database Access During Synchronization Previously, all other threads accessing the database were blocked during sync Full access available during download Read-only access available during the rest of the synchronize The following will return an error: Attempt by a thread to modify the database during a non-download phase Attempt by a thread to sync during synchronization

59. Palm Features Palm schema is no longer generated into the data segment Dynamic memory is used instead Implies OS 3.5 and 4-8 MB devices 9.0.1 should use even less memory Schema code unreadable now ULSEGDB will be considerably smaller

60. New Temp File Contains Temporary tables (rows and indexes) Transaction pages (not a transaction log) Suspended state information (Palm) Means better performance Less fragmentation of the store Less data checkpointed ul_tmp_CRID replaces ul_mem_CRID and ul_state_CRID

61. Component Improvements More integration with AppForge’s MobileVB ConnectionParms object representing access to an UltraLite database (not available in the C++ interface)

62. MobiLink New Features – Server Initiated Sync Synchronization is currently client initiated Server initiated Sync allows: Download data that cannot wait for remote user Upload data that cannot wait for remote user Frequently requested feature Benefit to Customers Allows greater flexibility in the design of synchronization architectures

63. Server Initiated Sync – How Does It Work?

64. Server Initiated Sync 

65. MobiLink New Features – File-Based Download What is File-based download? Ability to send a download as a file File can be shared by many remotes Does not replace normal synchronization Benefit to Customer Reduces load on server Can take advantage of cheaper bulk transport Allows download over any medium that support file transfer (including restartable file transfer)

66. MobiLink New Features – Sync Flexibility More synchronization options Upload only download only TCP/IP liveness Additional Scripts provide more control over synchronization process Enhancements to scheduling Performance and monitoring enhancements Benefit to Customers Greater flexibility in designing synchronization architectures

67. A Quick Look at Pocket PowerBuilder

68. Pocket PowerBuilder Key Features Productive 4GL IDE Supports complete development cycle Rich component set Visual development with minimal coding DataWindow control Single component providing sophisticated data representation Built in SQL for selects, updates, inserts and deletes Tight integration with SQL Anywhere Studio Easily develop mobile ‘smart client’ applications with ASA Integration with MobiLink for data synchronization

69. Pocket PowerBuilder Key Features Productive 4GL Environment Complements PowerBuilder for Windows CE deployments Based on core PowerBuilder IDE Similar look and feel, but separate IDE Ability to export PB projects and import them into Pocket PowerBuilder Rich Set of components Command Button, Picture Button, CheckBox, Radio Button, Static Text, List View, Tree View, List Box, DropDown List Box, Edit Mask, Single Line Edit, MultiLine Edit, Progress Bar, Scroll Bars, Line, Oval, Rectangle, Tabs, and many, many more!

70. Pocket PowerBuilder Key Features Productive 4GL Environment

71. Pocket PowerBuilder Key Features DataWindow Control Advanced control for displaying and manipulating data Available in many formats Freeform Graph Grid Group Tabular Reuse existing DataWindows with little effort

72. Pocket PowerBuilder Key Features DataWindow Control

73. Pocket PowerBuilder Key Features SQL Anywhere Integration Adaptive Server Anywhere mobile database Uses full data storage capabilities of Adaptive Server Anywhere on Windows CE client Database access via ODBC MobiLink data synchronization MobiLink bi-directional data synchronization used to integrate with other enterprise databases (Sybase ASE and ASA, Oracle, MS SQL Server, IBM DB2) New component to manage synchronization properties

74. Pocket PowerBuilder Demo

75. Wrap-up

76.

77. Conclusion SQL Anywhere 9 offers: Support for XML / Web Services Integration with .NET platform Enhanced Performance & Scalability Advanced Developer Productivity Availability Developer edition is NOW available !! Windows version shipped in September 2003 Mac OS X and Unix versions including Linux will become generally available in Q4 2003

78. Customer Success Story

79. Thank You! Thank you for coming! QUESTIONS ???

80. Try to keep break to 15 minutes.Try to keep break to 15 minutes.