Tagged Questions
23
votes
10answers
2k views
How do you organize highly customized software?
I'm working on a large software project which is highly customized for various customers arround the world. This means that we have maybe 80% code which is common between the various customers, but ...
3
votes
4answers
715 views
Is this database design sound and fully normalised?
I'm creating a database to store words. The intended usage is to query the database to find a word matching a set of filters. E.g. if I wanted to find a word with < 10 letters, < 3 syllables, ...
3
votes
4answers
584 views
Which database should I use to manage relationship?
I need 2 capabilities:
calculating mutual friends distinguishing between different types of edges, (e.g. FRIEND, ENEMY and other)
getting relationships distinguishing between different types of ...
3
votes
2answers
497 views
Is there a design pattern for modelling job execution flow?
In my application I have a set of jobs to execute:
Each job goes through the states "not started", "started", "completed", "failed" etc.
Each job has a set of pre-conditions and post-conditions.
...
2
votes
2answers
167 views
Should database-models (conceptual or physical) be reviewed by DBAs?
Where I work, new applications that are being developed that will use their own relational database, must have their database-models (conceptual, then physical ) reviewed and aproved by DBAs.
Things ...
2
votes
3answers
503 views
Is there a better way of handling access control logic instead of it being in the UI?
Through most of my dev experience, I've never had to deal with much variety of access control architectures.
They've all been pretty straight forward:
Group [Create, Update, Delete]
- User 1
...
2
votes
2answers
119 views
Pattern for group of entities with one required primary member
Given a parent entity with a collection of child entities where there must be exactly one primary child of the group?
To make the question more concrete, I've seen a number of ways that this pattern ...
2
votes
1answer
460 views
Status update & news feed database design / architecture
Imagine a application similar to Facebook, where you have status updates and a news feed. The names and profile pictures can be changed. There are also several different types of updates requiring a ...
1
vote
4answers
368 views
Schema Design : Advice Needed
I have a distributed data collection system where I have first layer as regional Databases where all collected data is initially stored and master database where all the data is consolidated, what are ...
1
vote
2answers
82 views
How can you predict the time it will take for two processes in two different machines in a cluster to communicate?
I am trying to develop a computing application which needs a lot of memory (>500gb). Buying a single machine for that is overly expensive. I can, though, buy ~100 small instances on Digital Ocean or ...
1
vote
1answer
121 views
Should I really need to implement event sourcing is this case?
An example of use case when event sourcing is applicable here whose excerpt is:
Say, something went wrong in your app and as a result, a user gets
blocked for abuse but that user claims to not ...
1
vote
1answer
1k views
Books that every software system architect/data modeller must read [closed]
I hope I'm not confusing the term system architecture with the data model/database.
Is there a book out there that's the standard for describing best practices, design methodologies, and other ...
1
vote
1answer
102 views
Database design: circular reference but dynamically created
I am trying to design database for this case:
Assignments have vectors, relation is 1:N
Assignments have submissions, relation is 1:N
Submissions have executions, relation is 1:N
Every execution ...
0
votes
1answer
101 views
Do we have any special design considerations for maintaining anonymity in an application?
This is an open-ended question which I am analysing while doing some fun projects in leisure. Websites like Google, Facebook do store user activities and perhaps sell them or use them for ...
-1
votes
1answer
106 views
Should We Use Surrogate Primary Keys for Every Table? [duplicate]
We are developing a data model for a marketing database that will import transaction, customer, inventory, etc. files and the directive is ONE process that works for every client. We have been told ...
