| Infobright |
|
Infobright OverviewLess work, lower cost. The need for business analytics has grown dramatically across all industries, outpacing the availability of technical expertise and budget to successfully implement it. Infobright solves these problems - by providing a solution that does the hard work of implementing and managing a scalable analytic database engine so you don't have to. Infobright Enterprise Edition (IEE) is the commercial version of our software, and Infobright Community Edition (ICE) is our freely-available, open source product you can download by clicking on the Download Community Edition button on the right. IEE includes enhanced features often needed for production and operational support, technical support and services, product warranty and other benefits of a commercial license. Infobright TechnologyInfobright Enterprise Edition Infobright combine a column-oriented database with our Knowledge Grid architecture to deliver a self-managing data warehouse optimized for analytics. Our sophisticated software eliminates the time-consuming effort typically involved in implementing and managing a data warehouse, freeing up your time and your budget. Work Smarter, Not HarderThe Infobright Analytic Data Warehouse is based on the following concepts:
Column Orientation Infobright is, at its core, is a highly compressed column-oriented database. This means that instead of the data being stored row-by-row, it is stored column-by-column. There are many advantages to column-orientation, including the ability to do more efficient data compression because each column stores a single data type (as opposed to rows that typically contain several data types), and allowing compression to be optimized for each particular data type. Most queries only involve a subset of the columns of the tables and so a column-oriented database focuses on retrieving only the data that is required.
Data Packs and the Knowledge Grid Data is stored in 65K Data Packs. Data Pack Nodes contain a set of statistics about the data that is stored and compressed in each of the Data Packs. Knowledge Nodes provide a further set of metadata related to Data Packs or column relationships. Together, Data Pack Nodes and Knowledge Nodes form the Knowledge Grid. Unlike traditional database indexes, they are not manually created, and require no ongoing "care and feeding". Instead, they are created and managed automatically by the system. In essence, they create a high level view of the entire content of the database. The Optimizer The Optimizer is the highest level of intelligence in the architecture. It uses the Knowledge Grid to determine the minimum set of Data Packs that need to be decompressed in order to satisfy a given query in the fastest possible time. Infobright MySQL IntegrationScaling MySQL for Data Warehousing - Leveraging BI tools Infobright's integration with MySQL provides MySQL users the ideal solution for scalable data warehousing - to 30TB and beyond. It also enables Infobright users to choose from the world's leading business intelligence tools for their analytic needs. Infobright and MySQL: the perfect combination. MySQL IntegrationMySQL is the world's most popular open source database software, with over 11 million active installations. Infobright brings scalable data warehousing to MySQL users through its integration as a MySQL storage engine. If your database is growing beyond several hundred gigabytes in size and you have a need for analytics, Infobright is the ideal choice. In the data warehouse marketplace, the database must integrate with a variety of tools. By integrating with MySQL, Infobright leverages the extensive tool connectivity provided by MySQL connectors (C, JDBC, ODBC, .NET, Perl, etc.). It also enables MySQL users to leverage the mature, tested BI tools with which they're already familiar. You'll also benefit from MySQL's legendary ease of use and low maintenance requirements. Infobright-MySQL integration includes the following features:
Infobright FeaturesInfobright Enterprise Edition Infobright's high performance analytic data warehouse is designed to handle business-driven queries on large volumes of data - without IT intervention. Easy to implement and manage, Infobright provides the answers your business users need at a price you can afford. Enterprise Edition FeaturesInfobright technology combines a column-oriented database with our Knowledge Grid architecture to deliver the ideal solution for your growing analytic needs. While other data warehouse products require extensive IT effort to create indexes, partition data and build physical data structures, our self-managing solution delivers rapid response to complex queries created on-the-fly. While other products require complex, expensive hardware infrastructure to provide high performance and scalability, the Infobright solution scales to 30TB+ using a single server and our industry-leading data compression (10:1 up to 40:1) significantly reduces storage requirements.
Infobright CompressionIndustry-Leading Compression
Infobright's column-oriented database plus the Knowledge Grid architecture result in data compression of 10:1 - 40:1. The benefit is faster query response and a significant reduction in storage costs. Managing large volumes of data continues to be a problem. Even though the costs of data storage have declined, data continues to increase at a very rapid rate. At the same time disk transfer rates have not increased significantly and more disks create additional problems, such as expanding back-up times, and additional management overhead. The reality is that data compression can significantly reduce the problems of rapidly expanding data. With Infobright, a 10 TB database becomes 1 TB database. Since the data is much smaller the disk transfer rate is improved (even with the overhead of compression). Unlike traditional row-based data warehouses, Infobright stores data in columns, allowing compression algorithms to be finely tuned to the column data type. Moreover, for each column, the data is split into Data Packs with each storing up to 65,536 values of a given column. Infobright then applies a set of patent-pending compression algortihms that are optimized by automatically self-adjusting various parameters of the algorithm for each data pack. An average compression ratio of 10:1 is achieved in Infobright. For example 10TB of raw data can be stored in about 1TB of space on average (including the overhead associated with Data Pack Nodes and the Knowledge Grid). Other database systems increase the data size because of the additional overhead required to create indexes and other special structures, in some cases by a factor of 2 or more. Even database systems with compression rarely exceed compression ratios of 1 to 1. Within Infobright, the compression ratio may differ depending on data types and content. Additionally, some data may turn out to be more repetitive than others, resulting in compression ratios as high as 40:1.
Infobright BenefitsInfobright Enterprise Edition Infobright's high performance analytic data warehouse is designed to handle business-driven queries on large volumes of data - without IT intervention. Easy to implement and manage, Infobright provides the answers your business users need at a price you can afford. Enterprise Edition BenefitsJust Load and Go
High performance and scalability
Low Cost
|
||||||||||||||||||||
