The present document is intended to set the basis for entity abstraction into the Analytics Module. This model creates an abstraction layer over our operational database hiding the details of our Postgres database schema implementation.

The direct queries are not for historical data, for that we need to convert them to a data warehouse.

To make a join of two or more direct queries in the Analytics Module, you can see the Showcase: Join Entities dashboard in your analytics instance by accessing it with admin privileges.

Entities

Each entity is a query that collects the most relevant properties from multiple tables into a single dataset that models a business object such as projects, threats, countermeasures, standards, etc… All entities of the system are available when selecting the Knowi Elastic Store data source when creating a new query. (There are also other datasets available belonging to the default dashboards).

An entity model is a set of concepts that describe the structure of data, regardless of its stored form. It models an entity-relationship schema at a business view level, which is an abstraction layer on top of our operational database to simplify the creation of join operations.

• Project Entity
• Component Entity
• Threat Entity
• Countermeasure Entity
• Standard Entity
• Threat Model Entity
• Component Questionnaire Entity