Adoption of in-memory technology solutions is happening faster than ever. This stems from a three pronged demand – first, a greater number of users, analysts, and businesses need access to data. Second, the number of transactions is increasing globally, so companies need faster ingest and analytics engines. Finally, performance inconsistencies are the nail in the coffin for companies competing in the on-demand economy – these enterprises need the responsiveness in-memory technology...
by Emily Friedman
The amount of data created in the past two years surpasses all of the data previously produced in human history. Even more shocking is that for all of that data produced, only 0.5% is being analyzed and used. In order to capitalize on data that exists today, businesses need the right tools to ingest and analyze data.
At MemSQL, our mission is to do exactly that. We help enterprises operate in today’s real-time world by unlocking value from data instantaneously. The first step in achieving this...
by Dale Deloy
The infrastructure of IoT will have a real-time database behind every sensor.
Soon every device with a sensor will blend seamlessly into the Internet of Things, from drones to vehicles to wearables. Device and sensor count predictions range from billions to trillions. With this tidal wave of new devices comes an increasing number of new data streams, converging to make instant analytics on real-time data a tenant of any digital transformation.
Our penchant for instant gratification extends to...
by Gary Orenstein
Photo: Martin Taylor
We often hear “How can I use MemSQL together with my Oracle database?”
As a relational database, MemSQL is similar to an Oracle database, and can serve as an alternative to Oracle in certain scenarios. Here is what sets MemSQL apart:
MemSQL is a distributed system, designed to run on multiple machines with a massively parallel processing architecture. An Oracle database, on the other hand, resides in a single, large machine, or a smaller fixed cluster size.
by Steven Camina
Our CTO and co-founder Nikita Shamgunov recently sat down with Software Engineering Daily. In the interview, Nikita focused on the ideal use cases for an in-memory database, compared to a disk-based store, and clarified how MemSQL compares to MySQL. In this post, we will dig deeper into how we define the ‘in-memory database’ and summarize its benefits.
What is MemSQL?
MemSQL is a high-performance in-memory database that combines the horizontal scalability of distributed systems with...
by Lesia Myroshnichenko
The database market continues to surprise those of us who have been in it for a while. After the initial wave of consolidation in the late 1990s and early 2000s, the market has exploded with new entrants: column-stores, document databases, NoSQL, in-memory, graph databases, and more. But who will truly challenge the incumbents for a position in the Top 5 rankings? Oracle, IBM, Microsoft, SAP, and Teradata dominate the $33B database market. Will it be a NoSQL database? Will it be an open source...
by Bruce Armstrong
We started MemSQL with a vision to enable every company to be a real-time enterprise, and to do that by delivering the leading real-time database for transactions and analytics. Since then, the forces shaping our digital economy have only added wind to our sails. The world is more mobile, interconnected, interactive, and on the cusp of several industry transformations such as the Internet of Things.
Real-time processing is the secret to keeping up, and in-memory solutions are the foundation....
by Eric Frenkiel
As technology weaves into our daily lives, our expectations of it continue to increase. Consider mobile devices and location information. Recently 451 Research released data that 47% of consumers would like to receive personalized information based on immediate location.
Source: 451 Research
Addressing this requires the ability to track real-time and historical data and to put both in context. Let’s examine that spectrum.
Incoming High Value Content
With a focus on ‘immediate,’ the highest...
Setting the Stage for Spark
With Spark on track to replace MapReduce, enterprises are flocking to the open source framework in effort to take advantage of its superior distributed data processing power.
IT leads that manage infrastructure and data pipelines of high-traffic websites are running Spark–in particular, Spark Streaming which is ideal for structuring real-time data on the fly–to reliably capture and process event data, and write it in a format that can immediately be queried by...
by Neil Dahlke
In preparation for Open World, I asked some of our engineers to recreate a demo that Oracle has been using over the last year to show off their “in-memory option.” It’s impressive to look at: the demo shows the database searching through billions of records from Wikipedia search trend data for popular terms in less than a second.
The thing about Oracle’s demo is it runs on a gigantically expensive server. In fact it is the biggest one they have at 32TB of RAM and hundreds of CPU cores....
by Nikita Shamgunov