Harnessing Knowledge from Ad Hoc Queries by Creating a Zone of Standardization

Business Intelligence drives strategic business decisions by providing timely and accurateinformation. Beneath the demand for constantly changing information-needs usually lay a highly complexentangled mesh of business rules, data sets, query logic and custom-ad hoc Reports. The discrete natureof ad hoc reports may lead to inefficiencies in processing times and also valuable business knowledge isbeing lost. If the ad hoc queries are viewed within a context of larger collection of queries we couldderive meaningful information worthy of reuse. Expert Query System (EQS) is an approach that drives adhoc queries towards standardization, structure and documentation to reuse, recycle queries, harnessknowledge and reduce the foot prints of the subsequent ad hoc queries. Therefore, a comprehensive, realtime, manageable, and knowledge-based solution for ad hoc reporting is absolutely necessary. Weproposed an expert query system based on a common metadata model that incrementally matures itselfand presents information to the users in relative terms to empower business intelligence solution.