Movatterモバイル変換

Question 1

0votes

1answer

42views

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 ...

Alan Graton

1

askedNov 17 at 13:41

Question 2

0votes

0answers

25views

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-...

Dongyun

1

askedNov 14 at 1:18

Question 3

0votes

0answers

9views

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 ...

Khairul Bashar

1

askedNov 3 at 10:50

Question 4

0votes

0answers

27views

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 ...

Sri Krishna

1

askedOct 24 at 10:46

Question 5

-1votes

1answer

95views

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 ...

Hugo Rechatin

1

askedOct 17 at 16:48

Question 6

2votes

1answer

104views

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 ...

brendans-bits

23

askedSep 15 at 2:04

Question 7

0votes

0answers

39views

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-87I tried to update the database its still not working. If it works I can import xml files ...

Adnan Joad

1

askedAug 30 at 11:20

Question 8

1vote

1answer

106views

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 ...

Emaborsa

121

askedAug 27 at 16:09

Question 9

0votes

0answers

30views

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) ...

karns

103

askedAug 25 at 13:12

Question 10

2votes

2answers

166views

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....

DevQt

205

askedAug 12 at 6:15

Question 11

-1votes

1answer

53views

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 ...

TheNKTLaw

1

askedAug 11 at 9:39

Question 12

0votes

1answer

114views

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), ...

Math Rules

178

askedJul 21 at 17:21

Question 13

0votes

1answer

116views

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 subcategoriesFurniture ...

ASINCAP

9

askedJul 5 at 13:46

Question 14

1vote

3answers

233views

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 ...

Jk Jerome

11

askedJun 18 at 2:59

Question 15

0votes

1answer

65views

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 = '...

Desert Wind

43

askedJun 1 at 17:22

Movatterモバイル変換

Stack Exchange Network

Questions tagged [database-design]

Modeling Addresses in SQL in Multitenancy Enterprise app

Designing scalable sensor data storage: wide table vs single table per sensor in DolphinDB

How to model a dynamic relationship in Hibernate where one field can reference multiple entity tables?

How to update complex data structure in RocksDB?

Best Design and Implementation Practices for a long (billions) and narrow table [closed]

Design of a table that references several columns in two other tables

When I hit iiq console in command prompt my Sailpoint says database version doesn't match the system version

Null value does not violate FOREIGN KEY constraint?

Location Hierarchy representing production rooms or first-class entity?

Evaluating File Data from FILESTREAM-Enabled vs. Non-FILESTREAM-Enabled Columns in a Single Table

Can the NKTg Law analogy help in modeling database performance under variable data loads?

What type of database should I use for this application?

Database Design for a Furniture Store E-commerce Site

Changing SQL Server Database Owner to SA Broke Application Login – Why Did It Happen and How Can We Prevent It?

how to purposefully mismatch database entries?

Hot Network Questions

Subscribe to RSS