Developing a Business Application

An Applications application may be as complex as storing all the data and performing all the analysis required for a study, or as simple as running a single set of reports.

An application typically includes the following general steps, each of which requires a particular defined object type:

1. Make data available for processing by doing one or both of the following:
   • Load data from one or more external systems using Load Sets.
   • Use Programs to read data already stored in Oracle Life Sciences Data Hub.
2. Use Programs to transform the data in one or more steps.
3. Report and/or transport data out of Oracle LSH. Use Programs and Report Sets to generate reports. Use Data Marts to write data to files for transport out of Oracle LSH.

Use Tables to store data at each stage of processing in Oracle LSH.

You can use a Workflow to combine some or all of these steps into a single executable process as shown in Figure 1-2. See Predefined Object Types for a description of each of these object types.

Figure 1-2 Example of Data Flow in a Work Area

Description of "Figure 1-2 Example of Data Flow in a Work Area"

• Working in a Work Area
  As an Oracle Life Sciences Data Hub application developer, or Definer, you work in a Work Area, creating instances of all the object definitions—Tables, Programs, Load Sets, Report Sets, Workflows, Data Marts, and/or Business Areas—required by the application.
• Mapping Executables to Tables
  To promote the reusability of Programs and other executable object definitions, Oracle Life Sciences Data Hub requires adding a subcomponent called a Table Descriptor to definitions of executable objects for each Table instance the executable reads from or writes to.
• Example of a Business Application
  You have both a SAS and an Oracle system integrated with Oracle Life Sciences Data Hub, with demography and adverse events data for Study A in the SAS system and demography and adverse events data for Study B in the Oracle system.