Dimensional Model – Some Little information about…

              Dimensional Modeling

Elements that make up a Dimensional Model:

Continue lendo »

Introdução a Massively Parallel Processing (MPP)

filo01_Cartoonized_4Baseado em texto de Diwakar Kasibhotla

Em Bases de Dados MPP – Massively Parallel Processing (Processamento Paralelo Massivo), bancos de dados são particionados em vários servidores ou nós, com cada servidor / nó tendo memória / processador para processar dados localmente. Toda a comunicação é através de uma interconexão de rede – não há compartilhamento no nível do disco ou contenção para se preocupar (ou seja, é uma arquitetura sem compartilhamento – ‘shared-nothing’).

Continue lendo »

Design Tip #180 The Future Is Bright

Data warehousing has never been more valuable and interesting than it is now. Making decisions based on data is so fundamental and obvious that the current generation of business users cropped-cropped-filo01_cartoonized_42.jpgand data warehouse designers/implementers can’t imagine a world without access to data. I’ll resist the urge to tell stories about what it was like before 1980. By Ralph Kimball  © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #179 Key Tenets of the Kimball Method

cropped-cropped-filo01_cartoonized_42.jpgMost of the guidance in the Kimball method for designing, developing, and deploying a DW/BI system is just that: guidance. There are hundreds or thousands of rules in the Kimball Group’s many books, and I confess to having bent many of those rules over the decades, when faced with conflicting goals or unpleasant political realities.
 By Joy Mundy – © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #178 Tried and True Concepts for DW-BI Success

Time marccropped-cropped-filo01_cartoonized_42.jpghes on and soon the collective retirement of the Kimball Group will be upon us. At the end of 2015 we will all retire. In my final Design Tip, I would like to share the perspective  for DW/BI success I’ve gained from my 26 years in the data warehouse/business intelligence industry. By Bob Becker – © Kimball Group. All rights reserved.

Continue lendo »

Design Tip #177 Final Word of the Day: Collaboration

By Margy Ross© Kimball Group. All rights reserved.

For cropped-filo01_cartoonized_4.jpgmy final Design Tip, I’m returning to a fundamental theme that’s not rocket science, but too often ignored: business-IT collaboration. If you buy into the proposition that the true measure of DW/BI success is business acceptance of the deliverables to improve their decision-making, then buying into the importance of collaboration should be easy. Achieving business adoption is a pipedream if the IT resources on a DW/BI team don’t collaborate with their business counterparts. Likewise, the business needs to be willing to collaborate with IT.

Continue lendo »

Design Tip #176 Dimensional Models – Logical or Physical?

Dimensional data models have been around for a very long time, almost certainly trcropped-cropped-filo01_cartoonized_42.jpgacing their lineage back to the original Data Cube project between Dartmouth and General Mills in the late 1960s. The appeal of dimensional modeling stems from the obvious simplicity of the models and the natural way in which both business people and technical folks can understand what the models mean. By Ralph Kimball – © Kimball Group. All rights reserved.

Continue lendo »