Database Technology Trends

Everywhere we turn this year, we see database technology companies continuing to grow and expand with new offerings for improving computer systems to help you support your company’s important business decisions.

This month’s newsletter describes 3 database technologies that offer new promise for improving performance: Sybase® ASE 15.7, Sybase® IQ 15.4, and Microsoft SQL Server® 2012 RC0.

On September 13th this year, Sybase announced availability of Sybase® Adaptive Server Enterprise® (ASE) 15.7. This is exciting news for our database community. According to Carl Olofson, research vice president at IDC, "Sybase has made significant enhancements to optimize data storage and increase developer productivity in ASE 15.7." "These new features . . . add to ASE’s already impressive total cost of ownership."

ASE 15.7 (the most feature-rich release in their history), is offering many new capabilities. Some of the most important ones include:

• Analyzing Dynamic Parameters
• Compressing Data in Adaptive Server
• Creating Non-materialized, Non-null Columns
• Cursor changes
• ERP certification on Sybase ASE
• Expanded Variable-Length Rows
• Fully Recoverable DDL
• Large objects changes
• Like Pattern matching changes
• Nested select statement enhancements
• New Adaptive Server Kernel
• New security features
• Retaining monitoring data
• Select for update changes

For more detailed information, see Sybase’s full feature list at:

http://www.sybase.com/detail?id=1094783 .

Sybase has also launched the new version of the Sybase IQ high performance column-based analytics database. Sybase IQ® 15.4 is addressing the new generation of Big Data. DBA’s and database developers can use this version to store large amounts of unstructured data, and web log information. Sybase tells us we’ll be able to use a "have it your way" approach.

Some new capabilities to consider are: a native MapReduce API, Predictive Model Markup Language (PMML) support, and integration with Hadoop. You will be able to federate a query between IQ and Hadoop. The new APIs will allow developers to implement in-database algorithms with greater performance results.

PMML capabilities will work with predictive models in industry-standard analytics tools, and then be able to automate their execution in Sybase IQ. These features can also be combined with text and multimedia analytics, using a range of techniques for analyzing big data.

Some other advantages with this new version are:

• New Java API and new extensions to the C++ APIs, allows implementation of high performance proprietary or certified ISV algorithms in-database.
• In-database analytics simulation environment eases development and testing.
• Compression of text data works well with other big data scenarios.
• Faster bulk loading of large data sets works through ODBC and JDBC interfaces

For more details on Sybase IQ 15.4 see Sybase’s what’s new datasheet at:

http://www.sybase.com/detail?id=1095620.

Microsoft announced SQL Server 2012 Release Candidate (RC0) last month, with its Cloud offerings.

There are three main SQL Server 2012 editions – Enterprise, BI (Business Intelligence), and Standard. Microsoft is still offering Web Developer and Express versions of SQL Server 2012.

At Dobler Consulting we’re seeing some exciting new features with this version:

Cloud Advantages

• SQL Server Data Tools
• Data-tier Application Component (DAC) parity and increased object support with SQL Azure
• SQL Azure DataSync
• Support for OData

Mission Critical Abilities

• SQL Server AlwaysOn
• ColumnStore Index
• User Defined Roles
• Distributed Replay

Breakthrough Insight

• Power View Web-based Data Visualizations
• BI Semantic Model
• Data Quality Services
• Migrate PowerPivot models into SSAS

Our conclusion . . . Sybase and Microsoft are offering us innovative and exciting new ways to manage our database systems and improve performance.

Download SQL Server 2012 RC0 via this link:

http://www.microsoft.com/download/en/details.aspx?id=28145 .

Keeping up with the news from so many different sources is getting harder and harder these days. That’s why I try to offer a one-stop-shop for your major database vendor news. You get the scoop and if you want to dig deeper, the links are right there. Let’s get started.

Sybase

