When you need to analyze a mountain of data, there simply is no substitute for column based database technology. InfiniDB Enterprise is a 100% columnar data engine design, which is has been widely recognized by the data warehouse community as the best paradigm for analytic databases. A column based database reads only the columns needed to satisfy a query, rather than all rows like traditional row-based systems, making queries much faster.
Index-free Design and Automated Partitioning Increase Speed
In addition to better performance, InfiniDB’s columnar database design provides other useful benefits to those that need to deploy fast business intelligence databases. Through the use of the InfiniDB’s intelligent Extent Map, indexes, materialized views and manual data partitioning are thing of the past. There is no need for indexing because the column is the index. This means that data loading is faster, and ad-hoc DML work speed is increased because no index updates need to be performed. Data partitioning in InfiniDB is automatic, both vertically and horizontally, eliminating unnecessary row and column data from queries.
Data Loading has Never Been Faster
Fast isn’t reserved for queries either. InfiniDB’s high-performance data load utility ensures your ability to keep up with the velocity of your business data. InfiniDB can load over a 1 million data records every second. What used to take days for many large data load scenarios, can now take an hour or two, making it easier for data administrators to plan around daily and sub-daily loads, while keeping the business users productive and happy.
Scaling InfiniDB Improves Performance
InfiniDB Enterprise is a column based database rooted in a distributed, MPP architecture. Its two-tiered distribution of work method enables linear scaling of query performance by adding more software nodes when scaling out hardware.