Skip to content

Database Structure Pane

Jump to bottom
Michael Derntl edited this page Jan 8, 2019 · 10 revisions
Database Structure Pane

This pane contains two parts: a header and a tree representing the nested structure of entities in the database.

Header

The header displays the name of the logged in user and a link to log out of the tool. The header also contains a button labeled with the symbol ↻. It can be used to refresh the database. The empty space in the header may display some some status text when working with the tool, particularly when lengthy processing is taking place. Most of the time it should however remain empty.

Tree

The main portion of the pane is occupied by a tree-like display of the structure of entities in the database. The nesting of entity types in the tree reflects the actual nesting of entities in the database.

Example: in the screenshot, we see that there are 7 entities of type CONTINENT in the database at top level. As child entities of these top-level CONTINENT, there are 252 COUNTRY and 37 HERITAGE entities. The COUNTRY entities have a total of 4,426 CITY child entities and 1,055 HERITAGE child entities.

By clicking the Show Properties button next to the entity type labels, the list of properties of the entity type fades in. Each property is listed with its label (i.e. ID, Name, Geometry, etc. in the screenshot), its data type (e.g. Integer, Text, Geometry, etc.), and an icon symbol that represents its data type as follows:

  • Integer: ℤ
  • Number: ℝ
  • Percentage: %
  • Boolean: ☑
  • Text:
  • Date: ▣
  • Single Choice: ·
  • Multiple Choice: ⋮
  • Table: ⊞
  • Geometry: ⏢
  • Epoch: ⥈
  • Dimension: ⛶
  • List: ☰
  • Entity: ⍟

Some entity types may expose nested properties. These table properties (e.g. Ancestor Entities in the screenshot) have child properties, each reflecting a column of the table property.

The three columns Output, Filter, and Aggregate, display symbols for any row that is used in the Analysis Options, respectively.

Example: in the screenshot above, the analysis options specify to output a table (⊞) of CITY entities. There is one filter (⛛) on the property Name of ancestor CONTINENT entities. The result table of cities is grouped (☍) by values of property Timezone. The result table also includes a count of CITY entities (#), a list of entity Names (☷), and the sum of Population (∑) as aggregate properties.

The row in the tree above which the user hovers the mouse pointer is highlighted with yellow background.

Clone this wiki locally