schema-design
PostgreSQL schema design [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2023-02-19 22:28 分类:问答Entity Attribute Value (EAV) vs. XML Column for New Product Atttributes
I have an existing, mature schema to which we need to add some new Product attributes. For example, we have Products.Flavor, and now need to add new attributes such as Weight, Fragrance, etc. Rather t[详细]
2023-02-18 14:22 分类:问答References vs embeds in MongoDB
I\'m trying to figure out how to best use MongoDB for a very small and simple use case, but finding the docs somewhat confusing.[详细]
2023-02-10 02:34 分类:问答MySQL database performance tuning, schema optimisation
I have a MySQL database with a pretty simple schema.There are parent, child and access tables. parent stores 51 fields that are all varchar (ranging in length from 16 to 512) except for for 4 longtex[详细]
2023-02-06 15:02 分类:问答MySql database schema referencing problem
I have the following tables; which开发者_StackOverflow中文版 will be holding information about various types of articles.[详细]
2023-02-06 04:06 分类:问答Appropriate way to structure a database table? (empty columns vs. multiple tables)
Let\'s say we have a object called a Widget, for which we can construct a database table. Now, let\'s say we have two sets of additional detail to describe widgets. Each set of data is available at a[详细]
2023-01-15 10:23 分类:问答enforce empty JSON schema
I want a JSON schema that enforces an empty JSON objec开发者_JAVA百科t, e.g. {} Is this a good idea and possible?[详细]
2023-01-12 11:20 分类:问答Schema less SQL database table - practical compromise
This question is an attempt to find a practical solution for this question. I need a semi-schema less design for my SQL database. However, I can limit the flexibility to shoehorn it into the entire[详细]
2023-01-09 14:04 分类:问答Can a binary tree or tree be always represented in a Database as 1 table and self-referencing?
I didn\'t feel this rule before, but it seems that a binary tree or any tree (each node can开发者_开发技巧 have many children but children cannot point back to any parent), then this data structure ca[详细]
2023-01-02 16:41 分类:问答MongoDB Schema Design - Real-time Chat
I\'m starting a project which I think will be particularly suited to MongoDB due to the speed and scalability it affords.[详细]
2023-01-01 18:33 分类:问答