Article View: comp.os.ms-windows.programmer.misc
Article #2234Distributed transaction processing with a relational database
From: dave
Date: Wed, 20 Jan 1993 22:04
Date: Wed, 20 Jan 1993 22:04
44 lines
2405 bytes
2405 bytes
We are in the problem analysis phase for a project to move an existing mainframe transaction processing system using VSAM, to distributed workstations and a relational database. The application must handle about 500,000 existing customers, periodically calling into the customer service reps. who handle complaints, new products, cancel products, etc. These customers need to be billed for their products, and the product must be transported to the customer. The total size of the VSAM files is now about 2-4 gig of data, with some of this being historical records. There will be about 100 users of hte system, with 50-70 fulltime. Batch processes will also be running over the data at various times through the cycle. I am looking for persons out there that have deployed, or are developing similar applications, and I would like information on how this can be accomplished most efficiently. Specifically: 1) What methods/tools did you use if you used OOA or Design? 2) What platform/workstation/servers are prefered for both development and deployment? 3) What language(s) did you use, C, C++, Cobol, 4GL? Did you use any CASE tools? E.g. What is a _very_ large, deployed system for C++? 4) How about GUIs and their development tools? Motif, Windows, Forms? The ideal situation would take advantage of existing PC hardware running Windows for the infrequent users, and perhaps an Xterm to a workstation for continous users. 5) Which database tools were used, Sybase, Ingres, Oracle? 6) I am also looking for any literature I can find on _deployed_ systems similar to this, books, papers, etc. Thank you for your input, dave ________________________________________________________________________ Dave Pracht phone: (914)347-6860 Director of Applications Development fax: (914)347-3182 Artificial Intelligence Technologies, Inc. internet: dave@ait.com Westchester Co. NY ________________________________________________________________________
Technical Details
Message-ID:
<1993Jan20.220428.28684@ait.com>Path:
arc1-ca.pugleaf.net!sparky!uunet!psinntp!shadow!rootShow Full Headers
Complete Article Headers
Newsgroups: comp.os.ms-windows.programmer.misc Path: arc1-ca.pugleaf.net!sparky!uunet!psinntp!shadow!root From: dave@ait.com Subject: Distributed transaction processing with a relational database Message-ID: <1993Jan20.220428.28684@ait.com> Sender: root@ait.com (Operator) Reply-To: dave@ait.com Organization: Artificial Intelligence Technologies, Inc. Date: Wed, 20 Jan 1993 22:04:28 GMT Lines: 44