Hey Michael,
Thanks for the input, you've offered me some great
insight. I was wondering if you may know a good
resource that discusses database design patterns like
the codelist or a line table? Otherwise, afaik I have
stored XML in the database and it's great if you just
transform it to an outputstream. However, trying to
make some decisions based on the xml requires parsing
into the application's domain model. This issue
concerns me when it comes to using XML for user
preferences. It sounds like your approach may be more
scalable. Ok, I have to think about it.
thanks again,
Julian
--- Michael Klaene <[EMAIL PROTECTED]> wrote:
> I'd like to learn more about storing XML in the
> database myself. I really haven't had much
> experience there so I couldn't say if it is
> beneficial or not. I started out as a database
> developer so I tend to rely heavily on the database
> for a number of things, system prefs being one of
> those things. Oracle( as I'm sure other vendors do
> as well) uses 'codelist' tables for storing a great
> deal of application metadata and I've always liked
> that approach.
>
> As I said, I wrote/am still writing a system where I
> define codelists that define different preferences
> ('show_x', 'hide_a'). A user preferences table
> contains user_id, but also columns name and value
> which would include 'show_x'/'true',
> 'hide_a'/'false').
>
> Mike
>
>
> Julian <[EMAIL PROTECTED]> wrote:
> I forgot to mention:
> 1) I cannot use Xindice since I do not feel it is
> viable.
> 2) I expect to have thousands of users with a
> moderate
> load.
> 3) I am leaning towards Michael's suggestion:
>
http://www.developer.com/db/print.php/10920_3413151_1
> Comment appreciated :)
>
>
> Thanks again, Julian
>
>
>
> __________________________________
> Do you Yahoo!?
> Meet the all-new My Yahoo! - Try it today!
> http://my.yahoo.com
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
>
> ---------------------------------
> Do you Yahoo!?
> The all-new My Yahoo! – Get yours free!
=====
Live simply so others may simply live.
-Ghandi
Pluralitas non est ponenda sine neccesitate.
"Entities should not be multiplied unneccesarily"
-William of Occam
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
