Re[2]: [DB-SIG] Looking for python compliant NXDs

[Harri Pasanen]

On Fri, 1 Feb 2002 12:06:02 +0100 TORZEC Nicolas thesard FTRD/DIH/LAN <nicolas.torzec@rd.francetelecom.com> wrote:

> Thank you all for your help.
> 
> I'm agree that using an classical relational DBMS (like postgres or mysql
> that I have both already used in the past) would be an "a priori" easy
> storage solution. 
>  
> But, three problems would occur : 
> 1) Mapping my XML data (semi-structured data based on complex TEI-like
> DTDs/Schemas) into the rigid relational model underlying the relational
> DBMSs is not a picnic! I have read on XML.com that tools exists for this
> kind of work?
> 2) As this mapping is not guaranted to be bidirectional, I'm not sure
> that
> the data I could retrieve will be really identical to the original one! 
> 2) Exploiting (i.e. adding, removing, selecting, extracting, reformating,
> analyzing) my collections of XML data through an SQL interface is not
> very
> satisfying for me. May be using the technologies associated to XML
> (Xpath,
> Xupdate, XSL, DOM ...) directly on the data stored in the DataBase would
> make the database administration/exploitation easier ?
> 
> Nicolas.
> 
> 


You might also want to check out MetaKit, http://www.equi4.com/metakit/.
>From its blurb: "MetaKit fills the gap between flat-file, relational,
object-oriented, and tree-structured databases, supporting relational
 joins, serialization, nested structures, and instant schema evolution."

Not sure how well it will scale to your purposes though.


-Harri










> 
> 
> -----Original Message-----
> From: Daniel Veillard [mailto:veillard@redhat.com]
> Sent: vendredi 1 fevrier 2002 12:01
> To: M.-A. Lemburg
> Cc: TORZEC Nicolas thesard FTRD/DIH/LAN; 'db-sig@python.org'
> Subject: Re: [DB-SIG] Re: [XML-SIG] Looking for python compliant NXDs
> 
> 
> On Fri, Feb 01, 2002 at 11:42:33AM +0100, M.-A. Lemburg wrote:
> > Daniel Veillard wrote:
> > >   Then use Postgresql or MySQL
> > >       http://www.postgresql.org/
> > >       http://www.mysql.com/
> > > 
> > >   Both use SQL and can be used from Python, you should feel at home.
> > 
> > I'll add SAP DB to that list:
> >         http://www.sapdb.org/
> 
>   Right,
> 
> > It's high performance, full SQL-92, has an Oracle SQL emulation, 
> > stored procedures, in-process backups, etc. etc. and it's 
> > Open Source ! (I wonder why SAP DB is not receiving more attention
> > in the Open Source world...)
> 
>   Because it was not developped within the Open source world and that
> late pluggers like those have a hard time to grow a community
> independantly
> of the quality of their source.
> 
> Daniel
>