Questions tagged [data-modeling]
Elaborating passive data structures based on the analysis of data requirements for the purpose of designing and implementing standardised data formats, databases and data processing systems.
112 questions
2
votes
1
answer
101
views
How to make the common "organization > project > content" conceptual model handle more subdivisions?
I am working on a system of websites and am back to an age-old problem of how to group the content.
In simplest terms, I am wanting to build something like a hierarchical organization of content, ...
- 2,787
-2
votes
2
answers
153
views
Preventing duplicate customers from company entry vs mobile sign-in [closed]
We have a system where customers can be created in two ways:
By a company — the customer belongs to that company and the company can edit their information.
By a mobile user — the customer has a ...
- 13
1
vote
1
answer
144
views
Fixed vs dynamic properties for a system with customization and changing requirements
Edit: writing a more specific question, as per comment, I guess my question boils down to: are dynamic properties designs appropriate for applications with rich UI and complex business logic (as ...
- 113
0
votes
1
answer
629
views
Data Flow in Data Flow Diagram
Consider the following level - 0 dataflow diagram for a patient management system :
Consider the doctor entity, the system provides an appointment report to the doctor. If the system only generates ...
- 43
-1
votes
1
answer
229
views
Modeling a CSV file: What is the standard? Python or SQL?
I have a wide CSV file of about 350mb, and want to load it into a SQL database and properly model the data to make it easier to use for analysis.
I could split the data into tables with python and ...
- 111
0
votes
1
answer
103
views
using same table for multiple features a bad coupling?
We are migrating a template that was a mere questions array questions
[
{
type:text,
name:first,
value:What is our name
},{
type:radio,
name:favourite fruits,
value:[
...
- 131
1
vote
5
answers
345
views
Data Modeling: Are technical concepts within a tool that implement a business entity entities as well?
I believe this forum is the correct one for my question, based on the community guidelines but let me know if not. It seemed like the best fit.
I am performing a data modeling exercise to formulate a ...
- 229
0
votes
2
answers
126
views
Tradeoff: Fetching less data vs having a simpler data model
We have 2 vehicle types in our system Car and Bike. Both can be associated with a Report.
There are components in our system which operate on Report but when dealing with the report they need to check ...
- 131
1
vote
2
answers
1k
views
Should I duplicate or inherit a python dataclass which changes attributes based on the version of an API endpoint?
I'm working on a python library for a REST API.I'm using python data classes to represent the structure of the returned JSON
The v2 of this API returns a slightly different object when compared to v1.
...
- 127
1
vote
0
answers
1k
views
Python - Where do I store data classes which are common across different files?
I'm working on a python wrapper for a REST API. I'm using python data classes to store the shape of the JSON response of each endpoint so developers have features like autocomplete and objects they ...
- 127
3
votes
1
answer
308
views
User (Actor) data shared across Domains / Microservices
I have read through a number of posts on Software Engineering but am unable to find a suitable solution for the problem my team and I are trying to solve.
We are building a system where we have ...
- 83
-1
votes
1
answer
445
views
How to model a ternary relationship in a graph-based paradigm?
Consider a context where we have Users saving Questions and adding personal Tags to them.
In a graph-based paradigm, a first approach could be something like:
(User)-[SAVES {tags}]->(Question)
...
- 71
1
vote
2
answers
2k
views
How to document a NoSQL document-based data model?
How do you document the logical data model of a document-oriented database like MongoDB?
For relational databases, Entity-Relationship diagrams or UML class diagrams are used.
What is the practice for ...
- 71
0
votes
1
answer
77
views
Is there a difference between these two data models?
Let us say I want to store on a database a userID, their nationality and if they are from the UK their UK passport number.
I could model this by having one table with userID as primary key, ...
- 1,159
1
vote
4
answers
628
views
Thinking about data as object vs table row [closed]
It often happens that we have a set of structured data. Let's say our data is about charitable organizations. I could turn it into a list/set of objects/structs:
struct Charity {
let name: String
...
