Skip to Content

Changes for page 5 Data Bases and SDMX

Last modified by Artur on 2025/09/10 11:19
From version 2.1
edited by Helena
on 2025/05/23 01:11
Change comment: There is no comment for this version
To version 1.2
edited by Artur
on 2025/05/20 14:28
Change comment: Update document after refactoring.

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.helena
1 +xwiki:XWiki.arturkryazhev
Content
... ... @@ -4,7 +4,8 @@
4 4  
5 5  == 5.1 Scope of this Chapter ==
6 6  
7 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_560921d6b5e976e3.png||data-xwiki-image-style-alignment="center" height="442" width="699"]]
7 +(% style="text-align: center;" %)
8 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_560921d6b5e976e3.png||height="442" width="699"]]
8 8  
9 9  == 5.2 Introduction ==
10 10  
... ... @@ -26,7 +26,8 @@
26 26  
27 27  Inside ConIstat, data are stored in a database using local structure metadata. A simplified snapshot of the database schema is provided in **Error! Reference source not found.**.
28 28  
29 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_511a92cc4b6c720d.png||data-xwiki-image-style-alignment="center" height="221" width="508"]]
30 +(% style="text-align: center;" %)
31 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_511a92cc4b6c720d.png||height="221" width="508"]]
30 30  
31 31  (% style="text-align: center;" %)
32 32  **{{id name="image_7"/}}Figure 7: Database schema for ConIstat**
... ... @@ -65,8 +65,7 @@
65 65  
66 66  **Um**: PE (index number - base 2000)
67 67  
68 -(% class="wikigeneratedid" id="HStart_Period:01_1990End_Period:08_2008" %)
69 -**Start_Period: 01_1990 End_Period: 08_2008**
70 +==== Start_Period: 01_1990 End_Period: 08_2008 ====
70 70  
71 71  The mapping process can be achieved by storing the resulting information in a special repository outside or inside the native database. In the case of the reported example it was chosen to use a repository inside the native database but without changing anything in the original tables. For this purpose, the following tables were added to the already existing schema:
72 72  
... ... @@ -75,7 +75,8 @@
75 75  
76 76  The table STS_METADATA represents the place where the mapping process stores the mapping information. In fact, it inherits the base structure from METADATA, and some fields were added in order to cover all the concepts expressed in the SDMX DSD. The resulting database schema after adding the new tables useful for the mapping process is shown in Figure 5.3.8.
77 77  
78 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_946fffda5f1e39f4.png||data-xwiki-image-style-alignment="center" height="623" width="579"]]
79 +(% style="text-align: center;" %)
80 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_946fffda5f1e39f4.png||height="623" width="579"]]
79 79  
80 80  **{{id name="image_5.3.8"/}}Figure 5.3.8: Database schema with additional tables for mapping**
81 81  
... ... @@ -162,7 +162,8 @@
162 162  * the application reads or writes a specific format of data (which could be a specific format of SDMX) which is pre or post processed by a transformation tool that transforms the input/output to the desired format
163 163  * the desired output format is read or written directly to/from the application
164 164  
165 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_c7e88a04d7c85a06.jpg||data-xwiki-image-style-alignment="center" height="212" width="655"]]
167 +(% style="text-align: center;" %)
168 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_c7e88a04d7c85a06.jpg||height="212" width="655"]]
166 166  
167 167  (% style="text-align: center;" %)
168 168  **{{id name="image_9"/}}Figure 9: External Transformation of SDMX Formats**
... ... @@ -192,7 +192,8 @@
192 192  
193 193  === 5.5.1 Schematic ===
194 194  
195 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_b8f2df37169beb6a.png||data-xwiki-image-style-alignment="center" height="297" width="657"]]
198 +(% style="text-align: center;" %)
199 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_b8f2df37169beb6a.png||height="297" width="657"]]
196 196  
197 197  (% style="text-align: center;" %)
198 198  **{{id name="image_10"/}}Figure 10: Reading and Writing SDMX Data**
... ... @@ -209,7 +209,8 @@
209 209  
210 210  The Data Structure Definition can be used to create a relational table structure in a database. The simplest type of structure is shown below:
211 211  
212 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_f884c2191e589a1f.jpg||data-xwiki-image-style-alignment="center" height="179" width="575"]]
216 +(% style="text-align: center;" %)
217 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_f884c2191e589a1f.jpg||height="179" width="575"]]
213 213  
214 214  (% style="text-align: center;" %)
215 215  **{{id name="image_11"/}}Figure 11: Schematic of a Database Schema Derived from a DSD**
... ... @@ -218,15 +218,19 @@
218 218  
219 219  The structural metadata from the ECB-EXR1 Data Structure Definition that is relevant to the database is shown below.
220 220  
221 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_44d1683c443fea76.png||data-xwiki-image-style-alignment="center" height="176" width="357"]]
226 +(% style="text-align: center;" %)
227 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_44d1683c443fea76.png||height="176" width="357"]]
222 222  
223 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_82cc6a2aeb7ef07a.png||data-xwiki-image-style-alignment="center" height="526" width="665"]]
229 +(% style="text-align: center;" %)
230 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_82cc6a2aeb7ef07a.png||height="526" width="665"]]
224 224  
225 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_8b3e6351a1864a96.png||data-xwiki-image-style-alignment="center" height="390" width="369"]]
232 +(% style="text-align: center;" %)
233 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_8b3e6351a1864a96.png||height="390" width="369"]]
226 226  
227 227  An example set of database tables from the ECB-EXR1 Data Structure Definition is shown below.
228 228  
229 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_bb92f342ba05b747.jpg||data-xwiki-image-style-alignment="center" height="251" width="576"]]
237 +(% style="text-align: center;" %)
238 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_bb92f342ba05b747.jpg||height="251" width="576"]]
230 230  
231 231  (% style="text-align: center;" %)
232 232  **{{id name="image_12"/}}Figure 12: Schematic of a Database Schema Derived from the ECB_EXR1 DSD**
... ... @@ -250,7 +250,8 @@
250 250  
251 251  A database can be made “SDMX Web Services enabled” in a similar way to the Data Reader and Data Writer described in Annex 4 – Data Reader and Data Writer Functions. This is shown schematically in the diagram below.
252 252  
253 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_3c55cbaa13d12a4b.png||data-xwiki-image-style-alignment="center" height="386" width="681"]]
262 +(% style="text-align: center;" %)
263 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_3c55cbaa13d12a4b.png||height="386" width="681"]]
254 254  
255 255  (% style="text-align: center;" %)
256 256  **{{id name="image_13"/}}Figure 13: SDMX Query Reader**