Semantic MediaWiki/data - Revision history

Woozle: moved a comment here from the main page

2020-07-28T20:57:45Z

moved a comment here from the main page

← Older revision		Revision as of 20:57, 28 July 2020
Line 1:		Line 1:
	==Tables==		==Tables==
			As the SMW code API is not yet stable or well-documented, it appears that going directly to the database may be the best way to utilize SMW data from code running within MediaWiki (typically as an extension).

	All of this information has been reverse-engineered, mostly from examination of data in a single SMW instance. I was not able to find any data-structure documentation in the [https://doc.semantic-mediawiki.org/index.html official code docs].		All of this information has been reverse-engineered, mostly from examination of data in a single SMW instance. I was not able to find any data-structure documentation in the [https://doc.semantic-mediawiki.org/index.html official code docs].

Woozle at 23:08, 10 July 2020

2020-07-10T23:08:59Z

← Older revision		Revision as of 23:08, 10 July 2020
Line 1:		Line 1:
	==Tables==		==Tables==
	I~~'m presuming that there~~ was ~~a schema version 1 based on~~ the ~~naming of~~ the ~~version 2 tables (they all end in~~ '2'~~), but this may be incorrect. In any case,~~ schema version ~~2 corresponds approximately to~~ SMW ~~v1.x, and schema~~ version ~~3 to SMW 2.x (and some high-numbered 1.x beta releases)~~.		All of this information has been reverse-engineered, mostly from examination of data in a single SMW instance. I was not able to find any data-structure documentation in the [https://doc.semantic-mediawiki.org/index.html official code docs].

			Note that the ''schema'' version numbers are generally higher than the corresponding SMW version<ref name=versions />.
	{\|		{\|
	\|-		\|-
	\| valign=top \|		\| valign=top \|
	===schema version 3===		===schema version 3===
	These are present in SMW version ~~<s>~~1.9 alpha</s> ~~(I think I '~~'~~must~~'' ~~have meant 2.9 alpha):~~		These are present in SMW version 1.9 alpha<ref name=versions />:
	* [[/smw_di_*]]:		* '''[[/smw_di_*]]''':
	** [[/smw_di_blob]]		** [[/smw_di_blob]]
	** [[/smw_di_bool]]		** [[/smw_di_bool]]
Line 63:		Line 65:
	* Presumably the type of storage can be determined by looking up the SMW ID in [[/smw_spec2]], making it unnecessary to check multiple tables (rels2, text2, atts2) for each property. but it does not seem to have been designed for this purpose.		* Presumably the type of storage can be determined by looking up the SMW ID in [[/smw_spec2]], making it unnecessary to check multiple tables (rels2, text2, atts2) for each property. but it does not seem to have been designed for this purpose.
	\|}		\|}
			==Footnote==
			<references>
			<ref name=versions>I'm presuming that there was a schema version 1 based on the naming of the version 2 tables (they all end in '2'), but this may be incorrect. In any case, schema version 2 corresponds approximately to SMW v1.x, and schema version 3 to SMW 2.x (and some high-numbered 1.x beta releases).</ref>
			</references>

Woozle: /* schema version 3 / smw_di_

2020-07-10T23:02:16Z

schema version 3: smw_di_*

← Older revision		Revision as of 23:02, 10 July 2020
Line 5:		Line 5:
	\| valign=top \|		\| valign=top \|
	===schema version 3===		===schema version 3===
	These are present in SMW version 1.9 alpha:		These are present in SMW version <s>1.9 alpha</s> (I think I ''must'' have meant 2.9 alpha):
	* [[/smw_di_blob]]		* [[/smw_di_*]]:
	* [[/smw_di_bool]]		** [[/smw_di_blob]]
	* [[/smw_di_coords]]		** [[/smw_di_bool]]
	* [[/smw_di_number]]		** [[/smw_di_coords]]
	* [[/smw_di_time]]		** [[/smw_di_number]]
	* [[/smw_di_url]]		** [[/smw_di_time]]
	* [[/smw_di_wikipage]]		** [[/smw_di_url]]
			** [[/smw_di_wikipage]]
	* [[/smw_fpt_ask]]		* [[/smw_fpt_ask]]
	* [[/smw_fpt_askde]]		* [[/smw_fpt_askde]]
Line 41:		Line 42:
	* [[/smw_prop_stats]]		* [[/smw_prop_stats]]
	\| valign=top \|		\| valign=top \|

	===schema version 2===		===schema version 2===
	These were present in SMW version 1.7, and may also be valid for 1.8 (but not 1.9):		These were present in SMW version 1.7, and may also be valid for 1.8 (but not 1.9):

Woozle: explanation about the numbering

2015-03-19T19:52:43Z

explanation about the numbering

← Older revision		Revision as of 19:52, 19 March 2015
Line 1:		Line 1:
	==Tables==		==Tables==
			I'm presuming that there was a schema version 1 based on the naming of the version 2 tables (they all end in '2'), but this may be incorrect. In any case, schema version 2 corresponds approximately to SMW v1.x, and schema version 3 to SMW 2.x (and some high-numbered 1.x beta releases).
	{\|		{\|
	\|-		\|-

Woozle: new tables for schema v3

2013-02-14T15:12:08Z

new tables for schema v3

@@ Line 1: / Line 1: @@
 ==Tables==
-As of SMW version 1.7:
+{|
 * '''[[/smw_atts2]]''': relationships where the value is numerically/logically significant, or a "string" (non-page type)
 * [[/smw_conc2]]: not sure; probably [[smw:Help:Concepts|concepts]]
@@ Line 14: / Line 55: @@
 Core tables are boldfaced; the others seem to be primarily for optimization or auxiliary purposes.
-==Explanations==
+====Explanations====
 * Semantic relationships are defined in [[/smw rels2]], [[/smw_text2]], and [[/smw_atts2]].
 * Correspondence between SMW entities (property names and some property values) and MediaWiki pages is defined in [[/smw_ids]]
 * Presumably the type of storage can be determined by looking up the SMW ID in [[/smw_spec2]], making it unnecessary to check multiple tables (rels2, text2, atts2) for each property. but it does not seem to have been designed for this purpose.

Woozle: remaining gaps filled in; key tables boldfaced; one more explanation

2012-12-17T19:41:35Z

remaining gaps filled in; key tables boldfaced; one more explanation

← Older revision		Revision as of 19:41, 17 December 2012
Line 1:		Line 1:
	==Tables==		==Tables==
	As of SMW version 1.7:		As of SMW version 1.7:
	* [[/smw_atts2]]: relationships where the value is numerically/logically significant, or a "string" (non-page type)		* '''[[/smw_atts2]]''': relationships where the value is numerically/logically significant, or a "string" (non-page type)
	* [[/smw_conc2]]: [[smw:Help:Concepts\|concepts]]		* [[/smw_conc2]]: not sure; probably [[smw:Help:Concepts\|concepts]]
	* [[/smw_conccache]]		* [[/smw_conccache]]: not sure; presumably a cache for concepts
	* [[/smw_ids]]: assigns IDs to all properties and ~~some~~ values		* '''[[/smw_ids]]''': assigns IDs to all properties, and values that map to a (potential) wiki page
	* [[/smw_inst2]]: not sure		* [[/smw_inst2]]: not sure
	* [[/smw_redi2]]: not sure; redirects?		* [[/smw_redi2]]: not sure; redirects?
	* [[/smw_rels2]]: relationships where the value refers to a ~~hypothetical~~ wiki page		* '''[[/smw_rels2]]''': relationships where the value refers to a (potential) wiki page
	* [[/smw_spec2]]: URLs to SWiVT specs		* [[/smw_spec2]]: URLs to SWiVT specs
	* [[/smw_subp2]]		* [[/smw_subp2]]: not sure; sub-property map?
	* [[/smw_subs2]]		* [[/smw_subs2]]: not sure; looks like a mapping of categories to sub-categories
	* [[/smw_text2]]: relationships where the value is a long text/data blob		* '''[[/smw_text2]]''': relationships where the value is a long text/data blob

			Core tables are boldfaced; the others seem to be primarily for optimization or auxiliary purposes.
	==Explanations==		==Explanations==
	* Semantic relationships are defined in [[/smw rels2]], [[/smw_text2]], and [[/smw_atts2]].		* Semantic relationships are defined in [[/smw rels2]], [[/smw_text2]], and [[/smw_atts2]].
	* Correspondence between SMW entities (property names and some property values) and MediaWiki pages is defined in [[/smw_ids]]		* Correspondence between SMW entities (property names and some property values) and MediaWiki pages is defined in [[/smw_ids]]
			* Presumably the type of storage can be determined by looking up the SMW ID in [[/smw_spec2]], making it unnecessary to check multiple tables (rels2, text2, atts2) for each property. but it does not seem to have been designed for this purpose.

Woozle: filling in the blanks with blanks

2012-12-17T16:19:02Z

filling in the blanks with blanks

← Older revision		Revision as of 16:19, 17 December 2012
Line 2:		Line 2:
	As of SMW version 1.7:		As of SMW version 1.7:
	* [[/smw_atts2]]: relationships where the value is numerically/logically significant, or a "string" (non-page type)		* [[/smw_atts2]]: relationships where the value is numerically/logically significant, or a "string" (non-page type)
	* [[/smw_conc2]]		* [[/smw_conc2]]: [[smw:Help:Concepts\|concepts]]
	* [[/smw_conccache]]		* [[/smw_conccache]]
	* [[/smw_ids]]: assigns IDs to all properties and some values		* [[/smw_ids]]: assigns IDs to all properties and some values
	* [[/smw_inst2]]		* [[/smw_inst2]]: not sure
	* [[/smw_redi2]]		* [[/smw_redi2]]: not sure; redirects?
	* [[/smw_rels2]]: relationships where the value refers to a hypothetical wiki page		* [[/smw_rels2]]: relationships where the value refers to a hypothetical wiki page
	* [[/smw_spec2]]		* [[/smw_spec2]]: URLs to SWiVT specs
	* [[/smw_subp2]]		* [[/smw_subp2]]
	* [[/smw_subs2]]		* [[/smw_subs2]]

Woozle: brief explanations

2012-12-17T15:55:43Z

brief explanations

← Older revision		Revision as of 15:55, 17 December 2012
Line 1:		Line 1:
	==Tables==		==Tables==
	As of SMW version 1.7:		As of SMW version 1.7:
	* [[/smw_atts2]]		* [[/smw_atts2]]: relationships where the value is numerically/logically significant, or a "string" (non-page type)
	* [[/smw_conc2]]		* [[/smw_conc2]]
	* [[/smw_conccache]]		* [[/smw_conccache]]
	* [[/smw_ids]]		* [[/smw_ids]]: assigns IDs to all properties and some values
	* [[/smw_inst2]]		* [[/smw_inst2]]
	* [[/smw_redi2]]		* [[/smw_redi2]]
	* [[/smw_rels2]]		* [[/smw_rels2]]: relationships where the value refers to a hypothetical wiki page
	* [[/smw_spec2]]		* [[/smw_spec2]]
	* [[/smw_subp2]]		* [[/smw_subp2]]
	* [[/smw_subs2]]		* [[/smw_subs2]]
	* [[/smw_text2]]		* [[/smw_text2]]: relationships where the value is a long text/data blob
			==Explanations==
			* Semantic relationships are defined in [[/smw rels2]], [[/smw_text2]], and [[/smw_atts2]].
			* Correspondence between SMW entities (property names and some property values) and MediaWiki pages is defined in [[/smw_ids]]

Woozle: subpages, not pages

2012-01-22T20:52:50Z

subpages, not pages

← Older revision		Revision as of 20:52, 22 January 2012
Line 1:		Line 1:
	==Tables==		==Tables==
	As of SMW version 1.7:		As of SMW version 1.7:
	* [[smw_atts2]]		* [[/smw_atts2]]
	* [[smw_conc2]]		* [[/smw_conc2]]
	* [[smw_conccache]]		* [[/smw_conccache]]
	* [[smw_ids]]		* [[/smw_ids]]
	* [[smw_inst2]]		* [[/smw_inst2]]
	* [[smw_redi2]]		* [[/smw_redi2]]
	* [[smw_rels2]]		* [[/smw_rels2]]
	* [[smw_spec2]]		* [[/smw_spec2]]
	* [[smw_subp2]]		* [[/smw_subp2]]
	* [[smw_subs2]]		* [[/smw_subs2]]
	* [[smw_text2]]		* [[/smw_text2]]

Woozle: list of smw tables

2012-01-22T16:36:50Z

list of smw tables

New page

==Tables==
As of SMW version 1.7:
* [[smw_atts2]]
* [[smw_conc2]]
* [[smw_conccache]]
* [[smw_ids]]
* [[smw_inst2]]
* [[smw_redi2]]
* [[smw_rels2]]
* [[smw_spec2]]
* [[smw_subp2]]
* [[smw_subs2]]
* [[smw_text2]]