Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Category: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 t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=1179)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  25
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, s_id_2, o_id_2o_id_25const52Using index; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4wikidb.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
Lifecycle FunctionsDefinition
Academic Social NetworkingTools that support making connections, sharing research and maximising the impact of digital data.
AccessTools that facilitate access to digital data by users.
Active Data StorageTools that support the storage, management, and ultimately the preservation, of evolving research data.
AnnotationTools that facilitate annotation of digital data by users.
AppraisalTools that enable the assessment of content against in order to decide on it's relevance or appropriateness for preservation
BackupTools that support the backing up of digital data to another storage location, typically in a scheduled manner.
BenefitsTools that enable the identification and articulation of the benefits of preservation and curation.
Binary & Hexidecimal EditingTools for viewing and editing of files displayed in different views such as binary, hexadecimal. These are typically known as hex editors.
Citation and Impact TrackingTools that support the citation of data and the tracking of the impact of usage of that data.
Content ProfilingTools that build a profile of the characteristics of digital content, typically by combining or analysing a number of sources of information such as extracted metadata and file format identifications.
CostingTools that support the calculation or prediction of the cost of preservation or curation activities.
Data Management PlanningTools that support the development of research data management plans and related activities.
Data capture and DepositTools that enable the capture and deposit of data.
De-DuplicationTools that enable the identification and/or removal of duplicate or similar files.
DecryptionTools for recovering passwords or unlocking encrypted digital files.
Dependency AnalysisTools for identifying essential information that resides externally to a digital object, or for identifying dependent processes such as which DLLs are required by a Windows process.
DiscoveryTools that facilitate the discovery of digital data by users.
Disk ImagingTools that enable the capture, viewing or extraction of contents of a disk image (which is a computer file containing the contents and structure of a disk volume or an entire data storage device, such as a hard drive or floppy disk).
EmulationTools that enable the emulation or virtualisation of a hardware or software system on another system.
Encryption DetectionTools that support the detection of encryption or password protection in files.