ID Out #1 Out #2 Name Arguments Mode Units In Units Out Ratio
0 1 - SolutionInjection solutions=[{}] - 0 1 0.00
1 2 - HashIndexBuild solutionSet=solutionSet1
joinVars=[]
sourceType=pipeline
- 1 1 1.00
2 3 - PipelineJoin pattern=distinct(?_internalVar3, owl:sameAs, <http://publications.europa.eu/resource/celex/31971L0317>)
joinType=join
joinProjectionVars=[?_internalVar3]
- 1 1 1.00
3 4 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_implements_directive>, ?_internalVar3)
joinType=join
joinProjectionVars=[?cellar_id, ?_internalVar3]
- 1 40 40.00
4 5 - PipelineJoin pattern=distinct(?exp, <http://publications.europa.eu/ontology/cdm#expression_belongs_to_work>, ?cellar_id)
joinType=join
joinProjectionVars=[?exp, ?cellar_id]
- 40 39 0.97
5 6 - PipelineJoin pattern=distinct(?exp, <http://publications.europa.eu/ontology/cdm#expression_title>, ?title)
joinType=join
joinProjectionVars=[?exp, ?title]
- 39 39 1.00
6 7 - PipelineJoin pattern=distinct(?exp, <http://publications.europa.eu/ontology/cdm#expression_uses_language>, ?expr_language)
joinType=join
joinProjectionVars=[?exp, ?expr_language]
- 39 39 1.00
7 8 - HashIndexBuild solutionSet=solutionSet15
joinVars=[?exp]
sourceType=pipeline
- 39 39 1.00
8 9 - PipelineJoin pattern=distinct(?manif, <http://publications.europa.eu/ontology/cdm#manifestation_manifests_expression>, ?exp)
joinType=join
joinProjectionVars=[?manif, ?exp]
- 39 0 0.00
9 10 - PipelineJoin pattern=distinct(?manif, <http://publications.europa.eu/ontology/cdm#manifestation_type>, ?type)
joinType=join
joinProjectionVars=[?manif, ?type]
- 0 0 0.00
10 11 - HashIndexJoin solutionSet=solutionSet15
joinType=optional
- 0 39 0.00
11 12 - HashIndexBuild solutionSet=solutionSet14
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
12 13 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_implemented_by_country>, ?country)
joinType=join
joinProjectionVars=[?cellar_id, ?country]
- 39 39 1.00
13 14 - HashIndexJoin solutionSet=solutionSet14
joinType=optional
- 39 39 1.00
14 15 - HashIndexBuild solutionSet=solutionSet12
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
15 16 - PipelineJoin pattern=distinct(?s, owl:annotatedSource, ?cellar_id)
joinType=join
joinProjectionVars=[?s, ?cellar_id]
- 39 696 17.85
16 17 - PipelineJoin pattern=distinct(?s, owl:annotatedProperty, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_implements_directive>)
joinType=join
joinProjectionVars=[?s]
- 696 487 0.70
17 18 - PipelineJoin pattern=distinct(?s, <http://publications.europa.eu/ontology/annotation#transposition_deadline_transmitted>, ?transposition_deadline_transmitted)
joinType=join
joinProjectionVars=[?s, ?transposition_deadline_transmitted]
- 487 413 0.85
18 19 - PipelineJoin pattern=distinct(?s, owl:annotatedTarget, ?_internalVar2)
joinType=join
joinProjectionVars=[?s, ?_internalVar2]
- 413 376 0.91
19 20 - PipelineJoin pattern=distinct(?_internalVar2, owl:sameAs, <http://publications.europa.eu/resource/celex/31971L0317>)
joinType=join
joinProjectionVars=[?_internalVar2]
- 376 29 0.08
20 21 - HashIndexBuild solutionSet=solutionSet13
joinVars=[?s]
sourceType=pipeline
- 29 29 1.00
21 22 - PipelineJoin pattern=distinct(?s, <http://publications.europa.eu/ontology/annotation#transposition_notification>, ?date_notification)
joinType=join
joinProjectionVars=[?s, ?date_notification]
- 29 23 0.79
22 23 - HashIndexJoin solutionSet=solutionSet13
joinType=optional
- 23 29 1.26
23 24 - HashIndexJoin solutionSet=solutionSet12
joinType=optional
- 29 39 1.34
24 25 - Filter condition=BIND(IF(bound(?transposition_deadline_transmitted), ?transposition_deadline_transmitted, "1001-01-01"^^xsd:string) AS ?_internalVar1) - 39 39 1.00
25 26 - TermResolution vars=[?_internalVar1] value2id 39 39 1.00
26 27 - VariableAlignment sourceVar=?_internalVar1
targetVar=?transposition_deadline
- 39 39 1.00
27 28 - HashIndexBuild solutionSet=solutionSet11
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
28 29 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_declaration_transposition_member-state>, ?transposition_status)
joinType=join
joinProjectionVars=[?cellar_id, ?transposition_status]
- 39 0 0.00
29 30 - HashIndexJoin solutionSet=solutionSet11
joinType=optional
- 0 39 0.00
30 31 - HashIndexBuild solutionSet=solutionSet10
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
31 32 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_name_official_journal>, ?oj_name)
joinType=join
joinProjectionVars=[?cellar_id, ?oj_name]
- 39 38 0.97
32 33 - HashIndexJoin solutionSet=solutionSet10
joinType=optional
- 38 39 1.03
33 34 - HashIndexBuild solutionSet=solutionSet9
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
34 35 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_number_official_journal>, ?oj_number)
joinType=join
joinProjectionVars=[?cellar_id, ?oj_number]
- 39 27 0.69
35 36 - HashIndexJoin solutionSet=solutionSet9
joinType=optional
- 27 39 1.44
36 37 - HashIndexBuild solutionSet=solutionSet8
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
37 38 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_date_official_journal>, ?oj_date)
joinType=join
joinProjectionVars=[?cellar_id, ?oj_date]
- 39 29 0.74
38 39 - HashIndexJoin solutionSet=solutionSet8
joinType=optional
- 29 39 1.34
39 40 - HashIndexBuild solutionSet=solutionSet7
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
40 41 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_page_official_journal>, ?oj_page)
joinType=join
joinProjectionVars=[?cellar_id, ?oj_page]
- 39 6 0.15
41 42 - HashIndexJoin solutionSet=solutionSet7
joinType=optional
- 6 39 6.50
42 43 - HashIndexBuild solutionSet=solutionSet6
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
43 44 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#resource_legal_date_entry-into-force>, ?entry_into_force)
joinType=join
joinProjectionVars=[?cellar_id, ?entry_into_force]
- 39 17 0.44
44 45 - HashIndexJoin solutionSet=solutionSet6
joinType=optional
- 17 39 2.29
45 46 - HashIndexBuild solutionSet=solutionSet5
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
46 47 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_reference_commission>, ?reference_commission)
joinType=join
joinProjectionVars=[?cellar_id, ?reference_commission]
- 39 26 0.67
47 48 - HashIndexJoin solutionSet=solutionSet5
joinType=optional
- 26 39 1.50
48 49 - HashIndexBuild solutionSet=solutionSet4
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
49 50 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#measure_national_implementing_national_website_link>, ?website)
joinType=join
joinProjectionVars=[?cellar_id, ?website]
- 39 0 0.00
50 51 - HashIndexJoin solutionSet=solutionSet4
joinType=optional
- 0 39 0.00
51 52 - HashIndexBuild solutionSet=solutionSet3
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
52 53 - PipelineJoin pattern=distinct(?cellar_id, cdm:eli, ?eli)
joinType=join
joinProjectionVars=[?cellar_id, ?eli]
- 39 0 0.00
53 54 - HashIndexJoin solutionSet=solutionSet3
joinType=optional
- 0 39 0.00
54 55 - HashIndexBuild solutionSet=solutionSet2
joinVars=[?cellar_id]
sourceType=pipeline
- 39 39 1.00
55 56 - PipelineJoin pattern=distinct(?cellar_id, <http://publications.europa.eu/ontology/cdm#work_date_document>, ?work_date_document)
joinType=join
joinProjectionVars=[?cellar_id, ?work_date_document]
- 39 39 1.00
56 57 - HashIndexJoin solutionSet=solutionSet2
joinType=optional
- 39 39 1.00
57 58 - Distinct vars=[?country, ?cellar_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, ?type] - 39 39 1.00
58 59 - Projection vars=[?country, ?cellar_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, ?type] retain 39 39 1.00
59 60 - HashIndexJoin solutionSet=solutionSet1
joinType=join
- 39 39 1.00
60 61 - PipelineJoin pattern=distinct(?cellar_id, owl:sameAs, ?nim_id)
joinType=join
joinProjectionVars=[?cellar_id, ?nim_id]
constraints=[REGEX(str(?nim_id), "resource/nim"^^xsd:string)]
- 39 691 17.72
61 62 63 ConditionalRouting condition=needsMaterialization(REGEX(str(?nim_id), "resource/nim"^^xsd:string)) - 691 691 1.00
62 63 - TermResolution vars=[?nim_id] id2value 691 691 1.00
63 64 - Filter condition=REGEX(str(?nim_id), "resource/nim"^^xsd:string) - 691 39 0.06
64 65 - TermResolution vars=[?type] id2value 39 39 1.00
65 66 - Aggregate groupBy=[?country, ?nim_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli]
aggregates=[?country, ?nim_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, BIND(GROUP_CONCAT(DISTINCT ?type; separator=", ") AS ?types)]
- 39 39 1.00
66 67 - TermResolution vars=[?country, ?nim_id] id2value 39 39 1.00
67 68 - Sort sortOrder=[ASC(?country), ASC(?nim_id)] - 39 39 1.00
68 69 - Distinct vars=[?country, ?nim_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, ?types] - 39 39 1.00
69 70 - Projection vars=[?country, ?nim_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, ?types] retain 39 39 1.00
70 - - TermResolution vars=[?country, ?nim_id, ?work_date_document, ?transposition_deadline, ?transposition_status, ?oj_name, ?oj_number, ?oj_date, ?oj_page, ?expr_language, ?title, ?entry_into_force, ?reference_commission, ?date_notification, ?website, ?eli, ?types] id2value 39 39 1.00