User`s guide

xiii
Preference Settings for Large Data Import . . . . . . . . . . . . . 5-19
Will All Data (Size n) Fit in a MATLAB Variable? . . . . . . . . 5-20
Will All of This Data Fit in the JVM Heap? . . . . . . . . . . . . 5-20
How Do I Perform Batching? . . . . . . . . . . . . . . . . . . . . . . . . 5-21
Displaying Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-23
How to Display Query Results . . . . . . . . . . . . . . . . . . . . . . 5-23
Displaying Data Relationally . . . . . . . . . . . . . . . . . . . . . . . . 5-23
Charting Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-27
Displaying Query Results in an HTML Report . . . . . . . . . . 5-29
Displaying Query Results with MATLAB Report Generator . 5-29
Fine-Tuning Queries Using Advanced Query Options . . . . 5-34
Retrieving All Occurrences vs. Unique Occurrences of Data . 5-34
Retrieving Data That Meets Specified Criteria . . . . . . . . . . 5-35
Grouping Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-38
Displaying Results in a Specified Order . . . . . . . . . . . . . . . 5-42
Using Having Clauses to Refine Group by Results . . . . . . . 5-45
Creating Subqueries for Values from Multiple Tables . . . . . 5-48
Creating Queries That Include Results from Multiple Tables 5-52
Additional Advanced Query Options . . . . . . . . . . . . . . . . . . 5-54
Retrieving BINARY and OTHER Data Types . . . . . . . . . . . . 5-55
Importing and Exporting Boolean Data . . . . . . . . . . . . . . . . 5-57
Import Boolean Data from Databases . . . . . . . . . . . . . . . . . 5-57
Exporting Boolean Data to Databases . . . . . . . . . . . . . . . . . 5-60
Saving Queries in Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-61
About Generated Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-61
VQB Query Elements in Generated Files . . . . . . . . . . . . . . 5-62
Saving Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-62
Running Saved Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-62
Editing Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-63
Using Database Toolbox Functions
6
Getting Started with Database Toolbox Functions . . . . . . . . 6-3