You are here: Need help with big data mart model « MsSQL Server « IT news, forums, messages
Need help with big data mart model

Posted by CasperinMiami on 11/01/05 20:37

I have a problem in a datamart my team is developing. There is a
split in approach within the team, one side taking the approach of
having a huge Fact table (resulting in literally billions of rows of
data) and another team having a fairly flat model that will result in
less rows, but longer response time to execute the BI queries.

My question is this: At what point does a FACT table too large? At
what point is a model for Business Intelligence too unwieldy and that
a compromise be agreed to for response time vs load and �completeness.

Thanks,

-C

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/help-big-data-mart-model-ftopict267633.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=919514

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация