About Tables

The tables that store data in the Oracle Life Sciences Data Hub are Oracle tables with additional metadata developed especially for Oracle LSH.

The tables that store data in the Oracle Life Sciences Data Hub (Oracle LSH) are Oracle tables with additional metadata developed especially for Oracle LSH. Oracle LSH database tables are designed to hold data that originated in either a SAS or an Oracle system, or both. They are designed so that computer programs based on either Oracle or SAS technology can read from or write to any Oracle LSH table. Oracle LSH tables have the following special characteristics:

• Both Oracle and SAS Metadata Attributes. Oracle LSH database tables have Oracle and SAS names and a SAS label at both the table/data set and column/variable levels.
• Blinding Attributes. Oracle LSH tables have special attributes for use in maintaining securely blinded clinical data. See Managing Blinded Data for further information.
• Data Processing Attribute. Oracle LSH tables have a special attribute whose value determines how the system processes data written to each table. Most methods of data processing result in an audit trail of all data changes within the table. See Data Processing Types.

• Table Definitions and Instances
  You must create both a Table definition and a Table instance, and install the instance in the database.
• Reading from and Writing to Tables
  There are several types of objects that can read data from and/or write data to an Oracle Life Sciences Data Hub Table instance, as follows.
• Creating Tables
  As you develop applications in Oracle Life Sciences Data Hub, you can create Oracle LSH Tables in the following ways.
• Columns
  Table Columns are instances of Variables, as are Parameters.
• Reports on Table Definitions and Instances
  From the Actions drop-down list, you can generate reports that provide information on a Table definition or instance.