Patent ID: 7979436
Filing Date: 2011-07-12
Classification: G06F

Abstract:
1. A method for executing aggregation queries in a pre-existing database, comprising: collecting database information from the pre-existing database, said database information including inconsistent dimensional tables and fact tables; running an entity discovery process on said inconsistent dimensional tables and said fact table to produce entity mapping tables; using said entity mapping tables to resolve said inconsistent dimensional tables into possible resolved dimensional tables; running the one of the aggregation queries on possible resolved databases to obtain a query result, said possible resolved databases including said resolved dimensional tables, wherein said database information comprises an auxiliary table including status information for information in said resolved dimensional tables; creating multiple resolved query tables from the running of the one of the aggregation queries on the possible resolved databases; and including a certainty status indicator in the query result that states if the query result is guaranteed or non-guaranteed.