Skip to Content

Changes for page 5 Data Bases and SDMX

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

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.arturkryazhev
1 +xwiki:XWiki.helena
Content
... ... @@ -4,8 +4,7 @@
4 4  
5 5  == 5.1 Scope of this Chapter ==
6 6  
7 -(% style="text-align: center;" %)
8 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_560921d6b5e976e3.png||height="442" width="699"]]
7 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_560921d6b5e976e3.png||data-xwiki-image-style-alignment="center" height="442" width="699"]]
9 9  
10 10  == 5.2 Introduction ==
11 11  
... ... @@ -27,8 +27,7 @@
27 27  
28 28  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.**.
29 29  
30 -(% style="text-align: center;" %)
31 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_511a92cc4b6c720d.png||height="221" width="508"]]
29 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_511a92cc4b6c720d.png||data-xwiki-image-style-alignment="center" height="221" width="508"]]
32 32  
33 33  (% style="text-align: center;" %)
34 34  **{{id name="image_7"/}}Figure 7: Database schema for ConIstat**
... ... @@ -67,7 +67,8 @@
67 67  
68 68  **Um**: PE (index number - base 2000)
69 69  
70 -==== Start_Period: 01_1990 End_Period: 08_2008 ====
68 +(% class="wikigeneratedid" id="HStart_Period:01_1990End_Period:08_2008" %)
69 +**Start_Period: 01_1990 End_Period: 08_2008**
71 71  
72 72  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:
73 73  
... ... @@ -76,8 +76,7 @@
76 76  
77 77  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.
78 78  
79 -(% style="text-align: center;" %)
80 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_946fffda5f1e39f4.png||height="623" width="579"]]
78 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_946fffda5f1e39f4.png||data-xwiki-image-style-alignment="center" height="623" width="579"]]
81 81  
82 82  **{{id name="image_5.3.8"/}}Figure 5.3.8: Database schema with additional tables for mapping**
83 83  
... ... @@ -164,8 +164,7 @@
164 164  * 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
165 165  * the desired output format is read or written directly to/from the application
166 166  
167 -(% style="text-align: center;" %)
168 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_c7e88a04d7c85a06.jpg||height="212" width="655"]]
165 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_c7e88a04d7c85a06.jpg||data-xwiki-image-style-alignment="center" height="212" width="655"]]
169 169  
170 170  (% style="text-align: center;" %)
171 171  **{{id name="image_9"/}}Figure 9: External Transformation of SDMX Formats**
... ... @@ -195,8 +195,7 @@
195 195  
196 196  === 5.5.1 Schematic ===
197 197  
198 -(% style="text-align: center;" %)
199 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_b8f2df37169beb6a.png||height="297" width="657"]]
195 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_b8f2df37169beb6a.png||data-xwiki-image-style-alignment="center" height="297" width="657"]]
200 200  
201 201  (% style="text-align: center;" %)
202 202  **{{id name="image_10"/}}Figure 10: Reading and Writing SDMX Data**
... ... @@ -213,8 +213,7 @@
213 213  
214 214  The Data Structure Definition can be used to create a relational table structure in a database. The simplest type of structure is shown below:
215 215  
216 -(% style="text-align: center;" %)
217 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_f884c2191e589a1f.jpg||height="179" width="575"]]
212 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_f884c2191e589a1f.jpg||data-xwiki-image-style-alignment="center" height="179" width="575"]]
218 218  
219 219  (% style="text-align: center;" %)
220 220  **{{id name="image_11"/}}Figure 11: Schematic of a Database Schema Derived from a DSD**
... ... @@ -223,19 +223,15 @@
223 223  
224 224  The structural metadata from the ECB-EXR1 Data Structure Definition that is relevant to the database is shown below.
225 225  
226 -(% style="text-align: center;" %)
227 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_44d1683c443fea76.png||height="176" width="357"]]
221 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_44d1683c443fea76.png||data-xwiki-image-style-alignment="center" height="176" width="357"]]
228 228  
229 -(% style="text-align: center;" %)
230 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_82cc6a2aeb7ef07a.png||height="526" width="665"]]
223 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_82cc6a2aeb7ef07a.png||data-xwiki-image-style-alignment="center" height="526" width="665"]]
231 231  
232 -(% style="text-align: center;" %)
233 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_8b3e6351a1864a96.png||height="390" width="369"]]
225 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_8b3e6351a1864a96.png||data-xwiki-image-style-alignment="center" height="390" width="369"]]
234 234  
235 235  An example set of database tables from the ECB-EXR1 Data Structure Definition is shown below.
236 236  
237 -(% style="text-align: center;" %)
238 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_bb92f342ba05b747.jpg||height="251" width="576"]]
229 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_bb92f342ba05b747.jpg||data-xwiki-image-style-alignment="center" height="251" width="576"]]
239 239  
240 240  (% style="text-align: center;" %)
241 241  **{{id name="image_12"/}}Figure 12: Schematic of a Database Schema Derived from the ECB_EXR1 DSD**
... ... @@ -259,8 +259,7 @@
259 259  
260 260  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.
261 261  
262 -(% style="text-align: center;" %)
263 -[[image:SDMX_2-1_User_Guide_draft_0-1_html_3c55cbaa13d12a4b.png||height="386" width="681"]]
253 +[[image:SDMX_2-1_User_Guide_draft_0-1_html_3c55cbaa13d12a4b.png||data-xwiki-image-style-alignment="center" height="386" width="681"]]
264 264  
265 265  (% style="text-align: center;" %)
266 266  **{{id name="image_13"/}}Figure 13: SDMX Query Reader**