asked on

CRUD vs Select in OLAP

In RDBMS-OLAP,we mainly have it denormalized help with fast reads (SELECT). But it does CRUD occasionally (daily, weekly etc) to refresh the data for reporting

Is there anything that can be done to speed up the CRUD operation? CRUD operations are faster only when DB is normalized, right?

thanks

ASKER CERTIFIED SOLUTION

dqmq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

>>>CRUD operations are faster only when DB is normalized, right?

Thanks for correcting my over simplification and false assumption. Yes, Indexing will be very key, too.

>>Performance on inserts can be improved with a clustered index on an incrementing key (in a fact table)

Is an Identity column suitable for this Clustered key on the fact table? If so, then this will be the surrogate key(PK) in the dimension table.

What are demoted keys?

SOLUTION

dqmq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

Thanks dgmg, that was helpful.

can you please finish this line, so I can follow your exact thoughts there...
"Summary tables benefit from indexes on their dimension component, not from indexes on the "

SOLUTION

dqmq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

Thanks for the simple examples that help very much.