All Questions
126 questions
0
votes
0
answers
49
views
Database Design - What is the Terminology for these Two methods of storing data and what are the Pros Cons of each
There are many ways to link data when storing them in tables within a database and I am not sure how to refer to these two different methods.
I am also curious to know what pros or cons are associated ...
- 2,418
-1
votes
1
answer
62
views
Split 1 row into multiple fractional rows
I'm working on a restaurant POS system and I'm trying to devise a splitting system in order to split items into fractional quantities over multiple orders.
Here is simple summary of what I have so far:...
- 391
-1
votes
1
answer
38
views
Messaging App Data Design Not efficient enough
Im working on a database with the following tables.
Table Message
————————
Id -
Body -
Sender -
Receiver -
IsSeen (boolean)
Table Room
——————-
Id -
Name
Table participants
——————-
RoomID (foreign key ...
- 292
3
votes
1
answer
1k
views
How to maintain two versions of same entity available for edit simultaneously with relationship? [closed]
The problem
Consider these database tables:
Product
Order
Order Details
User
Product has columns:
Product_Name, Product_Description, Product_Size, Product_Cost, Product_Unit
Order has columns:
...
- 3,172
-3
votes
1
answer
237
views
Common ways for pair matching of users in a database?
hope you are safe and well!
I have a question about regular or common ways of pair-matching if there is a database of users: say there are a few properties of each user, and when matching, each user ...
0
votes
1
answer
289
views
How to use properly redis for storing objects and retrieve them
I am thinking of building an app in which your database is exclusively redis, I have some doubts about how to save information about the objects and then obtain it again.
Redis, on its official page ...
0
votes
1
answer
127
views
Recommendations for database schema/data structure for picking default value given a list
Sorry for the vague title.
We have a use case where we can get 0 to many roles and from that list we need to set a "default value"
For instance say we scan the text of a document (doc 1) for roles, ...
- 153
-2
votes
1
answer
249
views
What is the best Database Model for Directed Graph Data structure? [closed]
Relational database systems or document-oriented database systems?
If you want to choose between SQL and NoSQL which database systems will you prefer for a family tree,
Are there any advantages of ...
- 2,236
1
vote
1
answer
135
views
How to improve/maximize current Database/Table Structure efficiency?
The current structure of my Database tables are as follows; I have two tables, Users, and Skills, with the following columns:
Users
user_id f_name l_name biography password email ...
- 25
1
vote
1
answer
208
views
NoSQL (DynamoDB) database design
I am developing a small project which allows to track stock portfolios. Users can have an unlimited number of portfolios which consist of an unlimited number of stocks including information about the ...
0
votes
2
answers
67
views
A data design question of labeling sides in a battle game
I am designing a chess-like game but I believe this question can be extend to all games that have battle.
So my question is, how should I properly label an object as a friend
object or an enemy ...
- 249
-1
votes
1
answer
51
views
How can I keep a leading board of the top users with the most reputation with minimal reads and writes?
I am building a community that operates on reputation similarly to SO.
I need to keep a leading board of the users with the most reputation. Preferably by percentage (for example top 5% of users).
I ...
- 4,008
0
votes
0
answers
58
views
Need an optimized way to handle combination of entities to improve performance
So, I am working on a feature in a web application. The problem is like this-
I have four different entities. Let's say those are - Item1, Item2, Item3, Item4. There's two phase of the feature. Let's ...
- 619
0
votes
2
answers
401
views
Store Arrays of Integers in a Relational Database
I am writing an app that allows users to track gym exercises.
The data structure is as follows:
An exercise has an array of set, where each set has a value for reps and weight.
I can display this ...
- 2,964
1
vote
4
answers
2k
views
Order / Invoicing best practices: Store net / gross / VAT or calculate?
I am hoping someone could help on this.
I am updating an ordering / despatch and invoicing system.
I have a OrderItem table which includes the following (truncated for ease):
OrderItemId (PK)
...
- 59