I don't know of any resources like this, but I'm sure there are database books
which detail the use of tables to help configure code. Like I said, I based my
own tables off of what I've seen Oracle do, but there's probably a lot of
variations on the same concept.
Mike
Julian <[EMAIL PROTECTED]> wrote:
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 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 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]
---------------------------------
Do you Yahoo!?
Discover all that’s new in My Yahoo!
