公开(公告)号：US07636739B2

公开(公告)日：2009-12-22

申请号：US11171769

申请日：2005-06-30

申请人： Stefano Stefani ,  Denis V. Churin ,  Istvan Cseri

发明人： Stefano Stefani ,  Denis V. Churin ,  Istvan Cseri

IPC分类号： G06F17/30

CPC分类号： G06F17/30911 ,  G06F17/30336 ,  Y10S707/99933 ,  Y10S707/99952

摘要： An update to a primary table is received. The primary table is read to determine the set of rows to be updated. The primary table is updated and XML objects stored in XML columns are overwritten according to the update. A pre-update node table comprising the nodes corresponding to the updated rows is created from an XML index table corresponding to the primary table. A post-update node table is created by shredding the updated XML objects. The post-update table and the pre-update table are merged according to their node identifiers. The resulting merged table can be inspected to determine which nodes have been, added, deleted, or updated. Based on this inspection, the necessary additions and deletions can be efficiently made to the XML index table.

摘要翻译： 接收到主表的更新。 读取主表以确定要更新的行集。 更新主表，并根据更新覆盖存储在XML列中的XML对象。 包括与更新的行相对应的节点的预更新节点表从与主表对应的XML索引表创建。 通过更新更新的XML对象来创建更新后节点表。 后更新表和更新前的表根据其节点标识符进行合并。 可以检查产生的合并表以确定哪些节点已被添加，删除或更新。 基于此检查，可以有效地对XML索引表进行必要的添加和删除。

公开(公告)号：US07634498B2

公开(公告)日：2009-12-15

申请号：US10693750

申请日：2003-10-24

申请人： Shankar Pal ,  Istvan Cseri ,  Gideon Schaller ,  Oliver N. Seeliger ,  Denis Y. Altudov ,  Denis V. Churin ,  Sameer A. Verkhedkar

发明人： Shankar Pal ,  Istvan Cseri ,  Gideon Schaller ,  Oliver N. Seeliger ,  Denis Y. Altudov ,  Denis V. Churin ,  Sameer A. Verkhedkar

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06F17/30911 ,  Y10S707/99942 ,  Y10S707/99944

摘要： Storing and querying XML data in a primary table or document utilizes an index of XML data and includes creating a primary table structure, creating a primary XML index commensurate with the primary table structure, populating the primary table and the primary XML index, and running a query on the XML data in a primary table by utilizing the XML index. The XML index can be implemented as a node table. The node table may have a B+-tree structure and be populated by shredding the XML values in the primary table. The XML data may be stored as binary large objects in an XML column of the primary table. Secondary XML indexes may be created to assist in the search and retrieval of XML data stored in the primary table. Both the primary XML index and the secondary XML index tables may be created using data definition language statements.

摘要翻译： 在主表或文档中存储和查询XML数据使用XML数据索引，包括创建主表结构，创建与主表结构相称的主XML索引，填充主表和主XML索引，并运行 通过利用XML索引对主表中的XML数据进行查询。 XML索引可以实现为节点表。 节点表可能具有B +树结构，并通过粉碎主表中的XML值来填充。 XML数据可以作为二进制大对象存储在主表的XML列中。 可以创建辅助XML索引以帮助搜索和检索存储在主表中的XML数据。 主XML索引和辅助XML索引表都可以使用数据定义语言语句创建。