Hello...
I'm now participant in c # corner, i have been read articles over here many times ago.
I decide to share you the problem i have in dealing with XML database file !!!
><"!
the idea is as follow:
i have a huge xml file, about 641 MB !!!
and i need to extract the information into RDBMS !!
the file contains information of
BOOKS
ARTICLES
CONFERENCES
JOURNALS
.. etc
until now, we found a way to categorise the infromation!!
But how can we read the file and store it as RDB, MYSQL server ???
thank you.
Loading
Sam HobbsPosted Dec 18, 2009, 11:27 AM
There are probably utilities you can use without writing any code. You could process the data into a database and then process it more as needed.
AmalPosted Dec 25, 2009, 3:26 PM
your post and the links help me alot.
the problem is solved now!
and a new matter comes up !!
>>
i have a DB
contains many filds
one of those is a link to a webpage that contain an abstract of a book !!
i need to read this abstract only out of the whole web site
and save it to the DB ...
i have some ideas in my mind !!
but get confused how to start !!
AmalPosted Dec 21, 2009, 3:17 PM
i will check them.
=)
Sam HobbsPosted Dec 21, 2009, 1:52 PM
AmalPosted Dec 21, 2009, 1:27 PM
even the file is in my pc, im not open it from the web page itself, PC get stuck ">< in some point !!
i study the xml file, at least the main parts
i got ACM CD, that help me too.
but still with some error, while reading and storing in SQL server 2005 DB !!
then serach for specific infromation ><
Sam HobbsPosted Dec 21, 2009, 12:39 PM
AmalPosted Dec 21, 2009, 10:24 AM
>>>really huge!!
yeah there is a DTD file, i just put it in the same dorectory where i store and read the xml file
"><
Sam HobbsPosted Dec 21, 2009, 12:29 AM
I see a DTD for the XML file. Are you using the DTD?
AmalPosted Dec 18, 2009, 2:37 PM
http://dblp.uni-trier.de/xml/
the structure it self is not stable !!! we faced a problem in reading it, but almost solved !!
so the work until now is :
1- creat DB tables in SQL 2005 server (DONE)
2- read data from XML file ( almost done )
>> we knew how to read, but still some problem in ordering the data !!
some errors came up !! and some data didnt appear ><"! no idea why !!
3- Access DB using ASP.net (almost done)
>> we knew the idea and how to do it .. but still didnt try it, unless we complete the issue of the XML file
what utilize may i use??