oracle10g - Oracle - Use of XMLType or Name=Value Pairs (EAV) -

i working on designing data model log information.

the log information can have variable elements , dynamic.

what type of data model should work better? use of xmltype column or child table name=value pairs?

i want avoid creating multiple columns columns dynamic nature , can change frequently.

i know eav model not querying, have heard oracle 11g provides pivot function can transpose rows columns , how impact performance?

the data loaded used downstream etl systems , occasional querying technical analysts

thanks

---

rajesh... plan create 2 tables:

parent table common attributes part of every log event while child table have parent table id (logid) , have other transactional elements.

currently there 200 elements apart standard elements , log event can have unto 10 different elements. number volatile , can change frequently. not make sense keep changing table data structure every time there new elements.

also data not stored more 7 days , table not going used (or occasional) querying. there downstream etl job pull data , perform flat file transforms.

i not worried datatype because string data. see concerns approach?

i'd tend towards columns known, 'pretty there' stuff, , xml bits individualistic columns. xml going easier etl handle long there sort of schema work (possibly, not necessarily, enforced database).