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:
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:
ICE is available on the following platforms for 64-bit Intel or 64-bit AMD:
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
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
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.
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
Community Website
Community Wiki
Community Forum
FAQ
Issues and Feature Requests
RECENT COMMENTS
[#420] John Garrett Martin comments on Agile for Data Warehouse Projects?
[#29] Dominik Slezak comments on VLDB 2008 & our first publication
[#28] Fan Min comments on VLDB 2008 & our first publication
[#27] Dominik Slezak comments on VLDB 2008 & our first publication
[#26] Fan Min comments on VLDB 2008 & our first publication
[#25] John Garrett Martin comments on Should MySQL Users Do Data Warehousing Differently?
[#24] John Garrett Martin comments on Extract Transform Load - What Not To Do...From Someone Who has Done Them All!!!
[#23] Victoria Eastwood comments on Do MySQL users do warehousing differently?
[#22] Dominik Slezak comments on Three faces of data mining
[#21] David Lutz comments on Three faces of data mining