Questions tagged [rdbms]
The rdbms tag has no summary.
69 questions
3votes
1answer
102views
Constraint to enforce pairwise distinctness of values in two columns in table
I'm kind of stumped by a seemingly simple problem in Db design, but the more I think about about it, the more it twists my mind. Let's say I have columns C1 and C2 in a table. How do I enforce that ...
- 141
7votes
1answer
285views
Why is the highest NUMERIC precision in most RDBMS 38?
SQL-92 says: 16)For the <exact numeric type>s DECIMAL and NUMERIC: a) The maximum value of <precision> is implementation-defined. <precision> ...
- 277
-1votes
3answers
535views
Avoid race condition using RDBMS transaction
I am working on design of a distributed system which will process some events. For simplicity lets say, multiple instance of same service will be consuming from same queue, every message will have a ...
0votes
1answer
195views
How is B-Tree used in DBMS-s if WHERE condition can be anything?
The most of the database management systems use B-tree as a data structure for increasing the performance. Let's imagine that we have a table users with the following columns: id (int), name (string), ...
- 111
-1votes
2answers
523views
Should I store non-editable items lists in a database?
Relational database is mostly used for storing editable user data. But how about storing non-editable lists of information? Possible examples are: GUI-related: main menu items, selectbox options, ...
- 277
1vote
3answers
956views
Event Sourcing inside a RDBMS
I'm thinking about using an Event Sourcing / Event Store pattern in my RDBMS designs. What I mean by Event Store is a pattern where each data mutation (INSERT / UPDATE / DELETE) is persisted as an ...
- 111
-1votes
2answers
183views
Do I need to use Apache Kafka alongside another DBMS in my use case?
I have a project that relies on getting data from IoT devices. then I display the data analytics using a graph (in real-time) and also the state of the machines (are they working or not and the reason ...
-3votes
2answers
64views
Does it make sense for a large scale SaaS project to use a single all powerful SQL/RDBMS database?
Scalability seems to be a thing now. I was in a heated argument with one of my developer who insist on using MySQL for a data intensive application we are building. MySql is easy, fits the purpose and ...
- 121
2votes
2answers
852views
Isn't data migration a major benefit of MongoDB compared to the commonly used relational databases?
I was reading an old answer which was recently updated, and noticed that the author doesn't quote the simplicity of data migration as a benefit of MongoDB. I always thought that the major benefit of a ...
- 137k
0votes
1answer
147views
Combining relational and document database for movies
As a architecture design brainstorm, I am pondering on how should I define schemas for movie database where heavy text searching is delegated to document based database (eg. elasticseach) while rdbms ...
- 103
-2votes
1answer
149views
In DBMS are Secondary Indices ordered?
I've read that the Heap File Organization is usually used to structure a secondary index. This makes me suspect that usually, a secondary index is unordered, as opposed to the primary index, that is ...
- 113
3votes
3answers
140views
What is a good datastructure for localizable tags? (Like a blog post or questions at SE getting tagged with)
I am developing a web application where users can upload images and add tags to them. Because the audience is very international, I want the app as well as the content to be localizable. Most of the ...
user334372
0votes
1answer
239views
In a parent table - Child table relation , where to store order of children
Assume a Parent -> Child relationship in RDBMS. questionnaire table and question table. question table has a foreign key questionnaire_id to store which questionnaire it belongs to. Questionaire ...
-1votes
1answer
167views
Combine Ids to a single field
I would like to ask if there is any powerful method we can use to combine the Id's to a single field for faster search and retrieval. My case is like this, I have a table that stores ID's of ...
- 101
2votes
2answers
139views
how to model 2 objects that refer to each other in the DB
Now I have 2 objects which are "PROBLEM" and "SOLUTION", obviously "SOLUTION" is a proposed solution to a given "PROBLEM", my problem is that in my business I have the following relations: a "PROBLEM"...
