data-integrity
Optional Unique Constraints?
I am setting up a SaaS application that multiple clients will use to enter data.However, I have certain fields that Client A may want to force unique, Client B may want to allow dupes.Obviously if I a[详细]
2023-02-04 11:37 分类:问答Calculating a "based" data checksum. (SHA1/2, etc)
I\'m not sure exactly how to ask this, but here\'s what I\'m hoping for, given a structure that could contain 5+n keys (thus, there are 5 keys mandatory to my system, additional keys are optional) - I[详细]
2023-02-02 02:22 分类:问答Tools, rules or processes for checking internal consistency of XML config files
I\'ve worked on projects that have very complex XML configuration, and one problem that\'s faced is maintaining the internal consistency of the XML.[详细]
2023-01-30 05:21 分类:问答how to handle multi-users connections with my php script?
If I write a script php writing 开发者_JAVA百科in a database, should I handle the locking of the database to avoid conflicts between users ?[详细]
2023-01-29 18:43 分类:问答SQL row modification constraint
I have a table, containing log entries. Is it possible to impose on it a constraint, restricting all modifications of rows, but still allowing addition and deletion of rows?[详细]
2023-01-28 23:26 分类:问答Need for both Ciphering and Integrity?
Why do some scenarios require both ciphering and integrity whereas some scenarios require only ciphering ? What are the factors that开发者_开发技巧 decide this in the case of networking domain ?Most s[详细]
2023-01-21 01:58 分类:问答MySQL transactions: multiple concurrent transactions and data integrity
I\'m using transactions for managing data across several MySQL InnoDB tables in a reasonably complex web application.Briefly, a given transaction works as follows:[详细]
2023-01-17 07:51 分类:问答Database constraints - keep or ignore?
When I was learning in university, they taught us the database fundamentals, basics and rules, and one of the most important rules is the constraints (primary key, foreign key), and how to make 1-m, 1[详细]
2023-01-16 11:28 分类:问答SQL Trigger not working correctly
here are the 2 table开发者_JS百科s i have, i want to implement an trigger that customer cannot have more than 5 accounts from a one bank, but can have more than 5 in total.[详细]
2023-01-16 05:13 分类:问答Repair Data Integrity
I think this is a long-shot, but here it goes: The basic question is: how does a development team beginning to repair data integrity on a large, damaged dataset?[详细]
2023-01-14 20:40 分类:问答