Infobright DB Reviews

Name: Infobright DB
Brand: Ignite Technologies
Rating: 3.8 (10 reviews)

Vendor: Ignite Technologies

3.8 out of 5

10 reviews
80% willing to recommend

860 followers

Post review

What is Infobright DB?

Infobright's high performance analytic database is designed for analyzing large volumes of machine-generated data

Get the Infobright DB Buyer's Guide and find out what your peers are saying about Infobright DB, MySQL, LocalDB and more!

Infobright DB is the #26 ranked solution in top Data Warehouse solutions and #33 ranked solution in top Relational Databases. PeerSpot users give Infobright DB an average rating of 7.6 out of 10. Based on the analysis of the 10 most recent Infobright DB reviews, the overall sentiment is positive, with a sentiment score of 6.4. (Among the lowest in the category). Infobright DB is most commonly compared to MySQL: Infobright DB vs MySQL.

Helped 824,067 peers since 2012

Featured reviews

Steve Dodge

Senior System Architect - Resiliency Engineering at AT&T

This version of Infobright has zero support for distributed scalability. The internal smart grid employed for each table has a major flaw in that the data size cannot be expunged until 2GB of data is reached at the column-level. This is a major flaw, making usage in a big-data scenario impossible. This means that you can delete as many records from a database table as you want. However, unless the 2GB aggregate size threshold was reached for some of the columns in the table, no reduction in disk space usage will occur. Only the data from the columns that reached 2GB will actually decrease. Other columns below 2GB in size do not leave the disk. I spent countless hours trying to find some workaround for this. I have nightmares of my e-mail inbox full of unsolvable questions about data size reduction from our field engineers.

Read full review

it_user700143

Computer Engineer at a financial services firm with 201-500 employees

Ability to work with it in the same manner as MySQL works; In the beginning of the BigData solutions boom, our company had previously been working with MySQL, and Infobright gave us the ability to avoid significant changes in our data structure and just use Infobright like "BigDataMySql". But there were some disadvantages, too.

Read full review

it_user7578

Consultant at a tech consulting company with 51-200 employees

Interesting Article about BigData and Column oriented engines written by a student… … Students in major of software engineering are required to take another course named “Data Storage & Information Retrieval Systems” as a prerequisite for Database. DS&IRS mainly focuses on optimized storage and…

Read full review

Infobright DB mindshare

As of December 2024, the mindshare of Infobright DB in the Relational Databases Tools category stands at 0.2%, up from 0.2% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Relational Databases Tools

PeerAnalyst reports

Type	Title	Date
Category	Relational Databases Tools	Dec 21, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 21, 2024	Download
Comparison	Infobright DB vs SQL Server	Dec 21, 2024	Download
Comparison	Infobright DB vs Oracle Database	Dec 21, 2024	Download
Comparison	Infobright DB vs MySQL	Dec 21, 2024	Download

Title	Rating	Mindshare	Recommending
MySQL	4.1	8.3%	91%	147 interviews Add to research
LocalDB	4.6	2.8%	100%	6 interviews Add to research

Valuable Features

Infobright DB's key features include high data compression, rapid loading, and efficient query execution. Users value its columnar architecture, enabling speed and storage for large datasets, as well as SQL compatibility. Its ease of use, reliability, and superior ad hoc aggregation performance are emphasized. Users also appreciate Infobright DB’s compatibility with MySQL, low maintenance costs, minimal technology footprint, and capability to handle diverse Big Data types while allowing for cost-effective data relationship analysis and business rule design.

"It has very amazing smart grid query feature for very fast aggregate queries across millions of rows"

Room for Improvement

Infobright DB lacks DDL functions, has room for improvement in complex subqueries and analytical functions, and does not support distributed scalability. The internal smart grid's 2GB column-level data expungement limitation hinders big data usage. It is slow, with restrictions on table modifications, and lacks adequate joins optimization and integration with Hadoop. Data replication issues exist, requiring self-implementation of redundancy, and it faces challenges in scalability and disk space management.

"Only the data from the columns that reached 2GB will actually decrease. Other columns below 2GB in size do not leave the disk."

ROI

Pricing

Infobright DB pricing varies significantly among users. Some find it expensive, especially as an additional database, while others consider it more cost-effective than Oracle. The cost is often based on server instances, with annual subscriptions reaching up to $25,000 per year. Proper planning for data size and licensing packages is recommended. Many utilize the Community Edition, ICE, for non-production systems without extensive licensing evaluation.

"Our pricing was based on server instances and it was actually very cheap compared to Oracle. I guess you get what you pay for."

Popular Use Cases

Service and Support

Infobright DB's customer service receives commendations for being friendly and helpful, with technical support often described as excellent or good. Users of the Community Edition mention the absence of support, and some note difficulties in reaching developer-level staff, attributing low ratings during 2015 and 2016. Interaction with Infobright Inc. management is appreciated, indicating a positive experience from a service perspective. While feedback varies, a general sense of enthusiasm is highlighted by engaged field representatives.

Deployment

Users reported a range of experiences with Infobright DB's initial setup. Some found it straightforward, quick, and similar to MySQL installation, while others faced challenges, particularly with the special FTP server and licensing. Implementing an efficient method to manage large fact tables was necessary due to limitations in ICE. Despite varied experiences, some users noted that once familiar, the setup time could be reduced significantly, especially with the removal of physical database design requirements.

Scalability

Users primarily report no significant challenges with Infobright DB's scalability. Some note its low hardware demand and small footprint as advantageous. However, others mention non-existent scalability due to reliance on a single server, prompting them to implement their own sharding techniques. While some find scalability effective, others criticize the inability to modify tables or expand beyond one machine, viewing it as a central point of failure. Experiences reflect a mix of ease and limitations.

Stability

Some users experienced no stability issues with Infobright DB, while others faced significant challenges. A few encountered frequent system hangs and major stability problems, particularly with the PostgreSQL version, requiring regular support to address crashes and provide patches. Instances of system failure under overload were noted, necessitating restarts. However, several found it to be generally stable without notable issues.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Infobright DB Buyer's Guide for additional reliable information.