TMCnet News
Splice Machine's New OLAP Engine Adds Columnar Storage and In-Memory Caching to its Hybrid Relational Data PlatformLAS VEGAS, Nov. 29, 2016 /PRNewswire/ -- Splice Machine, provider of the open-source SQL RDBMS powered by Apache Hadoop® and Apache Spark™, today announced at AWS re:Invent 2016 the release of version 2.5 of its industry-leading data platform for intelligent applications. The new version strengthens its ability to concurrently run enterprise-scale transactional and analytical workloads, frequently referred to as HTAP (Hybrid Transactional and Analytical Processing). "The new capabilities further emphasize the benefits of Splice Machine's hybrid architecture," said Monte Zweben, co-founder and CEO of Splice Machine. "For modern applications that need to combine fast data ingestion, web-scale transactional and analytical workloads, and continuous machine learning, one storage model does not fit all. The Splice Machine SQL RDBMS tightly integrates multiple compute engines, with in-memory and persistent storage in both row-based and columnar formats. The cost-based optimizer uses new advanced statistics to find the optimal execution strategy across all these resources for OLTP and OLAP workloads." With Splice Machine's hybrid architecture, companies can:
Version 2.5 of Splice Machine introduces important new capabilities: Columnar External Tables enables hybrid columnar and row-based querying. Columnar external tables can be created in Apache Parquet, Apache ORC or text formats. Columnar Storage improves large table scans, large joins, aggregations or groupings while the native row-based storage is used for write-optimized ingestion, single-record lookups/updates and short scans. In-Memory Caching via Pinning gives the ability to move tables and columnar data files into memory for lightning-fast data access. It avoids multiple table scans or writes to high-latency file systems such as Amazon S3. The capability allows data to be stored on very inexpensive storage while being very performant in-memory when required in applications. Statistics via Sketching helps solve the age-old problem that cost-based optimizers are only as good as their statistics, but most statistics are poor because statistics computation is expensive. Splice Machine utilizes the sketching library created by Yahoo! to provide very fast approximate analysis of Big Data statistics with bounded errors. Now with the power of sketches and histograms, the Splice Machine cost-based optimizer can choose indexes, join orders, and join algorithms with much more accuracy. Cost-Optimized Storage for AWS users. Data can be stored locally in ephemeral storage, on EBS, S3 and EFS. Depending on the workload and longevity of data, different data can be stored in different storage systems with different price/performance characteristics. About Splice Machine Splice Machine is a trademark of Splice Machine, Inc. Apache Hadoop®, Hadoop, Apache HBase, HBase, Apache Spark, Spark™, Apache Parquet and Apache ORC are trademarks of the Apache Software Foundation (ASF). Oracle and PL/SQL are trademarks of Oracle Corporation. All other trademarks are the property of their respective registered owners. Trademark use is for identification only and does not imply sponsorship, affiliation, or endorsement. Logo - http://photos.prnewswire.com/prnh/20140509/86257 To view the original version on PR Newswire, visit:http://www.prnewswire.com/news-releases/splice-machines-new-olap-engine-adds-columnar-storage-and-in-memory-caching-to-its-hybrid-relational-data-platform-300369470.html SOURCE Splice Machine |