-
Notifications
You must be signed in to change notification settings - Fork 0
Database Technology
Patrick Hoefner edited this page Dec 10, 2019
·
1 revision
Where data is stored?
- The patient data is stored on a centralised database-server
- every authorized device should be able to read from and to write on the database
- Because the data from biometrical devices must be collected 24/7, there is probably another device/storage necessary which is always connected with the biometrical devices and synchronized with the database-server
Requirements DBMS: DBMS should:
- be runnalble as a database server (e.g. on an raspbberry pi)
- support role/right management
- support access management (authentification System)
- API in JAVA or another language, where the team-Members have experience with
- support Data Mining Features
- secure the "availability" of the data on all devices, wich includes: "fast transactions" "quick synchronization", "be able to manage a ____ amount of data", "backup features"
Opportunities
- https://entwickler.de/online/datenbanken/grundkurs-datenbanken-datenbanksysteme-579859345.html
- https://db-engines.com/de/ranking
Comparison:
- https://opensource.com/article/19/1/open-source-databases
- https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems
If we agree on using a RaspberryPi as our very first server hardware, there are lots of tutorials how to install a webserver with PHP, Apache and MySQL (Popularity and ease of use, Speed, Licensing). As a webserver we could also use nginx.
- https://howtoraspberrypi.com/how-to-install-web-server-raspberry-pi-lamp/
- http://raspberrywebserver.com/sql-databases/using-mysql-on-a-raspberry-pi.html
- https://pimylifeup.com/raspberry-pi-mysql/
- https://www.intelligentes-haus.de/tutorials/smart-home-tutorials/installation-eines-raspberry-pi-mit-einem-webserver-inkl-php-mysql-ftp/
Alternative: (Open-source and community-driven, bad Memory performance, + Security, +Simple Setup)
- https://opensource.com/article/17/10/set-postgres-database-your-raspberry-pi
- https://manjaro.site/how-to-install-postgresql-on-raspberry-pi/
- https://bpwalters.com/blog/setting-up-postgresql-on-raspberry-pi/
MariaDB (Open-source, security features, very compatible with SQL, more performant with large databases)