WO2004100021A3 - Retaining hierarchical information in mapping between xml documents and relational data - Google Patents

Retaining hierarchical information in mapping between xml documents and relational data Download PDF

Info

Publication number
WO2004100021A3
WO2004100021A3 PCT/US2004/010018 US2004010018W WO2004100021A3 WO 2004100021 A3 WO2004100021 A3 WO 2004100021A3 US 2004010018 W US2004010018 W US 2004010018W WO 2004100021 A3 WO2004100021 A3 WO 2004100021A3
Authority
WO
WIPO (PCT)
Prior art keywords
xml
instance
sql statement
mapping
ordered collection
Prior art date
Application number
PCT/US2004/010018
Other languages
French (fr)
Other versions
WO2004100021A2 (en
Inventor
Ravi Murthy
Muralidhar Krishnaprasad
Anand Manikutty
Zhen Liu
James Warner
Original Assignee
Oracle Int Corp
Ravi Murthy
Muralidhar Krishnaprasad
Anand Manikutty
Zhen Liu
James Warner
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Oracle Int Corp, Ravi Murthy, Muralidhar Krishnaprasad, Anand Manikutty, Zhen Liu, James Warner filed Critical Oracle Int Corp
Priority to EP04760516A priority Critical patent/EP1618502A2/en
Priority to AU2004237062A priority patent/AU2004237062B2/en
Priority to CA2522309A priority patent/CA2522309C/en
Priority to JP2006509577A priority patent/JP4516566B2/en
Publication of WO2004100021A2 publication Critical patent/WO2004100021A2/en
Publication of WO2004100021A3 publication Critical patent/WO2004100021A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84Mapping; Conversion
    • G06F16/86Mapping to a database
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99943Generating database or data structure, e.g. via user interface

Abstract

Techniques for managing XML data in an SQL compliant DBMS include receiving an SQL statement. The SQL statement includes a particular operator that operates on a first instance of XML type that represents a first set of XML elements. During execution of the SQL statement, the particular operator is evaluated by generating an ordered collection of instances of XML type. Each different instance in the ordered collection is based on a different XML element from the first set; and there is an instance in the ordered collection for every XML element from either the first set or from the first set and its descendents. When descendents are included, each entry in the ordered collection indicates a level in the XML tree. In another aspect, an aggregate operator in the SQL statement operates on a collection of instances, with associated levels, to generate a single instance of XML type.
PCT/US2004/010018 2003-05-01 2004-03-31 Retaining hierarchical information in mapping between xml documents and relational data WO2004100021A2 (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
EP04760516A EP1618502A2 (en) 2003-05-01 2004-03-31 Retaining hierarchical information in mapping between xml documents and relational data
AU2004237062A AU2004237062B2 (en) 2003-05-01 2004-03-31 Retaining hierarchical information in mapping between XML documents and relational data
CA2522309A CA2522309C (en) 2003-05-01 2004-03-31 Retaining hierarchical information in mapping between xml documents and relational data
JP2006509577A JP4516566B2 (en) 2003-05-01 2004-03-31 Retention of hierarchy information in mapping between XML document and relational data

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/428,443 US7103611B2 (en) 2003-05-01 2003-05-01 Techniques for retaining hierarchical information in mapping between XML documents and relational data
US10/428,443 2003-05-01

Publications (2)

Publication Number Publication Date
WO2004100021A2 WO2004100021A2 (en) 2004-11-18
WO2004100021A3 true WO2004100021A3 (en) 2004-12-29

Family

ID=33310404

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/010018 WO2004100021A2 (en) 2003-05-01 2004-03-31 Retaining hierarchical information in mapping between xml documents and relational data

Country Status (7)

Country Link
US (1) US7103611B2 (en)
EP (1) EP1618502A2 (en)
JP (1) JP4516566B2 (en)
CN (1) CN100545835C (en)
AU (1) AU2004237062B2 (en)
CA (1) CA2522309C (en)
WO (1) WO2004100021A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102760164B (en) * 2012-06-12 2016-01-20 北大方正集团有限公司 A kind of method of exchanges data between relational database management system and XML data base management system

Families Citing this family (128)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7293228B1 (en) * 1997-01-31 2007-11-06 Timebase Pty Limited Maltweb multi-axis viewing interface and higher level scoping
AUPO489297A0 (en) * 1997-01-31 1997-02-27 Aunty Abha's Electronic Publishing Pty Ltd A system for electronic publishing
US7624356B1 (en) 2000-06-21 2009-11-24 Microsoft Corporation Task-sensitive methods and systems for displaying command sets
US7000230B1 (en) 2000-06-21 2006-02-14 Microsoft Corporation Network-based software extensions
US7346848B1 (en) 2000-06-21 2008-03-18 Microsoft Corporation Single window navigation methods and systems
US6948135B1 (en) 2000-06-21 2005-09-20 Microsoft Corporation Method and systems of providing information to computer users
US7191394B1 (en) 2000-06-21 2007-03-13 Microsoft Corporation Authoring arbitrary XML documents using DHTML and XSLT
US6883168B1 (en) 2000-06-21 2005-04-19 Microsoft Corporation Methods, systems, architectures and data structures for delivering software via a network
US7155667B1 (en) 2000-06-21 2006-12-26 Microsoft Corporation User interface for integrated spreadsheets and word processing tables
US7031962B2 (en) * 2001-03-27 2006-04-18 Bea Systems, Inc. System and method for managing objects and resources with access rights embedded in nodes within a hierarchical tree structure
US20030041305A1 (en) * 2001-07-18 2003-02-27 Christoph Schnelle Resilient data links
US7363310B2 (en) 2001-09-04 2008-04-22 Timebase Pty Limited Mapping of data from XML to SQL
AU2002334721B2 (en) * 2001-09-28 2008-10-23 Oracle International Corporation An index structure to access hierarchical data in a relational database system
US7281206B2 (en) * 2001-11-16 2007-10-09 Timebase Pty Limited Maintenance of a markup language document in a database
US7120645B2 (en) * 2002-09-27 2006-10-10 Oracle International Corporation Techniques for rewriting XML queries directed to relational database constructs
US7415672B1 (en) 2003-03-24 2008-08-19 Microsoft Corporation System and method for designing electronic forms
US7370066B1 (en) 2003-03-24 2008-05-06 Microsoft Corporation System and method for offline editing of data files
US7913159B2 (en) 2003-03-28 2011-03-22 Microsoft Corporation System and method for real-time validation of structured data files
US7296017B2 (en) 2003-03-28 2007-11-13 Microsoft Corporation Validation of XML data files
US7386568B2 (en) * 2003-05-01 2008-06-10 Oracle International Corporation Techniques for partial rewrite of XPath queries in a relational database
US7103611B2 (en) 2003-05-01 2006-09-05 Oracle International Corporation Techniques for retaining hierarchical information in mapping between XML documents and relational data
JP4240293B2 (en) * 2003-05-27 2009-03-18 株式会社ソニー・コンピュータエンタテインメント Multimedia playback apparatus and multimedia playback method
US7451392B1 (en) 2003-06-30 2008-11-11 Microsoft Corporation Rendering an HTML electronic form by applying XSLT to XML using a solution
US7406660B1 (en) 2003-08-01 2008-07-29 Microsoft Corporation Mapping between structured data and a visual surface
US7334187B1 (en) * 2003-08-06 2008-02-19 Microsoft Corporation Electronic form aggregation
US7490093B2 (en) 2003-08-25 2009-02-10 Oracle International Corporation Generating a schema-specific load structure to load data into a relational database based on determining whether the schema-specific load structure already exists
US8694510B2 (en) 2003-09-04 2014-04-08 Oracle International Corporation Indexing XML documents efficiently
US8229932B2 (en) 2003-09-04 2012-07-24 Oracle International Corporation Storing XML documents efficiently in an RDBMS
US20050091231A1 (en) * 2003-10-24 2005-04-28 Shankar Pal System and method for storing and retrieving XML data encapsulated as an object in a database store
US8819072B1 (en) 2004-02-02 2014-08-26 Microsoft Corporation Promoting data from structured data files
CN1560763B (en) * 2004-02-19 2010-05-05 北京大学 Method for translating expandable mark language path inquiry into structure inquiry
US7761461B2 (en) * 2004-04-08 2010-07-20 International Business Machines Corporation Method and system for relationship building from XML
US7930277B2 (en) 2004-04-21 2011-04-19 Oracle International Corporation Cost-based optimizer for an XML data repository within a database
US7496837B1 (en) 2004-04-29 2009-02-24 Microsoft Corporation Structural editing with schema awareness
US7281018B1 (en) 2004-05-26 2007-10-09 Microsoft Corporation Form template data source change
US7774620B1 (en) 2004-05-27 2010-08-10 Microsoft Corporation Executing applications at appropriate trust levels
US8055672B2 (en) * 2004-06-10 2011-11-08 International Business Machines Corporation Dynamic graphical database query and data mining interface
US7516121B2 (en) * 2004-06-23 2009-04-07 Oracle International Corporation Efficient evaluation of queries using translation
WO2006009768A1 (en) 2004-06-23 2006-01-26 Oracle International Corporation Efficient evaluation of queries using translation
US7668806B2 (en) 2004-08-05 2010-02-23 Oracle International Corporation Processing queries against one or more markup language sources
US7685137B2 (en) * 2004-08-06 2010-03-23 Oracle International Corporation Technique of using XMLType tree as the type infrastructure for XML
US7692636B2 (en) 2004-09-30 2010-04-06 Microsoft Corporation Systems and methods for handwriting to a screen
US7712022B2 (en) 2004-11-15 2010-05-04 Microsoft Corporation Mutually exclusive options in electronic forms
US7721190B2 (en) 2004-11-16 2010-05-18 Microsoft Corporation Methods and systems for server side form processing
US8458467B2 (en) 2005-06-21 2013-06-04 Cisco Technology, Inc. Method and apparatus for adaptive application message payload content transformation in a network infrastructure element
US7664879B2 (en) 2004-11-23 2010-02-16 Cisco Technology, Inc. Caching content and state data at a network element
US7987272B2 (en) 2004-12-06 2011-07-26 Cisco Technology, Inc. Performing message payload processing functions in a network element on behalf of an application
US8082304B2 (en) 2004-12-10 2011-12-20 Cisco Technology, Inc. Guaranteed delivery of application layer messages by a network element
US7904801B2 (en) 2004-12-15 2011-03-08 Microsoft Corporation Recursive sections in electronic forms
US20060136483A1 (en) * 2004-12-22 2006-06-22 International Business Machines Corporation System and method of decomposition of multiple items into the same table-column pair
US7937651B2 (en) 2005-01-14 2011-05-03 Microsoft Corporation Structural editing operations for network forms
US7725834B2 (en) 2005-03-04 2010-05-25 Microsoft Corporation Designer-created aspect for an electronic form template
US7305414B2 (en) 2005-04-05 2007-12-04 Oracle International Corporation Techniques for efficient integration of text searching with queries over XML data
US8010515B2 (en) 2005-04-15 2011-08-30 Microsoft Corporation Query to an electronic form
US20060235839A1 (en) * 2005-04-19 2006-10-19 Muralidhar Krishnaprasad Using XML as a common parser architecture to separate parser from compiler
US7685150B2 (en) * 2005-04-19 2010-03-23 Oracle International Corporation Optimization of queries over XML views that are based on union all operators
US7949941B2 (en) 2005-04-22 2011-05-24 Oracle International Corporation Optimizing XSLT based on input XML document structure description and translating XSLT into equivalent XQuery expressions
US8200975B2 (en) 2005-06-29 2012-06-12 Microsoft Corporation Digital signatures for network forms
US8166059B2 (en) 2005-07-08 2012-04-24 Oracle International Corporation Optimization of queries on a repository based on constraints on how the data is stored in the repository
US7406478B2 (en) * 2005-08-11 2008-07-29 Oracle International Corporation Flexible handling of datetime XML datatype in a database system
US8554789B2 (en) * 2005-10-07 2013-10-08 Oracle International Corporation Managing cyclic constructs of XML schema in a rdbms
US9367642B2 (en) 2005-10-07 2016-06-14 Oracle International Corporation Flexible storage of XML collections within an object-relational database
US8024368B2 (en) * 2005-10-07 2011-09-20 Oracle International Corporation Generating XML instances from flat files
US8073841B2 (en) 2005-10-07 2011-12-06 Oracle International Corporation Optimizing correlated XML extracts
US8001459B2 (en) 2005-12-05 2011-08-16 Microsoft Corporation Enabling electronic documents for limited-capability computing devices
US20070156868A1 (en) * 2005-12-29 2007-07-05 Ido Keren Efficient dynamic discovery of web services
US7529758B2 (en) * 2006-02-10 2009-05-05 International Business Machines Corporation Method for pre-processing mapping information for efficient decomposition of XML documents
US7681135B2 (en) * 2006-08-10 2010-03-16 Kabushiki Kaisha Toshiba System and method for generating a composite source user interface
US7797310B2 (en) 2006-10-16 2010-09-14 Oracle International Corporation Technique to estimate the cost of streaming evaluation of XPaths
US7747610B2 (en) * 2006-11-10 2010-06-29 Sybase, Inc. Database system and methodology for processing path based queries
US20080120283A1 (en) * 2006-11-17 2008-05-22 Oracle International Corporation Processing XML data stream(s) using continuous queries in a data stream management system
US7743076B2 (en) * 2007-01-26 2010-06-22 Microsoft Corporation Extensible action sequences coordinating independently created components
DE602007002474D1 (en) * 2007-04-27 2009-10-29 Software Ag Method and database system for performing an XML database query
US7836098B2 (en) 2007-07-13 2010-11-16 Oracle International Corporation Accelerating value-based lookup of XML document in XQuery
US7979420B2 (en) 2007-10-16 2011-07-12 Oracle International Corporation Handling silent relations in a data stream management system
US7996388B2 (en) * 2007-10-17 2011-08-09 Oracle International Corporation Adding new continuous queries to a data stream management system operating on existing queries
US8296316B2 (en) * 2007-10-17 2012-10-23 Oracle International Corporation Dynamically sharing a subtree of operators in a data stream management system operating on existing queries
US8073826B2 (en) 2007-10-18 2011-12-06 Oracle International Corporation Support for user defined functions in a data stream management system
US8521867B2 (en) * 2007-10-20 2013-08-27 Oracle International Corporation Support for incrementally processing user defined aggregations in a data stream management system
US7991766B2 (en) 2007-10-20 2011-08-02 Oracle International Corporation Support for user defined aggregations in a data stream management system
CN101436185B (en) * 2007-11-12 2012-02-01 北大方正集团有限公司 Method for implementing multiple-file compatibility by XML memory tree
US7788305B2 (en) * 2007-11-13 2010-08-31 Oracle International Corporation Hierarchy nodes derived based on parent/child foreign key and/or range values on parent node
CN101470727B (en) * 2007-12-24 2012-07-04 新奥特(北京)视频技术有限公司 Method and system for editing and processing tree-form data
CN101546259B (en) * 2008-03-28 2012-10-03 国际商业机器公司 Object-relation mapping system supporting model extension in runtime, and method thereof
US20090248716A1 (en) * 2008-03-31 2009-10-01 Caterpillar Inc. Hierarchy creation and management tool
US7814054B2 (en) * 2008-04-03 2010-10-12 Laurion James E System and method for providing common operators across multiple applications
US7958112B2 (en) 2008-08-08 2011-06-07 Oracle International Corporation Interleaving query transformations for XML indexes
US8589436B2 (en) 2008-08-29 2013-11-19 Oracle International Corporation Techniques for performing regular expression-based pattern matching in data streams
US8145859B2 (en) 2009-03-02 2012-03-27 Oracle International Corporation Method and system for spilling from a queue to a persistent store
US8352517B2 (en) 2009-03-02 2013-01-08 Oracle International Corporation Infrastructure for spilling pages to a persistent store
US8140558B2 (en) * 2009-05-22 2012-03-20 International Business Machines Corporation Generating structured query language/extensible markup language (SQL/XML) statements
US8387076B2 (en) 2009-07-21 2013-02-26 Oracle International Corporation Standardized database connectivity support for an event processing server
US8321450B2 (en) 2009-07-21 2012-11-27 Oracle International Corporation Standardized database connectivity support for an event processing server in an embedded context
US8527458B2 (en) 2009-08-03 2013-09-03 Oracle International Corporation Logging framework for a data stream processing server
US8386466B2 (en) 2009-08-03 2013-02-26 Oracle International Corporation Log visualization tool for a data stream processing server
US9430494B2 (en) 2009-12-28 2016-08-30 Oracle International Corporation Spatial data cartridge for event processing systems
US9305057B2 (en) 2009-12-28 2016-04-05 Oracle International Corporation Extensible indexing framework using data cartridges
US8959106B2 (en) 2009-12-28 2015-02-17 Oracle International Corporation Class loading using java data cartridges
US8918388B1 (en) * 2010-02-26 2014-12-23 Turn Inc. Custom data warehouse on top of mapreduce
US8713049B2 (en) 2010-09-17 2014-04-29 Oracle International Corporation Support for a parameterized query/view in complex event processing
US8495085B2 (en) * 2010-09-27 2013-07-23 International Business Machines Corporation Supporting efficient partial update of hierarchically structured documents based on record storage
US9189280B2 (en) 2010-11-18 2015-11-17 Oracle International Corporation Tracking large numbers of moving objects in an event processing system
US8489649B2 (en) 2010-12-13 2013-07-16 Oracle International Corporation Extensible RDF databases
US8990416B2 (en) 2011-05-06 2015-03-24 Oracle International Corporation Support for a new insert stream (ISTREAM) operation in complex event processing (CEP)
US9329975B2 (en) 2011-07-07 2016-05-03 Oracle International Corporation Continuous query language (CQL) debugger in complex event processing (CEP)
CN102308297B (en) * 2011-07-13 2013-06-05 华为技术有限公司 Data migration method, data migration device and data migration system
EP2608054B1 (en) * 2011-12-21 2018-02-21 Siemens Aktiengesellschaft Executing database insert calls in a MES system
CN102662997B (en) * 2012-03-15 2015-09-16 播思通讯技术(北京)有限公司 A kind of storing X ML data are to the method for relational database
US9953059B2 (en) 2012-09-28 2018-04-24 Oracle International Corporation Generation of archiver queries for continuous queries over archived relations
US9563663B2 (en) 2012-09-28 2017-02-07 Oracle International Corporation Fast path evaluation of Boolean predicates
US10956422B2 (en) 2012-12-05 2021-03-23 Oracle International Corporation Integrating event processing with map-reduce
US10298444B2 (en) 2013-01-15 2019-05-21 Oracle International Corporation Variable duration windows on continuous data streams
US9098587B2 (en) 2013-01-15 2015-08-04 Oracle International Corporation Variable duration non-event pattern matching
US9047249B2 (en) 2013-02-19 2015-06-02 Oracle International Corporation Handling faults in a continuous event processing (CEP) system
US9390135B2 (en) 2013-02-19 2016-07-12 Oracle International Corporation Executing continuous event processing (CEP) queries in parallel
US9418113B2 (en) 2013-05-30 2016-08-16 Oracle International Corporation Value based windows on relations in continuous data streams
CN104077340B (en) * 2013-07-18 2016-06-01 腾讯科技(深圳)有限公司 The establishment method of a kind of database and server
US9934279B2 (en) 2013-12-05 2018-04-03 Oracle International Corporation Pattern matching across multiple input data streams
US9244978B2 (en) 2014-06-11 2016-01-26 Oracle International Corporation Custom partitioning of a data stream
US9712645B2 (en) 2014-06-26 2017-07-18 Oracle International Corporation Embedded event processing
CN104133890B (en) * 2014-07-30 2016-02-10 四川中亚联邦科技有限公司 A kind of large data processing method in high in the clouds and system
CN104123392A (en) * 2014-08-11 2014-10-29 吉林禹硕动漫游戏科技股份有限公司 Tool and method for transferring relational database to HBase
US9886486B2 (en) 2014-09-24 2018-02-06 Oracle International Corporation Enriching events with dynamically typed big data for event processing
US10120907B2 (en) 2014-09-24 2018-11-06 Oracle International Corporation Scaling event processing using distributed flows and map-reduce operations
WO2017018901A1 (en) 2015-07-24 2017-02-02 Oracle International Corporation Visually exploring and analyzing event streams
US10872065B1 (en) * 2015-08-03 2020-12-22 Intelligence Designs, LLC System for managing relational databases using XML objects
JP6918057B2 (en) * 2019-08-05 2021-08-11 三菱電機株式会社 Screen development support device, screen development support method and screen development support program
CN111695002B (en) * 2020-06-05 2024-01-02 苏州瑞云信息技术有限公司 Database-independent query method based on XML sentences

Family Cites Families (37)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US220912A (en) * 1879-10-28 Improvement in indicators for barbed-wire fences
US220927A (en) * 1879-10-28 Improvement in book-marks
US10896A (en) * 1854-05-09 Machiite
US5257365A (en) 1990-03-16 1993-10-26 Powers Frederick A Database system with multi-dimensional summary search tree nodes for reducing the necessity to access records
US5956715A (en) 1994-12-13 1999-09-21 Microsoft Corporation Method and system for controlling user access to a resource in a networked computing environment
US5893109A (en) 1996-03-15 1999-04-06 Inso Providence Corporation Generation of chunks of a long document for an electronic book system
US5893104A (en) 1996-07-09 1999-04-06 Oracle Corporation Method and system for processing queries in a database system using index structures that are not native to the database system
US6208993B1 (en) 1996-07-26 2001-03-27 Ori Software Development Ltd. Method for organizing directories
US5987506A (en) 1996-11-22 1999-11-16 Mangosoft Corporation Remote access and geographically distributed computers in a globally addressable storage environment
US5878415A (en) 1997-03-20 1999-03-02 Novell, Inc. Controlling access to objects in a hierarchical database
JP3777025B2 (en) 1997-08-20 2006-05-24 インターナショナル・ビジネス・マシーンズ・コーポレーション System resource display device and method thereof
US6141655A (en) 1997-09-23 2000-10-31 At&T Corp Method and apparatus for optimizing and structuring data by designing a cube forest data structure for hierarchically split cube forest template
US5974407A (en) 1997-09-29 1999-10-26 Sacks; Jerome E. Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus
US6038563A (en) 1997-10-31 2000-03-14 Sun Microsystems, Inc. System and method for restricting database access to managed object information using a permissions table that specifies access rights corresponding to user access rights to the managed objects
US6356920B1 (en) 1998-03-09 2002-03-12 X-Aware, Inc Dynamic, hierarchical data exchange system
US6772350B1 (en) 1998-05-15 2004-08-03 E.Piphany, Inc. System and method for controlling access to resources in a distributed environment
US6263332B1 (en) 1998-08-14 2001-07-17 Vignette Corporation System and method for query processing of structured documents
US6487546B1 (en) 1998-08-27 2002-11-26 Oracle Corporation Apparatus and method for aggregate indexes
US6366934B1 (en) 1998-10-08 2002-04-02 International Business Machines Corporation Method and apparatus for querying structured documents using a database extender
US6154741A (en) 1999-01-29 2000-11-28 Feldman; Daniel J. Entitlement management and access control system
US6343287B1 (en) 1999-05-19 2002-01-29 Sun Microsystems, Inc. External data store link for a profile service
US6496842B1 (en) 1999-05-28 2002-12-17 Survol Interactive Technologies Navigating heirarchically organized information
US6470344B1 (en) 1999-05-29 2002-10-22 Oracle Corporation Buffering a hierarchical index of multi-dimensional data
US6199195B1 (en) 1999-07-08 2001-03-06 Science Application International Corporation Automatically generated objects within extensible object frameworks and links to enterprise resources
US6785673B1 (en) 2000-02-09 2004-08-31 At&T Corp. Method for converting relational data into XML
US6934712B2 (en) 2000-03-21 2005-08-23 International Business Machines Corporation Tagging XML query results over relational DBMSs
US6708186B1 (en) * 2000-08-14 2004-03-16 Oracle International Corporation Aggregating and manipulating dictionary metadata in a database system
US6785718B2 (en) 2000-10-23 2004-08-31 Schneider Logistics, Inc. Method and system for interfacing with a shipping service
US7197764B2 (en) 2001-06-29 2007-03-27 Bea Systems Inc. System for and methods of administration of access control to numerous resources and objects
AU2002334721B2 (en) * 2001-09-28 2008-10-23 Oracle International Corporation An index structure to access hierarchical data in a relational database system
US7127700B2 (en) 2002-03-14 2006-10-24 Openwave Systems Inc. Method and apparatus for developing web services using standard logical interfaces to support multiple markup languages
US7120645B2 (en) * 2002-09-27 2006-10-10 Oracle International Corporation Techniques for rewriting XML queries directed to relational database constructs
US7308474B2 (en) * 2002-11-06 2007-12-11 Oracle International Corporation Techniques for scalably accessing data in an arbitrarily large document by a device with limited resources
US6836778B2 (en) * 2003-05-01 2004-12-28 Oracle International Corporation Techniques for changing XML content in a relational database
US7103611B2 (en) 2003-05-01 2006-09-05 Oracle International Corporation Techniques for retaining hierarchical information in mapping between XML documents and relational data
US20040230667A1 (en) * 2003-05-12 2004-11-18 Wookey Michael J. Loosely coupled intellectual capital processing engine
US20050010896A1 (en) 2003-07-07 2005-01-13 International Business Machines Corporation Universal format transformation between relational database management systems and extensible markup language using XML relational transformation

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
DAYEN I: "Storing XML in Relational Databases", XML.COM, 20 June 2001 (2001-06-20), XP002275971 *
IBM SYSTEMS JOURNAL - XML PROGRAMMING WITH SQL-XML AND XQUERY, vol. 41, no. 4, 2002, REINTWALD B ET AL, pages 642 - 665, XP002295973, Retrieved from the Internet <URL:http://www.research.ibm.com/journal/sj/414/reinwald.pdf> [retrieved on 20040907] *
ORACLE9I - XML DATABASE DEVELOPER'S GUIDE - ORACLE XML DB, October 2002 (2002-10-01), pages 10-1 - 10-56, XP002295814, Retrieved from the Internet <URL:http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96620.pdf> [retrieved on 20040907] *
ORACLE9I SQL REFERENCE - RELEASE 2, October 2002 (2002-10-01), pages 8.3 - 8.7, XP002295972, Retrieved from the Internet <URL:HTTP://DOWNLOAD-WEST.ORACLE.COM/DOCS/CD/B10501_01/SERVER.920/A96540.PDF> [retrieved on 20040907] *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102760164B (en) * 2012-06-12 2016-01-20 北大方正集团有限公司 A kind of method of exchanges data between relational database management system and XML data base management system

Also Published As

Publication number Publication date
CN100545835C (en) 2009-09-30
WO2004100021A2 (en) 2004-11-18
JP2006525600A (en) 2006-11-09
AU2004237062B2 (en) 2008-07-17
CA2522309A1 (en) 2004-11-18
EP1618502A2 (en) 2006-01-25
CN1781105A (en) 2006-05-31
AU2004237062A1 (en) 2004-11-18
CA2522309C (en) 2010-03-23
US20040220927A1 (en) 2004-11-04
JP4516566B2 (en) 2010-08-04
US7103611B2 (en) 2006-09-05

Similar Documents

Publication Publication Date Title
WO2004100021A3 (en) Retaining hierarchical information in mapping between xml documents and relational data
WO2007014274A3 (en) Caching and modifying portions of a multi-dimensional database on a user device
WO2008130952A3 (en) Extensible database system and method
WO2007024622A3 (en) Building automation system data management
WO2004114160A3 (en) Systems and processes for automated criteria and attribute generation, searching, auditing and reporting of data
CA2461854A1 (en) Mechanism for mapping xml schemas to object-relational database systems
WO2007014341A3 (en) Patent mapping
WO2004044781A3 (en) Techniques for managing multiple hierarchies of data from a single interface
WO2008030335A3 (en) Enterprise performance management software system having action-based data capture
WO2006008733A3 (en) A method for determining near duplicate data objects
WO2008039542A3 (en) System and method of ad-hoc analysis of data
WO2006060773A3 (en) Computer systems and methods for visualizing data with generation of marks
WO2002025471A3 (en) Method and apparatus for structuring, maintaining, and using families of data
EP1983425A4 (en) Object relation display program and object relation display method
WO2004104729A3 (en) System and method for query result caching
EP1081611A3 (en) Query engine and method for Querying data using metadata model
WO2005036307A3 (en) System for optimizing a business process
WO2004012057A3 (en) Method and system of unifying data
WO2008018080A3 (en) Smart integration engine and metadata-oriented architecture for automatic eii and business integration
CA2385814A1 (en) Document management method and document management system
EP1526443A3 (en) Imaging device information management system
US20100049760A1 (en) Computer tool for managing digital docements
WO2007078774A3 (en) Conflict resolution in highly available network element
EP1335305A3 (en) Algorithm for dynamic selection of data locking granularity
CN106066871A (en) A kind of multiple and distributing sources access method based on open interface

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DPEN Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed from 20040101)
WWE Wipo information: entry into national phase

Ref document number: 2522309

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 2004237062

Country of ref document: AU

WWE Wipo information: entry into national phase

Ref document number: 02067/KOLNP/2005

Country of ref document: IN

Ref document number: 2067/KOLNP/2005

Country of ref document: IN

WWE Wipo information: entry into national phase

Ref document number: 2004760516

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2006509577

Country of ref document: JP

Ref document number: 20048117043

Country of ref document: CN

ENP Entry into the national phase

Ref document number: 2004237062

Country of ref document: AU

Date of ref document: 20040331

Kind code of ref document: A

WWP Wipo information: published in national office

Ref document number: 2004237062

Country of ref document: AU

WWP Wipo information: published in national office

Ref document number: 2004760516

Country of ref document: EP

ENP Entry into the national phase

Ref document number: 2004237062

Country of ref document: AU

Date of ref document: 20040331

Kind code of ref document: B