Skip to content

SQLAdmin Inventory

Jump to bottom
Niels Grove-Rasmussen edited this page Apr 2, 2017 · 1 revision

Conceptual Data Model

The data model has these conceptual entities:

  • Server
  • SQL Server Database Engine (SSDB)
  • SQL Server Integration Services (SSIS)
  • SQL Server Master Data Services (MDS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)

Other entities like SQL Server Data Quality Services (DQS) can be added when needed.

Logical Data Model

These entities are in the logical data model:

  • Computer
  • Database Engine instance
    • Database with associated entities like Filegroup, File and Database Role
  • Integration Services installation
    • Catalog
    • Project
  • Master Data Services installation
    • Master Data Manager
    • Model
  • Analysis Services instance
    • Database
  • Reporting Services installation
    • Folder
    • Data Source
    • Report
  • Collation
  • Edition
  • Version

The logical data model usually has these organizational entities

  • Environment
  • Zone
  • Landscape
  • Security Classification
  • Risk Classification
  • Department or other organizational unit

Physical Data Model

Data objects (tables) are placed in the schema "sqladmin" together with basic input and output procedures. Data load is done with stored procedures in the schema "sqladmin". Access to the required procedures is granted by the database role "sqladmin_load", that is granted execute right on the required procedures. Access to the data from other tools like SQLAnchor is through dedicated procedures placed in dedicated schema. Procedures for SQLAnchor are placed in the schema "sqlanchor".

Implemented Data Model

(TBD)

Clone this wiki locally