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.
111
questions
4
votes
5
answers
2k
views
What is the normal form of JSON?
This is going to sound like a trivial question, but I like to think it's actually a deep one. The simple quesiton is, "What is the normal form of a typical JSON object?" For reference, I ...
- 59.9k
0
votes
1
answer
120
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 ...
- 9,272
-1
votes
1
answer
190
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 ...
- 210k
0
votes
0
answers
27
views
3 QAbstractListModels versus 1 QAbstractItemModel
This is a simplified representation of the existing data structure I have in my code (The actual data structure is composed of classes), the data of which I need to display and modify via multiple ...
- 133
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:[
...
- 77.5k
1
vote
5
answers
296
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 ...
- 8,633
0
votes
0
answers
23
views
An IoT client and MVC-based server. Data model with different fields per type?
The problem
Let's assume such scenario:
List of IoT devices (one model?)
Each list item has (among other fields) a type field
Depending on the value in the type field, device may report different ...
- 2,406
0
votes
2
answers
116
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 ...
- 210k
2
votes
3
answers
970
views
Database Model Classes in TypeScript
I'm using Knex.js with TypeScript for database access.
Table
uid (UUID, auto-generated by Postgres)
name (varchar)
Model
interface User {
uid: string | null;
name: string;
}...
- 200
1
vote
2
answers
814
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.
...
- 27.8k
1
vote
0
answers
620
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
5
votes
3
answers
466
views
Rebuilding a legacy application : What about the data model?
I am currently rebuilding from scratch a product catalogue (to feed a shopping website).
The existing legacy system is heterogenous, Long story short : The some products are stored in a FileMaker ...
0
votes
2
answers
282
views
Creating a "pass-through" dynamic model
We have a layer that exists in our architecture that, for lack of a better term, bears the responsibility of defining the common models. In other words, when systems need to communicate, rather than ...
CommunityBot
- 1
4
votes
3
answers
128
views
Using Multiple 'Sub-types' vs a larger single type?
I have a user model in an application that I'm working on, which currently uses sub-types to encapsulate properties depending on what type of user you are - I just can't help but think that this is ...
- 78.7k
2
votes
1
answer
250
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 ...
- 3,113