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
3 answers
Export to csv, string w/ comma in it, splits it up
This code exports data into a csv file, which is opened within Excel.
When a string has a comma within it, it messes up the order of the data.
I need help modifying my code below to resolve any strings that contain a comma within it, to not to…

Brad
- 12,054
- 44
- 118
- 187
0
votes
2 answers
Inserting Data into Tables and Integrity
This is my first post, so please excuse me for any obvious or simple questions as I am very new to programming and all my projects are a first to me.
I am currently working on my first database project. A relational database using Oracle sql. I'm…

Rob Doyle
- 1
- 2
0
votes
2 answers
Database Model Normalization - Data Integrity
Here is my question, I have 2 basic entities.
1-Order and
2-Delivery Type (basically a look up table 1-email, 2-download, 3-USPS Mail)
Let's say a customer places an order and chooses delivery type 3-USPS Mail.
My orders table stores the id 3 to…

user714142
- 57
- 5
0
votes
1 answer
Search for consecutive sequence violation
I want to test for string corruption and it would be easiest to use a regex that finds violations of a repeated sequence of characters. Suppose the sequence used for validating integrity is 0 to 9.
For example, '0123456790123456789' would match…

Jeff Axelrod
- 27,676
- 31
- 147
- 246
0
votes
0 answers
Access Display two fields from one table
I have an ASSET table with two fields one is the ASSET NAME, The other an ASSET SERIAL. The NAME always has a unique serial number. attached to it.
I have a MASTER LOG table, and the field for "ASSET" is a dropdown containing the ASSET NAMES. I…

Eric Anthony
- 927
- 1
- 8
- 15
0
votes
0 answers
I need help implementing this algorithm for the 1worldsync DAM API
public static String calculateRFC2104HMAC(String data, String key)
throws java.security.SignatureException, java.security.NoSuchAlgorithmException,
java.security.InvalidKeyException {
String result;
// get an hmac_sha1 key from the raw key bytes…

BanMe
- 133
- 1
- 8
0
votes
1 answer
PHP: How bad of an idea is it to store shared user data in MySQL as a JSON string?
I am working on a simple multiplayer game that may have 2 to 6 people in a game at a time. The game is only slightly more complex than Five-Card Draw poker so it isn't very resource intensive.
In order to make the development fast and easy I am…

azBrian
- 661
- 1
- 5
- 19
0
votes
1 answer
What is the best way to implement record updates on an ORM?
I'm writing a simple code generator in C# for automating common tasks on bussiness applications such as data binding, model and viewmodel generation and record updating.
The generated code uses a data mapper that implements equallity by reference…

Rafael
- 2,642
- 2
- 24
- 30
0
votes
1 answer
What's the best approach of deleting users from database with many relations in peer-to-peer marketplace in Rails 4?
This is probably a complicated one, but I'll give it a try.
We have a Rails app - peer-to-peer marketplace with lots of registered users in beta testing. Users have many items for sale and swap. User will get offers from other users that want to…

Ronen
- 734
- 1
- 9
- 14
0
votes
1 answer
How to protect chat messages from man in the middle (PHP, JavaScript)
I'm currently working on a chat system for my website. I'm no wondering how to protect the integrity of a message. I'm currently doing this via
chat.class.php
class Chat{
private $config;
private $randomJSONrpc;
private $MySQL;
…

jankal
- 1,090
- 1
- 11
- 28
0
votes
1 answer
how to guarantee data integrity in action class
I have a 3 layer web application which uses these frameworks: struts, spring and hibernate.
in action class I have called a method in business logic layer which update data in a specific table. now I have to call another class to insert data in…

AFF
- 1,515
- 4
- 21
- 35
0
votes
2 answers
Losing data after killing an SQL spid
It is a really dangerous situation for me as a novice DBA.
Sometimes when I see that there is a deadlock in Activity Monitor screen, if query doesn't ends and stay in suspend state and also a head block, I have to kill that spid. Not always, but…

Rapunzo
- 966
- 5
- 21
- 42
0
votes
2 answers
Hash code for comparing objects with the same structure between Java and C#
I am developing a mobile application (implemented in Java), which synchronises data with a web service (implemented in C#). I would like to check whether object received from the server (and saved to the database) has the correct data compared to…

syntagma
- 23,346
- 16
- 78
- 134
0
votes
1 answer
How does a production deployment for a cloud based software happen?
Lets take the example of a heavily used cloud based software.
When a deployment happens, let's say users are online.
Won't the server require stop & start after deploy? How is the service continuity maintained?
How will the ongoing user sessions /…

MKM
- 85
- 10
0
votes
1 answer
Integrity of two image files of different size running same os issue
I have a requirement. I have two virtual image files running light weight linux distribution (eg : slitaz),whose disk sizes are different. I want to check the integrity of the kernel running of these image files at a given point in time at…

SRK
- 49
- 8