OrientDB应用举例-Social

作者: jiaxiaolei | 来源:发表于2017-12-25 21:04 被阅读56次

基础信息

orientdb console: v2.2.31
gremlin v2.6.0
orientdb api: 2.2.x

ip: 172.28.26.214:2480

先看一个效果展示：

image.png


orientdb {db=social}> select * from V;

+----+------+---------+-------+-------+-------+--------+--------+---------+---------+--
-------+---------+---------+---------+---------+---------+---------+---------+---------
+
|#   |@RID  |@CLASS   |out_Eat|type   |in_Eat |in_Loves|in_Twins|name     |in_Friend|ou
t_Twins|out_WrokI|out_Frien|out_Study|in_Classm|out_Loves|out_Class|in_WrokIn|in_StudyI
|
+----+------+---------+-------+-------+-------+--------+--------+---------+---------+--
-------+---------+---------+---------+---------+---------+---------+---------+---------
+
|0   |#26:0 |Person   |[#58:0]|       |       |        |        |Luca     |         |
       |         |         |         |         |         |         |         |
|
|1   |#27:0 |Person   |       |       |       |        |        |Bill     |         |
       |         |         |         |         |         |         |         |
|
|2   |#28:0 |Person   |       |       |       |        |        |Jay      |         |
       |         |         |         |         |         |         |         |
