Usage of Databases to Manage Multidimensional Data Effectively in Biomedical Engineering Laboratories
Data that can be plotted across multiple dimensions of attributes are most often managed using spreadsheet programs, which is both error prone and time inefficient. In comparison, databases are highly scalable and effective solutions, but the perspective and skill sets necessary to implement systems for custom needs are often lacking in biomedical engineering laboratories. In this work, we illustrate the usage of common software in Matlab and Microsoft Access to create a data pipeline to convert raw data into structured formats then aggregate the data in a variety of ways using queries in a database. Methods and visuals for our specific context as well as generalized recommendations are included to provide others with a framework to construct their own custom data pipeline and databases. We also discovered a novel relationship within our own data set using the elucidated methods.