Source: http://www.google.com/patents/US7844570?dq=6437692
Timestamp: 2015-05-23 13:10:28
Document Index: 676585476

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

Patent US7844570 - Database generation systems and methods - Google PatentsSearch Images Maps Play YouTube News Gmail Drive More »Sign inAdvanced Patent SearchPatentsThe subject invention pertains to systems and methods that facilitate generation of a database to support a multidimensional model. A database schema is generated in a top-down fashion. In particular, multidimensional structures and attributes such as cubes and dimensions can be defined. From such definition,...http://www.google.com/patents/US7844570?utm_source=gb-gplus-sharePatent US7844570 - Database generation systems and methodsAdvanced Patent SearchPublication numberUS7844570 B2Publication typeGrantApplication numberUS 11/074,508Publication dateNov 30, 2010Filing dateMar 8, 2005Priority dateJul 9, 2004Fee statusLapsedAlso published asUS20060020619Publication number074508, 11074508, US 7844570 B2, US 7844570B2, US-B2-7844570, US7844570 B2, US7844570B2InventorsAmir Netz, Paul J. Sanders, Donald M. Farmer, Kenneth Kwok, Ovidiu BurlacuOriginal AssigneeMicrosoft CorporationExport CitationBiBTeX, EndNote, RefManPatent Citations (22), Non-Patent Citations (22), Referenced by (6), Classifications (8), Legal Events (5) External Links: USPTO, USPTO Assignment, EspacenetDatabase generation systems and methods
As used in this application, the terms “component,” “sub-component,” and “system” and the like are intended to refer to a computer-related entity, either hardware, a combination of hardware and software, software, or software in execution. For example, a component may be, but is not limited to being, a process running on a processor, a processor, an object, an instance, an executable, a thread of execution, a program, and/or a computer. By way of illustration, both an application running on a computer and the computer can be a component. One or more components may reside within a process and/or thread of execution and a component may be localized on one computer and/or distributed between two or more computers.
Furthermore, the present invention may be implemented as a method, apparatus, or article of manufacture using standard programming and/or engineering techniques to produce software, firmware, hardware, or any combination thereof to control a computer to implement the disclosed invention. The term “article of manufacture” (or alternatively, “computer program product”) as used herein is intended to encompass a computer program accessible from any computer-readable device, or media. For example, computer readable media can include but are not limited to magnetic storage devices (e.g., hard disk, floppy disk, magnetic strips. . . ), optical disks (e.g., compact disk (CD), digital versatile disk (DVD). . . , smart cards, and flash memory devices (e.g., card, stick). Of course, those skilled in the art will recognize many modifications may be made to this configuration without departing from the scope or spirit of the subject invention.
FIG. 13 depicts a graphical user interface 1300 in accordance with an aspect of the invention. GUI 1300 enables particular options to be specified with respect to generation of a subject area database schema. A text box 1310 is provided to enable specification of the owning schema. The owning schema is simply the name of the schema to be created. Here, the schema is named “Sales.” GUI 1300 can also include numerous checkboxes 1320 to select options for the named schema. In this example, checkboxes correspond to the options create primary keys on dimension tables, create indexes, enforce referential integrity, and preserve data on regeneration. A drop-down menu 1330 is also provided to indicate options with respect to population of time tables. This option can be displayed when a staging area database is not to be created or the time table is not created by the staging area database or associated load component. The drop-down menu 1330 can include the selectable values “true,” “false,” and “Only if empty.” GUI 1300 also includes navigational buttons 1340 including back, next, and cancel. These buttons can be employed to affect the flow of data and more particularly to go back to the previous GUI, proceed to the next GUI or simply cancel the generation.
FIG. 14 illustrates a graphical user interface 1400 for specifying staging area options in accordance with an aspect of the subject invention. GUI 1400 allows a user to select options controlling the schema generated as well as other things such as preservation of data for a staging area database. A text box 1410 is provided for specification of the owning schema for the stage area database. In this instance, text box 1410 indicates that the schema is called “Sales Staging Area.” There are several check boxes 1420 below the text box 1410 for selection. This exemplary GUI 1400 includes check boxes 1420 for creation of primary keys on dimension tables, creation of indexes, and preservation of data on regeneration. A drop-down menu 1330 is also provided in GUI 1300 to specify whether and when time tables will be populated. Drop-down menu 1430 can include the values “true,” “false,” and “only if empty.” Finally, navigational buttons 1440 are provided to move to the next GUI, move back to the previous GUI or simply cancel generation.
FIG. 15 depicts a GUI 1500 for specification of naming conventions in accordance with an aspect of the subject invention. GUI 1500 facilitates specification of naming conventions for use in the generated schema(s). Although a generation system can employ its own default naming conventions, GUI 1500 empowers users to specify options for one or more for naming conventions. In particular, text box 1510 is provided for name convention specification. Text box 1510 is divided into two columns 1512 and 1514 for specification of an option name or identifier and the value assigned thereto. In this GUI, for example, the separator is to be an underscore. Accordingly, an underscore should be utilized as a separator rather than a space for instance, thus “Customer Name” becomes “Customer_Name.” Furthermore, it is noted that primary key names should include the prefix “PK,” for example “PK_CustomerID.” Additionally, GUI 1500 can include navigational buttons 1520 for moving to the next GUI page, moving back, finishing specification of the options and canceling generation.
FIG. 16 illustrates a GUI 1600 for summarizing the generation options specified in accordance with an aspect of the invention. GUI 1600 can be presented at the end of option selection to confirm user selection and other input. The options are presented in a text box or window 1610. Here, the generation options are summarized to include generation of a subject area database named “Sales” with a data source view by the same name, a staging area database called “Sales Staging Area” with a data source view by the same name, as well as one or more load components (referred to as DTS) for loading the Sales database from the staging area database. It is further noted in window 1610 that the data will not be preserved upon regeneration and that a time table will not be populated. The GUI 1600 also includes buttons 1620 for selection to go back to the last GUI, to move forward to the next GUI, to generate the specified databases and load components, and to cancel generation.
Turning to FIG. 18, a dialog box 1800 is illustrated in accordance with an aspect of the invention. If during generation or regeneration it is determined that data loss will occur and the option has been selected to preserve data, then dialog box 1800 will be displayed. Text box 1810 provides specific information regarding data that will be lost. In particular, the data source, the table and the column can be identified where data will be lost. In this instance, dialog box 1800 indicates that in the sales subject area database the column “Gender” will be lost in the customer table and in the sales staging area database the entire sales table will be lost. Buttons 1820, 1830 and 1840 provide a user with options to designate the action to take. Continue button 1820 indicates that generation should continue and the data lost. Cancel button 1830 indicates that generation should be canceled, while the help button 1840 designates that a help window or application should be spawned to assist the user. Additionally, while not illustrated, a third option could be provided where the data to be lost is saved to an alternate location and then the generation process proceeds resulting in the loss of such data. In this instance, the lost data can always be restored or rolled back at a later time, if necessary.
Patent CitationsCited PatentFiling datePublication dateApplicantTitleUS5937410 *Oct 16, 1997Aug 10, 1999Johnson Controls Technology CompanyMethod of transforming graphical object diagrams to product data manager schemaUS6205447 *Jun 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 systemUS6377934 *May 6, 1999Apr 23, 2002Metaedge CorporationMethod for providing a reverse star schema data modelUS6434557 *Dec 30, 1999Aug 13, 2002Decode Genetics Ehf.Online syntheses programming techniqueUS6473750Oct 15, 1999Oct 29, 2002Microsoft CorporationAdaptive query execution in a distributed database systemUS6651055Mar 1, 2001Nov 18, 2003Lawson Software, Inc.OLAP query generation engineUS7062479Nov 2, 2001Jun 13, 2006Cognos IncorporatedCalculation engine for use in OLAP environmentsUS20020116389 *Nov 29, 2001Aug 22, 2002Metaedge CoporationSystem and method for providing a data warehouse in accordance with a virtual schemaUS20030208468 *Apr 15, 2003Nov 6, 2003Mcnab David BoydMethod, system and apparatus for measuring and analyzing customer business volumeUS20030225736 *Dec 9, 2002Dec 4, 2003Reuven BakalashEnterprise-wide resource planning (ERP) system with integrated data aggregation engineUS20040044671 *Jan 30, 2003Mar 4, 2004Mitsuhiko YoshimuraMethod for changing database construction informationUS20040123048 *Jul 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 featuresUS20040181518Mar 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 methodUS20050228818 *Mar 18, 2005Oct 13, 2005Ravi MurthyMethod and system for flexible sectioning of XML data in a database systemUS20050256896May 11, 2004Nov 17, 2005Wolfgang PfeiferLocal data repository generationUS20060010164Feb 3, 2005Jan 12, 2006Microsoft CorporationCentralized KPI framework systems and methodsUS20060020933Apr 28, 2005Jan 26, 2006Microsoft CorporationMultidimensional database query extension systems and methods* Cited by examinerNon-Patent CitationsReference1 *Microsoft BI Accelerator Overview, Chapter 1, Published: Jul. 10, 2002, 17 pages plus coversheet www.microsoft.com/sql/prodinfo/previousversions/ssabi/ch1overview.mspx.2Microsoft Corp., Expressions (MDX), Microsoft TechNet, SQL Server 2005 Books Online (Sep. 2007), 3 pages.3 *Microsoft SQL 2000 Technical Articles, Analysis Services: Choosing Dimension Types in SQL Server 2000 Analysis Services, Published: Jul. 2000, 18 pages.4MSDN 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.5MSDN 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.6MSDN 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.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. 2-230.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. 231-330.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. 231-330.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. 331-493.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. 331-493.12OA Dated Dec. 29, 2008 for U.S. Appl. No. 11/050,130, 29 pages.13OA Dated Jan. 5, 2009 for U.S. Appl. No. 11/116,924, 49 pages.14OA Dated Jul. 1, 2008 for U.S. Appl. No. 11/050,130, 22 pages.15Office Action dated Dec. 8, 2009 cited in U.S. Appl. No. 11/116,924.16Office Action dated Mar. 5, 2008 cited in U.S. Appl. No. 11/116,924.17Office Action dated May 17, 2007 cited in U.S. Appl. No. 11/050,130.18Office Action dated Nov. 1, 2007 cited in U.S. Appl. No. 11/050,130.19Office Action dated Oct. 1, 2009 cited in U.S. Appl. No. 11/050,130.20Office Action dated Sep. 4, 2007 cited in U.S. Appl. No. 11/116,924.21SQL 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.22Youness, "Using NDX and ADOMD to Access Microsoft OLAP Data" dated 2000.* Cited by examinerReferenced byCiting PatentFiling datePublication dateApplicantTitleUS8024305 *Jun 26, 2008Sep 20, 2011International Business Machines CorporationUpdating a data warehouse schema based on changes in an observation modelUS8219991May 6, 2008Jul 10, 2012International Business Machines CorporationConsolidated launching of multiple tasksUS8302073Jun 15, 2006Oct 30, 2012International Business Machines CorporationMoving and copying dependencies along with source codeUS8423956May 5, 2008Apr 16, 2013International Business Machines CorporationSharing resources among hierarchical containers of resourcesUS8571909 *Aug 15, 2012Oct 29, 2013Roundhouse One LlcBusiness intelligence system and method utilizing multidimensional analysis of a plurality of transformed and scaled data streamsWO2014092697A1 *Dec 11, 2012Jun 19, 2014Tmm Data, LlcMethods and systems for collecting, managing, and sharing data* Cited by examinerClassifications U.S. Classification707/601, 707/605, 707/606, 707/803International ClassificationG06F17/30, G06F7/00Cooperative ClassificationG06F17/30592European ClassificationG06F17/30S8MLegal EventsDateCodeEventDescriptionJan 20, 2015FPExpired due to failure to pay maintenance feeEffective date: 20141130Dec 9, 2014ASAssignmentOwner name: MICROSOFT TECHNOLOGY LICENSING, LLC, WASHINGTONFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MICROSOFT CORPORATION;REEL/FRAME:034543/0001Effective date: 20141014Nov 30, 2014LAPSLapse for failure to pay maintenance feesJul 11, 2014REMIMaintenance fee reminder mailedMar 22, 2005ASAssignmentOwner name: MICROSOFT CORPORATION, WASHINGTONFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:NETZ, AMIR;SANDERS, PAUL J.;FARMER, DONALD M.;AND OTHERS;REEL/FRAME:015804/0724Effective date: 20050304RotateOriginal ImageGoogle Home - Sitemap - USPTO Bulk Downloads - Privacy Policy - Terms of Service - About Google Patents - Send FeedbackData provided by IFI CLAIMS Patent Services