All Questions
Tagged with database-design database
9,366 questions
0
votes
1
answer
55
views
real-world performance & trade-offs for Regatta DBMS [closed]
We are considering using Regatta as a high-performance transactional database. So far it promises higher throughput, stronger consistency and lower-latency reads and writes while being SQL compatible. ...
- 19
1
vote
0
answers
100
views
dimensional modeling from two different source systems for the same business process?
I have two transactional systems that is used for the same operational business activity: purchase order transactions. One system is legacy and the other is a new modern one. They have different ...
- 801
0
votes
2
answers
68
views
Integer PK but a GUID as FK
In our current PostgreSQL DB, primary keys are Ints. However, in almost all of the communications between services another candidate key is used, a GUID. While I am not the original author of the ...
- 35
-1
votes
1
answer
67
views
How can I model resource exchange processes?
I'm trying to model the economy of a resource management game. Processes turn one type of resource into another, at varying rates.
For example, process A turns 1x item A into 1x item B. That's simple, ...
- 21
1
vote
1
answer
272
views
Create DuckDB table with primary key from parquet
I am trying to set up a simple but large DuckDB database with a single column of unique values as read from a parquet file. For faster inference of single-point existence checking (WHERE id = test_id),...
- 28.7k
-2
votes
2
answers
40
views
connect these tables with many-to-many relationship within a PowerBI report
I have a database about bicycles. One table is for the construction of the whole bike and one is for the construction of each wheel. There can be multiple rows for each bike since it can be other ...
1
vote
1
answer
41
views
How to track changes to a multifield record in DB
I have a table that keep records that can be added and then updated by a user. Record has many fields. Some fields can be logically grouped, some have similar or the same data type. I need to keep in ...
- 19.1k
0
votes
0
answers
104
views
Modelling auto parts equivalency in a database
I am developing an auto parts quoting and pricing application for a company that sells auto parts. The client wants the application to handle their internal daily operations, such as calculating parts ...
0
votes
1
answer
66
views
Reducing vacuum overhead & partitioning strategy for high-volume messages in PostgreSQL 13
I have a use case where I need to process a file containing messages generated for multiple customers. These messages need to be stored in a database and to be forwarded to respective customer in ...
- 771
2
votes
1
answer
80
views
Modelling objects and changes to object which evolve over time in a SQL database
I'm, wondering if there is
at least a name
and/or a generic solution
for the following problem:
I have an object that has some properties.
{
"name": "Foo",
"colour&...
- 1,858
-2
votes
3
answers
75
views
Database design for related data with different properties
Let's say a manager wants to see the activities of their team members (similar to an audit log). From the client, activities are displayed in a single list.
Here are some types of activities:
Common ...
- 1,007
0
votes
1
answer
43
views
How to model exclusive relation in relational database?
Let there be 3 tables: A, B, C.
A row in A may be associated to a row in B, or it may be associated to a row in C, but it must not be associated to both B and C.
In other words, the association is an ...
- 3,357
-2
votes
1
answer
48
views
How do multi user applications use databases? [closed]
For services that have multiple users, how does that translate at the database layer? Take a simple key-value store that would use a three column table: ID (acting as a primary key, I know that's a ...
2
votes
3
answers
157
views
Laravel Eloquent parent with multiple polymorphic children
I've been trying to model a relationship in Laravel between a ShapeContainer entity and different shapes with unique properties, but a common Shape interface (with getArea and getPerimeter methods). I'...
- 674
0
votes
1
answer
61
views
How can I modelling Company Node in Neo4J for Stock Database?
I am wondering if anybody can share knowledge model stock database in Neo4J.
At first I have Company Node.
Use Case 1 is:
At 2002 a company name is different for Example "Company A". And ...
