We now have two published documents on Informix that talk about the positive impact of Informix in terms of the return on investment that companies can realize by deploying Informix. One of them is a Forrester paper titled "The Total Economic Impact™ Of IBM Informix Database Server" and can be found at this link It is an analysis of a 3 year investment cost vs benefit and validates what many of our Informix customers believe about and realize from Informix : "Less is More" - less admin requirements, less overall support costs, less impact during planned/unplanned downtime. It is based on the database server deployment infrastructure of a very large global retailer who have other database vendor products deployed and still sought to expand their footprint on Informix.
I encourage you to read this and present this data to your IT managers and/or other decision makers.
The other is actually a comparison of Informix vs Microsoft SQL Server done by ITG and the link can be found here.
n an earlier blog on what is now a non-existent edition - the Ultimate-C and which has now been replaced by Choice Edition, I did some comparison already on some of the capabilities of SQL Server vs Informix with some examples. This study is also based on a three year scenario surveying several midsize organizations in North America and Europe. Some of the findings include : on an average 63% lower personnel costs deploying Informix vs SQL Server, comparing Informix Growth vs MSFT SQL Server Standard Edition for installations with 65 to 200 users, overall cost of Informix was 42% less than SQL Server, while for larger installations comparing Informix Ultimate with MSFT SQL Server Enterprise, overall cost of Informix was 31% less than SQL Server. These are substantial savings! Again I encourage you to read this and present this data to your IT managers and/or other decision makers.
The New Informix
Matching: sql X
rnair 120000QPR1 Tags:  innovator-c free charge sql informix edition no elt community innovation best warehouse database 4 Comments 6,315 Views
Yesterday I posted an entry summarizing the new packaging and editions of Informix. One thing I forgot to mention was the version - all these announced editions are Informix 11.5xc7.
Today I want to talk about one of the new editions : Innovator-C. Innovator-C is a no-charge edition that you can use to develop, test and deploy production applications! If you wish to distribute Innovator-C with your applications, you will need to acquire a distribution license by contacting IBM sales. You can obtain optional Support for your Innovator-C by purchasing IBM Elite level Selected Support.
There are a couple of things I want to talk about. First, I want to throw some light on the details of the Innovator-C edition especially its resource allocations and usage as I have received a number of inquiries on this already. Innovator-C is available in 32-bit and 64-bit versions across all 11.50xc7 platforms . This download location will list your platform of choice. This edition supports 1 socket or 4 cores and 2 GB of memory per install. This means that you may install this on any size machine - the Informix engine is going to utilize at the most 4 cores and 2 GB memory. The CPU usage is capped by the engine via its CPU Virtual Processors (VPs). Let me expand on that a little using some an example. Let's say you install Innovator-C on your favorite platform and configure the engine to use 2 CPU VPs. The Informix engine is going to use 2 CPU VPs. If you configure anything more than 4 CPU VPs, the engine is going to put a message in its log and automatically scale back the CPU VPs to 4.
The second thing that I want to talk about and what is often a common inquiry is how this compares to no-charge offerings from other vendors especially Oracle and Microsoft SQL Server.
When you look at the resource allocations and functionality, you will see that Informix clearly differentiates itself from both Oracle and SQL Server no-charge editions. Oracle offers Oracle Express Edition and Microsoft offers SQL Server Express. Both SQL Server and Oracle Express editions put a size limit on your database - no more than 4 GB. Both Oracle and SQL Server Express also limit memory to 1 GB.
In terms of supported platforms Informix Innovator-C offers the widest range - supporting 32 and 4-bit versions across Unix, Linux, Microsoft Windows and Mac OS. SQL Server Express of course is Windows only and Oracle Express runs on 32-bit Linux and Windows only. Hey you never know which platform the next innovation is going to come from!
In terms of functionality, the Informix Innovator-C again differentiates itself from Oracle and SQL Server Express editions in the areas of high availability and replication.
Oracle Express does not come with high availability. SQL Server Express can only be used as a "witness" in a database mirroring setup. The witness establishes a quorum between two SQL Server editions known as a primary and a secondary. The primary and secondary in a failover setup CANNOT be a SQL Server Express edition. This means that you cannot setup a failover node for SQL Server Express.
With Informix Innovator-C you can set up high availability with Informix High Availability Data Replication (HDR) with a primary and a secondary. Additionally, the secondary is also read/write enabled which means the secondary can be used to balance read or write workloads.
In terms of data replication, SQL Server Express can only be used as a subscriber in their Publisher-Subscriber replication model. SQL Server Express cannot be a distributor or publisher. Multi-master or peer to peer replication is not supported. Oracle Express supports basic replication using materialized views (what used to called snapshots earlier). Materialized views are used to replicate data from a master to a non-master site. Basic replication allows you to either create a read-only snapshot that can receive changes from a master or create an updateable materialized view that can be used to update only those tables that were part of the snapshot from the master.
Informix Innovator-C allows update anywhere (peer to peer ) replication with another Innovator-C node with no restrictions enabling you to scale your application workloads.
To top it off, you can also obtain technical support for a very competitive subscription pricing. IBM Informix is the database software voted number #1 in customer satisfaction - that speaks volumes to the quality of the Informix support organization. Now I already knew that :-), but it's great to hear it from our customers!!
So, are you:
IBM Informix Product Manager
It's here !!!!
Here is the US announcement
Here is the Canada announcement
Here is the EMEA announcement
Here is the AP announcement
Here is the LA announcement
True to it's heritage, Informix continues to build on it's key differentiating capabilities that Informix customers and partners, known more widely as "Informix fans" have come to love. You can read more about the different features across the editions at http://www.informix.com
So what's new with Informix v11.7? Let me provide a very brief intro here.
Informix Flexible Grid : Informix now offers a very easy way to do something truly powerful - deploy Informix engines in a grid environment. With grid based replication enhancements, you can now:
Best-of-Breed Embedability enhancements that gets more autonomics: Again, this continues to enhance one of the core strengths of Informix, mainly the ability to embed Informix easily. Over the last few years, especially starting Informix v11.10, a lot of focus went into autonomics - self configuring, self-healing, self-optimizing and self-protecting characteristics. So what did we do more?
Security: Security remains a top business priority for Informix customers. With that in mind, Informix v11.70 offers: