need opinion/ideia.. multiple databases good or bad ideia?
Posted on 2009-12-16
today i have the human resources database with tables like the employees.. emp address/fones/documents/ and everything related to the employees of the company.. and at the main system we use the employees info from this database to create a login system, where can tell what employee has access to what..
so then came the pcs inventory system where we store all pcs from the company.. then came several others small system such as this one.. and all related tables went to the human resources db.. (since we store info like last employee that modified this/that and stuff like a small ticket system that uses the employee id)
now there is now a kind of big system that will be related to the employees id and such again.. but is it better to make another database for it and then when we need to get the like who did what in this new db will need a join between databases to get it i dont know how good or bad that is..
should we let all system stay at the human resource db or split them all into their own db and make joins between databases to get the info from the employee ??
what i am afraid is that if i keep all system in one db.. it will get very big this db.. not sure if its a good thing..
ps. sorry for my bad english since it isnt my main language