OmegaWiki - Revision history

Kipcool: +link to database documentation

2011-07-14T11:49:13Z

+link to database documentation

GerardM at 19:26, 30 July 2007

2007-07-30T19:26:19Z

Francis Tyers: /* Retrieving a list of lemmata that match a POS tag */

2007-07-30T17:25:30Z

Retrieving a list of lemmata that match a POS tag

Francis Tyers: /* Retrieve a list of translations */

2007-07-30T16:16:50Z

Retrieve a list of translations

Francis Tyers: /* Retrieve a list of translations */

2007-07-30T16:10:59Z

Retrieve a list of translations

Francis Tyers: /* Retrieve a list of translations */

2007-07-30T16:07:24Z

Retrieve a list of translations

Francis Tyers: /* Retrieving a list of lemmata that match a POS tag */

2007-07-30T16:06:45Z

Retrieving a list of lemmata that match a POS tag

Francis Tyers at 12:48, 30 July 2007

2007-07-30T12:48:09Z

Francis Tyers: /* Retrieving a list of lemmata that match a POS tag */

2007-07-30T12:10:55Z

Retrieving a list of lemmata that match a POS tag

Francis Tyers: /* Retrieving a list of lemmata that match a POS tag */

2007-07-30T11:54:01Z

Retrieving a list of lemmata that match a POS tag

