InfiniDB Delivers High Performance Query for large MapReduce and NoSQL data sets
Organizations struggling with large transactional and web data processing are turning to alternatives for traditional RDMS’s to capture and manipulate that data. MapReduce and other NoSQL offerings enable the ability to scale data environments very large, in a parallel manner. The role these technologies play focus on extract, transform, and load (ETL) types of operations, with solutions offering the ability to execute complex transformations rapidly and address ad-hoc queries against non-dimensionalized data easily.
However, MapReduce and NoSQL data offerings are
- Not designed for query intensive applications – those in which query performance time against large dimensional or non-dimensional data sets is crucial to business execution.
- Not optimized for query response time in an out-of-box capacity – they require a heavy investment of programming resources to optimize and re-optimize the data environment as the business changes and grows.
- Bottlenecked by intermediate query results – Unlike parallel, column-oriented databases, MapReduce solutions aren’t optimized for query processing capabilities, slowing query response by writing intermediate query results to local data structures as part of the query execution process.
Calpont InfiniDB – Built for Speed against Big Data
Calpont InfiniDB is a massively parallel processing (MPP), columnar database designed specifically for read intensive analytic applications and data warehouses that consume large amounts of operational and transaction data. InfiniDB scales performance linearly with data scale and hardware, is easy to deploy and maintain, and requires no special database tuning, indexing or materialized views, making it ideally suited for complex, Big Data analytics.
Distributed Map-Reduction Inherent to InfiniDB
For those searching for a new data platform to replace a traditional RDMS or legacy data warehouse that can scale extremely large and deliver fast analytics against that large data, InfiniDB is an ideal solution for both. InfiniDB executes map-reduction operations and user defined functions (UDFs) as out-of-box functionally, completely distributed and parallelized within its architecture, taking full advantage of InfiniDB’s exceptionally fast query processing.