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
In his General Session at DevOps Summit, Asaf Yigal, Co-Founder & VP of Product at Logz.io, will explore the value of Kibana 4 for log analysis and will give a real live, hands-on tutorial on how to set up Kibana 4 and get the most out of Apache log files. He will examine three use cases: IT operations, business intelligence, and security and compliance. This is a hands-on session that will require participants to bring their own laptops, and we will provide the rest.
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place June 6-8, 2017, at the Javits Center in New York City, New York, is co-located with 20th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry p...
@DevOpsSummit at Cloud taking place June 6-8, 2017, at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long developm...
A look across the tech landscape at the disruptive technologies that are increasing in prominence and speculate as to which will be most impactful for communications – namely, AI and Cloud Computing. In his session at 20th Cloud Expo, Curtis Peterson, VP of Operations at RingCentral, will highlight the current challenges of these transformative technologies and share strategies for preparing your organization for these changes. This “view from the top” will outline the latest trends and developm...
"LinearHub provides smart video conferencing, which is the Roundee service, and we archive all the video conferences and we also provide the transcript," stated Sunghyuk Kim, CEO of LinearHub, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
When you focus on a journey from up-close, you look at your own technical and cultural history and how you changed it for the benefit of the customer. This was our starting point: too many integration issues, 13 SWP days and very long cycles. It was evident that in this fast-paced industry we could no longer afford this reality. We needed something that would take us beyond reducing the development lifecycles, CI and Agile methodologies. We made a fundamental difference, even changed our culture...
Things are changing so quickly in IoT that it would take a wizard to predict which ecosystem will gain the most traction. In order for IoT to reach its potential, smart devices must be able to work together. Today, there are a slew of interoperability standards being promoted by big names to make this happen: HomeKit, Brillo and Alljoyn. In his session at @ThingsExpo, Adam Justice, vice president and general manager of Grid Connect, will review what happens when smart devices don’t work togethe...
"There's a growing demand from users for things to be faster. When you think about all the transactions or interactions users will have with your product and everything that is between those transactions and interactions - what drives us at Catchpoint Systems is the idea to measure that and to analyze it," explained Leo Vasiliou, Director of Web Performance Engineering at Catchpoint Systems, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York Ci...
The 20th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held June 6-8, 2017, at the Javits Center in New York City, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit your speaking proposal ...
@DevOpsSummit taking place June 6-8, 2017 at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. @DevOpsSummit at Cloud Expo New York Call for Papers is now open.
SYS-CON Events announced today that Dataloop.IO, an innovator in cloud IT-monitoring whose products help organizations save time and money, has been named “Bronze Sponsor” of SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Dataloop.IO is an emerging software company on the cutting edge of major IT-infrastructure trends including cloud computing and microservices. The company, founded in the UK but now based in San Fran...
WebRTC is the future of browser-to-browser communications, and continues to make inroads into the traditional, difficult, plug-in web communications world. The 6th WebRTC Summit continues our tradition of delivering the latest and greatest presentations within the world of WebRTC. Topics include voice calling, video chat, P2P file sharing, and use cases that have already leveraged the power and convenience of WebRTC.
20th Cloud Expo, taking place June 6-8, 2017, at the Javits Center in New York City, NY, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy.
Discover top technologies and tools all under one roof at April 24–28, 2017, at the Westin San Diego in San Diego, CA. Explore the Mobile Dev + Test and IoT Dev + Test Expo and enjoy all of these unique opportunities: The latest solutions, technologies, and tools in mobile or IoT software development and testing. Meet one-on-one with representatives from some of today's most innovative organizations
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in Embedded and IoT solutions, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 7-9, 2017, at the Javits Center in New York City, NY. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/Big Data, HPC and E...