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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
