Database for login application

2012 5 27
2 个回答
回答已采纳
1 次查看（30 天）

0 个投票

I want to make a login with few users,, as i read on the internet there are many methods to make a database (.mat,excel sheet,sql etc) and store user data, If anyone can provide me with details
1) What kind of a data base suitable for this application ?
2) How to do this ?
It would be a great help, thanks.

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2012-5-27

1 个投票

Any of those could be used, and your choice will not make much difference if you only ever have one access at a time. The choice starts to become more important if you have multiple simultaneous access and you are recording whether users are logged in or not.
For all of the possibilities you list above, you need to be careful of security. The temptation is to store the username and password in plain text. The security of that is gone as soon as anyone can get a copy of the database to examine. You need to encrypt the passwords somehow.

更多回答（1 个）

Milindu
Milindu 2012-5-27

0 个投票

thanks a lot ,,,
This login part is actually for a surveillance system application i am developing. Since it is a security application it would be good to have few simultaneous access and recording of users are logged in or not.
  • Why does my choice important in above conditions ?
  • Does this makes sql as the best choice ?
  • I do not have any prior knowledge in sql, so would choosing sql makes this part too complex ?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Walter Roberson
Walter Roberson 2012-5-27
When you have any information that is being written to, it is important that only one program at a time can write to the data (and only one copy of the program.)
If you only have one sensor, then you do not have to worry, as it can only do one thing at a time. But if you have several sensors, then they might need to access the data at the same time, and then you can end up with conflicting versions of information.
Database programs such as mysql are designed to be be accessed over a network and to internally handle multiple requests to the same data. A .mat file on a shared network drive is _not_ designed to protect multiple accesses.
I cannot answer whether sql is the best choice, or if one of the other databases is better. For example, would you be willing to pay 10 times as much for a database system that executed 1/100th of a second faster?
Milindu
Milindu 2012-5-28
Thanks for the ideas, i don't know weather i grasp everything you said, but it was helpful.
In my project i take video input and detect moving object in it, trying to detect weather moving figure is a human figure or not / if it is a human figure generate a alarm and record it . Since their are many objectives i think it would be enough to do a single access(one login at a time) and record log in time of that user. For that using .mat or excel is enough (i think).
If possible any information on working with .mat files would be a great help.
tnx
Walter Roberson
Walter Roberson 2012-5-28
What kind of information about working with .mat files were you hoping for? You can load() .mat files and you can save() information to .mat files.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by