MYSQL

CARDINALITY OF ASSOCIATIONS

GENERAL

synset having N words (1..28)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(wordid) AS N FROM synsets LEFT JOIN senses USING(synsetid) GROUP BY synsetid) AS C

MIN(N)	MAX(N)
1	28

word having N synset (1..75)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid) AS N FROM words LEFT JOIN senses USING(wordid) GROUP BY wordid) AS C

MIN(N)	MAX(N)
1	75

MORPHOLOGY

morph having N words (1..3)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(wordid) AS N FROM morphs LEFT JOIN morphmaps USING(morphid) GROUP BY morphid) AS C

MIN(N)	MAX(N)
1	3

word having N morphs (0..7)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(morphid) AS N FROM words LEFT JOIN morphmaps USING(wordid) GROUP BY wordid) AS C

MIN(N)	MAX(N)
0	7

VERBFRAMES

sense having N vframes (0..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(frameid) AS N FROM senses LEFT JOIN vframemaps USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	8

vframe having N senses (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vframes LEFT JOIN vframemaps USING(frameid) GROUP BY frameid) AS C

MIN(N)	MAX(N)
5	13205

VERBFRAMES SENTENCES

sense having N vframesentences (0..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(sentenceid) AS N FROM senses LEFT JOIN vframesentencemaps USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	4

vframesentences having N senses (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vframesentences LEFT JOIN vframesentencemaps USING(sentenceid) GROUP BY sentenceid) AS C

MIN(N)	MAX(N)
0	295

LEGACY SYNSETS

synsets21

SELECT COUNT(*) FROM synsets21

COUNT(*)
117102

synsets20

SELECT COUNT(*) FROM synsets20

COUNT(*)
114731

LEGACY SENSEMAPS

senses30 having N senses20 (1..5)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(*) AS N FROM senses LEFT JOIN sensemaps2030 USING(wordid,synsetid) GROUP BY wordid,synsetid) AS C

MIN(N)	MAX(N)
1	5

senses20 having N senses30 ()

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM senses20 LEFT JOIN sensemaps2030 USING(wordid,synsetid) GROUP BY wordid,synsetid) AS C

MIN(N)	MAX(N)
1	1

LEGACY SYNSETMAPS

synsets having N synsets21 (0..5)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid2) AS N FROM synsets LEFT JOIN synsetmaps2130 USING(synsetid) GROUP BY synsetid) AS C

MIN(N)	MAX(N)
0	5

synsets having N synsets20 (0..7)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid2) AS N FROM synsets LEFT JOIN synsetmaps2030 USING(synsetid) GROUP BY synsetid) AS C

MIN(N)	MAX(N)
0	7

synsets21 having N synsets30 (1..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid) N FROM synsetmaps2130 GROUP BY synsetid2) AS C

MIN(N)	MAX(N)
1	8

synsets20 having N synsets30 (1..8)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(synsetid) N FROM synsetmaps2030 GROUP BY synsetid2) AS C

MIN(N)	MAX(N)
1	8

VERBNET : CLASSES

words having N vnclasses (0..10)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(classid) AS N FROM words LEFT JOIN vnclassmembers USING(wordid) GROUP BY wordid) AS C

MIN(N)	MAX(N)
0	10

vnclasses having N words (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(wordid) AS N FROM vnclasses LEFT JOIN vnclassmembers USING(classid) GROUP BY classid) AS C

MIN(N)	MAX(N)
0	373

VERBNET : FRAMES

sense having N vnframes (0..37)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(frameid) AS N FROM senses LEFT JOIN vnframemaps USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	37

frame having N senses (1..801)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vnframes LEFT JOIN vnframemaps USING(frameid) GROUP BY frameid) AS C

MIN(N)	MAX(N)
0	660

VERBNET : ROLES

sense having N vnroles (0..14)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(roleid) AS N FROM senses LEFT JOIN vnrolemaps USING(wordid,synsetid) GROUP BY synsetid,wordid) AS C

MIN(N)	MAX(N)
0	14

vnrole having N senses (2..1901)

SELECT MIN(N),MAX(N) FROM ( SELECT COUNT(CONCAT(wordid,synsetid)) AS N FROM vnroles LEFT JOIN vnrolemaps USING(roleid) GROUP BY roleid) AS C

MIN(N)	MAX(N)
0	1756