Invention Grant
US09330149B2 Techniques for query and DML over relational tables using spreadsheet applications
有权
使用电子表格应用程序在关系表上查询和DML的技术
- Patent Title: Techniques for query and DML over relational tables using spreadsheet applications
- Patent Title (中): 使用电子表格应用程序在关系表上查询和DML的技术
-
Application No.: US11959398Application Date: 2007-12-18
-
Publication No.: US09330149B2Publication Date: 2016-05-03
- Inventor: Rohan Angrish , James W. Warner , Zhen Hua Liu
- Applicant: Rohan Angrish , James W. Warner , Zhen Hua Liu
- Applicant Address: US CA Redwood Shores
- Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee: ORACLE INTERNATIONAL CORPORATION
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Agent Marcel K. Bingham
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
In one embodiment, a database server receives a request from a spreadsheet application to open a file with spreadsheet data. The spreadsheet data is stored in one or more relational tables in one or more relational databases that are managed by the database server. In response to the request, the database server generates the file, where generating the file comprises retrieving the spreadsheet data from an XML view that is defined by an XQuery query. When executed, the XQuery query returns the spreadsheet data in an XML spreadsheet format that is understood by the spreadsheet application. The database server provides the generated file with the spreadsheet data directly to the spreadsheet application, where the spreadsheet data as retrieved from the XML view is formatted according to the XML spreadsheet format.
Public/Granted literature
- US20090158251A1 TECHNIQUES FOR QUERY AND DML OVER RELATIONAL TABLES USING SPREADSHEET APPLICATIONS Public/Granted day:2009-06-18
Information query