Skip to Content
Author's profile photo Philip MUGGLESTONE

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Talha Abdul
      Talha Abdul

      Hello

       

      Why query execution is slow in GraphScript compared to openCypher in SAP HANA Graph Engine ?

      Execution of simple Linear Search on approx. 10M edges took 20 to 30 seconds using GraphScript.

      Using openCypher it just took 980ms.

       

      Regards

      Talha Abdul

      Author's profile photo Philip MUGGLESTONE
      Philip MUGGLESTONE
      Blog Post Author

      Hi Tahla,

      Thanks for your feedback.

      openCypher is a declarative language with higher potential for query optimization compared to GraphScript which is an imperative language. However GraphScript supports more complex queries than openCypher including control flow logic.

      Therefore a good rule of thumb would be to reserve GraphScript for when you need to make more complex queries.

      Regards,

      Philip