Google Ads
Product News : MemSQL Announces New Tiered Database Platform
on 2014/2/6 9:10:40 (586 reads)
Product News

MemSQL has announced MemSQL v3.0, which combines the world's fastest in-memory row store with a new highly compressed column store. This integration provides a tiered storage architecture that leverages memory for real-time transactions and analytics, and a flash-optimized column store for deep analysis. MemSQL v3.0 provides access to both storage formats through an ANSI SQL interface with built-in utilities for transferring data between formats to eliminate the costly and time-consuming extract, transform and load (ETL) process. This capability leads to shorter development cycles and reduced latency. The result is a single database for both real-time and historical data in a fast, scalable and flexible platform.

With most database offerings, organizations must use separate databases for transactions, analytical processing and data warehousing. This siloed storage approach creates separate collections of data that cannot be analyzed together without costly ETL, a slow and error-prone process. Moreover, separate data stores require engineers to develop on multiple platforms and create custom connectors for databases that were not designed for interoperability.

MemSQL v3.0 has a simplified data infrastructure that makes it possible to maintain one active dataset, allowing users and applications to conduct real-time analysis that incorporates both live and historical data. Companies can use MemSQL's in-memory row store to ingest streaming data and run time-sensitive analytics. As data volumes grow, data can be moved to the new flash-optimized column store for highly compressed long-term storage and for deep analysis. This tiered storage architecture provides greater flexibility, and the result is a simpler, more cost-effective and less latency-prone data infrastructure.

 

Key Features

MemSQL v3.0 features a tiered storage architecture that allows companies to combine in-memory row and flash-optimized columnar engines to capture, store and query hundreds of terabytes of data in real-time. Highlights include the following:
* Workloads can access data in both row and column stores.
* MemSQL v3.0 is highly compressible -- deploy in memory, flash or disk.
* Built-in utilities transfer data seamlessly between storage tiers.
* MemSQL v3.0 is horizontally scalable on commodity hardware.

Printer Friendly Page Send this Story to a Friend Create a PDF from the article

Copyright (c) 2007-2014 Martinig & Associates | Methods & Tools Software Development Magazine | Privacy Policy
Software Development Articles | Software Development Directory | Software Development Videos
Software Development Jobs | Software Development News | Software Development Books
Software Development Blogs | Software Development Conferences