A single database platform delivers maximal performance for multiple workloads

Informix is simple yet powerful data management software that provides a single platform to achieve optimal performance for transactional and analytical applications. It enables organizations to lower costs and consolidate environments for OLTP and OLAP workloads. Using the most current technologies, Informix keeps data always available for real-time transactions and speed-of-thought analytics—helping organizations gain greater business insights for competitive advantage.

Highlights:

• Deliver fast, always-on access to data in a platform-independent environment
• Perform speed-of-thought analytics for rapid business decisions
• Leverage easy-to-use management features to help reduce complexity
• Enable fast and flexible cloud deployments

IBM® Informix® is one of the world’s most widely used database servers, present in organizations ranging from the largest corporations to start-ups. Informix incorporates design concepts that are significantly different from traditional relational platforms, resulting in extremely high levels of performance and availability, distinctive capabilities in data replication and scalability, and minimal administrative overhead.

  IBM Informix powers OLTP and analytics for data driven businesses (2013-03)

New Features for Data Warehouse, Sensor Data, Cloud Computing,
Administration and Application Development

Powerful and simple have always been watchwords for the IBM Informix database server and version 12.10 continues in that vein with enhancements to five key feature areas.

As well as updated platform support, there are also other new server features to improve SQL compatibility and boost performance:

Data Warehousing

New features in the Informix Warehouse Accelerator create a real time, in memory data warehouse capability. An updated administration interface means that the accelerator is even easier to configure and manage on a daily basis by using the new automatic partition refresh and trickle feed features. Informix has never been faster, simpler to use or more consistent in its performance.
The Informix server has also been enhanced to provide powerful OLAP features, often used by Business Intelligence tools such as IBM Cognos products, to simplify and speed up complex queries that have to work across very large sets of data.

Sensor Data

The ability to store and analyze high volumes of structured data is key to handling the current explosion of information from monitoring devices and Smart Meters. The unique capabilities of Informix spatial and TimeSeries data types make it a simple task to store and process this data avalanche. New enhancements built in to 12.10 make these data types even more powerful than before.
There is now a transparent view of time series data through Informix Warehouse Accelerator marrying two Informix technologies into a very powerful data search and analysis engine. Management of time series data is now much simpler and faster with the capability to define active and dormant time ranges for the storage containers.
There are also several enhancements to the Virtual Table Interface and a new Loader API to make access to time series data even faster than before.
Spatial data support has been enhanced to include new features that come with the latest ESRI 10.1 library.

Cloud

New features in the Informix Flexible Grid environment make the configuration and management of sharded data within complex replication environments even simpler than before by introducing the powerful concept of regions and the easy configuration of spoke and hub systems.
Monitoring of replication queues has been enhanced to take account of their asynchronous nature and there are performance enhancements to allow for the replication of lightappend operations.
The Connection Manager and internal server support for failover can now prioritize different networks within an application and database environment to maintain the highest level of service. This can also include keeping a Shared Disk Secondary cluster running while there is a network outage.

Embeddability

Autonomic capabilities have been extended with the ability to automatically compress data and compression now supports more database objects, which lowers the storage space requirements. Dynamic configuration for more server parameters allows for automatic tuning and self healing, including the ability to manage parameters in groups using an export and import interface.
Rolling window definitions for fragmented tables boost performance and can be controlled automatically for simple administration.

Easy Administration

As well as boasting a new dashboard, the IBM OpenAdmin Tool for Informix continues to be developed to monitor and control many of the new Informix 12.10 features mentioned above, such as replication grids and Informix Warehouse Accelerator data marts. There is now a mobile app for DBAs on the move, allowing them to monitor the health and performance of all their database server systems.
The old Informix Storage Manager has been replaced with a new Primary Storage Manager to make the process of backing up the server simpler and faster.

Application Development Support

It is easier to build applications in general, and database neutral ones in particular, with the addition of several new SQL language elements. As well as the OLAP functions mentioned above there are new UNION operators, extensions for compatibility with other database servers (including Informix Parallel Server) and new aggregate capabilities.
Improvements to Informix Genero speed up the development process with powerful new templates for the Business Application Modeling tool.
The Eclipse based loader tool for time series data now makes it easier to create load jobs, and has a simple command option for use in minimal production environments.
As always, there are a number of internal enhancements to the Informix server that improve cross platform support and provide notable performance increases. Examples of performance enhancements include the following: ANSI style outer join queries can now be better optimized by utilizing hash joins and support for compression of data in the server has been extended to include indexes and simple large objects, which reduces I/O time.

Download the document for more details!

 IBM Informix 12.10.xC New Features (2013-03)

Deutsches Zentrum für Luft- und Raumfahrt e. V. (DLR)
Informix & Geodetic DataBlade - Kundenreferenz

Germany’s Aerospace Center needed a reliable and highly scalable database server to provide efficient access to more than 2 PB of image data while fulfilling long-term data preservation policies. The center deployed IBM® Informix® database to serve as an inventory of image data and IBM Informix Geodetic DataBlade® for the representation of data in three dimensions. The solution has provided efficient access to 2 PB of image data with no data lost in 10 years and requires less than one full-time employee’s time to administer at each of two sites.
(Link zur Website des DLR)

 The German Aerospace Center on Informix (2013-01)

Informix Kundenreferenz Westfleisch

Westfleisch, a meat products cooperative in Germany, uses advanced tracking and analytics to follow each product it makes, from farm to slaughterhouse to grocery shelves, increasing accountability and creating peace of mind for consumers.

Food contamination is a serious matter. Tainted food that goes unchecked can be fatal for consumers and for companies. As governments tighten regulations on food production and processing, companies need to account for each bushel of vegetables or piece of meat that makes it to market. Westfleisch needed to track animal information throughout the production process. It sought a serious data warehouse with lightning-fast processing capability and analytics power that helps it know exactly where products are at any given time.

 Informix-Westfleisch-(2012-10)