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.
110 questions
1
vote
1
answer
104
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
488
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
213
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
91
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
322
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
121
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
968
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
2
votes
1
answer
272
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 ...
- 73
-1
votes
1
answer
405
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
68
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
561
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
...
2
votes
1
answer
991
views
How to draw an aggregation relationship in the Crow's Foot Notation?
I was stuck on a relation description and unable to model it in the Crow's Foot Notation:
Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a ...
- 185
3
votes
2
answers
427
views
What to do when putting logic into the database seems to be the only option?
I am currently working on an application that models a complex business process that consists of many steps, each having a 1:n relationship with subsequent steps. The software is written Java using ...
- 149