Internal IBM Worklight Database Tables

You can access a database of common tables from the IBM Worklight Server. The database must not be written to, and it might change from one release to another.

The following table provides a list of common IBM Worklight database tables, their description, and how they are used.

Name Description Order of Magnitude
ADAPTER_SYNC_DATA Replication across cluster nodes table for adapters. 10s of rows.
APP_ACTIVITY_REPORT Statistics for application activity. Records a record per server accessing user. Size depends on Application. Customer is responsible for purging older entries after aggregating to Data Warehouse
APP_SYNC_DATA Replication across cluster nodes table for applications. 10s of rows.
APP_VERSION_ACCESS_DATA Exceptions on App availability used for the Deny App feature 10s of rows.
AUTH_ASSOCIATED_IDENTITY Association between the user IDs in different realms. Out of the box associations are not defined. This feature may be enabled using code. If configured, will contain a single row per user.
BACKEND_SUBSCRIPTIONS Obsolete. Exists in pre v5.0 versions. Definitions of the cached data: procedures and parameter values -
CLUSTER_SYNC Cluster synchronization time 10s of rows
GADGET_APPLICATIONS Environments (for example, iPhone, Android) of deployed applications. References the GADGETS table. 10s of rows
GADGET_USER_PREF User preferences according to unique user identifier. Out of the box, there are no user preferences – preferences may be added by App developer. 1 row per preference, per user.
GADGETS Deployed applications 10s of rows
NOTIFICATION_APPLICATION Push notification table 10s of rows
NOTIFICATION_DEVICE Push notification table. Stores a record per device, per user subscription. Many to one relationship with NOTIFICATION_USER table. 1 row per device subscribing to event source
NOTIFICATION_MEDIATOR Push notification table Less than 10 rows
NOTIFICATION_USER Push notification table. Stores a record per user subscription to event sources 1 row per user subscribing to an event
PROPERTIES N/A 10s of rows
USAGE_DATA Usage report 1 row per active user per day.

The following table provides a list of common IBM Worklight WLREPORT database tables and their usage.

Name Description Order of Magnitude
ACTIVITIES_CUBE A materialized table of the 4 dimensional data cube. Populated every night based on the last 30 days of data. Can be used by BIRT or other reporting tools. Size depends on app and device usage, but is limited to last 30 days for faster access to the last 30 days of activities.
FACT_ACTIVITIES Summarization of activities used for device analytics. Updated by Worklight Server every 20 minutes with data from APP_ACTIVITY_REPORT table. Primarily used by BIRT reports and by other reporting tools. Size depends on app/device usage.
NOTIFICATION_ACTIVITIES Summarization of activities used for notification analytics. Updated with data from NOTIFICATION_REPORT table. Primarily used by BIRT reports and by other reporting tools. Size depends on app/notification usage.
PROC_REPORT Internal table used for housekeeping and maintaining the state of the scheduler tasks. About 72 rows per day.


Parent topic IBM Worklight Server administration