Spatially Chooses CrateDB to Power Location-Based Insights for SMBs

CrateDB selected over Postgres and Cassandra for fast analysis of terabytes of geospatial “Localgraphics™” data

SAN FRANCISCO — (BUSINESS WIRE) — November 7, 2017 — Crate.io, developers of CrateDB, a leading open source SQL database for real time analytics of IoT and machine data, today announced that Spatially, a provider of location intelligence software, chose 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.

“Spatially is a data-driven platform, so finding the right database was critical,” said Spatially CTO, Kartik Venkatesh. “Postgres couldn’t keep up with the data we have; Datastax Enterprise had ingest scaling issues with spatial data; Cassandra didn’t have spatial query operations. CrateDB was the only database we found that could smoothly process data for our users and for our data science team. We fell in love with it immediately.”

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 flexibility limitations of first-generation distributed SQL databases.

  • Data and query versatility via ANSI SQL on NoSQL underpinnings

CrateDB is a unique combination of SQL and NoSQL technology, which enables dynamic data schemas and a wide range of analytics and search, on time series, full text, JSON, geospatial and other structured and unstructured data without having to use different database engines to do so.

  • Simple scaling through a container architecture and automatic data sharding

Database scalability is vital for handling variations in machine data volume, but this is normally difficult to do. CrateDB can run as a cluster of containers, which enables it to be scaled easily with container platforms like Docker or Kubernetes. In addition, CrateDB automatically shards and redistributes data across the cluster as it changes size to optimize performance and high availability.

“We are really excited to be working with Spatially as they pioneer the field of Localgraphics,” said Christian Lutz, CEO of Crate.io. “The places customers go in their cars and with their phones can fundamentally change an SMB’s advertising strategy, or even the location of their business. We built CrateDB to support this type of data and we’re thrilled to see it shaping the world we live in.”

About Crate.io

Crate.io is the developer of CrateDB, an open source distributed database offering the scalability and performance of NoSQL with the power and ease of standard SQL. Designed specifically to support IoT and machine data applications, Crate is optimized for containerized environments. Crate.io is headquartered in San Francisco with offices in Berlin, Germany and Dornbirn, Austria.



Contact:

Mindshare PR
Sarah Bennett, +1 408-828-1366
Email Contact




Review Article Be the first to review this article
Featured Video
Jobs
Geospatial Solutions Specialist for University of North Dakota at Grand Forks, North Dakota
GIS Coordinator for City of Marysville at Marysville, Ohio
GIS Analyst II for Foresters Co Op at Grass Valley, California
Electrical Designer for Dinter Engineering at Reno, Nevada
Senior Project Architect for Gordon Prill, Inc at Sunnyvale, California
Director, Industrial Machinery Solutions- SISW PLM for Siemens AG at Livonia, Michigan
Upcoming Events
InterDrone 2021 --- Cancelled at Hyatt Regency Dallas TX - Aug 10 - 12, 2021
URISA GIS Leadership Academy at 701 Lee St #960 Des Plaines IL - Aug 16 - 20, 2021
8th International Scientific Conference on SOCIAL SCIENCES (ISCSS) 2021 at Congress Centre MARITIM PARADISE BLUE Albena Bulgaria - Aug 21 - 30, 2021



© 2021 Internet Business Systems, Inc.
670 Aberdeen Way, Milpitas, CA 95035
+1 (408) 882-6554 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation TechJobsCafe - Technical Jobs and Resumes  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise