🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.os.ms-windows.programmer.misc
Article #2234

Distributed transaction processing with a relational database

#2234
From: dave
Date: Wed, 20 Jan 1993 22:04
44 lines
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!root

Show 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