Infobright Cuts DBA Labor And Query Times
The Infobright column-store database is aimed at analytic analysis of moderate data volumes ranging from hundreds of gigbytes up to tens of terabytes. This is also the core market for Oracle and Microsoft SQL Server, but InfoBright says its alternative database, which is built on MySQL and designed for analytic applications, delivers higher performance at lower cost with much less database administrative work. The column-store database creates indexes automatically and there's no data partitioning and minimal ongoing DBA tuning required. The company claims customers are doing 90% less work than required for conventional databases while incurring half the cost in terms of database licensing and storage, thanks to high data compression.
Infobright's recent 4.0 release added a DomainExpert feature lets companies ignore repeating patterns of data that don't change, such as email addresses, URLs, and IP addresses. Companies add their own patterns as well, whether it's related to call data records, financial trading, or geospatial information. The Knowledge Grid query engine then has the brains to ignore this static data and explore only changing data. That saves query time because irrelevant data doesn't have to be decompressed and interrogated.