Strategy
Efficiency
Operation
Value
Innovation
Execution
My personal favorite is “Strategy”. It feels extremely glamorous to talk about strategy, notwithstanding how strategically idiotic we may sound. Execution is the least glamorous, because if you know how to execute, the very concept of going to b-schools is pointless.
Star schema is a denormalized model with one or more fact table is surrounded by number of fact table. The whole diagram itself it depicts a star called star schema.Advantage is star schema:
1.Contains lesser no of joins
2.Contains lesser no of queries, so queries result fastly.
Disadvantage of star schema:
If the dimension table is very huge in that case data redundancy will be there.Snowflake schema is based on normalization like normalize the dimension table to remove redundancy and dependancy. If star schema consists of a huge dimension table then we will broken that table into a no of dimension table.
Advantage of snow flake schema:
1.Non redundant data
2.Flexible
3.Easy to maintain
Disadvantage of snowflake schema:
1.Query performance go down as it needs more join to retrieve data.
Basically based on business needs and if the dimensional table is huge, go for snow flake schema and if there is one denormalized dimensional table go for star schema
OLTP(Online Transactional Processing) is a transactional system, data oriented model. It always contain data for few weeks or month. It is always up to date and shows current status of each business transaction .It is used to store few transactional data without any processing done on it. This system often use normalized schema.
Where Data [...]
This morning I started for my class at 7:15 AM driving my GETZ Prime. It was a usual cold winter morning in Bangalore in early hour of Saturday. Road was supposed to be empty. I overtook few autos, then a Ford IKON, which was irritatingly driving slowly. I suddenly accelerated my car to avoid entering [...]
Indians are finally in Oscar once again after legendary Satyajit Roy. Slumdog Millionaire bagged 10 Oscar nominations and musician AR Rahman alone bagged 3 nominations for himself. Though I have not seen the movie yet, I am quite excited and happy about Mumbai, the place primarily portrait in the movie. This City never stops to [...]
A simple mismatch can change your life completely. The mismatch between desire and deserve. We all desire much more than what we deserve. We try to fill the gap by crime, violence, hatred, politics, and sometimes with efforts and enormous hardship. Saints say, less the desire you have, more relaxed you will be in this [...]
I do not quite understand the hype behind Mr. Obama as a next US president. Apart from being first black US national , I do not see any other reason for this world wide hype surrounding Obmana’s presidency. Everything seems to be unnecessarily spectacular at his best, excessive worldwide media coverage, grandeur ceremonies , [...]
After spending almost one year, I am kind of doubtful about the virtues of blogging. Hope some of you guys ,the experts of blogosphere, will bail me out.
Does it really worth continuing blogging? Do any body really cares for your views and ideas of so many stuffs? Do blogs really create knowledge [...]
How do companies better integrate their IT infrastructure with Business Strategies, i.e., how to increase server utilization, reduce cooling power, increase automation and reduce human-intervention? How to get more return from IT investments? These are few typical questions many CTOs want immediate answers.Research reveals that $1 investment in IT infrastructure will subsequently result $8 maintenance [...]
Mobile software development for smart phones or other high end phones is booming. Urgency is visible across firms like Samsung, Google, Microsoft and other who provide various mobiles operating systems. Take an example Samsung Mobile Innovator which provides a collaborative way of mobile application development with huge support from Samsung. If you are a mobile [...]