| Presentation: |
Welcome Remarks and Q & A Session
Also
Mr. Chris Young, from Cascadia Software, Inc. will
give a presentation on the new upcoming features found in the release of Galaxy
Galaxy will become ASE 15, when released.
There are more features than can be covered in this presentation, so if there is a
specific feature you would like covered, please use the
Feed Back option to let us know. Here
are some of the ASE 15.0 features (as listed on the Beta website):
| Scalability and Manageability (TCO) Features |
| Next Generation Query Processing:
Improve query performance and maintain ASE’s low TCO through reduced
maintenance requirements. Backed by ASE 15.0’s new optimizer and query execution engine,
ASE supports operational DSS through features such as star joins, hash joins, join histograms,
partition elimination, and optimization goals. |
| Row Locked System Tables/Catalogs:
Improves concurrency and throughput by reducing contention on system
tables. |
| Galaxy Partitions:
A completely new partitioning infrastructure, galaxy partitions support
physically partitioned data based on range, list, hash, or round-robin schemes. This feature
supports local and global indices, and provides the ability to perform maintenance at the
individual partition level, dramatically reducing overhead in VLDB environments. |
| Very Large Storage Support:
ASE 15.0 allows DBA's to assign over two billion devices to a single
ASE server with each device up to 4 Terabytes in size. With 15.0, the size limit for
individual databases is now 32 Terabytes when using 16 Kb database pages. |
| Execution Metrics:
Track query performance metrics to find bottlenecks and optimize
systems. Analytical applications can access stored metrics using SQL. |
| Automatic Database Expansion:
Eliminates downtime due to full databases via thresholds that can
automatically increase database and device sizes. DBAs can implement this through
Sybase-provided default stored procedures or customized site-specific rules. |
| Automatic Update Statistics:
Eliminates guesswork by automatically running update statistics in
the background when a system generated data change metric matches a DBA defined policy. |
| Application Enabling Technology Features |
| Computed Columns and Functional Indexes:
Increased flexibility for developing complex queries and the ability to
index on complex data types. |
| Scrollable Cursors:
Scan in any direction or directly access any row in the result set. |
| UNITEXT Data Type Support:
Expands on ASE’s Unicode capabilities by providing UNITEXT data type
support along with the existing UNICHAR and UNIVARCHAR data types. |
| Large Identifiers:
Provides increased naming flexibility in multi-byte character set
environments by expanding most identifier names from 30 bytes to 255 bytes. Examples
include names for tables, columns, indexes, views, stored procedures, variables, and
data types. |
| XML: Extends
ASE’s native XML capabilities to include XML storage validation, enhancements to SQL-XML
transformation and performance enhancements. ASE 15.0’s expanded XML capabilities address
the growing need to manipulate and store XML in the database tier natively. |
| Real Time Messaging:
Building on the real-time messaging capabilities in ASE 12.5.2
to become the messaging hub for enterprise applications, 15.0 extends capabilities to
popular messaging systems like IBM MQ, and provides support for highly resilient and
asynchronous messaging. |
| 64-Bit Integer SQL Data Type:
Provides efficient handling of values up to 9.22 x 10e18
(9 followed by 18 digits). |
| ODBC Driver (Windows & Linux) |
| ADO.NET Provider (Windows) |
| Security Features |
| FIPS 140-2 Compliant SSL Support |
| ISO 15408 Common Criteria Certification |
All members and guests should plan to attend this informative presentation.
|
