Informix Gets Optional Data Warehousing Feature From IBM
In effect, Informix customers don't have to turn to DB2 in order to get the same capabilities.
IBM's Informix Dynamic Server has been equipped with data warehousing capabilities that put it on a more even footing with its major competitors.
Oracle, Microsoft's SQL Server, and IBM's own DB2 have extensive data warehousing capabilities built in or available as add-on packages. Informix was once the fourth-largest database vendor, behind IBM, Oracle, and Sybase. IBM acquired it in 2001 for $1 billion, maintaining the database server as an independent product line, but it lagged the field in data warehousing aspects.
IBM said Thursday that the optional Informix Warehouse Feature is now available and can be used to store and analyze data from Informix transaction systems. In effect, Informix customers don't have to turn to DB2 in order to get data warehousing capabilities with the IBM nameplate on them.
Informix users need not only transaction performance but also a system that allows them "a deeper understanding of the data that is generated from the global enterprise," said Arvind Krishna, VP of worldwide information management development, in the announcement.
Informix runs on Windows, Linux, and Unix servers, including both IBM's AIX and Sun Microsystems' Solaris/Sparc. The Data Warehouse Feature includes tools for building data warehouses, and the nature of the tools suggests Informix data warehouses might have a more real-time quality than the traditional, historical data warehouse.
The feature includes such things as tools for setting the parameters of the database for supporting decision support systems; creating parallel queries for rapid execution in a decision support environment; and creating quick, sequential table scans, a data-hunting tactic often used in decision support environments.
Informix is used by eight of the top 10 U.S. retailers, said Krishna. The data warehouse capabilities will help them unlock patterns and trends in their data as they use Informix to conduct their business, as opposed to exporting the data to another system for warehousing and analytics.
In addition, IBM now has the Cognos decision support and data analysis system capable of sitting on top of different data warehouses.
Column-store databases and appliances are another solution. InformationWeek has published an independent analysis of this topic. Download the report here (registration required).
How Enterprises Are Attacking the IT Security EnterpriseTo learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
IT Strategies to Conquer the CloudChances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.