{"id":88105,"date":"2020-07-12T13:42:29","date_gmt":"2020-07-12T11:42:29","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dlya-postgresql-podgotovleno-dopolnenie-age-dlya-hraneniya-dannyh-v-forme-grafa"},"modified":"2020-07-12T13:42:29","modified_gmt":"2020-07-12T11:42:29","slug":"dlya-postgresql-podgotovleno-dopolnenie-age-dlya-hraneniya-dannyh-v-forme-grafa","status":"publish","type":"post","link":"https:\/\/prohoster.info\/fr\/blog\/news\/dlya-postgresql-podgotovleno-dopolnenie-age-dlya-hraneniya-dannyh-v-forme-grafa","title":{"rendered":"Un compl\u00e9ment AGE a \u00e9t\u00e9 pr\u00e9par\u00e9 pour PostgreSQL afin de stocker les donn\u00e9es sous forme de graphe.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Pour PostgreSQL d'activer<\/a><\/noindex> l'extension AGE (AgensGraph-Extension) avec la mise en \u0153uvre du langage de requ\u00eates openCypher<\/a><\/noindex> pour manipuler des ensembles de donn\u00e9es hi\u00e9rarchiques li\u00e9es entre elles, formant un graphe. Au lieu de colonnes et de lignes, les bases de donn\u00e9es orient\u00e9es graphe utilisent une structure similaire \u00e0 un r\u00e9seau \u2014 des n\u0153uds sont d\u00e9finis, ainsi que leurs propri\u00e9t\u00e9s et les relations entre n\u0153uds. AGE est distribu\u00e9<\/a><\/noindex> sous licence Apache 2.0, transf\u00e9r\u00e9 par Bitnine sous l'\u00e9gide de la Fondation Apache et actuellement plac\u00e9 dans l'incubateur Apache. <\/p>\n

Le projet continue de d\u00e9velopper le SGBD AgensGraph<\/a><\/noindex>, qui repr\u00e9sente<\/a><\/noindex> est une modification retravaill\u00e9e pour le traitement des graphes de PostgreSQL. La principale diff\u00e9rence est la mise en \u0153uvre d'AGE sous la forme d'une extension universelle fonctionnant comme un surcouche sur les versions standard de PostgreSQL. La sortie r\u00e9cemment publi\u00e9e Apache AGE 0.2.0<\/a><\/noindex> prend en charge PostgreSQL 11.<\/p>\n

Dans l'\u00e9tat actuel, AGE prend en charge<\/a><\/noindex> des capacit\u00e9s du langage de requ\u00eates Cypher, comme l'utilisation de l'expression \u00ab CREATE \u00bb pour d\u00e9finir des n\u0153uds et des relations, l'expression \u00ab MATCH \u00bb pour rechercher des donn\u00e9es dans le graphe selon des conditions sp\u00e9cifi\u00e9es (WHERE), dans un ordre donn\u00e9 (ORDER BY) et avec des limites impos\u00e9es (SKIP, LIMIT). L'ensemble de donn\u00e9es r\u00e9sultant, renvoy\u00e9 par la requ\u00eate, est d\u00e9fini \u00e0 l'aide de l'expression \u00ab RETURN \u00bb. L'expression \u00ab WITH \u00bb permet de combiner plusieurs requ\u00eates en une cha\u00eene. <\/p>\n

Il est possible de cr\u00e9er des bases de donn\u00e9es multimod\u00e8les, combinant les mod\u00e8les de stockage hi\u00e9rarchique des propri\u00e9t\u00e9s sous forme de graphe, le mod\u00e8le relationnel et le mod\u00e8le de stockage de documents au format JSON. L'ex\u00e9cution de requ\u00eates int\u00e9gr\u00e9es incluant des \u00e9l\u00e9ments des langages SQL et Cypher est prise en charge.
\nIl est possible de cr\u00e9er des index pour les propri\u00e9t\u00e9s des n\u0153uds et des ar\u00eates du graphe.
\nUn ensemble \u00e9largi de types Agtype est propos\u00e9 pour l'utilisation, incluant des types pour les ar\u00eates, les n\u0153uds et les chemins dans le graphe. Les expressions agr\u00e9g\u00e9es ne sont pas encore mises en \u0153uvre. Parmi les fonctions sp\u00e9cialis\u00e9es disponibles figurent : id, start_id, end_id, type, properties, head, last, length, size, startNode, endNode, timestamp, toBoolean, toFloat, toInteger et coalesce. <\/p>\n

<\/a><\/noindex><\/p>\n

Source : opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0414\u043b\u044f PostgreSQL \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 AGE (AgensGraph-Extension) \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 openCypher \u0434\u043b\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0439 \u0441 \u043d\u0430\u0431\u043e\u0440\u0430\u043c\u0438 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u043c\u0435\u0436\u0434\u0443 \u0441\u043e\u0431\u043e\u0439 \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u043e\u0431\u0440\u0430\u0437\u0443\u044e\u0449\u0438\u0445 \u0433\u0440\u0430\u0444. \u0412\u043c\u0435\u0441\u0442\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438 \u0441\u0442\u0440\u043e\u043a \u0433\u0440\u0430\u0444\u043e-\u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u044b\u0435 \u0411\u0414 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0443, \u043f\u043e\u0445\u043e\u0436\u0443\u044e \u043d\u0430 \u0441\u0435\u0442\u044c — \u0437\u0430\u0434\u0430\u044e\u0442\u0441\u044f \u0443\u0437\u043b\u044b, \u0438\u0445 \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430 \u0438 \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f \u043c\u0435\u0436\u0434\u0443 \u0443\u0437\u043b\u0430\u043c\u0438. AGE \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0, \u043f\u0435\u0440\u0435\u0434\u0430\u043d \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 Bitnine \u043f\u043e\u0434 \u043f\u043e\u043a\u0440\u043e\u0432\u0438\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u043e \u0424\u043e\u043d\u0434\u0430 Apache […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-88105","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Un compl\u00e9ment AGE pour PostgreSQL a \u00e9t\u00e9 pr\u00e9par\u00e9 pour stocker des donn\u00e9es sous forme de graphe | ProHoster","description":"Pour PostgreSQL, l'extension AGE (AgensGraph-Extension) avec la mise en \u0153uvre du langage de requ\u00eates a \u00e9t\u00e9 propos\u00e9e","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/dlya-postgresql-podgotovleno-dopolnenie-age-dlya-hraneniya-dannyh-v-forme-grafa","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0414\u043b\u044f PostgreSQL \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u043e \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 AGE \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0444\u043e\u0440\u043c\u0435 \u0433\u0440\u0430\u0444\u0430 | ProHoster","og:description":"\u0414\u043b\u044f PostgreSQL \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u043e \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 AGE (AgensGraph-Extension) \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432","og:url":"https:\/\/prohoster.info\/fr\/blog\/news\/dlya-postgresql-podgotovleno-dopolnenie-age-dlya-hraneniya-dannyh-v-forme-grafa","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-07-12T11:42:29+00:00","article:modified_time":"2020-07-12T11:42:29+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"88105","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:36:29","updated":"2022-10-03 10:03:20","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/88105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=88105"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/88105\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=88105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=88105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=88105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}