Welcome!

News Feed Item

MemSQL Announces New Tiered Database Platform for Combined Real-Time and Historical Data Analysis

New Integrated Architecture Delivers World's Fastest In-Memory Database Processing for Both Operations and Analytics, Plus Rapid-Transfer Flash-Optimized Column Store for Deep Analysis

SAN FRANCISCO, CA -- (Marketwired) -- 02/06/14 -- MemSQL, the leader in distributed in-memory database technology, today 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.

As a customer of MemSQL, CPXi has been in production with the new columnar architecture for almost six months. CPXi is a global digital media holding company providing multi-screen messaging that leverages display, social, mobile and video advertising at scale and serves billions of managed impressions daily.

"The new capabilities in MemSQL v3.0 allow CPXi to leverage historical data stores and use them to shape a real-time response," said Gil Resh, senior vice president of product and technology at CPXi. "We measure online engagement over time and capture vast amounts of data -- more than 250 billion records with hundreds of different dimensions -- to make millisecond decisions about which ads to show, even while the webpage is loading."

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.

"Enterprises are increasingly seeking to make the smartest possible decision in the critical moment, in order to increase efficiency, reduce operational risk, and maximize income potential. Such enterprises need to leverage Big Data with real-time analysis of their data so they can best serve both their customers and their bottom lines," said IDC analyst Carl Olofson. "The purpose of MemSQL v3.0 technology is to enable enterprises to process coordinated transactional and up-to-the-minute analytical workloads. This ensures data timeliness and integrity while obviating the need for complex ETL or CDC data transfers, thus saving resources and eliminating related operational delays, frustration and human error."

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.

"Our customers' top priorities are speed and scalability,'" said Eric Frenkiel, co-founder and CEO of MemSQL. "Our new flash-optimized column store means customers can combine real-time and historical data for added flexibility, extracting the full value of their data."

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.

Availability
MemSQL v3.0 will be available for download in Q2 2014. For more information regarding an enterprise license including full support and services, please contact [email protected] or (855) 4-MEMSQL (463-6775).

Additional Resources

About MemSQL

MemSQL is the database for fast data processing. With a single platform, companies can converge live data with their data warehouse to accelerate applications and power real-time operational analytics. MemSQL's Big Data platform brings speed, scale, and simplicity to enterprise customers worldwide. Based in San Francisco, MemSQL is a Y Combinator company funded by prominent venture capitalists and angel investors, including Accel Partners, Khosla Ventures, Data Collective, First Round Capital and IA Ventures. For more information, please visit www.memsql.com.

Add to Digg Bookmark with del.icio.us Add to Newsvine

More Stories By Marketwired .

Copyright © 2009 Marketwired. All rights reserved. All the news releases provided by Marketwired are copyrighted. Any forms of copying other than an individual user's personal reference without express written permission is prohibited. Further distribution of these materials is strictly forbidden, including but not limited to, posting, emailing, faxing, archiving in a public database, redistributing via a computer network or in a printed form.

Latest Stories
Agile has finally jumped the technology shark, expanding outside the software world. Enterprises are now increasingly adopting Agile practices across their organizations in order to successfully navigate the disruptive waters that threaten to drown them. In our quest for establishing change as a core competency in our organizations, this business-centric notion of Agile is an essential component of Agile Digital Transformation. In the years since the publication of the Agile Manifesto, the conn...
"MobiDev is a software development company and we do complex, custom software development for everybody from entrepreneurs to large enterprises," explained Alan Winters, U.S. Head of Business Development at MobiDev, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Large industrial manufacturing organizations are adopting the agile principles of cloud software companies. The industrial manufacturing development process has not scaled over time. Now that design CAD teams are geographically distributed, centralizing their work is key. With large multi-gigabyte projects, outdated tools have stifled industrial team agility, time-to-market milestones, and impacted P&L stakeholders.
"ZeroStack is a startup in Silicon Valley. We're solving a very interesting problem around bringing public cloud convenience with private cloud control for enterprises and mid-size companies," explained Kamesh Pemmaraju, VP of Product Management at ZeroStack, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native applications. However, sharing a Kubernetes cluster between members of the same team can be challenging. And, sharing clusters across multiple teams is even harder. Kubernetes offers several constructs to help implement segmentation and isolation. However, these primitives can be complex to understand and apply. As a result, it’s becoming common for enterprises to end up with several clusters. Thi...
"Akvelon is a software development company and we also provide consultancy services to folks who are looking to scale or accelerate their engineering roadmaps," explained Jeremiah Mothersell, Marketing Manager at Akvelon, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
In his session at 21st Cloud Expo, Carl J. Levine, Senior Technical Evangelist for NS1, will objectively discuss how DNS is used to solve Digital Transformation challenges in large SaaS applications, CDNs, AdTech platforms, and other demanding use cases. Carl J. Levine is the Senior Technical Evangelist for NS1. A veteran of the Internet Infrastructure space, he has over a decade of experience with startups, networking protocols and Internet infrastructure, combined with the unique ability to it...
"Infoblox does DNS, DHCP and IP address management for not only enterprise networks but cloud networks as well. Customers are looking for a single platform that can extend not only in their private enterprise environment but private cloud, public cloud, tracking all the IP space and everything that is going on in that environment," explained Steve Salo, Principal Systems Engineer at Infoblox, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Conventio...
"Codigm is based on the cloud and we are here to explore marketing opportunities in America. Our mission is to make an ecosystem of the SW environment that anyone can understand, learn, teach, and develop the SW on the cloud," explained Sung Tae Ryu, CEO of Codigm, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
The question before companies today is not whether to become intelligent, it’s a question of how and how fast. The key is to adopt and deploy an intelligent application strategy while simultaneously preparing to scale that intelligence. In her session at 21st Cloud Expo, Sangeeta Chakraborty, Chief Customer Officer at Ayasdi, provided a tactical framework to become a truly intelligent enterprise, including how to identify the right applications for AI, how to build a Center of Excellence to oper...
"IBM is really all in on blockchain. We take a look at sort of the history of blockchain ledger technologies. It started out with bitcoin, Ethereum, and IBM evaluated these particular blockchain technologies and found they were anonymous and permissionless and that many companies were looking for permissioned blockchain," stated René Bostic, Technical VP of the IBM Cloud Unit in North America, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Conventi...
Gemini is Yahoo’s native and search advertising platform. To ensure the quality of a complex distributed system that spans multiple products and components and across various desktop websites and mobile app and web experiences – both Yahoo owned and operated and third-party syndication (supply), with complex interaction with more than a billion users and numerous advertisers globally (demand) – it becomes imperative to automate a set of end-to-end tests 24x7 to detect bugs and regression. In th...
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, discussed how by using ne...
"Cloud Academy is an enterprise training platform for the cloud, specifically public clouds. We offer guided learning experiences on AWS, Azure, Google Cloud and all the surrounding methodologies and technologies that you need to know and your teams need to know in order to leverage the full benefits of the cloud," explained Alex Brower, VP of Marketing at Cloud Academy, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clar...