I am currently migrating our currently test data that is stored in excel files to a database. Because the type of data in the test results are going to grow we decided to go with nosql instead of sql.
I was planning on using a document database to store the data in but realized I'm not entirely sure how to store the data for it to be efficiently read.
The idea is that you have unique keys that help you find the data you are looking for quicker.
The data columns in the excel are:
- Model of device
- Version of software
- Type of test
- A bunch of other columns that include the test data (% of something, Count of something, etc...)
So these are the columns and there are multiple rows of his kind of data.
Would a nested document be used here?
i.e. [Type of test] -> [Date] -> [Model of device] -> [Version of software] -> [Bunch of test data]
Am I even using the right database type?