>At 04:41 PM 9/9/2003 -0400, Don wrote: >>Have you ever tried to import your RainingData PICK database into a >>RDBMS like MS SQL Server
>Sure, that would be preferable. But the problem is MV data does not >"map" directly to relational data. MV allows a "field" in a "table" to >actually contain multiple values or sub-data. I would think so too. >Check if your PICK >product has some export options that would "flatten" the data. For >example, turning all multivalues into a separate relational table. Great tip. I'll try it when I meet with the client next time. >If >it doesn't have this ability perhaps you could export to XML (which is >hierarchical and is more like MV data than SQL data). >Then there are >more tools available to translate XML into relational data. Here essentially you're saying, try Matt's XML tool or the similar. I have two concerns for this approach, say, a XML tool works well (Matt's a very smart guy, that's for sure) (a) this process has to be sort of automated because the target database needs to be refreshed regularly; (b) the cost and implementation efforts required for using such a tool. I'm constantly reminded that this client is very tight on cash spending. Thanks, Peter. Don > > >>>Yes, I am working on a project right now that uses a RainingData >PICK >>>database from a ColdFusion website. >>>We had all sorts of problems and finally decided to run the website > >>>from a local database (MySQL, but it could be anything) and have the > >>>administrator upload data from PICK periodically. >>> >>>We had trouble with GaExpress and finally wrote our own PICK program > >>>that listens on a TCP port and parses simple requests for data. In >CF >>>we use cfhttp to contact the PICK program and the results are put >into >>>a query object by manually parsing the results and using QueryNew, >>>QuerySetCell, etc... >>> >>>Remember: PICK is single threaded. The entire operating environment. > >>>Don't let your web site depend on it. >>> >>>At 08:57 AM 9/5/2003 -0700, LI, Chunshen \(Don\) wrote: >>>>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 Get the mailserver that powers this list at http://www.coolfusion.com
