iQ — Integrated Query Tool
Self-Service Query Tool Integrating All CODE Managed Data
CODE • Comprehensive Oncology Data & Engineering • Cancer Center Shared Resource
The iQ application enables self-service data requests. It understands the connections between data, the user's permissions to that data, and pathways that connect the information in the various HCI Comprehensive Oncology Data & Engineering (CODE) software applications. The tool helps users visualize those pathways to explore data repositories and find the data they need.
Using iQ, researchers can create queries that span and bring together data from multiple systems and databases. Users can query for most data fields available from CORE, CCR, and RSR (including custom data elements), as well as the HCI Tumor Registry and Molecular Profiling.
Users can keep custom developed queries private or make them available to team members when a query might be useful to others. The iQ tool applies row level security and scrubbing at runtime based on the permissions of the user running the query, not the person who developed it.
Researchers can export query results from iQ in PDF, HTML, CSV, and Excel formats for further analysis.
The iQ tool works with the complex permissions models of the systems with which it interfaces to provide or restrict access to data as appropriate. It filters query results at the individual row and column level and scrubs them according to the user's permissions for that data.
Key Capabilities
CUSTOM QUERYING A powerful query tool developed by HCI Comprehensive Oncology Data & Engineering (CODE) Shared Resource that allows authorized users to create their own queries of data managed by HCI CODE applications.
INTELLIGENT INTEGRATION The tool understands connections between data, the user's permissions for that data, and pathways that connect the information in the various HCI CODE applications.
DATA SOURCES Fully integrated with multiple HCI applications and databases (CCR, RSR, Tumor Registry, Molecular Profiling, and CORE) for access to critical data from research and clinical systems.
REPORTING Provides reporting capabilities for many HCI CODE applications, including CCR, RSR, and CORE.
SECURITY Keeps research data secure and HIPAA compliant. Query results are filtered at the row and column level and scrubbed according to the user's permissions for that data.
iQ Features
iQ is a powerful and flexible query tool that allows authorized users to report on the data managed by HCI's research applications.
CUSTOM QUERIES — The iQ tool facilitates self-service data requests. It understands the connections between data and users' permissions to that data. It also includes pathways that connect information from various systems, and it helps users visualize those pathways to explore data repositories and find the data they need.
DATA INTEGRATION — User-created queries can span and bring together data from multiple systems and databases. Users can query for most data fields that are available in CORE, CCR, RSR (including any custom data elements), the HCI Tumor Registry, and Molecular Profiling.
SHARED QUERIES — Users can keep custom queries private or make them available to team members when a query might be useful to others. Row level security and scrubbing are applied at runtime based on the permissions of the user running the query, not the person who developed it.
RESULTS EXPORT — Researchers can export query results from iQ in PDF, HTML, CSV, or Excel formats for further analysis.
ACCESS CONTROL — The iQ tool works with the complex permissions models of each application with which it interfaces to provide or restrict access to data as appropriate.
Interfaces
The iQ tool interfaces with the following applications and databases: CORE, CCR, RSR, Molecular Profiling, and the HCI Tumor Registry.
Requirements
- Google Chrome (latest)
- Microsoft Edge (latest)
Services Available
- Training
- Technical Support
- Application Configuration
- Application Development
- Query and Report Generation
- Natural Language Processing
CODE • Comprehensive Oncology Data & EngineeringCancer Center Shared Resource
