Question : In a database named asterisk, there is a table named cdr which was partitioned on the time field. […]
Tag: data-integrity
How to conduct integrity test on SQL Server database backup file?
Question : I was assigned to check the integrity of database backups from sql server every two weeks. I’m new […]
Use of log_bin_trust_function_creators in MySQL
Question : What is the use of log_bin_trust_function_creators? Also, Is the value of the parameter dynamic? Will it change if […]
How can I enforce data integrity in this model with a M:2 relationship?
Question : This model describes a part of my database (somewhat simplified): A “Tumor model” describes an experiment a researcher […]
How to add a check constraint in Postgres without locking the table?
Question : I would like to add a check constraint to a very large table. Something like: ALTER TABLE “accounts” […]
How do I store phone numbers in PostgreSQL?
Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]
How do I ensure consistent MySQL backups?
Question : How can we ensure MySQL backups are consistent when they are taken as full backups as well as […]
Constraining data based on related data in a different table. Should this be done on the database level or the application level?
Question : I am working on a database that contains our customer information as well as information about our vendors. […]
how I can create check sum to validate no changes at int string pairs on table
Question : Business case is. 1)Users print document on paper 2)users carry printed paper to Boss, Boss sing on paper […]
Best approach to compare specific columns of 2 tables in different databases?
Question : I’m running an application who does have a shorten version of a table in the backend database. Both […]