Complex data warehousing and knowledge discovery for advanced retrieval development