Internal IBM Worklight Database Tables

IBM Worklight v5.0.5 > WL server administration
Internal IBM Worklight Database Tables

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. 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.

Common IBM Worklight WLREPORT database tables...

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 WL 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 WL server administration

+
Search Tips | Advanced Search

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. 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.

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 WL 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.