Posts Tagged ‘Vector Approach’

Sybase News 2010 Q1

Sunday, February 21st, 2010


Sybase IQ

Sybase’s secret is out. Gartner officially acknowledges that Sybase IQ belongs into the leader quadrant of its Data Warehouse Database Management System Magic Quadrant. Click here to read Sybase’s announcement.

I am working with Sybase IQ since 2001 and I always knew that the column vector approach has tremendous advantages in a large volume data warehouse environment. As for many other products of Sybase, the focus was solely on the superior database engine. This pretty much excluded all non technical people from experiencing the Sybase IQ advantage. Click here to read about the latest performance record set by Sybase IQ.

With the introduction of Sybase IQ Options, these advantages are now transparent to not so technical people as well. This is an important step in the right direction. Database technology is not driven by DBAs and infrastructure managers, but by business analysts and application architects. Click here to read more about Sybase IQ Options.

I think this will positively impact the role Sybase IQ plays in the data warehouse market. Hopefully Sybase marketing will take full advantage of this opportunity. 


Sybase ASE 15.5 IMDB

In my last post I wrote about in-memory database and their advantages. Sybase ASE 15.5 will provide this so called IMDB in its core engine, which means that there’s no need to change your application code to connect to the Sybase ASE IMDB.

Sybase released a new white paper on how to apply performance tuning to the Sybase ASE in-memory database. Yes, even in-memory databases need some TLC. The report also outlines my comments on where IMDBs are most suitable to solve performance problems. Heavy write intensive applications are the top beneficiaries, as long as the data is not needed for long term storage. E-commerce applications are probably the best example. But there are other situations where an IMDB will provide an alternative. Any data collection application that aggregates data end only writes the result set into a permanent storage is a good candidate for IMDB.  Click here to read the entire report.


Note


This is the latest update from Sybase. As always, please feel free to comment on this post. I would love to hear your feedback.