Re: File Normalization Question

[Carl Galgano <cgalgano@xxxxxxxxxxxxxxxxx>]

That could be.  Most data warehousing applications have tons or redundant
data in then mainly for ease of ad hoc reporting etc.  The BIG difference
(IMHO) between a data warehouse that stores redundant data and a transaction
processing system that does the same is maint.  Remember the data warehouse
(by defn) remains static, so maintaining the file is not an issue.  I would
say this is bad (depending on the amount of redundancy of data) programming
and database design.

Carl


At 03:58 PM 6/10/97 -0400, JULANNFRA@aol.com wrote:
>Hi Everyone, I have a question (obviously).  I am looking at this software
>package that has redundant information within some of its detail files.  For
>years I have felt this was bad programming, however, this package does
>include (supposedly) a user report writer function.  I am wondering if I am
>looking at a bad database file setup or a database system that is created for
>user ease in creating reports (queries).  Thank you in advance.  Are query
>functions eliminating the need to have top (1st?) normalization of its
>database files?       Julie
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* This is the Midrange System Mailing List!  To submit a new message,   *
>* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
>* this list send email to MAJORDOMO@midrange.com and specify            *
>* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
>* should be directed to the list owner / operator: david@midrange.com   *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
Carl J. Galgano
EDI Consulting Services, Inc.   
540 Powder Springs Street
Suite C19
Marietta, GA 30064
770-422-2995

root
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *