Analytic Databases Get Major Updates at Infobright

Infobright, a provider of open source analytic databases, announced major product upgrades that include query performance boosts well as remote data loading capabilities. New features will be available in both Infobright Enterprise Edition (IEE, version 3.5) and Infobright Community Edition (ICE, version 3.5).

Both editions have a number of new features, Susan Davis, vice president of marketing and product management of Infobright, tells 5 Minute Briefing. "The enhancements common to both are significant query performance boosts, the use of the MySQL query cache which enhances query performance for repetitive queries, and the ability to remotely load data," she says.  Specific enhancements exclusive to IEE include high availability replication, improved workload management and database monitoring, Davis says. "In addition, the upcoming availability of the Distributed Load Processor (DLP), which can enable load speeds of one terabyte an hour using remote servers to process and compress the data, will be IEE only. We expect it to be available by the end of March."

The new releases also provide users the ability to load data from a remote machine and thus offload potentially heavy ETL processing to a separate server-ensuring more CPU resources are available for query processing. In addition, both ICE and IEE may optionally use the MySQL query cache, resulting in further performance gains for repeated execution of queries.

Infobright often gets used in conjunction with or as an alternative to ETL environments, Davis says. "Many customers will use an ETL or data integration tool from vendors like Talend or Informatica before loading the data into Infobright, but others just do a straight load from a source system. The Infobright loader, especially with the upcoming DLP, will be much faster, but often there is still a need for the extraction and transformation these products provide. They are certainly complementary technology to Infobright and we partner with these companies and others."

IEE now supports MySQL statement-based replication, which includes support for scale-out, spreading the load among multiple servers to improve concurrency and performance. It includes support for both master/slave, master/multi-slave configurations, delivering a simple approach to high-availability and redundancy. It also improves data security and backup, allowing the replication process to be paused for backup services to be run on the slave.

IEE also features enhanced workload management, which builds on the multi-core query processing delivered in IEE 3.4, and adds parallel scanning and execution of individual queries, as well as automatic query throttling technology for improved load balancing and query execution.

For more information, go here.