14.6. Dashboard Builder Data Model

The following image illustrates the Dashboard Builder data model:

dashbuilder db schema
Note

Dashboard Builder data model stores only metadata, not actual runtime data.

Table 14.1. Dashboard Builder Data Model

TableAttributesDescription

dashb_data_source

dbid, ds_type, name, jndi_path, ds_url, jdbc_driver_class, user_name, passwd, test_query

Stores data source instances, either JNDI or JDBC.

dashb_data_source_table

dbid, name, data_source, selected

Currently not used. Stores a set of tables available for a given data source.

dashb_data_source_column

dbid, name, sql_type, data_source, table_name, primary_key, identity1

Currently not used. Stores a set of columns within a table.

dashb_permission

id_permission, principal_class, principal_name, permission_class, permission_resource, permission_action, permission_readonly

Stores permissions for different user interface resources (workspaces, pages, panels, and graphic resources).

dashb_graphic_resource

dbid, workspace_id, section_id, panel_id, id, resource_type, zip, status, last_modified

Stores graphic resource definitions (envelopes, layouts, and skins).

dashb_workspace

id_workspace, look, envelope, url, default_workspace, home_search_mode

Stores workspace instances.

dashb_workspace_home

id_workspace, id_role, id_section

Stores a home page for each role.

dashb_workspace_parameter

id_workspace, id_parameter, language, value

Stores workspace-related parameters.

dashb_allowed_panel

id_workspace, id_panel_provider

Stores a set of panel types a workspace can use.

dashb_section

dbid, id_section, id_workspace, id_template, position, visible, region_spacing, panel_spacing, id_parent, url, skin, envelope

Refers to the dashb_workspace table.

dashb_section_i18n

id_section, language, title

Stores information for internationalization and localization.

dashb_panel_instance

dbid, id_instance, id_workspace, provider, serialization

Stores reusable panel instances. It is not tied to any specific page.

dashb_panel

dbid, id_panel, id_instance, id_section, id_region, position

Stores page panels. Refers to the dashb_panel_instance and dashb_section tables. It is tied to a particular page and layout region.

dashb_panel_parameter

dbid, id_parameter, id_instance, value, language

Stores page panels and is tied to a particular page and layout region.

dashb_panel_html

dbid, id_instance

Stores an HTML panel definition.

dashb_panel_html_i18n

id_text, language, html_text

Stores information for internationalization and localization.

dashb_data_provider

id, code, provider_uid, provider_xml, data_properties_xml, can_edit, can_edit_properties, can_delete

Stores data provider definitions (SQL and CSV).

dashb_data_provider_i18n

id_data_provider, language, description

Stores information for internationalization and localization.

dashb_kpi

id, id_data_provider, code, displayer_uid, displayer_xml

Stores all types of KPI definitions (pie, bar, line, and table).

dashb_kpi_i18n

id_kpi, language, description

Stores information for internationalization and localization.

dashb_installed_module

name, version

Stores installed or imported modules used for automatic importing of assets.

dashb_cluster_node

id_node, node_address, startup_time, node_status

Stores running nodes and is needed for cluster setups.