Powerhouse using Oracle

11 Mar 99 12:07:39 -0500

--=_ORCL_3412220_0_0
Content-Transfer-Encoding:quoted-printable
Content-Type:text/plain; charset="iso-8859-1"

It's not necessary to have a dictionary but it is very common to mirror the 
database in the dictionary.  This is this forth generation work in action. 
An 
item in the dictionary can contain a help message, picture clauses, default 
report headings, valid entries, etc.  Without this in the dictionary you
would 
have to recode all of this over and over again for each occurrence of an
item. 
 It makes forming standards for your system a once time thing.  Why not do
it 
the once in the dictionary (a little extra effort) for each item and save 
yourself a tremendous amount of tedious coding in the future and endless 
inconsistency. 

If your moving from RMS to Oracle, go the distance.  Normalization will be 
impossible and locking issues a nightmare if you stop halfway through your 
commitment (half RMS half Oracle - UGLY).  You'll be glad you went
relational 
in the end!   

Mark Stewart 
Consultants Club Corp. 
Windsor, Ontario 
Canada

--=_ORCL_3412220_0_0
Content-Type:message/rfc822

Date: 11 Mar 99 11:16:22
From:Cindy Lomas <clomas@milk.org>
To:powerh-l
Subject:Powerhouse using Oracle
Return-Path:<powerh-l-owner@lists.swau.edu>
Received:by mail.detroitedison.com with ESMTP id LAA00228; Thu, 11 Mar 1999 11:15:23 -0500 (EST)
Received:by dte.detroitedison.com with ESMTP id LAA24563; Thu, 11 Mar 1999 11:15:22 -0500 (EST)
Received:from sphere.swau.edu (sphere.swau.edu [205.165.192.254]) by cosmic3.swau.edu (8.8.3/8.8.3) with ESMTP id KAA28367; Thu, 11 Mar 1999 10:13:54 -0600
Received:from localhost (daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) with SMTP id KAA27098; Thu, 11 Mar 1999 10:13:49 -0600
Received:by sphere.swau.edu (bulk_mailer v1.9); Thu, 11 Mar 1999 10:13:32 -0600
Received:(from daemon@localhost) by sphere.swau.edu (8.9.1/8.9.1) id KAA27062 for powerh-l-outgoing; Thu, 11 Mar 1999 10:13:30 -0600
Received:from gateway.milk.org (milk.org [192.139.81.25]) by sphere.swau.edu (8.9.1/8.9.1) with ESMTP id KAA27057 for <powerh-l@lists.swau.edu>; Thu, 11 Mar 1999 10:13:24 -0600
Received:from clomas ([192.168.6.55]) by milk.org with SMTP id <102200-276>; Thu, 11 Mar 1999 11:15:07 -0500
Message-Id:<3.0.3.32.19990311111620.006dadc0@milk.org>
X-Sender:clomas@milk.org
Sender:owner-powerh-l@sphere.swau.edu
MIME-Version: 1.0
Content-Type:text/plain; charset=us-ascii
Content-Transfer-Encoding:7bit

We are currently using Powerhouse on VMS with RMS files. We are looking
into using Oracle with PH. Will it be necessary to have a dictionary
definition of the database or is this covered by the PDL DATABASE statement
(i.e. will we doubling our DBA work?)

Thanks,
Cindy Lomas

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.

--=_ORCL_3412220_0_0--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.