Source: http://www.google.com/patents/US7664804?dq=6,044,471
Timestamp: 2015-03-31 13:01:54
Document Index: 81607119

Matched Legal Cases: ['Application No. 200510082407', 'Application No. 200510082420', 'Application No. 200510082420', 'Application No. 200510082420', 'Application No. 200510082420', 'Application No. 05', 'Application No. 05', 'Application No. 05104477', 'Application No. 0510620']

Patent US7664804 - Method, system, and apparatus for exposing workbook ranges as data sources - Google PatentsSearch Images Maps Play YouTube News Gmail Drive More »Sign inAdvanced Patent SearchPatentsA method, system, and apparatus are provided for exposing and utilizing workbook ranges as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including a range that includes data objects. The workbook may be published...http://www.google.com/patents/US7664804?utm_source=gb-gplus-sharePatent US7664804 - Method, system, and apparatus for exposing workbook ranges as data sourcesAdvanced Patent SearchPublication numberUS7664804 B2Publication typeGrantApplication numberUS 10/858,175Publication dateFeb 16, 2010Filing dateJun 1, 2004Priority dateJun 1, 2004Fee statusPaidAlso published asCA2508933A1, CN1758247A, CN100547586C, EP1605367A2, EP1605367A3, US20050267853Publication number10858175, 858175, US 7664804 B2, US 7664804B2, US-B2-7664804, US7664804 B2, US7664804B2InventorsDaniel C. Battagin, Liviu Asnash, Amir Netz, Cristian Petculescu, Eran MegiddoOriginal AssigneeMicrosoft CorporationExport CitationBiBTeX, EndNote, RefManPatent Citations (58), Non-Patent Citations (30), Referenced by (6), Classifications (19), Legal Events (2) External Links: USPTO, USPTO Assignment, EspacenetMethod, system, and apparatus for exposing workbook ranges as data sources
US 7664804 B2Abstract
When building workbooks, users of spreadsheet application programs often utilize data from a number of different sources. For instance, when creating a workbook within a spreadsheet application program, a user may import data from another workbook, may enter data into the workbook manually, or may obtain data by executing queries on a relational database or on an on-line analytical processing (�OLAP�) cube. Once the data has been entered from any of these sources, a user typically arranges the data in the desired configuration within the workbook. At the end of this process, the user has created a workbook that includes a tabular range of data upon which meaningful numerical analysis may be performed.
Patent CitationsCited PatentFiling datePublication dateApplicantTitleUS5437006Jan 27, 1993Jul 25, 1995Microsoft CorporationSpreadsheet command/function capability from a dynamic-link libraryUS5870522Jun 7, 1995Feb 9, 1999Samsung Electronics Co., Ltd.Backward compatible HDTV recording/reproducing systemUS5890174Nov 16, 1995Mar 30, 1999Microsoft CorporationMethod and system for constructing a formula in a spreadsheetUS5893123Jun 22, 1995Apr 6, 1999Tuinenga; Paul W.System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheetUS5933818Jun 2, 1997Aug 3, 1999Electronic Data Systems CorporationData analysis systemUS5937406Jan 31, 1997Aug 10, 1999Informix Software, Inc.File system interface to a databaseUS5974416Nov 10, 1997Oct 26, 1999Microsoft CorporationMethod of creating a tabular data stream for sending rows of data between client and serverUS6012057 *Jul 30, 1997Jan 4, 2000Quarterdeck CorporationHigh speed data searching for information in a computer systemUS6055548Jun 3, 1996Apr 25, 2000Microsoft CorporationComputerized spreadsheet with auto-calculatorUS6094651Aug 22, 1997Jul 25, 2000International Business Machines CorporationDiscovery-driven exploration of OLAP data cubesUS6157934Oct 15, 1996Dec 5, 2000Ultimus, L.L.C.Method and apparatus for using distributed spreadsheets in a client/server architecture for workflow automationUS6269377Sep 21, 1998Jul 31, 2001Microsoft CorporationSystem and method for managing locations of software components via a source listUS6282548Jun 21, 1997Aug 28, 2001Alexa InternetAutomatically generate and displaying metadata as supplemental information concurrently with the web page, there being no link between web page and metadataUS6317750 *Oct 26, 1998Nov 13, 2001Hyperion Solutions CorporationMethod and apparatus for accessing multidimensional dataUS6411313 *Jun 14, 1999Jun 25, 2002Microsoft CorporationUser interface for creating a spreadsheet pivottableUS6430584Mar 14, 2000Aug 6, 2002Microsoft CorporationComputerized spreadsheet with auto-calculatorUS6446059Jun 22, 1999Sep 3, 2002Microsoft CorporationRecord for a multidimensional database with flexible pathsUS6456999Jun 22, 1999Sep 24, 2002Microsoft CorporationAggregations size estimation in database servicesUS6473750Oct 15, 1999Oct 29, 2002Microsoft CorporationAdaptive query execution in a distributed database systemUS6477536Jun 22, 1999Nov 5, 2002Microsoft CorporationVirtual cubesUS6493718Oct 15, 1999Dec 10, 2002Microsoft CorporationAdaptive database caching and data retrieval mechanismUS6532458Mar 15, 1999Mar 11, 2003Microsoft CorporationSampling for database systemsUS6549907Apr 22, 1999Apr 15, 2003Microsoft CorporationMulti-dimensional database and data cube compression for aggregate query support on numeric dimensionsUS6604135 *Aug 6, 1999Aug 5, 2003International Business Machines CorporationWWW client server dynamic interactive system methodUS6631497Jul 19, 1999Oct 7, 2003International Business Machines CorporationBinding data from data source to cells in a spreadsheetUS6632249Jan 16, 2001Oct 14, 2003Microsoft CorporationMethod for providing web-based services to an application program moduleUS6684206May 18, 2001Jan 27, 2004Hewlett-Packard Development Company, L.P.OLAP-based web access analysis method and systemUS6701485Jun 15, 1999Mar 2, 2004Microsoft CorporationBinding spreadsheet cells to objectsUS6898603 *Oct 15, 1999May 24, 2005Microsoft CorporationMulti-dimensional data structure cachingUS6920443Sep 21, 1999Jul 19, 2005International Business Machines, CorporationMethod, system, program, and data structure for transforming database tablesUS7032030Mar 10, 2000Apr 18, 2006John David CodignottoMessage publishing system and methodUS7240052 *Sep 3, 2004Jul 3, 2007Iac Search & Media, Inc.Refinement of a search query based on information stored on a local storage mediumUS7299223 *Jul 15, 2004Nov 20, 2007Oracle International CorporationSpreadsheet to SQL translationUS7460713Aug 16, 2007Dec 2, 2008Silverbrook Research Pty LtdSystem for recording and retrieving note taking on notebook formUS20020010743Feb 10, 2001Jan 24, 2002Ryan Mark H.Method and system for distributing and collecting spreadsheet informationUS20020013786Dec 15, 2000Jan 31, 2002Robert MachalekData mining and reportingUS20020059261Jan 16, 2001May 16, 2002Microsoft CorporationMethod for providing web-based services to an application program moduleUS20020095399May 4, 2001Jul 18, 2002Devine Robert L.S.System and methods providing automatic distributed data retrieval, analysis and reporting servicesUS20020169799 *Jan 11, 2002Nov 14, 2002Voshell Perlie E.Systems and methods providing dynamic spreadsheet functionalityUS20020188629Oct 10, 2001Dec 12, 2002Burfoot Daniel C.System, protocol, and methods for the creation of distributed spreadsheetsUS20030110191Jul 11, 2002Jun 12, 2003Robert HandsakerSystem and method for efficiently and flexibly utilizing spreadsheet informationUS20030149934 *May 11, 2001Aug 7, 2003Worden Robert PeelComputer program connecting the structure of a xml document to its underlying meaningUS20030195762Oct 15, 2002Oct 16, 2003David GleasonAutomated workflowUS20040060001Sep 22, 2003Mar 25, 2004Microsoft CorporationExtension of formulas and formatting in an electronic spreadsheetUS20040103365Nov 27, 2002May 27, 2004Alan CoxSystem, method, and computer program product for an integrated spreadsheet and databaseUS20040103366Nov 26, 2002May 27, 2004Microsoft CorporationUser defined spreadsheet functionsUS20040133567 *Nov 6, 2003Jul 8, 2004Oracle International CorporationRun-time optimizations of queries with SQL spreadsheetUS20040133568 *Nov 6, 2003Jul 8, 2004Oracle International CorporationCompile-time optimizations of queries with SQL spreadsheetUS20040237029May 22, 2003Nov 25, 2004Medicke John A.Methods, systems and computer program products for incorporating spreadsheet formulas of multi-dimensional cube data into a multi-dimentional cubeUS20050039113 *Aug 12, 2003Feb 17, 2005International Business Machines CorporationMethod and apparatus for dataUS20050039114 *Jul 15, 2004Feb 17, 2005Oracle International CorporationSpreadsheet to SQL translationUS20060024653Jul 30, 2004Feb 2, 2006Microsoft CorporationMethod, system, and apparatus for exposing workbooks as data sourcesUS20060069603Sep 30, 2004Mar 30, 2006Microsoft CorporationTwo-dimensional radial user interface for computer software applicationsUS20060069617Nov 10, 2004Mar 30, 2006Scott MilenerMethod and apparatus for prefetching electronic data for enhanced browsingUS20060112123 *Sep 8, 2005May 25, 2006Macnica, Inc.Spreadsheet user-interfaced business data visualization and publishing systemUS20090235154Jul 30, 2004Sep 17, 2009Microsoft CorporationMethod, system, and apparatus for providing access to workbook models through remote function callsEP0997834A2Oct 20, 1999May 3, 2000Hyperion Solutions CorporationMethod and apparatus for accessing multidimensional dataEP1605367A2May 31, 2005Dec 14, 2005Microsoft CorporationMethod,system, and apparatus for making available workbook ranges as data sources* Cited by examinerNon-Patent CitationsReference1 *4tops.com, "Excel Import Assistant for Microsoft Access" Apr. 2003, www.4tops.com.2Andrew Witkowski et al., "Spreadsheets in RDBMS for OLAP," 06.2003, ACM SIGMOD, pp. 52-63.3Chinese First Office Action dated Feb. 13, 2009 cited in Application No. 200510082407.4 (0337cc01) pp. 1-11.4Chinese First Office Action dated Mar. 14, 2008 cited in Application No. 200510082420.X; 17 pgs.5Chinese Fourth Office Action dated Jul. 10, 2009 cited in Application No. 200510082420.X (0336cc01), pp. 1-7.6Chinese Second Office Action dated Nov. 21, 2008 cited in Application No. 200510082420.X; 7 pgs.7Chinese Third Office Action dated Mar. 13, 2009 cited in Application No. 200510082420.X (0336cc01), pp. 1-7.8De Paoli et al., "Requirements for a Layered Software Architecture Supporting Cooperative Multi-Layer Interaction," Software Engineering, 1996, Proceedings of the 18th International Conference, pp. 408-417.9Erik Hatcher, "Remote scripting using a servlet," Jan. 2, 2001, http://www.ibm.com/developerworks/web/library/wa-resc/, 7 pgs. (0337ep01).10European Examination Report mailed Apr. 1, 2009 in 07717837.4-1527/1977339.11European Examination Report mailed Mar. 25, 2009 in 07717882.0-1527/1977340.12European Official Communication dated Nov. 26, 2007 cited in EP Application No. 05 104 620.9-1243.13European Official Communication dated Nov. 5, 2007 cited in EP Application No. 05 104 620.9-1243; (60001.0337EP01); 5 pgs.14European Search Report dated Jun. 30, 2006 cited in Application No. 05104477.4-2201.15European Search Report mailed Aug. 6, 2007 cited in EP Application No. 0510620.9-1243; (60001.0337EP01); 3 pgs.16ExcelTip.com, "Export data from Excel to Access (DAO) using VBA in Microsoft Excel," 05.2003, pp. 1-2.17Lakshmanan et al., "On Querying Spreadsheets," Data Engineering, 1998, Proceedings, 14th International Conference, pp. 134-141.18Mexican Office Action dated Jan. 22, 2009 cited in Application No. PA/a/2005/005799 (0337mx01), pp. 1-4.19U.S. Appl. No. 10/903,568, filed Jul. 30, 2004 entitled "Method, System, and Apparatus for Exposing Workbooks as Data Sources".20U.S. Appl. No. 10/903,781, filed Jul. 30, 2004 entitled, "Method, System, and Apparatus for Providing Access to Workboook Models Through Remote Function Calls"; (60001.0337US01); 30 pgs.21U.S. Final Office Action dated Aug. 4, 2009 cited in U.S. Appl. No. 10/903,781, pp. 1-20.22U.S. Final Office Action dated Jun. 6, 2008 cited in U.S. Appl. No. 10/903,568; (60001.0336US01); 25 pgs.23U.S. Final Office Action dated May 12, 2008 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 14 pgs.24U.S. Final Office Action dated May 4, 2007 cited in U.S. Appl. No. 10/903,568.25U.S. Office Action dated Dec. 19, 2007 cited in U.S. Appl. No. 10/903,568.26U.S. Office Action dated Dec. 19, 2008 cited in U.S. Appl. No. 10/903,568; (60001.0336US01); 29 pgs.27U.S. Office Action dated Nov. 2, 2006 cited in U.S. Appl. No. 10/903,568.28U.S. Office Action dated Nov. 26, 2008 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 16 pgs.29U.S. Office Action dated Oct. 31, 2007 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 13 pgs.30U.S. Office Action mailed May 20, 2009, in U.S. Appl. No. 11/599,598.* Cited by examinerReferenced byCiting PatentFiling datePublication dateApplicantTitleUS7991804Jul 30, 2004Aug 2, 2011Microsoft CorporationMethod, system, and apparatus for exposing workbooks as data sourcesUS8050784 *Nov 15, 2006Nov 1, 2011Rockwell Automation Technologies, Inc.Integrated programmer reference for industrial control device dataUS8121975 *Feb 20, 2008Feb 21, 2012Panorama Software Inc.Creating pivot tables from tabular dataUS8578399Jul 30, 2004Nov 5, 2013Microsoft CorporationMethod, system, and apparatus for providing access to workbook models through remote function cellsUS20110161796 *Dec 31, 2009Jun 30, 2011Edward Charles LaikinFormDB: a process to create a forms database in Excel without user programmingUS20110225579 *Mar 12, 2010Sep 15, 2011Nikhil KhandelwalConfigurable software deployment* Cited by examinerClassifications U.S. Classification707/804, 707/802, 707/705, 707/803, 707/758, 707/790, 707/600International ClassificationG06F17/24, G06F17/30, G06F17/00, G06F7/00, G06F, G09B19/00, G06F12/06Cooperative ClassificationG06F17/246, G06F17/30592European ClassificationG06F17/30S, G06F17/30S5V, G06F17/24SLegal EventsDateCodeEventDescriptionMar 18, 2013FPAYFee paymentYear of fee payment: 4Jun 1, 2004ASAssignmentOwner name: MICROSOFT CORPORATION, WASHINGTONFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:NETZ, AMIR;PETCULESCU, CRISTIAN;BATTAGIN, DANIEL C.;AND OTHERS;REEL/FRAME:015432/0768;SIGNING DATES FROM 20040525 TO 20040528Owner name: MICROSOFT CORPORATION,WASHINGTONFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:NETZ, AMIR;PETCULESCU, CRISTIAN;BATTAGIN, DANIEL C. AND OTHERS;SIGNED BETWEEN 20040525 AND 20040528;US-ASSIGNMENT DATABASE UPDATED:20100216;REEL/FRAME:15432/768Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:NETZ, AMIR;PETCULESCU, CRISTIAN;BATTAGIN, DANIEL C.;AND OTHERS;SIGNING DATES FROM 20040525 TO 20040528;REEL/FRAME:015432/0768RotateOriginal ImageGoogle Home - Sitemap - USPTO Bulk Downloads - Privacy Policy - Terms of Service - About Google Patents - Send FeedbackData provided by IFI CLAIMS Patent Services