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
0
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
0
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
- Analysis of Current SRM Practices: A Solutions Proposal
- Lectures on Quality Assurance during Model Creation
- Large-Scale Pattern-Based Information Extraction from the World Wide Web
- Adaptive and Reactive Rich Internet Applications
- Tractable Rules for Description Logics
- Final presentation "Linked Open Data Applications"
- Theorie und Anwendung von Topic-Specific Trust Open Rating Systems
- Bedarfsgetriebener Wissensaustausch in verteilten Teams
- "We are the Web: The future of the social machine" - Talk by Prof. Hendler
- Semantic Web Search – A Process-Oriented Perspective on Data Retrieval on the Semantic Web
- Interfaces for Personal Semantic Knowledge Management
- Karlsruhe Service Summer 2010
- Coalition-Flow Networks: Generalised Network Flows for Coalition Games
- Using Data Mining to Facilitate User Contributions in the Social Semantic Web
- Statistisches Maschinelles Lernen in Semantischen Graphen
- Recurrent neural networks - Information Processing and self-organization at the Edge of Chaos
- Adaptive Future Internet Applications
- Small is Again Beautiful in Description Logics
- Exploiting Social Semantics for Multilingual Information Retrieval
- Sprachübergreifender Wissenstransfer
- Mit Ontologien und Folksonomien Communities von Wissensarbeitern Unterstützen
- Ontologie-basierte Monosemierung
- Event Processing and Stream Reasoning with ETALIS
- Kollaborative Erstellung von (teil-)strukturierten Prozessbeschreibungen aus unstrukturiertem, informellem Prozesswissen
- Where event processing is going in 2020, and how it will make the world proactive?
- Ontologie-Alignment durch Biologisch-inspirierte Optimierungsverfahren
- Automatische und Semi-automatische Verfahren zur Unterstützung von Ontologieänderungen
- Uta Lösch
- Veli Bicer
- Search Relevance based on the Semantic Web
- A Tensor-Based Distributional Model of Semantics
- 28th AIK symposium "40 years Institute AIFB"
- Status und Methodik in der Entwicklung zuverlässiger Software
- Semantische Technologien für die Verarbeitung vernetzter Informationen mit Nutzungsbeschränkungen
- Effiziente und Effektive Verwaltung von Ereignismustern
- Design Principles of Advanced Task Elicitation Systems
- Invited talk about Linked Open Data and Wikidata as part of the lecture Knowlege Management (Rudi Studer)
- Julia Hoxha
- Effiziente Verarbeitung von unstrukturierten, strukturierten und hybriden Anfragen
- Ranking for Heterogeneous Web Data Search
- A Semantic Wiki-based Integration Platform for IT Service Management
- Effiziente klassifikationsbasierte Suche nach semantisch beschriebenen Diensten
- Discovery Informatics: Intelligent Systems to Accelerate Data Analysis in Science and Beyond
- Epistemic Reasoning in OWL 2 DL
- Cross-domain Recommendations based on semantically-enhanced User Web Behavior
- Instance Matching for Heterogeneous Structured Data
- Rank-aware, approximate query processing on the Semantic Web
- Roland Stühmer
- The Web: Wisdom of Crowds or Wisdom of a Few?
- Efficient Context-aware Real-time Processing of Personal Data Streams