Explanation of Registry Tables - Revision history

Plazarou at 09:13, 25 April 2024

2024-04-25T09:13:40Z

Vmurrell at 15:56, 10 September 2023

2023-09-10T15:56:55Z

Plazarou at 09:52, 25 August 2022

2022-08-25T09:52:35Z

Plazarou at 09:51, 25 August 2022

2022-08-25T09:51:57Z

Plazarou: Created page with " The following lists some of the tables that the Registry creates with a description of the tables purpose. '''Note:''' the database tables are primarily used for persistence..."

2022-08-25T09:51:34Z

Created page with " The following lists some of the tables that the Registry creates with a description of the tables purpose. '''Note:''' the database tables are primarily used for persistence..."

New page

The following lists some of the tables that the Registry creates with a description of the tables purpose.

'''Note:''' the database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables unless explicitly instructed to do so.

==== Structural Metadata Persistence ====
{| class="wikitable"
!|Table Name
!| Description
|-
|registry_maintainables
|A list of all the maintainables in the Registry.
|-
|registry_maintainable_sdmx
|Each maintainable in the Registry stored in its SDMX form.
|-
|registry_maintainable_ser
|Each maintainable in the Registry stored as a Java serialised object. This is used for performance purposes as de-serialising a serialised object is faster than recreating it from its SDMX form.
|}

==== Transactional Information ====
{| class="wikitable"
!|Table Name
!| Description
|-
|tx_backup
|Stores the transaction number for each individual structure submission / modification. Note a single transaction can be for multiple metadata structures
|-
|sdmx_transaction
|Stores information about each transaction, such as the user who performed it, the date and event type (Replace, Delete, etc)
|-
|sdmx_transaction_item
|Links the URN of a individual structural metadata to a transaction number.
|-
|sdmx_backup
|Stores a binary image of the transaction in gzipped format of the XML
|}

==== Registry Settings ====
{| class="wikitable"
!|Table Name
!| Description
|-
|registry_settings
|Persists most of the registry settings in a key / value format where the column "name" identifies the setting and the column "value" its value.
|-
|registry_settings_dv
|Persists the data validation settings of the Registry
|-
|registry_settings_ser
|Serialised Registry settings. This is used for when the the setting to be stored cannot be described as a string in the registry_settings table and its serialised form needs to be persisted.
|}

@@ Line 2: / Line 2: @@
 The following lists ''some'' of the tables that the Registry creates, along with a description of the tables' purpose.
-'''Important Notes:''' The database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables '''unless explicitly instructed to do so'''.
+'''Important Notes:''' The database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Regnology does not recommend modifying database tables '''unless explicitly instructed to do so'''.
 ==== Structural Metadata Persistence ====

← Older revision		Revision as of 15:56, 10 September 2023
Line 1:		Line 1:
−		+	[[Category:How_To]]
	The following lists ''some'' of the tables that the Registry creates, along with a description of the tables' purpose.		The following lists ''some'' of the tables that the Registry creates, along with a description of the tables' purpose.

@@ Line 2: / Line 2: @@
 The following lists ''some'' of the tables that the Registry creates, along with a description of the tables' purpose.
-'''Note:''' the database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables unless explicitly instructed to do so.
+'''Important Notes:''' The database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables '''unless explicitly instructed to do so'''.
 ==== Structural Metadata Persistence ====

← Older revision		Revision as of 09:51, 25 August 2022
Line 1:		Line 1:

−	The following lists some of the tables that the Registry creates with a description of the tables purpose.	+	The following lists ''some'' of the tables that the Registry creates, along with a description of the tables' purpose.

	'''Note:''' the database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables unless explicitly instructed to do so.		'''Note:''' the database tables are primarily used for persistence of Registry information. Do not expect modifying database values to have any effect on a running Registry. Metadata Technology does not recommend modifying database tables unless explicitly instructed to do so.