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
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=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
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 |
---|---|---|
InBoxer | Metadata Extraction Metadata Processing Access | InBoxer is a next generation email archiving, IM archiving, e-discovery, and policy management system. |
Index.dat Analyzer v2.5 | Metadata Extraction Forensic | Index.dat Analyzer is a tool to view, examine and delete contents of index.dat files. |
InfinaDyne | Forensic | InfinaDyne's forensic products are focused on government and law enforcement examining various types of media and intent on collecting evidence in a thorough, secure and trustworthy manner. |
Invenio | Preservation System | Invenio is a free software suite enabling you to run your own digital library or document repository on the web. |
JHOVE (Harvard Object Validation Environment) | Validation Metadata Extraction File Format Identification Encryption Detection | JHOVE provides functions to perform format-specific identification, validation, and characterization of digital objects. |
JHOVE2 | Validation Metadata Extraction File Format Identification Encryption Detection | JHOVE2 allows data curators to characterise the digital objects in their repositories. |
JWAT | Metadata Extraction Validation File Format Migration | Java Web Archive Toolkit |
Jp2StructCheck | Validation Quality Assurance Metadata Extraction | Simple JP2 file structure checker |
Jpylyzer | Validation Quality Assurance Metadata Extraction | JP2 validation + properties extraction |
KEA (Keyphrase Extraction Algorithm) | Forensic | KEA is an algorithm for extracting keyphrases from text documents. |
Keith Humphreys' PhraseRate | Metadata Extraction | PhraseRate is a program, developed by Keith Humphreys, for extracting a set of meaningful, attractive keywords and key phrases from a web page describing the content of that page. |
LOCKSS (Lots of Copies Keep Stuff Safe) | Storage Preservation System Access | LOCKSS software allows libraries to create preserved digital collections out of materials that would otherwise be accessible only through a licensed academic subscription. |
Libewf | Forensic | Libewf is a library for support of the Expert Witness Compression Format (EWF), it support both the SMART (EWF-S01) and EnCase (EWF-E01) format. |
Libsafe | Preservation System | libsafe allows the organizations to create a full OAIS compliant Archive, including active and passive digital preservation workflows and is particularly suited for master image files of digitizing processes. |
Lingfo | File Format Migration Metadata Extraction | Lingfo provides a library for developers to use to extract information from Microsoft Excel spreadsheet files. |
METS Reader Writer | Metadata Extraction Metadata Processing | Python library for processing and outputting METS/PREMIS XML according to the Archivematica METS profile. |
MP3::Tag | Metadata Extraction | MP3::Tag is a module for reading tags of MP3 audio files. |
MRU-Blaster | Redaction Forensic | MRU-Blaster is a program made to do one large task - detect and clean MRU (most recently used) lists on your computer. |
MailStore Home | Metadata Extraction Metadata Processing File Management Discovery | Unifies your private emails into one searchable, platform-independent repository |
McAfee Free Tools | Forensic | Free Tools [See specifically Foresnic Tools] |
Mdqc | Metadata Extraction Metadata Processing Quality Assurance | Tool for managing and comparing digital asset metadata |
MediaInfo | Metadata Extraction | Supplies technical and tag information about a video or audio file. |
Mendeley | Academic Social Networking Citation and Impact Tracking | Mendeley is a combination web service and desktop application that allows users to create, manage, and share collections of references. |
Merritt Repository Service | Preservation System | Merritt is a cost-effective repository service from the University of California Curation Center (UC3) that lets the UC community manage, archive, and share its valuable digital content. |
Metadata Extraction Tool | Metadata Extraction | Metadata Extraction Tool automatically extracts a limited set of metadata from the headers of digital files. |
Metadata Interrogator | Metadata Extraction | The Metadata Interrogator is a standalone, offline GUI tool for extracting and analysing metadata from a wide variety of file formats. |
Metadata transformer | Metadata Extraction | A simple tool for creating new CSV and HTML reports based on the metadata files generated by the Data Accessioner |
Metadata++ | Metadata Extraction Metadata Processing Personal Archiving | Freeware tool to view, edit, modify, extract, copy metadata of various formats. |
Metadata2Go | Metadata Extraction | Web-based EXIF data viewer |
Microsoft Office 2003 Add-in: Word Redaction v1.2 | Redaction Forensic | Use the Word 2003 Redaction Add-in to hide text within Microsoft Office Word 2003 documents. |
Microsoft Office 2003/XP Add-in: Remove Hidden Data | Redaction Forensic | With this add-in you can permanently remove hidden data and collaboration data, such as change tracking and comments, from Microsoft Word, Microsoft Excel, and Microsoft PowerPoint files. |
Minimum Preservation Tool | Fixity Preservation System | The Minimum Preservation Tool (MPT) can be used to create an interim preservation storage environment for files awaiting preservation in a longer term repository solution. It supports checksum generation, fixity checking, and replication across two or more storage nodes. |
Mink | Access Discovery Personal Archiving | Chrome extension that uses Memento to indicate that a page a user is viewing on the live web has an archived copy and to give the user access to the copy |
Muse | Personal Archiving | A tool used for personal archiving of email. |
MyExperiment | Workflow and Lab Notebook Management Managing Active Research Data Academic Social Networking Workflow | myExperiment is an online social networking service aimed at scientific researchers; the site fosters collaboration by allowing members to share scientific workflows, experiment plans, and other digital objects. |
NARA File Analyzer and Metadata Harvester | Fixity Metadata Extraction File Format Identification | NARA File Analyzer and Metadata Harvester allows a user to analyze the contents of a file system or external drive and generates statistics about the contents of the contained directories. |
NARA Video Frame Analyzer | Metadata Extraction Quality Assurance | NARA Video Frame Analyzer analyzes technical properties of individual frames of a video file in order to detect quality issues within digitized video files. |
NESSTAR | Metadata Processing Service | Nesstar suite is an online publishing platform for organisations wishing to share datasets both internally and with the wider web. |
NSRL (National Software Reference Library) | Forensic | The NSRL provides a large data set of metadata on computer files which can be used to identify the files and their provenance |
Nanite | File Format Identification Metadata Extraction | A friendly swarm of format-identifying robots |
Nextflow | Workflow | Data-driven computational pipelines |
OCFA (Open Computer Forensics Architecture) | Forensic | Open Computer Forensics Architecture is a modular computer forensics framework. |
ODF Validator | Validation Metadata Extraction | ODF Validator is a tool that validates OpenDocument files and checks them for certain conformance criteria. |
OSFMount | Disk Imaging Forensic | disk image file mounting |
Officeparser.py | Metadata Extraction File Format Identification | officerparser.py is a python script that parses the format of OLE compound documents used by Microsoft Office applications. |
OpenJPEG | File Format Migration Metadata Extraction | The OpenJPEG library is an open-source JPEG 2000 codec written in C language. |
PDF Tools (by Didier Stevens) | Metadata Extraction Dependency Analysis Validation | Tools for parsing and analysing PDF documents |
PET (PERICLES Extraction Tool) | Metadata Extraction Dependency Analysis | A tool to capture contextual information in a sheer curation scenario |
Package Handler | File Management Metadata Processing Personal Archiving Validation Appraisal | View, create, edit, and validate Swiss archival packages |
Pagelyzer | Metadata Extraction Quality Assurance | Suite of tools for detecting changes in web pages and their rendering |