Infobright DB Valuable Features

SD
Senior System Architect - Resiliency Engineering at a comms service provider with 10,001+ employees

A valuable feature was the use of a columnar database for large, ever-growing, big datasets.  It also have very amazing smart grid query feature for very fast aggregate queries across millions of rows

View full review »
it_user700143 - PeerSpot reviewer
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.

View full review »
it_user266910 - PeerSpot reviewer
BI Developer at a tech services company with 10,001+ employees

The high compression and the relatively fast load for a free product.

View full review »
Buyer's Guide
Relational Databases Tools
March 2024
Find out what your peers are saying about Ignite Technologies, Oracle, Microsoft and others in Relational Databases Tools. Updated: March 2024.
765,234 professionals have used our research since 2012.
it_user708987 - PeerSpot reviewer
MySQL DBA at a financial services firm with 51-200 employees

Performance, compression, and compatibility with MySQL

View full review »
it_user704985 - PeerSpot reviewer
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.
View full review »
it_user288705 - PeerSpot reviewer
Responsabile Area Progetti BI & SYS at a tech services company with 51-200 employees

I love that the solution is a columnar DB. This means that there is data compression on the disk, a fully-indexed columnstore, and highly efficient query execution.

View full review »
it_user687159 - PeerSpot reviewer
SR Business Intelligence Developer at a tech services company with 11-50 employees

The following features are valuable for us:

  • Columnar type of the database itself.
  • Fast processing.
  • Big data storage.
  • Possibility to use SQL language (MS SSAS uses DAX, MDX).
View full review »
it_user687174 - PeerSpot reviewer
Dynamic and creative, leading a business consultancy practice in analytics, business Intelligence, crm and strategy. at a tech services company with 1-10 employees

Query, data loading speed, simplicity, reliability, and ease of use are valuable features. Quality of the customer engagement from the Infobright team is also an important factor.

View full review »
Buyer's Guide
Relational Databases Tools
March 2024
Find out what your peers are saying about Ignite Technologies, Oracle, Microsoft and others in Relational Databases Tools. Updated: March 2024.
765,234 professionals have used our research since 2012.