** Hot News **
Just released ....
SQL Anywhere Version 16 - New Features
|New or Enhanced Functionality||Technical Benefits|
|Improved query optimization||Out-of-the-box performance|
|Advanced data synchronization with SAP HANA||Out-of-the-box performance|
|Support for SAP HANA||Out-of-the-box performance|
|Roles and privilege||Security|
|Certificates stored in database||Security|
|Database mirroring||24/7 reliable operations|
|Improved error handling||24/7 reliable operations|
|Online schema updates||24/7 reliable operations|
|Event tracing||24/7 reliable operations|
|OData support||Developer productivity|
|Row and array support||Developer productivity|
SAP Sybase SQL Anywhere Optimizer improves performance by dynamically analyzing queries and the surrounding machine state, such as CPU speed, available RAM, and more. The optimizer uses this information to generate an execution plan that minimizes runtime. In this newest version, the optimizer can evaluate a much broader set of access plans during query optimization. The optimizer also has the ability to take better advantage of system resources to improve parallelism, which further increases performance for complex reporting and analysis queries.
Advanced Data Synchronization
The synchronization process has increased scalability and performance with synchronization performance improvements to the communications protocol and to the threading model used for synchronization. The new profiler and updated synchronization modeler make it easier than ever to manage the full synchronization lifecycle, from design, to testing, and to deployment.
Support for SAP HANA
In addition to being able to synchronize data from remote SAP Sybase SQL Anywhere and UltraLite databases to a HANA consolidated database, the SAP Sybase SQL Anywhere remote data access feature now allows developers to run ad hoc SQL or create proxy tables against a HANA database from a SAP Sybase SQL Anywhere connection using the new HANAODBC remote data access server class. You can also connect directly to HANA database from DBISQL.
Roles and Privileges
A complete set of system privileges and roles increase security by following the principles of least privilege and separation of duties. A system privilege has been created for every privileged operation that can be performed in the system. When a user is assigned the role database backups, for example, that person has permission to do backups, and nothing else. A user could also be given permission to manage users and login policies.
SAP Sybase SQL Anywhere 16 encrypts and decrypts data using standard encryption algorithms, ensuring that data is not compromised when it is imported into and exported out of the database. The ENCRYPT function can encrypt data inside the database server and then it can be output into a raw format so that it can be decrypted outside of the database (with the key). Also, the DECRYPT function can decrypt data encrypted outside of the database server.
Disk sandboxing limits vulnerabilities by locking down the server and limiting read-write file operations executed from the database server to the directory on the underlying file system where the main database file is located. When disk sandboxing is enabled, relative path names are treated as relative to the directory where the main database file is located. When disk sandboxing is not enabled, relative path names are relative to the working directory of the database server.
Database mirroring helps maintain system reliability and improve performance in heavy read applications. If the server fails or the system must be taken offline for maintenance, a live, mirrored version will come online to maintain availability. Administrators can now change the mirror system configuration and add or remove nodes without taking the system offline. Events can now run on the mirror server and copy nodes in mirroring and read-only scale-out systems.
Improved Error Handling
The database server is more robust when dealing with fatal errors. When a database specific assertion occurs, for example, the database server can now take only that database offline, leaving the server up and available for any other databases still running on it. Similarly, on the client side, if a client receives an out-of-memory error while executing a database operation, rather than terminate the application, the database client now returns the error to the application and gives the application the opportunity to handle it.
Online Schema Updates
The database server now supports the creation of new indices on tables without requiring exclusive access to the table for the entire duration of the create index statement. Users can continue to access the table while the index is being created.
Application developers can use event tracing in production systems with minimal performance impact to more easily debug and troubleshoot application issues. Event tracing records information about system-defined and user-defined trace events to an event tracing target. A trace session is made up of trace events (specific points in the database server software or your SQL application) that collect information that is logged to a target, such as a file). Event trace files can be merged, filtered, or translated to readable forms such as text or XML.
SAP Sybase SQL Anywhere has added web services support. The OData Server allows web clients to communicate with an SAP Sybase SQL Anywhere database server using the OData protocol. Web clients can send OData requests to a configurable OData Producer hosted in an HTTP server, which converts OData concepts into relational database operations.
Row and Array Support
SAP Sybase SQL Anywhere simplifies programming and makes it easier to access data with new support for ROW and ARRAY data types. A ROW constructor and an ARRAY constructor support composite data types that can be used as variables, procedure parameters, and function return types. SQL functions and procedures accept ROW and ARRAY data types as IN, OUT, or INOUT arguments.
Regards ... Chris