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. Use this tag for questions about checking whether data has been tampered with; keeping data safe and unchanged; keeping data in sync; or properly cleaning up after data changes.
Questions tagged [data-integrity]
333 questions
0
votes
2 answers
Save id against a record in another table or in an array in a field
I'm doing some php/mysql work and started to wonder what would be more efficient and what method would have better data integrity.
I've never used method #2 but i have seen it used in systems like a CMS or eCommerce. I use #1 regularly.
Example:…
mylesthe.dev
- 9,565
- 4
- 23
- 34
0
votes
1 answer
Fixing broken integrity hierarchy trees using SQL
I have a basic parent child table (parentid int, childid int) for groups where top level groups have a parentid of -1. I would like to make sure that changes in the org structure did not break the chain, and if they did, fix it. Meaning if there is…
user1480192
- 665
- 8
- 23
0
votes
1 answer
What unit-testing framework can I use for testing quality of data in database
I am having a Database using which we show reports that is group by applying count etc.
I just need to have the best unit test framework in place which can help me out in querying the database automatically and verifying the result.
Abhishek Parikh
- 171
- 1
- 6
- 22
0
votes
0 answers
Java beans data integrity issues in multithreaded web application
I have an XML configuration file for my web application, which is read using JAXB, only once per JVM lifecycle - on the first call to the application. The results are cached in Java beans inside a singleton class - again, only once. This singleton…
Phani K
- 1,133
- 2
- 11
- 14
-1
votes
0 answers
Addressing Security Concerns in Location-Based Rewards App
My team is currently developing a mobile app that calculates user distance based on their location and offers rewards accordingly. The app obtains the user's present location, then sends this data to the server through an API request. (If there's a…
Mason
- 69
- 7
-1
votes
1 answer
Creating a composite foreign key for different tables using id and ENUM
I'm designing a PostgreSQL database schema where I need to establish a composite foreign key that references various tables based on an ENUM value stored in another column. In main_table has columns target_id and target_type. target_type column…
Artem
- 358
- 3
- 15
-1
votes
2 answers
How to write a key name in the type script interface if it has '-'
export interface team {
football:Football
table-tennis:TableTennis
}
export interface Football{
goalPost:any
ball:any
}
export interface TableTennis{
bat:any
ball:any
}
Sayan
- 47
- 12
-1
votes
2 answers
Associate joined table rows with same parent table rows if a value of field in parent row is same
I have data in two tables. City and Address.
City
id - name - code
1 - abc - 1
2 - xyz - 2
3 - efg - 2
Address
id - city_id - name
1 - 1 - wer
2 - 2 - sdf
3 - 3 - tyu
Now code for cities with id 2 and 3 are the same. I…
Sikander
- 834
- 2
- 10
- 33
-1
votes
1 answer
Data integrity checksum for file transfer with scp from local system to a flash drive connected on a remote computer
I am trying to check data integrity for a file transferred from local system to flash drive connected on a remote system.
So couple of questions:
Is scp good method to transfer files this way? I cannot transfer file directory to remote system but…
-1
votes
1 answer
Reindexing a position column in mysql
This is a MySQL question:
I have a table with the following structure.
reference
position
parent
Every item is meant to have a position, and each position should only be used once. The positions should increment (so if there are 40 items then the…
calumbrodie
- 4,722
- 5
- 35
- 63
-1
votes
2 answers
Split tables in SQL Server
I have a table called Students that stores all the basic information of students and trainings that they have attended to(The table has more than 15 columns and more than 5000 records). a sample part of the table is like this:
St_id St_Name …
Kabir Panahi
- 15
- 3
-1
votes
1 answer
How to check file integrity of download if checksum value is not posted
I plan to download a large amount of files from this website.
There are no checksums posted on this website (that I know of). Is there a way I can generate a checksum from the file on the server (perhaps via some Command Line Interface) and then…
arelevantuser
- 1
- 3
-1
votes
1 answer
Database Data Protection
The scenario is that our client owns and manages a system (we wrote it) hosted at their clients premises. Their client is contractually restricted from changing any data in the database behind the system but they could change the data if they chose…
Lewis Harvey
- 332
- 2
- 10
-1
votes
2 answers
printf hex value output seemed bigger than is should
I have a function that calculate a 32 bit CRC,
I have an internal variable to a class that hold the CRC.
the function that validate CRC consistency return a boolean result of the class CRC with what the class is calculating,
the member function…
aah134
- 860
- 12
- 25
-1
votes
2 answers
Creating trigger for date of Birth
Please can someone enlighten me on how to create trigger for date of birth having upper limit of 60 and lower limit of 20. I am working on an assignment that requires constraint on staff age range for a shipping company on oracle 11g. thank you
