MySQL Forums
Forum List  »  Connector/Node.js

Import data (with logical structure) into MYSQL DB
Posted by: Jakub Ježek
Date: November 16, 2009 08:32AM

Hi,

I have the problem with design of my db. I need to import data prom OVAL definitions files (XML structure) into my db. My original schema works for simple XML files. But for more complicated structure of criterion elements isn't useable. CRITERION are in relation given by their atribute OPERATOR. It could have values from AND to XOR. But usually has AND or OR. Criterions contain links to some tests about presence of pkgs in particular versions.


I got schema here:
http://fi.muni.cz/~xjezek2/temp/mysql_forum/database_model_oval3.png

Simplier XML:
http://fi.muni.cz/~xjezek2/temp/mysql_forum/com.redhat.rhsa-20091490.xml

Complicated XML:
http://fi.muni.cz/~xjezek2/temp/mysql_forum/com.redhat.rhsa-20091463.xml

And why I need this in db? Because I need to be able to answer queries like this:

I have for example this structure :

test1 AND test2 AND ((test3 ANd test4) OR test5)

And I need to know, if I have pkg of particular version in my system, it belong to this definiton.

And my question is:
How to design scheme of CveCriterions table?

I hope I descibe my problem understandably. Sry for my bad English.

Jakub Jezek

Options: ReplyQuote


Subject
Written By
Posted
Import data (with logical structure) into MYSQL DB
November 16, 2009 08:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.