I am not anticipating any new Sybase ASE version before this summer. None are announced. This is due to the massive efforts of certifying SAP R/3 on Sybase ASE, which is expected by the end of Q2. There were many joined events between SAP and Sybase since Sybase’s acquisition by SAP. The most notable is SAP TechED. The latest was in Berlin and drew a lot of interest, especially into Sybase mobility as well as Sybase IQ and ASE.

This year Sybase TechWave 2011 will be hosted within the SAP TechED USA in Las Vegas. This is the much needed boost for Sybase to a larger audience.

Sybase IQ 15.3 is expected to be released soon. The beta tests are going for quite a while. The highlight for Sybase IQ 15.3 is the PlexQ Distributed Query Platform, a Massively Parallel Processing (MPP) architecture that accelerates highly complex queries by distributing work to many computers in a grid configuration.

Sybase IQ 15.3 PlexQ Distributed Query Platform solution offers the following benefits:

• Extreme performance: enables users to harness the power of multiple compute resources in a Sybase IQ PlexQ environment to simultaneously execute queries across the grid. This is the next step after Sybase IQ 15 introduced multiple writers in the multiplex grid.
• Increased scalability: empowers system managers to easily and cost effectively scale out Sybase IQ PlexQ nodes with commodity hardware and managing SLAs in a high demand environment.
• Architectural flexibility: allows system managers to quickly and easily group subsets of compute resources as logical entities. This allows DBA to effectively utilize workload balancing and resource sharing.

2011 will be a very interesting year for Sybase and as I stated many times before, SAP made all the difference. Sybase is on its way back to gaining market shares as well as market interest.

Click here to read more about Sybase IQ.

Oracle

No, Oracle 12g is not here, yet. There is little or no information available on this topic. The only leaked information so far is that raw devices will no longer be supported. Well, you saw this coming, right? With the maturity of ASM you will probably skip raw devices even sooner.

Let’s focus on the latest release 11g R2. Many of the new features are focused on the cluster.

Single-Instance RAC: This will replace the custom DBSTART scripting DBAs had to do to automatically start all the Oracle instances upon system start. This will implement the restart features every node in a cluster is accustom to.

Cluster Time Synchronization Service: Synchronizing system times across all RAC nodes can be a chore. If you’ve ever experienced a node eviction within a Real Application Cluster database’s cluster configuration, you know how difficult it can be to tie together the train of events that caused the eviction.

ASM: Many new features that offers better support for clusterware.

ACFS: The ASM Clustered File System is the successor of the OCFS and the OCFS2. This allows for better management of the voting disk in a RAC configuration.

Improvements to software installation and patching: The previously standalone Cluster Verification Utility (CVU) is now integrated into the Oracle Universal Installer. Plus there is a new zero-downtime patching for clusterware.

There are several performance improvement features in 11g R2, especially for data warehouse environments.

These include:

• Instance “Caging”
• Automatic Degree of Parallelism
• Parallel Data Cache: In-Memory Execution.
• Faster Refreshes of Materialized Views

Data Guard: New disaster recovery options and better standby database management.

All these improvements and new features are part of the paradigm shift of Oracle that moves the database management closer toward a self-tuning, self-managed and self-healing database system.

Click here to read more about Oracle 11g R2

SQL Server

After 2 releases of SQL Server 2008 and SQL Server 2008 R2, Microsoft is releasing the new SQL Server 2011, code name Denali. At a first glance this is a developer’s release. Many new features are geared to better support SQL developers and a better integration into Visual Studio is also a key improvement.

Here are some of the new features:

Multi-Subnet Failover Clustering: This feature allows to geographically separate cluster nodes to provide disaster recovery and high availability. This feature depends on Windows Server failover cluster.

Sequences: Oracle style sequences for unique key value generation. Finally!

Query Paging: This is a feature that MySQL offers for years and now SQL Server is offering as well. Paging through result sets has some distinct performance advantages and simplifies coding efforts for developers.

The most significant change is the drop of DTS package support. This is not actually an announced feature, but an observation within SQL Server Management Studio. The Data Transformation Services menu option under the Legacy section has been removed. I think it is time for the hold outs to convert their old DTS packages to SSIS.

