Multidimensional database query extension systems and methods

Details Multidimensional database query extension systems and methods Multidimensional database query extension systems and methods

2011-05-03

2011-05-03

Dwivedi, Mahesh H (Department: 2168)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S758000, C707S760000, C707S957000

Reexamination Certificate

active

07937401

ABSTRACT:
The subject invention pertains to the integration of an object model and a multidimensional database query language such as MDX. In particular, multidimensional declarative query language entities can be exposed through objects in an object model. The object model enables generation and employment of procedural language functions, routines, or procedures that interact with multidimensional database data. This effectively provides an extension for multidimensional query languages. For example, procedures can be stored and invoked from a declarative language query. Furthermore, the object model disclosed herein can expose a context object to enable conditional procedures based on the context of execution.

REFERENCES:
patent: 5937410 (1999-08-01), Shen
patent: 6205447 (2001-03-01), Malloy
patent: 6233583 (2001-05-01), Hoth
patent: 6377934 (2002-04-01), Chen et al.
patent: 6434557 (2002-08-01), Egilsson et al.
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6651055 (2003-11-01), Kilmer et al.
patent: 7062479 (2006-06-01), Edmunds et al.
patent: 2002/0116389 (2002-08-01), Chen et al.
patent: 2003/0208468 (2003-11-01), McNab et al.
patent: 2003/0225736 (2003-12-01), Bakalash et al.
patent: 2004/0044671 (2004-03-01), Yoshimura et al.
patent: 2004/0123048 (2004-06-01), Mullins et al.
patent: 2004/0181518 (2004-09-01), Mayo et al.
patent: 2004/0193567 (2004-09-01), Dettinger et al.
patent: 2005/0049831 (2005-03-01), Lilly
patent: 2005/0071737 (2005-03-01), Adendorff et al.
patent: 2005/0216831 (2005-09-01), Guzik et al.
patent: 2005/0228818 (2005-10-01), Murthy et al.
patent: 2005/0256896 (2005-11-01), Pfeifer et al.
patent: 2005/0283459 (2005-12-01), MacLennan et al.
patent: 2006/0010164 (2006-01-01), Netz
patent: 2006/0020619 (2006-01-01), Netz
Article entitled “Expressions (MDX)” by Microsoft dated Sep. 2007.
Article entitled “Using MDX and ADOMD to Access Microsoft OLAP Data” by Youness dated 2000.
Article entitled “Introducing the SQL Server ‘MDX in Analysis Services’ Series”, dated Dec. 2, 2002, by Pearson.
SQL Server Accelerator for BI Overview. http://www.microsoft.com/sql/prodinfo/previousversions/ssabi/overview. mspx. Jun. 24, 2003, Last accessed Mar. 27, 2006. 4 pages.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 1-101.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 2-230.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 231-330.
MSDN Library, SQL Server 2000, Analysis Services (Analysis Services SQL Server). http://msdn.microsoft.com/library/en-us/olapdmad/aggettingstart—80xj.asp?frame=true. 2006 Microsoft Corporation. Last accessed Mar. 27, 2006. pp. 331-493.
Microsoft BI Accelerator Overview, Chapter 1, published: Jul. 10, 2002, 17 pages plus coversheet www.microsoft.com/sul/prodinfo/perviousversions/ssabi/ch1overview.mspx.
Adam Shapiro, “Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services”, Microsoft SQL 2000 Technical Articles, Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services, Published: Jul. 2000, 18 pages.
OA Dated Jul. 11, 2008 for U.S. Appl. No. 11/074,508, 31 pages.
OA Dated Mar. 2, 2009 for U.S. Appl. No. 11/074,508, 50 pages.
OA Dated Dec. 29, 2008 for U.S. Appl. No. 11/050,130, 29 pages.
OA Dated Jul. 1, 2008 for U.S. Appl. No. 11/050,130, 22 pages.
Office Action dated May 17, 2007 cited in U.S. Appl. No. 11/050,130.
Office Action dated Nov. 1, 2007 cited in U.S. Appl. No. 11/050,130.
Office Action dated Oct. 1, 2009 cited in U.S. Appl. No. 11/050,130.
Office Action dated May 9, 2007 cited in U.S. Appl. No. 11/074,508.
Office Action dated Oct. 17, 2007 cited in U.S. Appl. No. 11/074,508.
Office Action dated Jan. 29, 2008 cited in U.S. Appl. No. 11/074,508.
Office Action dated Nov. 9, 2009 cited in U.S. Appl. No. 11/074,508.
Notice of Allowance dated Feb. 22, 2010 cited in U.S. Appl. No. 11/050,130.

Affiliated with

Also associated with

Rating

Multidimensional database query extension systems and methods does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Multidimensional database query extension systems and methods, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multidimensional database query extension systems and methods will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2627560