Skip to content

Instantly share code, notes, and snippets.

@sean9999
Last active August 29, 2015 14:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sean9999/5b000a5bdfa709aec33c to your computer and use it in GitHub Desktop.
Save sean9999/5b000a5bdfa709aec33c to your computer and use it in GitHub Desktop.
people and cars

People and Cars

This Graph desrcribes a social network centered around files. The application’s mandate is to offer users the ability to organize and share files in an efficient, intuitive, and privacy-preserving way. Specifically, it allows users to:

  1. tag their own files

  2. share their files with friends

  3. tag files that have been shared to them by friends

  4. see tags that friends of friends have applied to files, but not have privacy state changed by this event

  5. share tags themselves, so that the shareability of files can be managed in sets

  6. share shares, so that a friend of a friend can see shares, thereby extending the reach of a resource

  7. limit shareability of a file by number of hops

create (_1:`Share` {`msg`:"just wanted to share this volvo with you", `z`:1403899617122})
create (_2:`Share` {`msg`:"hey there, im a message", `z`:1403903974317})
create (_9:`Share` {`msg`:"Milly, i want you to have this beamer", `z`:1403906438134})
create (_15:`Share` {`msg`:"hey alvin here- i want to share this tag with you, it only adds one file though", `z`:1403924803390})
create (_17:`Share` {`msg`:"will, i hope you enjoy my files pertaining to sportback", `z`:1403926710486})
create (_19:`Share` {`msg`:"edith, i want  you to see these sportbacks, as i do Will", `z`:1403927801940})
create (_22:`Share` {`msg`:"Edith, how do you like Opels?", `z`:1403927859264})
create (_26:`File` {`extension`:"pdf", `filename`:"bmw-cabrio.pdf", `hops`:100, `kind`:"file", `md5`:"9a347b77961a61e4ec759799c64e7833", `mimetype`:"application/pdf", `url`:"http://z.koomol.gourd.io/tmp/cars/bmw-cabrio.pdf"})
create (_113:`File` {`extension`:"png", `filename`:"BMW-M6-Convertible.png", `hops`:100, `kind`:"file", `md5`:"a06ebd95c4c3ebee618dee9c72555dc9", `mimetype`:"image/png", `url`:"http://z.koomol.gourd.io/tmp/cars2/BMW-M6-Convertible.png"})
create (_233:`File` {`extension`:"png", `filename`:"Citroen-C1-facelift.png", `hops`:100, `kind`:"file", `md5`:"650cfe1006f73fe492264bab0eb8095e", `mimetype`:"image/png", `url`:"http://z.koomol.gourd.io/tmp/cars2/Citroen-C1-facelift.png"})
create (_234:`File` {`extension`:"png", `filename`:"Opel-Adam-Cup.png", `hops`:100, `kind`:"file", `md5`:"6ed401f6af8758f0cf7714acd913866e", `mimetype`:"image/png", `url`:"http://z.koomol.gourd.io/tmp/cars2/Opel-Adam-Cup.png"})
create (_236:`File` {`extension`:"png", `filename`:"Audi-S3-Sportback.png", `hops`:100, `kind`:"file", `md5`:"76be5a76cc817f367cfa5b457a697ed4", `mimetype`:"image/png", `url`:"http://z.koomol.gourd.io/tmp/cars2/Audi-S3-Sportback.png"})
create (_253:`File` {`extension`:"png", `filename`:"Volvo-V60-Hybrid-Plug-in-facelift.png", `hops`:100, `kind`:"file", `md5`:"bc8b5b228312960ba8f319d3b5001001", `mimetype`:"image/png", `url`:"http://z.koomol.gourd.io/tmp/cars2/Volvo-V60-Hybrid-Plug-in-facelift.png"})
create (_271:`Word` {`word`:"tmp"})
create (_272:`Word` {`word`:"cars"})
create (_278:`Word` {`word`:"pdf"})
create (_280:`Word` {`word`:"audi"})
create (_282:`Word` {`word`:"cabrio"})
create (_285:`Word` {`word`:"volvo"})
create (_299:`Word` {`word`:"bmw"})
create (_312:`Word` {`word`:"v60"})
create (_313:`Word` {`word`:"plug"})
create (_322:`Word` {`word`:"sportback"})
create (_323:`Word` {`word`:"adam"})
create (_746:`Tag` {`word`:"tmp"})
create (_747:`Tag` {`word`:"cars"})
create (_750:`Tag` {`word`:"pdf"})
create (_752:`Tag` {`word`:"cabrio"})
create (_763:`Tag` {`word`:"bmw"})
create (_766:`Word` {`word`:"png"})
create (_782:`Word` {`word`:"cars2"})
create (_788:`Word` {`word`:"facelift"})
create (_977:`Word` {`word`:"convertible"})
create (_1030:`Word` {`word`:"citroen"})
create (_1045:`Word` {`word`:"opel"})
create (_1053:`Word` {`word`:"cup"})
create (_1067:`Word` {`word`:"hybrid"})
create (_1096:`Person` {`avatar`:"http://z.koomol.gourd.io/assets/random_avatars/113.png", `first_name`:"Mildred", `handle`:"skill1018", `kind`:"person", `last_name`:"Igou", `z`:1395605134})
create (_1097:`Person` {`avatar`:"http://z.koomol.gourd.io/assets/random_avatars/054.png", `first_name`:"Alvin", `handle`:"gland142", `kind`:"person", `last_name`:"Pietrok", `z`:1395605134})
create (_1098:`Person` {`avatar`:"http://z.koomol.gourd.io/assets/random_avatars/002.png", `first_name`:"Edith", `handle`:"punishing183", `kind`:"person", `last_name`:"Brimhall", `z`:1395605134})
create (_1099:`Person` {`avatar`:"http://z.koomol.gourd.io/assets/random_avatars/089.png", `first_name`:"Willard", `handle`:"little_wille", `kind`:"person", `last_name`:"Obanner", `z`:1395605134})
create (_1100:`Person` {`avatar`:"http://z.koomol.gourd.io/assets/random_avatars/078.png", `first_name`:"Edgar", `handle`:"edblum", `kind`:"person", `last_name`:"Blumenfeld", `z`:1395605134})
create (_1113:`Tag` {`word`:"tmp"})
create (_1114:`Tag` {`word`:"cars2"})
create (_1117:`Tag` {`word`:"facelift"})
create (_1118:`Tag` {`word`:"png"})
create (_1146:`Tag` {`word`:"bmw"})
create (_1149:`Tag` {`word`:"audi"})
create (_1188:`Tag` {`word`:"convertible"})
create (_1213:`Tag` {`word`:"citroen"})
create (_1218:`Tag` {`word`:"opel"})
create (_1221:`Tag` {`word`:"cup"})
create (_1227:`Tag` {`word`:"hybrid"})
create (_1236:`Tag` {`word`:"volvo"})
create (_1237:`Tag` {`word`:"v60"})
create (_1238:`Tag` {`word`:"plug"})
create (_1248:`Tag` {`word`:"sportback"})
create (_1249:`Tag` {`word`:"adam"})
create _1-[:`SHARETO`]->_1096
create _1-[:`MEMBERIS`]->_253
create _2-[:`SHARETO`]->_1096
create _2-[:`MEMBERIS`]->_233
create _9-[:`SHARETO`]->_1096
create _9-[:`MEMBERIS`]->_113
create _15-[:`SHARETO`]->_1096
create _15-[:`MEMBERIS`]->_763
create _17-[:`SHARETO`]->_1099
create _17-[:`MEMBERIS`]->_1248
create _19-[:`SHARETO`]->_1098
create _19-[:`MEMBERIS`]->_1248
create _22-[:`SHARETO`]->_1098
create _22-[:`MEMBERIS`]->_234
create _746-[:`OWNERIS`]->_1097
create _746-[:`FILEIS`]->_31
create _746-[:`FILEIS`]->_28
create _746-[:`FILEIS`]->_26
create _746-[:`FILEIS`]->_24
create _746-[:`FILEIS`]->_21
create _746-[:`FILEIS`]->_20
create _746-[:`FILEIS`]->_18
create _746-[:`FILEIS`]->_16
create _746-[:`FILEIS`]->_14
create _746-[:`FILEIS`]->_11
create _746-[:`FILEIS`]->_8
create _746-[:`FILEIS`]->_6
create _746-[:`FILEIS`]->_4
create _746-[:`FILEIS`]->_0
create _746-[:`FILEIS`]->_34
create _746-[:`WORDIS`]->_271
create _747-[:`OWNERIS`]->_1097
create _747-[:`FILEIS`]->_31
create _747-[:`FILEIS`]->_28
create _747-[:`FILEIS`]->_26
create _747-[:`FILEIS`]->_24
create _747-[:`FILEIS`]->_21
create _747-[:`FILEIS`]->_20
create _747-[:`FILEIS`]->_18
create _747-[:`FILEIS`]->_16
create _747-[:`FILEIS`]->_14
create _747-[:`FILEIS`]->_11
create _747-[:`FILEIS`]->_8
create _747-[:`FILEIS`]->_6
create _747-[:`FILEIS`]->_4
create _747-[:`FILEIS`]->_0
create _747-[:`FILEIS`]->_34
create _747-[:`WORDIS`]->_272
create _750-[:`OWNERIS`]->_1097
create _750-[:`FILEIS`]->_31
create _750-[:`FILEIS`]->_28
create _750-[:`FILEIS`]->_26
create _750-[:`FILEIS`]->_24
create _750-[:`FILEIS`]->_21
create _750-[:`FILEIS`]->_20
create _750-[:`FILEIS`]->_18
create _750-[:`FILEIS`]->_16
create _750-[:`FILEIS`]->_14
create _750-[:`FILEIS`]->_11
create _750-[:`FILEIS`]->_8
create _750-[:`FILEIS`]->_6
create _750-[:`FILEIS`]->_4
create _750-[:`FILEIS`]->_0
create _750-[:`FILEIS`]->_34
create _750-[:`WORDIS`]->_278
create _752-[:`OWNERIS`]->_1097
create _752-[:`FILEIS`]->_26
create _752-[:`FILEIS`]->_24
create _752-[:`FILEIS`]->_20
create _752-[:`FILEIS`]->_18
create _752-[:`FILEIS`]->_0
create _752-[:`WORDIS`]->_282
create _763-[:`OWNERIS`]->_1097
create _763-[:`FILEIS`]->_26
create _763-[:`WORDIS`]->_299
create _1097-[:`OWNS`]->_34
create _1097-[:`OWNS`]->_0
create _1097-[:`OWNS`]->_4
create _1097-[:`OWNS`]->_6
create _1097-[:`OWNS`]->_8
create _1097-[:`OWNS`]->_11
create _1097-[:`OWNS`]->_14
create _1097-[:`OWNS`]->_16
create _1097-[:`OWNS`]->_18
create _1097-[:`OWNS`]->_20
create _1097-[:`OWNS`]->_21
create _1097-[:`OWNS`]->_24
create _1097-[:`OWNS`]->_26
create _1097-[:`OWNS`]->_28
create _1097-[:`OWNS`]->_31
create _1097-[:`SHAREFROM`]->_15
create _1098-[:`OWNS`]->_306
create _1098-[:`OWNS`]->_303
create _1098-[:`OWNS`]->_301
create _1098-[:`OWNS`]->_300
create _1100-[:`OWNS`]->_298
create _1100-[:`OWNS`]->_296
create _1100-[:`OWNS`]->_294
create _1100-[:`OWNS`]->_289
create _1100-[:`OWNS`]->_286
create _1100-[:`OWNS`]->_283
create _1100-[:`OWNS`]->_281
create _1100-[:`OWNS`]->_279
create _1100-[:`OWNS`]->_276
create _1100-[:`OWNS`]->_274
create _1100-[:`OWNS`]->_273
create _1100-[:`OWNS`]->_270
create _1100-[:`OWNS`]->_268
create _1100-[:`OWNS`]->_265
create _1100-[:`OWNS`]->_262
create _1100-[:`OWNS`]->_260
create _1100-[:`OWNS`]->_257
create _1100-[:`OWNS`]->_63
create _1100-[:`OWNS`]->_59
create _1100-[:`OWNS`]->_55
create _1100-[:`OWNS`]->_50
create _1100-[:`OWNS`]->_47
create _1100-[:`OWNS`]->_44
create _1100-[:`OWNS`]->_36
create _1100-[:`OWNS`]->_94
create _1100-[:`OWNS`]->_91
create _1100-[:`OWNS`]->_89
create _1100-[:`OWNS`]->_86
create _1100-[:`OWNS`]->_81
create _1100-[:`OWNS`]->_78
create _1100-[:`OWNS`]->_75
create _1100-[:`OWNS`]->_74
create _1100-[:`OWNS`]->_70
create _1100-[:`OWNS`]->_66
create _1100-[:`OWNS`]->_125
create _1100-[:`OWNS`]->_122
create _1100-[:`OWNS`]->_116
create _1100-[:`OWNS`]->_113
create _1100-[:`OWNS`]->_111
create _1100-[:`OWNS`]->_109
create _1100-[:`OWNS`]->_105
create _1100-[:`OWNS`]->_102
create _1100-[:`OWNS`]->_99
create _1100-[:`OWNS`]->_97
create _1100-[:`OWNS`]->_159
create _1100-[:`OWNS`]->_157
create _1100-[:`OWNS`]->_156
create _1100-[:`OWNS`]->_153
create _1100-[:`OWNS`]->_151
create _1100-[:`OWNS`]->_149
create _1100-[:`OWNS`]->_147
create _1100-[:`OWNS`]->_143
create _1100-[:`OWNS`]->_141
create _1100-[:`OWNS`]->_138
create _1100-[:`OWNS`]->_135
create _1100-[:`OWNS`]->_132
create _1100-[:`OWNS`]->_190
create _1100-[:`OWNS`]->_187
create _1100-[:`OWNS`]->_186
create _1100-[:`OWNS`]->_184
create _1100-[:`OWNS`]->_180
create _1100-[:`OWNS`]->_177
create _1100-[:`OWNS`]->_174
create _1100-[:`OWNS`]->_172
create _1100-[:`OWNS`]->_167
create _1100-[:`OWNS`]->_164
create _1100-[:`OWNS`]->_161
create _1100-[:`OWNS`]->_223
create _1100-[:`OWNS`]->_222
create _1100-[:`OWNS`]->_221
create _1100-[:`OWNS`]->_217
create _1100-[:`OWNS`]->_214
create _1100-[:`OWNS`]->_210
create _1100-[:`OWNS`]->_207
create _1100-[:`OWNS`]->_205
create _1100-[:`OWNS`]->_203
create _1100-[:`OWNS`]->_201
create _1100-[:`OWNS`]->_200
create _1100-[:`OWNS`]->_198
create _1100-[:`OWNS`]->_194
create _1100-[:`OWNS`]->_192
create _1100-[:`OWNS`]->_253
create _1100-[:`OWNS`]->_252
create _1100-[:`OWNS`]->_248
create _1100-[:`OWNS`]->_246
create _1100-[:`OWNS`]->_243
create _1100-[:`OWNS`]->_241
create _1100-[:`OWNS`]->_239
create _1100-[:`OWNS`]->_236
create _1100-[:`OWNS`]->_234
create _1100-[:`OWNS`]->_233
create _1100-[:`OWNS`]->_230
create _1100-[:`OWNS`]->_228
create _1100-[:`OWNS`]->_225
create _1100-[:`SHAREFROM`]->_22
create _1100-[:`SHAREFROM`]->_19
create _1100-[:`SHAREFROM`]->_17
create _1100-[:`SHAREFROM`]->_9
create _1100-[:`SHAREFROM`]->_2
create _1100-[:`SHAREFROM` {`z`:1403899842696}]->_1
create _1113-[:`WORDIS`]->_271
create _1113-[:`OWNERIS`]->_1100
create _1113-[:`FILEIS`]->_225
create _1113-[:`FILEIS`]->_228
create _1113-[:`FILEIS`]->_230
create _1113-[:`FILEIS`]->_233
create _1113-[:`FILEIS`]->_234
create _1113-[:`FILEIS`]->_236
create _1113-[:`FILEIS`]->_239
create _1113-[:`FILEIS`]->_241
create _1113-[:`FILEIS`]->_243
create _1113-[:`FILEIS`]->_246
create _1113-[:`FILEIS`]->_248
create _1113-[:`FILEIS`]->_252
create _1113-[:`FILEIS`]->_253
create _1113-[:`FILEIS`]->_192
create _1113-[:`FILEIS`]->_194
create _1113-[:`FILEIS`]->_198
create _1113-[:`FILEIS`]->_200
create _1113-[:`FILEIS`]->_201
create _1113-[:`FILEIS`]->_203
create _1113-[:`FILEIS`]->_205
create _1113-[:`FILEIS`]->_207
create _1113-[:`FILEIS`]->_210
create _1113-[:`FILEIS`]->_214
create _1113-[:`FILEIS`]->_217
create _1113-[:`FILEIS`]->_221
create _1113-[:`FILEIS`]->_222
create _1113-[:`FILEIS`]->_223
create _1113-[:`FILEIS`]->_161
create _1113-[:`FILEIS`]->_164
create _1113-[:`FILEIS`]->_167
create _1113-[:`FILEIS`]->_172
create _1113-[:`FILEIS`]->_174
create _1113-[:`FILEIS`]->_177
create _1113-[:`FILEIS`]->_180
create _1113-[:`FILEIS`]->_184
create _1113-[:`FILEIS`]->_186
create _1113-[:`FILEIS`]->_187
create _1113-[:`FILEIS`]->_190
create _1113-[:`FILEIS`]->_132
create _1113-[:`FILEIS`]->_135
create _1113-[:`FILEIS`]->_138
create _1113-[:`FILEIS`]->_141
create _1113-[:`FILEIS`]->_143
create _1113-[:`FILEIS`]->_147
create _1113-[:`FILEIS`]->_149
create _1113-[:`FILEIS`]->_298
create _1113-[:`FILEIS`]->_296
create _1113-[:`FILEIS`]->_294
create _1113-[:`FILEIS`]->_289
create _1113-[:`FILEIS`]->_286
create _1113-[:`FILEIS`]->_283
create _1113-[:`FILEIS`]->_281
create _1113-[:`FILEIS`]->_279
create _1113-[:`FILEIS`]->_276
create _1113-[:`FILEIS`]->_274
create _1113-[:`FILEIS`]->_273
create _1113-[:`FILEIS`]->_270
create _1113-[:`FILEIS`]->_268
create _1113-[:`FILEIS`]->_265
create _1113-[:`FILEIS`]->_262
create _1113-[:`FILEIS`]->_260
create _1113-[:`FILEIS`]->_257
create _1113-[:`FILEIS`]->_63
create _1113-[:`FILEIS`]->_59
create _1113-[:`FILEIS`]->_55
create _1113-[:`FILEIS`]->_50
create _1113-[:`FILEIS`]->_47
create _1113-[:`FILEIS`]->_44
create _1113-[:`FILEIS`]->_36
create _1113-[:`FILEIS`]->_94
create _1113-[:`FILEIS`]->_91
create _1113-[:`FILEIS`]->_89
create _1113-[:`FILEIS`]->_86
create _1113-[:`FILEIS`]->_81
create _1113-[:`FILEIS`]->_78
create _1113-[:`FILEIS`]->_75
create _1113-[:`FILEIS`]->_74
create _1113-[:`FILEIS`]->_70
create _1113-[:`FILEIS`]->_66
create _1113-[:`FILEIS`]->_125
create _1113-[:`FILEIS`]->_122
create _1113-[:`FILEIS`]->_116
create _1113-[:`FILEIS`]->_113
create _1113-[:`FILEIS`]->_111
create _1113-[:`FILEIS`]->_109
create _1113-[:`FILEIS`]->_105
create _1113-[:`FILEIS`]->_102
create _1113-[:`FILEIS`]->_99
create _1113-[:`FILEIS`]->_97
create _1113-[:`FILEIS`]->_159
create _1113-[:`FILEIS`]->_157
create _1113-[:`FILEIS`]->_156
create _1113-[:`FILEIS`]->_153
create _1113-[:`FILEIS`]->_151
create _1114-[:`WORDIS`]->_782
create _1114-[:`OWNERIS`]->_1100
create _1114-[:`FILEIS`]->_225
create _1114-[:`FILEIS`]->_228
create _1114-[:`FILEIS`]->_230
create _1114-[:`FILEIS`]->_233
create _1114-[:`FILEIS`]->_234
create _1114-[:`FILEIS`]->_236
create _1114-[:`FILEIS`]->_239
create _1114-[:`FILEIS`]->_241
create _1114-[:`FILEIS`]->_243
create _1114-[:`FILEIS`]->_246
create _1114-[:`FILEIS`]->_248
create _1114-[:`FILEIS`]->_252
create _1114-[:`FILEIS`]->_253
create _1114-[:`FILEIS`]->_192
create _1114-[:`FILEIS`]->_194
create _1114-[:`FILEIS`]->_198
create _1114-[:`FILEIS`]->_200
create _1114-[:`FILEIS`]->_201
create _1114-[:`FILEIS`]->_203
create _1114-[:`FILEIS`]->_205
create _1114-[:`FILEIS`]->_207
create _1114-[:`FILEIS`]->_210
create _1114-[:`FILEIS`]->_214
create _1114-[:`FILEIS`]->_217
create _1114-[:`FILEIS`]->_221
create _1114-[:`FILEIS`]->_222
create _1114-[:`FILEIS`]->_223
create _1114-[:`FILEIS`]->_161
create _1114-[:`FILEIS`]->_164
create _1114-[:`FILEIS`]->_167
create _1114-[:`FILEIS`]->_172
create _1114-[:`FILEIS`]->_174
create _1114-[:`FILEIS`]->_177
create _1114-[:`FILEIS`]->_180
create _1114-[:`FILEIS`]->_184
create _1114-[:`FILEIS`]->_186
create _1114-[:`FILEIS`]->_187
create _1114-[:`FILEIS`]->_190
create _1114-[:`FILEIS`]->_132
create _1114-[:`FILEIS`]->_135
create _1114-[:`FILEIS`]->_138
create _1114-[:`FILEIS`]->_141
create _1114-[:`FILEIS`]->_143
create _1114-[:`FILEIS`]->_147
create _1114-[:`FILEIS`]->_149
create _1114-[:`FILEIS`]->_298
create _1114-[:`FILEIS`]->_296
create _1114-[:`FILEIS`]->_294
create _1114-[:`FILEIS`]->_289
create _1114-[:`FILEIS`]->_286
create _1114-[:`FILEIS`]->_283
create _1114-[:`FILEIS`]->_281
create _1114-[:`FILEIS`]->_279
create _1114-[:`FILEIS`]->_276
create _1114-[:`FILEIS`]->_274
create _1114-[:`FILEIS`]->_273
create _1114-[:`FILEIS`]->_270
create _1114-[:`FILEIS`]->_268
create _1114-[:`FILEIS`]->_265
create _1114-[:`FILEIS`]->_262
create _1114-[:`FILEIS`]->_260
create _1114-[:`FILEIS`]->_257
create _1114-[:`FILEIS`]->_63
create _1114-[:`FILEIS`]->_59
create _1114-[:`FILEIS`]->_55
create _1114-[:`FILEIS`]->_50
create _1114-[:`FILEIS`]->_47
create _1114-[:`FILEIS`]->_44
create _1114-[:`FILEIS`]->_36
create _1114-[:`FILEIS`]->_94
create _1114-[:`FILEIS`]->_91
create _1114-[:`FILEIS`]->_89
create _1114-[:`FILEIS`]->_86
create _1114-[:`FILEIS`]->_81
create _1114-[:`FILEIS`]->_78
create _1114-[:`FILEIS`]->_75
create _1114-[:`FILEIS`]->_74
create _1114-[:`FILEIS`]->_70
create _1114-[:`FILEIS`]->_66
create _1114-[:`FILEIS`]->_125
create _1114-[:`FILEIS`]->_122
create _1114-[:`FILEIS`]->_116
create _1114-[:`FILEIS`]->_113
create _1114-[:`FILEIS`]->_111
create _1114-[:`FILEIS`]->_109
create _1114-[:`FILEIS`]->_105
create _1114-[:`FILEIS`]->_102
create _1114-[:`FILEIS`]->_99
create _1114-[:`FILEIS`]->_97
create _1114-[:`FILEIS`]->_159
create _1114-[:`FILEIS`]->_157
create _1114-[:`FILEIS`]->_156
create _1114-[:`FILEIS`]->_153
create _1114-[:`FILEIS`]->_151
create _1117-[:`OWNERIS`]->_1100
create _1117-[:`FILEIS`]->_228
create _1117-[:`FILEIS`]->_233
create _1117-[:`FILEIS`]->_253
create _1117-[:`FILEIS`]->_194
create _1117-[:`FILEIS`]->_198
create _1117-[:`FILEIS`]->_221
create _1117-[:`FILEIS`]->_164
create _1117-[:`FILEIS`]->_172
create _1117-[:`FILEIS`]->_177
create _1117-[:`FILEIS`]->_184
create _1117-[:`FILEIS`]->_138
create _1117-[:`FILEIS`]->_149
create _1117-[:`FILEIS`]->_109
create _1117-[:`FILEIS`]->_111
create _1117-[:`FILEIS`]->_74
create _1117-[:`FILEIS`]->_36
create _1117-[:`FILEIS`]->_47
create _1117-[:`FILEIS`]->_265
create _1117-[:`FILEIS`]->_298
create _1117-[:`WORDIS`]->_788
create _1118-[:`WORDIS`]->_766
create _1118-[:`OWNERIS`]->_1100
create _1118-[:`FILEIS`]->_225
create _1118-[:`FILEIS`]->_228
create _1118-[:`FILEIS`]->_230
create _1118-[:`FILEIS`]->_233
create _1118-[:`FILEIS`]->_234
create _1118-[:`FILEIS`]->_236
create _1118-[:`FILEIS`]->_239
create _1118-[:`FILEIS`]->_241
create _1118-[:`FILEIS`]->_243
create _1118-[:`FILEIS`]->_246
create _1118-[:`FILEIS`]->_248
create _1118-[:`FILEIS`]->_252
create _1118-[:`FILEIS`]->_253
create _1118-[:`FILEIS`]->_192
create _1118-[:`FILEIS`]->_194
create _1118-[:`FILEIS`]->_198
create _1118-[:`FILEIS`]->_200
create _1118-[:`FILEIS`]->_201
create _1118-[:`FILEIS`]->_203
create _1118-[:`FILEIS`]->_205
create _1118-[:`FILEIS`]->_207
create _1118-[:`FILEIS`]->_210
create _1118-[:`FILEIS`]->_214
create _1118-[:`FILEIS`]->_217
create _1118-[:`FILEIS`]->_221
create _1118-[:`FILEIS`]->_222
create _1118-[:`FILEIS`]->_223
create _1118-[:`FILEIS`]->_161
create _1118-[:`FILEIS`]->_164
create _1118-[:`FILEIS`]->_167
create _1118-[:`FILEIS`]->_172
create _1118-[:`FILEIS`]->_174
create _1118-[:`FILEIS`]->_177
create _1118-[:`FILEIS`]->_180
create _1118-[:`FILEIS`]->_184
create _1118-[:`FILEIS`]->_186
create _1118-[:`FILEIS`]->_187
create _1118-[:`FILEIS`]->_190
create _1118-[:`FILEIS`]->_132
create _1118-[:`FILEIS`]->_135
create _1118-[:`FILEIS`]->_138
create _1118-[:`FILEIS`]->_141
create _1118-[:`FILEIS`]->_143
create _1118-[:`FILEIS`]->_147
create _1118-[:`FILEIS`]->_149
create _1118-[:`FILEIS`]->_298
create _1118-[:`FILEIS`]->_296
create _1118-[:`FILEIS`]->_294
create _1118-[:`FILEIS`]->_289
create _1118-[:`FILEIS`]->_286
create _1118-[:`FILEIS`]->_283
create _1118-[:`FILEIS`]->_281
create _1118-[:`FILEIS`]->_279
create _1118-[:`FILEIS`]->_276
create _1118-[:`FILEIS`]->_274
create _1118-[:`FILEIS`]->_273
create _1118-[:`FILEIS`]->_270
create _1118-[:`FILEIS`]->_268
create _1118-[:`FILEIS`]->_265
create _1118-[:`FILEIS`]->_262
create _1118-[:`FILEIS`]->_260
create _1118-[:`FILEIS`]->_257
create _1118-[:`FILEIS`]->_63
create _1118-[:`FILEIS`]->_59
create _1118-[:`FILEIS`]->_55
create _1118-[:`FILEIS`]->_50
create _1118-[:`FILEIS`]->_47
create _1118-[:`FILEIS`]->_44
create _1118-[:`FILEIS`]->_36
create _1118-[:`FILEIS`]->_94
create _1118-[:`FILEIS`]->_91
create _1118-[:`FILEIS`]->_89
create _1118-[:`FILEIS`]->_86
create _1118-[:`FILEIS`]->_81
create _1118-[:`FILEIS`]->_78
create _1118-[:`FILEIS`]->_75
create _1118-[:`FILEIS`]->_74
create _1118-[:`FILEIS`]->_70
create _1118-[:`FILEIS`]->_66
create _1118-[:`FILEIS`]->_125
create _1118-[:`FILEIS`]->_122
create _1118-[:`FILEIS`]->_116
create _1118-[:`FILEIS`]->_113
create _1118-[:`FILEIS`]->_111
create _1118-[:`FILEIS`]->_109
create _1118-[:`FILEIS`]->_105
create _1118-[:`FILEIS`]->_102
create _1118-[:`FILEIS`]->_99
create _1118-[:`FILEIS`]->_97
create _1118-[:`FILEIS`]->_159
create _1118-[:`FILEIS`]->_157
create _1118-[:`FILEIS`]->_156
create _1118-[:`FILEIS`]->_153
create _1118-[:`FILEIS`]->_151
create _1146-[:`OWNERIS`]->_1100
create _1146-[:`FILEIS`]->_248
create _1146-[:`FILEIS`]->_200
create _1146-[:`FILEIS`]->_141
create _1146-[:`FILEIS`]->_113
create _1146-[:`FILEIS`]->_81
create _1146-[:`FILEIS`]->_265
create _1146-[:`WORDIS`]->_299
create _1149-[:`OWNERIS`]->_1100
create _1149-[:`FILEIS`]->_236
create _1149-[:`FILEIS`]->_214
create _1149-[:`FILEIS`]->_184
create _1149-[:`FILEIS`]->_138
create _1149-[:`FILEIS`]->_149
create _1149-[:`FILEIS`]->_97
create _1149-[:`FILEIS`]->_94
create _1149-[:`FILEIS`]->_257
create _1149-[:`FILEIS`]->_260
create _1149-[:`WORDIS`]->_280
create _1188-[:`OWNERIS`]->_1100
create _1188-[:`FILEIS`]->_113
create _1188-[:`WORDIS`]->_977
create _1213-[:`OWNERIS`]->_1100
create _1213-[:`FILEIS`]->_228
create _1213-[:`FILEIS`]->_233
create _1213-[:`FILEIS`]->_180
create _1213-[:`WORDIS`]->_1030
create _1218-[:`OWNERIS`]->_1100
create _1218-[:`FILEIS`]->_234
create _1218-[:`FILEIS`]->_203
create _1218-[:`FILEIS`]->_222
create _1218-[:`FILEIS`]->_167
create _1218-[:`WORDIS`]->_1045
create _1221-[:`OWNERIS`]->_1100
create _1221-[:`FILEIS`]->_234
create _1221-[:`FILEIS`]->_167
create _1221-[:`WORDIS`]->_1053
create _1227-[:`OWNERIS`]->_1100
create _1227-[:`FILEIS`]->_253
create _1227-[:`FILEIS`]->_214
create _1227-[:`WORDIS`]->_1067
create _1236-[:`OWNERIS`]->_1100
create _1236-[:`FILEIS`]->_243
create _1236-[:`FILEIS`]->_253
create _1236-[:`WORDIS`]->_285
create _1237-[:`OWNERIS`]->_1100
create _1237-[:`FILEIS`]->_253
create _1237-[:`WORDIS`]->_312
create _1238-[:`OWNERIS`]->_1100
create _1238-[:`FILEIS`]->_253
create _1238-[:`WORDIS`]->_313
create _1248-[:`OWNERIS`]->_1100
create _1248-[:`FILEIS`]->_236
create _1248-[:`WORDIS`]->_322
create _1249-[:`OWNERIS`]->_1100
create _1249-[:`FILEIS`]->_234
create _1249-[:`WORDIS`]->_323
MATCH (a)-[r]->(b)
WHERE labels(a) <> [] AND labels(b) <> []
RETURN DISTINCT head(labels(a)) AS This, type(r) as To, head(labels(b)) AS That
LIMIT 10

