Infobright Community Edition (ICE) 3.0.2

December 4, 2008

About ICE

ICE is an open source software solution designed to deliver a scalable data warehouse optimized for analytic queries. The architecture delivers the following key benefits:

• Ideal for data volumes up to 30TB
• Market-leading data compression (from 10:1 to over 40:1), which drastically reduces I/O (improving query performance) and results in significantly less storage than alternative solutions
• No licensing fees
• Fast response times for ad hoc analytic queries
• Query and load performance remains constant as the size of the database grows
• No requirement for specific schemas, e.g. Star schema
• No requirement for materialized views, complex data partitioning strategies, or indexing
• Simple to implement and manage, requiring little administration
• Reduction in data warehouse capital and operational expenses by reducing the number of servers, the amount of storage needed and their associated maintenance costs, and a significant reduction in administrative costs
• Runs on low cost, off-the-shelf hardware
• Is compatible with major Business Intelligence tools such as Pentaho, JasperSoft, Cognos, Business Objects, and others

ICE is designed to run high-performance ad hoc, complex queries on very large data sets without the need of manual tuning, data partitioning, or index creation.

New Features

The Infobright Community Edition (ICE) 3.0.2 is the third community release, which includes:

• New Transaction Model
  
  • Enhancements to the transaction model to better handle rollback in cases when the server goes offline during a LOAD
• Fixed Server Behavior with Unhandled Conditions (defect 711)
  
  • ICE previously accepted conditions such as an invalid date or number, eventually switching to MySQL due to value out of range, and the query took forever. ICE now rejects the query and returns an error that a query parameter does not match the data type of column
• Termination of Queries that Run Out of Memory
  
  • ICE previously switched to MySQL when a query ran out of memory/resources, and the query took forever. The query now terminates and returns that the server has hit an internal memory or other resource limit

Supported Platforms

ICE is available on the following platforms for 64-bit Intel or 64-bit AMD:

• Red Hat Enterprise Linux 5
• Debian ‘Lenny’
• CentOS 5.2

ICE is also available on the following platforms for 32-bit Intel or 32-bit AMD: (for solution testing purposes only, not recommended for performance testing or production deployments):

Ubuntu 8.04

Fedora 9

System Requirements

Processor Architecture - Intel 64-bit, Intel 32-bit, AMD 64-bit, AMD 32-bit

For Personal Evaluation and/or Application Development:

CPU Speed

• 32-bit:     
  
  • 1.6GHz minimum
  • 2.0GHz or faster dual or quad core recommended
• 64-bit:     
  
  • 1.8GHz minimum
  • 2.0GHz or faster dual or quad core recommended

Memory   

• 32-bit:
  • 1GB minimum
  • 2GB or more recommended
• 64-bit:
  • 2GB minimum
  • 4GB or more recommended

For Multi-User Evaluation or Production Deployment:

CPU Speed

• 64-bit:     
  • 2.0GHz minimum
  • 2.0GHz or faster dual or quad core recommended

Memory

• 64-bit:     
  • 4GB minimun
  • 8GB or more recommended

Download ICE

Installation Instructions

Upgrade Instructions

Upgrade Issues

The new transaction model functionality changes the structure of the data so after upgrading to 3.0.2 users will not be able to use their database with previous versions of ICE. For this reason, we recommend users backup their data before upgrading.

Issues Fixed

The following issues have been fixed and verified since the release of ICE 3.0 RC1. For more details on these, please visit http://bugs.infobright.org/                                        

Ticket   Description                                           

#844 Can't load into MyISAM without setting bh_dataformat to txt_variable 

#889 MySQL loader crash with 6 files 

#899 ICE installation on top of already installed mysql environment error 

#932 While query_cache_size is on, query executed by mysql engine on brighthouse tables return wrong results

#934 Uncommitted data seen in other sessions when query is executed by mysql engine

#958 README missing from build

#963 Source missing my-ib.cnf 

#964 ICE 32bit source install/start error due to memory settings in brighthouse.ini 

#977 ICE 32: crashes when running select count(distinct) with group by a few times in a row

Known Issues

For the current list of known and closed issues, visit the Infobright Bug Tracking System

Ticket   Description                                           

#848 Knowledge Node files intermittently become unavailable to queries, resulting in slower queries

#870 Infobright can't find numbers in numeric text; inconsistent with MyISAM's treatment

#875 Infobright engine appears as transactional - cosmetic only; no impact on performance

#888 installer hardening: quotes in path (and spaces) not handled by installer

#891 Default MySQL tests included in Infobright contain tests that will not run

#933 Results of queries executed by IB engine aren't cached

#935 Usability: "Cannot start bhloader" needs improved error message

#959 ICE ignores ONLY_FULL_GROUP_BY sql mode

#980 ICE 32: Illegal mix of collations error on select

ICE Resources

Community Website
Community Wiki
Community Forum
FAQ 
Issues and Feature Requests