Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Category:Data mining and learning analytics tools]] [[Analysis orientation::General analysis]]
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=4339
AND (
(t4.o_hash='General analysis') AND t4.p_id=4318)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort 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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=4339
AND (
(t4.o_hash='General analysis') AND t4.p_id=4318)
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | index_merge | s_id, p_id, s_id_2, o_hash | o_hash,p_id | 258,262 | 1 | Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort | ||
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 9 | mediawiki_135.t4.s_id, const | 1 | Using index | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | mediawiki_135.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneDM and LA tools | license | Tool type | Data manipulation | Access | Page edition |
---|---|---|---|---|---|
RapidMiner Server 6 (2013-11-24)
|
Commercial&Closed source | http://rapidminer.com/products-2/rapidminer-server/ | 26 February 2014 | ||
RapidMiner Studio 5.3.015 (2014-02-26)
|
Commercial&Open source | Framework/Library/API | Data extraction, Data transformation, Data analysis, Data visualisation, Data conversion, Data cleaning | http://sourceforge.net/projects/rapidminer/#resources | 10 November 2014 |
Free&Open source | Web application | Data extraction, Data analysis, Data visualisation | https://redash.io/ | 27 November 2017 | |
SATO (2014-09-10)
|
Free&Closed source | Web application | http://www.ling.uqam.ca/sato/ | 18 November 2014 | |
SQ-ALL 1 (2015-08-10)
|
Free&Closed source | Web application | Data extraction, Data transformation, Data analysis, Data conversion, Data cleaning | http://sqall.co | 17 August 2015 |
Scrapy 0.22.2 (2014-02-14)
|
Free&Open source | http://scrapy.org/ | 26 February 2014 | ||
Semilar alpha
|
Free&Closed source | Application software | Data analysis | http://www.semanticsimilarity.org/ | 19 March 2014 |
Framework/Library/API | Data analysis | http://nlp.stanford.edu/software/index.shtml | 8 October 2014 | ||
TOko 0.0.27 (2007-10-28)
|
Free&Open source | Application software | Data analysis | http://www.toko-sigmund.org/ | 22 September 2014 |
Free&Closed source | Application software | Data visualisation, Data extraction | http://www.tableausoftware.com/public/ | 27 June 2014 | |
Tabula 0.9.3 (2014-01-18)
|
Free&Open source | Application software | Data extraction | http://tabula.nerdpower.org/ | 21 March 2014 |
Tangara 1.4.50 (2013-12-18)
|
Free&Open source | Application software | Data extraction, Data transformation, Data analysis, Data visualisation, Data conversion, Data cleaning | http://eric.univ-lyon2.fr/~ricco/tanagra/index.html | 14 October 2014 |
Taporware 2.0 (2007-05-01)
|
Free&Closed source | Web application | Data extraction, Data analysis, Data visualisation, Data conversion | http://taporware.ualberta.ca/ | 18 March 2014 |
Free&Open source | Application software | Data extraction, Data analysis | http://neon.niederlandistik.fu-berlin.de/en/textstat/ | 30 November 2014 | |
Free&Closed source | Web application | Data analysis | http://textalyser.net/ | 30 November 2014 | |
Tm 0.5-10 (2014-01-13)
|
Free&Open source | Plugin/extension pack | Data extraction, Data transformation, Data analysis, Data visualisation | http://tm.r-forge.r-project.org/ | 24 March 2014 |
Tropes 8.4.2 (2014-02-18)
|
Free&Closed source | Application software | Data analysis, Data visualisation | http://www.tropes.fr/download.htm | 21 March 2014 |
Free&Open source | Application software | Data extraction, Data transformation, Data analysis, Data visualisation | http://www.ark.cs.cmu.edu/TweetNLP/ | 29 October 2014 | |
Voyant Tools 1.0 Beta (2014-01-01)
|
Free&Closed source | Web application | Data extraction, Data analysis, Data visualisation | http://voyant-tools.org/ | 18 March 2014 |
Web-harvest 2.0 (2010-02-17)
|
Free&Open source | Data extraction | http://web-harvest.sourceforge.net/ | 26 February 2014 | |
Weka 3.6 (2013-07-30)
|
Free&Open source | Application software | Data transformation, Data analysis, Data visualisation | http://www.cs.waikato.ac.nz/ml/weka/ | 26 February 2014 |
Commercial&Closed source | Application software | Data analysis | http://www.lexically.net/wordsmith/index.html | 1 December 2014 | |
WordStat 6.1 (2010-10-30)
|
Commercial&Closed source | Application software | Data extraction, Data transformation, Data analysis, Data visualisation | http://provalisresearch.com/products/content-analysis-software/ | 21 October 2014 |
Wordcruncher (2014-10-01)
|
Free&Closed source | Application software | Data analysis, Data visualisation | http://www.wordcruncher.com/index.html | 1 December 2014 |