Question : I’m building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure […]
Tag: design-pattern
Why would an application use one central metadata table to hold metadata for all other tables?
Question : I’ve started working with an application that has an usual design: In addition to the tables that contain […]
If the query for database too complicated, does it means the design of Database is bad?
Question : I am new to database, and below is one of my query with it’s explanation, I feel it’s […]
Most efficient ordering post database design
Question : I have posts table that is has post_order column. I store order of each post in it. when […]
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 […]