November 19, 2010 at 3:47 pm
Hi,
I am currently in a process of designing an application to aid the work of construction project managers.
I want to add analysis features using olap at an early stage of the application development.
My question is what can I do to make the database ready for later loading the data into a cube?
Thanks,
Michael
November 20, 2010 at 1:23 am
Make sure that your database design uses consistent and properly chosen data types. Apply recognised standards or carefully designed encoding schemes and business keys. Avoid using nulls. Enforce all the necessary keys and other business rules. Aim to be in at least Boyce Codd / 5th Normal Form. Record data at the most detailed level of granularity that is feasible. These are good things to do in any database.
November 20, 2010 at 2:57 am
For analsyis it is alwasy better to have the OLAP (DW) database where you will have your fact tables and dimension tables. From this database you will need to create your cube.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply