Source: https://patents.google.com/patent/US7937401B2/en
Timestamp: 2019-12-11 11:30:51
Document Index: 651185884

Matched Legal Cases: ['art-80', 'art—80', 'art-80', 'art—80', 'art-80', 'art—80', 'art-80', 'art—80']

US7937401B2 - Multidimensional database query extension systems and methods - Google Patents
Multidimensional database query extension systems and methods Download PDF
US7937401B2
US7937401B2 US11/116,924 US11692405A US7937401B2 US 7937401 B2 US7937401 B2 US 7937401B2 US 11692405 A US11692405 A US 11692405A US 7937401 B2 US7937401 B2 US 7937401B2
US11/116,924
US20060020933A1 (en
Irina G. Gorbach
Alexander Gourkov Balikov
2005-04-28 Priority to US11/116,924 priority patent/US7937401B2/en
2005-05-19 Assigned to MICROSOFT CORPORATION reassignment MICROSOFT CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: BALIKOV, ALEXANDER GOURKOV, BERGER, ALEXANDER, GORBACH, IRINA G., PASUMANSKY, MOSHA
2006-01-26 Publication of US20060020933A1 publication Critical patent/US20060020933A1/en
2011-05-03 Publication of US7937401B2 publication Critical patent/US7937401B2/en
230000002104 routine Effects 0 abstract claims description 16
MDX.Set tset1; MDX.Set tset2; MDX.Set tset3; tset1 = Database(0).Cube(0).Dimension(0).Hierarchy(0).Level(0).Members; tset1 = Database(0).Cube(0).Dimension(1).Hierarchy(0).Level(0).Members; tset3 = MDX.MDX.Crossjoin(tset1, tset2);
MDX.Member X; X = X.Parent; X = X.Lead(3); X = X.FirstChild;
MDX.Cub cub; MDX.Tuple CurTup; MDX.Member DefMemb; MDX.Member memb; MDX.Dimension TimeDim; MDX.Level YrLev; cub = MDX.Context.CurrentCube; CurTup = MDX.Context.CurrentTuple; TimeDim = cub.Dimensions(“[Time]”); YrLev = cub.Dimension(“[Time]”).Hierarchies(0).Levels(“Year”); TimeMemb1997 = cub.Dimensions(“[Time]”).Hierarchies(0). Levels(“[Year]”).Members(“[1997]”); TimeMemb1998 = Cub.Dimensions(“[Time]”).Hierarchies(0). Levels(“[Year]”).Members(“[1998]”); For each memb in CurTup { If memb.ParentLevel.ParentHierarchy.ParentDimension = TimeDim { Switch (MDXFunction.Ancestor(memb, YrLev) { Case TimeMemb 1997: DoSomething( ); break; Case TimeMemb 1998: DoSomething( ); break; Default: DoDefault( ); break; } } }
US11/116,924 2004-07-09 2005-04-28 Multidimensional database query extension systems and methods Expired - Fee Related US7937401B2 (en)
US11/116,924 US7937401B2 (en) 2004-07-09 2005-04-28 Multidimensional database query extension systems and methods
US20060020933A1 US20060020933A1 (en) 2006-01-26
US7937401B2 true US7937401B2 (en) 2011-05-03
ID=35658726
US11/116,924 Expired - Fee Related US7937401B2 (en) 2004-07-09 2005-04-28 Multidimensional database query extension systems and methods
US (1) US7937401B2 (en)
JP5149550B2 (en) * 2007-06-12 2013-02-20 ゼネラル・エレクトリック・カンパニイ Soft switching based on microelectromechanical systems
US10339133B2 (en) * 2013-11-11 2019-07-02 International Business Machines Corporation Amorphous data preparation for efficient query formulation
US10048952B2 (en) * 2015-11-11 2018-08-14 Oracle International Corporation Compiler optimized data model evaluation
US20030208468A1 (en) 2002-04-15 2003-11-06 Mcnab David Boyd Method, system and apparatus for measuring and analyzing customer business volume
US20040123048A1 (en) 2002-07-22 2004-06-24 Ward Mullins Dynamic object-driven database manipulation and mapping system having a simple global interface and an optional multiple user need only caching system with disable and notify features
2005-04-28 US US11/116,924 patent/US7937401B2/en not_active Expired - Fee Related
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.
Article entitled "Expressions (MDX)" by Microsoft dated Sep. 2007. *
Article entitled "Introducing the SQL Server ‘MDX in Analysis Services’ Series", dated Dec. 2, 2002, by Pearson. *
Article entitled "Introducing the SQL Server 'MDX in Analysis Services' Series", dated Dec. 2, 2002, by Pearson. *
Article entitled "Using MDX and ADOMD to Access Microsoft OLAP Data" by Youness dated 2000. *
Microsoft BI Accelerator Overview, Chapter 1, published: Jul. 10, 2002, 17 pages plus coversheet www.microsoft.com/sul/prodinfo/perviousversions/ssabi/ch1overview.mspx.
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. 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. 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. 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.
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.
Notice of Allowance dated Feb. 22, 2010 cited in U.S. Appl. No. 11/050,130.
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.
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.
Office Action dated Jan. 29, 2008 cited in U.S. Appl. No. 11/074,508.
Office Action dated May 17, 2007 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 Nov. 1, 2007 cited in U.S. Appl. No. 11/050,130.
Office Action dated Nov. 9, 2009 cited in U.S. Appl. No. 11/074,508.
Office Action dated Oct. 1, 2009 cited in U.S. Appl. No. 11/050,130.
Office Action dated Oct. 17, 2007 cited in U.S. Appl. No. 11/074,508.
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.
US20060020933A1 (en) 2006-01-26
US7500225B2 (en) 2009-03-03 SQL server debugging in a distributed database environment
US9946756B2 (en) 2018-04-17 Mechanism to chain continuous queries
US20100332526A1 (en) 2010-12-30 Method(s) For Updating Database Object Metadata
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:PASUMANSKY, MOSHA;GORBACH, IRINA G.;BALIKOV, ALEXANDER GOURKOV;AND OTHERS;SIGNING DATES FROM 20050309 TO 20050329;REEL/FRAME:016035/0644
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:PASUMANSKY, MOSHA;GORBACH, IRINA G.;BALIKOV, ALEXANDER GOURKOV;AND OTHERS;REEL/FRAME:016035/0644;SIGNING DATES FROM 20050309 TO 20050329