Stack Overflow
Stack Overflow

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
1 answer

Merging records from the same table

I have a database which has contact details ranging from the unique contact id, name, address, city, zip ,phone, pager, cell, website and etc). I have noticed there are duplicate contacts (contact id is different first name and last name is same,…
user3470756
  • 53
  • 1
  • 8
0
votes
2 answers

Repeated id in children tables

I'm wondering what the pros and cons of having a repeated id in child tables in a database. For example, consider a table parent: create table parent ( id int, a text, b text ) And this parent has a child1 table that references it: create…
cdmckay
  • 31,832
  • 25
  • 83
  • 114
0
votes
1 answer

md5 checksums when uploading to file picker

Background I'm working on integrating an existing app with File Picker. In our existing setup we are relying on md5 checksums to ensure data integrity. As far as I can see File Picker does not provide any md5 when they respond to an upload against…
Thorbjørn Hermansen
  • 3,522
  • 1
  • 21
  • 12
0
votes
1 answer

java serialization across networks data integrity

How to ensure data integrity when sending serialized objects across networks. Implemented example would be helpful. One way could be to use java.io.Externalizable with java.security.MessageDigest But this is requires a manual serialization. I think…
vartika
  • 35
  • 1
  • 7
0
votes
2 answers

Relational Integrity between OLAP and OLTP

I've been reviewing a client's architecture, particularly their OLAP system, which is just a regular old snowflake schema on SQL Server. The facts and dimensions are ETL'd in from other transactional systems such as ERP. One thing that jumped out at…
João Bragança
  • 1,353
  • 1
  • 13
  • 29
0
votes
1 answer

Composite key with user-supplied string column, foreign keys

Let's say I have the following table TABLE subgroups ( group_id t_group_id NOT NULL REFERENCES groups(group_id), subgroup_name t_subgroup_name NOT NULL, more attributes ... ) subgroup_name is UNIQUE to a group(group_id). A…
akp
  • 21
  • 1
  • 1
  • 6
0
votes
2 answers

How to make sure that the file passed using java.net is as it was before transmission

I'm studying java.net and trying to transmit som file. here is the sender code public static final FilesGetter filesGetter = new FilesGetter(); public static Socket s; public static File[] files; public static void main(String args[])…
Nikitin Mikhail
  • 2,983
  • 9
  • 42
  • 67
0
votes
3 answers

Browse button using Java to import files

I am developing a checksum generator application. I, for now, designed it to give SHA/MD5 output of strings values. I would like to know if you can import files so it can act as an integrity checker too by creating hash values for imported files.…
user2529236
0
votes
1 answer

Social Network: Delete Post in Database Without Breaking Application

Introduction I am designing a social networking website for college students. To facilitate moderation, some students will be designated as moderators with elevated abilities to delete inappropriate posts and review flagged content. Question When a…
ProfileTwist
  • 1,524
  • 1
  • 13
  • 18
0
votes
1 answer

Is this the correct way to use a checksum?

I'm working on an app that, among other things, downloads images from the web. Some of my testers are finding that images fails to download. In some cases, downloading fails in the middle. The image that ends up on displaying is something like…
Moshe
  • 57,511
  • 78
  • 272
  • 425
0
votes
1 answer

Database Table per Type with exclusive Sub-Types

In a table per type architecture, say I have a type Person with two sub-types student and teacher. A student cannot be a teacher, and a teacher cannot be a student. Below is the best way I know how to set these up so far: Geometry ID int, PK …
Eric
  • 1,392
  • 17
  • 37
0
votes
1 answer

how to ensure data integrity using the function storeFile() of the php driver of mongodb?

I ask my question here because I didn't found any information anywhere else yet. The context: - replicaSet architecture with 3 servers. - PHP as main language - the picture average size is around 2Mo - usage : storing a lot of galleries into…
sephiroth66
  • 185
  • 1
  • 1
  • 7
0
votes
2 answers

Enforce integrity constraint for closed loop foreign key constraints

The problem arises from the following three tables - Tour - Id TourPackage - Id - TourId Traveller - Id - TourId - PackageId The foreign key constraints are in place. However, I also wish to enforce that Traveller's Package must also refer…
bhootjb
  • 1,501
  • 1
  • 21
  • 33
0
votes
1 answer

Sub query in check "not allowed here"

I am trying to add a constraint onto one of my tables to ensure that my workers maintain a station if and only if that station is in the state which the worker is currently employed. However, it seems that Oracle does not like subqueries inside…
Fallenreaper
  • 10,222
  • 12
  • 66
  • 129
0
votes
1 answer

oracle database: create a PL/SQL procedure that checks the duplicated data

I want to create a PL/produces that checks the start date and end date in the database. here is my data HAS_CONTRACT DATE_FROM DATE_TO DURATION ---------------------------------------- --------- ---------…
user1851359
  • 139
  • 2
  • 14
1 2 3
…
22 23