SQL Anywhere 16 New Features

55 Pages·2013·1.66 MB·English

by  Hinsperger, Jason

SQL Anywhere 16 New
Features
Jason Hinsperger, Product Manager, SAP
March 6, 2013
Legal Disclaimer
The information in this presentation is confidential and proprietary to SAP and may not be disclosed
without the permission of SAP. This presentation is not subject to your license agreement or any
other service or subscription agreement with SAP. SAP has no obligation to pursue any course of
business outlined in this document or any related presentation, or to develop or release any
functionality mentioned therein. This document, or any related presentation and SAP's strategy and
possible future developments, products and or platforms directions and functionality are all subject
to change and may be changed by SAP at any time for any reason without notice. The information in
this document is not a commitment, promise or legal obligation to deliver any material, code or
functionality. This document is provided without a warranty of any kind, either express or implied,
including but not limited to, the implied warranties of merchantability, fitness for a particular
purpose, or non-infringement. This document is for informational purposes and may not be
incorporated into a contract. SAP assumes no responsibility for errors or omissions in this
document, except if such damages were caused by SAP´s willful misconduct or gross negligence.
All forward-looking statements are subject to various risks and uncertainties that could cause actual
results to differ materially from expectations. Readers are cautioned not to place undue reliance on
these forward-looking statements, which speak only as of their dates, and they should not be relied
upon in making purchasing decisions.
© 2012 SAP AG. All rights reserved. 2
SQL Anywhere – Recent History
SQL Anywhere: Performance Features
SQL Anywhere 10 SQL Anywhere 11 SQL Anywhere 12
(2006) (2008) (2010)
• Materialized views • Immediate materialized views • Self-tuning multiprogramming level
• Snapshop isolation • Merging tables • Self-healing column statistics
• Intra-query parallelism • Reduced transaction log • Improved remote data access
• Parallel backups contention • Enhanced connection pooling
• Column compression • Parallel sort • Immediate materialized views support
• New index design • Parallel index scan for OUTER JOINs
• New storage format • Index compression • Enhanced optimization of ORM-
• Checkpoint write behind • Index-only retrieval generated queries
• New catalog • Faster execution for • Improved index performance
• External Java VM inexpensive statements • Improved validation of large
• Client statement caching • Parallel archive backups databases
• Improved BLOB storage • Improved data import • New query execution cost model
control and performance capabilities • Intelligent locking when updating
• Simple statement caching primary rows
© 2012 SAP AG. All rights reserved. 3
SQL Anywhere – Recent History
SQL Anywhere: Scalability and Monitoring Features
SQL Anywhere 10 SQL Anywhere 11 SQL Anywhere 12
(2006) (2008) (2010)
• Database mirroring (high • Read-only access to • Read-only scale-out
availability) mirrored servers configurations
• Cluster agent • Database mirroring auto-
setup
• Comprehensive server
monitoring (web-based)
© 2012 SAP AG. All rights reserved. 4
SQL Anywhere – Recent History
SQL Anywhere: Developer Productivity Features
SQL Anywhere 10 SQL Anywhere 11 SQL Anywhere 12
(2006) (2008) (2010)
• Performance analysis and • Full text search • Spatial data support
application profiling • Regular expression search • Spatial data viewer
• Internationalization • Visual Studio 2008 • Sequences
• Visual Studio 2003 and 2005 integration • Select from DML
integration • .NET 3.5 support, including • External prefilter and term
• .NET 2.0 support Entity Framework breaker libraries for full text
• Deployment Wizard • JSON web services search
• Temporary procedures • New SQL Anywhere C API • JDBC 4.0 support
• Global shared temp tables • Python database API • Enhanced Java batch
• JDBC 3.0 support • External runtime operations
• IPv6 support environments (Java, CLR, • Visual Studio 2010 integration
• Table encryption Perl, PHP) • .NET 4.0 support
•Exception reporting and • ASP.NET providers • CREATE or REPLACE clause
statistics gathering • Support for Ruby
© 2012 SAP AG. All rights reserved. 5
SQL Anywhere 16
Server Highlights
Security
Security
Raw Encryption/decryption
Disk Sandboxing
Storing Certificates in the database
Dual password change control
LDAP User Authentication
– Hook into existing enterprise infrastructures for managing users and passwords
– Enable central management of password complexity policies
– Multiple domains and multiple LDAP servers
– Uses login profiles to define options for accessing and authenticating with an LDAP server
o SQL Anywhere Server connects to LDAP Server with user‟s distinguished name and password to
authenticate user.
Role Based Security
– Granular control over the privileged tasks that users can perform
o Support separation of duties: assign disjoint sets of privileged tasks to separate autonomous entities.
o Support principle of least privilege: match job responsibilities with privileges granted
– Simpler administration of access control
– Control over propagation of privileges: who can grant which privileges

© 2012 SAP AG. All rights reserved. 8
Role based access control
Roles Based Security Objectives
 Support principles of least privilege and separation of duties
 Create new permission sets to enable extreme flexibility in delegating administrative tasks
 Remove the need for a super user in the system
 Create separation between role administrators and permission owners
 Support ANSI standard syntax
 Maintain backward compatibility

© 2012 SAP AG. All rights reserved. 9
Role based access control
Background
 Permissions are associated with roles, and users are assigned to roles

Permis associated assigned
Roles Users
sions with to

 Roles
– Created based on business rules, job functions and organizational requirements
– Assign and reassign users to roles as needed
– Definitions are relatively static – while user assignments to role change frequently
– Can be arranged in arbitrarily deep role hierarchies
– Can may be configured to be mutually exclusive
– Role administrators may grant and revoke role membership without having the privilege to
o Create new roles
o Assign new permissions to the roles they administer

© 2012 SAP AG. All rights reserved. 10