NOSQL数据库建模工具 [英] Modeling Tool for NOSQL Databases

问题描述

我知道大多数时候，NOSQL数据库都是无模式的，或者至少具有灵活的数据库模式。
但是，基本架构需要事先建模，以后可能会发展。那么，在这种情况下，是否存在用于NOSQL数据库的建模工具/语言？
类似用于RDB和Visual Paradigm的UML（UML建模工具）。我发现对于图形数据库，我们可以使用属性图形模型，但是我正在研究大列数据库和文档库。
谢谢。

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建模通常从询问如何查询数据库中的数据开始，所以主要的建模是我想问数据库的问题列表是什么，而对于SQL数据库，建模通常是您所拥有的数据的功能，即我已经拥有的答案。找出想要对NoSQL数据库提出什么问题的这种思维活动有助于定义实体以及这些实体之间的关系。

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数据库回答这些问题。要对其建模，通常使用 Creately ，这是一种在线工具，可以直观地表示各种模型。

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 Creately which is an online tool for visually representing models of various kinds.

另一种方法可能是以JSON格式表示NoSQL模型，然后使用精美的D3.js javascript库创建数据驱动的文档。请访问此网站以获取更多详细信息以及可用于直观表示模型的模板。

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 this website for more details and the templates available to visually represent your model.

希望有帮助。

这篇关于NOSQL数据库建模工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！