RE: Reusable components

[Clemens Wyss <cl...@mysign.ch>]

> One example: How do I best store hierarchical data like a
> (file system) folder structure in my data base?
how about JCR (jackrabbit->derby)? Either only for the "hierarchal" part of or the complete model...

> -----Original Message-----
> From: Thomas [mailto:Thomas.K.Hill@t-online.de]
> Sent: Thursday, September 30, 2010 11:27 PM
> To: derby-user@db.apache.org
> Subject: Reusable components
>
>
> When implementing the data model for my application using
> Derby and coding some
> stored procedures in JAVA over the past months I have asked
> myself a couple of
> times along the way what the best approach to fulfil some 'standard'
> requirements would be - general requirements which I would
> expect most people
> designing data base applications would have and will need a
> solution for.
>
> One example: How do I best store hierarchical data like a
> (file system) folder
> structure in my data base? In case of my application the
> decision was to go with
> the nested set model / using the modified pre-order tree
> traversal algorithm
> (the article 'nested set model' in wikipedia might be a good
> starting point for
> details on this).
>
> PEAR - the PHP Extension and Application Repository which is
> "a framework and
> distribution system for reusable PHP components" even has a reference
> implementation of nested sets in PHP - how exiting and
> unfortunate that this
> omly seems to exist for PHP.
>
> So I was wondering whether such reusable components actually
> might also exist in
> form of stored procedure code written in Java which could be
> used in data base
> management systems supporting Java as procedural language -
> like Derby -
> somewhere? (without me having come accross this)
>
> and if not, whether there might be an appetite of some users
> on this forum to
> dedicate some of their time sharing their solutions and to jointly
> build/test/document some reusable procedures? (which might be
> an opportunity for
> some people like myself who will never be able to contribute
> to advancing Derby
> itself (as I am not a professional Java programmer), but who
> have experience in
> data modelling and SQL and might therefore contribute in such
> an endeavor.
>
>
>
>