Using multidimensional access as surrogate for run-time hash...

Details Using multidimensional access as surrogate for run-time hash... Using multidimensional access as surrogate for run-time hash...

2011-08-16

2011-08-16

Trujillo, James (Department: 2159)

Data processing: database and file management or data structures

Database and file access

Query optimization

C707S760000

Reexamination Certificate

active

08001112

ABSTRACT:
Approaches are disclosed for using a multidimensional database as a surrogate for a run-time hash table in the context of processing a relational query. In an embodiment, an analytic workspace is used to store data, wherein the data is to be evaluated using a by a function in the processing of a MODEL clause. The approaches eliminate the need to use a hash table to store the data that is to be evaluated. The data may initially reside in the analytic workspace, or it may be loaded into the analytic workspace.

REFERENCES:
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5799300 (1998-08-01), Agrawal et al.
patent: 5907848 (1999-05-01), Zaiken et al.
patent: 5918232 (1999-06-01), Pouschine et al.
patent: 5987467 (1999-11-01), Ross et al.
patent: 6163774 (2000-12-01), Lore et al.
patent: 6173292 (2001-01-01), Barber et al.
patent: 6205447 (2001-03-01), Malloy
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6421665 (2002-07-01), Brye et al.
patent: 6438537 (2002-08-01), Netz et al.
patent: 6493699 (2002-12-01), Colby et al.
patent: 6553366 (2003-04-01), Miller et al.
patent: 6560594 (2003-05-01), Cochrane et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6587857 (2003-07-01), Carothers et al.
patent: 6615203 (2003-09-01), Lin et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6629102 (2003-09-01), Malloy et al.
patent: 6651073 (2003-11-01), Lyle et al.
patent: 6665682 (2003-12-01), DeKimpe et al.
patent: 6691301 (2004-02-01), Bowen
patent: 6826556 (2004-11-01), Miller et al.
patent: 6931418 (2005-08-01), Barnes
patent: 6980980 (2005-12-01), Yeh
patent: 7020647 (2006-03-01), Egan et al.
patent: 7194465 (2007-03-01), MacGregor
patent: 7222130 (2007-05-01), Cras et al.
patent: 2002/0059195 (2002-05-01), Cras et al.
patent: 2002/0087516 (2002-07-01), Cras et al.
patent: 2002/0091681 (2002-07-01), Cras et al.
patent: 2002/0091707 (2002-07-01), Keller
patent: 2002/0103807 (2002-08-01), Yamashita
patent: 2002/0126545 (2002-09-01), Warren et al.
patent: 2002/0138353 (2002-09-01), Schreiber et al.
patent: 2002/0168621 (2002-11-01), Cook et al.
patent: 2002/0184187 (2002-12-01), Bakalash et al.
patent: 2002/0188598 (2002-12-01), Myllymaki
patent: 2003/0009295 (2003-01-01), Markowitz et al.
patent: 2003/0014417 (2003-01-01), Kelkar
patent: 2003/0084053 (2003-05-01), Govrin et al.
patent: 2003/0088540 (2003-05-01), Edmunds et al.
patent: 2003/0093424 (2003-05-01), Chun et al.
patent: 2003/0101202 (2003-05-01), Kelkar et al.
Ramsak, Frank, “Interactive ROLAP on Large Datasets: A Case Study with UB-Trees,” Database Engineering & Applications, Jul. 16-18 2001, pp. 167-176.
Ross, Kenneth A., “Serving Datacube Tuples from Main Memory,” Scientific and Statistical Database Management, Jul. 26-28, 2000, pp. 182-195.

Affiliated with

Also associated with

Rating

Using multidimensional access as surrogate for run-time hash... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Using multidimensional access as surrogate for run-time hash..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Using multidimensional access as surrogate for run-time hash... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2691798