Upgrade to Pro — share decks privately, control downloads, hide ads and more …

The Extreme Analytics Platform for Data Science and Analytics

The Extreme Analytics Platform for Data Science and Analytics

In this presentation we explain the features in MapD that makes it the best GPU based operational analytics platform. We also discuss the newly released MapD 4.0 with native support for Geospatial data type.

OmniSci

June 26, 2018
Tweet

More Decks by OmniSci

Other Decks in Technology

Transcript

  1. Advanced memory management SSD or NVRAM STORAGE (L3) 250GB to

    20TB 1-2 GB/sec CPU RAM (L2) 32GB to 3TB 70-120 GB/sec GPU RAM (L1) 24GB to 256GB 1000-6000 GB/sec Hot Data Speedup = 1500x to 5000x Over Cold Data Warm Data Speedup = 35x to 120x Over Cold Data Cold Data COMPUTE LAYER STORAGE LAYER Data Lake/Data Warehouse/System Of Record
  2. Geospatial Objects Type POINT A point described by two coordinates.

    LINESTRING A sequence of 2 or more points and the lines that connect them. POLYGON A set of one or more rings (closed line strings), with the first representing the shape (external ring) and the rest representing holes in that shape (internal rings) MULTIPOLYGON A set of one or more polygons.
  3. Supported Geo File Formats Type GeoJSON Uses the JavaScript Object

    Notation (JSON) open data standard for storing geographical features as key-value pairs. ESRI Shapefile Consists of a group of files (.shp, .shx, .dbf etc) that need to be stored in the same directory or part of a zip file. The .shp file contains the feature geometry itself. KML Keyhole Markup Language is based on XML, using tag-based structure with nested elements and attributes to store geographic data. CSV/TSV with WKT Well Known Text (WKT) is a text markup language for representing vector geometry objects on a map.
  4. Geospatial Functions Spatial Relationship and Measurement Functions Returns shortest planar

    distance between geometries. Returns shortest geodesic distance between geographies (in meters, limited support) . Returns true if first geometry contains the second one.