Design datawarehouse schema

Hi,
I need to design a datawarehouse for the manufacturing industry. I'm
sure that this has been done a dozen times, and I was wondering if
there are workgroups where I can find a sample schema, reports and
others?
Looking forward to your reply,
DirkIs there such a thing as a 'standard datawarehouse' for ANY industry'
Seems to me that too much is variable, unless you are only storing industry
standard EDI stuff like Purchase Orders, Healthcare Claims, etc.
TheSQLGuru
President
Indicium Resources, Inc.
"locusta74ster@.gmail.com" <locusta74@.gmail.com> wrote in message
news:1174924469.776834.285710@.d57g2000hsg.googlegroups.com...
> Hi,
> I need to design a datawarehouse for the manufacturing industry. I'm
> sure that this has been done a dozen times, and I was wondering if
> there are workgroups where I can find a sample schema, reports and
> others?
> Looking forward to your reply,
> Dirk
>|||On Mar 27, 4:40 am, "TheSQLGuru" <kgbo...@.earthlink.net> wrote:
> Is there such a thing as a 'standard datawarehouse' for ANY industry'
> Seems to me that too much is variable, unless you are only storing industr
y
> standard EDI stuff like Purchase Orders, Healthcare Claims, etc.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "locusta74s...@.gmail.com" <locust...@.gmail.com> wrote in message
> news:1174924469.776834.285710@.d57g2000hsg.googlegroups.com...
>
>
>
>
> - Show quoted text -
Hi SQL Guru,
well, yes, there is....over the last few years we have developed
models across a number of industries and they are quite
standardised...we have also developed applications on top of
them...today this all sits on MSFT only.....
Currently they sit at 500 tables and 7,000 fields. We use them as the
base for when we start a project. They are still in 'early adopter'
phase but we will be bringing them to market soon enough...hence
commenting on them here...
What we have essentially invented is a way of being able to customise
analytical applications, from front to back, at the lowest possible
cost....and 'to back' I mean riht back to the extraction out of the
source system.
Of course, there are few good models out there for 'free'. And no-one
made any money out of just selling models which is why more do not
exist...the three companies that sell models, IBM, NCR and Sybase
have made 'rounding errors' on model revenues.....so IBM and NCR now
insist that if you want the model you have to buy the rest as well...
This is a reaction to the fact that the model is the 'heart and soul'
of the EDW and is the majority of the IP...and companies only wanted
to buy the model for peanuts and not take the rest of the
'solution'....and in the end, no-one made any money out of them. We
are only selling our models separately from the rest of the work we
have done in very specific cases. Mostly, we would like our clients to
buy the ETL and the apps as well as the models... :-)
Best Regards
Peter
www.peternolan.com