Ukwengezwa kwe-AGE kulungiselelwe ukuthi i-PostgreSQL igcine idatha ngendlela yegrafu

Nge-PostgreSQL ehlongozwayo I-AGE (AgensGraph-Extension) ihlanganisa nokusebenzisa ulimi lombuzo i-openCypher ngokukhohlisa amasethi edatha ye-hierarchical exhumene akha igrafu. Esikhundleni samakholomu nemigqa, isizindalwazi esigxile kugrafu sisebenzisa isakhiwo esifana nenethiwekhi—amanodi, izakhiwo zawo, nobudlelwano phakathi kwamanodi kuyacaciswa. AGE isatshalaliswa ngu enikezwe ilayisense ngaphansi kwelayisensi ye-Apache 2.0, elethwe ngaphansi kwe-Apache Foundation ngabakwa-Bitnine, futhi okwamanje ehlala ku-Apache Incubator.

Le phrojekthi iyaqhubeka nokuthuthukiswa kwe-DBMS Ama-AgentGraphokuyinto izipho inguqulo eguquliwe ye-PostgreSQL yokucubungula igrafu. Umehluko oyinhloko ukuqaliswa kwe-AGE ngendlela yesengezo samazwe ngamazwe esisebenza njengesengezo phezu kokukhishwa okujwayelekile kwe-PostgreSQL. Inkinga eshicilelwe kamuva nje I-Apache AGE 0.2.0 isekela i-PostgreSQL 11.

Esimeni samanje AGE isekela izici ezinjalo zolimi lombuzo we-Cypher njengokusebenzisa isisho esithi “DALA” ukuchaza amanodi nezixhumanisi, isisho esithi “MATCH” ukucinga idatha kugrafu ngokwemibandela eshiwo (LAPHO), ngohlelo olucacisiwe (ORDER BY) kanye setha imikhawulo (SKIP, LIMIT) . Umphumela omisiwe obuyiselwe ngumbuzo unqunywa kusetshenziswa isisho esithi "RETURN". Isisho esithi "NGA" siyatholakala ukuze kuhlanganiswe izicelo eziningi ndawonye.

Kuyenzeka udale isizindalwazi esinamamodeli amaningi ahlanganisa amamodeli okugcinwa kwezakhiwo ngendlela yegrafu, imodeli ehlobene kanye nemodeli yokugcina amadokhumenti ngefomethi ye-JSON. Isekela ukusetshenziswa kwemibuzo ehlanganisiwe ehlanganisa izici zezilimi ze-SQL ne-Cypher.
Kungenzeka ukudala izinkomba zezakhiwo zama-vertices kanye nemiphetho yegrafu.
Kuhlongozwa isethi enwetshiwe yezinhlobo ze-Agtype ukuze zisetshenziswe, okuhlanganisa izinhlobo zamaphethelo, ama-vertices nezindlela kugrafu. Izinkulumo ezihlanganisiwe azikenziwa. Imisebenzi ekhethekile etholakalayo ihlanganisa i-id, start_id, end_id, type, properties, head, last, ubude, size, startNode, endNode, isitembu sesikhathi, toBoolean, toFloat, toInteger, kanye ne-coalesce.

Source: opennet.ru