Database Strategy - more...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18155
interpreted = N
texte = Well it looks like I might get the hotel reservation project that Ireferred to earlier - now I just have to figure out how to pull thisproject off (yee haw!) - So once again I appeal to the combined wisdom &experience of the group for some guidance.My client has 25 full-time reservation agents who are constantly checkingpricing and availibility of hotel rooms while talking to customers on thephone. They are using a database hack of Telemagic running on Novellcurrently - but they have another developer creating a FoxPro-basedsolution to replace their in-house reservation system (all pc -based). Theyare looking to me to create their on-line reservation system. In looking attheir application I realized that their in-house reservation agent needsare virtually identical to the feature set we want to offer on-line. Bothsolutions have to run queries checking for availability (or inventory),pricing, location, and amenities and return the qualified results, allowinstant booking and then reduce the available inventory, etc etc.Since the inventory of available rooms is shared between in-house andon-line operations I have to: A) create a method to seamlessly andcontinuously synchronize the inventory counts between both the in-houseFoxPro database and the on-line WebCat database, or B) develop a singlesystem that can be accessed by both in-house agents as well as the web.I've been thinking about the feasability of building a single WebCat-basedsolution running on a server on their in-house LAN and connected to thenet via T-1, then give all the agents browsers and they would do theirwork via this intranet - while the same server would be accessed by webusers. This would elimenate the data synching problem but I've never heardof anyone using WebCat in this sort of fashion.1. What are people's thoughts on the feasability on such a solution?2. Is creating a single WebCat solution a better idea than coordinatingWebCat and FoxPro databases?3. Can a WebCat-based solution handle the speed needs of approx. 40full-time users (25 in-house, 15 or so on-line)? BTW, we havn't yet decidedwhat platform and server software to use...4. Is there a better solution that I'm not thinking of?5. Is this any way to be spending your summer vacation?Thanks to all who have had the patience to read through this and even morethanks to those who respond!Regards-Marty
Associated Messages, from the most recent to the oldest:
Well it looks like I might get the hotel reservation project that Ireferred to earlier - now I just have to figure out how to pull thisproject off (yee haw!) - So once again I appeal to the combined wisdom &experience of the group for some guidance.My client has 25 full-time reservation agents who are constantly checkingpricing and availibility of hotel rooms while talking to customers on thephone. They are using a database hack of Telemagic running on Novellcurrently - but they have another developer creating a FoxPro-basedsolution to replace their in-house reservation system (all pc -based). Theyare looking to me to create their on-line reservation system. In looking attheir application I realized that their in-house reservation agent needsare virtually identical to the feature set we want to offer on-line. Bothsolutions have to run queries checking for availability (or inventory),pricing, location, and amenities and return the qualified results, allowinstant booking and then reduce the available inventory, etc etc.Since the inventory of available rooms is shared between in-house andon-line operations I have to: A) create a method to seamlessly andcontinuously synchronize the inventory counts between both the in-houseFoxPro database and the on-line WebCat database, or B) develop a singlesystem that can be accessed by both in-house agents as well as the web.I've been thinking about the feasability of building a single WebCat-basedsolution running on a server on their in-house LAN and connected to thenet via T-1, then give all the agents browsers and they would do theirwork via this intranet - while the same server would be accessed by webusers. This would elimenate the data synching problem but I've never heardof anyone using WebCat in this sort of fashion.1. What are people's thoughts on the feasability on such a solution?2. Is creating a single WebCat solution a better idea than coordinatingWebCat and FoxPro databases?3. Can a WebCat-based solution handle the speed needs of approx. 40full-time users (25 in-house, 15 or so on-line)? BTW, we havn't yet decidedwhat platform and server software to use...4. Is there a better solution that I'm not thinking of?5. Is this any way to be spending your summer vacation?Thanks to all who have had the patience to read through this and even morethanks to those who respond!Regards-Marty
Marty Schmid
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
possible, WebCat2.0 and checkboxes-restated (1997)
Date format problems (1997)
Cannot calculate prices (1997)
WCS Newbie question (1997)
Checkboxes (1998)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
PSC recommends what date format yr 2000??? (1997)
Corrupted filetypes with [movefile] (1998)
Re:Help name our technology! (1997)
RE: [sendmail]- bcc? (1998)
authenticating a second user (1997)
UPS Shipping (1999)
Integration with SQL (1997)
WebCat2: Items xx to xx shown, etc. (1997)
RE: WebCat and image maps (1997)
Webcatalog installation on debian ? (2003)
Looking up two prices in database? (1997)
[WebDNA] Escaping content for JSON (2013)
Check boxes (1997)
WebCat2.0 [format thousands .0f] no go (1997)