shows any GUIDs that have been promoted from pseudo-GUIDS. For example: "NDARUV811UZG“ used to be "NDAR_INVKL165TGF“, and can still be found in earlier data under that pseudo-GUID. The Parent is the ‘real’ GUID, whereas the child is the pseudo-GUID – there may be multiple pseudo-GUIDs associated with a single ‘real’ GUID. Resolved subject identifiers?
summary of the metadata associated with a given imaging session, including: subjectkey, interview_age, image_scanner_manufacturer, image_category, image_dimensions, image_subtype, image_tr, image_te, and image_flip_angle
use SQL Developer for this interface, but other options include Toad and DBVis. MySQL can be accessed from R, Perl, Java, SAS, SPSS, Matlab / Octave, or whatever language / analytical tools you wish to use.
SELECT * FROM <table_name> WHERE <column_name> = <something>; Tables contain columns, which contain values Columns can be one of a number of different data types. NDAR contains timestamps, floats, integers and strings.
the number of records SELECT COUNT(subjectkey) FROM fMRIwithADI.image03; If you want to count by a certain criteria, use GROUP BY SELECT COUNT(subjectkey), interview_age FROM fMRIwithADI.image03 GROUP BY interview_age;
count of records by age from the image03 structure. ORDER BY interview_age descending (largest first). SELECT COUNT(subjectkey), interview_age FROM fMRIwithADI.image03 GROUP BY interview_age ORDER BY interview_age DESC;
finds the maximum value MIN() – finds the minimum value AVG() – finds the mean Mode -- does not really exist in MySQL, but you can do something like this: SELECT COUNT(*) as total, interview_age FROM fMRIwithADI.image03 GROUP BY INTERVIEW_AGE ORDER BY total DESC – puts the largest value first LIMIT 1 – returns only the first result
shows records that are in one table, but not in another table. SELECT subjectkey, interview_age FROM fMRIwithADI.genomics_subject02; MINUS SELECT subjectkey, interview_age FROM fMRIwithADI.genomics_sample03;
using views CREATE VIEW fMRIwithADI.SUBJECTS AS SELECT image03.subjectkey, image03.interview_age FROM fMRIwithADI.image03 INNER JOIN fMRIwithADI.ndar_subject01 ON image03.subjectkey = ndar_subject01.subjectkey;