Data processing: structural design – modeling – simulation – and em – Modeling by mathematical expression
Reexamination Certificate
2006-12-22
2011-10-11
Silver, David (Department: 2128)
Data processing: structural design, modeling, simulation, and em
Modeling by mathematical expression
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.
Beyer Law Group LLP
Calle Angel
Merced Systems, Inc.
Silver David
LandOfFree
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.
Profile ID: LFUS-PAI-O-4271521