Structured and JSON Data Together.
MemSQL combines structured and semi-structured data in a single database, making it easy to store and query JSON and structured data together using SQL.
- Enable Rapid Application Development.
- Engineers move faster with a single data store that supports structured and semi-structured data. MemSQL 2.5 enables engineers to develop with one database that combines both structured and JSON data for flexibility and simplicity.
- Eliminate the ETL Process.
- MemSQL eliminates the time required to process and move JSON data between data stores in order to run analytics. Rather than structuring the JSON and loading it into another database, developers can insert JSON data directly into MemSQL alongside their structured data.
Use SQL to Query JSON Data.
The ability to store and query structured and semi-structured data together, in one place, has enormous business value. By supporting JSON data in a high performance database, MemSQL enables real-time analytics on data feeds of variable structure.
- Use standard SQL over JSON data including built-ins, GROUP BY, JOINs, and more.
- Create JSON indexes online.
- Client drivers require no changes to support JSON.
- JSON properties are updatable.
- JSON columns can contain ‘null’, ‘true’, ‘false’, double-precision floating-point values, quoted strings, heterogeneous arrays, and/or objects.
Access JSON properties through SQL.
SELECT * FROM accounts WHERE click_stream::%is_active AND JSON_LENGTH(click_stream::clicked) > 1;
What the Analysts Say.
“With its in-memory database, MemSQL is well positioned to enable organizations to analyze operational data in real time and attain operational insights faster.” Matt Aslett, research director, data management and analytics, 451 Research