Linked Questions
21 questions linked to/from Is there a name for this database schema of key values?
0
votes
1
answer
324
views
DB Structure: one table to hold all domain values? [duplicate]
One database I recently start working with was designed with one main table containing all possible values, and foreign keys in other tables are specifying the nature of each of those items.
CREATE ...
- 143
0
votes
0
answers
96
views
When is should/shouldn't the Entity Attribute Value (EAV) pattern be used? [duplicate]
Possible Duplicate:
Is there a name for this database structure?
The Entity Attribute Value (EAV) pattern usually has three columns: foreign key, attribute, and value. Attributes of data are ...
user10719
0
votes
2
answers
90
views
Multiple types of parts with multiple types of information (unspecified amount) [duplicate]
I'm having trouble designing a database for a project I was working on recently. It's to do with a garage management system.
So I've realised I need to store multiple types of parts (Tyres, engines, ...
0
votes
0
answers
64
views
How to properly design this type of relationship [duplicate]
I am building a model with the following requirements:
Items may have attributes
Attributes may be of type: 'Choice', 'FreeText', 'Number'
I am not quite sure how to relate the item to attribute ...
- 101
1
vote
0
answers
45
views
Advice on designing databases for things like Posts and categories; and general rule of thumbs [duplicate]
I'm creating my own website with a capability to CRUD posts and other related stuff like category, tags and other things (I believe it's similar to the first two mentioned).
Posts: (current create ...
- 151
45
votes
1
answer
22k
views
Commonly Used Acronyms by Database Administrators
What are the most commonly used acronyms among database administrators and what are their correlated meanings?
This is for the community and those searching for meanings of commonly used terms and ...
2
votes
1
answer
4k
views
Alternatives to EAV model
I am looking for a design pattern that would allow me to capture metadata relating to columns on a table. More specifically, here is my situation.
I have a database with fields in a field table, ...
4
votes
2
answers
520
views
Is EAV an appropriate design for a collection of coexisting metadata-rich "fact estimates" on objects? [closed]
I'm attempting to architect a system that will collect estimates on various quantities (10+) on each of many (300K+) objects, and make decisions from the historical record of these estimates. For ...
- 141
5
votes
1
answer
4k
views
Schema for analytics table in Postgres
We use Postgres for analytics (star schema).
Every few seconds we get reports on ~500 metrics types.
The simplest schema would be:
timestamp metric_type value
78930890 FOO ...
- 53
2
votes
1
answer
1k
views
Nullable columns or jsonb for storing user profile?
I'm deciding between using nullable fields or jsonb to store user profile. Initially, this would be used for contacts: email and phone. I anticipate that there may be other columns added later, such ...
- 749
2
votes
1
answer
2k
views
Attribute and Value tables on SQL - Is this a good practice?
I'm not a SQL expert and I'd like to ask for the best practices on the following schema.
On my current project, we're using Attribute and AttributeValue tables quite often. I'm thinking this might ...
- 121
3
votes
2
answers
2k
views
How to design future proof tables?
I am new to database design and have started developing my first schema.
Some of my tables (e.g. user_profile) I am struggling to come up with an exhaustive list of fields for the table. A particular ...
- 519
-1
votes
2
answers
1k
views
EAV in postgresql
I'm building an application that needs to be deployed several times, with a relatively well organized data model. A table needs to be configured for each deployment with a small number of additional ...
- 1
1
vote
0
answers
849
views
How to handle many columns / variable schema?
I apologize in advance in case this question has been asked already.
I'm working on revamping a reporting application used within my company. The requirements are:
Support addition of new fields (...
- 11
2
votes
1
answer
425
views
Is having all entity tables inherit from one main entity table a bad idea?
My co-worker is designing a schema where most entities (like contacts, quotes, tasks) inherit from an "entity" table, which keeps track of things like which tenant owns the entity, and chagnes to the ...
0
votes
1
answer
610
views
SQL Server Database Design for Reporting
We are designing a reporting solution for survey results. Although datasets are reasonable in size (rarely more than 500.000 respondents and 50 questions), performance is obviously a major concern.
...
- 3
1
vote
1
answer
197
views
How should I model a "communication preferences" field which may require different supporting info for each row?
I am building a system which sends information to other systems. Each client system has its own communication requirements. For example, a client system might require:
An HTTP request
An HTTPS ...
- 113
0
votes
1
answer
173
views
What is the best way to create tables for email campaigns?
I have table email_sent with fields:
id
user_id
template_name
sent_at
opened clicks
And now I need to save data which was send for each email. I have several campaigns with differnt data. For ...
- 175
0
votes
1
answer
156
views
Performance of a View with Hundreds of Left Joins
I have a table with 100+ columns, each containing a numeric value that maps to a string value in another table. When trying to create a view for the table that contains these string values, I'm ...
- 101
1
vote
1
answer
145
views
Should I use a single column with many dimensions with columnar data?
I'm using Apache Iceberg which performs queries on Parquet files. The data saves a lot of types of events and their respective numeric values. I'm hesitating whether it's more efficient to have one ...
- 113
0
votes
1
answer
24
views
Is it valid design to relate different but similarly structured data to resources using composite keys?
I have been taking an approach on small applications for some time now where I have a very similar data structure that might apply to more than one different type of resource. To avoid making ...
- 1