Standard or base dimensional models for industries

View previous topic View next topic Go down

Standard or base dimensional models for industries

Post  Jeff Smith on Tue Apr 15, 2014 10:27 am

Is there a place that stores or publishes standard or basic dimensional models for various industries?

it occurred to me that there should be industry standard DW models out there. Different companies in the same industry have the same data. In fact, in many cases, the source systems are purchased - not made. And even if they were, don't the same companies within an industry have the same data?

Should all health insurance companies have the same fact tables and dimension tables? Heck, there should be a lot of overlap in the insurance industry as a whole. There are members, providers, clients, claims, and brokers.

Another example is the banking industry. Credit accounts, deposit accounts, transactions, credit applications, branches and ATMs.

And Retail is retail.

Granted, there are minor differences in the structure of the dimension tables, but a DW for an particular industry should be rather consistent.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  BoxesAndLines on Tue Apr 15, 2014 4:13 pm

There are lots of models out there. IBM, SAP, Teradata, all have industry standard models available. Retail has the ARTS industry model. None of them are cheap which is why you don't run across them very often.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  Jeff Smith on Tue Apr 15, 2014 4:19 pm

We should create a new tab for DDL or physical models.  Make it a place where people can get examples for common dimensions and facts.  Heck, throw up a model and let people critique it - constructively of course - it will improve everyone's designs.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  hkandpal on Thu Apr 17, 2014 6:39 pm

Hi Jeff,

That is a good idea; we should help something like a template model which can then be customized by people depending upon their requirement/environment.

thanks

Himanshu

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  nick_white on Tue Apr 22, 2014 3:14 am

I'll admit to playing devil's advocate a bit here but...

1. Isn't any model that could be applicable to a significant number of projects going to be so generic that it's actually of little use to any specific project?
2. Isn't such a generic model going to be trivial for an experienced dimensional modeler to create?
3. If an inexperienced dimensional modeler can't create a basic model then isn't creating one from scratch a vital learning experience for them? Also, would you really want someone who is incapable of creating the generic model taking it and enhancing it for their specific requirements? I would suggest that their chances of them doing this successfully are slight
4. If the proposal is to create DDL then this is DB-specific. Would there really be the appetite to create Oracle, SQL Server, DB2, etc. versions of each model - and if we didn't then how useful would they be?

Just a few thoughts to add to the discussion...


Last edited by nick_white on Tue Apr 22, 2014 10:40 am; edited 1 time in total

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  Booma on Tue Apr 22, 2014 3:51 am

nick_white wrote:I'll admit to playing devil's advocate a bit here but...

1. Isn't any model that could be applicable to a significant number of projects going to be so generic that it's actually of little use to any specific project?
2. Isn't such a generic model going to be trivial for an experienced dimensional modeler to create?
3. If an inexperienced dimensional modeler can't create a basic model then isn't creating one from scratch a vital learning experience for them? Also, would you really want someone who is incapable of creating the generic model taking it and enhancing it for their specific requirements? I would suggest that their chances of them doing this successfully are slight
3. If the proposal is to create DDL then this is DB-specific. Would there really be the appetite to create Oracle, SQL Server, DB2, etc. versions of each model - and if we didn't then how useful would they be?

Just a few thoughts to add to the discussion...
I think few people would be able to use such dimensional models directly for their datawarehouse. There will always be some mutation be done. But I think it would be great for newcomers to have some starting point which they can build upon.
avatar
Booma

Posts : 12
Join date : 2014-03-10

View user profile

Back to top Go down

Re: Standard or base dimensional models for industries

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum