Spatially has chosen CrateDB over Postgres and Cassandra to give SMBs a comprehensive view of customers and business opportunities in their area. Spatially is a user of CrateDB Enterprise Edition, using the database for rapid analysis of tens of terabytes of Localgraphics data compiled about major U.S. cities like Boston, Seattle, and Miami.

Spatially uses massive datasets, such as U.S. census data, public transit, traffic and device-tracking data, to help SMBs decide where to put their business and how to advertise to their customers. Its customers can look at foot and vehicle traffic, spending and both facility and advertising placement by local competitors.

To find geographic insights through the patterns and relationships in their data, Spatially data scientists analyze terabytes of data in CrateDB using SQL, GO, Python, R, Spark/EMR and others. Spatially engineers then implement those data sets, queries and algorithms in a customer- facing SaaS system that is also powered by CrateDB. Spatially plans to scale CrateDB to handle hundreds of terabytes as it continues to expand to other cities.

CrateDB is an open source SQL database built on top of NoSQL storage, indexing and networking technology for simpler scaling and greater data model flexibility. Its unique architecture makes it ideal for ingesting and querying a firehose of IoT and machine-generated data in real time and it gives developers the benefits of NoSQL databases without forcing them to abandon SQL.

CrateDB features the following innovations:

Distributed SQL query engine for faster JOINs, aggregations and ad-hoc queries

In-memory columnar indexes and a fully distributed query engine enable CrateDB to perform complex queries in real time and overcome many of the performance and...

To continue reading