Tag Archives: 2012

IIUG 2012: Presentations / Apresentações

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

English version:

The 2012 IIUG conference has just taken place this week in San Diego. The echos around the net and social media are very positive. And as usual, the IIUG made available for download the presentations of this year’s conference. You can find them in the IIUG member area on the IIUG website. There are more than 100 presentations so you’ll have plenty of material to study. From a brief overview I’ve foun…

Leave a comment Continue Reading →

IIUG 2012: Presentations / Apresentações

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

English version:

The 2012 IIUG conference has just taken place this week in San Diego. The echos around the net and social media are very positive. And as usual, the IIUG made available for download the presentations of this year’s conference. You can find them in the IIUG member area on the IIUG website. There are more than 100 presentations so you’ll have plenty of material to study. From a brief overview I’v…

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 →

Sessions for all / Sessões para todos

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

English version:

The session list for the 2012 IIUG user conference is available… And just a quick glimpse at it makes me even more sad for not being present. If you still have the chance to go, don’t hesitate.
I was just looking at the session list to decide a few sessions to highlight, but I can’t! Honestly… I could point a few that don’t raise my interest, mainly because I have the idea I know enough about that particular topic. But the vast majority makes me recall my biggest problem when I attended the conference: decide be…

Leave a comment Continue Reading →

Sessions for all / Sessões para todos

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

English version:

The session list for the 2012 IIUG user conference is available… And just a quick glimpse at it makes me even more sad for not being present. If you still have the chance to go, don’t hesitate.
I was just looking at the session list to decide a few sessions to highlight, but I can’t! Honestly… I could point a few that don’t raise my interest, mainly because I have the idea I know enough about that particular topic. But the vast majority makes me recall my biggest problem when I attended the conference: de…

Leave a comment Continue Reading →