1 Explore Oracle Health Real-World Data

You can use Oracle Life Sciences AI Data Platform (LSAIDP) to query Oracle Health Real-World Data (RWD).

Start your workflow in LSAIDP Workbench when you need governed Master Catalog discovery, workspace context, notebook-based SQL, compute clusters, collaboration, or managed/external table and volume workflows. Access to RWD depends on your organization's configuration, Oracle Cloud Infrastructure (OCI) Identify and Access Management (IAM) access, and Workbench Role Based Access Control (RBAC) permissions.

  • Access Workbench
    Use Workbench first when you need governed Master Catalog discovery, workspace context, notebook-based SQL, compute clusters, collaboration, or managed/external table and volume workflows. Access to data depends on your organization's configuration, OCI IAM access, and Workbench RBAC permissions.
  • Locate Real-World Data in Workbench
    Use the Workbench Master Catalog to locate authorized Oracle Health Real-World Data (RWD) assets and review metadata before analysis.
  • Query SQL in Workbench
    Use Workbench notebooks for governed SQL exploration when your organization has configured notebook SQL access. Depending on configuration, you can use SQL cells or SQL in Python through Spark. Exact catalog names, schema names, table names, and data reference steps can vary.
  • Sign in to Database Actions
    Depending on how your organization has set up authentication, you can sign in to Database Actions by connecting to a single, default database or you can use a schema alias to connect to multiple databases. Sign in to Database Actions to view the data catalog and run queries.
  • Access the SQL Worksheet
    Use the SQL page in Database Actions to write and run SQL queries, then create database objects based on Real-World Data.
  • Use the SQL Worksheet
    Use the SQL page to interact with your database. You can create queries, and add or edit data. You can use SQL and PL/SQL statements in the worksheet to create tables, insert data, and select data from a table.
  • SQL Worksheet Guidelines
    Adhering to operational standards ensures that your queries align with system performance, data security, and query efficiency. Consider the following guidelines when you use SQL Worksheet to develop SQL queries for an Autonomous Database Warehouse (ADW) instance.
  • Locate the Oracle Health Real-World Dataset
    Each version of Oracle Health Real-World Data is stored in its own schema. Use the navigator to select the schema.
  • Run Queries on Oracle Health Real-World Data
    You can use the code editor on the SQL page to create and run SQL statements, PL/SQL scripts, and JavaScript code on the Oracle Health Real-World Data that your organization has access to.
  • Create New Datasets
    Real-World Data and Reference Dataset schema are read-only.
  • Load New Data
    If your organization has permission to do so, you can use the Data Load page in Database Actions to make that data available to your instance of Autonomous Database.
  • Connect Using JDBC
    You can use Java Database Connectivity (JDBC) to connect your data.
  • Connect Using an Autonomous Database Wallet
    Instead of using JDBC, you can use an ADW wallet to connect to other tools.
  • Download an Autonomous Database Wallet
    A wallet is a secure container that stores authentication credentials, such as secure socket layer certificates and keys for a secure connection to an Oracle database.
  • Save Customer-Provided Data and Derived Outputs
    When Workbench notebooks write CSV or similar file outputs with Spark, the output directory usually contains part files instead of one CSV file. Store these outputs in an approved destination according to how the output will be reused.
  • Make Data Available in Oracle Analytics Cloud
    Your Oracle Analytics Cloud (OAC) administrator can create a default connection to a shared ADW reporting schema (such as DW_CUST_REPORT), in Autonomous Data Warehouse (ADW).