All Questions
165
questions
1
vote
2
answers
64
views
How to system-design paying a payment with multiple currencies
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in ...
0
votes
1
answer
31
views
Database Engine to support Column References [closed]
I need to design a database/data warehouse that supports analytical queries on multiple tables. To simplify the problem, let assume two tables:
Orders(
id int,
company_id,
amount float
)
...
-1
votes
1
answer
83
views
Separate tables based on business goals
Is it worth to split tables bases solely on the business goal?
NOTE: The tables all have identical columns.
1. One table
One orders table, with a orderType column to differentiate them.
2. Two tables
...
0
votes
1
answer
597
views
How do I create a staging and production environment for the data within a database? Database/API/application architecture planning
I have two applications that will be going through my API and interacting with my database(s).
The first application displays production data that the customer can view, this has been through a QA ...
0
votes
0
answers
30
views
Keep financial data even when removing user from data base
I'm working on a system that manages clubs and associations.
One key factor of this system is that one person can be a member of more than one club.
Right now, I'm facing an issue where my system is ...
0
votes
1
answer
143
views
Is it bad practice to store a foreign key like user_id in all related model tables even if some of those models are children of related models?
We have 3 models: Users which can have Orders which can have a Transaction (like a credit card transaction).
Does it make sense to store the user_id on transactions or is that considered bad practice ...
2
votes
1
answer
699
views
Limit before sharding or partitioning a table
I am new to the database system design. After reading many articles, I am really getting confused on what is the limit till which we should have 1 table and not go for sharding or partitioning. I know ...
-1
votes
2
answers
172
views
Database Architecture: Central Database to Work as a Registry for Local Databases
The central database(blue) will hold all customer data of the project.
The local databases(green) will be deployed at the physical locations containing a copy of the customer databases. Multiple ...
0
votes
1
answer
88
views
Choosing proper database in AWS when all items must be read from the table
I have an AWS application where DynamoDB is used for most data storage and it works well for most cases. I would like to ask you about one particular case where I feel DynamoDB might not be the best ...
-1
votes
1
answer
290
views
Can we share the same database but different tables between micro services
We have two microservices which have different business logic. Assume business logic is quite complex hence decided to split it into new service but the domain is same. This new service requires some ...
-1
votes
1
answer
853
views
Unlimited levels of hierarchy in SQL table - PostgreSQL
I am looking for a way to store and handle unlimited level of hierarchy for various organisations/entities stored in my DB. For example, instead of having just one parent and one child organisation (e....
0
votes
1
answer
460
views
How can we sync a database schema that is shared between multiple projects repositories?
We have a database schema that multiple projects depend on. These projects are stored on github repositories.
Let's say for example that we have a user schema that is existing at both projects A and B,...
-1
votes
1
answer
375
views
Nested or different mongodb collections for e-commerce products with multi language?
He there, I use to work with Relational DBS, but right now trying to implement e-commerce shop and use mongodb.
I need the product, sub-products and description (multi lang);
I prefere to separate ...
0
votes
1
answer
111
views
Individual parameter tables vs wrapping them into a single table, which is better?
I've got various settings that need to be looked up and stored according to various parameters.
For example, I need to know the hardware settings, which depend on the computer being used and the type ...
0
votes
0
answers
71
views
How do I make multi-table update query everyday on MySQL
I'm working on automating the process of building a database. This is a database that needs daily updates after one build.
This database has 51 tables, divided into 3 schemas (there are 17 tables in ...