Questions tagged [data-integrity]

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.

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…
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…