Kuwedzerwa kweAGE kwakagadzirirwa PostgreSQL kuchengetedza data muchimiro chegirafu

YePostgreSQL yakarongwa AGE (AgensGraph-Extension) kuwedzera nekushandisa mutauro wemubvunzo openCypher yekushandura seti yedata yakabatana yehierarchical inoumba girafu. Panzvimbo pemakoramu nemitsara, girafu-inotungamirwa dhatabhesi inoshandisa chimiro chakafanana netiweki-node, zvimiro zvavo, uye hukama pakati pemanodhi zvinotsanangurwa. AGE inoparadzirwa ne ine rezinesi pasi peApache 2.0 rezinesi, yakaunzwa pasi peApache Foundation neBitnine, uye parizvino inogara muApache Incubator.

Iyo purojekiti inoenderera mberi nekuvandudzwa kweDBMS AgentsGraphizvo inomirira iyo ndeye yakagadziridzwa PostgreSQL gadziriso yegirafu kugadzirisa. Musiyano wakakosha ndeyekuitwa kweAGE muchimiro cheadd-on yepasirese iyo inoshanda seyekuwedzera pamusoro peyakajairwa PostgreSQL kuburitswa. Nyaya yakabudiswa munguva pfupi yapfuura Apache AGE 0.2.0 inotsigira PostgreSQL 11.

Mumamiriro azvino AGE zvitsigiso maficha akadai emutauro weCypher wemubvunzo sekushandisa izwi rekuti "CREATE" kutsanangura node uye zvinongedzo, izwi rekuti "MATCH" yekutsvaga data mugirafu zvinoenderana nemamiriro akatsanangurwa (KUPI), mune yakatarwa (ORDER BY) uye ne gadza zvirambidzo (SKIP, LIMIT) . Mhedzisiro yadzoserwa nemubvunzo inotariswa pachishandiswa izwi rekuti "RETURN". Izwi rekuti "NE" rinowanikwa kubatanidza zvikumbiro zvakawanda pamwechete.

Zvinokwanisika kugadzira dhatabhesi remhando dzakasiyana-siyana dzinobatanidza mamodheru ekuchengetedza zvivakwa muchimiro chegirafu, muenzaniso wehukama uye modhi yekuchengeta magwaro muJSON fomati. Inotsigira kuitiswa kwemibvunzo yakabatanidzwa inosanganisira zvinhu zveSQL neCypher mitauro.
Zvinogoneka kugadzira indexes yezvimiro zve vertices uye mipendero yegirafu.
Seti yakawedzerwa yemhando dzeAgtype inokurudzirwa kuti ishandiswe, kusanganisira mhando dzemipendero, vertices uye nzira dziri mugirafu. Matauriro akaunganidzwa haasati aitwa. Anowanikwa akasarudzika mabasa anosanganisira id, start_id, end_id, mhando, zvivakwa, musoro, yekupedzisira, kureba, saizi, startNode, endNode, timestamp, toBoolean, toFloat, toInteger, uye coalesce.

Source: opennet.ru