MemSQL Brings Geospatial Analysis to In-Memory, Distributed Databases

March 20, 2015  - By
Image: GPS World

MemSQL, which specializes in real-time databases for transactions and analytics, has announced new geospatial capabilities for its in-memory, distributed SQL-based database. By bringing together geospatial and operational data in the same high speed database, customers can achieve unprecedented agility for geospatial analysis, MemSQL said.

Unlike segregated solutions, MemSQL integrates geospatial data as a primary data type, making it as easy to use and operate at scale with as much speed and high throughput as any other class of data.

Previously, enterprises were forced to segregate their geospatial data into separate data stores. With the rise of IoT and mobility, nearly all data is location-specific. As data volume increases, maintaining geolocation information outside of the primary datastore leads to longer latency and synchronization challenges.

By integrating geospatial functions, MemSQL enables enterprises to achieve greater database efficiency with a single database that is in-memory, linearly scalable and supports the full range of relational SQL and geospatial functions. With MemSQL, geospatial data no longer remains separate and becomes just another data type with lock-free capabilities and powerful manipulation functions.

Taxi Scenario with Esri. Working with MemSQL and Apache Spark, Esri analyzed data compiled from 170 million real-world New York City taxi rides around the GPS coordinates of pickups and dropoffs, as well as distance and travel time. Slicing by hour of the day, Esri can calculate the average speed of a taxi ride and find the best and worst places for traffic jams. Slicing by day of the week, the ebb and flow of traffic during workdays and weekends becomes visible.

For a city planner, this data insight can be used to redirect traffic at specific times in an effort to unclog traffic congestion. For the taxi business, this data can improve efficiency with supply and demand of cabs during times of high or low traffic for any given region.

“MemSQL is enabling companies to consolidate many niche solutions into fewer, more capable multi-purpose solutions. By making geospatial data a primary part of in-memory, operational databases, our customers can rely on one solution to make their data more valuable,” said Eric Frenkiel, MemSQL co-founder and CEO. “We’re delivering on our promise of easy access to database innovation and are quickly becoming the go-to-company to help enterprises operationalize analytics.”

MemSQL will showcase the MemSQL, Apache Spark and Esri demonstration at Spark Summit East 2015 on March 18-19 at The Sheraton New York Times Square Hotel. Visit MemSQL at Booth 13 during show expo hours.

The early access MemSQL geospatial capabilities are available now and will be generally available in calendar Q2. Read the technical blog post here.

This article is tagged with , , and posted in GIS News, GIS Software, GNSS/GPS, Technology

About the Author: Tracy Cozzens

Senior Editor Tracy Cozzens joined GPS World magazine in 2006. She also is editor of GPS World’s newsletters and the sister website Geospatial Solutions. She has worked in government, for non-profits, and in corporate communications, editing a variety of publications for audiences ranging from federal government contractors to teachers.