|
|3   |#34:0 |Teacher  |       |       |       |[#99:0] |        |Miss Li  |         |
       |[#139:0] |         |         |         |         |         |         |
|
|4   |#35:0 |Teacher  |       |       |       |        |        |Mr Luo   |         |
       |[#138:0] |         |         |         |         |         |         |
|
|5   |#42:0 |Student  |       |       |       |        |        |LiLei    |         |
       |         |[#82:0]  |[#130:0] |         |[#98:0...|[#90:0]  |         |
|
|6   |#43:0 |Student  |       |       |       |[#98:0] |        |LiMin    |[#82:0]  |
       |         |         |         |[#90:0]  |         |         |         |
|
|7   |#44:0 |Student  |       |       |       |        |        |HanMeimei|         |
       |         |         |[#131:0] |         |         |         |         |         |
|8   |#45:0 |Student  |       |       |       |        |        |Lucy     |         |[#106:0] |         |         |         |         |         |[#91:0]  |         |         |
|9   |#46:0 |Student  |       |       |       |        |[#106:0]|Lily     |         |         |         |         |         |[#91:0]  |         |         |         |         |
|10  |#50:0 |Restau...|       |Pizza  |[#58:0]|        |        |Dante    |         |         |         |         |         |         |         |         |         |         |
|11  |#51:0 |Restau...|       |French |       |        |        |Charlie  |         |         |         |         |         |         |         |         |         |         |
|12  |#114:0|School   |       |Junior |       |        |        |No.2     |         |         |         |         |         |         |         |         |[#138:...|[#130:...|
+----+------+---------+-------+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+

13 item(s) found. Query executed in 0.001 sec(s).

orientdb {db=social}> select * from E;

+----+------+---------+-----+------+
|#   |@RID  |@CLASS   |out  |in    |
+----+------+---------+-----+------+
|0   |#58:0 |Eat      |#26:0|#50:0 |
|1   |#82:0 |Friend   |#42:0|#43:0 |
|2   |#90:0 |Classmate|#42:0|#43:0 |
|3   |#91:0 |Classmate|#45:0|#46:0 |
|4   |#98:0 |Loves    |#42:0|#43:0 |
|5   |#99:0 |Loves    |#42:0|#34:0 |
|6   |#106:0|Twins    |#45:0|#46:0 |
|7   |#130:0|StudyIn  |#42:0|#114:0|
|8   |#131:0|StudyIn  |#44:0|#114:0|
|9   |#138:0|WrokIn   |#35:0|#114:0|
|10  |#139:0|WrokIn   |#34:0|#114:0|
+----+------+---------+-----+------+

11 item(s) found. Query executed in 0.002 sec(s).

建立一个social 的 database.

storage type: plocal
database type: graph

image.png

连接：

orientdb> connect remote:localhost/social root root

Connecting to database [remote:localhost/social] with user 'root'...OK

建立一个顶点 Person

orientdb {db=social}>  CREATE CLASS Person EXTENDS V

Class created successfully. Total classes in database now: 12.

NOTE: 建立一个Vertex class Teacher

orientdb {db=social}>  CREATE CLASS Teacher EXTENDS V, Person

Class created successfully. Total classes in database now: 19.

NOTE: 建立一个Vertex class Student

orientdb {db=social}>  CREATE CLASS Student  EXTENDS V, Person

Class created successfully. Total classes in database now: 20.

建立 Restaurant

orientdb {db=social}> CREATE CLASS Restaurant EXTENDS V

Class created successfully. Total classes in database now: 13.

建立 school

orientdb {db=social}> CREATE CLASS School EXTENDS V

Class created successfully. Total classes in database now: 23.

建立 Person 下的记录， Luca, Bill, Jay

orientdb {db=social}> CREATE VERTEX Person SET name='Luca'

Created vertex 'Person#26:0{name:Luca} v1' in 0.073000 sec(s).

orientdb {db=social}> CREATE VERTEX Person SET name='Bill'

Created vertex 'Person#27:0{name:Bill} v1' in 0.009000 sec(s).

orientdb {db=social}> CREATE VERTEX Person SET name='Jay'

Created vertex 'Person#28:0{name:Jay} v1' in 0.023000 sec(s).

建立 Teacher: Miss Li, Mr Luo

orientdb {db=social}> CREATE VERTEX Teacher SET name='Miss Li'

Created vertex 'Teacher#82:0{name:Miss Li} v1' in 0.055000 sec(s).

orientdb {db=social}> CREATE VERTEX Teacher SET name='Mr Luo'

Created vertex 'Teacher#83:0{name:Mr Luo} v1' in 0.014000 sec(s).

建立 Teacher: LiLei, LiMin, HanMeiMei,Lily, Lucy

orientdb {db=social}>  CREATE VERTEX Student SET name='LiLei'

Created vertex 'Student#90:0{name:LiLei} v1' in 0.028000 sec(s).

orientdb {db=social}>  CREATE VERTEX Student SET name='LiMin'

Created vertex 'Student#91:0{name:LiMin} v1' in 0.038000 sec(s).

orientdb {db=social}>  CREATE VERTEX Student SET name='HanMeimei'

Created vertex 'Student#92:0{name:HanMeimei} v1' in 0.021000 sec(s).


orientdb {db=social}>   CREATE VERTEX Student SET name='Lucy'

Created vertex 'Student#45:0{name:Lucy} v1' in 0.002000 sec(s).


orientdb {db=social}>  CREATE VERTEX Student SET name='Lily'

Created vertex 'Student#46:0{name:Lily} v1' in 0.001000 sec(s).

NOTE: 建立Restaurant 的记录， Dante, Charlie

orientdb {db=social}>  CREATE VERTEX Restaurant SET name='Dante', type='Pizza'

Created vertex 'Restaurant#34:0{name:Dante,type:Pizza} v1' in 0.043000 sec(s).

orientdb {db=social}> CREATE VERTEX Restaurant SET name='Charlie', type='French'

Created vertex 'Restaurant#35:0{name:Charlie,type:French} v1' in 0.070000 sec(s).

NOTE: 建立School 的记录， NO.2

orientdb {db=social}> CREATE VERTEX School SET name='No.2', type='Junior '

Created vertex 'School#114:0{name:No.2,type:Junior } v1' in 0.001000 sec(s).

NOTE: 建立关系 Eat

orientdb {db=social}> CREATE CLASS Eat EXTENDS E

Class created successfully. Total classes in database now: 14.

NOTE: 建立关系 love

orientdb {db=social}> CREATE CLASS Love EXTENDS E

Class created successfully. Total classes in database now: 15.

NOTE: 建立关系 Know

orientdb {db=social}> CREATE CLASS Know EXTENDS E

Class created successfully. Total classes in database now: 16.

NOTE: 建立关系 Friend

orientdb {db=social}> CREATE CLASS Friend EXTENDS E, Know

Class created successfully. Total classes in database now: 17.

NOTE: 建立关系 Classmate

orientdb {db=social}> CREATE CLASS Classmate  EXTENDS E, Know

Class created successfully. Total classes in database now: 18.

NOTE: 建立关系 Loves

orientdb {db=social}> CREATE CLASS Loves  EXTENDS E, Know

Class created successfully. Total classes in database now: 21.

NOTE: 建立关系 Twins

orientdb {db=social}>  CREATE CLASS Twins  EXTENDS E, Know

Class created successfully. Total classes in database now: 22.

NOTE: 建立关系 WorkIn

orientdb {db=social}> CREATE CLASS WorkIN  EXTENDS E

Class created successfully. Total classes in database now: 24.

NOTE: 建立关系 StudyIn

orientdb {db=social}> CREATE CLASS StudyIn  EXTENDS E

Class created successfully. Total classes in database now: 25.

NOTE: 建立一个Map: Luca Eat Dante

orientdb {db=social}>  create EDGE Eat from (select from Person where name = 'Luca') to (select from Restaurant where name = 'Dante');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#42:0|Eat   |#26:0|#34:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.014000 sec(s).

LiLei Friend Limin

orientdb {db=social}> create EDGE Friend from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#82:0|Friend|#42:0|#43:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.003000 sec(s).

NOTE: LiLei Loves LiMin

orientdb {db=social}> create EDGE Loves from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+------+-----+-----+
|# |@RID |@CLASS|out |in |
+----+-----+------+-----+-----+
|0 |#98:0|Loves |#42:0|#43:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: LiLei Classmate LiMin

orientdb {db=social}> create EDGE Classmate from (select from Student where name = 'LiLei') to (select from Student where name = 'LiMin');

+----+-----+---------+-----+-----+
|#   |@RID |@CLASS   |out  |in   |
+----+-----+---------+-----+-----+
|0   |#90:0|Classmate|#42:0|#43:0|
+----+-----+---------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: LiLei Loves Miss Li

orientdb {db=social}> create EDGE Loves from (select from Student where name = 'LiLei') to (select from Teacher where name = 'Miss Li');

+----+-----+------+-----+-----+
|#   |@RID |@CLASS|out  |in   |
+----+-----+------+-----+-----+
|0   |#99:0|Loves |#42:0|#34:0|
+----+-----+------+-----+-----+
Created '1' edges in 0.003000 sec(s).

NOTE: 建立一个Map: Lucy Twins Lily

orientdb {db=social}> create EDGE Twins from (select from Student where name = 'Lucy') to (select from Student where name = 'Lily');

+----+------+------+-----+-----+
|#   |@RID  |@CLASS|out  |in   |
+----+------+------+-----+-----+
|0   |#106:0|Twins |#45:0|#46:0|
+----+------+------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一个Map: Lucy Classmate Lily

orientdb {db=social}> create EDGE Classmate from (select from Student where name = 'Lucy') to (select from Student where name = 'Lily');

+----+-----+---------+-----+-----+
|#   |@RID |@CLASS   |out  |in   |
+----+-----+---------+-----+-----+
|0   |#91:0|Classmate|#45:0|#46:0|
+----+-----+---------+-----+-----+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一个Map: LiLei StudyIn NO2

orientdb {db=social}> create EDGE StudyIn from (select from Student where name = 'LiLei') to (select from School where name = 'No.2');

+----+------+-------+-----+------+
|#   |@RID  |@CLASS |out  |in    |
+----+------+-------+-----+------+
|0   |#130:0|StudyIn|#42:0|#114:0|
+----+------+-------+-----+------+
Created '1' edges in 0.002000 sec(s).

NOTE: 建立一个Map: HanMeiMei StudyIn NO2

orientdb {db=social}> create EDGE StudyIn from (select from Student where name = 'HanMeimei') to (select from School where name = 'No.2');

+----+------+-------+-----+------+
|#   |@RID  |@CLASS |out  |in    |
+----+------+-------+-----+------+
|0   |#131:0|StudyIn|#44:0|#114:0|
+----+------+-------+-----+------+
Created '1' edges in 0.003000 sec(s).

NOTE: 建立一个Map: Mr Luo WrokIn NO2

orientdb {db=social}> create EDGE WrokIn from (select from Teacher where name = 'Mr Luo') to (select from School where name = 'No.2');

+----+------+------+-----+------+
|#   |@RID  |@CLASS|out  |in    |
+----+------+------+-----+------+
|0   |#138:0|WrokIn|#35:0|#114:0|
+----+------+------+-----+------+
Created '1' edges in 0.045000 sec(s).

NOTE: 建立一个Map: Miss Li WrokIn NO2

orientdb {db=social}> create EDGE WrokIn from (select from Teacher where name = 'Miss Li') to (select from School where name = 'No.2');

+----+------+------+-----+------+
|#   |@RID  |@CLASS|out  |in    |
+----+------+------+-----+------+
|0   |#139:0|WrokIn|#34:0|#114:0|
+----+------+------+-----+------+
Created '1' edges in 0.002000 sec(s).

查询

查看有几个Person

这里可以把Person 的子类 Teacher, Student 查出来。

orientdb {db=social}> select * from Person;

+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+
|#   |@RID |@CLASS |out_Eat|in_Loves|in_Twins|name     |in_Friend|out_Twins|out_WrokI|out_Frien|out_Study|in_Classm|out_Loves|out_Class|
+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+
|0   |#26:0|Person |[#58:0]|        |        |Luca     |         |         |         |         |         |         |         |         |
|1   |#27:0|Person |       |        |        |Bill     |         |         |         |         |         |         |         |         |
|2   |#28:0|Person |       |        |        |Jay      |         |         |         |         |         |         |         |         |
|3   |#34:0|Teacher|       |[#99:0] |        |Miss Li  |         |         |[#139:0] |         |         |         |         |         |
|4   |#35:0|Teacher|       |        |        |Mr Luo   |         |         |[#138:0] |         |         |         |         |         |
|5   |#42:0|Student|       |        |        |LiLei    |         |         |         |[#82:0]  |[#130:0] |         |[#98:0...|[#90:0]  |
|6   |#43:0|Student|       |[#98:0] |        |LiMin    |[#82:0]  |         |         |         |         |[#90:0]  |         |         |
|7   |#44:0|Student|       |        |        |HanMeimei|         |         |         |         |[#131:0] |         |         |         |
|8   |#45:0|Student|       |        |        |Lucy     |         |[#106:0] |         |         |         |         |         |[#91:0]  |
|9   |#46:0|Student|       |        |[#106:0]|Lily     |         |         |         |         |         |[#91:0]  |         |         |
+----+-----+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+

10 item(s) found. Query executed in 0.002 sec(s).

查看定义了几种关系（关系列表）

orientdb {db=social}> select * from Know;

+----+------+---------+-----+-----+
|#   |@RID  |@CLASS   |out  |in   |
+----+------+---------+-----+-----+
|0   |#82:0 |Friend   |#42:0|#43:0|
|1   |#90:0 |Classmate|#42:0|#43:0|
|2   |#91:0 |Classmate|#45:0|#46:0|
|3   |#98:0 |Loves    |#42:0|#43:0|
|4   |#99:0 |Loves    |#42:0|#34:0|
|5   |#106:0|Twins    |#45:0|#46:0|
+----+------+---------+-----+-----+

6 item(s) found. Query executed in 0.002 sec(s).


orientdb {db=social}>  select * from E;

+----+------+---------+-----+------+
|#   |@RID  |@CLASS   |out  |in    |
+----+------+---------+-----+------+
|0   |#58:0 |Eat      |#26:0|#50:0 |
|1   |#82:0 |Friend   |#42:0|#43:0 |
|2   |#90:0 |Classmate|#42:0|#43:0 |
|3   |#91:0 |Classmate|#45:0|#46:0 |
|4   |#98:0 |Loves    |#42:0|#43:0 |
|5   |#99:0 |Loves    |#42:0|#34:0 |
|6   |#106:0|Twins    |#45:0|#46:0 |
|7   |#130:0|StudyIn  |#42:0|#114:0|
|8   |#131:0|StudyIn  |#44:0|#114:0|
|9   |#138:0|WrokIn   |#35:0|#114:0|
|10  |#139:0|WrokIn   |#34:0|#114:0|
+----+------+---------+-----+------+

11 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查询 LiMin 的 Friend StudyIn 的 School

orientdb {db=social}> MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn') {as: school} RETURN person, school.name

+----+------+-----------+
|#   |person|school_name|
+----+------+-----------+
|0   |      |No.2       |
+----+------+-----------+

1 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查询 LiMin 的 Friend StudyIn 的 School 中的 Teacher

orientdb {db=social}>  MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn').both('WrokIn') {as: teacher} RETURN person, teacher.name

+----+------+------------+
|#   |person|teacher_name|
+----+------+------------+
|0   |      |Mr Luo      |
|1   |      |Miss Li     |
+----+------+------------+

2 item(s) found. Query executed in 0.002 sec(s).

NOTE: 查询 LiMin 的 Friend StudyIn 的 School 中的 Teacher 和 Student

orientdb {db=social}> MATCH {class: Person, as: people, where:(name = 'LiMin')}.both('Friend').both('StudyIn').both('E') {as: person} RETURN person.name

+----+-----------+
|#   |person_name|
+----+-----------+
|0   |Mr Luo     |
|1   |Miss Li    |
|2   |LiLei      |
|3   |HanMeimei  |
+----+-----------+

4 item(s) found. Query executed in 0.003 sec(s).

扩展阅读

orientdb sql query to select edge and vertex fields property.

https://stackoverflow.com/questions/28534120/orientdb-sql-query-to-select-edge-and-vertex-fields-property
简介：
有一些例子可以参考。