users and their files

MATCH (u:Person)-[:OWNS]-(f:File)
RETURN u.first_name AS user, COUNT(f) AS n,COLLECT(f.filename) AS files

Files and their tags

MATCH (f:File)--(t:Tag)
RETURN f.filename AS filename, COLLECT(DISTINCT t.word) AS tags

Tags and their cardinality

MATCH (w:Word)<-[:WORDIS]-(t:Tag)-[:FILEIS]->(f:File)
RETURN w.word, COUNT(DISTINCT(t)) AS n_tags, COUNT(DISTINCT(f)) AS n_files
ORDER BY n_tags DESC, n_files DESC

who shared what?

MATCH (p:Person)
OPTIONAL MATCH (p)-[shareouts:SHAREFROM]->()
OPTIONAL MATCH (p)<-[shareins:SHARETO]-()
OPTIONAL MATCH (p)-[:OWNS]-(f:File)
OPTIONAL MATCH (p)<-[:OWNERIS]-(t:Tag)
RETURN p.first_name,COUNT(DISTINCT f) AS own_files,COUNT(DISTINCT t) AS own_tags,COUNT(DISTINCT shareouts) AS shareouts,COUNT(DISTINCT shareins) AS shareins
ORDER BY own_files DESC,own_tags DESC,shareouts DESC,shareins DESC

Console

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment