Effektiv och underhållssäker lagring av medicinsk data
MysqlMongodbEavEntity attribute valueEffective databaseDatabasetestTesting databasesSQLNoSQLEffektiv databasDatabastestTesta databaserMysqlMongodbEav
Creating a database to manage medical data is not the easiest. We create a database to be used for a presentation tool that presents medical data about patients that is stored in the database. We examine which of the three databases, MySQL with relational design, MySQL with EAV design and MongoDB that are best suited for storing medical data. The analysis i performed in two steps. The first step handles the database that is most effective to retriev data. The second step examines how easy it is to change the structure of the various databases. The results show that depending on whether efficiency or maintenance is most important, different databases are the best choise. MySQL with relational design proves to be most effective while MongoDB is the easiest to maintain.