-
11.
公开(公告)号:US07260585B2
公开(公告)日:2007-08-21
申请号:US10897578
申请日:2004-07-23
IPC分类号: G06F17/30
CPC分类号: G06F17/30595 , Y10S707/954 , Y10S707/99931 , Y10S707/99933 , Y10S707/99943
摘要: Techniques are provided for mapping XML data and metadata from data in relational databases. According to certain embodiments of the invention, a mechanism is provided to allow the user to use a database query to retrieve data form a relational database in the form of XML documents by canonically mapping object relational data to XML data and canonically mapping object relational schemas to XML-Schemas. The mechanism causes the generation of XML-schema information for the XML documents.
摘要翻译: 提供了用于从关系数据库中的数据映射XML数据和元数据的技术。 根据本发明的某些实施例,提供了一种机制,以允许用户使用数据库查询以XML文档的形式从关系数据库中检索数据,方法是将对象关系数据定性地映射到XML数据,并将对象关系模式映射到 XML模式 该机制导致为XML文档生成XML模式信息。
-
公开(公告)号:US06836778B2
公开(公告)日:2004-12-28
申请号:US10428445
申请日:2003-05-01
申请人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
发明人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
IPC分类号: G06F1730
CPC分类号: G06F17/3061 , G06F17/30923 , Y10S707/99943
摘要: Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.
摘要翻译: 提供技术用于在符合SQL / XML的数据库管理系统(DBMS)中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造,例如XML文档,XML元素,XML属性和XML文档片段。 收到一条SQL语句,其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间,通过修改组件的内容而不修改整个实例来评估XML运算符。 例如,XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符,一个insert-before运算符,一个append-child运算符和一个update运算符。 在执行期间,这些运算符可能被重写为对现有的SQL结构进行操作,或者只通过更新现有的SQL结构或两者来评估。
-
公开(公告)号:US07386567B2
公开(公告)日:2008-06-10
申请号:US10956300
申请日:2004-09-30
申请人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
发明人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
IPC分类号: G06F17/30
CPC分类号: G06F17/3061 , G06F17/30923 , Y10S707/99943
摘要: Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.
摘要翻译: 提供技术用于在符合SQL / XML的数据库管理系统(DBMS)中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造,例如XML文档,XML元素,XML属性和XML文档片段。 收到一条SQL语句,其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间,通过修改组件的内容而不修改整个实例来评估XML运算符。 例如,XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符,一个insert-before运算符,一个append-child运算符和一个update运算符。 在执行期间,这些运算符可能被重写为对现有的SQL结构进行操作,或者只通过更新现有的SQL结构或两者来评估。
-
公开(公告)号:US20050055358A1
公开(公告)日:2005-03-10
申请号:US10897578
申请日:2004-07-23
CPC分类号: G06F17/30595 , Y10S707/954 , Y10S707/99931 , Y10S707/99933 , Y10S707/99943
摘要: Techniques are provided for mapping XML data and metadata from data in relational databases. According to certain embodiments of the invention, a mechanism is provided to allow the user to use a database query to retrieve data form a relational database in the form of XML documents by canonically mapping object relational data to XML data and canonically mapping object relational schemas to XML-Schemas. The mechanism causes the generation of XML-schema information for the XML documents.
-
公开(公告)号:US20050044113A1
公开(公告)日:2005-02-24
申请号:US10956300
申请日:2004-09-30
申请人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
发明人: Anand Manikutty , Muralidhar Krishnaprasad , Ravi Murthy , Visar Nimani , James Warner , Eric Sedlar , Neema Jalali , Bhushan Khaladkar
CPC分类号: G06F17/3061 , G06F17/30923 , Y10S707/99943
摘要: Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.
摘要翻译: 提供技术用于在符合SQL / XML的数据库管理系统(DBMS)中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造,例如XML文档,XML元素,XML属性和XML文档片段。 收到一条SQL语句,其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间,通过修改组件的内容而不修改整个实例来评估XML运算符。 例如,XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符,一个insert-before运算符,一个append-child运算符和一个update运算符。 在执行期间,这些运算符可能被重写为对现有的SQL结构进行操作,或者只通过更新现有的SQL结构或两者来评估。
-
公开(公告)号:US07512599B2
公开(公告)日:2009-03-31
申请号:US10767501
申请日:2004-01-29
CPC分类号: G06F17/30979 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要: A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.
摘要翻译: 在数据库系统中接收到执行查询的请求。 作为响应,数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值,并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
公开(公告)号:US20050154714A1
公开(公告)日:2005-07-14
申请号:US10767501
申请日:2004-01-29
申请人: Qin Yu , Adiel Yoaz , Subramanian Muralidhar , Visar Nimani , Susan Kotsovolos
发明人: Qin Yu , Adiel Yoaz , Subramanian Muralidhar , Visar Nimani , Susan Kotsovolos
IPC分类号: G06F17/30
CPC分类号: G06F17/30979 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要: A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.
摘要翻译: 在数据库系统中接收到执行查询的请求。 作为响应,数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值,并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。
-
-
-
-
-
-