rss.livelink.thread@place:occasion

🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

Vitaliy-R — Fri, 29 Sep 2023 15:23:26 GMT

More than two years ago, the JSON Document Store debuted in . 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 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.

📺 Slides

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

cphmedard — Mon, 11 Sep 2023 10:43:08 GMT

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...

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

cphmedard — Fri, 15 Sep 2023 13:05:03 GMT

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

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

mvinci — Thu, 28 Sep 2023 07:01:32 GMT

Best in devoctoberfest !!!

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

akuller — Thu, 28 Sep 2023 07:28:13 GMT

@mkemeter nice session, are there any plans to make document storage available in the free tier model?

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

mkemeter — Thu, 28 Sep 2023 07:38:00 GMT

Thanks Marcello!

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

mkemeter — Thu, 28 Sep 2023 07:39:27 GMT

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.

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

mkemeter — Thu, 28 Sep 2023 07:45:16 GMT

Here are some additional links, which I pasted in the chat during the live session:

SAP HANA Multi-model Community blogs:
https://blogs.sap.com/tags/ca0132d1-ba23-4d3c-a7ef-5bcbd1cf01a3/
Blog on Document Store Use Cases:
https://blogs.sap.com/2023/02/02/sap-hana-cloud-document-store-when-would-i-use-a-document-store/
Blog on some advanced Document Store SQL Queries:
https://blogs.sap.com/2021/08/04/the-small-json-document-store-cookbook/
Further resources on SAP HANA Spatial:
https://cutt.ly/saphanaspatial
Starter Blog for the Compatibility Layer:
https://blogs.sap.com/2022/12/13/introduction-to-sap-hana-compatibility-layer-for-mongodb-wire-protocol/
GitHub Repository of the Compatibility Layer:
https://github.com/SAP/sap-hana-compatibility-layer-for-mongodb-wire-protocol
The FerretDB Project:
https://www.ferretdb.io/

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

LuisBenavidesA — Thu, 28 Sep 2023 08:37:27 GMT

Great, thanks @mkemeter for share it, helpful resources to continuous of learning journey.

Re: 🔵 SAP HANA Cloud: processing semi-structured data using the JSON Document Store

Vitaliy-R — Mon, 16 Oct 2023 13:14:51 GMT

Slides from @mkemeter can be found at https://dam.sap.com/mac/u/a/VSP5Wn1.htm?rc=10