InfoBright Enterprise Edition

Enhancements to query performance. Simplified remote data loading. High Availability Replication support. These are the three most important changes introduced in edition 3.5 of Infobright Enterprise Edition - one of the most popular analytic databases aiming at customers who most of attention pay exactly to performance. Struggling with giant loads of data and maintaining large data warehouses, the ones who don't want to involve IT departments. Enterprise Edition - with its common simplicity and easiness of implementing, and further management - should answer all their needs.

Basically, the core of Infobright solutions is combining two technologies at once - column-oriented databases followed by Knowledge Grid architecture result in shortening the time needed for answering even the most complex queries. However, important is the fact there is no IT involvement needed for adjusting the structures, partitions, and indexes. Instead of requiring complex - and, therefore, expensive - hardware structures, Infobright Enterprise Edition itself is scalable enough to ensure 50 TB of data per a single server and up to 40:1 data compression.

Key features of Infobright

  • Usual compression rate is estimated at about 10:1, however - if a user needs - it's possible to increase the rate even up to 40:1.
  • Enhanced scalability resulted in allowing users to operate up to 50 TB within a single server implementation (though the data needs to be compressed to up to 5 TB).
  • The combination of column based architecture and Knowledge Grid results in significant performance improvement.
  • Enterprise Edition works well with industry standards driven by Intel and AMD.
  • "Load and go" - that is all that you need for implementing the solution. Everything is preconfigured, therefore no further customization is required.
  • Almost all maintenance is being done automatically - no frequent tuning nor modifying is necessary.
  • Data loading comes with a speed of up to 100 GB per hour or - if 4 tables were being loaded simultaneously - up to 250 GB per hour.
  • Thank to MySQL integration, Infobright supports Cognos, SAS, Pentaho, Jaspersoft, MicroStrategy, and other BI tools.
  • ETL is supported through solution's loader and through MySQL.

Technological features

  • Supporting full ANSI SQL-92 and SQL-99 extensions.
  • Multiple schema designs supported.
  • Supporting ODBC, JDBC, and other standard database interfaces.
  • APIs that are supported are: C, C++, Delphi, Eiffel, Java, SmallTalk, Lisp, Perl, Python, Ruby, PHP, REALbasic, and many others.
  • Insert, update, and delete - DML statements supported.
  • 64-bit operating systems - Red Hat Enterprise Linux 5, Linux 5 Advanced Server, Solaris 100, Debian Lenny, and CentOS 5.
  • Supported are Intel and AMD x86 units and servers of at least 16 GB of RAM.
  • Two loaders - solution's and MySQL - ready to use.

Infobright resources and interesting links

http://www.infobright.org/images/uploads/IEE_vs_ICE.pdf - once the solutions by Infobright are being spread twofold - as Enterprise Edition and Community Edition - it would be reasonable to know the differences between them, especially because the second of them is being provided as an open source tool. The article focuses, then, on ten most important differences between versions of Infobright data warehouse solutions.

http://www.sun.com/third-party/global/infobright/Infobright-SB-041609-LR.pdf - it's not easy for even the largest companies to deliver strictly self-dependent solutions able to ensure their users need nothing else. Thereupon, Infobright in cooperation with Sun Microsystems, did their best to ensure the best results, and here is where you can read about how it evolved in practice.

http://download.101com.com/pub/tdwi/files/Case-Study-Infobright-Bango.pdf - the best it is to learn on someone else's experience, and now it's possible. Here is the case study of Bango - one of mobile analytics companies - which managers decided o give Infobright solutions a try, considering it the most affordable and - therefore - acceptable option.