... | ... | @@ -155,7 +155,7 @@ Level 4 is performed by the end-user based on the validation reports and execute |
|
|
|
|
|
- The voorpagina just contains information about how the valdiation was executed and with which data
|
|
|
|
|
|
<img src="uploads/85c546c8321d4ca7f7d4b9062f9b02b3/Screenshot_2022-08-22_at_10.44.07.png" width="30%" />
|
|
|
<img src="uploads/85c546c8321d4ca7f7d4b9062f9b02b3/Screenshot_2022-08-22_at_10.44.07.png" width="60%" />
|
|
|
|
|
|
- The resultaten tab contains a more comprehensive version of the results shown in the KIK-Starter
|
|
|
|
... | ... | @@ -207,4 +207,69 @@ Level 4 is performed by the end-user based on the validation reports and execute |
|
|
|
|
|
- Rules at the very bottom with 100% satisfaction and a positive number of activations are likely no issue.
|
|
|
|
|
|
# More about queries |
|
|
# Queries
|
|
|
|
|
|
- Upload data to KIK-Starter like in the first use scenario above or select an existing dataset
|
|
|
|
|
|
<img src="uploads/9e4c68a2e18f55b550b118d9a73b8b00/Screenshot_2022-08-22_at_10.31.15.png" width="40%" /><img src="uploads/389f40ada1a0e0cc60ec82a1753fb82a/Screenshot_2022-08-22_at_10.31.43.png" width="40%" />
|
|
|
|
|
|
- Select the desired uitwisselprofiel and query
|
|
|
|
|
|
<img src="uploads/26d4d278c449cfad803539ec827a47a6/Screenshot_2022-08-22_at_11.13.14.png" width="40%" /><img src="uploads/ba6c3da1e3a7b6fe05e035ec4b23ad43/Screenshot_2022-08-22_at_11.13.23.png" width="40%" />
|
|
|
|
|
|
- Select opvragen
|
|
|
|
|
|
<img src="uploads/be5894f4ca1124a4f455fbacdddd69b0/Screenshot_2022-08-22_at_11.13.32.png" width="40%" />
|
|
|
|
|
|
- KIK-Starter shows the result of the query.
|
|
|
|
|
|
<img src="uploads/c763614f8d71c7c6c6230bcd8b5398e4/Screenshot_2022-08-22_at_11.15.11.png" width="60%" />
|
|
|
|
|
|
- If a query contains more than 10 rows of results, a paginator at the bottom right allows scrolling between individual results
|
|
|
|
|
|
<img src="uploads/537f423456466984d3fb847c8b977d3b/Screenshot_2022-08-22_at_11.16.47.png" width="60%" />
|
|
|
|
|
|
- If a query yields no results, a warning to that effect is shown
|
|
|
|
|
|
<img src="uploads/34ae7195e24b5c41cd8307221a6b6cd3/Screenshot_2022-08-22_at_11.19.22.png" width="40%" />
|
|
|
|
|
|
- A successful query allows downloading an excel query report
|
|
|
|
|
|
<img src="uploads/87c5b5a1c067a1025769921ef12e89a4/Screenshot_2022-08-22_at_11.19.59.png" width="30%" />
|
|
|
|
|
|
## Query report
|
|
|
|
|
|
- The query report is a standard Excel file; here we'll use [this](uploads/e56bad8563aed760e154f3a9b00c3594/query.xlsx) as example (generated from the example file above)
|
|
|
|
|
|
- The report contains 2 tabs
|
|
|
|
|
|
<img src="uploads/ab5775cf2fb1ba05421c24bfb7718e01/Screenshot_2022-08-22_at_11.22.10.png" width="25%" />
|
|
|
|
|
|
- The voorpagina just contains information about how the valdiation was executed and with which data
|
|
|
|
|
|
<img src="uploads/72b45f10476f08494c7c024a43608047/Screenshot_2022-08-22_at_11.22.42.png" width="60%" />
|
|
|
|
|
|
- The resultaten tab contains a more comprehensive version of the results shown in the KIK-Starter
|
|
|
|
|
|
<img src="uploads/8f6c1f336267ed94d27bc8b259b7d3a0/Screenshot_2022-08-22_at_11.22.49.png" width="60%" />
|
|
|
|
|
|
# Data conversion
|
|
|
|
|
|
# Advanced query options
|
|
|
|
|
|
Depending on your user rule, you also have some more advanced options for querying
|
|
|
|
|
|
- It is possible to manually adjust a query using SPARQL
|
|
|
|
|
|
<img src="uploads/d77cb8ae29d2ebfb476f88de4221f06b/Screenshot_2022-08-22_at_11.24.34.png" width="40%" />
|
|
|
|
|
|
- KIK-Starter automatically converts a simple query (yielding a relational result, i.e., a SPARQL SELECT query) into a [map and reduce query](https://en.wikipedia.org/wiki/MapReduce). It is possible to manually adjust the map and reduce queries too
|
|
|
|
|
|
<img src="uploads/34d15ee7a0cb5ed770b7dd08a6daf627/Screenshot_2022-08-22_at_11.26.55.png" width="60%" />
|
|
|
|
|
|
- From a technical point of view, the result of the map query is uploaded to the KIK-Starter centraal and the reduce query is executed on the centraal to extract information when needed. This means that only the results of the query (in the sense of the map query) is uploaded, not the detailed data. Splitting the two allows doing more sophisticated aggregation at the central if needed.
|
|
|
|
|
|
- KIK-Starter retains a history over executed queries; selecting an entry from the history and clicking opvragen fetches the old result again (which is faster and reflects the data at the time of the original query)
|
|
|
|
|
|
<img src="uploads/05c620781ec99068683f779cf7719edc/Screenshot_2022-08-22_at_11.29.20.png" width="40%" />
|
|
|
|