Introducing devonfw support for SAP HANA
What is devonfw?
devonfw is an open-source software reference architecture developed by the SAP partner Capgemini. It bundles standard open-source components such as Spring, Hibernate, Maven, QueryDSL, Flyway, Angular, and others to create a flexible, innovative, and high quality solution for writing applications.
There is also a demo application called My Thai Star that’s build on top of the framework to act as a best-practice guide and showcase the framework’s abilities. The scenario for the demo application is the web page of a Thai restaurant where customers can reserve tables, browse the menu, and order food.
Over the last year, a joint team of developers from Capgemini and SAP have worked to add support for SAP HANA as an additional database for devonfw. But since HANA isn’t just another database we didn’t stop at adding basic support to the framework itself.
Instead we thought of use-cases for the My Thai Star demo application that would fit nicely into the restaurant scenario and could showcase the power of SAP HANA as well as give developers best-practices for developing their own applications using the advanced features of the SAP HANA platform.
Prediction of future demand
One scenario that could be useful for restaurant managers is the prediction of the demand in the near future to allow for accurate planning of needed supplies.
The first use-case implemented for the My Thai Star demo application does just that. It provides a planning screen for restaurant managers on which they can see the historical order data as well as the predicted demand for the next week based on the historical data.
Restaurant managers can choose the period shown for the historical data to find past time periods similar to the one of interest for the prediction. On the prediction panel they can dynamically adjust factors like temperature and whether a day is a public holiday to improve the prediction accuracy.
The prediction itself is implemented using the SAP HANA Predictive Analysis Library which offers a wide variety of prediction algorithms which are executed directly in the database.
Geospatial analysis and clustering of customers
The second scenario we have implemented is getting insight into the geographical distribution of customers. This allows restaurant managers to see where their customers come from and help them plan promotions or increase advertising in certain areas.
The use-case implemented for the My Thai Star demo application displays clusters of customers for each dish offered on the menu. Restaurant managers can then use the visualized information to better target their customers.
The spatial clustering is implemented using the SAP HANA spatial engine which includes spatial clustering out-of-the-box.
How can I get started?
devonfw provides its own documentation including a guide on how to get started on HANA.