Top "Data-integrity" questions

taking steps to ensure that data will not be accidentally or maliciously changed or altered, or verifying whether data has already been changed in such a way.

What's wrong with foreign keys?

I remember hearing Joel Spolsky mention in podcast 014 that he'd barely ever used a foreign key (if I remember correctly). …

database database-design foreign-keys referential-integrity data-integrity
Can Foreign Key be null?

In our database project we have a table Sale that has an primary key and two exclusive foreign keys: Vehicle_…

sql oracle database-design foreign-keys data-integrity
File containing its own checksum

Is it possible to create a file that will contain its own checksum (MD5, SHA1, whatever)? And to upset jokers …

security checksum data-integrity
How to perform checksums during a SFTP file transfer for data integrity?

I have a requirement to perform checksum (for data integrity) for SFTP. I was hoping this could be done during …

sftp checksum data-integrity
Does TLS ensure message integrity and confidentiality of data transmission in a RESTful Java enterprise

I want to apply web service security according to OWASP Web Service Security. Thereby I stumbled over the two points: …

security ssl data-integrity confidentiality
How to overcome Netezza's lack of unique constraint/referential integrity enforcement?

It appears that the lack of support for enforcing 2 basic constraints (unique and foreign key), is a reason for loss …

database data-integrity netezza