直接使用頂點(diǎn)V:
-- # 小朱25歲,出生在教師家庭并且有個(gè)姐姐小田洪燥,他現(xiàn)在奮斗在帝都。
CREATE VERTEX V SET name="小朱",sex="男",age="25";
CREATE VERTEX V SET name="小田",sex="女",age="27";
CREATE EDGE E FROM #9:0 TO #10:0 SET name="sister";
CREATE EDGE E FROM #10:0 TO #9:0 SET name="brother";
SELECT * FROM V WHERE name in ['小朱',"小田"];
image.png
image.png
image.png
-- # 小朱還有一個(gè)可愛的女盆友叫小劉
CREATE VERTEX V SET name="小劉",sex="女",age="23";
CREATE EDGE E FROM #9:0 TO #11:0 SET name="lover";
CREATE EDGE E FROM #11:0 TO #9:0 SET name="lover";
image.png
image.png
-- # 小朱目前工作在企業(yè)Google乳乌,他有一堆同事小馬捧韵、小龔、小微…..
CREATE VERTEX V SET name="Google";
CREATE VERTEX V SET name="小馬",sex="男",age="29",company="Google";
CREATE VERTEX V SET name="小龔",sex="男",age="28",company="Google";
CREATE VERTEX V SET name="小微",sex="女",age="24",company="Google";
UPDATE V SET company = 'Google' WHERE name='小朱'
CREATE EDGE E FROM (select from V where company='Google') TO (select from V where name ='Google') SET name="employee";
image.png
image.png
-- # 小朱目前跟不同同事合作完成了如下項(xiàng)目:PROJECT-1,PROJECT-2,PROJECT-3…..
CREATE VERTEX V SET name="PROJECT-1",type='JAVA',starttime='2016/01/01';
CREATE VERTEX V SET name="PROJECT-2",type='JAVA',starttime='2016/01/01';
CREATE VERTEX V SET name="PROJECT-3",type='JAVA',starttime='2016/01/01';
CREATE EDGE E FROM (select from V where name in ['小朱','小馬','小微']) TO (select from v where name='PROJECT-1') SET name="work";
CREATE EDGE E FROM (select from V where name in ['小朱','小馬','小微','小龔']) TO (select from v where name='PROJECT-2') SET name="work";
CREATE EDGE E FROM (select from V where name in ['小朱','小馬','小龔']) TO (select from v where name='PROJECT-3') SET name="work";
image.png
image.png
NOTE:
所有點(diǎn)和邊緣均繼承祖先V汉操、E對(duì)象再来,不能方便的通過語句進(jìn)行篩選,不推薦直接創(chuàng)建V磷瘤、E記錄芒篷。
使用擴(kuò)展的頂點(diǎn)和邊:
CREATE CLASS Company EXTENDS V;
CREATE CLASS Project EXTENDS V;
CREATE CLASS Preson EXTENDS V;
CREATE CLASS Lover EXTENDS E;
CREATE CLASS Sister EXTENDS E;
CREATE CLASS Brother EXTENDS E;
CREATE CLASS Employee EXTENDS E;
CREATE CLASS Work EXTENDS E;
CREATE VERTEX Preson SET name="小朱",sex="男",age="25",company="Google";
CREATE VERTEX Preson SET name="小劉",sex="女",age="23";
CREATE VERTEX Preson SET name="小田",sex="女",age="27";
CREATE VERTEX Company SET name="Google";
CREATE VERTEX Preson SET name="小馬",sex="男",age="29",company="Google";
CREATE VERTEX Preson SET name="小龔",sex="男",age="28",company="Google";
CREATE VERTEX Preson SET name="小微",sex="女",age="24",company="Google";
CREATE VERTEX Project SET name="PROJECT-1",type='JAVA',starttime='2016/01/01';
CREATE VERTEX Project SET name="PROJECT-2",type='JAVA',starttime='2016/01/01';
CREATE VERTEX Project SET name="PROJECT-3",type='JAVA',starttime='2016/01/01';
-- # 把以前的頂點(diǎn)移動(dòng)到每個(gè)具體的類別
-- # MOVE VERTEX(SELECT FROM V WHERE name='Google') TO CLASS:Company;
-- #創(chuàng)建情侶關(guān)系
CREATE EDGE Lover FROM (select from Preson where name='小朱') TO (select from Preson where name='小劉');
CREATE EDGE Lover FROM (select from Preson where name='小劉') TO (select from Preson where name='小朱');
-- #創(chuàng)建姐弟關(guān)系
CREATE EDGE Sister FROM (select from Preson where name='小朱') TO (select from Preson where name='小田');
CREATE EDGE Brother FROM (select from Preson where name='小田') TO (select from Preson where name='小朱');
-- #創(chuàng)建雇傭關(guān)系
CREATE EDGE Employee FROM (select from Preson where company='Google') TO (select from Company where name ='Google');
-- #創(chuàng)建項(xiàng)目關(guān)系
CREATE EDGE Work FROM (select from Preson where name in ['小朱','小馬','小微']) TO (select from Project where name='PROJECT-1');
CREATE EDGE Work FROM (select from Preson where name in ['小朱','小馬','小微','小龔']) TO (select from Project where name='PROJECT-2');
CREATE EDGE Work FROM (select from Preson where name in ['小朱','小馬','小龔']) TO (select from Project where name='PROJECT-3');
查看:
SELECT * FROM V;
圖1 頂點(diǎn)&邊的圖
圖二 完整的WEB UI
擴(kuò)展閱讀:
OrientDB 圖計(jì)算框架
http://blog.csdn.net/zhufengyi/article/details/53037764
簡介:
介紹了SQL命令,還提供了場景采缚。