拥有多个数据库在亚马逊 Neptune 中。

huangapple go评论41阅读模式
英文:

Having multiple databases in amazon neptune

问题

在MySQL中,我们可以创建多个数据库,然后在这些数据库中创建不同的表。例如:

mysql> create database demo;
mysql> use demo;
mysql> create table test_demo (id int);

这使我们能够在不同的数据库下创建多个表,从而实现虚拟分离。

我正在寻找Amazon Neptune 中的类似功能。是否可以在Amazon Neptune中创建不同的数据库,然后在这些数据库中构建相互独立的图形?如果可能的话,如何实现?

注意:我不希望为每个图形创建单独的集群,因此上述问题。

英文:

In mysql we can create multiple databases and then we create different different tables in those database. e.g.

mysql> create database demo;
mysql> use demo;
mysql> create table test_demo (id int);

This allows us to create multiple tables under different different databases which provides virtual seggregation.

I am looking for similar stuff in amazon neptune. Is it possible to create different databases in amazon neptune and then to build the graph in those database which are independent from each other? If it is possible then how ?

Note: I don't want to create the separate cluster for my each graph hence above question.

答案1

得分: 2

目前,Neptune 是一个单租户数据库服务。这意味着单个 Neptune 集群只能托管单个逻辑数据库。

如果您希望使用单个集群来托管多个上下文/用户的数据,您需要在应用程序内部执行此操作,并使用数据模型的不同方面来表示这些不同的上下文。例如,如果您的图中有一个 Person 节点标签,您可以使用不同的前缀来表示与不同用户相关的 Person 节点:User1.Person,User2.Person,...,UserX.Person。对于边和属性键也是类似的。

英文:

At present, Neptune is a single-tenant database service. This means that a single Neptune cluster can only host a single logical database.

If you're looking to use a single cluster to host data for multiple contexts/users, you would need to do this within the application and use different aspects of the data model to denote these different contexts. For example, if you have a Person node label in your graph, you could use separate prefixes to denote which Person nodes relate to different users: User1.Person, User2.Person, ..., UserX.Person. Similar for edges and property keys.

huangapple
  • 本文由 发表于 2023年2月8日 14:48:56
  • 转载请务必保留本文链接:https://go.coder-hub.com/75382227.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定