Re: [xml-dbms] FW: DBVisualizer - XMLDBMS
- It's yours. Give the list a yell if you need any input about what the UI
should look like.
adam flinton wrote:
> D'you want me to deal with this or do you want to?
> > -----Original Message-----
> > From: Roger Bjärevall [mailto:rogge@...]
> > Sent: Sunday, October 29, 2000 11:16 PM
> > To: adam flinton
> > Subject: Re: DBVisualizer - XMLDBMS
> > Adam,
> > Having read your mail it seems like an interesting direction for
> > DbVisualizer. I need to find out exactly what this means both in terms
> > of XML-DBMS and how it would affect DbVisualizer. While I'm trying to
> > figure out the details of XML-DBMS it would be great if you
> > can describe
> > how you would like to see this functionality in DbVis. In terms of
> > layout, functions, display, etc.
> > Regards
> > Roger
Programming, Writing, and Training
XML, Databases, and Schemas
- For my current project, I am also interested in creating a GUI that provides
an easy method of generating mappings for DTDs. Can you forward to me, any
screen layouts or other specifications you may already have figured out so
>From: adam flinton <aflinton@...>_________________________________________________________________________
>To: "xml-dbms Mailing List (E-mail)" <firstname.lastname@example.org>
>Subject: [xml-dbms] FW: DBVisualizer - XMLDBMS
>Date: Mon, 30 Oct 2000 13:18:17 -0000
>From: Roger Bj�revall [mailto:rogge@...]
>Sent: Sunday, October 29, 2000 11:16 PM
>To: adam flinton
>Subject: Re: DBVisualizer - XMLDBMS
>Having read your mail it seems like an interesting direction for
>DbVisualizer. I need to find out exactly what this means both in terms
>of XML-DBMS and how it would affect DbVisualizer. While I'm trying to
>figure out the details of XML-DBMS it would be great if you can describe
>how you would like to see this functionality in DbVis. In terms of
>layout, functions, display, etc.
>adam flinton wrote:
> > Dear People @ ideit,
> > I am part of a group developing an OpenSource project called xml-dbms (
> > http://www.rpbourret.com/xmldbms/index.htm ).
> > In short the project is about transferring data between SQL Databases &
> > documents.
> > We are in the process of a major rewrite (mostly to accomodate / move to
> > Schema's instead of DTD'es so as to support typing (e.g. Integer,
> > etc) & other goodies).
> > @ the moment the whole process of building map files & then transferring
> > between DB <> XML (i.e from XML doc into DB & creating XML docs from the
> > is a commandline operation.
> > To aid users we are shoving together a GUI.
> > Looking for inspiration I chanced across DB Visualizer. I am extremely
> > impressed with the overall product. 1 quick question is why doesn't
> > the JDBC driver @ runtime (i.e. via the GUI) work correctly in Java1.2?
> > However my main question is:
> > I feel that the ability to generate XML out of RDBMS'es (& for RDBMS'es
> > absorb/consume XML Documents ) is going to be a vital part of data
> > management in the future. I think that XML-DBMS will provide that in an
> > & standards based way. I will have to build a GUI based Mapper between
> > SQL db & and an XML Document / schema such that mapping files can be
> > easily. I have seen your SQLDB GUI & think that the XML<>DB part would
> > into it extremely well & would help you sell your product (I am a Java
> > / developer so as far as I am concerned the more high quality Java Tools
> > there are the better.) I say that as I there are so few really good SQL
> > tools written in Java that I am loath to start re-inventing the wheel &
> > such affecting the livelihoods of others trying to make their way doing
> > same thing as me.
> > Would you consider building the XML<>DB GUI such that it alone could be
> > OpenSource but where you could include it within your application as a
> > item / tab? I do feel that this task will become a standard part of SQL
> > Database operations & maintainence.
> > i.e. if all you want to do is to do a mapping between SQL & XML then
> > is a freeware / OSS GUI tool but if you want the complete SQL design &
> > management ***including*** the XML<>SQL then buy DBViz.
> > The XML<>SQL part needs to be able to browse a DB structure (visually) &
> > allow a user to visually build / map a table / view / Sql Statement to
> > XML Schema using XML-DBMS (& take an XML schema & map that to a SQL
> > structure).
> > The low level stuff would be handled by XML-DBMS. This is mostly about
> > building a GUI for people who prefer to click on a schema (e.g. ADAM) &
> > a Table (e.g. COMPANIES) rather than type ADAM.COMPANIES. Equally
> > statement that selects companies & all the contacts which are Foreign
> > to a given company etc such that an XML doc could be produced which had
> > company with its details & then a child set of Contacts who are part of
> > company & their details. To me it's simpler CLI (Command Line Interface)
> > 'ing it but I accept that others might prefer the Visual route.
> > As I said I will have to get the above GUI functionality one way or
> > however what immediately struck me looking @ your product was:
> > A) It is a good product.
> > B) You must already have the DB/GUI side covered in terms of coding.
> > C) It would (IMHO) make for a serious selling point for DB Visualizer.
> > I look forward to your views.
> > Adam Flinton
>Roger Bj�revall roger.bjarevall@...
>Innovative-IT Development AB Mobile: +46 709 242012
>S�dermannagatan 48 Office: +46 8 55602760
>Box 20129 http://www.ideit.com
>S-104 60 Stockholm
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Share information about yourself, create your own public profile at
> -----Original Message-----Yup....I'll just finish some stuff & then I'll do that.
> From: Anar Daswani [mailto:anar_daswani@...]
> Sent: Wednesday, November 01, 2000 9:19 PM
> To: email@example.com
> Subject: Re: [xml-dbms] FW: DBVisualizer - XMLDBMS
> For my current project, I am also interested in creating a
> GUI that provides
> an easy method of generating mappings for DTDs. Can you
> forward to me, any
> screen layouts or other specifications you may already have
> figured out so
> Anar Daswani