SQL921: SQL Anywhere Roadmap - PowerPoint PPT Presentation

albert
slide1 l.
Skip this Video
Loading SlideShow in 5 Seconds..
SQL921: SQL Anywhere Roadmap PowerPoint Presentation
Download Presentation
SQL921: SQL Anywhere Roadmap

play fullscreen
1 / 51
Download Presentation
SQL921: SQL Anywhere Roadmap
1010 Views
Download Presentation

SQL921: SQL Anywhere Roadmap

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. SQL921: SQL Anywhere Roadmap Dave Neudoerffer VP Engineering iAnywhere Solutions August 15-19, 2004

  2. The Enterprise. Unwired.

  3. The Enterprise. Unwired. Industry and Cross Platform Solutions Manage Information Unwire Information Unwire People • Adaptive Server Enterprise • Adaptive Server Anywhere • Sybase IQ • Dynamic Archive • Dynamic ODS • Replication Server • OpenSwitch • Mirror Activator • PowerDesigner • Connectivity Options • EAServer • Industry Warehouse Studio • Unwired Accelerator • Unwired Orchestrator • Unwired Toolkit • Enterprise Portal • Real Time Data Services • SQL Anywhere Studio • M-Business Anywhere • Pylon Family (Mobile Email) • Mobile Sales • XcelleNet Frontline Solutions • PocketBuilder • PowerBuilder Family • AvantGo Sybase Workspace

  4. iAnywhere – Who are we today? • Database • Mobile Enterprise Solutions • Mobile Portal for PDAs

  5. iAnywhere – Database • Database : From Mobile right up to Enterprise • SQL Anywhere Studio

  6. iAnywhere – Mobile Enterprise Solutions • App Infrastructure for “Always Available / Occasionally connected” smart client applications • Enterprise applications

  7. iAnywhere – Mobile Portal • Mobile Portal for PDAs • AvantGo Mobile Internet Service • 10 million registered users • ships with all CE devices • Over 2500 channels to choose from

  8. SQL Anywhere Competitive Landscape • Mobile Database • MS MSDE • MS SQL Server CE • on-device datastore • Oracle Lite • IBM DB2 Everyplace • Synchronization • Synchrologic • Microsoft • IBM • Oracle Mobile Database Synchronization SMB Database Embedded Database • SMB Database • - Microsoft SQL Server • IBM DB/2 • Oracle • MySQL • Embedded Database • Microsoft MSDE • MySQL • Sleepycat Berkley DB • Birdstep

  9. SQL Anywhere Studio Components • Adaptive Server Anywhere • 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 scalable from handhelds to large server installations. • 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 and mobile messaging technology for sharing information among relational databases while maintaining the integrity of transactions across the entire system. 5

  10. SQL Anywhere Studio Components • QAnywhere • Application to application messaging technology based on database synchronization infrastructure. Client side API in Java or C/C++ or .NET extending enterprise messaging infrastructures to mobile applications that are occasionally connected. • SQL Remote • Synchronization technology for synchronizing ASA remotes with ASA or ASE consolidated databases. Message based – direct connection not required. Alternative to MobiLink in some cases. Development plateaued, but still fully supported indefinitely. • Sybase Central • Management tool for ASA, UltraLite, MobiLink and SQL Remote. Uses a tree structure for easy manipulation and management of objects. Also includes a builtin stored procedure debugger. 5

  11. SQL Anywhere Studio Components • PowerDesigner • Physical data modeller allows complete design of database schemas. It also provides facilities to reverse engineer the schema of an existing database and to generate SQL to create any schema you design. • Infomaker • A powerful and easy-to-use reporting tool that lets you query databases and create sophisticated and effective custom reports of data. 5

  12. Agenda • SQL Anywhere Studio 8 • SQL Anywhere Studio 9 • SQL Anywhere Studio Roadmap – Jasper

  13. SQL Anywhere 8.0 Release Roadmap

  14. SQL Anywhere Studio 8 Enhancements At-a-Glance • Improved Performance • Major enhancements to query execution engine and optimizer • Additional join methods • Significantly improved predicate analysis • Histograms used for selectivity estimation • Storage improvements • New Compressed B-tree indexes • Improved security and usability • Comprehensive data encryption • Improved administration and troubleshooting tools • Visual access plan displayer • Stored Procedure Profiler

  15. Agenda • SQL Anywhere Studio 8 • SQL Anywhere Studio 9 • SQL Anywhere Studio Roadmap – Jasper

  16. SQL Anywhere Roadmap Today “Jasper” Beta “Jasper” 9.0 9.0.1 9.0.2 8.0.3 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 2005 2003 2004 2006 Timings and features subject to change

  17. SAS 9.0 Release Breakdown

  18. SQL Anywhere Studio 9 Enhancements At-a-Glance • Expanded Platform and Standards Support • XML import & export • Web services (SOAP, HTTP server) • .NET Framework and .NET Compact Framework • New platform support (Mac OS X, Netware 6.5 and 64-bit platforms) • Enhanced Performance and Scalability • Index Consultant • Query Optimizer • Query Execution • Advanced Developer Productivity • Administration tools – easier to use, integrated debugger • Expanded ASA SQL functionality – OLAP, Select over procs, recursive union • UltraLite – Dynamic SQL, .NET component, Multiple application access • MobiLink – Server initiated sync, file based downloads, more sync options, MobiLink Monitor 7

  19. ASA 9.0.1 Extended OLAP functions • GROUP BY CUBE • Additional aggregate functions • Eg. Windowed, regression • Rank(), dense_rank() Checksum all database pages Performance • Prime cache on startup • Extended optimizations 9.0 on MAC OS/X • ASA, MobiLink, Sybase Central, DBISQL

  20. Performance, performance, performance ASA 9.0.0

  21. High Performance Out-of-the-Box

  22. UltraLite 9.0.1 • Extended Dynamic SQL • Add DDL: create/drop table, index • Subquery support • ODBC interface • Subset of ODBC 3.5 • Platforms • MS Smartphone • Components • AvantGO POD • UltraLite Server support from components • Increased integration into .NET and AppForge components

  23. UltraLite 9.0.1 • Runtime Enhancements • Restartable Downloads • Start a failed download from where it left off, rather than starting over • Schema Upgrade status monitoring • Allow one app to connect to multiple UltraLite databases simultaneously • UltraLite Utilities • Unload/reload • Java UltraLite • No plans for Dynamic SQL • Java component interface to C++ UL partly replaces (supports Dynamic SQL)

  24. MobiLink 9.0.1 • Network Failure recovery • Restartable downloads • Transactional ordered uploads • Interop with public wireless, wireless LAN, dialup • IP tracking for Server Initiated Sync • Seamless integration of ASA synchronization into applications • ActiveX component for ASA synchronization • Enhanced User Authentication facilities • Java classes to aid in external user authentication e.g. LDAP • Apache redirector for MobiLink Server • QAnywhere occasionally connected mobile messaging infrastructure • C++ client for Windows • .NET client for Windows and CE • JMS Connector • Uses ASA as mobile message store

  25. SQL Anywhere Roadmap Today “Jasper” Beta “Jasper” 9.0 9.0.1 9.0.2 8.0.3 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 2005 2003 2004 2006 Timings and features subject to change

  26. Disclaimer • Statements concerning iAnywhere Solutions' new products are • forward-looking statements that involve a number of uncertainties • and risks and cannot be guaranteed. Factors that could ultimately • affect such statements are detailed from time to time in Sybase's • Securities and Exchange Commission filings, including but not • limited to its annual report on Form 10-K and its quarterly reports on • Form 10-Q (copies of which can be viewed on the Company's • website). • ----------------------------------------------------- • All of the information in this presentation are forward-looking • statements, as defined above. As such, there is uncertainty • associated with if or when any of these features will be added to the • product. Features that are less certain are marked with ‘?’. • The future feature list is large and hence there are tradeoffs to be • made. Your feedback is essential to help us make these tradeoffs.

  27. ASA Short Term Futures Release Independent: • Performance whitepaper • TPC/H benchmark • SMB marketing push ASA 9.0.2 • Native GUID type • Web service invocation as external stored procedure • HTTP 1.1 support for HTTP interface • Enhanced Soap support for more client environments • Callout for disk full conditions • SNMP agent • 64-bit application support for Solaris, AIX, HPUX • Deadlock analysis gear

  28. ASA Short Term Futures • Current Certifications: • Section 508 – Accessibility • Continue to maintain self certification on SQL Anywhere Studio 8.0 and up • C2 • Version 7.0.2 is C2 certified • Future Certifications: • Common Criteria • Complete security model: users, authentication, access control, etc. • Target Q1/2005, probably on 9.0.1 • FIPS 140-2 • Use of certified security module • Target 2005 on 9.0.2 or 9.0.3

  29. UltraLite 9.0.2 • Extended Dynamic SQL • Simple Query Optimizer • IF & Case expressions • ISQL for UltraLite • On desktop (Windows only) to any UltraLite db • Sync • Schema painter tool to generate MobiLink scripts • Components • ADO.NET driver • Pocket PowerBuilder support • mBA PODS – one button sync for data and application • Support for AppForge Crossfire

  30. MobiLink 9.0.2 • Data Sync • Grouped transactional uploads • HTTP stream enhancements • Interoperability with various proxies and gateways, cookie support • Native Apache 1.3/2.0 redirectors • mBusiness Anywhere redirectors • First Upload always works – allows recreation of dbs • AvantGo client one-button-sync • Additional platform support for Server Initiated Sync (SIS) • Kyrocera 7135, Treo 600 • QAnywhere • Minor enhancements and polish

  31. Agenda • SQL Anywhere Studio 8 • SQL Anywhere Studio 9 • SQL Anywhere Studio Roadmap - Jasper

  32. SQL Anywhere Roadmap Today “Jasper” Beta “Jasper” 9.0 9.0.1 9.0.2 8.0.3 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 2005 2003 2004 2006 Timings and features subject to change

  33. SQL Anywhere Product Strategy • SQL Anywhere Studio • ASA • Continued push into server space – SMB market and beyond • Internal rearchitecting for performance and extended life of code • Additional Performance features: Materialized views, new index type • Snapshot isolation – row versioning, new index implementation • Benchmarks: TPC/H and custom benchmark • Certifications: CC and FIPS 140-2 • UltraLite • Ease of development of UltraLite applications • Extending Dynamic SQL • Moving towards free standing database system • MobiLink • Ease of use – make it easier to create and manage scripts • Flexibility – Syncing directly to app servers • Admin Tools • Comprehensive performance analysis tool • MobiLink synchronization management • Adjacent Markets

  34. SQL Anywhere Studio Design Goals • Full featured SQL database • Ease of use • Performance out-of-the-box • Embeddability • Interoperability/Open architecture • Cross platform support • Heterogeneous Data Sychronization • Being responsive to our customers 6

  35. SQL Anywhere Studio Futures • Major components • ASA • UltraLite • MobiLink • SQL Remote

  36. ASA – Jasper • Features: • Hot Failover / Hot Standby • Admin of large dbs: faster unload/reload, dbvalid, dbbackup, index creation • Materialized views • Snapshot Isolation • Improved locking behaviour on insert at EOT • Lock escalation • Extended multi-byte character sorting • Further engine instrumentation • Resource governors • Offline dbspaces • Compatibility features with Oracle, MSSS, MySQL • ?? UTF16 encoding support • ?? Global shared temp tables (not logged) • ?? Compression / Encryption of individual columns • ?? File/Directory data via external tables • ?? Random access to BLOBs • ?? Completion of ANSI SQL 99 OLAP support

  37. ASA – Jasper • Performance: • Improved utility speed • LOAD/UNLOAD TABLE: Charset spec, binary format • Validate table • Backup • Sorting and Index creation • Improved sequential scans • ?? Improved simple statement execution times • Contention elimination on insert • Lock escalation • Intra-query parallelism • Parallel sequential and index scans • Parallel joins • Additional optimization methods • Internal: • Reduce contention eg. Row latching • New indexing methods • Rewritten catalog implementation • Expression manipulation rewrite

  38. ASA – Jasper • Administration Tools: • Performance analysis tool / Database App Profiling • Pull together index consultant, request analysis, stored proc profiling, lock analysis • Integration with source control systems (using SCC) • SQL scripts for DBISQL • Stored procedure source management • Schema definition source control • Database maintenance/management improvement • Use wizards to create tasks that can be managed and scheduled  more task oriented approach • Other • Connection wizard • Easily manage connection parameters • Rewritten launchers • More easily configurable, better error handling, easier deployment • Folder hiding • Provider wide search capabilities • JavaDoc like tool for stored procedure documentation

  39. ASA – Jasper • Removed (Deprecated) • Write files • Read only compressed databases

  40. UltraLite – Jasper • UltraLite Runtime • More than 64K rows per table • Performance enhancements • Extended Dynamic SQL and db management • Distinct on aggregates • UNION • ?? TOP N • More properties accessible through SQL • Extendded DDL • Synchronization of schema changes • ?? Windows NT runtime to handle both ANSI and UNICODE DBs • ?? Recoverable schema upgrade • ?? Predicates on publications • Support for industry standard APIs • Dynamic SQL support in ESQL • ADO.NET • ?? JDBC interface to Native UltraLite

  41. UltraLite – Jasper • Platforms: • Windows Mobile 2004 • Palm OS 6 • ?? Symbian • Administration: • Simple ISQL functionality • Schema management • ?? Sybase Central plugin or VS.NET • Removed (Deprecated): • Static SQL support • Java UltraLite • UL.NET (replaced with ADO.NET) • ??ActiveX component • Removal of schema file • Extended DDL • Sync schema through MobiLink • Internal: • Streams rewrite (performance during syncs)

  42. MobiLink – Jasper • MobiLink Administration • Synchronization Manager • Wizard to guide you through the setup of a MobiLink architecture • Specify table & column mappings • MobiLink system table management • Script generation • Remote database generation • Script version management, source control interoperability • Management of QAnywhere and Connectors

  43. MobiLink – Jasper • MobiLink Server • Named parameters in SQL scripts • Communications compression and improved error handling • New threading model for higher throughput • Enable synchronization through application servers • Object model upload & download interfaces • Specific implementation using XML • Automatic schema caching, change detection and delivery • Automatically compute changes on server so scripts don’t have to • Server Initiated Sync TCP Gateway • Better user management • Improved ODBC error handling • ?? Transmit file based download file using MobiLink • ?? Failover for MobiLink server

  44. MobiLink – Jasper • DBMLSync • Schema caching for improved performance • Data synchronization policies • sync on connect, control of failure retries, escalate persistent failures, ... • .NET component interface • Initiate synchronization from inside ASA • Script-based uploads instead of log scanning • Download only subscriptions – simplifies logging • Better error handling via hooks

  45. MobiLink – Jasper • Server Initiated Sync (SIS) • TCP Gateway – device tracking in IP network • Network connectivity information on server – supplied by listener • QAnywhere • UltraLite message store (today, it is ASA) • ?? Better BLOB management for message store • ?? QAnywhere agent UI • ?? Stored procedures to send and receive messages • ?? Ability to send files • ?? Group support • ?? Update a message that has been queued but not sent • ?? Off-line Web Services • ??Queuing of web service requests

  46. SQL Anywhere Roadmap Today “Jasper” Beta “Jasper” 9.0 9.0.1 9.0.2 8.0.3 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 2005 2003 2004 2006 Timings and features subject to change

  47. New Area Exploration • Simple Sync API • Client API to tie into MobiLink sync environment • Feed local changes up • Retrieve central changes at client • Java and/or C/C++ • Main purposes: • 1. To be used on platforms we don’t support with a db eg. RIM Blackberry • 2. To be used for very simple applications where a RDBMS is overkill eg. Use the native Palm datastore • 3. To be used in certain cases for client side dbs we don’t support eg. Access, SQL Server CE •  Probably start with J2ME environment to address #1

  48. New Area Exploration • Embedded device systems • Target ASA and/or UltraLite to platforms like embedded Linux on PPC • New platforms becoming more standardized for embedded systems (Vxworks custom config issue) • Perhaps focus on sync opportunities only? • Possibly offer a porting SDK

  49. New Area Exploration • Remote Admin: make it easier to manage applications and databases in the field • Framework for software updates (integration with Afaria management software) • Health reports from remote databases • In field performance analysis tools

  50. iAnywhere at TechWave2004 • Ask the iAnywhere Experts on the Technology Boardwalk (exhibit hall) • Drop in during exhibit hall hours and have all your questions answered by our technical experts! • Appointments outside of exhibit hall hours are also available to speak one-on-one with our Senior Engineers. Ask questions or get your yearly technical review – ask us for details! • TechWave ToGo Channel • TechWave To Go, an AvantGo channel providing up-to-date information about TechWave classes, events, maps and more – also, keep up to date with the TechWave Newsletter – now available via your handheld device! • www.ianywhere.com/techwavetogo • Mobile and Wireless Email using Pylon Anywhere • iAnywhere is providing access to your corporate email at TechWave using Pylon Anywhere. You can keep up-to-date with your latest email, calendar, contacts, and tasks from your PDA or any Web-client! Visit the iAnywhere demo station in the Sybase booth or our “Ask the Experts” area in the Technology Boardwalk (Exhibit Hall) for details on how you can evaluate Pylon Anywhere yourself!