Questions tagged [database-design]
The development of the conceptual schema and/or the logical model and/or the physical settings of a database.
6,369 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
25
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
70
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 ...
0
votes
0
answers
24
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) ...
2
votes
2
answers
130
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....
-1
votes
1
answer
34
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
101
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), ...
0
votes
1
answer
89
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 ...
1
vote
3
answers
153
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 ...
0
votes
1
answer
54
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 = '...
2
votes
1
answer
215
views
Have multiple users for your DB per action?
I installed my mariaDB and phpMyAdmin. I created a new user with all the Grand and Super priveleges. And I deleted the "root" user for savety.
Perfect.
As I follow an article: make a ...
3
votes
2
answers
150
views
Database structure and storage for highly interconnected different data
I am trying to figure out the best way to structure and handle highly interconnected data of various types used for analytics and inference (of new data from old data).
There would be one-to-one, many-...
1
vote
1
answer
65
views
Is this ER diagram using crow's foot correct?
Im having some trouble to check if my ER diagram using crow's foot is right.
I have a exercise asking for this:
TAB_Pessoa = { cpf (PK), nome, data_nascimento, sexo }
TAB_Aluno = { matricula (PK), ...
-1
votes
1
answer
69
views
What are the best practices of a banking relational database? [closed]
I don't have any particular problem in mind, I am just looking for the best practices.
I am creating a bank database. Nothing too important or involving real money, nevertheless, I think it would be ...
1
vote
1
answer
44
views
Database Design for Managing Main and Custom Scope Entities
I have a database consisting of a main scopes table (containing standard scopes), a projects table, and a configuration table linking scopes to projects. I now need to allow for custom scopes that are ...
-1
votes
1
answer
65
views
Best Database for Bulk Reads and Fast Key Lookups for Genomic Data [closed]
I'm developing a system to store and query genomic data using a relational database (PostgreSQL being my primary candidate).
The dataset is quite large around 9 billion records with over 300 columns, ...