Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Preservation Action]]
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=1198)
))
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=1198)
))
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 | 11 (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 |
---|---|---|
JJ2000 | File Format Migration Rendering | Pure Java implementation of a JPEG2000 decoder |
JPC | Emulation | JPC is the fast pure Java x86 PC emulator. |
JWAT | Validation File Format Migration Metadata Extraction | Java Web Archive Toolkit |
Java library implementing Pairtree | De-Duplication File Management | The PAIRTREE LIBRARY is a software library that supports the mapping between identifiers and filepaths according to the Pairtree Specification. |
Jp2StructCheck | Validation Metadata Extraction Quality Assurance | Simple JP2 file structure checker |
Jpylyzer | Validation Metadata Extraction Quality Assurance | JP2 validation + properties extraction |
KEEP Emulation Framework | Emulation | KEEP Emulation Framework (EF) allows users to view and interact with digital files that otherwise would require obsolete hardware and software. |
KOST-Simy | Validation Quality Assurance | The KOST-Simy application is used for Compare Images. |
KOST-Val | Validation Quality Assurance | KOST-Val is an open source validator for different file formats and Submission Information Package (SIP). |
Kakadu | File Format Migration Rendering | JPEG 2000 SDK, includes encoder/decoder |
Kernel-based virtual machine | Emulation | KVM (for Kernel-based Virtual Machine) is a full virtualization solution for Linux on x86 hardware containing virtualization extensions (Intel VT or AMD-V). |
LegacyFileConverter | File Format Migration | Converts document formats to RTF |
Library (xklb) | File Management Quality Assurance Web Capture | Media indexing multi-tool |
Libreoffice | File Format Migration | An office suite with command line options for PDF/A conversions |
Lingfo | File Format Migration Metadata Extraction | Lingfo provides a library for developers to use to extract information from Microsoft Excel spreadsheet files. |
Linux-VServer | Emulation | Linux-VServer provides virtualization for GNU/Linux systems. |
LuraDocument PDF Compressor | File Format Migration | LuraDocument PDF Compressor is a document conversion engine. |
MDB/ACCDB Viewer | File Format Migration | MDB Viewer opens Microsoft Access 1997-2013 databases on your Macintosh, and views and exports all tables in Access databases. |
METS Navigator | Metadata Processing Rendering | METS-based system for displaying and navigating sets of page images or other multi-part digital objects. |
MIXED (Migration to Intermediate XML for Electronic Data) | File Format Migration | MIXED (Migration to Intermediate XML for Electronic Data) is a web service that converts tabular data files such as spreadsheets and databases to the Standard Data Format for Preservation (SDFP), a supplier-independent XML format. |
MP3val | Validation Quality Assurance | MP3val is a small, high-speed, free software tool for checking MPEG audio files' integrity. |
MPG321 | File Format Migration | mpg321 is a command-line mp3 player. mpg321 is used for frontends, as an mp3 player and as an mp3 to wave file decoder. |
MPP Viewer | Access File Format Migration | MPP Viewer is a viewer for Microsoft Project files |
MPlayerRR | Rendering | A movie player that runs on many systems, supports a wide range of formats and supports a wide range of output drivers |
MRU-Blaster | Forensic Redaction | MRU-Blaster is a program made to do one large task - detect and clean MRU (most recently used) lists on your computer. |
MSIL Disassembler (Ildasm.exe) | File Format Migration | The MSIL Disassembler is a companion tool to the MSIL Assembler (Ilasm. |
MailStore Home | Discovery File Management Metadata Extraction Metadata Processing | Unifies your private emails into one searchable, platform-independent repository |
Matchbox Tool | De-Duplication Quality Assurance | Matchbox: Duplicate detection tool for digital document collections. |
Mdqc | Metadata Extraction Metadata Processing Quality Assurance | Tool for managing and comparing digital asset metadata |
MeshLab | Rendering | A tool for editing, cleaning, healing, inspecting, rendering, texturing, converting, and editing 3D triangular meshes. |
Micr'Olonys | Access Backup File Recovery Storage Transfer Passive Data Storage | Micr’Olonys is the software solution for long-term passive digital archiving on film and paper. |
Microsoft Office 2003 Add-in: Word Redaction v1.2 | Forensic Redaction | 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 | Forensic Redaction | 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. |
Mplayer | Rendering | A movie player that runs on many systems, supports a wide range of formats and supports a wide range of output drivers |
Mutlivalent | Rendering | Multivalent works on digital documents research and development. |
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. |
NT (New Tool) | De-Duplication Rendering | This is a presrvation tool |
Namalysator | Validation Metadata Processing Quality Assurance | Tool for METS/ALTO validation and quality control |
Nitro Pro | File Format Migration | A PDF handling tool including PDF/A |
NumaHOP | OCR Quality Assurance | Platform for digitization projects management |
Ontrack EasyRecovery | File Recovery | Ontrack EasyRecovery software products offer home users or businesses complete solutions for their data recovery, file repair and disk diagnostic needs. |
Open Office | File Format Migration Rendering | OpenOffice.org 3 is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. |
Open Video Converter | File Format Migration | This tool is for video conversion, splitting and editing. |
OpenJPEG | File Format Migration Metadata Extraction | The OpenJPEG library is an open-source JPEG 2000 codec written in C language. |
OpenVZ wiki | Emulation | OpenVZ is container-based virtualization for Linux. |
OpenXML/ODF Translator Add-in for Office | File Format Migration | The goal for this project is to provide translators to allow for interoperability between applications based on ODF (OpenDocument) 1. |
Oracle Outside In Technology | File Format Migration | Outside In Technology is a suite of software development kits (SDKs) that provides developers with a comprehensive solution to access, transform and control the contents of over 500 unstructured file formats. |
PDFTron PDF-A Manager | Validation File Format Migration | PDF/A Manager is a PDF/A (ISO 19005) validation and conversion software. |
PDFsam | Redaction Rendering | PDFsam splits and merges PDF files |
Package Handler | Validation File Management Metadata Processing Personal Archiving Appraisal | View, create, edit, and validate Swiss archival packages |