Questions tagged [rdbms]
The rdbms tag has no summary.
69 questions
3
votes
1
answer
127
views
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
7
votes
1
answer
326
views
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
-1
votes
3
answers
622
views
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 ...
0
votes
1
answer
221
views
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
-1
votes
2
answers
542
views
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
1
vote
3
answers
1k
views
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
-1
votes
2
answers
213
views
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 ...
-3
votes
2
answers
73
views
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
2
votes
2
answers
900
views
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 ...
- 139k
0
votes
1
answer
168
views
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
-2
votes
1
answer
166
views
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
3
votes
3
answers
148
views
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
0
votes
1
answer
259
views
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 ...
- 109
-1
votes
1
answer
182
views
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
2
votes
2
answers
154
views
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"...
- 241