New answers tagged database-recommendation
SQL Server has transparent database encryption, which provides the functionality you are looking for. TDE performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery. The DEK is a symmetric key secured by using ...
Coding your application should not drive your database design. You should first write down the biz rules of your app. It seems you have different type of users (employee, admin and regular users), which mean they'll have different needs. Option2 seem a good approach. User table should have userType. REgarding the images, do they belong to the user (they ...
Read this post how StackExchange does it: http://www.brentozar.com/archive/2014/01/how-to-query-the-stackexchange-databases/
I would use Couch of any JSON storage. You can also develop a small module for protocolbuffer files loading if you do only read and write, no update. MongoDB can do the thing but you won't get advantage of your hadoop. I don't know what kind of data and processing you are gonna do.
Top 50 recent answers are included