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 I referred to earlier - now I just have to figure out how to pull this project 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 checking pricing and availibility of hotel rooms while talking to customers on the phone. They are using a database hack of Telemagic running on Novell currently - but they have another developer creating a FoxPro-based solution to replace their in-house reservation system (all pc -based). They are looking to me to create their on-line reservation system. In looking at their application I realized that their in-house reservation agent needs are virtually identical to the feature set we want to offer on-line. Both solutions have to run queries checking for availability (or inventory), pricing, location, and amenities and return the qualified results, allow instant booking and then reduce the available inventory, etc etc.Since the inventory of available rooms is shared between in-house and on-line operations I have to: A) create a method to seamlessly and continuously synchronize the inventory counts between both the in-house FoxPro database and the on-line WebCat database, or B) develop a single system 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-based solution running on a server on their in-house LAN and connected to the net via T-1, then give all the agents browsers and they would do their work via this intranet - while the same server would be accessed by web users. This would elimenate the data synching problem but I've never heard of 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 coordinating WebCat and FoxPro databases?3. Can a WebCat-based solution handle the speed needs of approx. 40 full-time users (25 in-house, 15 or so on-line)? BTW, we havn't yet decided what 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 more thanks 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 I referred to earlier - now I just have to figure out how to pull this project 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 checking pricing and availibility of hotel rooms while talking to customers on the phone. They are using a database hack of Telemagic running on Novell currently - but they have another developer creating a FoxPro-based solution to replace their in-house reservation system (all pc -based). They are looking to me to create their on-line reservation system. In looking at their application I realized that their in-house reservation agent needs are virtually identical to the feature set we want to offer on-line. Both solutions have to run queries checking for availability (or inventory), pricing, location, and amenities and return the qualified results, allow instant booking and then reduce the available inventory, etc etc.Since the inventory of available rooms is shared between in-house and on-line operations I have to: A) create a method to seamlessly and continuously synchronize the inventory counts between both the in-house FoxPro database and the on-line WebCat database, or B) develop a single system 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-based solution running on a server on their in-house LAN and connected to the net via T-1, then give all the agents browsers and they would do their work via this intranet - while the same server would be accessed by web users. This would elimenate the data synching problem but I've never heard of 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 coordinating WebCat and FoxPro databases?3. Can a WebCat-based solution handle the speed needs of approx. 40 full-time users (25 in-house, 15 or so on-line)? BTW, we havn't yet decided what 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 more thanks 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:
Running 2 two WebCatalog.acgi's (1996)
combining strings (1997)
[shownext] and descending order (1997)
I've been thinking (2002)
[ConvertChars] problem (1997)
Latin Characters (1998)
auto adding SKUs w/DB helper (1998)
Garbage files created (2000)
[createfolder] & [deletefolder] (1997)
Templates on Unix & CGI on Mac? (1997)
[numFound] inside [showIf]? (2000)
Showing formatted results in tables (2002)
Pieces Show Up! Curse You! (2000)
TCPConnect (1998)
Secure server question (1997)
Calculating multiple shipping... (1997)
[WebDNA] Converting | to TAB (2010)
Missing Cart Information (2003)
Modifying databases manually (was Banner DNA) (1997)
Problems problems problems (1997)