topic Re: Start Schema or Single Table Schema. Which one is better? in App Development

Start Schema or Single Table Schema. Which one is better?

vikraant — Fri, 14 Apr 2017 13:12:52 GMT

Which one should be preferred while developing apps?

Re: Start Schema or Single Table Schema. Which one is better?

qlikcheepirishe — Fri, 14 Apr 2017 17:22:32 GMT

Hiii Vikraant,

Best practice is to have Star Schema in any data modelling.

Anyhow, if you can make all the tables in one fact table the performance will be much faster for the developing application.

Regards,

Mahesh Shetty

Re: Start Schema or Single Table Schema. Which one is better?

vlad_komarov — Mon, 17 Apr 2017 18:17:46 GMT

The correct answer should be: "It depends"...

Please check the following posts:

Star Schema or Snow Flaxe schema?

Re: star & snowflake schema‌

And as a summary (from Mahesh T‌ reply on one of posts):

Regards,

Vlad

Re: Start Schema or Single Table Schema. Which one is better?

satheshreddy — Tue, 18 Apr 2017 09:01:30 GMT

Hi Vikraant,

Based on requirement, mostly we can use star schema.

If we can able to merge the Dimension tables into one fact table its best for performance, but so many projects not possible these one tats the reason we are using star and snowflake.

Regards

Sathish

Re: Start Schema or Single Table Schema. Which one is better?

satheshreddy — Mon, 24 Apr 2017 06:15:24 GMT

Hi Vikrant,

if any one answer is ok to you please mark correct and close the thread.

Regards

sathish