Clicking the sub menu QUERY BUILDER under the menu QUERY will lead you to the Query Builder page[Fig01].
While you are exploring or done with the query composition, you can also scroll down and save the constructed query[Fig03]. Be sure to sign up or sign in before saving a query. The Name and Description of the query are automatically generated for your convenience, and you can customize them as you want.
Clicking the "Save Query" button in Fig03 will lead you to the Query Manager page[Fig04], which allows you to keep track of saved queries and retrieve record information on the queries. You can also click the sub menu QUERY MANAGER under the menu QUERY or click the tab Query Manager to get to the Query Manager page[Fig04]. Clicking the name of a saved query (blue box) will link to the Query Builder page with query widgets automatically loaded for the saved query, where you can review and update query criteria.
There are two ways to explore graphical distribution of multiple datasets according to a single core term and any two core terms.
The first way is to view graphical distribution for a single core term across all the dataset variables mapping to it. Box plots are generated for numeric terms and bar plots for categorical terms. For example[Fig05], in the Query Builder page, clicking the core term "Body mass index" under the category "02 - Anthropometry" (blue arrow) will generate a query widget, where you can click the button "View Box Plots" (red circle) to view the box plots[Fig06] generated for each dataset variable mapping to the core term "Body mass index".
As shown in Fig06, there are four box plots corresponding to four variables in datasets SHHS and CHAT mapping to the core term "Body mass index". The summary statistics of these variables are also reported in the table below the box plots. Hovering over a box plot will show the summary statistics for the corresponding variable.
The second way is to view graphical distribution by choosing any two core terms. For example, clicking the sub menu GRAPHICAL EXPLORATION under the menu QUERY or clicking the tab Graphical Exploration will lead you to the Graphical Exploration page[Fig07]. You will need to choose one core term for X axis and another for Y axis (e.g., Race for X axis and Systolic blood pressure for Y axis in blue boxes). Box plots will be generated if a numeric core term is chosen for Y axis and bar plots will be given if a categorical core term is chosen for Y axis.
Clicking the button "Graph Distribution" (red circle in Fig07) will generate multiple graphs[Fig08]. Each graph in Fig08 is rendered for a variable in a dataset mapping to Y axis against a variable mapping to X axis in the same dataset. For example, the first graph in Fig08 shows the box plots for the baseline-visit variable "Average Systolic BP" in the dataset SHHS against the baseline-visit variable "Race" in SHHS. Here each box plot is rendered for the "Average Systolic BP" data under a specific option of "Race" (e.g., White, Black, or Other).
Clicking the sub menu CASE-CONTROL EXPLORATION under the menu QUERY or clicking the tab Case-Control Exploration will lead you to the Case-Control Exploration page[Fig09]. The workflow to explore case-control matching consists of five steps:
Fig11 shows an exmaple with all conditions in the above steps specified. For each numeric match term or numeric outcome term, users can configure bin size[Fig12] to control the rendering of the results. Then, you can choose exploration type[Fig09] to be "Cross Dataset" or "Within Dataset." Clicking the "Matching" button (in Fig09) will render the result in a multi-column table format[Fig12]. In addition, the matching result can be downloaded and saved as the Comma-Separated Values (CSV) format.
Clicking the "Save Exploration" button in Fig10 will lead you to the Case-Control Manager page[Fig13], which allows you to keep track of saved case-control explorations. You can also click the sub menu CASE-CONTROL MANAGER under the menu QUERY or click the tab Case-Control Manager to get to the Case-Control Manager page[Fig13]. Clicking the name of a saved case-control exploration (blue box) will link to the Case-Control Exploration page with the saved exploration automatically loaded, where you can review and update the exploration.
Ready to start building your own query or exploring graphs? Build Query Graphical Exploration