Source: http://www.google.com/patents/US7873649?dq=U.S.+patent+number+7,325,728
Timestamp: 2014-11-29 02:46:14
Document Index: 680397323

Matched Legal Cases: ['Application No. 2001290693', 'Application No. 2001290693', 'application No. 2007229358', 'application No. 2007229359', 'application No. 2001290693', 'Application No. 05', 'application No. 2007229358', 'application No. 2007229359', 'Application No. 05', 'art 1', 'art 2', 'art 1', 'art 2']

Patent US7873649 - Method and mechanism for identifying transaction on a row of data - Google PatentsSearch Images Maps Play YouTube News Gmail Drive More »Sign inAdvanced Patent SearchPatentsTechniques are provided for using XML syntax in exchanging data in relational databases. According to certain embodiments of the invention, one or more portions of the relational database is visualized as an XML document. A standard Uniform Resource Locator (URL) mechanism is provided to access data...http://www.google.com/patents/US7873649?utm_source=gb-gplus-sharePatent US7873649 - Method and mechanism for identifying transaction on a row of dataAdvanced Patent SearchPublication numberUS7873649 B2Publication typeGrantApplication numberUS 09/949,020Publication dateJan 18, 2011Filing dateSep 6, 2001Priority dateSep 7, 2000Fee statusPaidAlso published asUS20020078094Publication number09949020, 949020, US 7873649 B2, US 7873649B2, US-B2-7873649, US7873649 B2, US7873649B2InventorsMuralidhar Krishnaprasad, Viswanathan Krishnamurthy, Ravi MurthyOriginal AssigneeOracle International CorporationExport CitationBiBTeX, EndNote, RefManPatent Citations (92), Non-Patent Citations (73), Classifications (11), Legal Events (4) External Links: USPTO, USPTO Assignment, EspacenetMethod and mechanism for identifying transaction on a row of dataUS 7873649 B2Abstract Techniques are provided for using XML syntax in exchanging data in relational databases. According to certain embodiments of the invention, one or more portions of the relational database is visualized as an XML document. A standard Uniform Resource Locator (URL) mechanism is provided to access data stored in the relational database by defining the URL as an XPath expression over the visualized XML document.
RELATED APPLICATIONS Priority Claim This application is related to and claims domestic priority under 35 U.S.C. �119(e) from prior U.S. Provisional Patent Application Ser. No. 60/230,878 filed on Sep. 7, 2000 entitled �XML DATA STORAGE, QUERY REWRITES, VISUALIZATION, MAPPING AND REFERENCING�, by inventors Muralidhar Krishnaprasad, Vishwanathan Krishnamurthy, and Ravi Murthy, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
This application is related to U.S. patent application Ser. No. 09/948,949, which was filed on Sep. 6, 2001 and issued as U.S. Pat. No. 6,871,204 on Mar. 22, 2005, and which is entitled �APPARATUS AND METHOD FOR MAPPING RELATIONAL DATA AND METADATA TO XML,� naming as inventors Muralidhar Krishnaprasad, Vishwanathan Krishnamurthy, Ravi Murthy and Visar Nimani, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein; and
This application is related to U.S. patent application Ser. No. 09/948,998, which was filed on Sep. 6, 2001 and issued as U.S. Pat. No. 7,024,425 on Apr. 4, 2006, and which is entitled �METHOD AND APPARATUS FOR FLEXIBLE STORAGE AND UNIFORM MANIPULATION OF XML DATA IN A RELATIONAL DATABASE SYSTEM�, naming as inventors Muralidhar Krishnaprasad, Vishwanathan Krishnamurthy, and Ravi Murthy, the entire disclosure of which is hereby incorporated by reference as if fully set forth herein.
FIELD OF THE INVENTION The present invention relates generally to relational databases and, more specifically, to XML visualization of a database and DBURI references to database objects.
BACKGROUND OF THE INVENTION On the World Wide Web, there is a need to reference data from different sources inside documents. The standard way of referencing such data is through the use of URIs�or universal resource identifiers. Since a vast majority of the data lies inside relational databases, it is necessary to support a standard URI based access methods to such data. Typically, such applications are written using standard mechanisms like Servlets, which in-turn may execute SQL statements to retrieve and format the database data. Significant processing is often needed to convert the results of the SQL data into a standard format required by the user, such as extensible Markup Language (XML). XML is a World Wide Web Consortium (W3C) standard for representing data.
SUMMARY OF THE INVENTION Techniques are provided for allowing a user to view and retrieve data from a relational database in XML format.
(1) the user to access this data through the World Wide Web by providing URI references to such data, and (2) to store and perform operations on these URI references inside the database. Techniques are also provided for using XML syntax in exchanging data with relational databases. According to certain embodiments of the invention, an access mechanism is provided that allows one or more portions of the relational database to be accessed as if it were an XML document. Users may navigate through those �visualized� portions of the database using XPath expressions. Techniques are also provided to modify the �visualized� portions of the database and these modifications are converted to relational database operations such as SQL DMLs and DDLs.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT Techniques are provided for using XML syntax for accessing data in relational databases. In the following description, for the purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to avoid unnecessarily obscuring the present invention.
Functional Overview Using the techniques described herein, any particular user of the relational database, herein referred to as the �current user�, can visualize as an XML tree all the tables and views and the associated schema, in the relational database, to which the current user has been granted access privileges. In other words, the user, instead of seeing the database data in the form of tables and views, the data is presented to the user in the form of an XML document, and the typical structure of an XML document is a tree.
There may be several concurrent current users of the database. However, for the purpose of simplifying the description, the techniques described herein refer to a single current user. The XML tree is hereafter referred to as a �visualized XML document�. The visualized XML document comprises XML representations of the tables and views and the associated schema. Because the XML document is based on the access rights of a user, the XML document will vary from user to user based on each user's access rights. Thus, the visualized XML document, as described herein, is associated with the current user.
The data items that are identified by a URL or URI, and that are to be accessed in a relational database, are referred to herein as �target data�. Target data may vary from implementation to implementation. Target data may be any one of numerous types of data, such as relational database schema objects, relational data, control files, etc. The present invention is not limited to target data of any particular type.
The combination of (1) XML visualization of the relational database, and (2) the mechanism for navigating through the visualized XML document using XPath expressions, allows the user to �point to� any data in the relational database. For example, an XPath expression such as, /SCOTT/EMP/ROW[EMPNO=2100] points to the data value in the row identified by EMPNO=21. The row in question is in a relational database table called EMP, which is a schema object of the relational database schema called Scott.
According to certain embodiments, the current user can see all the data in the relational database, to which the user has been granted access privileges, as a visualized XML document. The visualized XML document includes a �database tag� and a set of schemas with tables and views. For example, if the database is called �oradb� then the XML document starts with the database tag �<oradb>� and ends with the database tag �</oradb>�.
http://machine-name/servlet-name/SCOTT/EMP/ROW[EMPNO=2100]/ENAME In the above URL, the database tag, �oradb�, is implicitly bound, and thus the user need not specify the database tag in the URL.
The current user can augment the URL or URI with content types to specify the Multipurpose Internet Mail Extensions (MIME) type of the output. For example, if the URL points to a BLOB (Binary Large OBject) column that is storing an image, wherein the image is the �target data�, then the content type can be set to gif. Thus, in response to using the URL, the current user obtains the image rather than, for example, a large hexadecimal file.
�text( )� is an XPath standard to identify the text node. The use of text( ) in the above URL would produce a result that contains only the text value in the employee-name column of EMP table at the row for which the employee number is 2100. The text value in the employee-name column of EMP table at the row for which the employee number is 2100 is �John�. Thus, the result of accessing the above URL using text( ) is �John�. In contrast, when text( ) is not used in the URL to access the employee-name column in the example, �John� is inlined inside a fragment of the visualized XML document as follows:
1) There is a pseudo top-level enclosing tag that identifies the relational database that contains the target data. An example of a pair of enclosing tags that identify the relational database that contains the target data is <oradb> . . . </oradb>, where �oradb� is the name of the relational database that contains the target data, as shown below (not all the elements in the visualization are shown): <oradb>
2) Each schema in the relational database for which the current user has been granted access privileges corresponds to one element in the visualized XML document. The name of the element is the same as the name of the schema to which the element corresponds. In the example illustrated herein, the schema SCOTT in the relational database �oradb� is represented by the element with the same name in the visualized XML document. Similarly, the schema JONES is represented by the element with the same name in the visualized XML document. The following visualized XML document is a visualization of the relational database down to the schema element level. For the purpose of illustration, only the elements corresponding to schemas SCOTT and JONES are shown.
3) Each table or view in the relational database for which the current user has been granted access privileges corresponds to one element in the visualized XML document. The name of the element is the same as the name of the table or view to which the element corresponds. In the example illustrated herein, the table EMP in the relational database �oradb� is represented by the element with the same name in the visualized XML document. Similarly, the table DEPT is represented by the element with the same name in the visualized XML document. The following visualized XML document is a visualization of the relational database down to the table element level. For the purpose of illustration, only the elements corresponding to tables EMP and DEPT are shown.
... <!�multiple ROW tag pairs - each pair
.... <!�other rows..>
... <!�other rows..>
According to one embodiment of the invention, the Xpath query over the XML visualization may be translated into relational database queries and the result formatted in XML. Techniques are provided for converting XPath expressions into relational database queries. For the purpose of explanation, assume that the XPath expression that is to be converted into a query is in the context of the relational database �oradb�. Thus, the format of a typical XPath expression is the context of �oradb� can be generalized as follows:
According to certain embodiments, a special data type is provided in the relational database for storing URIs and URLs in the relational database. Such a data type is herein referred to as an �Uritype�. URIs and URLs can be stored in columns in relational database tables by defining the URIs and URLs as Uritype data.
Further assume that the current user, Scott, would like to update data at the employee-name column of EMP table at the row for which the employee number is 2100. The update comprises changing the name �John� to �Mary�.
UPDATE �SCOTT�.�EMP�
SET �ENAME� = �Mary�
Where �EMPNO� = 2100;
If the current user, Scott, is using a web browser to access target data in the relational database, then according to certain embodiments, a general purpose servlet may be provided to allow the current user to modify, add or delete XML data that is stored in the relational database using the standard URIs and URLs. Using the above example of updating the name �John� to �Mary�, a general purpose servlet is provided that allows Scott to perform the following: 1) select the update operation for updating XML data and 2) post to the servlet the �update� information in the form of the following XPath expressions:
According to certain other embodiments, a special servlet may be provided for each database operation. In other words, there may be an �Insert-servlet� for the INSERT operation, a �Delete-servlet� for the DELETE operation, and an �Update-servlet� for the UPDATE operation.
Using the above example of updating the name �John� to �Mary�, an �Insert_servlet� is provided that allows Scott to perform the following: 1) select the update operation for updating XML data and 2) post to the servlet the �update� information in the form of the following XPath expressions:
http://machine-name/<delete-servlet>/SCOTT Hardware FIG. 3 is a block diagram that illustrates a computer system 300 upon which an embodiment of the invention may be implemented. Computer system 300 includes a bus 302 or other communication mechanism for communicating information, and a processor 304 coupled with bus 302 for processing information. Computer system 300 also includes a main memory 306, such as a random access memory (RAM) or other dynamic storage device, coupled to bus 302 for storing information and instructions to be executed by processor 304. Main memory 306 also may be used for storing temporary variables or other intermediate information during execution of instructions to be executed by processor 304. Computer system 300 further includes a read only memory (ROM) 308 or other static storage device coupled to bus 302 for storing static information and instructions for processor 304. A storage device 301, such as a magnetic disk or optical disk, is provided and coupled to bus 302 for storing information and instructions.
Patent CitationsCited PatentFiling datePublication dateApplicantTitleUS5999941Nov 25, 1997Dec 7, 1999Micron Electronics, Inc.Database access using active server pagesUS6012067 *Mar 2, 1998Jan 4, 2000Sarkar; Shyam SundarMethod and apparatus for storing and manipulating objects in a plurality of relational data managers on the webUS6240407Dec 17, 1998May 29, 2001International Business Machines Corp.Method and apparatus for creating an index in a database systemUS6253195Oct 20, 1998Jun 26, 2001Microsoft CorporationOptimized query treeUS6269380Aug 31, 1998Jul 31, 2001Xerox CorporationProperty based mechanism for flexibility supporting front-end and back-end components having different communication protocolsUS6279006Oct 14, 1998Aug 21, 2001Fujitsu LimitedStructured data management system and computer-readable recording medium storing structured data management programUS6282537Apr 6, 1999Aug 28, 2001Massachusetts Institute Of TechnologyQuery and retrieving semi-structured data from heterogeneous sources by translating structured queriesUS6366934Jun 2, 1999Apr 2, 2002International Business Machines CorporationMethod and apparatus for querying structured documents using a database extenderUS6418448Dec 6, 1999Jul 9, 2002Shyam Sundar SarkarMethod and apparatus for processing markup language specifications for data and metadata used inside multiple related internet documents to navigate, query and manipulate information from a plurality of object relational databases over the webUS6438540Jun 19, 2001Aug 20, 2002Vignette CorporationAutomatic query and transformative processUS6449620Mar 2, 2000Sep 10, 2002Nimble Technology, Inc.Method and apparatus for generating information pages using semi-structured data stored in a structured mannerUS6510434 *Dec 29, 1999Jan 21, 2003Bellsouth Intellectual Property CorporationSystem and method for retrieving information from a database using an index of XML tags and metafilesUS6516327Sep 24, 1999Feb 4, 2003International Business Machines CorporationSystem and method for synchronizing data in multiple databasesUS6574655 *Jun 29, 1999Jun 3, 2003Thomson Licensing SaAssociative management of multimedia assets and associated resources using multi-domain agent-based communication between heterogeneous peersUS6584459Jun 2, 1999Jun 24, 2003International Business Machines CorporationDatabase extender for storing, querying, and retrieving structured documentsUS6591295 *Nov 5, 1999Jul 8, 2003Oracle International Corp.Methods and apparatus for using multimedia data stored in a relational database in web applicationsUS6604100Feb 8, 2001Aug 5, 2003At&T Corp.Method for converting relational data into a structured documentUS6636845Jan 31, 2002Oct 21, 2003International Business Machines CorporationGenerating one or more XML documents from a single SQL queryUS6643633 *Jan 31, 2002Nov 4, 2003International Business Machines CorporationStoring fragmented XML data into a relational database by decomposing XML documents with application specific mappingsUS6684204 *Jun 19, 2000Jan 27, 2004International Business Machines CorporationMethod for conducting a search on a network which includes documents having a plurality of tagsUS6721727Nov 29, 2000Apr 13, 2004International Business Machines CorporationXML documents stored as column dataUS6766330 *Oct 12, 2000Jul 20, 2004International Business Machines CorporationUniversal output constructor for XML queries universal output constructor for XML queriesUS6772413 *Dec 8, 2000Aug 3, 2004Datapower Technology, Inc.Method and apparatus of data exchange using runtime code generator and translatorUS6785673Dec 28, 2001Aug 31, 2004At&T Corp.Method for converting relational data into XMLUS6810429 *Feb 3, 2000Oct 26, 2004Mitsubishi Electric Research Laboratories, Inc.Enterprise integration systemUS6871204 *Sep 6, 2001Mar 22, 2005Oracle International CorporationApparatus and method for mapping relational data and metadata to XMLUS6918082 *Dec 17, 1998Jul 12, 2005Jeffrey M. GrossElectronic document proofing systemUS6947945 *Mar 21, 2000Sep 20, 2005International Business Machines CorporationUsing an XML query language to publish relational data as XMLUS6976210 *Aug 29, 2000Dec 13, 2005Lucent Technologies Inc.Method and apparatus for web-site-independent personalization from multiple sites having user-determined extraction functionalityUS7028028May 17, 2001Apr 11, 2006Enosys Markets,Inc.System for querying markup language data stored in a relational database according to markup language schemaUS7031956Oct 9, 2001Apr 18, 2006Verizon Laboratories Inc.System and method for synchronizing and/or updating an existing relational database with supplemental XML dataUS7043716Jun 13, 2001May 9, 2006Arius Software CorporationSystem and method for multiple level architecture by use of abstract application notationUS7051071 *Feb 16, 2001May 23, 2006Bea Systems, Inc.Workflow integration system for enterprise wide electronic collaborationUS7062507Feb 24, 2003Jun 13, 2006The Boeing CompanyIndexing profile for efficient and scalable XML based publish and subscribe systemUS7072896 *Feb 14, 2001Jul 4, 2006Verizon Laboratories Inc.System and method for automatic loading of an XML document defined by a document-type definition into a relational database including the generation of a relational schema thereforUS7124137Dec 19, 2002Oct 17, 2006International Business Machines CorporationMethod, system, and program for optimizing processing of nested functionsUS7260585 *Jul 23, 2004Aug 21, 2007Oracle International CorporationApparatus and method for mapping relational data and metadata to XMLUS20010037345Mar 19, 2001Nov 1, 2001International Business Machines CorporationTagging XML query results over relational DBMSsUS20010047372 *Feb 12, 2001Nov 29, 2001Alexander GorelikNested relational data modelUS20020015042 *Nov 29, 2000Feb 7, 2002Robotham John S.Visual content browsing using rasterized representationsUS20020035606 *May 18, 2001Mar 21, 2002Kenton Stephen J.Method and system for straight through processingUS20020038358Aug 8, 2001Mar 28, 2002Sweatt Millard E.Method and system for remote television replay controlUS20020054090 *Aug 30, 2001May 9, 2002Silva Juliana FreireMethod and apparatus for creating and providing personalized access to web content and services from terminals having diverse capabilitiesUS20020073019Sep 22, 1997Jun 13, 2002David W. DeatonSystem, method, and database for processing transactionsUS20020078094 *Sep 6, 2001Jun 20, 2002Muralidhar KrishnaprasadMethod and apparatus for XML visualization of a relational database and universal resource identifiers to database data and metadataUS20020091725 *May 12, 1998Jul 11, 2002David SkokMethod and apparatus for providing client-based web page content creation and managementUS20020100027Jul 24, 2001Jul 25, 2002International Business Machines CorporationMethod of externalizing relational and ASN.1-formatted data into XML formatUS20020116371 *Dec 5, 2000Aug 22, 2002David DoddsSystem and method for the storage, indexing and retrieval of XML documents using relation databasesUS20020116457Feb 21, 2002Aug 22, 2002John EshlemanSystems and methods for managing distributed database resourcesUS20020120685 *Apr 10, 2002Aug 29, 2002Alok SrivastavaSystem for dynamically invoking remote network services using service descriptions stored in a service registryUS20020123993 *Nov 29, 2000Sep 5, 2002Chau Hoang K.XML document processingUS20020124100 *Apr 27, 2000Sep 5, 2002Jeffrey B AdamsMethod and apparatus for access to, and delivery of, multimedia informationUS20020133497 *Aug 1, 2001Sep 19, 2002Draper Denise L.Nested conditional relations (NCR) model and algebraUS20020156772Jan 31, 2002Oct 24, 2002International Business MachinesGenerating one or more XML documents from a single SQL queryUS20020169788 *Feb 14, 2001Nov 14, 2002Wang-Chien LeeSystem and method for automatic loading of an XML document defined by a document-type definition into a relational database including the generation of a relational schema thereforUS20020169842 *Apr 1, 2002Nov 14, 2002Centegy CorporationMethod and system for facilitating the integration of a plurality of dissimilar systemsUS20020184401Oct 22, 2001Dec 5, 2002Kadel Richard WilliamExtensible information systemUS20020198874Jul 26, 2002Dec 26, 2002Nasr Roger I.Automatic query and transformative processUS20030014397 *Jan 31, 2002Jan 16, 2003International Business Machines CorporationGenerating one or more XML documents from a relational database using XPath data modelUS20030028563Jun 26, 2001Feb 6, 2003William StutzMethods and apparatus for extendible information aggregation and presentationUS20030065659Sep 27, 2002Apr 3, 2003Oracle CorporationProviding a consistent hierarchical abstraction of relational dataUS20030126136 *Jun 24, 2002Jul 3, 2003Nosa OmoiguiSystem and method for knowledge retrieval, management, delivery and presentationUS20030140308Sep 27, 2002Jul 24, 2003Ravi MurthyMechanism for mapping XML schemas to object-relational database systemsUS20030158897 *Nov 30, 2000Aug 21, 2003Viryanet Ltd.Networked platform for creating and supporting communitiesUS20030200214Apr 14, 2003Oct 23, 2003Doole Douglas J.Detection and prevention of writing conflicts within nested query statementsUS20040006563Jun 26, 2002Jan 8, 2004Arthur ZwiegincewManipulating schematized data in a databaseUS20040015783Jun 20, 2003Jan 22, 2004Canon Kabushiki KaishaMethods for interactively defining transforms and for generating queries by manipulating existing query dataUS20040064466May 1, 2003Apr 1, 2004Oracle International CorporationTechniques for rewriting XML queries directed to relational database constructsUS20040143581Jan 15, 2003Jul 22, 2004Bohannon Philip L.Cost-based storage of extensible markup language (XML) dataUS20040148278Mar 28, 2003Jul 29, 2004Amir MiloSystem and method for providing content warehouseUS20040167904Feb 20, 2003Aug 26, 2004Ji-Rong WenSemi-structured data storage schema selectionUS20040193575Mar 25, 2003Sep 30, 2004Chia-Hsun ChenPath expressions and SQL select statement in object oriented languageUS20040199524Jul 17, 2003Oct 7, 2004Michael RysSystems and methods for transforming query results into hierarchical informationUS20040260691Jun 23, 2003Dec 23, 2004Desai Arpan A.Common query runtime system and application programming interfaceUS20040267719Jun 27, 2003Dec 30, 2004Microsoft CorporationSystem and method for managed database query pre-optimizationUS20040267760Jun 23, 2003Dec 30, 2004Brundage Michael L.Query intermediate language method and systemUS20050004892Jun 23, 2003Jan 6, 2005Brundage Michael L.Query optimizer system and methodUS20050022115May 28, 2002Jan 27, 2005Roberts BaumgartnerVisual and interactive wrapper generation, automated information extraction from web pages, and translation into xmlUS20050044078 *Sep 8, 2004Feb 24, 2005Overture Services, Inc.Technique for processing data in a networkUS20050097084Oct 31, 2003May 5, 2005Balmin Andrey L.XPath containment for index and materialized view matchingUS20050160076Jun 25, 2004Jul 21, 2005Fujitsu LimitedMethod and apparatus for referring to database integration, and computer productUS20050210002Mar 18, 2004Sep 22, 2005Microsoft CorporationSystem and method for compiling an extensible markup language based queryUS20050289125Sep 22, 2004Dec 29, 2005Oracle International CorporationEfficient evaluation of queries using translationUS20050289138Jun 25, 2004Dec 29, 2005Cheng Alex TAggregate indexing of structured and unstructured marked-up contentUS20060010124Dec 3, 2004Jan 12, 2006Bea Systems, Inc.Systems and methods for implementing a computer language type systemUS20060101320 *Dec 23, 2003May 11, 2006David DoddsSystem and method for the storage, indexing and retrieval of XML documents using relational databasesUS20060224576Apr 4, 2005Oct 5, 2006Oracle International CorporationEffectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL systemUS20070038780 *Sep 19, 2006Feb 15, 2007Irving RappaportMethod and system for facilitating the integration of a plurality of dissimilar systemsUS20070233645 *Mar 28, 2006Oct 4, 2007Trenten PetersonSystem and Method for Building an XQuery Using a Model-Based XQuery Building ToolUS20100070448 *Jan 22, 2009Mar 18, 2010Nosa OmoiguiSystem and method for knowledge retrieval, management, delivery and presentationWO2001033433A1 *Oct 31, 2000May 10, 2001Xcoders IncMethod and apparatus for establishing and using an xml databaseWO2001065419A2Mar 2, 2001Sep 7, 2001Nimble Technology IncMethod and apparatus for storing semi-structured data in a structured manner* Cited by examinerNon-Patent CitationsReference1"A Performance Evaluation of Storing XML Data in Relational Database Management Systems,"-Latifur Khan and Yan Rao-ACM-2001 (pp. 31-38).2"From XML Schema to Relations: A Cost-Based Approach to XML Storage"-Bell Laboratories: Philip Bohannon, Juliana Freire, Prasan Roy and Jerome Simeon-IEEE-2002-Proceedings of the 18th International Conference on Data Engineering (ICDE'02), 12 pages.3"Oracle 9i Project XDB"-The XML Database-Oracle-2001 (pp. 1-18).4"Oracle8i-The XML Enabled Data Mangement System"-Oracle Corporation: Sandeepan Banerjee, Vishu Krishnamurthy, Muralidhar Krishnaprasad and Ravi Murthy, paper published in IEEE Conference-ICDE 2000, pp. 561-568.5"SRQL: Sorted Relational Query Language"-Raghu Ramakrishnan, Donko Donjerkovic, Arvind Ranganathan, Kevin S. Beyer and Muralidhar Krishnaprasad-Jul. 1-3, 1998 IEEE pp. 84-95.6 *[Feb. 9, 2000] From Jonathan Robie: There is a paper �Projection and Transformation in XML Queries�.7 *[Feb. 9, 2000] From Jonathan Robie: There is a paper 'Projection and Transformation in XML Queries'.8"A Performance Evaluation of Storing XML Data in Relational Database Management Systems,"�Latifur Khan and Yan Rao�ACM-2001 (pp. 31-38).9"From XML Schema to Relations: A Cost-Based Approach to XML Storage"�Bell Laboratories: Philip Bohannon, Juliana Freire, Prasan Roy and Jerome Simeon�IEEE�2002�Proceedings of the 18th International Conference on Data Engineering (ICDE'02), 12 pages.10"Oracle 9i Project XDB"�The XML Database�Oracle�2001 (pp. 1-18).11"Oracle8i�The XML Enabled Data Mangement System"�Oracle Corporation: Sandeepan Banerjee, Vishu Krishnamurthy, Muralidhar Krishnaprasad and Ravi Murthy, paper published in IEEE Conference�ICDE 2000, pp. 561-568.12"SRQL: Sorted Relational Query Language"�Raghu Ramakrishnan, Donko Donjerkovic, Arvind Ranganathan, Kevin S. Beyer and Muralidhar Krishnaprasad�Jul. 1-3, 1998 IEEE pp. 84-95.13 *All Your Data: The Oracle Extensibility Architecture. Sandeepan Banerjee et al. Published 1999.14Amended Claims, App. No. 01 970 715.7, 13 pages.15Australian Application No. 2001290693-current claims, 17 pgs.16Australian Application No. 2001290693�current claims, 17 pgs.17Australian Government, "Examiner's first report on patent application No. 2007229358", 2 pages.18Australian Government, "Examiner's first report on patent application No. 2007229359", 2 pages.19Australian Office Action; Examiner's first report on patent application No. 2001290693, dated Jun. 27, 2006, 4 pgs.20Banerjee et al. "Oracle 8i-The XML Enabled Data Management System"-Data Engineering, IEEE/Mar. 2000 (pp. 561-568.21Banerjee et al. "Oracle 8i�The XML Enabled Data Management System"�Data Engineering, IEEE/Mar. 2000 (pp. 561-568.22 *Cheng, J.; Xu, J.XML and DB2. IBM Laboratory. Data Engineering 2000, Proceedings. 16th International Conference in May 2000.23Cheng, Josephine et al., "IBM DB2 XML Extender, An end-to-end solution for storing and retrieving XML documents," IEEE, ICDE '00 Conference, San Diego, Feb. 2000, 128 pages.24Choi, Byron et al., "The XQuey Formal Semantics: A Foundation for Implementation Optimization," May 31, 2002, IEEE XP-002353605, 15 pages.25 *Cindy Xinmin Chen and Ashok Malhotra. XML Queries via SQL. IBM Thomas Watson Research Center 1999.26Claims, Application No. 05 760 442.3-2201, 8 pages.27Claims, patent application No. 2007229358, 8 pages.28Claims, patent application No. 2007229359, 8 pages.29Claims, PCT/US2005/021259, dated Nov. 30, 2006, 8 pages (attached).30Current Claims Patent App. 2001290693, 7 pages.31Current Claims, PCT/US2005/021259, 15 pages.32Daniela Florescu et al., "A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in a Relational Database," May 1999, XP-002168318, pp. 1-31.33Daniele Braga et al., "A Graphical Environment to Query XML Data with Query," Proceedings of the Fourth International Conference on Web Information Systems Engineering (WISE '03), 2003, IEEE, 10 pages.34 *Data Engineering. IEEE Sep. 1999. vol. 22 No. 3. Bulletin. Special Issue on XML.35 *Enabling Your Business Data for XML with DB2 XML Extender. Jane Xu & Josephine Cheng. IBM. Xtech2000 (Pub. Feb. 29, 2000).36 *Ernesto Damiani et al. Design and implementation of an access control processor for XML documents. Computer Networks 33 (2000) pp. 59-75. Pub. Jun. 2000 by Elsevier B.V.37 *Ernesto Damiani et al. Securing XML Documents. LNCS 1777, pp. 121-135. Pub. Mar. 2000.38European Patent Office, "Communication Pursuant to Article 94(3) EPC", Application No. 05 760 442.3-2201, dated Jun. 20, 2008, 2 pages.39European Patent Office, "Communication Pursuant to Article 96(2) EPC," App. No. 01 970 715.7, sated Jul. 19, 2006, 8 pages.40Funderbunk, J. et al., "XML programming with SQL/XML and XQuery", IBM Systems Journal, XP-002295973 (2002), pp. 642-665.41Gennick, Jonathan, "SQL in, XML out", May/Jun. 2003, Oracle Magazine, 5 pages.42International Preliminary Examining Authority, "Notification of Transmittal of the International Preliminary Report on Patentability," PCT/US2005/021259, dated Feb. 2, 2007, 9 pages.43International Searching Authority, "Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration," PCT/US2005/021259, dated Nov. 24, 2005, 13 pages.44IP Australia, "Examiner's Report No. 2," Patent App. 2001290693, 2 pages.45 *Josephine Cheng and Jane Xu. IBM XML Extender. An end-to-end solution for storing and retrieving XML documents. IBM Silicon Valley. Copyright IEEE Feb. 2000.46Kang, Ji-Hoon et al., "An XQuery Engine for Digital Library Systems that support XML data," Proceedings of the 2004 International Symposium on Application and the Internet Workshops, IEEE , 5 pages.47Kang, Ji-Hoon et al., "An XQuery Engine for Digital Library Systems that support XML data," Proceedings of the 2004 International Symposium on Application and the Internet Workshops, IEEE XP-0010684128, 5 pages.48Lawrence et al. "Integrating Relational Database Schemas Using a Standarized Dictionary"-2001-ACM (pp. 225-230).49Lawrence et al. "Integrating Relational Database Schemas Using a Standarized Dictionary"�2001�ACM (pp. 225-230).50 *Managing XML documents in object-relational databases (1999) by Meike Klettke, Holger Meyer.51Melton, John, "ISO-ANSI Working Draft; XML-Related Specifications (SQL/XML)," WG3: DRS-020, H2-2002-365, Aug. 2002, 154 pages.52Murthy, Ravi et al., "XML Schemas in Oracle XML DB," Proceedings of the 29th VLDB Conference, 2003, IEEE XP-002353604, pp. 1009-1018.53Oracle Corporation, "Oracle9i XML Database Developer's Guide-Oracle XML DB," Release 2 (9.2), Mar. 2002, Part No. A96620-1, pp. 4-31-4-35, 5-21-5-24 and 5-70-5-71.54Oracle Corporation, "Oracle9i XML Database Developer's Guide�Oracle XML DB," Release 2 (9.2), Mar. 2002, Part No. A96620-1, pp. 4-31-4-35, 5-21-5-24 and 5-70-5-71.55R. Bourret et al.: A generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases, Jun. 8-9, 2000, IEEE computing SOC., pp. 134-143.56 *R. Bourret, C. Bornhovd, A. Buchmann. A generic load/extract utility for data transfer between XML documents and Relational Databases. IEEE Jun. 8-9, 2000.57Rys, Michael et al., "Integrating XQuery and Relational Database Systems," Chapter 7-XQuery from the Experts: A Guide to the W3C XML Query Language, Addison Wesley Professional, Aug. 22, 2003, ISBN 978-0-321-18060-5, pp. 353-391.58Rys, Michael et al., "Integrating XQuery and Relational Database Systems," Chapter 7�XQuery from the Experts: A Guide to the W3C XML Query Language, Addison Wesley Professional, Aug. 22, 2003, ISBN 978-0-321-18060-5, pp. 353-391.59Schmidt et al.-"Efficient Relational Storage and Retrieval of XML Documents"-CWI, The Netherlands (pp. 1-6).60Schmidt et al.�"Efficient Relational Storage and Retrieval of XML Documents"�CWI, The Netherlands (pp. 1-6).61Shanmugasundaram, Jayavel, et al., "Querying XML Views of Relational Data," Proceedings of the 27th Very Large Databases Conference, Rome, Italy, Sep. 2001, pp. 261-270.62 *SQL Server 2000 XML Enhancements. By Rich Rollman: Lead Program Manager XML technologies. Microsoft Corp. 5-324. PowerPoint Presentation at Microsoft TechEd 2000, Jun. 5-8, Orlando, Fla.63U.S. Appl. No. 10/956,300, filed Sep. 30, 2004, Office Action Mailing Date May 31, 2007.64U.S. Appl. No. 11/098,887, filed Apr. 4, 2005, Office Action Mailing Date Jul. 10, 2007.65W3C, "XML Schema Part 1: Structures," W3C Recommendation, May 2, 2001, , pp. 1-203.66W3C, "XML Schema Part 2: Datatypes," W3C Recommendation, May 2, 2001, , pp. 1-146.67W3C, "XML Schema Part 1: Structures," W3C Recommendation, May 2, 2001, <http://www.w3.org/TR/2001/REC-xmlschema-1-20010502/>, pp. 1-203.68W3C, "XML Schema Part 2: Datatypes," W3C Recommendation, May 2, 2001, <http://www.w3.org/TR/2001/REC-xmlschema-2-20010502/>, pp. 1-146.69 *XML and DB2. by Josephine Cheng and Jane Xu. IBM Santa Teresa Laboratory. Feb. 29-Mar. 3, 2000.70Zemke, Fred, "XMLQuery," Change Proposal, ISO/IEC JTC1/SC32 WG3:SIA-nnn ANSI NCITS H2-2004-02lrl, Mar. 14, 2004, 29 pages.71Zhang, Hui et al., "XQuery rewriting at the relational algebra level," Computer Systems Science and Engineering, vol. 18, No. 5, Sep. 2003, IEEE XP-009056809, pp. 241-262.72Zhang, Xin et al., "Honey, I Shrunk the XQuery!-An XML Algebra Optimization Approach," Submission for WIDM'02, IEEE XP-002316448, 14 pages.73Zhang, Xin et al., "Honey, I Shrunk the XQuery!�An XML Algebra Optimization Approach," Submission for WIDM'02, IEEE XP-002316448, 14 pages.* Cited by examinerClassifications U.S. Classification707/759, 707/722, 707/706, 707/781, 707/791, 707/713, 707/736International ClassificationG06F17/30, G06F7/00Cooperative ClassificationG06F17/30595European ClassificationG06F17/30S8RLegal EventsDateCodeEventDescriptionJun 18, 2014FPAYFee paymentYear of fee payment: 4Jul 10, 2012CCCertificate of correctionApr 21, 2003ASAssignmentOwner name: ORACLE INTERNATIONAL CORPORATION, CALIFORNIAFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:ORACLE CORPORATION;REEL/FRAME:013944/0938Effective date: 20030411Owner name: ORACLE INTERNATIONAL CORPORATION,CALIFORNIAFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:ORACLE CORPORATION;US-ASSIGNMENT DATABASE UPDATED:20100406;REEL/FRAME:13944/938Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:ORACLE CORPORATION;US-ASSIGNMENT DATABASE UPDATED:20100504;REEL/FRAME:13944/938Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:ORACLE CORPORATION;US-ASSIGNMENT DATABASE UPDATED:20100525;REEL/FRAME:13944/938Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:ORACLE CORPORATION;REEL/FRAME:13944/938Jan 11, 2002ASAssignmentOwner name: ORACLE CORPORATION, CALIFORNIAFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:KRISHNAPRASAD, MURALIDHAR;KRISHNAMURTHY, VISWANATHAN;MURTHY, RAVI;REEL/FRAME:012472/0198Effective date: 20011106RotateOriginal ImageGoogle Home - Sitemap - USPTO Bulk Downloads - Privacy Policy - Terms of Service - About Google Patents - Send FeedbackData provided by IFI CLAIMS Patent Services©2012 Google