Zowonjezera AGE zakonzedwa kuti PostgreSQL isunge deta mu mawonekedwe a graph

Kwa PostgreSQL akufuna AGE (AgensGraph-Extension) kuwonjezera ndi kugwiritsa ntchito chilankhulo cha mafunso OpenCypher posintha ma seti a data yolumikizidwa yomwe imapanga ma graph. M'malo mwa mizati ndi mizere, nkhokwe zokhala ndi ma graph zimagwiritsa ntchito mawonekedwe ofanana ndi ma netiweki-node, katundu wawo, ndi maubale pakati pa ma node amafotokozedwa. AGE wogawidwa ndi chololedwa pansi pa layisensi ya Apache 2.0, yobweretsedwa mothandizidwa ndi Apache Foundation ndi Bitnine, ndipo pano ili mu Apache Incubator.

Ntchitoyi ikupitilira chitukuko cha DBMS AgentsGraphzomwe imaimira ndikusintha kwa PostgreSQL kwakusintha kwa ma graph. Kusiyana kwakukulu ndiko kukhazikitsidwa kwa AGE mu mawonekedwe owonjezera padziko lonse lapansi omwe amagwira ntchito ngati chowonjezera pazomwe zimatulutsidwa za PostgreSQL. Nkhani yosindikizidwa posachedwa Apache AGE 0.2.0 imathandizira PostgreSQL 11.

Pakali pano AGE zogwiriziza mawonekedwe amtundu wamafunso a Cypher monga kugwiritsa ntchito mawu oti "CREATE" kutanthauzira ma node ndi maulalo, mawu oti "MATCH" kufufuza deta mu graph molingana ndi zikhalidwe zomwe zafotokozedwa (KUPENE), mu dongosolo lodziwika (ORDER BY) ndi khazikitsani zoletsa (SKIP, LIMIT) . Zotsatira zomwe zabwezedwa ndi funso zimatsimikiziridwa pogwiritsa ntchito mawu akuti "RETURN". Mawu akuti "WITH" amapezeka kuti agwirizane ndi zopempha zingapo.

N'zotheka kupanga ma database amitundu yambiri omwe amaphatikiza zitsanzo zosungiramo katundu wa hierarchical mu mawonekedwe a graph, chitsanzo chaubale ndi chitsanzo chosungira malemba mumtundu wa JSON. Imathandizira kufunsidwa kwa mafunso ophatikizika omwe amaphatikiza zinthu za SQL ndi zilankhulo za Cypher.
Ndizotheka kupanga ma index azinthu zama vertices ndi m'mphepete mwa graph.
Mitundu yowonjezereka ya mitundu ya Agtype ikuganiziridwa kuti igwiritsidwe ntchito, kuphatikizapo mitundu ya m'mphepete, ma vertices ndi njira za graph. Mawu ophatikizana sanagwiritsidwebe ntchito. Ntchito zapadera zomwe zilipo zikuphatikiza id, start_id, end_id, mtundu, katundu, mutu, chomaliza, kutalika, kukula, startNode, endNode, timestamp, toBoolean, toFloat, toInteger, ndi coalesce.

Source: opennet.ru