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
0
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
0
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 |
---|---|---|
AFFLIB | Forensic | The Advanced Forensics Format (AFF) and AFF Library (AFFLIB) are a joint development project of Simson L. |
ALTAG3D | File Management Storage Metadata Extraction Personal Archiving | An open source archive software |
Aaru Data Preservation Suite | Backup Disk Imaging Metadata Extraction | Media dump software and disc image manager |
Adobe Photoshop Elements | Metadata Extraction Metadata Processing Personal Archiving | A commercial image editor with a metadata module (Organizer). |
Amazon Cloud | Storage Service | Amazon Cloud is an internet-based storage location designed to hold files indefinitely. |
Apache PDFBox | Metadata Extraction Repair File Format Migration Validation Encryption Detection | JAVA PDF library for creation, manipulation, validation and content extraction of PDF documents |
Apache POI - the Java API for Microsoft Documents | File Format Migration Metadata Extraction Encryption Detection | The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). |
Apache Tika | Metadata Extraction File Format Identification Text Extraction Embedded File Extraction | Java based tool for identifying file formats using signatures and extracting metadata and text content from documents. |
Archive-It | Service Web Capture | Archive-It is the leading web archiving service for collecting and accessing cultural heritage on the web. It is a service provided by the Internet Archive. |
ArchiveBox | Web Capture Personal Archiving | ArchiveBox is an open source tool that lets organizations & individuals archive both public & private web content while retaining control over their data. |
Archivematica | Preservation System File Format Migration | Archivematica is a digital preservation system that automates the process of preparing digital objects for ingest into a repository and an access system |
Audacity | Redaction Personal Archiving File Management | The open source audio editor |
AudiAnnotate | Access Annotation Preservation System Workflow Academic Social Networking Personal Archiving Service Version Control Metadata Processing Rendering Discovery Persistent Identification Managing Active Research Data | To make audio and its interpretations more discoverable and usable by extending the use of the newest IIIF (International Image Interoperability Framework) standard for audio with the development of the AudiAnnotate web application, documented workflows and workshops that will facilitate the use of existing best-of-breed, open source tools for audio annotation (Sonic Visualiser), for public code and document repositories (GitHub), and audio presentation (Universal Viewer) to produce, publish, and sustain shareable W3C Web Annotations for individual and collaborative audio projects. |
Autopsy Digital Forensics | Appraisal Content Profiling De-Duplication Disk Imaging Forensic | Open source, free digital forensics tool |
Autopsy Forensic Browser | Forensic | Graphical interface to the command line digital investigation tools in The Sleuth Kit |
BWF MetaEdit | Metadata Extraction Metadata Processing Validation | BWF MetaEdit permits embedding, validating, and exporting of metadata in Broadcast WAVE Format (BWF) files. |
BitCurator | File Management Fixity Metadata Extraction Metadata Processing Quality Assurance Validation Workflow | The BitCurator Environment is an Ubuntu Linux distribution geared to the needs of archivists and librarians. It includes a suite of open source digital forensics and data analysis tools to help collecting institutions process born-digital materials. |
Bless | Binary & Hexidecimal Editing | Bless is a high quality, full featured hex editor. |
Brunnhilde | Metadata Extraction Content Profiling Appraisal | Siegfried-based characterization of directories and disk images |
C3PO | Content Profiling Metadata Extraction | C3PO is a content profiling tool for visualization and preservation analysis |
CONTENTdm | Preservation System | CONTENTdm is a digital collection management system |
CWL (Common Workflow Language) | Workflow | Common Workflow Language (CWL) is an open standard for describing how to run command line tools and connect them to create workflows. |
Carbonite | Storage Backup Service | an online backup service that automatically backs up documents, e-mails, music, photos, and settings. Info gathered early March 2013. |
Chronopolis | Storage Backup Service | "Chronopolis digital preservation network provides services for the long-term preservation and curation of America's digital holdings" |
CloudCompare | File Format Migration Multi Format Rendering Metadata Extraction | CloudCompare is a tool for editing and processing 3D point clouds and triangular meshes. |
CollectiveAccess | Access Preservation System | CollectiveAccess is web-based software to catalogue, manage, and publish museum and archival collections. |
Crazy-fast-image-scan | File Format Identification Content Profiling Forensic | A script to scan media very quickly to find out what kind of content it contains |
CyberChef | Encryption Detection File Management Decryption Metadata Extraction Personal Archiving Binary & Hexidecimal Editing Discovery | A forensic tool with workflow capabilities to analyse files and containers |
DAITSS | Preservation System | A digital preservation software application designed as a dark archive to service consortial and institutional preservation repositories a multi-user environment type. DAITSS is considered to be a first-party system. |
DCape (ingest only) | Preservation System Storage | "The goal of the DCAPE project is to build a distributed production preservation environment that meets the needs of archival repositories for trusted archival preservation services." (Note: This is a work in progress, see notes for more information) |
DIMAG | Metadata Extraction Preservation System Access File Format Migration Storage Workflow | A software suite supporting archives with preservation of digital information for eternity |
DIMAG IngestList | Metadata Extraction Transfer | Accompanies ingest process from donor to archive, logs process steps. |
DLCM | Preservation System | DLCM is an archiving solution based on the OAIS model developed in Java by Swiss universities. It is also the technological stack of the OLOS service. |
DMPonline | Planning Data Management Planning Managing Active Research Data Service | DMPonline is the DCC's data management planning tool. |
DNS | Metadata Processing File Format Migration Validation Preservation System | DNS - DA NRW Software Suite |
DROID (Digital Record Object Identification) | File Format Identification Metadata Extraction | DROID (Digital Record Object Identification) is a software tool developed to perform automated batch identification of file formats. |
DSPS (Digital Preservation Software Platform) | Preservation System | The DPSP is a collection of four software applications which support the goal of digital preservation. |
DSpace | Preservation System Access | DSpace is an institutional repository system which enables easy deposit, preservation, and access for all types of digital content. |
DUMPBIN Utility | Metadata Extraction File Format Identification | The DUMPBIN utility, which is provided with the 32-bit version of Microsoft Visual C++, combines the abilities of the LINK, LIB, and EXEHDR utilities. |
DataLifter | Forensic | suite of tools "designed to assist with Computer Forensics, Information Auditing, Information Security and Data Recovery" |
Dataverse | Active Data Storage Preservation System Managing Active Research Data Storage | The Dataverse is an open source web application to share, preserve, cite, explore and analyze research data. |
Dc3dd for computer forensics | Disk Imaging Forensic | dc3dd is a patched version of GNU dd with a number of features useful for computer forensics. |
Dcfldd | File Management Forensic File Copy | dcfldd is an enhanced version of GNU dd with features useful for forensics and security. |
Demystify | Metadata Extraction Content Profiling De-Duplication | Format Identification Analysis and Reporting |
DiPS (Digital Preservation Solution) | Access Active Data Storage File Format Identification File Format Migration File Management Metadata Extraction Preservation System Secure Deletion Service Storage Transfer Validation Workflow | DiPS (OAIS compliant Digital Preservation Solution) |
Digital Intelligence Forensic Software | Forensic | Digital Intelligence Forensic Software |
Digital Preservation Recorder | Workflow File Format Migration | Digital Preservation Recorder (DPR) is free and open source software developed by the National Archives of Australia to aid in the long term preservation of digital records. |
Directory List & Print | Metadata Extraction File Management | A universal metadata extractor |
DiscMaster | Service | Website to browse and search vintage computer files from archive.org |
Disk2FDI | Backup Disk Imaging Forensic Personal Archiving | Disk2FDI is a professional disk imaging software designed to create binary images of floppy disks to the Formatted Disk Image (FDI) file format, as well as sector-based standard formats. |