Semantic search
Jump to navigation
Jump to search
Query-Depth:2
Debug output SQLStore
ASK Query
[[Category:Tools]] [[Function.Stage::Create or Receive (Acquire)]]
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=1186)
))
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=1186)
))
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 | 10 (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 |
---|---|---|
7-Zip | Rendering Transfer Fixity | 7-Zip is a file archiver with a high compression ratio, and encryption and fixity check capabilities |
AFF Open Source Computer Forensics Software | Disk Imaging | Tools for the creation of disk images, used in conjunction with the AFF open and extensible file format to store disk images and associated metadata. |
ANTS (Archives Network Transfer System) | Transfer | ANTS runs on a Windows desktop and is designed to package digital records with contextual metadata and transfer them to an institutional archives. |
Aaru Data Preservation Suite | Backup Disk Imaging Metadata Extraction | Media dump software and disc image manager |
ArchiFiltre | File Management Appraisal | Overview of folder trees with fine diagrams |
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. |
Archive::BagIt | Fixity File Copy | BagIt API for Perl |
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. |
ArchiveFacebook | Web Capture | ArchiveFacebook is a Firefox extension which allows individuals to save and manage Facebook web content. |
Artivity | Data capture and Deposit Workflow and Lab Notebook Management | A tool for capturing contextual data produced during the creative process of artists and designers while working on a computer. |
Autopsy Digital Forensics | Appraisal Content Profiling De-Duplication Disk Imaging Forensic | Open source, free digital forensics tool |
BIL (BagIt Library) | Fixity File Copy | BagIt Library is a Java software library that supports the creation, manipulation and validation of bags. |
BagIt Transfer Utilities | Fixity File Copy | BagIt transfer Utilities are a collection of tools developed for the purpose of validation and transfer of bags. |
Bagger | Fixity Transfer | GUI application to facilitate the creation and verification of BagIt bags. |
Brozzler | Web Capture | From GitHub (https://github.com/internetarchive/brozzler): Brozzler is a distributed web crawler that uses a real browser (Chrome or Chromium) to fetch pages and embedded URLs and to extract links. Brozzler is designed to work in conjunction with warcprox for web archiving. |
Brunnhilde | Metadata Extraction Content Profiling Appraisal | Siegfried-based characterization of directories and disk images |
CDRDAO (CDR Disk At Once) | Disk Imaging | Cdrdao records audio or data CD-Rs in disk-at-once (DAO) mode based on a textual description of the CD contents. |
CINCH | Web Capture | CINCH (Capture INgest and CHecksum Tool) facilitates batch downloading and ingest of Internet-accessible documents and/or images to a central repository. |
CND3D | Active Data Storage Storage Managing Active Research Data Data capture and Deposit | Store, Preserve and publish 3D objects produced in Digital Humanities Research |
CRunch | Workflow and Lab Notebook Management Managing Active Research Data | cRunch provides an infrastructure for exploratory data analysis with the statistical programming language and environment R |
CloneCD | Disk Imaging | CloneCD is the perfect tool to make backup copies of your music and data CDs, regardless of copy protection. |
ContextMiner | Metadata Processing Web Capture | ContextMiner is a framework to collect, analyze, and present the contextual information along with the data. |
Cp Unix command | File Copy | cp copies files (or, optionally, directories). Part of GNU coreutils. |
Cryptcat | File Copy | Cryptcat is a lightweight version of netcat with integrated transport encryption capabilities. |
Curate.Us | Web Capture | With a simple click of the mouse, you can create visually compelling clips and quotes of web content that are easily embedded in blog posts, email, forums, and websites. |
Czkawka | De-Duplication File Management Appraisal | Czkawka is a simple, fast and free app to remove unnecessary files from your computer. |
DART (Digital Archivist's Resource Tool) | Storage File Management Fixity Transfer | Provides both a GUI and a command-line interface for packaging files and uploading them to remote repositories. |
DArcMail | Data capture and Deposit Access Appraisal | Processing and access to email accounts |
DIMAG IngestList | Metadata Extraction Transfer | Accompanies ingest process from donor to archive, logs process steps. |
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. |
Dd Unix command | File Copy | This page gives information on using the dd Unix command. |
Dd rescue | File Recovery Disk Imaging | dd_rescue is suitable for rescuing data from a medium with errors, i. |
DeepArc | File Format Migration Web Capture | Intended for preserving web sites from the back-end, this is a database-to-XML curation tool. |
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) |
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. |
DiskFormatID | Disk Imaging File Format Identification | Identify floppy disk formats from kryoflux stream files |
Disktype | Metadata Extraction Disk Imaging | Tool for detecting the content format of a disk or disk image. It knows about common file systems, partition tables, and boot codes. |
Docuteam packer | Appraisal Data capture and Deposit File Management Fixity Metadata Processing | Creates and edits SIPs |
Docworks | OCR Workflow Quality Assurance | Document digitization workflow software |
Double Commander | Fixity File Copy Batch Rename File Management De-Duplication | Open source file manager with two panels side by side |
DriveImage XML | Disk Imaging | DriveImage XML is an easy to use and reliable program for imaging and backing up partitions and logical drives. |
Duke Data Accessioner | File Copy File Format Identification Metadata Extraction Transfer Validation | Data Accessioner provides a graphical user interface to aid in migrating data from physical media to a dedicated file server, documenting the process and using MD5 checksums to identify any errors introduced in transfer. |
EPADD | Metadata Processing Metadata Extraction Content Profiling Access Appraisal | ePADD is a software package developed by Stanford University's Special Collections & University Archives that supports archival processes around the appraisal, ingest, processing, discovery, and delivery of email archives. |
Easy CD-DA Extractor | File Format Migration Metadata Extraction Disk Imaging | Easy CD-DA Extractor is CD Ripper, Music Converter, Audio Converter, Metadata Editor, and CD/DVD burning software. |
Exact Audio Copy | File Format Migration Metadata Extraction Disk Imaging | Exact Audio Copy is an audio grabber for audio CDs using standard CD and DVD-ROM drives on Windows only. |
Exactly | Transfer | Packs data in BagIt bags and transfers them to/from remote location via FTP, SFTP |
FC5025 | Data capture and Deposit | Device Side Data's FC5025 USB 5.25" floppy controller plugs into any computer's USB port and enables you to attach a 5.25" floppy drive. |
FCIV | Fixity Transfer | Generates and compares MD5 values stored in an XML file. |
Find It! Keep It! | Web Capture | Find It! Keep It! is a tool to save and organise web content. |