Questions tagged [data-integrity]
The data-integrity tag has no summary.
67 questions
0 votes
1 answer
54 views
What happens in MariaDB if an index is dropped from a table while a join is running on that table?
I am running Fedora 42 KDE spin, and the output from mysql -V is mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using EditLine wrapper I have a script that runs weekly that creates a ...
- 161
0 votes
0 answers
55 views
Data Loss and data redeundancy when forced failed over to secondary replica on DR Data Center in SQL Server 2016
We are using SQL Server 2016 Enterprise edition and planning to have 2 datacenters primary and the remote Disaster recovery(DR). We have 2 replicas (primary replica and secondary replica) in the ...
0 votes
1 answer
200 views
Best practices for tracking ingested data sources
I am in the process of creating an ingestion pipeline wherein there exists a step of periodically reading new .csv files and storing them into a postgres database. This step is functioning, however it ...
- 101
2 votes
2 answers
1k views
How do you handle "undo" in databases in general, and PostgreSQL specifically?
I have a complex PostgreSQL-based system which I made myself from the ground up. It contains tons of invaluable (to me) data which I don't want to lose or get corrupted. I'm always paranoid about ...
- 287
0 votes
2 answers
2k views
Check for spaces or zeros in all columns in all tables
I have multiple tables in an Oracle schema that have columns with incorrect values: Number columns where the value is zero, instead of null. Text columns where the value is a space, instead of null. ...
- 1,527
1 vote
2 answers
2k views
How to ensure that two or more simultaneous requests to a MySQL table don't interfere
Suppose I have about a 1000 simultaneous requests to a table in my DB which consists of these statements (in order): SELECT INSERT or UPDATE (could be multiple) DELETE and I want to make sure that ...
- 13
0 votes
1 answer
104 views
Database design - logging of same value when recorded in multiple tables
I need to record changes to a particular value, which is read as part of multiple events that are all separately tracked, and be able to view a log of all of the values later. I think an example will ...
- 293
4 votes
1 answer
9k views
Changing a column datatype from INT to BIGINT
I have a large, partitioned table with a field in that needs to upgraded from INT to BIGINT. My intention is to detach each partition, make the change and then re-attach, using something like this: ...
- 1,313