Page added by Alex Rudyy

There are several ways to implement database structure for storing configuration objects.
In this page we would like to analyze all the alternatives and identify what would be the best option for the database structure to store configurable objects

Existing database schema.

Unable to render embedded object: File (old-design.png) not found.

Existing database schema contains 10 tables to store the following:

current schema version (VERSION table)
exchanges (EXCHANGES table)
queues (QUEUES table)
queue bindings (QUEUE_BINDINGS table)
queue messages (DELIVERIES table)
messages (MESSAGE_META_DATA and MESSAGE_CONTENT tables)
federation links (LINKS table)
federation bridges (BRIDGES table)
distributed transactions (XIDS table)

In order to store the entire broker configuration with such schema more tables are actually needs to be created for storing configuration entities like broker, virtual hosts etc.

That's seems impractical and require extra development efforts to implement functionality for each configurable object.

Database schema with storing relationship in the tables

variant 1) table per relationship

Unable to render embedded object: File (new-design-version-1.png) not found.

With this design configurable objects (broker, virtual hosts, queues, queue bindings, exchanges, exchange bindings etc) can be stored in CONFIGURATION table.

Each configurable object should have a unique ID and all its attributes are stored in attributes column as BLOB.
One-to-many relationship are stored using PARENT_ID column.
For storing many-to-many relationships (like queue bindings, exchange bindings etc) special tables are created for each of the relationship.

On the design above QUEUE_BINDINGS table is added to store queue bindings and QUEUE_ALTERNATE_EXCHANGES is added to store queue alternate exchanges

variant 2) single table for storing all relationship

Unable to render embedded object: File (new-design-version-2.png) not found.

With this design configurable objects (broker, virtual hosts, queues, queue bindings, exchanges, exchange bindings etc) can be stored in CONFIGURATION table.

Each configurable object have a unique ID and all its attributes are stored in attributes column as BLOB.
One-to-many relationship are stored using PARENT_ID column.
All many-to-many relationships (like queue bindings, exchange bindings etc) are stored in the special ASSOCIATIONS table.

ASSOCIATION_TYPE column is used to distinguish the association type.

Database schema with storing relationship in JSON format

Unable to render embedded object: File (new-design-version-3.png) not found.

With this design configurable objects are stored in CONFIGURATION table.
All relationship (one-to-many, many-to-many) are stored in attributes field in JSON format as IDs.

Change Notification Preferences

View Online | Add Comment

--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]

[CONF] Apache Qpid > Database schema for storing of Unified Configuration

Database schema for storing of Unified Configuration