Infobright Community Edition (ICE) (64-bit) 3.1.1

Infobright Community Edition (ICE) (64-bit) 3.1.1 is created as a useful tool which provides help with your growing analytic needs. While other data warehouse products require extensive IT effort to create indexes, partition data and build physical data structures,  self-managing solution delivers rapid response to complex queries created on-the-fly.

While other products require complex, expensive hardware infrastructure to provide high performance and scalability, the Infobright solution scales to 50TB+ using a single server and  industry-leading data compression (10:1 up to 40:1) significantly reduces storage requirements. ICE is integrated with MySQL 5.1, and includes a distribution of MySQL within the installer.

Benefits:

1. Just Load and Go
   • Simple to implement and manage, requiring little administration
   • No specific schemas needed
   • Self-managing: no need to create indexes, materialized views or partition data
   • Use the BI tools you know: compatible with major Business Intelligence tools such as Cognos, Business Objects, Pentaho, Jaspersoft and others.
2. High performance and scalability
   • Very fast data load: up to 280GB/hour
   • Fast response times for complex analytic queries
   • Query and load performance remain constant as the size of the database grows
   • Scales up to 50TB of data and more
3. Low Cost
   • Low cost enterprise subscriptions that include product licenses, updates, outstanding support and more
   • Eliminates the need for complex hardware infrastructure
   • Runs on low cost, industry standard servers
   • A single server can scale to support 50 TB of data
   • Industry-leading data compression (10:1 up to 40:1) significantly reduces the amount of storage needed and their associated maintenance costs
   • 90% less work to manage means much lower operational expenses.

Major Features:

1. SQL Support
   • Full ANSI SQL-92 with some SQL-99 extensions including full support for VIEWs and stored procedures
2. Flexible Schema Support  
   • Supports all schema designs
3. Industry Standard Interfaces
   • Supports standard database interfaces, including ODBC,  JDBC and native connections
4. Supported APIs  
   • Supported APIs include C, C++, C#, Borland Delphi (via dbExpress), Eiffel, SmallTalk, Java (with a native Java driver implementation), Lisp, Perl, PHP, Python, Ruby, REALbasic, FreeBasic, and Tcl
5. DML Support  
   • Supports DML statements (Insert, Update, Delete)
6. Concurrent Users  
   • Supports up to 500 database users with up to 32 concurrent queries (depending on number of CPU cores and amount of memory)
7. Operating Systems  
   • Windows Server 2003/2008 (64-bit), Solaris 10 (64-bit), Red Hat Enterprise Linux 5 (64-bit), Red Hat Enterprise Linux 5 Advanced Server (64-bit), Debian ‘Lenny’ (64-bit), or CentOS 5.2 (64-bit)
8. Processor Support  
   • Intel and AMD x86-based servers with a minimum of 8GB of RAM
9. Supported Load Formats  
   • Two loaders are available in Infobright Enterprise.