IBM Informix Information Reviews & Insights

Informix brings our team the best functionality, openness and reliability for our customers, and allows developers and customers to avoid having cumbersome time configuring. Managing huge amounts of different data with rapid retrieval process. Informax also helps us in project management with its hybrid data capabilities.We can provide our customers with customized information and datas.

The simplicity to manage huge amounts of data is really amazing. The data can also be easily accessed when needed. Customizing information and data for our customers in ways that it is easier for them to understand. Informix helps us to connect data of web pages and even more important for us this software can be used with the language of Java programming being this fundamental in our company.

I've started working with Informix l as a developer. It was a very interesting experience as Informix 4gl is a very good development tool. It consists of two parts: One part for designing screens and another part for writing code that easily uses these screens to form a complete business application including a report engine that lets you create reports very easily. After that, I've started working on IDS version 7 as an administrator. I've discovered a powerful engine with a unique architecture that runs as an operating system where you can tune every part of this incredible machine, starting with its virtual processors and ending with flexible disk storage. Informa IDS is multithreaded (is there any other DB engine that can do the same?). I've also had an exciting experience with Genero, a development tool that can take your Informix 4gl application and change its text interface to a graphical one and deploy it on a web server. Instead of rewriting your 4gl code with any framework, just load it on Genero studio and see the result. Actually, if you try to develop the same application with another framework, it will cost you a lot without success.

Informix is best suited for almost every business. OLTP and OLAP application, NoSql, IoT, all these areas are very well done with Informix.

IBM Informix is a relational database. In our context, it is used for transactional operations (OLTP). It is used across the organization, for different products and processes. We use it for its high scalability.

Highly recommended for:

• Transactional operations.
• Embedded database, like in IoT.
• Full end to end IoT integration.
• Solutions requiring database extensibility.
• Support for hybrid data structures (relational and NoSQL).

Not recommended for:

• Storing text data, even if the text datablade is a great product, now integrated, it is not designed for this.

I support business and government organizations that use Informix worldwide. Clients use Informix for OLTP applications as well as Data Warehouse and Decision Support analytics. Database sizes range from several GB to tens of TB. Industries include retail, wholesale, electric utilities, online gaming, online gambling, information processing, financial records management and financial transactions, court record keeping, government taxation units, etc. For most of these organizations Informix manages and secures mission-critical data.