loading...
Optimization of Hypothetical Queries in an OLAP Environment
San Diego, California February 28-March 03
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2000.83942816th International Conference on Data ...
 This Article 
 
PURCHASE ARTICLE: $0
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Andrey Balmin, University of California at San Diego
Yannis Papakonstantinou, University of California at San Diego
Thanos Papadimitriou, University of California at Los Angeles
Analysts and decision-makers use what-if analysis to assess the effects of hypothetical scenarios on historical data. Current On-Line Analytical Processing (OLAP) systems support what-if analysis only by physically replicating the data warehouse and modifying it according to the scenario. This process may take hours, hence limiting the applicability of OLAP.To eliminate this inefficiency, we built and OLAP toolkit, called Sesame, that exploits the following two opportunities. First, typically a small part of the modified data is needed to answer the hypothetical query. For example, the analyst, might be interested in results of the new strategy only during certain periods of time, and maybe 90% of the modifications were not needed. Second, data warehouses tend to have pre-computed materialized views, to help answer popular queries.
Citation:
Andrey Balmin, Yannis Papakonstantinou, Thanos Papadimitriou, "Optimization of Hypothetical Queries in an OLAP Environment," icde, pp.311, 16th International Conference on Data Engineering (ICDE'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions