Infobright

Acquired Company OLAP

Infobright is a column-oriented analytical DBMS engine for MySQL.

The internal architecture of Infobright is comprised of three parts: Data Pack (DP), DPN (Data Pack Node), KN (Knowledge Node). When data is loaded into a table, the data is broken into different groups with fixed number rows and then decompose these data into separate data packs for each of the columns. As a result, each column has the same number of rows and this column structure is better at data compression compared with row-oriented database. The average data pack compression ratio is approximate 20:1 and the infobright can handle up to 50TB data for data analytics applications. One interesting about infobright is that it is more suitable for data analyze because it does not support INSERT, DELETE, UPDATE operations

History

Infobright was founded in 2005. It first released the open-source version of the DBMS in September 2008 and launched its community

In July 2016, Infobright moved away from its open source community edition to direct customer markets and original equipment manufacturer (OME).

The company was bought by a holding company in 2017 and is now in maintenance mode.

Foreign Keys

Not Supported

Infobright does not support foreign key constrains.

Indexes

Not Supported

Infobright does not support explicit indexes. The knowledge grid in Infobright serves as substitute for indexes as well as Data Pack Nodes (DPN). Each DPN contains some statistic information (such as max, min, sum) derived from the tuples that it stores. The knowledge grid store more advanced information (such as interdependence between multiple tables, multiple columns) and helps to locate the needed DPN with little decompress data as much as possible. For example, suppose a query wants to find such data which the value of certain column is within a specific range.

Infobright's Optimizer can generate three type of Packs: Relevant Packs, Irrelevant Packs, Suspect Packs. Each query does not need to decompress relevant and irrelevant packs, and will only need to find other data in suspect packs. In this way, the DPN serves like the index. Also the knowledge grid also serves like index because it records the relationship between multiple tables. So for join search, the DBMS first uses information of DPN in both tables to find related data blocks, and then uses knowledge node to build the relationship between those data blocks. Both DPN and the knowledge grid avoids the need to maintain an index.

Logging

Not Supported

Since infobright do not support modification of tables, they do not support logging.

Query Compilation

Not Supported

Query Interface

Custom API

The API infobright supports are ODBC, JDBC, C API, C++, Delphi, Eiffel, Java, SmallTalk, Lisp, REALbasic, PHP, Visual Basic, Ruby, Perl and Python.

Storage Architecture

Disk-oriented

Infobright is a disk-oriented DBMS. The system automatically creates the internal knowledge grid structure. This knowledge grid is key structure of the system for query execution.

Storage Model

Decomposition Storage Model (Columnar)

The storage Model for Infobright is DSM to support large data sets and analytical (OLAP) workloads.

Stored Procedures

Supported

Infobright support stored procedures. The language is their own store procedures, follow the MySQL Ansi-92 Standard. When using this language to define a stored procedure, use delimiter key word to define the procedure and change it back when the definition is finished. Below is sample code for stored Procedures for Infobright: "https://drive.google.com/open?id=0B1fwCLZ9xWQtYzh2ZVVDekV5NDg" .This function of this stored procedure is convert a date format string (“YYYYMMDD”) to a string (‘YYYY-MM-DD’).

System Architecture

Shared-Nothing

Infobright is shared-nothing DBMS and it does not rely on special hardware. It combines a columnar database and knowledge grid for optimizing analytics (such as compressing, storing and retrieving data).

Views

Virtual Views

Infobright only support views but not materialized views. In addition to that, infobright also support approximate queries to reduce the query time for massive amount of data.

People Also Viewed

Infobright Logo
Website

https://infobright.com

Twitter

@Infobright

Developer

Infobright

Country of Origin

CA , PL

Start Year

2005

End Year

2017

Acquired By

Ignite Technologies

Project Type

Commercial

Supported languages

C++

Derived From

MySQL

Compatible With

MySQL

Operating Systems

Linux, Solaris

Licenses

Proprietary

Wikipedia

https://en.wikipedia.org/wiki/Infobright

People Also Viewed