Sounds like an interesting option. The key might be, as Joe indicated, how good such tool(s) can do the job. Thanks, Matt.
Don >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
