To improve a relation figure for a database

tags:

database

views:

answers:

To improve a relation figure for a database

+3 A:

User, UserInfo, Moderator and Password are redundant tables that offer no benefit.

They only express 1-1 relationships with User, so there is no need to normalize them into seperate tables:

Make one table:

UserId
Name
Email
PasswordMd5
IsModerator

FlySwat 2009-07-25 19:14:14

I need to store the user's password in a hash -form such that nobody connot read it. **Do I need a table for it such that I can check effectively that the password given by the user matches the one in the database?**

Masi 2009-07-25 19:29:11

No. You do the hash in your application.

FlySwat 2009-07-25 19:31:09

To clarify, you never store the cleartext pass in your database. What good is having both clear and the hash in your DB? Store just the hash, and then apply your hash algo to the inputted password then just compare hashes.

FlySwat 2009-07-25 19:35:31

@FlySwat: I know that the app works like, by multiplicating two very large primes, x and y, such that the product, z, is public: x*y=z. z is is the hash in the db and apparently y is in the db too. If user give the right password, the value of x, we let him in. -- **Should I have the parameter password-y in your suggested table too?**

Masi 2009-07-25 19:39:28

Please, see my reply to your answer about how I understand your answer: http://stackoverflow.com/questions/1182798/to-improve-a-relation-figure-for-a-database/1182876#1182876

Masi 2009-07-25 19:43:05

Never invent your own hashing algorithm. Use SHA1.

FlySwat 2009-07-25 19:50:49

@FlySwat: I am speaking of SHA1. I have never used it before. I only know its mathematical background. - **How can I use SHA1 algorithm in my database?**

Masi 2009-07-25 19:55:13

Are you sure you're thinking about SHA and not RSA? Your answer above that refers to large primes and public products sounds a lot more like RSA than SHA. They are completely different algorithms with different purposes.

Greg Hewgill 2009-07-26 00:41:53

Masi 2009-07-25 19:41:57

This table is improved at the thread http://stackoverflow.com/questions/1182910/how-to-improve-a-erd/1183112#1183112

Masi 2009-07-26 13:45:00

ansaurus

tags:

views:

answers:

To improve a relation figure for a database

related questions