Im really stuck with a problem that’s been driving me nuts for a day or so now. I hope someone can help.
Iv written a script to grab an XML file from the web , and the Bulk load it into my database. It works fine when I only use a very basic schema file, yet when I try to expand it to include additional attributes , im completely stuck.
The relational model and true relational databases does not have XML datatypes.
Do you mean you wish to load XML into a non-relational model in a non-relational database into a proprietary implementation without portability and poor performance? You can represent the XML schema in the DB as a relational structure instead of trying to store water in a built-from-paper pan.
That’s ok , I understand what he’s trying to say. Maybe I should of mentioned a few other points.
1. Im not a DB guy. I Work with SQL very often , but still only really know what I need to get by. (I should probably hang out in these forums more often)
2. This data. Is going to be bulk loaded in batches, every few hours or so, but the record count will be fairly low, around the 3000 rows mark. Querying this is very fast , and performance isn’t a concern. Having all the data I need in a single table is my preference right now , so that’s what im trying to do. Relationship models and more complicated structures aren’t needed right now.
My only bottle neck is those attributes. Can anyone help me fix that schema ?