Follow Us

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message

Sybase ups RDBMS encryption and data integration

Adds to data integration suite.

Article comments

Sybase has boosted the encryption and manageability of its relational database management system (RDBMS). It has also found the time to partner up with DataFlux to strengthen its data integration product suite.

The database vendor announced this week a new version of its RDBMS, Adaptive Server Enterprise (ASE), which it claimed offered improvements to its encryption, database development, archiving options, as well as performance upgrades.

Sybase said that its ASE encryption allowed any column in the database to be encrypted with one command, so a full table or the entire database does not have to be encrypted. The database vendor believes this will allow companies to safeguard sensitive data, even from internal personnel such as database administrators.

Sybase believes that ASE encryption does not require changes to applications, as Sybase ASE’s optimiser takes into account column properties (for example whether a column is encrypted or not) when solving a query.

Version 15.0.2 of ASE also provides a number of features to improve the productivity of the application programmer. It delivers Transact-SQL user-defined SQL functions (UDFs). Since these functions are written in SQL, Sybase said they could be readily incorporated within stored procedures without requiring developers to learn an additional programming language. The application developer is also helped with updatable views using the “Instead of Trigger” feature, four new statistical functions, and XML table function for better handling of unstructured text.

The archiving ability of ASE has also been tweaked, to allow DBAs to validate or selectively recover data from database backups by presenting the backup as if it were an online database.

Sybase was also keen to point out that ASE 15.0.2 “significantly improves performance for both OLTP applications and decision support systems”. It says that new features allow for fast responses when using system-level commands, irrespective of the number of users, and faster performance for creating/loading databases even with tables having triggers and indexes.

Meanwhile in a separate announcement, Sybase said that it has partnered with DataFlux in order to strengthen the Sybase Data Integration Suite with DataFlux’s SOA-enabled data profiling and data quality tools.



Share:

More from Techworld

More relevant IT news

Comments



Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story, and in case of transmission error. Both your name and the recipient's name and address will not be used for any other purpose.

Techworld White Papers

Choose – and Choose Wisely – the Right MSP for Your SMB

End users need a technology partner that provides transparency, enables productivity, delivers...

Download Whitepaper

10 Effective Habits of Indispensable IT Departments

It’s no secret that responsibilities are growing while budgets continue to shrink. Download this...

Download Whitepaper

Gartner Magic Quadrant for Enterprise Information Archiving

Enterprise information archiving is contributing to organisational needs for e-discovery and...

Download Whitepaper

Advancing the state of virtualised backups

Dell Software’s vRanger is a veteran of the virtualisation specific backup market. It was the...

Download Whitepaper

Techworld UK - Technology - Business

Innovation, productivity, agility and profit

Watch this on demand webinar which explores IT innovation, managed print services and business agility.

Techworld Mobile Site

Access Techworld's content on the move

Get the latest news, product reviews and downloads on your mobile device with Techworld's mobile site.

Find out more...

From Wow to How : Making mobile and cloud work for you

On demand Biztech Briefing - Learn how to effectively deliver mobile work styles and cloud services together.

Watch now...

Site Map

* *