Skip to content

Databases

Jump to bottom
samatrhea edited this page Aug 27, 2024 · 4 revisions

Databases

The CDP4-COMET server makes use of a relational database management system called PostgreSQL. All the data is stored in 3 dedicated databases in a PostgreSQL cluster. Below you can find a description of each of these databases.

CDP4Manage

  • Used as an anchor database to initially create a CDP4-COMET Server database.
  • It is there as "proof" that a database is setup correctly so it can create a CDP4-COMET database.

CDP4Server

  • The database that contains all the data of a CDP4-COMET database server including site data, model data and reference data.

CDP4Restore

  • A database that is created and filled with data when data has been seeded to the CDP4-COMET Server using an Annex C3 file. this file is sent to the server using the following route: http://cdp4services-test.cdp4.org/Data/Exchange. This can only be done when this feature is enabled. Use the following command to seed a server from a file: curl --form file=@"Data.zip" http://cdp4services-test.cdp4.org/Data/Exchange
  • The CDP4-COMET Server database can be restored to the state it was in when the CDP4Restore database was changed last using a specific route in the COMET WebService. Send an empty

copyright @ Starion Group S.A.

Introduction

  1. Introduction
  2. REST API - ICD

Deployment

  1. Configuration
  2. Docker
  3. Ubuntu
  4. Windows Server 2019
  5. PostgreSQL Tuning
  6. Restore default admin password
  7. Upgrade

Architecture

  1. Overview
  2. CDP4-SDK
  3. CDP4-ORM
  4. Authentication and Authorization
  5. Cyclic Cycles
  6. Migrations

Database Structure

  1. Databases
  2. Schemas
  3. Tables
  4. Triggers
  5. Functions
  6. Views

Integration Test

  1. Integration Test Suite

Build and Release

  1. Build
  2. Dockerize

Roadmap

  1. Roadmap
Clone this wiki locally