database NOSQL 数据库建模工具

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/22835089/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 09:13:10  来源:igfitidea点击:

Modeling Tool for NOSQL Databases

databasedatabase-designdata-modelingnosql

提问by SoumaZ

I know that most of the time NOSQL databses are schema-less or at least have a flexible database schema. However, the basic schema needs to be modeled beforehand and may evolve later. So,in this case, is there a modeling tool/language for NOSQL databases? Like UML for RDB and Visual Paradigm (UML modeling tool). I found that for "Graph Databases", we can use "Property Graph Model" but I am working on "BigColumn Databases" and "Document-base Databases". Thank you.

我知道大多数时候 NOSQL 数据库都是无模式的,或者至少有一个灵活的数据库模式。但是,基本模式需要事先建模,以后可能会演变。那么,在这种情况下,是否有用于 NOSQL 数据库的建模工具/语言?像 RDB 和 Visual Paradigm(UML 建模工具)的 UML。我发现对于“图形数据库”,我们可以使用“属性图形模型”,但我正在研究“BigColumn 数据库”和“基于文档的数据库”。谢谢你。

回答by M.K.

NoSQL databases approach modelling from a different point of view generally. NoSQL modelling usually begins with asking questions on how the data in the database is going to be queried, so the main modelling is 'what are the list of questions that I want to ask of my database', whereas with SQL databases, modelling usually is a function of what data you have, that is, what answers I have already. This mental exercise of finding out what questions one would like to ask of the NoSQL database serve to define the entities and the relationship amongst those entities.

NoSQL 数据库通常从不同的角度进行建模。NoSQL 建模通常从询问如何查询数据库中的数据开始,因此主要建模是“我想对我的数据库提出哪些问题列表”,而对于 SQL 数据库,建模通常是你有什么数据的函数,也就是我已经有什么答案。这种找出人们想对 NoSQL 数据库提出什么问题的心理练习有助于定义实体以及这些实体之间的关系。

Once you have a list of questions, you then need to design a model that will answer those questions via the NoSQL database. To model it, I typically use Createlywhich is an online tool for visually representing models of various kinds.

有了问题列表后,您就需要设计一个模型,通过 NoSQL 数据库回答这些问题。为了建模,我通常使用Creately,它是一个在线工具,用于直观地表示各种模型。

Another method could be to represent your NoSQL model in JSON format and then use the wonderful D3.js javascript library to create a data-driven document. See thiswebsite for more details and the templates available to visually represent your model.

另一种方法可能是以 JSON 格式表示您的 NoSQL 模型,然后使用出色的 D3.js javascript 库来创建数据驱动的文档。有关更多详细信息以及可用于直观表示您的模型的模板,请参阅网站。

Hope it helps.

希望能帮助到你。

回答by Siva Karthikeyan

KDMis one solution you can think for NoSQL database Cassandra. This tool starts from conceptual modelling till physical modelling. May be you can have look at this. This is available to use free online.

KDM是您可以为 NoSQL 数据库 Cassandra 考虑的一种解决方案。该工具从概念建模到物理建模。也许你可以看看这个。这可以在线免费使用。