I have been working on information extraction from biomedical text. So, I have come across many useful databases like PubMed, UniProt etc. But the biggest issue is that every source provides the data in xml format along with corresponding XSD schema file and I don't know any way to get this data into a relational database (mysql etc.).
I understand I can design my own database schema and then parse these xml files and insert data into the database. But this seems very cumbersome to do for all the databases that I need.
What method do generally people use to get data from xml files to any relational database?