Questions tagged [rules-and-constraints]
The rules-and-constraints tag has no summary.
41 questions
3
votes
1
answer
128
views
Constraint to enforce pairwise distinctness of values in two columns in table
I'm kind of stumped by a seemingly simple problem in Db design, but the more I think about about it, the more it twists my mind.
Let's say I have columns C1 and C2 in a table. How do I enforce that ...
- 141
-1
votes
1
answer
115
views
Rules (calculated field) engine
I have a fun problem ahead of me.
So, I have built a solution for my company that basically handles unstructured information. It works like this:
A user creates a Task, the Task is in reality just a ...
2
votes
4
answers
307
views
Is it a bad practice to query remote resources inside validation?
Watching this talk about Symfony Forms and validation, at 23:06, I got stuck with a doubt
I couldn't find a satisfying answer to:
Is it a bad practice to execute a query (or a web request, or a side ...
- 335
0
votes
2
answers
553
views
2 way multiplicity constraints in code
my goal is to convert this class diagram into Java code.
How should I approach this, given that I want the constraints to hold at all times? It creates a chicken-egg problem where the first Course or ...
- 195
0
votes
0
answers
78
views
Should a new access control mechanism use a precedence-based or an order-based permission system?
Let's say I have users, groups (or "roles") and resources, and I want to manage various permissions on those resources. As far as I can see, there are two main "philosophies" when it comes to ...
- 9,868
1
vote
4
answers
2k
views
Rules engine suggestion for hard coded if-then-else
Reposting question as Previous post on same Topic was not clear.
Currently our financial application receives multiple feeds in csv format from client, there are usually 100k to 5M rows of data. ...
- 19
1
vote
1
answer
2k
views
How to solve a Constraint Satisfaction Problem for Scheduling
This presentation describes several algorithms for solving a CSP for scheduling.
Say I have a few processes with some constraints:
a before c
c before b
b after d
c 50% more important than e
give d ...
- 2,787
14
votes
6
answers
5k
views
Forbid calls to arbitrary functions/classes in external code
I've experienced cases where it would be valuable to restrict access to the API of external libraries and frameworks to prevent negative consequences in the system.
For example, in a SharePoint ...
- 402
0
votes
1
answer
2k
views
How to design a Rule Engine Validation System to be asynchronous and highly performant!
I am implementing a validation system which has some constraints, there are category of users let's say 30 and for each category there are number of rules. Actually there are 100 different rules.
I ...
- 111
55
votes
7
answers
3k
views
What happened to database constraints?
When I review database models for RDBMS, I'm usually surprised to find little to no constraints (aside PK/FK). For instance, percentage is often stored in a column of type int (while tinyint would be ...
- 139k
0
votes
1
answer
258
views
Validating combinations based on rule sets (or similar mechanism)
Let's say I've got many functions and each function accepts an unordered list (order does not matter). For each function I want to see if this list is valid based on certain rules (a knowledgebase ...
- 11
5
votes
2
answers
686
views
Preferred approach to a matching process
I am currently in the process of putting together a matching algorithm. The matching process is as follows:
Query data is used to perform a "lookup" on a set of reference data in order to determine an ...
- 159
0
votes
2
answers
85
views
Trouble handling constraints for the input of a method
I'm looking for advice on how to handle constraints on the input of a method. I have a method that only works if the input argument(s) fulfill certain constraints. If the method is called on input ...
- 282
7
votes
2
answers
2k
views
Specifying a bi-directional unique constraint on a join table in Postgres [closed]
Problem description
I have a situation where I want to enforce that a relationship can only be defined once and I want to solve it on database (Postgres) level.
The following situation I consider ...
- 179
4
votes
3
answers
2k
views
C#/VB struct – how to avoid case with zero default values, which is considered invalid for given structure?
How to implement some constrained .NET struct/structure (let's say LimitedString), where its state with default values (set by CLR to technical defaults, i.e. nulls, zeros, etc.) should be prohibited ...
- 672