Click to See Complete Forum and Search --> : Newbie question


rimmer007
12-31-2003, 08:51 PM
hi all

I m just started learning about XML not planning on any XML programming yet just some theory stuff


XML can derive data from different database which has the same meaning but different formats. For example

Person detail(name:String, age:int) database 1
Person detail(Forename,Surname:String, DoB:int) database2

how would you incorporate these data into a framework where it can be queried as a whole?

Do you generate a DTD from database 1 and databse 2 ? Would that just be one DTD or 2 DTDs ? What would you do after generating the DTD?

paps
01-11-2004, 06:54 PM
Well....you could have a single DTD to which both the DB adher...DTD or for that matter Schema are rules to which an XML sticks..or that XML will follow the rules....

So if you have XML's coming from two db but following that single DTD (or schema) you can integrate thm pretty easily.......

Once you have a XML following certain rules....u know the format of that data...u could then choose to display it using XSL....or store in third db....or just throw the XML. :D do what you want with it......

As far as using a single XML to query multiple db goes....well...i would assume that you would have a attribute in XML pointing to which db should be quried.....the point is that its limitless......only bounded by your imagination.... :cool: