INDEXING IN WAREHOUSE AND BUSINESS INTELLIGENCE

View previous topic View next topic Go down

INDEXING IN WAREHOUSE AND BUSINESS INTELLIGENCE

Post  arun a on Tue Oct 13, 2009 9:08 am

I have trouble to understand the indexing concept in both warehouse and BI "When does the intelligence go for indexing option !?" Is there any specific situation ?

arun a

Posts : 1
Join date : 2009-10-13

View user profile

Back to top Go down

Re: INDEXING IN WAREHOUSE AND BUSINESS INTELLIGENCE

Post  ngalemmo on Tue Oct 13, 2009 11:50 am

I do not fully understand the question.

If you are referring to indexing the physical database, then there really isn't any option... data warehouses are heavily indexed, much more extensivly than transactional systems. (Unless you are using specialized hardware, such as Netezza, which doesn't support indexing.) The need for indexes is primarily because a data warehouse is called on to service ad-hoc queries in an unstructured environment. How you index is a function of what database system you are using (Oracle, for example, has significantly different indexing methods than SQL Server, and Teradata is significantly different that the other two), and most vendors have a data warehousing section in their technical documentation that recommends suitable approaches for their system.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum