YePostgreSQL AGE (AgensGraph-Extension) yekuwedzera ine mubvunzo kushandisa mutauro yekushandura seti yedata ine hukama inoumba girafu. Panzvimbo pemakoramu nemitsara, girafu-inotungamirwa dhatabhesi inoshandisa network-yakafanana chimiro-node, zvimiro zvavo, uye hukama pakati pemanodhi zvinotsanangurwa. AGE pasi peApache 2.0 rezenisi, inotamiswa neBitnine kune inosimudzira yeApache Foundation uye parizvino inogara muApache Incubator.
Iyo purojekiti inoenderera mberi nekugadzira iyo DBMS izvo ishanduro yePostgreSQL yakagadziridzwa yakagadziridzwa kuti girafu igadziriswe. Musiyano wakakosha ndeyekuitwa kweAGE sekuwedzera-kwese kunomhanya se superset pamusoro peyakajairwa PostgreSQL kuburitswa. Iyo ichangobva kuburitswa kuburitswa inotsigira basa nePostgreSQL 11.
Mumamiriro azvino eAGE Cypher query language capabilities inosanganisira "CREATE" statement yekutsanangura nodes nehukama, uye "MATCH" statement yekutsvaga data mugirafu inoenderana nemamiriro akatarwa (WHERE), muhurongwa hwakatarwa (ORDER BY), uye nezvirambidzo zvakatemwa (SKIP, LIMIT). Mhedzisiro yadzoserwa nemubvunzo inotsanangurwa pachishandiswa "RETURN" statement. Chirevo che "NE" chiripo chekubatanidza mibvunzo yakawanda.
Multi-model dhatabhesi inogona kugadzirwa, ichibatanidza hierarchical graph zvivakwa zvekuchengetera modhi, yehukama modhi, uye JSON gwaro rekuchengetedza modhi. Yakabatanidzwa mibvunzo inosanganisira SQL uye Cypher mutauro zvinhu zvinotsigirwa.
Zvinogoneka kugadzira indices yezvivakwa zve graph vertices uye edges.
Iyo yakawedzera seti yemhando dzeAgtype inowanikwa 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
