Fact dimensions in multidimensional databases

Details Fact dimensions in multidimensional databases Fact dimensions in multidimensional databases

2005-05-24

2010-10-05

Robinson, Greta L (Department: 2169)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Using a denormalized schema

C707S600000, C707S605000

Reexamination Certificate

active

07809678

ABSTRACT:
The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.

REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5940818 (1999-08-01), Malloy et al.
patent: 5978788 (1999-11-01), Castelli et al.
patent: 6189004 (2001-02-01), Rassen et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6212524 (2001-04-01), Weissman et al.
patent: 6223171 (2001-04-01), Chaudhuri et al.
patent: 6317750 (2001-11-01), Tortolani et al.
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6542895 (2003-04-01), DeKimpe
patent: 6578028 (2003-06-01), Egilsson et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 6721760 (2004-04-01), Ono et al.
patent: 6775675 (2004-08-01), Nwabueze et al.
patent: 6877006 (2005-04-01), Vasudevan
patent: 6901406 (2005-05-01), Nabe et al.
patent: 6970874 (2005-11-01), Egilsson et al.
patent: 7562086 (2009-07-01), Mirchandani
patent: 2002/0087633 (2002-07-01), Nelson
patent: 2002/0087686 (2002-07-01), Cronk
patent: 2002/0099692 (2002-07-01), Shah et al.
patent: 2004/0059724 (2004-03-01), Petculescu et al.
patent: 2004/0215626 (2004-10-01), Colossi et al.
patent: 2004/0225692 (2004-11-01), Pasumansky et al.
patent: 2005/0010565 (2005-01-01), Cushing et al.
patent: 2005/0065939 (2005-03-01), Miao
patent: 2005/0076067 (2005-04-01), Bakalash et al.
patent: 2005/0283488 (2005-12-01), Colossi et al.
patent: 2006/0010143 (2006-01-01), Netz
OA dated Jan. 26, 2009 for U.S. Appl. No. 11/167,413, 25 pages.
Wil Blake et al., Delta Service in a Mobile File System Client Cache, 1998, IEEE pp. 222-228.
Office Action dated Sep. 19, 2007 cited in U.S. Appl. No. 11/167,413.
Office Action dated Mar. 5, 2008 cited in U.S. Appl. No. 11/167,413.
Office Action dated Aug. 11, 2008 cited in U.S. Appl. No. 11/167,413.
Notice of Allowance dated Apr. 13, 2009 cited in U.S. Appl. No. 11/167,413.
Office Action dated Aug. 8, 2007 cited in U.S. Appl. No. 11/137,232.
Office Action dated Apr. 25, 2008 cited in U.S. Appl. No. 11/137,232.
Office Action dated Jan. 8, 2009 cited in U.S. Appl. No. 11/137,232.
Office Action dated Jul. 20, 2009 cited in U.S. Appl. No. 11/137,232.
Office Action dated Feb. 23, 2010 cited in U.S. Appl. No. 11/137,232.

Affiliated with

Also associated with

Rating

Fact dimensions in multidimensional databases does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Fact dimensions in multidimensional databases, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Fact dimensions in multidimensional databases will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4216229