What's New in SQL Anywhere Studio
Welcome to SQL Anywhere Studio Version 9
Here are some of the highlights in this release of the Adaptive Server Anywhere database.
Scalability and performance In this release, Adaptive Server Anywhere has taken more major strides in scalability and performance. A redesign of the cache management system makes for much-improved concurrency at high numbers of users. Customers already run Adaptive Server Anywhere with several hundred simultaneous users, and this release looks to raise the bar on the scale that can be handled.
Query processing has also taken another big step forward. Innovative new algorithms make many queries run in a fraction of the time of previous releases.
While many of the performance improvement changes are built into the internals of the database server, a new Index Consultant provides administrators with an easy-to-use way of optimizing performance by guiding them through the selection of appropriate indexes.
Web services This release sees a web server built right into to the database. You can now access Adaptive Server Anywhere databases over HTTP as well as the usual client/server network protocols. Adaptive Server Anywhere now provides web services, including support for SOAP requests. Close integration into Microsoft Visual Studio .NET makes the development of web services applications straightforward.
XML in the database Client applications can now get result sets as XML, or can take XML data and store it in the database in relational form. Developers have control over the format of the XML data, which eases integration into other systems.
.NET integration Adaptive Server Anywhere version 9 is built to work with Microsoft's .NET architecture. In addition to the web services and XML features, an ADO .NET provider enables data access from Visual Studio .NET.
Even richer SQL Adaptive Server Anywhere's SQL language has been extended to enable you to do more with your data. You can carry out simple OLAP features such as ROLLUP queries, execute recursive union queries to get at hierarchical "bill of materials" data, and carry out set operations such as INTERSECT and EXCEPT.
For a complete list of new features in Adaptive Server Anywhere, see Adaptive Server Anywhere new features.