Skip to Content
Last modified by Helena on 2025/09/10 11:19
From version 2.1
edited by Helena
on 2025/05/23 17:15
Change comment: There is no comment for this version
To version 6.1
edited by Artur
on 2025/07/14 10:19
Change comment: Imported from XAR

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.helena
1 +xwiki:XWiki.arturkryazhev
Tags
... ... @@ -1,0 +1,1 @@
1 +Category|Category scheme|Code|Currency|Data set|Data source|Dataflow|Dimension|Provision agreement|Statistical data and metadata exchange|Structural metadata
Content
... ... @@ -22,33 +22,31 @@
22 22  
23 23  === 15.2.2 SOAP ===
24 24  
25 -Using the SOAP query, one can query for a category by name, and request that only the matched items be returned. The sample file, ecb_query/ecb_exr_category_soap.xml demonstrates a query for category schemes where a category contains the text "Exchange rate" in its English name. Note that it also request that only matched items
25 +Using the SOAP query, one can query for a [[category>>doc:sdmx:Glossary.Category.WebHome]] by name, and request that only the matched items be returned. The sample file, ecb_query/ecb_exr_category_soap.xml demonstrates a query for [[category schemes>>doc:sdmx:Glossary.Category scheme.WebHome]] where a [[category>>doc:sdmx:Glossary.Category.WebHome]] contains the text "Exchange rate" in its English name. Note that it also request that only matched items and their children be returned. The result file for this query is ecb_query/ecb_exr_category_soap.xml. It can be seen from this result file that only the relevant [[categories>>doc:sdmx:Glossary.Category.WebHome]] are returned.
26 26  
27 -and their children be returned. The result file for this query is ecb_query/ecb_exr_category_soap.xml. It can be seen from this result file that only the relevant categories are returned.
28 -
29 29  == 15.3 Discovering Data Structures ==
30 30  
31 -After the user queried for categories, he can now examine these categories in order to determine how to proceed with the data discovery process. Suppose that upon examination the user decide that he actually wanted data for the effective exchange rate category (2018773.2018810.2018779.2018795). The user will want to find data flows which are categorised against this category.
29 +After the user queried for [[categories>>doc:sdmx:Glossary.Category.WebHome]], he can now examine these [[categories>>doc:sdmx:Glossary.Category.WebHome]] in order to determine how to proceed with the data discovery process. Suppose that upon examination the user decide that he actually wanted data for the effective exchange rate [[category>>doc:sdmx:Glossary.Category.WebHome]] (2018773.2018810.2018779.2018795). The user will want to find [[data flows>>doc:sdmx:Glossary.Dataflow.WebHome]] which are categorised against this [[category>>doc:sdmx:Glossary.Category.WebHome]].
32 32  
33 33  === 15.3.1 REST ===
34 34  
35 -In the REST syntax, the user will have to query for the category scheme in which the exchange rate is defined and request that categorisations and their references be returned. This query would be as follows:
33 +In the REST syntax, the user will have to query for the [[category scheme>>doc:sdmx:Glossary.Category scheme.WebHome]] in which the exchange rate is defined and request that categorisations and their references be returned. This query would be as follows:
36 36  
37 37  http:~/~/ws-entry-point/categoryscheme/ECB/SDW_ECONOMIC_CONCEPTS/1.0?references="parentan dsiblings"
38 38  
39 -Note the references parameter. It specifies parent (i.e. objects referencing the queried object) and siblings, objects referenced directly from the parent object. This will return categorisations which reference the categories of the queried category scheme and the objects which these categorisations categorise. The sample file, ecb_query/ecb_exr_dataflow_rest.xml shows the result of this query. Note that this assumes that there is only one data flow categorised against the one category. In reality, all categorisations and their objects for the entire category scheme would be returned.
37 +Note the references parameter. It specifies parent (i.e. objects referencing the queried object) and siblings, objects referenced directly from the parent object. This will return categorisations which reference the [[categories>>doc:sdmx:Glossary.Category.WebHome]] of the queried [[category scheme>>doc:sdmx:Glossary.Category scheme.WebHome]] and the objects which these categorisations categorise. The sample file, ecb_query/ecb_exr_dataflow_rest.xml shows the result of this query. Note that this assumes that there is only one [[data flow>>doc:sdmx:Glossary.Dataflow.WebHome]] categorised against the one [[category>>doc:sdmx:Glossary.Category.WebHome]]. In reality, all categorisations and their objects for the entire [[category scheme>>doc:sdmx:Glossary.Category scheme.WebHome]] would be returned.
40 40  
41 41  === 15.3.2 SOAP ===
42 42  
43 -The SOAP syntax is able to take a much more direct approach. It can query directly for categorisations which use the specific effective exchange rate category, and only categorisation which categorise data flows. Further, it can omit the actual categorisation from the results, leaving only the dataflow to be returned. The sample file, ecb_query\ecb_exr_dataflow_query.xml shows this sample query and ecb_query\ecb_exr_dataflow_soap.xml shows the result.
41 +The SOAP syntax is able to take a much more direct approach. It can query directly for categorisations which use the specific effective exchange rate [[category>>doc:sdmx:Glossary.Category.WebHome]], and only categorisation which categorise [[data flows>>doc:sdmx:Glossary.Dataflow.WebHome]]. Further, it can omit the actual categorisation from the results, leaving only the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] to be returned. The sample file, ecb_query\ecb_exr_dataflow_query.xml shows this sample query and ecb_query\ecb_exr_dataflow_soap.xml shows the result.
44 44  
45 45  == 15.4 Discovering Data ==
46 46  
47 -Now that the dataflow has been found for the effective exchange rate data, the actual data reported against this flow can be retrieved.
45 +Now that the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] has been found for the effective exchange rate data, the actual data reported against this flow can be retrieved.
48 48  
49 49  === 15.4.1 REST ===
50 50  
51 -In the REST syntax, the data query is very straight forward for querying for an entire data set for a give data flow, in this case the effective exchange rates flow (2034482):
49 +In the REST syntax, the data query is very straight forward for querying for an entire [[data set>>doc:sdmx:Glossary.Data set.WebHome]] for a give [[data flow>>doc:sdmx:Glossary.Dataflow.WebHome]], in this case the effective exchange rates flow (2034482):
52 52  
53 53  http:~/~/ws-entry-point/data/2034482
54 54  
... ... @@ -56,19 +56,19 @@
56 56  
57 57  === 15.4.2 SOAP ===
58 58  
59 -The query in the SOAP syntax is just as simple, as shown in ecb_query/ecb_exr_data_query.xml. The request is for structure specific data, but does not specify which dimension to orient the data on. The implication is that the data source will return the data oriented with the dimension it chooses at the observation level. In this case, it is the time dimension.
57 +The query in the SOAP syntax is just as simple, as shown in ecb_query/ecb_exr_data_query.xml. The request is for structure specific data, but does not specify which [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] to orient the data on. The implication is that the [[data source>>doc:sdmx:Glossary.Data source.WebHome]] will return the data oriented with the [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]] it chooses at the observation (% style="color:#e74c3c" %)level(%%). In this case, it is the time [[dimension>>doc:sdmx:Glossary.Dimension.WebHome]].
60 60  
61 61  The result for this query is the same as the REST and is shown in the sample file ecb_query\ecb_exr_data.xml.
62 62  
63 -Technically, the query for the dataflow was not actually necessary to discover the data using the SOAP query. It is possible to query for data directly by a category - with the result being any data in which the data set, the data structure, the data flow, or the provision agreement which is categorised against the referenced category.
61 +Technically, the query for the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]] was not actually necessary to discover the data using the SOAP query. It is possible to query for data directly by a [[category>>doc:sdmx:Glossary.Category.WebHome]] - with the result being any data in which the [[data set>>doc:sdmx:Glossary.Data set.WebHome]], the data structure, the [[data flow>>doc:sdmx:Glossary.Dataflow.WebHome]], or the [[provision agreement>>doc:sdmx:Glossary.Provision agreement.WebHome]] which is categorised against the referenced [[category>>doc:sdmx:Glossary.Category.WebHome]].
64 64  
65 65  == 15.5 Better Data Queries ==
66 66  
67 -The above example assumes a very simple scenario, where the data itself was not actually queried. In actuality, such a query may not be wise as the volume of data returned could be quite large. In a more realistic scenario, one might choose to first examine the data structure for the data flow in order to determine what data might be available. After the full data structure details are returned, one can examine the dimensionality of the data and even look at the available codes to do things such as search for exchange rates for only select currencies.
65 +The above example assumes a very simple scenario, where the data itself was not actually queried. In actuality, such a query may not be wise as the volume of data returned could be quite large. In a more realistic scenario, one might choose to first examine the data structure for the [[data flow>>doc:sdmx:Glossary.Dataflow.WebHome]] in order to determine what data might be available. After the full data structure details are returned, one can examine the dimensionality of the data and even look at the available [[codes>>doc:sdmx:Glossary.Code.WebHome]] to do things such as search for exchange rates for only select [[currencies>>doc:sdmx:Glossary.Currency.WebHome]].
68 68  
69 69  === 15.5.1 REST ===
70 70  
71 -To retrieve the full details of the data structure in REST based on the dataflow, one simply queries for the data flow and all descendant references:
69 +To retrieve the full details of the data structure in REST based on the [[dataflow>>doc:sdmx:Glossary.Dataflow.WebHome]], one simply queries for the [[data flow>>doc:sdmx:Glossary.Dataflow.WebHome]] and all descendant references:
72 72  
73 73  http:~/~/ws-entry-point/dataflow/ECB/2034482/1.0?references="descendants"
74 74  
... ... @@ -80,7 +80,7 @@
80 80  
81 81  == 15.6 Other Structural Metadata Query Features ==
82 82  
83 -There is a sample set included with this document that serve to highlight some of the more advanced mechanisms in the structural metadata queries. These sample files are as follows.
81 +There is a sample set included with this document that serve to highlight some of the more advanced mechanisms in the [[structural metadata>>doc:sdmx:Glossary.Structural metadata.WebHome]] queries. These sample files are as follows.
84 84  
85 85  Directory Name: query
86 86  
SUZ.Methodology.Code.MethodologyClass[0]
index
... ... @@ -1,1 +1,0 @@
1 -16
SKMS.Methodology.Code.MethodologyClass[0]
Index
... ... @@ -1,0 +1,1 @@
1 +16