Questions tagged [database-design]
The development of the conceptual schema and/or the logical model and/or the physical settings of a database.
6,366 questions
0
votes
1
answer
42
views
Modeling Addresses in SQL in Multitenancy Enterprise app
I have a multitenant app where I'm having some trouble modeling the Address tables. It's an Enterprise App so the database is quite big.
Since tenants, users and persons can have N addresses I've ...
0
votes
0
answers
25
views
Designing scalable sensor data storage: wide table vs single table per sensor in DolphinDB
I'm designing a system to store large volumes of sensor data (10,000+ sensors) and evaluating different schema approaches in DolphinDB.
Current Context:
Data Volume: 10,000+ sensors, continuous time-...
- 1
0
votes
0
answers
9
views
How to model a dynamic relationship in Hibernate where one field can reference multiple entity tables?
I’m designing an application using Hibernate (JPA) and I’m facing a modeling challenge related to dynamic relationships between entities.
Here’s the scenario:
I have a Comment entity that can be ...
0
votes
0
answers
27
views
How to update complex data structure in RocksDB?
I have been working with RocksDB for a while, and in my use case, complex data structures are stored as values in the database — for example, a Map that may itself contain nested maps.
1. Update ...
-1
votes
1
answer
95
views
Best Design and Implementation Practices for a long (billions) and narrow table [closed]
I am about to start working on a project that aims at modeling all trees in France using the LiDAR coverage of the territory.
I won't get into the detail of the modeling but basically after ...
2
votes
1
answer
104
views
Design of a table that references several columns in two other tables
Is it possible to create a table that is built from an inner join of two other tables with additional columns, but where the rows are kept updated when the inner join is re-run?
Currently using ...
0
votes
0
answers
39
views
When I hit iiq console in command prompt my Sailpoint says database version doesn't match the system version
In mine it says Application's system version 8.4-104 does not match IdentityIQ database's system version 8.4-87
I tried to update the database its still not working. If it works I can import xml files ...
1
vote
1
answer
107
views
Null value does not violate FOREIGN KEY constraint?
I am wondering why Postgres allows to insert a non-existing values for a foreign key to a nullable multicolumn unique constraint. (Cannot be an actual primary key.)
I made a fiddle. I expected this to ...
- 121
0
votes
0
answers
30
views
Location Hierarchy representing production rooms or first-class entity?
I'm struggling to figure out the best way to model Production Rooms in our manufacturing ERP app. Currently, we have a Locations model which is a hierarchical, materialized-path (Ancestry Gem) ...
- 103
2
votes
2
answers
166
views
Evaluating File Data from FILESTREAM-Enabled vs. Non-FILESTREAM-Enabled Columns in a Single Table
Originally, I was working with .NET 9 and a Blazor web app for admin and a Flutter app for external end-user, but for this context, I constrained it to SQL Server 2017, to evaluate it first internally....
- 205
-1
votes
1
answer
53
views
Can the NKTg Law analogy help in modeling database performance under variable data loads?
I recently came across the NKTg Law on Varying Inertia in physics, which describes an object’s movement tendency based on its position (x), velocity (v), and mass (m), with m allowed to change over ...
0
votes
1
answer
114
views
What type of database should I use for this application?
I am currently designing a mobile application that sends push notifications to users subscribed to a set of topics. The list of possible topics changes infrequently (not more than once per year), ...
- 178
0
votes
1
answer
116
views
Database Design for a Furniture Store E-commerce Site
I'm building my first web project: a modular furniture e-commerce platform using Next.js and PostgreSQL.
I’ve designed a normalized relational schema to handle:
Categories and subcategories
Furniture ...
- 9
1
vote
3
answers
233
views
Changing SQL Server Database Owner to SA Broke Application Login – Why Did It Happen and How Can We Prevent It?
We're in the process of aligning with SQL Server security best practices and recently initiated a project to change database ownership from individual domain logins to the SA account across our ...
- 11
0
votes
1
answer
65
views
how to purposefully mismatch database entries?
I've got my standard MariaDB database with phpMyAdmin.
I'm working with OpenSSL and php. And I've got nothing more than a basic rented web-server.
$cipher_algo = 'aes-128-cbc';
$key = '...
- 43