Source: http://www.google.com/patents/US7937401?dq=U.S.+Patent+No.+4,528,643)
Timestamp: 2014-03-14 11:41:03
Document Index: 3640932

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

Patent US7937401 - Multidimensional database query extension systems and methods - Google PatentsSearch Images Maps Play YouTube News Gmail Drive More »Sign inAdvanced Patent SearchPatentsThe 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...http://www.google.com/patents/US7937401?utm_source=gb-gplus-sharePatent US7937401 - Multidimensional database query extension systems and methodsAdvanced Patent SearchPublication numberUS7937401 B2Publication typeGrantApplication numberUS 11/116,924Publication dateMay 3, 2011Filing dateApr 28, 2005Priority dateJul 9, 2004Also published asUS20060020933Publication number11116924, 116924, US 7937401 B2, US 7937401B2, US-B2-7937401, US7937401 B2, US7937401B2InventorsMosha Pasumansky, Irina G. Gorbach, Alexander Gourkov Balikov, Alexander Berger, Marius Dumitru, Thomas P. ConlonOriginal AssigneeMicrosoft CorporationExport CitationBiBTeX, EndNote, RefManPatent Citations (23), Non-Patent Citations (27), Referenced by (3), Classifications (8), Legal Events (2) External Links: USPTO, USPTO Assignment, EspacenetMultidimensional database query extension systems and methodsUS 7937401 B2Abstract 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.
TECHNICAL FIELD The subject invention relates generally to databases and more particularly toward multidimensional database query systems and methods
BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram of a programming system for interaction with multidimensional data in accordance with an aspect of the subject invention.
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; } } } Furthermore, it should be noted that a stored procedure might wish to take a code path conditional on a pass number. For instance:
To further clarify the operation of system 500 consider the following example: Assume that the interface component received the MDX query �Select my_stored_procedure(args) on 0 from Sales.� The parser component 520 can receive this query and identify the extension component �my_stored_procedure(args).� This extension can be provided to the formula component 410, which sends it the execution engine 420. Execution engine 420 can located and then execute the procedure based on the arguments provided. Thereafter, the result or result object, for instance the MDX �Set� object, can be return to the formula component 410. The formula component 410 can then pass and the query component 530 can receive the result of the extension execution. A new declaratory query can then be generated by the query component 530 incorporating the extension result, �Select �result object� on 0 from Sales.� Query results can then be passed back to the query component 530, which passes it to the interface component 510, which can ultimately output the result to the requesting entity.
Turning to FIG. 6, a multidimensional database interaction system 600 is illustrated in accordance with an aspect of the subject invention. System 600 can include a set of two interfaces, namely user interface 610 and system interface component 620, to facilitate interaction with a multidimensional database system that process queries that include procedural routine calls or the like. User Interface component 610 receives multidimensional queries from users or other entities. In particular, interface component 610 can receive multidimensional declarative queries that include calls to procedural functions or routines. According to an aspect of the invention, the query can be an MDX query, for example �Select procedure(args) on 0 from Sales.� System interface component 620 receives the multidimensional query from the user interface component 610 and returns the results of such a query. These results can be provided back to the user interface component 610. The user interface component 610 can then provide the results back to the query submitting entity. According to an aspect of the invention, user interface component 610 and system interface component 620 can be separate application programming interfaces or subcomponents for single application interface providing aggregate functionality.
Patent CitationsCited PatentFiling datePublication dateApplicantTitleUS5937410Oct 16, 1997Aug 10, 1999Johnson Controls Technology CompanyMethod of transforming graphical object diagrams to product data manager schemaUS6205447Jun 30, 1997Mar 20, 2001International Business Machines CorporationRelational database management of multi-dimensional dataUS6233583Sep 10, 1998May 15, 2001International Business Machines CorporationReport generator for use within a lotus notes database systemUS6377934May 6, 1999Apr 23, 2002Metaedge CorporationMethod for providing a reverse star schema data modelUS6434557Dec 30, 1999Aug 13, 2002Decode Genetics Ehf.Online syntheses programming techniqueUS6473750 *Oct 15, 1999Oct 29, 2002Microsoft CorporationAdaptive query execution in a distributed database systemUS6651055 *Mar 1, 2001Nov 18, 2003Lawson Software, Inc.OLAP query generation engineUS7062479 *Nov 2, 2001Jun 13, 2006Cognos IncorporatedCalculation engine for use in OLAP environmentsUS20020116389Nov 29, 2001Aug 22, 2002Metaedge CoporationSystem and method for providing a data warehouse in accordance with a virtual schemaUS20030208468Apr 15, 2003Nov 6, 2003Mcnab David BoydMethod, system and apparatus for measuring and analyzing customer business volumeUS20030225736Dec 9, 2002Dec 4, 2003Reuven BakalashEnterprise-wide resource planning (ERP) system with integrated data aggregation engineUS20040044671Jan 30, 2003Mar 4, 2004Mitsuhiko YoshimuraMethod for changing database construction informationUS20040123048Jul 22, 2003Jun 24, 2004Ward MullinsDynamic 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 featuresUS20040181518 *Mar 14, 2003Sep 16, 2004Mayo Bryan EdwardSystem and method for an OLAP engine having dynamic disaggregationUS20040193567Mar 27, 2003Sep 30, 2004International Business Machines CorporationApparatus and method for using a predefined database operation as a data source for a different database operationUS20050049831Jan 24, 2003Mar 3, 2005Leica Geosystems AgPerformance monitoring system and methodUS20050071737Sep 30, 2003Mar 31, 2005Cognos IncorporatedBusiness performance presentation user interface and method for presenting business performanceUS20050216831Mar 29, 2004Sep 29, 2005Grzegorz GuzikKey performance indicator system and methodUS20050228818Mar 18, 2005Oct 13, 2005Ravi MurthyMethod and system for flexible sectioning of XML data in a database systemUS20050256896May 11, 2004Nov 17, 2005Wolfgang PfeiferLocal data repository generationUS20050283459 *Jun 22, 2004Dec 22, 2005Microsoft CorporationCombining multidimensional expressions and data mining extensions to mine OLAP cubesUS20060010164Feb 3, 2005Jan 12, 2006Microsoft CorporationCentralized KPI framework systems and methodsUS20060020619Mar 8, 2005Jan 26, 2006Microsoft CorporationDatabase generation systems and methods* Cited by examinerNon-Patent CitationsReference1Adam 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.2 *Article entitled "Expressions (MDX)" by Microsoft dated Sep. 2007.3 *Article entitled "Introducing the SQL Server 'MDX in Analysis Services' Series", dated Dec. 2, 2002, by Pearson.4 *Article entitled "Using MDX and ADOMD to Access Microsoft OLAP Data" by Youness dated 2000.5 *Article entitled "Introducing the SQL Server �MDX in Analysis Services� Series", dated Dec. 2, 2002, by Pearson.6Microsoft BI Accelerator Overview, Chapter 1, published: Jul. 10, 2002, 17 pages plus coversheet www.microsoft.com/sul/prodinfo/perviousversions/ssabi/ch1overview.mspx.7MSDN 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.8MSDN 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.9MSDN 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.10MSDN 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.11MSDN 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.12MSDN 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.13MSDN 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.14MSDN 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.15Notice of Allowance dated Feb. 22, 2010 cited in U.S. Appl. No. 11/050,130.16OA Dated Dec. 29, 2008 for U.S. Appl. No. 11/050,130, 29 pages.17OA Dated Jul. 1, 2008 for U.S. Appl. No. 11/050,130, 22 pages.18OA Dated Jul. 11, 2008 for U.S. Appl. No. 11/074,508, 31 pages.19OA Dated Mar. 2, 2009 for U.S. Appl. No. 11/074,508, 50 pages.20Office Action dated Jan. 29, 2008 cited in U.S. Appl. No. 11/074,508.21Office Action dated May 17, 2007 cited in U.S. Appl. No. 11/050,130.22Office Action dated May 9, 2007 cited in U.S. Appl. No. 11/074,508.23Office Action dated Nov. 1, 2007 cited in U.S. Appl. No. 11/050,130.24Office Action dated Nov. 9, 2009 cited in U.S. Appl. No. 11/074,508.25Office Action dated Oct. 1, 2009 cited in U.S. Appl. No. 11/050,130.26Office Action dated Oct. 17, 2007 cited in U.S. Appl. No. 11/074,508.27SQL 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.* Cited by examinerReferenced byCiting PatentFiling datePublication dateApplicantTitleUS8204901 *Sep 2, 2009Jun 19, 2012International Business Machines CorporationGenerating query predicates for processing multidimensional dataUS8412493Jan 28, 2009Apr 2, 2013International Business Machines CorporationMulti-dimensional model generation for determining service performanceUS20110055149 *Sep 2, 2009Mar 3, 2011International Business Machines CorporationGenerating query predicates for olap processing* Cited by examinerClassifications U.S. Classification707/759, 707/760, 707/758, 707/957International ClassificationG06F17/30Cooperative ClassificationG06F17/30592, Y10S707/957European ClassificationG06F17/30S8MLegal EventsDateCodeEventDescriptionJul 19, 2011CCCertificate of correctionMay 19, 2005ASAssignmentOwner name: MICROSOFT CORPORATION, WASHINGTONFree 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 20050329Free 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/0644RotateOriginal ImageGoogle Home - Sitemap - USPTO Bulk Downloads - Privacy Policy - Terms of Service - About Google Patents - Send FeedbackData provided by IFI CLAIMS Patent Services©2012 Google