1. Developing SOA Applications with Oracle SOA Suite
  2. Understanding Sensor Public Views and the Sensor Actions XSD
  3. Sensor Public Views
  4. Schema

Schema

The database publisher persists the sensor data in a predefined relational schema in the database. The following public views can be used from a client (Oracle Warehouse, portals, and so on) to query the sensor values using SQL.

Note:

In Table D-1 through Table D-4, the Indexed or Unique? column provides unique index names and the order of the attributes. For example, U1,2 means that the attribute is the second one in a unique index named U1. PK means primary key.