Looking through SAP Hana Database
- Ang Yong Xiang Adwin
- Nov 4, 2018
- 2 min read
For our application we require a database so that we can have a place for storage of our data. So we considered Hana Database, and I have to go look through whether SAP Hana is feasible for us.
SAP HANA prevents the need for creating multiple database, which can occur when a business expands and there is a need to have different databases for different aspects in the business. However, the many databases can cause a problem as when the data collected increases to a massive scale, moving data around will cause massive load times.
SAP Hana database is a relational database management system. It combines OLAP and OLTP processing into a single in-memory database, eliminating disk bottlenecks and offering groundbreaking performance. This ACID-compliant, in-memory columnar database stores compressed data, offers parallel processing across multiprocessor cores, and supports single instruction multiple data (SIMD) commands.
SAP Hana database uses Row & Column Storage in order to store data which is similar to what we have learnt so far for MSSQL. WE can use SQL query in order to retrieve data from the database.
After doing some in-depth look into the feasibility, I can see that they support python and node js for connectivity to the trial version of Hana Database.
For the connection to work, there is a need to use their java sdk to open up a tunnel to connect to the HANA Database. However, this is not feasible for us, as we intend on putting our website live, therefore we will not be able to access the database.
Another problem would be that we will have to use JS or Python for server-side, however we will be using C# and therefore we may need to bridge Python and C# which we do not have any experience in. Learning how to may take a very long time which we lack.
Resources
Python Connection: https://blogs.sap.com/2018/07/19/exploring-data-science-with-python-and-sap-hana-cloud-platform/
Comments