Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Store]]
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
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_di_wikipage` AS t6 ON t4.o_id=t6.s_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=1157
AND (t6.p_id=1162 AND t6.o_id=1204)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
100
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
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_di_wikipage` AS t6 ON t4.o_id=t6.s_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t4.p_id=1157
AND (t6.p_id=1162 AND t6.o_id=1204)
))
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
OFFSET
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t6 | ref|filter | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id|p_id | 5|4 | const | 9 (2%) | Using where; Using temporary; Using filesort; Using rowid filter | |
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | wikidb.t6.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | wikidb.t4.s_id | 1 | Using where | |
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | s_id_2 | 4 | wikidb.t4.s_id | 1 | Using where; Using index; Distinct | |
1 | SIMPLE | t3 | eq_ref | PRIMARY | PRIMARY | 4 | wikidb.t2.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t3
Recursively computed hierarchy for element(s) (517).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=517 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:2
Errors and Warnings
NoneTool | Function | Purpose |
---|---|---|
Riprap | Fixity | Riprap is a PREMIS-compliant fixity checking microservice. |
Rocfl | File Copy Storage | rocfl is a command line utility for interacting with OCFL repositories on the local filesystem or in S3. |
SAFE Archive Audit System | Fixity Storage | Policy-based replication and Auditing of LOCKSS networks. |
SRB (The DICE Storage Resource Broker) | Storage | The DICE Storage Resource Broker (SRB) supports shared collections that can be distributed across multiple organizations and heterogeneous storage systems. |
SSDeep | Fixity De-Duplication | Recursive piecewise hashing tool |
SafeMover | Fixity Data capture and Deposit Transfer | Python tool to support the overtly "safe" copying of files from one location to another. Uses fixity, and OS file system metadata. |
Sumfolder1 | Fixity De-Duplication Appraisal | sumfolder1 is a utility for use within the archival and digital preservation community to generate checksums for file system directories, and to generate an overall "collection" checksum for a given set of files. The utility may be used in support of de-duplication at a directory/folder level. |
Taverna | Managing Active Research Data Workflow Workflow and Lab Notebook Management | Taverna is a scientific workflow management system designed to assemble, run, document and share sequences sequences of web services and scripts. |
TeraCopy | File Copy File Management Transfer | Performs file copying, whilst also logging and verifying accuracy and completeness by using checksums |
The Rename | File Management | Bulk renaming of files |
The aDORe Federation | Storage | The aDORe Federation is a federated repository framework and reference implementation which aims to address many of the scalability issues experienced by large scale digital object repositories. |
Tree | File Management Metadata Processing Appraisal | Tree displays the directory structure of a path or of the disk in a drive graphically. |
TreeSize | File Management Appraisal | Manage disk space and scan your hard disks. |
UKWA Access API | Persistent Identification Service | Web archives access API |
UnArchiver | Fixity Decryption Transfer | UnArchiver is a native macOS utility which supports infinitely more archive formats then other common archiving utilities. |
VRenamer | File Management Metadata Processing | vRenamer is a cross platform tool for batch renaming files |
Warc-proxy | File Management Rendering | Warc-proxy is a simple tool to view WARC content in Firefox |
WarcManager | File Management Web Capture | The WARC Manager is a web-based UI for managing and querying collections of web crawl data. |
WebCite | Citation and Impact Tracking Persistent Identification Web Capture | WebCite is an on-demand web archiving service that takes snapshots of Internet-accessible digital objects at the behest of users, storing the data on their own servers and assigning unique identifiers to those instances of the material. |
WinMerge | De-Duplication File Management | A visual tool for differencing and merging of file collections, images and texts. |
XArch | Managing Active Research Data | XArch is an archive management system that allows one to create, populate, and query archives of multiple database versions. |