SQL Anywhere Studio 9.0.1

SQL Anywhere Studio is a comprehensive package that provides data management and enterprise data synchronization, enabling the rapid development and deployment of database-powered applications.
SQL Anywhere Studio extends information in corporate applications and enterprise systems to anywhere business takes place. With more than 8 million deployed seats, SQL Anywhere Studio powers embedded database applications in desktop, server, mobile and remote office environments.
SQL Anywhere delivers enterprise caliber features, but without the bulky characteristics of an enterprise database. Its robust reliability and performance, along with highly efficient usage of memory and system resources, ensures that the database can often be hidden from laptop and desktop users.
Features:
- Full transaction processing
- SQL and Java triggers and stored procedures
- External stored procedures (callable external DLLs)
- Built-in referential and entity integrity, including cascading updates and deletes
- Dynamic, multiple database support
- Row-level locking
- XML import and export and SQLX functionality*
- Integrated HTTP server*
- Strong encryption for database files and network communications
- Event scheduling and handling
- High-performance, self-tuning, cost-based query optimizer
- Advanced query execution algorithms
- Dynamic cache sizing
- Binary Large Object (BLOB) support
- Windows Performance Monitor integration
- Online table and index defragmentation
- Online backup
- Advanced cache management system
Enhancements:
- Improved OLAP functionality(CUBE/ROLLUP)
- Performance Improvements (Parallel Index Scans/Database Server Cache warming)