Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Cross-Lifecycle Functions]]
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=1189)
))
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
150
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=1189)
))
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
150
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 |
---|---|---|
Paraben | Forensic | Paraben provides forensics tools. |
PdfaPilot | Validation File Format Migration Metadata Extraction | pdfaPilot: Conversion of documents and emails into robust, searchable PDF or PDF/A files |
Pdfcpu | Validation Metadata Extraction | A Go library and command line tool for PDF processing incl. validation |
Pdftk | Metadata Extraction Repair | PDF manipulation tool |
Peepdf | Metadata Extraction | peepdf is a Python tool to explore PDF files in order to find out if the file can be harmful or not. |
Perma.cc | Citation and Impact Tracking Personal Archiving | A tool that captures, stores, plays-back and provides a new URL for web citation. Built and maintained at the Harvard Law School Library. |
Pre-Ingest Tool | Validation Metadata Extraction Metadata Processing | A tool for generating an OAIS SIP for digital preservation. It produces METS document that contains metadata for digital preservation. |
Preservica | Preservation System Service | Preservica is a complete OAIS Digital Preservation system available on the cloud (hosted in US, EU, CA or AUS) and on-premise. It is trusted by over 1000 organisations across 5 continents to preserve collections both large (>6Pb) and small (few 100kb). |
Prodiscover | Forensic | Prodiscover provides a set of features and toolkits for Computer Forensics and Incident Response |
Proofpoint Enterprise Archive | Discovery Storage Service | Proofpoint Enterprise Archive is a SaaS email archiving solution that addresses three key challenges eDiscovery, regulatory compliance and email storage management without the headaches of managing archiving in-house. |
PyFlag | Forensic | FLAG (Forensic and Log Analysis GUI) is an advanced forensic tool for the analysis of large volumes of log files and forensic investigations. |
Python XMP Toolkit | Metadata Extraction Metadata Processing | Library for working with XMP metadata, as well as reading/writing XMP metadata stored in many different file formats |
Qpdf | Decryption Metadata Extraction | QPDF is a command-line program that does structural, content-preserving transformations on PDF files |
RAID (Real-time Analytical Intelligence Database) | Forensic | RAID is a relational database used to record key pieces of information and to quickly identify links among people, places, businesses, financial accounts, telephone numbers, and other investigative information. |
RATOM | Discovery Metadata Extraction Appraisal | Review, Appraisal, and Triage of Mail (RATOM) is software to assist archives and other collecting organizations with email analysis, selection, and appraisal tasks |
RCS (The Revision Control System) | Version Control | The Revision Control System (RCS) manages multiple revisions of files. |
RackSpace | Storage Service | RackSpace provices cloud based services to businesses of all sizes through the world. |
RapidRedact | Forensic Redaction | The RapidRedact product range provides fast, easy to use redaction tools for irreversibly blanking out (redacting) selected information, author's changes and hidden data from all electronic document types. |
Redact-It | Forensic Redaction | Provides Windows desktop and server redaction of PDF, Word, scanned TIFF images. Find, black out and remove content within documents, images or drawings. |
Redax | Forensic Redaction | Redax completely redacts (removes) text and graphics from the PDF page. |
Regshot | Forensic | Regshot is an open-source (GPL) registry compare utility that allows you to quickly take a snapshot of your registry and then compare it with a second one - done after doing system changes or installing a new software product. |
Rescarta | Access Personal Archiving Preservation System | The ResCarta Tools software empowers users to create non-proprietary digital objects with LOC standard METS, MODS, MIX and AudioMD metadata from existing TIFF, JPEG, PDF and WAV data through user-friendly interfaces. |
ResearchGate | Academic Social Networking | ResearchGate is an online professional network for scientists and researchers, particularly employed by those wishing to follow and track the publication outputs of others in their field. |
Roda | Preservation System | RODA - Repository of Authentic Digital Objects |
Rosetta | Access File Format Migration Metadata Processing Preservation System | Ex Libris Rosetta enables institutions to preserve and provide access to the collections in their care. |
Samvera | Preservation System | A digital repository software that offers flexible and rich user interfaces tailored to distinct content types |
Sheeko | Annotation Metadata Extraction | Machine learning implementation package to generate descriptive metadata for digitized historical images. |
Shotwell | Annotation Metadata Processing Personal Archiving | An open source photo manager capable of describing image collections for archival ingest. |
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. |
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. |
The Carve Path Zero-storage Library and filesystem | Forensic | LibCarvPath is a library for computer forensics carving tools. |
The Open Video Digital Library Toolkit | Preservation System | The Open Video Digital Library Toolkit project is intended to provide museums, libraries and other institutions holding moving image collections tools to more easily create Web-based digital video libraries. |
The Sleuth Kit | Forensic | Collection of command line computer forensics digital investigation tools. |
UKWA Access API | Persistent Identification Service | Web archives access API |
Vitam | Preservation System | Vitam is an open source software able to manage and preserve digital records and archives (back-end). |
WARCreate | Data capture and Deposit Personal Archiving Web Capture | Google Chrome browser extension for creating WARC files from web pages |
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. |
WinHex | Binary & Hexidecimal Editing Forensic | WinHex is in its core a universal hexadecimal editor, particularly helpful in the realm of computer forensics, data recovery, low-level data processing, and IT security. |
Windows IR/CF Tools | Forensic | Windows based forensic tools |
WordHoard | Access Metadata Extraction | WordHoard is an application for the close reading and scholarly analysis of deeply tagged texts. |
WxHexEditor | Binary & Hexidecimal Editing | A free hex editor / disk editor |
Xpdf | Metadata Extraction Rendering | Open source PDF viewer that includes PDF information extractor and font analyzer |
Yara | Content Profiling Forensic | YARA is a tool that allows the identification of files that match user-defined textual or binary patterns |