Hi all,
I am trying to build Bio Database based on different file types (RAW, WIFF, DTA, MGF, mzXML) information to overcome searching or comparision on "set of files". The main drawback existed in previous tools is that support query on the only set of files, so questioning whole file type was impossible. My aim is building database and parse all files information into database , minimize redundancy and make GUI for quering.
The main good aspect is that I can convert almost all files to XML (mzXML or mzML) format. But, I am somehow lost in creating database from XML Schema. The problem I am facing is how to mapped these complex XML Schema into Relational Database? Moreover, the intensity of complexity increase when building relationship between the sets of XML schema elements. I went through XML2DB, but doesn't sound promising, Altova XML spy got feature but commercial product. So, I have to say till now haven't found soluton to my problem.
Parsing is second step; but building Database is important in the begining. I am trying to find out the solution. In between does anyone here in BioStar have experience regarding such matter?
Any suggestions, answers and comments are welcome!