Combining multi-dimensional data sources using database...

Details Combining multi-dimensional data sources using database... Combining multi-dimensional data sources using database...

2005-12-28

2008-12-09

Fleurantin, Jean Bolte (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07464083

ABSTRACT:
A system, method and computer program product for linking multidimensional data sources in a relational database using database joins are disclosed. Attributes from a join query are filtered. The attributes include characteristics and restrictions of the join query. A subset of the attributes that are relevant to the multidimensional data source are extracted. A partial join query is generated from the extracted subset of the attributes. The partial join query includes characteristics and restrictions that are relevant to the multidimensional data source. It makes use of aggregated data defined for the multidimensional data source if appropriate.

REFERENCES:
patent: 5603024 (1997-02-01), Goldring
patent: 5897632 (1999-04-01), Dar et al.
patent: 5991754 (1999-11-01), Raitto et al.
patent: 6003024 (1999-12-01), Bair et al.
patent: 6192357 (2001-02-01), Krychniak
patent: 6233573 (2001-05-01), Bair et al.
patent: 6480836 (2002-11-01), Colby et al.
patent: 6505189 (2003-01-01), On Au et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6636870 (2003-10-01), Roccaforte
patent: 6775682 (2004-08-01), Ballamkonda et al.
patent: 7010538 (2006-03-01), Black
patent: 7035843 (2006-04-01), Bellamkonda et al.
patent: 7185016 (2007-02-01), Rasmussen
patent: 7191169 (2007-03-01), Tao
patent: 2003/0009464 (2003-01-01), Campbell et al.
patent: 2003/0055832 (2003-03-01), Roccaforte
patent: 2003/0208506 (2003-11-01), Greenfield et al.
patent: 2004/0122814 (2004-06-01), Zhang et al.
patent: 2004/0215626 (2004-10-01), Colossi et al.
patent: 2005/0027721 (2005-02-01), Saenz
patent: 2005/0033741 (2005-02-01), Dombroski et al.
patent: 2005/0060300 (2005-03-01), Stolte et al.
patent: 2005/0065940 (2005-03-01), Bakalash et al.
patent: 2005/0076045 (2005-04-01), Stenslet et al.
patent: 2005/0091237 (2005-04-01), Bakalash et al.
patent: 2005/0138001 (2005-06-01), Mittal et al.
patent: 2005/0165741 (2005-07-01), Gordon
patent: 2005/0262071 (2005-11-01), Prager
patent: 2006/0122964 (2006-06-01), Yu et al.
patent: 2007/0061287 (2007-03-01), Le et al.
patent: 2007/0130180 (2007-06-01), Rasmussen
“Design data marts for data warehouses”—ACM TOSEM, vol. 10, issue 4, ACM Oct. 2001—pp. 452-483.
“A Case for Dynamic View Management”—ACM TODS vol. 26, issue 4 ACM Dec. 2001, Yannis Kotidis and Nick Roussopoulos—pp. 388-423.
“User-cognizant multidimensional analysis”—Sunita Sarawagi—The VLDB Journal vol. 10, issue 2-3, ACM Sep. 2001, pp. 224-239.
Akinde, Michael et al., “The MD-join: An Operator for Complex OLAP”, Proceedings, 17th International Conference on Data Engineering (ICDE'01), pp. 524-533 (2001).
Colby, Latha et al., “Red Brick Vista™: Aggregate Computation and Management”, Proceedings of the 14thInternational Conference on Data Engineering; pp. 174-177 (1998).
Gupta, Ashish et al., “Aggregate-Query Processing in Data Warehousing Environments”, Proceedings of the 21th international Conference on Very Large Data Bases, pp. 358-369 (1995).

Affiliated with

Also associated with

Rating

Combining multi-dimensional data sources using database... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Combining multi-dimensional data sources using database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Combining multi-dimensional data sources using database... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4025975