Open janbrogger opened 6 years ago
The current implementation of database export has identical tables in ctap/master and ctap/dev. The ctap/dev branch produces a separate database file for each feature group, whereas ctap/master produces just a single file.
The structure is: sqlite> .schema CREATE TABLE subject (subjectnr INTEGER PRIMARY KEY, subjectstr TEXT, sex TEXT, age REAL); CREATE TABLE measurement (measurement TEXT PRIMARY KEY, session TEXT, description TEXT); CREATE TABLE results (id INTEGER PRIMARY KEY AUTOINCREMENT, subjectnr INTEGER, measurement TEXT, channel TEXT, variable TEXT, value REAL, timestamp TEXT, duration REAL, latency REAL);
which already contains fields for subjects, measurements and results (feature values). Possible linking of these tables is left to the user.
To me the main issues are related to 'results' table:
Issue 1. needs to be resolved but the other two seem more like fine tuning to me.
Can anyone give examples about how large sqlite files are produced with the current setup?
Note also that base Matlab lacks tools to work with databases. To make fancy things we'd need decent tools to work with databases.
I am wondering whether it might be helpful to rewrite export_features_CTAP. There is no table for segments or patients or studies, which means that there is a lot of duplication and the results table becomes one "megatable". What do you think?
Feature request to export_features_CTAP: