Enhancements to Graph Processing in SAP HANA 2.0 SPS 01
SAP HANA Graph processing continues to evolve at a rapid pace and new capabilities were recently introduced with HANA 2.0 SPS 01.
New capabilities focus on enhanced support both for Cypher Query Language and GraphScript as well as additional shortest path analysis.
SAP HANA Graph support for Cypher (actually openCypher) now includes undirected edges, limited length for paths, and the ability to filter all edges in a path. Reserved keywords are now included in the SAP HANA Graph reference guide.
GraphScript has been extended to provide a new operator providing neighborhood search as well as the following set operators: UNION, INTERSECT, EXCEPT.
There’s also a new algorithm to support one-to-one shortest path analysis. Previously all targets were returned in shortest path analysis for a given source. Now it’s possible to focus the analysis on a single target.
To see these new capabilities in action and get up to speed quickly we’ve added hands-on tutorials to the SAP HANA Academy.
Videos showing what’s new for graph processing with HANA 2 SPS 01 are:
Shortest Path – One to One
Enhancements to Pattern Matching with Cypher
Enhancements to GraphScript
XSA – Calc View Modeler – Shortest Path
XSA – Calc View Modeler – Pattern Matching with Cypher
XSA – GraphScript
For the bigger picture, the Graph playlist covers all aspects of SAP HANA Graph from introduction and getting started to creating a graph workspace to using both the graph viewer tool, SQL Script, and the graph node of the calculation view editor in SAP Web IDE for HANA.
If you’re interested to learn about what’s new with HANA 2 SPS 01 in general check out the following blog.
Happy graph processing with HANA!
The SAP HANA Academy provides free online video tutorials for the developers, consultants, partners and customers of SAP HANA.
Topics range from practical how-to instructions on administration, data loading and modeling, and integration with other SAP solutions, to more conceptual projects to help build out new solutions using mobile applications or predictive analysis.
For the full library, see SAP HANA Academy Library – by the SAP HANA Academy
For the full list of blogs, see Blog Posts – by the SAP HANA Academy