A little side note, SQL Server Management Studio now offers support for multi-screen environments.

Click here to download a trial of SQL Server 2011

Conclusion

Here you have it, a potpourri of new database technologies across vendors and systems. I hope you found something of interest to you and as always, please leave feedback.

Until next time,

Peter Dobler

First of all I have to apologize to my loyal readers for the long absence from my blog. In simple terms, “I got busy”. But in these economic times, I guess this is a good thing. I don’t want to give a promise I can’t keep, but I will do my best to keep this blog up-to-date.

The past few years were dominated by all major database vendors introducing and improving their database cluster products. There is the bread of shared nothing clusters like Microsoft SQL Server 2008 and there are the share everything clusters like Oracle and Sybase. You can read all about this in my previous post “Grid Databases – The Future of Database Technology?“.

It is amazing how far these technologies have come and how much we got used to “always available” databases. You know what’s coming next. Now, that we have uninterrupted access to data, it would be great if we get the data faster. Well, the database vendors have an answer for that as well.

It was about 7 years ago when I first was introduced into the concept of in-memory databases. At the time it was less known database vendor called Times-Ten that offered an in-memory database with blazing performance metrics, hence times ten. It was the perfect answer to solid state disk drives that could drain an IT budget in a hurry.

Apparently this technology was so intriguing that Oracle decided to buy Times Ten and make it Oracle’s in-memory database. The only downside to this is, it is not an Oracle database in memory, it is Times Ten’s engine running in memory. This creates admin nightmares to have special skills to manage the Times Ten engine in addition to the Oracle server, as well as different software development techniques for both systems. Performance gains out weight manageability concerns, I guess?

Just recently Sybase announced its Sybase ASE server, in version 15.5, will have an in-memory engine equivalent that will provide the same functionality and manageability as the standard Sybase ASE server. This is a remarkable step, because it provides performance gains transparent to client applications and the database engine will not challenge DBAs to learn new skills. To me this is a win-win situation.

Microsoft is still in the planning and rumor phase of providing an in-memory database for its next version of SQL Server. The code name for the next SQL Server upgrade is Kilimanjaro. This is the name to use when searching for upgrade information. It is not clear when the new SQL Server release will be available and it is not clear if it will be named SQL Server 2010. It depends if it gets out this year or not.

IBM has its own in-memory database for DB2 and I believe it is a Java based and Java supporting engine. I have to admit that I’m not as fluent with DB2 as I wish to and please add your comments to this post if you’re a DB2 expert.

Having listed all the in-memory contenders, the question pops up “What about Sybase IQ?” or any other data warehouse database for that matter, Terradata and Netezza for example.

The answer lies in the architecture of in-memory databases. They are designed to improve transaction processing volume, the classic OLTP applications. Data warehouses would not have any benefits from in-memory databases. In-memory databases provide extreme high-speed transaction processing without the need to confirm disk write success. Traditional databases have one thing they have to do to ensure data integrity. They all need to wait for the disk i/o to confirm a write to disk. Database vendors came up with very complex and sophisticated caching techniques to overcome this performance challenge. But they cannot ignore this fundamental requirement.

In-memory database bypass this disk writing requirement and that’s what improves the speed. Designed for high volume transaction systems, like e-commerce shopping carts, in-memory databases are unbeatable when it comes to writing transaction data. And this is fundamentally different to data caching of traditional database engines. Data caching improves read performance, but does nothing to improve write performance.
There is a downside to these databases as well; they offer alternatives to performance problems in poorly written applications. Like powerful hardware, in-memory database have the potential to mask poor application development. We might see an explosion of in-memory database implementations due to this matter.

Bottom-line: this is cutting edge technology that will give database architects another tool in the toolbox to design the most effective database environment. Do yourself a favor and try to get your hands at a test environment to experience this technology first hand. Yes, 2010 could be the year of in-memory databases.

Thanks for listening,
Peter