Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Veranstaltung]] [[Forschungsgruppe::Web Science]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t8.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t8 ON t0.smw_id=t8.s_id
WHERE
(t2.o_id='176110'
AND (t4.p_id='176129' AND t4.o_id='176417')
)
AND (t8.p_id='176155')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t8.o_sortkey ASC
LIMIT
55
OFFSET
50
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t8.o_sortkey
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_time` AS t8 ON t0.smw_id=t8.s_id
WHERE
(t2.o_id='176110'
AND (t4.p_id='176129' AND t4.o_id='176417')
)
AND (t8.p_id='176155')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t8.o_sortkey ASC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 216 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 13 | kit_smw1.t2.s_id,const,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t2.s_id | 1 | Using where |
1 | SIMPLE | t8 | ref | s_id,p_id,p_id_2,s_id_2 | s_id_2 | 8 | kit_smw1.t2.s_id,const | 1 | Using index |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
None
Conferences and Workshops
- Challenges for Consuming and Mining Linked Data
- Challenges for Consuming and Mining Linked Data
- Benedikt Kämpgen
- Integration von multidimensionalen Datensätzen aus dem Web für analytische Abfragen
- Identification of Emerging Scientific Topics in Bibliometric Databases
- User Interfaces to Semantic Knowledge Bases based on Natural Language Generation and Semantic Wikis
- Internet of Everything
- Semantische Konfiguration von AAL-Umgebungen
- 30th AIK symposium "Semantik in Big Data"
- Design and Application of Quantified Self Approaches to Support Reflective Learning
- Data-driven Business as a Cognitive Computing Challenge
- SPARQL1.1 Updates and Entailment - Why the specification is silent about their interaction
- Dynamic Interaction and Manipulation of Web Resources
- Ontology Design Patterns for Large-Scale Data Interchange and Discovery
- Making Authorship and Social Interactions Transparent in Collaboratively Written and Revisioned Text – The Use Case of Wikipedia
- Gravitation and Fitness in Ontology Dynamics
- Understanding sequential user behavior on the web
- Methodik und Tools zur Entwicklung verteilter Echtzeit-Verarbeitungspipelines
- Linked Data Entity Summarization
- Validation Framework for RDF-based Constraint Languages
- Query Processing over Graph-based Data on the Web
- Intellectual Capital: Software innovation and its role in national economies
- Semantic Annotation and Search: Bridging the Gap between Text, Knowledge and Language
- From Data Modeling to Knowledge Engineering in Space System Design
- Cross-lingual Monitoring of Events
- Semantic Search for Novcel Information
- Artificial Intelligence: A tale of two Worlds at Nuance
- 33rd AIK symposium "Von Wissensmanagement zu Web Science"
- Research and innovation at EMCL – Engineering Mathematics and Computing Lab/ Towards Cognition-Guided Patient-Specific Numerical Simulation for Surgery Assistance
- 9th Conference Professional Knowledge Management (WM2017)
- Semantic Similarity Measures and their Impact on Data-Driven Tasks over Knowledge Graphs
- Decentralized Control in Distributed Applications via Web and Semantic Web Technologies
- Decision-Making with Multi-Step Expert Advice on the Web
- Multi-view Representation Learning for Unifying Languages, Knowledge and Vision
- Specifying and Monitoring Behaviour on the Linked Data Web
- Situationsbewusstes Complex Event Processing auf Basis von Partial Pattern Fulfillment
- Ontology Engineering at Scale for Open City Data Sharing
- Multi-modal Data Fusion based on Latent Representations
- Kontextspezifische Interpretation von heterogenen Umweltbeobachtungen durch Ausnutzung von Linked Open Data
- Conceptualization of an Agent Framework for Heterogeneous Domain Specific Tasks
- Learning Latent Features using Stochastic Neural Networks on Graph Structured Data
- Automating Industrial Event Stream Analytics: Methods, Models, and Tools
- Managing Stream Processing Pipelines in Heterogeneous Fog Infrastructures
- Decentralized Query Processing over Heterogeneous Sources of Knowledge Graphs
- Human-Understandable Explanations for Neural Networks
- Guided automated machine learning system
- Data Mining and Information Extraction Methods for Large-Scale High-Quality Representations of Scientific Publications
- Methods for Strengthening Explainable AI in Industrial Applications
- Document Image Dewarping and Illumination Correction using Reference Templates