MemSQL Rides In-Memory Rocket, SQL Legacy for Big Data
Updated · Jun 25, 2012
San Francisco-based MemSQL released a new database that the startup says will give companies struggling with Big Data the benefits of SQL at NoSQL speeds.
MemSQL was founded last year by former Facebook staffer Eric Frenkiel and Nikita Shamgunov, who served as a Microsoft SQL Server senior database engineer. To date, the company has attracted $5 million in funding from venture firms and angel investors including First Round Capital, IA Ventures, NEA, Y Combinator and actor Ashton Kutcher.
MemSQL plans to use the funds to bolster its sales and marketing efforts and ramp up technical support as it woos customers from the financial services, digital advertising and telecommunications industries.
With its recent launch, MemSQL joins the hot and highly contested Big Data analytics market. Currently, industry heavyweights Oracle and SAP are battling it out in the in-memory space with their Exalytics and HANA products, respectively. And they have plenty of company. Of late, firms like Teradata, Opera Solutions and Tibco have been growing the in-memory analytics market with new offerings.
SQL, Meet In-Memory Analytics
MemSQL blends lock-free data structures and a unique coding translation process to enable fast analytics using traditional SQL database techniques, according to the company. The technology also exploits the performance boost provided by in-memory systems and appliances.
In-memory analytics systems employ huge stores of RAM to overcome the latency and bandwidth constraints of transferring data from disk-based storage. The result is a performance-boosting architecture that allows analytics applications to process huge data sets at faster rates.
MemSQL’s approach to integrating SQL data and main memory storage provides a big leap in Big Data processing, says MemSQL CEO Eric Frenkiel. “MemSQL was designed to tackle Big Data problems by increasing an application’s throughput 30 times over and still offer SQL,” he states in a company release.
And all in a package that delivers a “flat learning curve for MySQL users” and installs using one command, according to the company.
The company also touts the platform’s ability to accommodate massive levels of transactional throughput using commodity IT hardware and provide real-time analytics on constantly changing data. Rounding out the benefits are sub-millisecond response times, a distributed and scalable architecture and resiliency features.