More than two years ago, the JSON Document Store debuted in SAP HANA Cloud. Starting as a simple yet neatly integrated store for semi-structured data, the development team has invested in enterprise-grade features such as enhanced processing of JSON arrays, support for indexes, and improved integration into the SQL query layer.
In this session, we will provide an overview and a demo of SAP HANA’s JSON Document Store. Additionally, you will learn how to connect MongoDB clients to SAP HANA using an open-source compatibility layer for the MongoDB Wire Protocol.
i had a multi layer/hierarchical graph to be stored for mutli level dependency graphs / rules imposed on scheduling problems: multi resource scheduling subject to such dependency graphs. they were give to us in JSON objects...
I turn my comment into a question : imagine a graph G=(V,E) given in JSON format, where V set of nodes and E set of directed arcs on (VxV).naturally i would like to store this in HANA , from which i would next create a graph with HANA graph or indirectly (table of nodes, table of arcs). regardless of which.
Now, imagine a nested/hierarchy: each node in V in that first level Graph, i zoom on it, it actually represents a sub graph, a level 2 graph, also represented in JSON format. so a two level graph.
Now, imagine this two level graph is all stored in a single JSON structure. i d like to store that in HANA and derive the two level graph (directly or indirectly).
repeat for any level of graphs.... doable in HANA JSON processing ?
this opens up Bill of Bill of Bill of Bill of .... deeply nested BOMs... or deeply nested ... .BOP (processes)
I have sent an example of a two level BOP to your team.
many thx, claude ph
Unfortunately not. The reason for this is that the Document Store requires at least 3 vCPUs and the free tier only offers 2. If this changes, we would be keen on integrating the offering into the free tier.
Here are some additional links, which I pasted in the chat during the live session: