基于PostgreSQL的图数据库-AgensGraph
2022-07-08 13:55:24 
阿炯
AgensGraph 是一个基于 PostgreSQL 的图数据库。采用C语言开发并在ApacheV2.0协议授权。
AgensGraph is a new generation multi-model graph database for the modern complex data environment. AgensGraph is a multi-model database, which supports the relational and graph data model at the same time that enables developers to integrate the legacy relational data model and the flexible graph data model in one database. AgensGraph supports ANSI-SQL and openCypher. SQL queries and Cypher queries can be integrated into a single query in AgensGraph.
AgensGraph is based on the powerful PostgreSQL, and is very robust, fully-featured and ready for enterprise use. It is optimized for handling complex connected graph data and provides plenty of powerful database features essential to the enterprise database environment including ACID transactions, multi-version concurrency control, stored procedure, triggers, constraints, sophisticated monitoring and a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-systems of PostgreSQL and can be extended with many outstanding external modules, like PostGIS.
属性图模型：
Property Graph Model
数据对象：
Labels :
同时 AgensGraph 也是用于现代复杂数据环境的新一代多模型图数据库，它同时支持关系和图数据模型。因此，开发者可以将遗留下来的关系数据模型和灵活的图形数据模型集成到一个数据库中。支持 ANSI-SQL 和 openCypher。SQL 和 Cypher 可以集成到 AgensGraph 中的单个查询中。
主要特性：
多模型支持，包括：图数据库，关系数据库和 JSON 文档数据库
支持 Cypher 查询语言
支持 SQL 和 Cypher 混合查询
图数据对象的管理
层次化的图标签组织
支持 Vertex 和 Edge 的属性索引
约束支持：唯一约束、强制约束以及检查约束
兼容 ACID 事务性
提供 Hadoop 连接支持
主从备份机制
一些图操作的 DDL：
CREATE VLABEL person;
CREATE VLABEL friend inherits (person);
CREATE ELABEL knows;
CREATE ELABEL live_together;
CREATE ELABEL room_mate inherits (knows, live_together);
CREATE (:person {name: 'Tom'})-[:knows]->(:person {name: 'Summer'});
CREATE (:person {name: 'Pat'})-[:knows]->(:person {name: 'Nikki'});
CREATE (:person {name: 'Olive'})-[:knows]->(:person {name: 'Todd'});
MATCH (n:person {name: 'Tom'})-[:knows]->(m:person) RETURN n.name AS n, m.name AS m;
MATCH (p:person {name: 'Tom'})-[:knows*1..2]->(f:person)
RETURN f.name;
最新版本：2.12
AgensGraph 开发团队于2022年7月上旬发布了2.12，主要改进内容包括：
将以前的 AgensGraph DB 从 PG11 升级到 PG12
大数据处理的性能：改进了分区和查找性能
增加数据导入功能：增加数据导入过滤条件
提高开发的便利性：提供 DDL 语句和 JSON 类型的 SQL
更多详情可查看此处。
项目主页：
https://bitnine.net/agensgraph/
https://github.com/bitnine-oss/agensgraph