Skip to Content
Previous

Working with Document Store Engine in SAP Vora

By Vitaliy Rudnytskiy

Document Store is a distributed in-memory JSON document store that supports rich query processing over JSON data

You will learn

You will learn how to process JSON data using SAP Vora document store engine.

Details


Step 1: Document Store Engine

Document Store is a distributed in-memory JSON document store that supports rich query processing over JSON data.

The Document Store uses a special binary JSON format and a highly optimized, parallel, and NUMA (Non-Unified Memory Access architecture) aware execution engine to provide high performance on analytical workloads. It also combines JSON with most of the regular SQL features. You do not have to learn a new query language, but can use SQL for JSON as well.

Step 2: Running notebook 7_Document Store

Continue by select ting the 7_Document Store notebook.
Notebook

You will be looking at employee data, the raw data is stored in a single JSON document. Start by creating the required partition function and partition scheme.
Partition function and scheme

Run some basic queries against Document Store Engine.
Basic queries

Run and complete the remainder of the paragraphs in this notebook.

Next Steps

Updated 09/13/2017

Time to Complete

10 Min

Beginner

Tags

Next
Back to top

Call me now