Tag Archives: accelerator

Announcing the IWA RedBook

Query Acceleration for Business using Informix Warehouse Accelerator

A draft IBM Redbooks publication  (Planned Published date of November 2013)

Abstract

IBM Informix Warehouse Accelerator (IWA) is a…

Leave a comment Continue Reading →

Informix Warehouse Accelerator: News / Novidades

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English Version

This is just a very short note to mention a blog post from Martin Muerderer on his excellent blog dedicated to Informix Warehouse Accelerator. He warns us that recent Linux versions (with libstdc++ 4.6) will cause problems for IWA. At startup (ondwa start) the user will get errors like


An assertion ‘str.tellg() > 0′ failed. Additional info: Invalid size definition ’0′ encountered for parameter SEND_QUEUE_SIZE

Some workarounds wo…

Leave a comment Continue Reading →

OAT survey / Inquérito OAT

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

I’ve just noticed that the Informix documentation team has just publish a blog entry announcing a very interesting initiative at the 2012 IIUG conference. Users will be able to preview some product (OAT and IWA) enhancements as well as …

Leave a comment Continue Reading →

Database wars are over? / As guerras das bases de dados terminaram?

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English Version

“Database wars are over…”, “…and relational won”, “…and Oracle won”. If you search for these terms on your favorite search engine you’ll get enough answers to keep you busy for a long time.
At a certain point many believed this was true. And I’m sure many others still do. But if you’ve been paying attention lately you’ll notice this can still be under discussion.
Currently there is a lot of movement in the database arena… Let’s see:

So, we are definitively seeing news on the technology front. And although it’s true that these days databases are a commodity, the fact is that no system is implemented without some sort of database. And it…

Leave a comment Continue Reading →

IWA: A Year in Review

IWA – A Year in Review   This week marks the 1-year anniversary for the release of the Informix Warehouse Accelerator (IWA). This blog entry takes a look at what we have accomplished and what we look forward to.   Technology   First of all, for those not yet…

Leave a comment Continue Reading →

2012 Informix Roadshow Lisboa: Closing notes / Notas de fecho

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English Version

The 2012 Informix Roadshow in Lisbon ended yesterday. The highlights of the second workshop day were Informix Warehouse Accelerator, compression and Genero.

Attendees were impressed by the ease of use of IWA and has planned in literally a couple of hours they managed to install the server component, the client management tool, define a data mart, load it, test the queries and even look into the workload analyzer that allows automatic mart definition. And all these achievable in a laptop with 4GB of memor…

Leave a comment Continue Reading →

2012 Informix Roadshow: Having fun / Boa forma de passar dois dias

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English Version

As announced earlier, the Lisbon 2012 Informix roadshow is happening. Today we assisted several presentations on 11.7 new features, security enhancements, storage provisioning and flexible grid.
Just after lunch students had the chance to experiment with the storage provisioning lab.

Tomorrow there will be final flexible grid details, a quick overview about Mashups and then we’ll entered the main topic of the day; Info…

Leave a comment Continue Reading →

Too little, too late? / Muito pouco, muito tarde?

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English Version:

I recently got an advice on how to make better use of Twitter… And so I did… I increased the number of people or accounts I’m following and today I was flooded by messages about the launch of one of the database competitors. If you’ve been paying attention to the net you probably know which one I’m talking about… I’ve seen some references before and I decided to investigate a little further what were the new features causing all this buzz around it… I must grant credit to the company behind it, since it was not difficult to get information and find several articles and papers and people talking about it.

I think that in the IT field we tend to close ourselves around what we know better. I’ve seen it in Oracle DBAs, in people working with Informix (you should know it’s much harder to find an Informix DBA than a DBA from any other database since we tend to have several hats and play several roles) and with people working in different environments (z/OS is a classical example). And apparently it also happens with people working with SQL Server. I’d say that only this can explain all this enthusiasm… Let me explain why, by picking two of the flagship features of it’s new version (I’ll be using the terms I’ve found on the Internet in blogs, articles and so on):

  • AlwaysOn
    Believe it or not this is a form of replication that allows databases to be put together in groups that use a primary server and one or more secondary servers. The replication can be synchronous, or asynchronous. The secondary servers can accept read only queries. It includes some sort of connection redirection and something I could not exactly understand that allows temporary statistics to be computed on the secondaries and stored in temporary spaces…
  • ColumnStore indexes
    This is interesting…. It combines several technologies like in-memory database, columnar storage and star model optimization. This allows incredible time savings, but has some drawbacks, like not being able to update a table with an index of this type (several workaround are mentioned, but all of them have serious implications). It’s up to the optimizer to decide if it will use this kind of index or the traditional query plans.

I’m sure that if you’re an Informix user, or someone paying attention to the Informix scene, you have a smile on your face by now… And I would not need to explain why. But for the people who are a bit more distracted, or as I mentioned above live on a closed world, let me explain why Informix people have a smile on their faces at this point in the article:

In 2007 (yes, five years ago), IBM introduced version 11.1, code named Chetah, and one of the features was something called MACH-11. This did not cause half the buzz that we’re seeing today, but in very short words, it was the ability to configure a set of Informix instances (where we can have several databases) with a primary server, a “close” secondary server, called HDR (which can by synchronous), and several remote secondary servers (RSS) which receive the logs. The communication between these can be encrypted (there are known customer c…

Leave a comment Continue Reading →