Hello, we have written an application (CMS with DB-Apps) with a very similar approach and stored the extra data in a sophisticated arange of tables (also rights and so on). We have wondered, why relational databases have no - or too less - support for such real world requirements. I don't know why there is no (to me know) standard for something like that or even natural support in one of the many DBs, but I also think, this would be an outstanding feature! Btw, what do you think about this, Fredt? ;-) Very many people have to implement matadata-like features over and over again. What about a standarized way? Who would enjoy this, what is against it?
Best wishes, Rainer Am Donnerstag, 11. November 2004 20:44 schrieb Michael Gerzabek: > Hi, > > At 19:40 11.11.2004, Rainer Pröbster wrote: > >Hi, > > > >why con't you just read out all the meatdata you need only at startup and > >create some kind of repository which you hold then in RAM? > > that's exactly what I'm doing now. The point is I had to create a rather > complicated lookup mechanism to get the form metdata from each SQL > statement that's used. > > So my idea is to plug into ResultSetMetaData. There I could link my forms > metadata with the database metadata and have them all in one place and can > get it very fast. I think I could 'deploy' the metadata at startup of the > database and never have to do an additional lookup for the form metadata. > > WDYT? > > Regards, > Michael > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: > Sybase ASE Linux Express Edition - download now for FREE > LinuxWorld Reader's Choice Award Winner for best database on Linux. > http://ads.osdn.com/?ad_idU88&alloc_id065&op=Click > _______________________________________________ > hsqldb-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_idU88&alloc_id065&op=click _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
