LOGIN | REGISTER NOW | SUBSCRIBE
 

New Tricks for Sybase ASE Database Platform


By P J Connolly
Email    print   
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://sdt.bz/31005
 
Most Read Latest News Blog Resources
Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible
Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans
Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers
ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development
Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter


Add comment


Name*
Email*  
Country     


  • Comment
Loading




close
NEXT ARTICLE
SAP and Sybase to Fuel Enterprise Mobile App Development With Latest Release of Sybase Unwired Platform
2.1 Release of SybaseCustomer and Partner Ecosystem to More Easily and Cost Effectively Build Enterprise-Grade Mobile Apps Read More...
 
 
 
 
News on Monday
more>>
SharePoint Tech Report
more>>


   

 
 

Download Current Issue
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?


 
blogs tab
Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
02/09/2012 02:16 PM EST

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST

 
Events calendar tab
Cloud Connect
2/13/2012 to 2/16/2012
Santa Clara
TechWeb

SPTechCon: The SharePoint Technology Conf.
2/26/2012 to 2/29/2012
San Francisco
BZ Media

RSA Conf.
2/27/2012 to 3/2/2012
San Francisco
RSA

IBM Pulse Conf.
3/4/2012 to 3/7/2012
Las Vegas
IBM Tivoli

Game Developer Conf.
3/5/2012 to 3/9/2012
San Francisco
TechWeb