Data Stores - Revision history

Vmurrell at 11:36, 3 November 2025

2025-11-03T11:36:49Z

2025-01-16T09:24:47Z

‎Registry Managed Data Store

2025-01-14T13:23:54Z

2023-09-04T14:58:13Z

2023-03-10T18:07:51Z

‎Dataflow, DSD and other related structures:

2023-03-10T18:01:51Z

‎Dataflow, DSD and other related structures:

2023-03-10T17:58:48Z

‎Example Using Oracle

2023-03-10T17:57:56Z

‎Example Using Oracle

2023-03-10T17:57:39Z

‎Example Using Oracle

2023-03-10T17:56:09Z

‎Example Using Oracle

@@ Line 6: / Line 6: @@
 == Registry Managed Data Store ==
-A Registry Managed Data Store is one which the Registry maintains.  This means as data is published to the Fusion Registry, the Registry wil write the data to the store and manage the transaction. Registry managed data stores come in two flavours, a relational database (MySQL or SQL Server) store, or a Fusion Store which has been custom built by Metadata Technology for rapid storage and dissemination of data.
+A Registry Managed Data Store is one which the Registry maintains.  This means as data is published to the Fusion Registry, the Registry will write the data to the store and manage the transaction. Registry managed data stores come in two flavours, a relational database (MySQL or SQL Server) store, or a Fusion Store which has been custom built by Metadata Technology for rapid storage and dissemination of data.
 === Fusion Data Store ===

@@ Line 176: / Line 176: @@
 | FR_UPDATED_DATE || datetime || Optional  || to support the updatedAfter query parameter
 |}
 == Custom Table and Column Names ==

@@ Line 291: / Line 291: @@
 INSERT INTO WB_WDI_ECON_POL_DEBT_1_0_OBS (FR_KEY_ID, FR_OBS_DATE, TIME_PERIOD, OBS_VALUE, UNIT_MULT) values ('A:AG_AGR_TRAC_NO:AFG', '01-JAN-1952', '1952', '11952.999', 'C'
 </pre>
 ====Dataflow, DSD and other related structures:====
-The following file contains the structures required by this demo. It includes:
+The following file ( [[File:ExampleStructures.zip|thumb|Structures For Oracle]] ) contains the structures required by this demo. It includes:
 * The Data Structure: '''WB:WDI(1.0)'''
 * The Dataflow: '''WB:WDI_ECON_POL_DEBT(1.0)'''
 * The Provision Agreement: '''WB:WB_WDI_ECON_POL_DEBT(1.0)'''
 * Supporting structures such as Codelists and Concept Schemes

← Older revision		Revision as of 18:01, 10 March 2023
Line 293:		Line 293:

	====Dataflow, DSD and other related structures:====		====Dataflow, DSD and other related structures:====
		+	The following file contains the structures required by this demo. It includes:
		+	* The Data Structure: '''WB:WDI(1.0)'''
		+	* The Dataflow: '''WB:WDI_ECON_POL_DEBT(1.0)'''
		+	* The Provision Agreement: '''WB:WB_WDI_ECON_POL_DEBT(1.0)'''
		+	* Supporting structures such as Codelists and Concept Schemes

@@ Line 233: / Line 233: @@
 ==Example Using Oracle==
-The following is a quick example showing how to set up 2 externally managed tables when using the Oracle Database and connect them to the Fusion Registry.  The steps to follow are:
+The following is a short example demonstrating how to use Oracle and set up 2 externally managed tables and connect them to the Fusion Registry, allowing the Registry to disseminate data.
 # Using the database tools of your choice, create the Key Table and Obs Table and populate both with data
 # Load the structures (attached below) into your Fusion Registry

@@ Line 241: / Line 241: @@
 #* If everything has gone correctly, then the table will show 3 Series (and an unknown amount of Observations)
 # The data can now be queried from the Registry using the appropriate Web Service and the dataflow '''"WDI_ECON_POL_DEBT"'''.  E.g.:
 http://localhost:8080/FusionRegistry/sdmx/v2/data/dataflow/WB/WDI_ECON_POL_DEBT/1.0/?format=sdmx-compact-2.1

@@ Line 237: / Line 237: @@
 # Load the structures (attached below) into your Fusion Registry
 # Navigate to the Data Sources Manager page and:
-## Set up an Oracle Connection where the Connection Type is '''"Externally Managed"''' and the Database Platform is '''"Oracle"'''
+#* Set up an Oracle Connection where the Connection Type is '''"Externally Managed"''' and the Database Platform is '''"Oracle"'''
-## Select this Oracle data source in the table and click the cogs at top-right. Select '''"Link Provision Agreement"''' and select the Provision Agreement '''"WB_WDI_ECON_POL_DEBT"'''
+#* Select this Oracle data source in the table and click the cogs at top-right. Select '''"Link Provision Agreement"''' and select the Provision Agreement '''"WB_WDI_ECON_POL_DEBT"'''
-### If everything has gone correctly, then the table will show 3 Series (and an unknown amount of Observations)
+#* If everything has gone correctly, then the table will show 3 Series (and an unknown amount of Observations)
-* The data can now be queried from the Registry using the appropriate Web Service and the dataflow "WDI_ECON_POL_DEBT".  E.g.:
+# The data can now be queried from the Registry using the appropriate Web Service and the dataflow '''"WDI_ECON_POL_DEBT"'''.  E.g.:
 http://localhost:8080/FusionRegistry/sdmx/v2/data/dataflow/WB/WDI_ECON_POL_DEBT/1.0/?format=sdmx-compact-2.1