database - Why is the business activity/engagement of OLAP so small in comparison to OLTP one? -


http://sql.wikis.com/wc.dll?sql~datawarehouse tells:

  • "sid adelman of sid adelman & associates in recent presentation observed meta group estimates the cost of single data warehouse implementation project runs around $3 million, , single, initial implementation, near scope of providing integrated views entire enterprise"

i afraid $3 million not tell majority of ppl.

how relate cost of corresponding (by size , level of data processing of) oltp database implementation?
higher/lower? how many times?

note olap solutions being implemented after costs of dbms made oltp solutions...

why costs elevated?

update:
let me reformulate question: why olap solutions rather rare in comparison oltp ones?

does laboriousness , costs of olap seem prohibitive?

nobody seems doubt in need , necessity spend money on oltp.
though, logical point of view, not clear me why not vice versa?
there lot of legacy data sources accumulated outside of dbms...

update2:
reformulating question again...
1 can judge professional , business activity in areas activity (number , frequency) of forum posts questions, vacancies, etc.
oltp related questions has 2 orders more frequency(number) of questions compared olap ones in site.
why it?

why it? oltp related questions has 2 orders more frequency(number) of questions compared olap ones in site.

could experienced database developers olap while oltp done application programmers little or no database knowledge? there less need ask questions , questions have tend complex forum.

could there fewer olap databases because need 1 or more oltp databases pull data , olap implementations consolidate data many oltp databases? small databases , databases on subjects don't need data warehousing solutions @ all? there no need develop data warehouse if reporting needs perform adequately aginst oltp database, amount of data gets large , reporting gets complex these types of projects initiated.

i can assure our enterprise oltp databases cost considerably more 3 million develop. comparison our olap databases cheaper. have spent less 5% of development time on olap on oltp. maybe less 1%.


Comments

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -