Relative Content

Tag Archive for rules-and-constraints

What does value propagation mean?

I am working on an algorithm which calculates intervals for variables in some given constraints. For example there is a function called propagateValues and its description is

Should I check integrity in my application code or defer to the database? [duplicate]

This question already has answers here: Should my multi-server RDBMS or my Application handle database Referential Integrity? (5 answers) Closed 11 years ago. At work we have a lot of code like this (pseudocode): response form_submit(string username, string password) { if ( username == “” || username.contains(invalid_chars) || password.length < 5 || … ) { […]

Fixing bad data in a database – redo or incremental

I have pseudo-ownership of a fairly old db (original data from 30 years ago; current design is >15 years old). In my opinion, the schema is pretty broken, and one of the implications of this is that there are a lot of inconsistencies/issues with the data. I’m planning to write a new schema and port the data across, which is a fairly simple task as new data comes in rarely.