Columnar, Open Source Analytic Database - Features - Infobright

By: Infobright  09-12-2011
Keywords: Data Compression

Columnar, Open Source Analytic Database - Features - Infobright

Infobright's high performance analytic database is designed to handle business-driven queries on large volumes of data - without IT intervention. Easy to implement and manage, Infobright provides the answers your business users need at a price you can afford.

New! Infobright Enterprise Edition 4.0 is now available.

Infobright is very pleased to announce Release 4.0 with DomainExpert technology. Release 4.0's new capabilities enable near-real time analytics on "Big Data" with optimizations specifically for machine-generated data.

Enterprise Edition Features

Infobright technology combines a column-oriented database with our Knowledge Grid architecture to deliver the ideal solution for your growing analytic needs. While other databases  require extensive IT effort to create indexes, partition data and build physical data structures, our 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 our industry-leading data compression (10:1 up to 40:1) significantly reduces storage requirements.

SQL Support


Full ANSI SQL-92 with some SQL-99 extensions including full support for VIEWs and stored procedures
Flexible Schema Support

Supports all schema designs

Industry Standard Interfaces

Supports standard database interfaces, including ODBC,  JDBC 
and native connections

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

DML Support

Supports DML statements (INSERT, UPDATE, DELETE)

Concurrent Queries

Concurrent queries continue to perform at maximum speed until they exceed the number of cores in the physical server. If the number of concurrent queries exceeds the number of cores, performance of each query will be reduced.

Operating Systems

Windows Server 2003 (64-bit, 32-bit eval), Solaris 10 (64-bit), Red Hat Enterprise Linux 5 (64-bit), Novell SUSE Linux Enterprise 10, Red Hat Enterprise Linux 5 Advanced Server (64-bit), Debian ‘Lenny’ (64-bit), or CentOS 5.2 (64-bit)

Processor Support

Intel and AMD x86-based servers with a minimum of
4GB of RAM (16GB+ recommended)

Supported Load Form

Three loaders are available with Infobright Enterprise 4.0. The MySQL loader can be used for text based loads or the Infobright loader can be used to speed the load of text or binary files (up to 280GB/hour with parallel load).


The Distributed Load Processor is a multi-machine loader that scales linearly, letting you load TBs per hour.

Keywords: Data Compression

Contact Infobright

Email - none provided

Print this page

Other products and services from Infobright

09-12-2011

Knowledge Grid Architecture, Self-Managing Data Warehouse, BI Software, Analytical Data Warehouse - Infobright - Infobright

There are many advantages to column-orientation, including the ability to do more efficient data compression because each column stores a single data type, and allowing compression to be optimized for each particular data type. Infobright organizes the data into 2 layers: the compressed data itself that is stored in segments called Data Packs, and information about the data which comprises the components of the Knowledge Grid.


09-12-2011

Infobright Enterprise Edition Analytic Database - Benefits - Infobright

Gathering and analyzing web-based customer interactions over the lifetime of a customer is an extremely complex problem in France, where government regulations dictate that consumers always have the right to. Traditional data warehouse products put a tremendous burden on IT in order to create and maintain an environment that will allow users to query against large volumes of data.


09-12-2011

Download Infobright Enterprise Edition Trial - Infobright

If you want to save the old data then export the data in flat files from the ICE installation before uninstall. Uninstall ICE (remove/move the data directory since the uninstall doesn't remove the data directory. You will need to establish a free account with us in order to generate your trial key. An IEE Evaluation cannot be installed on top of an existing ICE instance. Save the iblicense-name.lic file in your top-level Infobright directory.


09-12-2011

High Volume Analytic Data Warehouse, MySQL Optimization, Scalable Open Source Data Warehousing - Infobright - Infobright

Infobright solves these problems - by providing a solution that does the hard work of implementing and managing a scalable analytic database engine so you don't have to. The need for business analytics has grown dramatically across all industries, outpacing the availability of technical expertise and budget to successfully implement it.