> I would imagine that exporting the data to a Native XML Database would > be one way to go since MVDB data can easily be represented by XML.
Both UniVerse v10 and UniData v6(not sure) is "Supposed* to support creating XML Docs from the DB. I did some testing in UniVerse Enviroment with "TOXML" Syntax. It didnt really work as per the docs. "select field1, field2, field3 from TableName TOXML; Was supposed to return an XML Doc...instead it returned a Query Object. Yes, if the XML is returned correctly from MVDB, i think SQL Server 2003 is supposed to support XML Data and XML Search/XPath functions. This might work. Joe Eugene ----- Original Message ----- From: "Matt Liotta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 10:03 AM Subject: Re: MVDB > I would imagine that exporting the data to a Native XML Database would > be one way to go since MVDB data can easily be represented by XML. > Further, XML databases can be easy to work with from CF. > > -Matt > > On Monday, September 8, 2003, at 10:00 AM, Chunshen (Don) Li wrote: > > >>> Have you ever exported UniVerse database to RDBMS, say, MS SQL > >>> Server or > >> Oracle platform? > >> > >> If you are using MVDB's with nested data (i.e 2NF), you wont really > >> be able > >> to export the data to MSSQL. > > This may be bad news, Joe, I have a client who is using UniData v5.2 > > but I don't know anything about that data structure. Any tool that > > comes with UniData might be able to give me some high level data > > schema view? > > > >> However, Lastest version of Oracle supports Nested Relational > >> Tables.. you > >> can probably use to this > >> architecture for the export.... > > Oracle won't be an option at least for now, way too expensive, > > maintenance etc. > > > >> Now the above scenario is only worth looking at, if your company is > >> trying > >> to Migrate TO RDBMS (NOT For Daily/Simple Export) > >> IBM DB2 also supports some data types for this purpose. > > DB2 would be similar category to Oracle for now. > >> > >> U2 MV Databases (UniVerse and UniData) both have ODBC and JDBC > >> Interfaces. I > >> have played around with JDBC and CFMX, > >> works pretty well... Except this is not very useful in the MV 2NF > >> >Scenario. > > I have a tool that allows easy data access/view for RMDBS like MS SQL > > Server, I intend to import the UniData database into MS SQL Server > > first, then, take a good look at it. One of the goals is to > > 'consolidate' various data/databases that the company has, for a > > single view of data (at least read only initially). > > > >> SQL only works in the 1NF. There has been > >> some JDBC enhancements to bring back Nested Data in different > >> tables... Or > >> Joins. > > This JDBC enhancement sounds encouraging. > > > >>> BTW, what's the main similarity and difference between UniData and > >> UniVerse, > >> Unidata and Universe are very similar in Architecture... i dont know > >> of any > >> big Differences. > > Good to know. > > > > Thanks. > > > > Li, Chunshen (Don) > > > >> > >> Joe Eugene > >> > >> > >> ----- Original Message ----- > >> From: "Chunshen (Don) Li" <[EMAIL PROTECTED]> > >> To: "CF-Talk" <[EMAIL PROTECTED]> > >> Sent: Friday, September 05, 2003 3:44 PM > >> Subject: MVDB > >> > >> > >>> Have you ever exported UniVerse database to RDBMS, say, MS SQL > >>> Server or > >> Oracle platform? If so, did you use ODBC driver or ... and what's > >> experience? Thanks for sharing. > >>> BTW, what's the main similarity and difference between UniData and > >> UniVerse, forgive my laziness of not reading documentations. > >>> > >>>> Yes, we run UniVerse v.10. ??? > >>>> > >>>> Joe Eugene > >>>> ----- Original Message ----- > >>>> From: "LI, Chunshen (Don)" <[EMAIL PROTECTED]> > >>>> To: "CF-Talk" <[EMAIL PROTECTED]> > >>>> Sent: Friday, September 05, 2003 11:57 AM > >>>> Subject: MVDB > >>>> > >>>> > >>>>> Hello, > >>>>> > >>>>> I'm wondering if anyone has ever worked on a > >>>>> Multi-valued Database system like UniData from ROI. > >>>>> > >>>>> Thanks. > >>>>> > >>> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
