Disambiguation with respect to multi-grained dimension...

Data processing: structural design – modeling – simulation – and em – Modeling by mathematical expression

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S706000, C707S708000, C707S725000, C707S777000

Reexamination Certificate

active

08036859

ABSTRACT:
Each of a plurality of dimension coordinates corresponding to a report query has a finer grain and a coarser grain. A subset of the dimension coordinates are dimension coordinates for which there is ambiguity as to what coarser grain value should be associated with the finer grain value. For every unique finer grain value of the dimension coordinates of the subset, it is determined what coarser grain value to associate with all dimension coordinates of the subset having that finer grain value. The determined coarser grain value is the coarser grain value of one of the dimension coordinates, of the subset, having that finer grain value. For each of the dimension coordinates of the plurality of dimension coordinates not in the subset, the coarser grain value associated with that dimension coordinate is the coarser grain value of that dimension coordinate. A report is generated in view of the plurality of dimension coordinates and their associated coarser grain values.

REFERENCES:
patent: 5832496 (1998-11-01), Anand et al.
patent: 5864857 (1999-01-01), Ohata et al.
patent: 6578028 (2003-06-01), Egilsson et al.
patent: 6735593 (2004-05-01), Williams
patent: 6970874 (2005-11-01), Egilsson et al.
patent: 7653528 (2010-01-01), Kohlmeier et al.
patent: 2002/0062315 (2002-05-01), Weiss et al.
patent: 2002/0095430 (2002-07-01), Egilsson et al.
patent: 2002/0099563 (2002-07-01), Adendorff et al.
patent: 2002/0116362 (2002-08-01), Li et al.
patent: 2002/0198909 (2002-12-01), Huynh et al.
patent: 2003/0023608 (2003-01-01), Egilsson et al.
patent: 2004/0153435 (2004-08-01), Gudbjartsson et al.
patent: 2005/0060332 (2005-03-01), Bernstein et al.
patent: 2005/0080802 (2005-04-01), Cras et al.
patent: 2007/0233651 (2007-10-01), Deshpande et al.
patent: 2008/0154856 (2008-06-01), Riise et al.
patent: 2418753 (2003-08-01), None
patent: 1450274 (2004-08-01), None
U.S. Appl. No. 11/427,718, filed Jun. 29, 2006.
Kimball, Ralph, “Kimball Design Tip #8: Perfectly Partitioning History with the Type 2 Slowly Changing Dimension”, No. 8, May 21, 2000, www.kimballgroup.com.
Kimball, Ralph, “Human Resource Data Marts: Design Guidelines for Querying and Analyzing Employee Data”, DBMS online, http://www.dbmsmag.com/9802d05.html, printed on Jun. 14, 2006.
Kimball, Ralph, “Surrogate Keys: Keep Control Over Record identifiers by Generating New Keys for the Data Warehouse”, DBMS online, http://www.dbmsmag.com/9805d05.html, printed on Jun. 14, 2006.
Kimball, Ralph, “Pipelining Your Surrogates: A Good Surrogate Key System is Worth the Work”, DBMS online, http://www.dbmsmag.com/9806d05.html, printed on Jun. 14, 2006.
International Search Report in corresponding PCT application PCT/US2007/087104, mailed Jun. 5, 2008.
Written Opinion in corresponding PCT application PCT/US2007/087104, mailed Jun. 5, 2008.
Samtani et al., “Recent Advances and Research Problems in Data Warehousing,” Advancing in Database Technologies. Workshops on Data Warehousing and Data Mining, Mobile Data Access and Collaborative Work Support and Spatio-Temporal Data Management, Nov. 19, 1998, pp. 81-92.
Riedewald et al., “ Efficient Integration and Aggergation of Historian Infonrmation,” Sigmod 2002. Proceedings of the ACM Sigmod International Conference on the Management of Data, Madison, WI, Jun. 4-6, 2002, pp. 13-24.
Bauer et al, “Data-Warehouse-Systeme,” Architektur Entwicklung Anwendung, 2001, pp. 183-195, Heidleberg Germany.
Reiger, B. “Mastering Time Variences of Dimension Tables in the Data Warehouse,” Internet Citation, Apr. 14, 1999, Retrieved from the Internet: URL: http://andromeda.oec.uni-osnabrueck.de/uwdstift/DMOS-ref.pdf, retrieved on Nov. 14, 2007.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Disambiguation with respect to multi-grained dimension... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Disambiguation with respect to multi-grained dimension..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Disambiguation with respect to multi-grained dimension... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-4271521

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.