Questions tagged [database-design]
For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.
108
questions with no upvoted or accepted answers
5
votes
0
answers
533
views
Graph Database, Storing Transactions
I'm working on getting a handle on Graph Databases (using Neo4j) and am trying to wrap my head around where "the line" is between what makes a good fit for GraphDBs and what should be strictly RDBMSs.
...
4
votes
0
answers
58
views
Designing provisioning strategies
I'm trying to redesign a provisioning application that administrates other application through their REST API.
The application is quite simple, we have groups, we have users and roles and we have a ...
4
votes
0
answers
2k
views
NoSQL data modelling for multi level nested documents
What kind of NoSql data modelling is best suitable for the following requirement?
This can be visualised (NoSQL-Document) as a Collection of Records where each Record contains nested Documents.The ...
4
votes
0
answers
562
views
Expiring counters in Cassandra
So I know that TTL is not available for counters because of design reasons and I've read https://issues.apache.org/jira/browse/CASSANDRA-2103 as well as some other SO questions regarding this but ...
4
votes
0
answers
538
views
What's the canonical way to store translations of user data?
I've developed some software that allows my users to attach a blurb to some non-language specific information:
Pseudocode model:
item():
ID
creationdate
byline //Only one byline for the object
...
4
votes
1
answer
1k
views
How should I store usernames and passwords for user login using php/cassandra?
I am new to NOSQL and Cassandra. I am not sure if I should store usernames and password in Cassandra. If I should, what is the best way to do that? I am getting lots of conflicting ideas from research....
3
votes
0
answers
55
views
How Best To Store Data Structures Around Flow
I'm working on building a simulator for HVAC units. The conceptual model I am working with is basically that an HVAC unit has inputs and outputs, and I need to be able to calculate the outputs for a ...
3
votes
0
answers
1k
views
Designing a database for storing external API results
I have hard time wrapping my head around and finding a solution on how to design a working database structure for this situation:
We have a system that should collect data from Google Analytics & ...
3
votes
0
answers
248
views
Saving tabular, spreadsheet-like data in a relational database?
I'm hoping this question isn't too broad or too prone to opinionated answers, since I could really use some pointers.
I'm trying to come up with a way to persist tabular, spreadsheet-like1, data in a ...
3
votes
0
answers
535
views
PHP Vertical Columns from 3 SQL Tables
I work at a high needs school in which there are several classes that plan their work through Excel spread sheets grading and tracking student progress. We have come to the conclusion that this ...
3
votes
0
answers
337
views
Best approach for displaying a price from a product according the "setup"? [Designing the DB table and relations]
I'm basically building a reseller website, in which people can buy (users) from a predefined product list and sell them at a higher price (clients).
I will show you some images to explain better ...
3
votes
0
answers
795
views
Redmine - Database Structure/Normalization
I am using redmine for project management and issue tracking.
I was looking at the database tables and the underlying structure and was wondering if anyone who is experienced with database ...
3
votes
1
answer
171
views
Database consistency for a distributed system
I'm working on a phone call monitoring project. The aim is to have one row in the calls table for each ongoing call. Each call instance may be updated by many different servers/threads as more ...
2
votes
0
answers
38
views
Populating form options in dynamic web form
I am looking for advice on database design for a web app I am building.
In the web app (Angular, REST API, Oracle SQL database), I am constructing a web form dynamically. I chose dynamic form ...
2
votes
0
answers
34
views
In a multi-region network, how do you organize requests through VPNs for atomic database transaction requirements?
I am trying to setup a multi-region (global) AWS system, where each region (which has multiple availability zones) has its own VPC. In theory these VPCs all use different portions of the private IP ...