I am working on the project which will automatically generate sample
schema analyzing existing
MySQL database and
logs. I am looking for help regarding the below questions. Please, share your thoughts,some links or references.
1) What are the
MySQL parameters which can help me to automate the process?
2) What are the criteria to design the idle
MongoDB database? What I should keep in mind while designing
MongoDB database? Example
MongoDB schema for any
MySQL database would be great help.
3) How denormalizing the
database will help?
4) Is there any existing opensource application/tool which can help automation process?