OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   Re: [xml-dev] importing and accessing data - redux

[ Lists Home | Date Index | Thread Index ]

If you are looking for a crash course in what exists in XML and data access,
I wrote

        http://www.25hoursaday.com/StoringAndQueryingXML.html

a while ago which should be helpful in pointing you in the right direction.
As for converting the tab delimited data to XML, I suggest using whatever
scripting/programming language you are familiar with to complete this task.
I'd go with Perl myself.

--
THINGS TO DO IF I BECOME AN EVIL OVERLORD #15
I will never employ any device with a digital countdown. If I find that such
a device is absolutely unavoidable, I will set it to activate when the
counter
reaches 117 and the hero is just putting his plan into operation.


----- Original Message -----
From: "Paul Freedman" <paul@freedmania.com>
To: <xml-dev@lists.xml.org>
Sent: Friday, December 07, 2001 1:55 PM
Subject: [xml-dev] importing and accessing data - redux


> On the offchance that the only person who knows the answer didn't see
> this earlier, I'm posting it again. I apologise for the redundancy; the
> answer may be real important to this job.
>
> I am a newcomer to xml and to this list. I hope this is the place for
> basic questions, or if not then at least the place to learn where to ask
> them. Please let me know if I'm being inappropriate, too.
>
> I have a small database with two tables of about 250 records each. One
> table is a glossary with two fields, "word" and "definition". The other
> is a directory called 'papers', containing five fields. All the data is
> string. Nothing, including the definitions, is longer than 600
> characters.
>
> Currently the data resides in 2 tab-delimited .txts.
>
> I want to handle the data with normal database functions: search,
> select, sort. I am at a loss as to how to begin. I can't even see
> how to import the data into an xml document (or generate a document
> with the data in place).
>
> I know that, using Matt Sergeant's DBIx::XML_RDB module, I can access a
> mySQL database through Perl. I'm trying to avoid Perl and Java.
>
> My interface, incidentally, is a Shockwave piece built in Macromedia
> Director 8.5. I'm trying to not use their database-accessing xtras.
> Their XML Parser xtra is known to work, but first I'd need, it seems, an
> "XML Database". Building it by hand would defeat my purpose, and leave
> me with the problem of building a maintenance device.
>
> Is there a way to use xml as my database here?
>
> Any help will be deeply appreciated.
>
> Thanks,
> Paul Freedman
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com





 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS