哪种存储适合存储多组相同模式的表？
我用一个表来存储字典中所有单词的各种分类。
它看起来像这样：
word category origin-language
------- --------- ---------------
happy adjective English
bonjour greeting French
...
从一组分类中，我能够产生一个数字。 我想找到一个产生最小值的集合，因此我想将许多此类分类的集合（每个是一个表）及其各自的数字存储在存储器中。
什么样的存储适合这项任务？我认为关系数据库不合适，因为没有表格数据的数据类型。
I use a table to store various classifications of all words in the dictionary.
It looks like this:
word category origin-language
------- --------- ---------------
happy adjective English
bonjour greeting French
...
from a set of classifications, I am able to produce a number.
I want to find a set which produces a minimum, so I want to store many sets of such classifications (each is a table) together with their respective numbers in a storage.
What kind of storage is suitable for this task? I don't think relational database is suitable, since there is no datatype for tabular data.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我建议使用像您这样的单个表加上一列来标识分类集：
分类（ClassificationSet，Word，Category，OiginLanguage）KEY ???
一些 DBMS 确实有表类型，有些（例如 Oracle）允许嵌套表。我认为这与你的问题无关。通常更直接地找到没有嵌套表的等效模型。
I would suggest a single table like yours plus a column to identify the classification set:
Classification (ClassificationSet, Word, Category, OiginLanguage) KEY ???
Several DBMSs do have a type for tables and some (e.g. Oracle) allow nested tables. I don't think that's relevant to your problem. It's usually more straightforward to find an equivalent model without nested tables.
我目前的想法是，我将所有此类表存储在不同的数据库模式下，将它们命名为 table_1, table_2, ...,
并创建一个新表：
my current thinking is that I store all such tables under a different database schema, name them table_1, table_2, ...,
and create a new table: