If you have table based data with a lot of relations than an RDMS suits well the task. RDMSs can manage foreign keys and cascade records on delete for you. Usually RDMSs can be scaled well for read but not for write out of the box.
If you have less relations or the structure needs to be flexible then go with document based DBs. However you have to manage any relations and remove related unnecessary records on delete. Watch out for the NoSQL hype, analyse your situation. They usually can be scaled for write and read as well.
Other NoSQL databases such as Redis are perfect for key-value caching.