× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Is anything truly a user based tool?

Most of the battle is understanding the database.  Think 3rd normal form 
vs data access.  Basically this is handled one of several ways.
- A set of join logical files, or SQL views are created to make this all 
easy to access.
- Data is replicated in one big cluster, or data warehouse.
- All tools are manipulated by someone in IS who sets them up and locks 
the user out of changing them.
- All tools are manipulated by someone in IS who sets them up.  If they 
want to make changes they copy and modify.
- Intelligent users are empowered, and trained, on how to query the data 
directly.

Classic example.  Tie these BPCS files together:
ECH - order header
ECL - order line
ESN - order notes
IIM - Item master
RCM - customer master
and the list goes on and on...

I tend to push the join logical, or view, to make this easier.

If you don't solve this issue, how will the tool help you?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.