Question : I have posts table that is has post_order column. I store order of each post in it. when […]
Tag: design-pattern
Composite Primary Key in multi-tenant SQL Server database
Question : I’m building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure […]
Numerical data with lots of NULLs: 6NF or document database?
Question : I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated […]
Pair of 2-tuple composite FKs pointing to same table (closure table pattern)
Question : I don’t have much experience with DB design, and having a hard time figuring out what’s wrong with […]
Which postgres design for a nested resource that can link to the same type of resource
Question : I have this kind of data that I need to store in postgres (ruby object). #<InitRes:0x007f8ec3734c78 @kind=”RestrictionsSchema”, @restrictions= […]
Time Series Table ( Many Columns ) Design Recommendations [duplicate]
Question : This question already has answers here: How to store many smallish time-series in a relational DB? (3 answers) […]
Numerical data with lots of NULLs: 6NF or document database?
Question : I have a source of numerical data mostly comprised of sensor readings, physical quantities and flags. Each associated […]
Storing column for data that doesn’t exist for majority of rows
Question : I’m using mariadb. I have a single table that keeps track of video_count and image_count for a few […]
Is there a well-known name for this “poor man’s ref. integrity” schema design pattern?
Question : Is there a name for the following database schema design/pattern? My eventual goal is to find more literature […]
Is it ok to have multiple files table for a different entity?
Question : I have two entities A and B. A and B can have multiple files associated to them, each […]