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 #28 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. Infobright DB is most commonly compared to MySQL: Infobright DB vs MySQL.

Helped 831,158 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_user704985

Big Data & Business Intelligence Expert

The performance of ad hoc aggregation queries is superior to any RDBMS that I have used and I have used them all. The parallel load engine (DLP) makes it the fastest load on the market that I know of (as of April 2017.) The compression of data is also highest on the market anywhere between 10x to 50x, when comparing to raw data. Valuable Features * Ability to support wide and denormalized data sets * Small footprint * Fast load * Ad hoc query capability across denormalized tables * Low maintenance costs * No need for physical design * Low technology footprint * Capable of hosting and/or integrating with and analyzing “Big Data” * Social Network data * Huge volumes * Logs of different origins * Unstructured and semi-structured data Short Term Benefits * Enhanced Data Relationship Knowledge and Business Rule Design – allows identifying additional detailed BI query needs in a low-cost environment. * Mitigate the risk of one shot large builds that do not meet business requirements. * Validate schema and evolve the design. * Validate and vet detailed requirements and analyze queries before undertaking a costly and lengthy development process. Long Term Benefits * As business conditions change the Sandbox based on IEE allows quick testing and analysis of the impact of these changes. * The rapid design, analysis and build cycle, in a DW Discovery Mart, takes one to two weeks versus six to 12 months using traditional data warehousing techniques. * Low cost and rapid deployment – easy to maintain with less need for ETL programs, integration logic, and minimal data modeling.

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

Product category:

As of January 2025, 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	Jan 21, 2025	Download
Product	Reviews, tips, and advice from real users	Jan 21, 2025	Download
Comparison	Infobright DB vs SQL Server	Jan 21, 2025	Download
Comparison	Infobright DB vs Oracle Database	Jan 21, 2025	Download
Comparison	Infobright DB vs MySQL	Jan 21, 2025	Download

Title	Rating	Mindshare	Recommending
MySQL	4.1	8.4%	91%	147 interviews Add to research
LocalDB	4.6	2.9%	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."

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."

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.