Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Ingest]]
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=1195)
))
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
200
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=1195)
))
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
200
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 |
---|---|---|
Smithsonian Cook | File Format Migration Metadata Extraction Metadata Processing Rendering Workflow | Processing of 3D model, mesh, and texture data including the option to define custom processing workflows, where a set of files is processed by multiple tools. |
SobekCM | Access Discovery Metadata Processing Preservation System Quality Assurance | SobekCM is a digital repository and digital scholarship/publishing system which enables easy deposit, preservation, and access for all types of digital content, tailored to the needs of galleries, libraries, archives, museums, scholars, and researchers. |
SobekCM METS Editor | Metadata Processing | Creation of METS documents from a folder of items with bibliographic 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. |
TIFF-Val | Validation Quality Assurance | TIFF-Val is an open source validator for TIFF files. |
TOMES (Transforming Online Mail with Embedded Semantics) | Content Profiling Data capture and Deposit File Format Migration Metadata Processing | A package of open source tools for handling the preservation of government email records |
TrID File Identifier | File Format Identification | TrID is a utility designed to identify file types from their binary signatures. |
Tree | File Management Metadata Processing Appraisal | Tree displays the directory structure of a path or of the disk in a drive graphically. |
UKWA Access API | Persistent Identification Service | Web archives access API |
UKWA GSuite Add-On | Validation Appraisal | GSuite functions for people working with web archives. The functions use the Memento API (specifically the TimeGate) to look up whether a given archive holds a given URL. It currently supports checks against:
|
USGS Formal metadata: information and software | Metadata Processing | This page links to information and tools from the USGS. |
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 |
VeraPDF | Validation | PDF/A validation tool |
Voyeur | Access Metadata Processing | Voyeur is a web-based text analysis environment that can use texts in a variety of formats, from different locations to perform lexical analysis, export data to other tools, and embed live tools into remote websites. |
W3C Markup Validation Service | Validation | This is the World Wide Web Consortium's validation tool. |
WCT (Web Curator Tool) | Metadata Processing Web Capture | Web Curator Tool (WCT) is a workflow management application for selective web archiving. |
Warctools | Validation File Format Migration Metadata Extraction | Command line tools and libraries for handling and manipulating WARC files (and HTTP contents) |
Web Archive Discovery | Content Profiling Discovery File Format Identification Metadata Extraction | Indexing and discovery tools for web archives. |
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. |
WordHoard | Access Metadata Extraction | WordHoard is an application for the close reading and scholarly analysis of deeply tagged texts. |
XMLstarlet | Metadata Processing | A set of command line utilities (tools) to transform, query, validate, and edit XML documents and files |
XcorrSound | De-Duplication Quality Assurance | The xcorrSound package compares sound waves using cross correlation. |
Xpdf | Metadata Extraction Rendering | Open source PDF viewer that includes PDF information extractor and font analyzer |