dhw_self - Objects by schema

dbeaver

Description

contains some testing to prepare JSON files to be used in DBeaver for virtual PK and virtual references

development is on hold

dmdocs

Description

Objects

docs

Description

objects related to the Database documentation generator

Objects

graph

Description

contains graph tables: edge and node tables

property

Description

Inheritance or determination of extended properties for RepoObjects or RepoObject columns, based on references

Objects

reference

Description

Determination and management of references (dependencies) between RepoObjects or RepoObject columns

Objects

repo

Description

main schema containing objects and logic around RepoSchema, RepoObject, RepoObjectColumn

RepoObject

Central construct to represent objects (tables, views, procedures, functions, index, …​) and their subunits (columns, index columns, procedure parameters, …​), their properties and relationships between them.

Objects

sqlparse

Description

contains objects around SqlParser.py

The Python project sqlparse will be used, to extract column references from database views SQL code.

A Python script SqlParser.py was created.

  • to read sql_modules_definition

  • to write the parsed view definition back into the repository database

Objects

ssas

Description

Objects

ssis

Description

Objects

ssis_t

Description

Objects

sys_self

Description

this schema is not required when connecting the repository to a "normal" dwh database

  • it contains some views and procedures similar to objects in schema repo_sys to apply similar logic not to the dwh database but to the current database (self)

  • is is only used the repository database development

tool

Description

Tools that can also be used outside and independently of DataHandwerk

workflow

Description

A workflow executes procedures in a specific and necessary order

Objects