Sybase 12.5 new features fully demonstrated

ASE12.5.0.3 new Features

I. Performance Monitoring system table

A new set of systems performance monitoring system tables, using the information in these system tables is very convenient for analyzing ASE server. These performance monitoring system tables are also the basis of Db-xray's work.

MDA tables, installation and configuration documentation, this is useful.

Second, multiple temporary libraries

Can let you in the System Pro

Create a user staging database outside of tempdb. The primary purpose of using multiple staging databases is to mitigate contention for system tables and log tables in the system's staging database.

Iii. External File system

Enables you to access the external file system through SQL language and maps the datasheet to the file directory or file of an external file system by creating a proxy table.

Accessing the file directory

accessing files

This is going to licenses.

Iv. Java and XML applications in DB

The adaptive server provides a Java runtime environment in which Java code can be run in ASE. The database server ASE provides a new way to manage and store data and application logic.

The following three methods can be used in ASE to use Java features:

Using Java classes as SQL data types

Calling Java methods in the database

Storing and querying XML in a database

V. New enhancements and NEW functions

Disk Resize

Sampling:update Statistics

Variable page size

Large column size

Migrate Utility

ALS (asynchronous Log service)

Server Dynamic Parameter configuration

Function

Year (date_expression): Part of the middle-aged expression

Month (date_expression): Part of the month in an expression

Day (date_expression): An expression of the Zhongtian part

Str_replace (String_expression1, String_expression2,

STRING_EXPRESSION3): Replaces the String_expression2 string in String_expression1 with the String_expression3 value.

Left (character_expression, integer_expression): Returns a string that specifies the number of characters in the left-hand side of the string.

Len (string_expression): Returns the number of characters (character) for a string, noting that it is not a byte number and does not contain an empty partition.

Square (numeric_expression): Returns the square number

NEWID ([Optionflag]): A readable random string that produces a 32-bit or 36-bit (including dash).

VI. SQL Debugger

ASE12.5 provides a command-line debug tool SQLDBGR that you can use to debug tracing of stored procedures and triggers.

ASE 12.5.1 New Features

One, Dynamic Data caching

The ASE 12.5.1 can dynamically change the data cache without restarting the ASE server as in previous versions. With the dynamic Sp_cacheconfig feature, you can immediately free memory and redistribute it. With the dynamic capabilities of Sp_cacheconfig, the following tasks can be accomplished:

Create a new data cache

Space to enlarge existing data cache

Changing the type of data cache

II. automatic growth of database space

ASE 12.5.1 provides database space and database equipment automatic growth function, when the database space is not enough, the database first expands the space, when the database equipment space is not enough, the database equipment expands the space. The automatic growth of database space is set up by Sp_dbextend storage process.

Third, database loading and unloading

The purpose of loading and unloading a database is to move the database from one ASE server to another ASE server. This allows us to copy the database using the ASE External command, such as UNIX command DD or FTP. Using this method to copy the database does not require the ASE server down machine.

There are three steps to uninstalling and loading a database:

Uninstalling a database using the Unmount command

Copy related files

To mount a database using the Mount command

Use the online database command to make the target ASE server

Four, SQL derived tables

The SQL derived table (SQL derived table) is generated by a nested SELECT statement.

V. New date and time data types

ASE 12.5.1 adds two new data types to represent time and date: date and times

There are two additional functions that correspond to these two data types:

Current_date (): Back to Current date

Current_time (): Returns the current time

Vi. Task Scheduler

Task Scheduler (Job Scheduler) component

An ASE internal task: JS task

An external process: JS Agent

SYBMGMTDB database and storage process

Predefined templates (template)

Vii. further compatibility with MS SQL Server expansion features

The ASE 12.5.1 is more compatible with MS SQL Server extensions to facilitate porting applications on MS SQL Server to Sybase ASE.

ASE 12.5.2 New Features

One, statement caching (statement cache)

The statement cache enables ASE to save the executed SQL statement text so that the ASE server can compare to the SQL statement in the cache when it receives a new SQL statement, and if a matching SQL statement is found, ASE can use the previous execution plan.

Second, data backup (DUMP DATABASE) encryption

Third, the Linux system for large memory support

64G of memory can be supported after IA32 Linux uses PAE technology

Prior to ASE 12.5.2 version, up to 2.7G of memory support only