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
0
votes
4
answers
3k
views
Efficient way to search data based on multiple attributes
We are building a system where we accumulate data from many of our internal services, process them and generate set of data called Jobs saved to database. Our client application running on client ...
3
votes
1
answer
89
views
Using an array as a member variable in a class
I have a style question for designing a class to represent a real model.
Let's say I have Guide that has PointsOfInterest as a member.
Would I want to do something like:
class Guide {
public ...
3
votes
2
answers
3k
views
Design patterns for processing/manipulating data
Sometimes when I write a class or piece of code that has to deal with parsing or processing of data, I have to ask myself, if there might be a better solution to the problem.
Example 1:
In a recent ...
1
vote
2
answers
2k
views
How to design the datamodel of nested categories connected to a note?
I am building a personal app to store my notes in. It is not a new concept, of course, but it is giving me a great project to learn Node.JS together with trying out a graph database: Neo4j.
What I am ...
3
votes
3
answers
280
views
Modeling content management domain
The domain is more or less straightforward — I have an article (or rather several types of articles) that I want to edit and publish. Published article is exposed through an API to public. The thing I ...
24
votes
4
answers
83k
views
ERD: "many" vs "zero or many"/"one or many" crowfoot notation?
Background
I saw this figure describing the different crowfoot notations used in ERD:
I'm not able to find the difference between the "many" notation and the "zero or many. However I was able to find ...
1
vote
1
answer
138
views
How to model shared and unique options for a family of products for a relational database?
I have a family of products that currently houses 3 product lines. All 3 product lines share the same 4 options, but on top of those, each product line has 1, 2, or 3 different options respectively, ...
6
votes
1
answer
146
views
Should an entity id contain information about entity?
If an Entity doesn't have an unique ID, we usually use auto increment number to distinguish entities. But sometimes, we have to hand that ID over to people so that they can use it. So using auto ...
0
votes
1
answer
216
views
How to choose a data model?
Although this question takes a very narrow, concrete form, I'm more interested in the conceptual underpinnings of justifying an approach, and how I can apply it to the next problem.
Setup
I'm ...
5
votes
2
answers
16k
views
How multi-valued and derived attributes are denoted in crow foot's notation of ERD?
In Chen notation multi-valued attributes are denoted by double eclipse(oval) and derived attributes are denoted by dotted eclipse(oval), but how they are denoted in crow foot notation?
Also how ...
2
votes
3
answers
614
views
Database design for changing user roles
What database design would you suggest for the following example?
Example: Imagine a bus with some people inside. Every person has some attributes like name, etc. Also there are driver- and passenger-...
1
vote
4
answers
1k
views
Best way to model "Composite Skus"?
I have a SKU record which keeps track of raw materials used, pricing, cost, etc. An example SKU would be a Hamburger (1 bun, 1 patty, 1 oz ketchup, costs $11 make, priced at $4, etc).
I need to add ...
1
vote
1
answer
79
views
KPI Module structure
My plan's to develop a module for easy customer KPI handling across projects.
It should consist of a small SDK to put 2-3 lines of code in the project, a "template"/model for a SQL table (code first ...
1
vote
2
answers
454
views
How to update a model with dependencies
I'm having a bit of a hard time figuring this out. I have a model (which you can see in the image below) this model can be changed (it won't happen often, but it can). When it changes I do not get the ...
-1
votes
1
answer
202
views
How to design and store life cycle or states for a Java entity bean?
In our application, we have a pojo mapped to some entity. One pojo refers to one entry in DB. There are multiple steps for it's life-cycle. It gets created freshly, it goes 'live', after some ...