LOGIN | REGISTER NOW | SUBSCRIBE
 
print Printable version 
Most Read Latest News Blog Resources
Mono brings .NET to Android
At Microsoft MIX, Mono will unveil the ability to port .NET applications to the Android op...

Does Windows cost Microsoft opportunities?
Microsoft's decision to focus .NET on Windows is stifling innovation due to the specter of...

Scrum Planning Board adds automation to Axosoft OnTime
Illustrations are also included to assist Scrum-using developers a better view of what the...

Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter

New Tricks for Sybase ASE Database Platform


By P. J. Connolly
August 3, 2007 — 
Sybase has released an update to its flagship Adaptive Server Enterprise (ASE) database platform with what the company called enhancements to data protection and manageability. New statistical and XML table functions are expected to make it easier to access and use data, while extra security functions were designed to make misuse more difficult.

Although a 15.0.2 release may sound like it’s not much, this is only the second revision since ASE 15 shipped in 2005. According to the company, the seemingly minor revision number has less to do with the amount of new features, and more with the amount of disruption customers can expect when implementing this release.

ASE 15.0.2 offers additional encryption functionality by adding checks against rogue administrators, while key recovery is now available through the use of secure yet retrievable key copies.

The new release allows the encryption of more datatypes, and users without decrypt permissions can be fed selected default data. This last feature is expected to be particularly useful in testing scenarios, and in addressing the increasing concerns over the mishandling of data.

The new ASE release also provides T-SQL user-defined functions, attempting to improve productivity by allowing application developers to write functions in SQL and add them to stored procedures.

Developers can also make use of a new function that extracts multivalued elements from an XML document and assembles a SQL table from them. This allows applications to make a single call to the new XML table [or… xmltable()] function, instead of a T-SQL loop that repeatedly calls to ASE’s XML extract [or… xmlextract()] function.

ASE 15.0.2 includes new “instead of” triggers that allow the updating of all views, including those that could otherwise be updated. These are special stored procedures that perform user-defined actions, overriding a triggering statement’s default action.

Developers wishing to compute variance or standard deviation from numeric data have a new range of statistical aggregate functions to choose from in this release, as well as aliases for common functions. These can calculate standard deviation and variance for a sample, or for the entire population.

The ASE update will be particularly useful for many users in the Far East, as it includes case-insensitive dictionary sort orders for Chinese and Japanese character sets, including EUC-GB, GB-18030 and CP936 on the one hand, and EUCJIS, SJIS and DECKANJI on the other.

Also new in this release is the ability to treat database archive dumps as if they were read-only online databases, for backup validation or selective recovery. Sybase claims this is more efficient in terms of disk space as well as time. Archive databases can also be loaded with transaction logs, for verifying a restore operation.


Share this link: http://www.sdtimes.com/link/31005
 

Add comment


Name*
Email*  
Country     


  • Comment
  • Preview
Loading



 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 
Download Current Issue
ISSUE 3/15/2010 PDF

Need Back Issues?
DOWNLOAD HERE

Receive the print Edition?


 
blogs tab
Google Code turns 5
Google Code Turns 5, and adds a Paxos Algorithm to make the system more stable and reliable.
03/17/2010 11:16 AM EST

Test your Visual Studio 2010 know-how
Microsoft is offering free beta certification exams for Visual Studio 2010.
03/17/2010 11:08 AM EST

Microsoft lifts the hood on IE9
Microsoft is previewing IE9.
03/16/2010 01:10 PM EST

 

Events calendar tab
EclipseCon
3/22/2010 to 3/25/2010
Santa Clara, Calif.
The Eclipse Foundation

DevConnections
4/12/2010 to 4/14/2010
Las Vegas
Penton Media

MySQL Conf. and Expo
4/12/2010 to 4/15/2010
Santa Clara, Calif.
O'Reilly Media

High Performance Computing Linux Financial Markets
4/19/2010
New York City
Flagg Management

Informix User Conf.
4/25/2010 to 4/28/2010
Overland Park, Kans.
IIUG