ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ObjectTypeQueryCount
2
Match (n:domain) return count(n); 1638461
3
AssetMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='Asset' return count(n);482094
4
AssetImageMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='AssetImage' return count(n);65
5
ContentMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='Content' return count(n);577506
6
ContentImage
Match (n:domain) where n.IL_FUNC_OBJECT_TYPE='ContentImage' return count(n);
6864
7
CollectionMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='Collection' return count(n); 63545
8
CollectionImage
Match (n:domain) where n.IL_FUNC_OBJECT_TYPE='CollectionImage' return count(n);
6073
9
QuestionMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='Question' return count(n);556
10
QuestionImage
Match (n:domain) where n.IL_FUNC_OBJECT_TYPE='QuestionImage' return count(n);
1
11
QuestionSetMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='QuestionSet' return count(n); 344
12
QuestionSetImage
Match (n:domain) where n.IL_FUNC_OBJECT_TYPE='QuestionSetImage' return count(n);
13
13
ItemMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='Item' return count(n);0
14
ItemImageMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='ItemImage' return count(n); 0
15
ItemSetMatch (n:domain) where n.IL_FUNC_OBJECT_TYPE='ItemSet' return count(n);8581
16
ItemSetImage
Match (n:domain) where n.IL_FUNC_OBJECT_TYPE='ItemSetImage' return count(n);
0
17
18
19
Match (n:domain) return distinct n.IL_FUNC_OBJECT_TYPE, count(n.IL_FUNC_OBJECT_TYPE) as count order by n.IL_FUNC_OBJECT_TYPE;
20
-------------------------------------------+
| n.IL_FUNC_OBJECT_TYPE | count |
+------------------------------------------+
| "Api" | 2 |
| "AssessmentItem" | 366970 |
| "AssessmentItemImage" | 2 |
| "Asset" | 482094 |
| "AssetImage" | 65 |
| "Category" | 10 |
| "CategoryInstance" | 356 |
| "Channel" | 137 |
| "Collection" | 63545 |
| "CollectionImage" | 6073 |
| "Concept" | 1477 |
| "Content" | 577506 |
| "ContentImage" | 6864 |
| "Dimension" | 47 |
| "Domain" | 7 |
| "Framework" | 77 |
| "ItemSet" | 8581 |
| "Language" | 18 |
| "Library" | 1 |
| "License" | 9 |
| "Method" | 46 |
| "Misconception" | 50 |
| "ObjectCategory" | 40 |
| "ObjectCategoryDefinition" | 177 |
| "ObjectCategoryDefinitionImage" | 1 |
| "Question" | 556 |
| "QuestionImage" | 1 |
| "QuestionSet" | 344 |
| "QuestionSetImage" | 13 |
| "Reference" | 5 |
| "Term" | 118966 |
| NULL | 0 |
+------------------------------------------+
21
22
Match (n:domain) return distinct n.mimeType, count(n.mimeType) as count order by n.mimeType;
23
-------------------------------------------------------+
| n.mimeType | count |
+------------------------------------------------------+
| "application/epub" | 1510 |
| "application/octet-stream" | 49100 |
| "application/pdf" | 140207 |
| "application/vnd.android.package-archive" | 264 |
| "application/vnd.ekstep.content-archive" | 99 |
| "application/vnd.ekstep.content-collection" | 111092 |
| "application/vnd.ekstep.ecml-archive" | 155747 |
| "application/vnd.ekstep.h5p-archive" | 6148 |
| "application/vnd.ekstep.html-archive" | 22482 |
| "application/vnd.ekstep.plugin-archive" | 245 |
| "application/vnd.sunbird.question" | 555 |
| "application/vnd.sunbird.questionset" | 355 |
| "audio/mp3" | 88768 |
| "audio/mp4" | 173 |
| "audio/mpeg" | 14488 |
| "audio/ogg" | 2839 |
| "audio/wav" | 21448 |
| "audio/x-wav" | 24 |
| "image/bmp" | 4 |
| "image/gif" | 20 |
| "image/jpeg" | 181648 |
| "image/jpg" | 90 |
| "image/png" | 113657 |
| "image/svg+xml" | 464 |
| "image/tiff" | 1 |
| "text/x-url" | 50 |
| "video/3gpp" | 6 |
| "video/mp4" | 168054 |
| "video/mpeg" | 2 |
| "video/quicktime" | 6 |
| "video/webm" | 2056 |
| "video/x-youtube" | 65752 |
| NULL | 0 |
+------------------------------------------------------+
24
25
Match (n:domain) return distinct n.mimeType, n.IL_FUNC_OBJECT_TYPE, count(n.mimeType) as count order by n.IL_FUNC_OBJECT_TYPE;
26
----------------------------------------------------------------------------------------+
| n.mimeType | n.IL_FUNC_OBJECT_TYPE | count |
+----------------------------------------------------------------------------------------+
| NULL | "Api" | 0 |
| "application/vnd.ekstep.ecml-archive" | "AssessmentItem" | 10452 |
| NULL | "AssessmentItem" | 0 |
| NULL | "AssessmentItemImage" | 0 |
| "video/mp4" | "Asset" | 8677 |
| "image/jpeg" | "Asset" | 181606 |
| "image/gif" | "Asset" | 20 |
| "video/webm" | "Asset" | 310 |
| "audio/ogg" | "Asset" | 2839 |
| "video/mpeg" | "Asset" | 2 |
| "audio/mp3" | "Asset" | 88381 |
| "image/tiff" | "Asset" | 1 |
| "video/quicktime" | "Asset" | 6 |
| "video/x-youtube" | "Asset" | 710 |
| "video/3gpp" | "Asset" | 6 |
| "image/png" | "Asset" | 113636 |
| "audio/x-wav" | "Asset" | 24 |
| NULL | "Asset" | 0 |
| "audio/mpeg" | "Asset" | 14488 |
| "audio/wav" | "Asset" | 21448 |
| "image/bmp" | "Asset" | 4 |
| "application/vnd.ekstep.ecml-archive" | "Asset" | 11 |
| "audio/mp4" | "Asset" | 173 |
| "application/octet-stream" | "Asset" | 49100 |
| "application/vnd.ekstep.content-archive" | "Asset" | 99 |
| "image/svg+xml" | "Asset" | 463 |
| "image/jpg" | "Asset" | 89 |
| "image/jpeg" | "AssetImage" | 42 |
| "video/mp4" | "AssetImage" | 1 |
| "image/png" | "AssetImage" | 21 |
| "image/svg+xml" | "AssetImage" | 1 |
| NULL | "Category" | 0 |
| NULL | "CategoryInstance" | 0 |
| NULL | "Channel" | 0 |
| NULL | "Collection" | 0 |
| "application/vnd.ekstep.content-collection" | "Collection" | 63544 |
| "application/vnd.ekstep.content-collection" | "CollectionImage" | 6072 |
| NULL | "CollectionImage" | 0 |
| "application/vnd.ekstep.ecml-archive" | "Concept" | 3 |
| NULL | "Concept" | 0 |
| "application/vnd.android.package-archive" | "Content" | 260 |
| "application/vnd.ekstep.content-collection" | "Content" | 41476 |
| "image/jpg" | "Content" | 1 |
| "application/epub" | "Content" | 1504 |
| "application/vnd.ekstep.h5p-archive" | "Content" | 6083 |
| "video/mp4" | "Content" | 158580 |
| "audio/mp3" | "Content" | 387 |
| "video/webm" | "Content" | 1734 |
| "application/pdf" | "Content" | 138818 |
| "video/x-youtube" | "Content" | 64759 |
| NULL | "Content" | 0 |
| "application/vnd.ekstep.plugin-archive" | "Content" | 210 |
| "application/vnd.ekstep.html-archive" | "Content" | 21953 |
| "text/x-url" | "Content" | 50 |
| "application/vnd.ekstep.ecml-archive" | "Content" | 141537 |
| "application/vnd.ekstep.h5p-archive" | "ContentImage" | 65 |
| "video/mp4" | "ContentImage" | 796 |
| "application/epub" | "ContentImage" | 6 |
| "video/webm" | "ContentImage" | 12 |
| "application/pdf" | "ContentImage" | 1389 |
| "video/x-youtube" | "ContentImage" | 283 |
| NULL | "ContentImage" | 0 |
| "application/vnd.android.package-archive" | "ContentImage" | 4 |
| "application/vnd.ekstep.html-archive" | "ContentImage" | 529 |
| "application/vnd.ekstep.plugin-archive" | "ContentImage" | 35 |
| "application/vnd.ekstep.ecml-archive" | "ContentImage" | 3744 |
| NULL | "Dimension" | 0 |
| NULL | "Domain" | 0 |
| NULL | "Framework" | 0 |
| NULL | "ItemSet" | 0 |
| NULL | "Language" | 0 |
| NULL | "Library" | 0 |
| NULL | "License" | 0 |
| NULL | "Method" | 0 |
| NULL | "Misconception" | 0 |
| NULL | "ObjectCategory" | 0 |
| NULL | "ObjectCategoryDefinition" | 0 |
| NULL | "ObjectCategoryDefinitionImage" | 0 |
| "application/vnd.sunbird.question" | "Question" | 555 |
| NULL | "Question" | 0 |
| NULL | "QuestionImage" | 0 |
| NULL | "QuestionSet" | 0 |
| "application/vnd.sunbird.questionset" | "QuestionSet" | 343 |
| "application/vnd.sunbird.questionset" | "QuestionSetImage" | 12 |
| NULL | "QuestionSetImage" | 0 |
| NULL | "Reference" | 0 |
| NULL | "Term" | 0 |
| NULL | NULL | 0 |
+----------------------------------------------------------------------------------------+
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100