LOGIN | REGISTER NOW | SUBSCRIBE
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 
Download Current Issue
ISSUE 7/1/2009 PDF

Need Back Issues?
DOWNLOAD HERE

Receive the print Edition?


 
Is the mystery Borland suitor Serena?
Borland software is considering an offer from another company after a preliminary deal with MicroFocus. Is Serena the new company?
06/30/2009 01:55 PM EST

Windows 7 - An eBayer's dream product?
Windows 7 pre-orders can make people money on eBay.
06/29/2009 03:48 PM EST

Know thine cloud provider
Cloud computing require companies to understand compliance and regulation. Third parties will play a big role in regulated industries.
06/29/2009 02:58 PM EST

 

Microsoft Worldwide Partner Conf.
7/13/2009 to 7/16/2009
New Orleans
Microsoft

OSCON (Open Source Convention)
7/20/2009 to 7/24/2009
San Jose
O'Reilly Media

XBRL Technology Workshop & Summit
7/28/2009 to 7/30/2009
Santa Clara
XBRL US

ACM SIGGRAPH
8/3/2009 to 8/7/2009
New Orleans
ACM SIGGRAPH

OpenSource World (formerly LinuxWorld)
8/12/2009 to 8/13/2009
San Francisco
IDG World Expo


 
print Printable version 
Most Read Latest News Blog Resources
Kapow automates website data retrieval
Kapow Technology's Web Data Server 7.0 can be used to create modules that navigate through...

Oracle's Fusion 11g lays groundwork for ERP platform
Fusion's components are standards-based and integrated, but some abilities are lost if non...

COBOL’s future lies in the clouds
After 50 years of use in businesses, COBOL is still lingering around mainframes. But the s...

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