Reporting and summarizing metrics in sparse relationships on an OLTP database
作者： Michael L. Lamb , Biswadeep Banerjee , Vishnukumar T Santharam , Mack E. Phelps
DOI:
关键词:
摘要: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting set base tables database; and (ii) creating factless materialized query table, having maximum sparsity, for tables. The includes at least two keys including distinct primary keys. table one record associated each Each value every key
lens.org 参考文章(15)
Raisa Ifraimov, Francis E. Brindel, Michael Van Schaick, Paul Kohlmiller, Richard P. Mansour, Analytical methods and software product for automated health care information systems ,(2008)
Amit Gupta, Carlos Mazuela, Daniel M. Farrell, Stanislav Vohnik, Chuck Ballard, Dimensional Modeling: In a Business Intelligence Environment ,(2006)
Terence Patrick Purcell, Performing a multiple table join operating based on generated predicates from materialized results ,(2004)
Jian Le, Daniel DeKimpe, Method, apparatus and program storage device for optimizing a data warehouse model and operation ,(2005)
Aaron C Beals, Foster D Hinshaw, Materialized view system and method ,(2004)
Yefim Shuf, Hong Min, Terence P. Purcell, Zhong Liang Zhang, Xiao Bo Wang, Dong Sheng Chen, Generating materialized query table candidates ,(2010)
Tom Fazal, Michael Adendorff, Simon Palmer, Report management system ,(2006)
Guy Shaked, Reuven Bakalash, Joseph Caspi, Data aggregation server supporting rapid query response with sparse multi-dimensional data ,(2002)
John Vernale, Harikrishna Raghumandala, Asha Kiran Potdar, System and method for processing and analyzing dimension data ,(2010)
Randall Bello, Andrew Witkowski, Mohamed Ziauddin, Rewriting queries to access materialized views that group along an ordered dimension ,(1999)