App Architecture

Database Tables

All Dataplane Reports app data is stored within application-specific tables in the Jira database.

Permanent Tables

Dataplane Reports uses ActiveObjects-based tables to store permanent data related to saved reports and app configuration. ActiveObjects is an Atlassian framework technology enabling third-party apps to store proprietary object data in Atlassian products.

All Dataplane Reports ActiveObjects tables in the Jira database begin with prefix AO_6714C7_.

Jira automatically includes all ActiveObjects tables when performing a Backup system operation via Jira Administration, and when restoring that data via a Restore system operation.

Data stored within these tables must be preserved for correct product operation.

The following tables in the Jira database are used to store Dataplane Reports' permanent data:

AO_6714C7_CUSTOMIZER_GROUP
AO_6714C7_CUSTOMIZER_SCRIPT
AO_6714C7_DASHBOARD_PROPERTIES
AO_6714C7_GLOBAL_CONFIG
AO_6714C7_PERMITTED_GROUP
AO_6714C7_RECENT_REPORT_RECORD
AO_6714C7_REPORTCOLLECTION
AO_6714C7_REPORTCOLLECTIONLINK
AO_6714C7_REPORT_SCHEDULE
AO_6714C7_REPORT_SUBSCRIBER
AO_6714C7_SAVED_REPORT_PERM
AO_6714C7_SAVED_REPORT_RECORD

Ephemeral Tables

Dataplane Reports maintains a real-time index of Jira issue change history in ephemeral—or non-permanent—database tables, using data schema optimized for efficient reporting. These app-specific tables are stored in the same database as Jira itself, so no additional database setup is required.

Although these tables are required to generate reports, they contain data that always exists separately in Jira's own project and issue database tables, thus Dataplane Reports can recreate the entire contents of these ephemeral app tables at any time using the "Build Index" function on the Dataplane Reports > Administration > Configuration page.

All Dataplane Reports ephemeral tables in the Jira database begin with the prefix art.

Jira does not include these ephemeral tables when performing a Backup system operation via Jira Administration. Therefore, after a Jira Administration Restore system operation, you must rebuild the Dataplane Reports index to regenerate the app’s ephemeral tables.

Dataplane Reports creates the following tables in the Jira database for ephemeral data:

artdate
arthash
artrid
artstate
artstatecf
artstatecfdata
artstatecfid
artstatemap
artstateprocessed
artstateproperty
arttdbl
arttdt
arttm

In multi-node Jira Data Center instances, Dataplane Reports creates these additional tables in the Jira database for ephemeral data:

artcluster
artelection
arthistevent
artidxevent

Page Contents

1 Database Tables
- 1.1 Permanent Tables
- 1.2 Ephemeral Tables