June 21, 2010 08:35 ET
Infobright Enterprise Edition 3.4 Powers Analytic Applications and Data Marts With up to 500 Percent Query Performance Boost
Major Enhancements Include Multi-Core Workload Management, Query While Load, Insert/Update/Delete Performance and Expanded Internationalization
TORONTO--(Marketwire - June 21, 2010) - Infobright, whose high performance database is the preferred choice for analytic applications and data marts, today announced Infobright® Enterprise Edition (IEE) 3.4, combining unmatched performance and simplicity for analytics involving large volumes of data. The release includes a number of major enhancements, including query performance improvements up to 500 percent, delete performance improvement of more than 1,600 percent, the ability to run queries while data is loading, more efficient workload management and support for multi-language data.
"We are thrilled to deliver such outstanding performance improvements to our customers with IEE 3.4," said Bob Zurek, CTO and VP product management of Infobright. "The most important aspect of this, however, is that this high level of performance is achieved without any work on the part of our users -- no need to create indexes, partition data, or do any manual tuning work at all. Infobright's continued focus on delivering the highest degree of performance without the associated infrastructure and administrative complexity of other databases sets us apart in the industry."
Major new features include:
- New Workload Manager and Performance Enhancements: Faster Queries, Faster Deletes, Faster Insert/Update/Delete Operations
Infobright's new workload manager now utilizes all available resources including CPUs and memory to optimize the order of data access, and rapidly decompress and read data in parallel with query execution. This advancement has demonstrated query performance increases of 40-500 percent. The workload management system also provides the ability for multiple concurrent queries to be balanced across all system resources.
Enhancements to insert/update/delete processing have also had a dramatic impact on performance. As shown in the table below, delete performance has been improved by more than 1,600 percent while tests of insert/update/delete show improvement up to 1,000 percent.
In keeping with Infobright's focus on simplicity and ease of use, these new capabilities help companies scale performance without the need to implement costly, complex MPP hardware infrastructure.
Results of Performance Tests
||Average Improvement Results
|Single user scenarios, aggregate and non-aggregate queries
||40 - 50%
|Multi-user query performance for 4 and 8 user scenarios
|Single-user DML performance
||300 - 1000%
|Multi-user DML high commit scenarios (multiple interleaved inserts, updates and deletes
||300 - 600%
|Single user DELETE performance
- Query While Load/DML, Load While Query/DML
For businesses such as mobile providers and online retailers, up-to-the-minute insight into what customers are doing -- how they are responding to location-specific offers or what they are adding to their shopping cart, for example -- is critical to competitive advantage. Even a small delay can mean the difference between making and losing a sale. To ensure faster access to information, IEE 3.4 includes the ability to execute queries while data is still loading. When a LOAD or DML process completes, the new data is immediately available for analytics, enabling business users to load and query concurrently. This is especially important for web, mobile, security, network management and other types of applications that capture data in real time.
- Enhanced Internationalization
In today's global business environment, more and more companies need support for multi-language data. IEE 3.4 expands the solution's already extensive international capabilities with the following additional features:
- The ability to load UTF-8 data via the Infobright high-speed loader
- Support for exporting UTF-8 data
- The ability to convert current ASCII tables to UTF-8.
To reduce the wait time for users, large result sets are now streamed to the client, rather than waiting for the full query to execute. This provides faster return of data and lowers the memory footprint for most non-aggregate and aggregate queries. It also benefits ISVs and SaaS providers who embed IEE within their application or service.
IEE Release 3.4 will be generally available in June.
Infobright's high performance database is the preferred choice for analytic applications and data marts. With the fastest implementation time, unmatched operational simplicity and low cost, Infobright is being used by enterprises, SaaS and software companies in online businesses, telecommunications, financial services and other industries to provide rapid access to critical business data. For more information, please visit www.infobright.com or join our open source community at www.infobright.org.
All names referred to are trademarks or registered trademarks of their respective owners.