← Older revision		Revision as of 11:49, 14 July 2011
Line 1:		Line 1:
	The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it. You might want to read [http://www.omegawiki.org/~~DefinedMeaning~~ ~~this]~~ for a description of "DefinedMeaning".		The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it. You might want to read [http://www.omegawiki.org/Help:OmegaWiki_database_layout the documentation for the OmegaWiki database] and [http://www.omegawiki.org/DefinedMeaning this description of "DefinedMeaning"].

	==Retrieving a list of POS tags==		==Retrieving a list of POS tags==

← Older revision		Revision as of 19:26, 30 July 2007
Line 1:		Line 1:
	The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it. You might want to read [http://www.omegawiki.org/DefinedMeaning this] for a description of "~~Defined Meaning~~".		The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it. You might want to read [http://www.omegawiki.org/DefinedMeaning this] for a description of "DefinedMeaning".

	==Retrieving a list of POS tags==		==Retrieving a list of POS tags==

@@ Line 44: / Line 44: @@
 So, lets retrieve all Welsh nouns!
-First retrive the <code>option_id</code> of the POS tag from the <code>uw_option_attribute_options</code> table:
+First retrieve the <code>option_id</code> of the POS tag from the <code>uw_option_attribute_options</code> table:
 Remember, <code>option_mid</code> is the defined meaning of the part of speech that you want, in this case '5612' is "noun".

@@ Line 112: / Line 112: @@
 |       438194 |             437893 |                 1 | French        | affaire   |
 +--------------+--------------------+-------------------+---------------+-----------+
 </pre>
 The <code>identical_meaning</code> flag means that the meaning of the words is thought to be identical in each language.
+You can reduce this to your two languages that you want with a further constraint (note, 85 = English, 153 = Welsh):
+<pre>
+mysql> select syntrans_sid,defined_meaning_id,identical_meaning,language_name,spelling
+    -> from uw_syntrans,uw_expression_ns,language_names
+    -> where defined_meaning_id = '437893'
+    -> and uw_expression_ns.expression_id = uw_syntrans.expression_id
+    -> and language_names.language_id = uw_expression_ns.language_id
+    -> and language_names.name_language_id = '85'
+    -> and (uw_expression_ns.language_id = '85' or uw_expression_ns.language_id = '153');
++-------------------+---------------+----------+
+| identical_meaning | language_name | spelling |
++-------------------+---------------+----------+
+|                 1 | English       | bargain  |
+|                 1 | Welsh         | bargen   |
++-------------------+---------------+----------+
+</pre>

@@ Line 95: / Line 95: @@
 <pre>
-mysql> select syntrans_sid,defined_meaning_id,defined_meaning_id,identical_meaning,language_name,spelling
+mysql> select syntrans_sid,defined_meaning_id,identical_meaning,language_name,spelling
     -> from uw_syntrans,uw_expression_ns,language_names
     -> where defined_meaning_id = '437893'
@@ Line 101: / Line 101: @@
     -> and language_names.language_id = uw_expression_ns.language_id
     -> and language_names.name_language_id = '85';
-+--------------+--------------------+--------------------+-------------------+---------------+-----------+
++--------------+--------------------+-------------------+---------------+-----------+
-| syntrans_sid | defined_meaning_id | defined_meaning_id | identical_meaning | language_name | spelling  |
+| syntrans_sid | defined_meaning_id | identical_meaning | language_name | spelling  |
-+--------------+--------------------+--------------------+-------------------+---------------+-----------+
++--------------+--------------------+-------------------+---------------+-----------+
-|       437894 |             437893 |             437893 |                 1 | English       | bargain   |
+|       437894 |             437893 |                 1 | English       | bargain   |
-|       437897 |             437893 |             437893 |                 1 | Dutch         | koopje    |
+|       437897 |             437893 |                 1 | Dutch         | koopje    |
-|       437898 |             437893 |             437893 |                 1 | French        | occasion  |
+|       437898 |             437893 |                 1 | French        | occasion  |
-|       437900 |             437893 |             437893 |                 1 | Japanese      | お買得     |
+|       437900 |             437893 |                 1 | Japanese      | お買得     |
-|       437902 |             437893 |             437893 |                 1 | Castilian     | ganga     |
+|       437902 |             437893 |                 1 | Castilian     | ganga     |
-|       437904 |             437893 |             437893 |                 1 | Welsh         | bargen    |
+|       437904 |             437893 |                 1 | Welsh         | bargen    |
-|       438194 |             437893 |             437893 |                 1 | French        | affaire   |
+|       438194 |             437893 |                 1 | French        | affaire   |
-+--------------+--------------------+--------------------+-------------------+---------------+-----------+
++--------------+--------------------+-------------------+---------------+-----------+
 </pre>

← Older revision		Revision as of 12:48, 30 July 2007
Line 1:		Line 1:
	The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it.		The OmegaWiki database layout is pretty dreadful, hopefully this will make things slightly easier for anyone brave enough to look near it. You might want to read [http://www.omegawiki.org/DefinedMeaning this] for a description of "Defined Meaning".

	==Retrieving a list of POS tags==		==Retrieving a list of POS tags==

@@ Line 69: / Line 69: @@
     -> and uw_syntrans.syntrans_sid = uw_option_attribute_values.object_id
     -> and uw_defined_meaning.defined_meaning_id = uw_syntrans.defined_meaning_id
-    -> and uw_expression_ns.expression_id = uw_defined_meaning.expression_id;
+    -> and uw_expression_ns.expression_id = uw_syntrans.expression_id;
-+----------+-----------+--------------------+-------------+
++----------+-----------+--------------------+--------------+
-| value_id | object_id | defined_meaning_id | spelling    |
+| value_id | object_id | defined_meaning_id | spelling     |
-+----------+-----------+--------------------+-------------+
++----------+-----------+--------------------+--------------+
-|   438988 |    438983 |               5930 | skill       |
+|   437913 |    437904 |             437893 | bargen       |
-|   437913 |    437904 |             437893 | bargain     |
+|   438025 |    438006 |             437948 | methdaliad   |
-|   438025 |    438006 |             437948 | bankruptcy  |
+|   438988 |    438983 |               5930 | gallu        |
-|   439078 |    439059 |             439017 | chassis     |
+|   439078 |    439059 |             439017 | siasi        |
-|   439079 |    439061 |             439017 | chassis     |
+|   439079 |    439061 |             439017 | ffrâm        |
-|   440330 |    440318 |             440185 | diplomat    |
+|   440330 |    440318 |             440185 | diplomydd    |
-|   442533 |    442508 |             442442 | defendant   |
+|   442533 |    442508 |             442442 | diffynnydd   |
-|   444812 |    444805 |             444787 | taxpayer    |
+|   444812 |    444805 |             444787 | trethdalwr   |
-|   444887 |    444874 |             444834 | traditional |
+|   444887 |    444874 |             444834 | traddodiadol |
-|   473807 |    473789 |             473754 | equilibrium |
+|   473807 |    473789 |             473754 | cydbwysedd   |
-|   474801 |    474791 |             474762 | enterprise  |
+|   474801 |    474791 |             474762 | menter       |
-|   475455 |    475442 |             475412 | volunteer   |
+|   475455 |    475442 |             475412 | gwirfoddolwr |
-+----------+-----------+--------------------+-------------+
++----------+-----------+--------------------+--------------+
 </pre>

@@ Line 87: / Line 87: @@
 +----------+-----------+--------------------+-------------+
 </pre>
+This assumes that the <code>syntrans_sid</code> is the same as the <code>uw_option_attribute_values.object_id</code> which may not always be the case.