专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07849113B2 Query statistics 有权
标题翻译：查询统计信息
公开(公告)号：US07849113B2
公开(公告)日：2010-12-07
申请号：US11978799
申请日：2007-10-30
申请人： Sundeep Abraham , Wesley C. Lin , Yasuhiro Matsuda , Mohammad Faisal , Geeta Arora
发明人： Sundeep Abraham , Wesley C. Lin , Yasuhiro Matsuda , Mohammad Faisal , Geeta Arora
IPC分类号： G06F17/20 , G06F15/16
CPC分类号： G06F17/30536 , G06F17/30442
摘要： Systems, methods, and other embodiments associated with selectively acquiring and utilizing query statistics are described. One example method includes selectively acquiring statistics associated with search queries submitted to a search process during a sample period. The statistics may be associated with an index and tokens associated with the index and search queries. The method may also include selecting tokens and/or queries to optimize based, at least in part, on the statistics. In one example, whether and/or how the tokens and/or queries are optimized may depend on estimating index fragmentation based, at least in part, on the statistics.
摘要翻译：描述了与选择性地获取和利用查询统计相关联的系统，方法和其他实施例。一个示例性方法包括选择性地获取在采样周期期间提交到搜索过程的搜索查询相关联的统计信息。统计信息可能与与索引和搜索查询相关联的索引和令牌相关联。该方法还可以包括至少部分地基于统计信息来选择令牌和/或查询进行优化。在一个示例中，是否和/或如何优化令牌和/或查询可以取决于至少部分地基于统计量估计索引碎片。

2. 发明授权

US07801856B2 Using XML for flexible replication of complex types 有权
标题翻译：使用XML灵活复制复杂类型
公开(公告)号：US07801856B2
公开(公告)日：2010-09-21
申请号：US11502247
申请日：2006-08-09
申请人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Nimar Arora , Edwina Lu
发明人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Nimar Arora , Edwina Lu
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30569
摘要： Instances of complex types are logically replicated. In general, the logical replication of complex types involves converting a complex type instance from its storage format into a logical representation written in a markup language, like XML. The logical representation is then propagated to a destination (or destinations), which converts the logical representation to a storage format used at the destination for that complex type.
摘要翻译：复杂类型的实例在逻辑上被复制。一般来说，复杂类型的逻辑复制涉及将复杂类型实例从其存储格式转换为以标记语言（如XML）编写的逻辑表示。然后，逻辑表示被传播到目的地（或目的地），其将逻辑表示转换为用于该复合类型的目的地的存储格式。

3. 发明授权

US07853573B2 Efficient replication of XML data in a relational database management system 有权
标题翻译：在关系数据库管理系统中高效地复制XML数据
公开(公告)号：US07853573B2
公开(公告)日：2010-12-14
申请号：US11416835
申请日：2006-05-03
申请人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Sivasankaran Chandrasekar , Lik Wong , Nimar S. Arora
发明人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Sivasankaran Chandrasekar , Lik Wong , Nimar S. Arora
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30908
摘要： Efficiently replicating XML data among databases includes techniques for (a) replicating XML data involved with an insert operation; (b) replicating XML data involved with an update operation; (c) leveraging existing relational replication techniques for XML data stored in shredded form using object-relational constructs; and (d) replicating XQuery Data Model sequences. Each technique reduces the amount of information that would otherwise need to be transmitted over a network for XML data replication purposes.
摘要翻译：在数据库之间有效复制XML数据包括（a）复制与插入操作相关的XML数据的技术; （b）复制涉及更新操作的XML数据; （c）利用现有的关系复制技术，使用对象关系结构存储在切割形式的XML数据; 和（d）复制XQuery数据模型序列。每种技术减少了为了进行XML数据复制而需要通过网络传输的信息量。

4. 发明申请

US20080040369A1 Using XML for flexible replication of complex types 有权
标题翻译：使用XML灵活复制复杂类型
公开(公告)号：US20080040369A1
公开(公告)日：2008-02-14
申请号：US11502247
申请日：2006-08-09
申请人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Nimar Arora , Edwina Lu
发明人： James W. Warner , Zhen Hua Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Nimar Arora , Edwina Lu
IPC分类号： G06F7/00
CPC分类号： G06F17/30569
摘要： Instances of complex types are logically replicated. In general, the logical replication of complex types involves converting a complex type instance from its storage format into a logical representation written in a markup language, like XML. The logical representation is then propagated to a destination (or destinations), which converts the logical representation to a storage format used at the destination for that complex type.
摘要翻译：复杂类型的实例在逻辑上被复制。一般来说，复杂类型的逻辑复制涉及将复杂类型实例从其存储格式转换为以标记语言（如XML）编写的逻辑表示。然后，逻辑表示被传播到目的地（或目的地），其将逻辑表示转换为用于该复合类型的目的地的存储格式。

5. 发明申请

US20070260650A1 Efficient replication of XML data in a relational database management system 有权
标题翻译：在关系数据库管理系统中高效地复制XML数据
公开(公告)号：US20070260650A1
公开(公告)日：2007-11-08
申请号：US11416835
申请日：2006-05-03
申请人： James Warner , Zhen Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Sivasankaran Chandrasekar , Lik Wong , Nimar Arora
发明人： James Warner , Zhen Liu , Sundeep Abraham , Muralidhar Krishnaprasad , Geeta Arora , Ravi Murthy , Sivasankaran Chandrasekar , Lik Wong , Nimar Arora
IPC分类号： G06F17/30
CPC分类号： G06F17/30908
摘要： Efficiently replicating XML data among databases includes techniques for (a) replicating XML data involved with an insert operation; (b) replicating XML data involved with an update operation; (c) leveraging existing relational replication techniques for XML data stored in shredded form using object-relational constructs; and (d) replicating XQuery Data Model sequences. Each technique reduces the amount of information that would otherwise need to be transmitted over a network for XML data replication purposes.
摘要翻译：在数据库之间有效复制XML数据包括（a）复制与插入操作相关的XML数据的技术; （b）复制涉及更新操作的XML数据; （c）利用现有的关系复制技术，使用对象关系结构存储在切割形式的XML数据; 和（d）复制XQuery数据模型序列。每种技术减少了为了进行XML数据复制而需要通过网络传输的信息量。

6. 发明申请

US20080098048A1 Migrating temporary data of a session 有权
标题翻译：迁移会话的临时数据
公开(公告)号：US20080098048A1
公开(公告)日：2008-04-24
申请号：US11732844
申请日：2007-04-04
申请人： Yujie Cao , Tugrul Bingol , Geeta Arora , Harmeek Singh Bedi , Susan M. Kotsovolos
发明人： Yujie Cao , Tugrul Bingol , Geeta Arora , Harmeek Singh Bedi , Susan M. Kotsovolos
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , G06F11/2097 , Y10S707/99953
摘要： A technique for migrating (e.g., “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data.” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.
摘要翻译：提供了用于将临时数据从一个会话迁移（例如，“复制”或“移动”）到另一会话的技术。在执行与特定会话相关联的工作时，会创建会话状态。会话状态的一个子集包括被称为“临时数据”的大对象。因此，临时数据存储在数据库（而不是数据库服务器）中，并且在特定会话被删除时通常被删除。为了在将会话状态迁移到不同的会话时避免该删除，在一个实施例中，临时数据被保存在与数据库分开的外部存储器中。在外部存储器中创建外部表，并存储临时数据。访问外部表的位置信息被提供给另一个会话。

7. 发明申请

US20050262113A1 Interpreting remote objects at a local site 有权
标题翻译：在本地站点解释远程对象
公开(公告)号：US20050262113A1
公开(公告)日：2005-11-24
申请号：US10949102
申请日：2004-09-24
申请人： Geeta Arora , Magdi Morsi , Rajendra Pingte
发明人： Geeta Arora , Magdi Morsi , Rajendra Pingte
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30569
摘要： A method and apparatus for receiving objects is provided. Embodiments provide for receiving, from a source database server, at a target database server, an object. If the object type of the object is involved in an inheritance hierarchy, then the target database server inspects the object to determine a source identifier that identifies to a source database server the object type associated with the object. The target database determines a target identifier that identifies to the target database server the object type associated with the object based on a mapping that associates source identifiers to target identifiers. Alternately, if the object type of the object is not involved in an inheritance hierarchy, then the target database server inspects the object to determine a set of characteristics of the object. The target database server determines the target identifier for the object based on the characteristics of the object.
摘要翻译：提供了一种用于接收物体的方法和装置。实施例提供从源数据库服务器在目标数据库服务器处接收对象。如果对象的对象类型涉及继承层次结构，则目标数据库服务器将检查对象以确定向源数据库服务器标识与对象关联的对象类型的源标识符。目标数据库基于将源标识符与目标标识符相关联的映射来确定向目标数据库服务器标识与对象相关联的对象类型的目标标识符。或者，如果对象的对象类型不涉及继承层次结构，则目标数据库服务器将检查对象以确定对象的一组特征。目标数据库服务器基于对象的特征来确定对象的目标标识符。

8. 发明授权

US07756889B2 Partitioning of nested tables 有权
标题翻译：嵌套表的分区
公开(公告)号：US07756889B2
公开(公告)日：2010-07-13
申请号：US11707735
申请日：2007-02-16
申请人： Qin Yu , Geeta Arora , Sriram Krishnamurthy , Adiel Yoaz
发明人： Qin Yu , Geeta Arora , Sriram Krishnamurthy , Adiel Yoaz
IPC分类号： G06F7/00
CPC分类号： G06F17/30486 , G06F17/30312
摘要： Techniques for partitioning nested tables are provided. A parent table includes a column for collection items. A nested table is created for storing items that belong to the collection items. The nested table is partitioned to create a plurality of nested table partitions. Each nested table partition is a distinct, separately stored structure within a database. How the nested table is partitioned may, or may not, be based on how the parent table is partitioned. For example, a nested table may be partitioned based on the same criteria in which the parent table is partitioned. As another example, a nested table may be partitioned, whereas the parent table is not partitioned.
摘要翻译：提供分区嵌套表的技术。父表包括收集项列。创建嵌套表用于存储属于集合项目的项目。嵌套表被分区以创建多个嵌套表分区。每个嵌套表分区是一个不同的，单独存储的数据库结构。嵌套表的分区方式可能是，也可能不是基于父表的分区方式。例如，嵌套表可以根据父表进行分区的相同标准进行分区。作为另一示例，嵌套表可以被分区，而父表不被分区。

9. 发明授权

US09767214B2 Technique and framework to provide diagnosability for XML query/DML rewrite and XML index selection 有权
公开(公告)号：US09767214B2
公开(公告)日：2017-09-19
申请号：US13172573
申请日：2011-06-29
申请人： Beda Christoph Hammerschmidt , Zhen Hua Liu , Geeta Arora , Thomas Baby
发明人： Beda Christoph Hammerschmidt , Zhen Hua Liu , Geeta Arora , Thomas Baby
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30929
摘要： A method and apparatus for automatically analyzing and providing feedback regarding the optimizability of a relational database query. A query developer's primary goal is to ensure that queries and DML operations are rewritten for the most efficient execution. Rewrite diagnosability captures metadata for each attempted query optimization including success or failure and the reasons for failure. The metadata is stored in association with the operators that were not removed through rewriting. Once all optimizations have been attempted and rewriting is complete, the metadata is selectively displayed based on the cost to perform the associated operation. The context of performing the operation may affect the cost. The cost may be based at least on the type of operation and where within the query tree the operation is located. A query developer may configure the database system not to execute the resulting query plan based on one or more criteria.

10. 发明授权

US07630957B2 Immutable bookmarks for large objects in a database 有权
标题翻译：数据库中大对象不可变的书签
公开(公告)号：US07630957B2
公开(公告)日：2009-12-08
申请号：US11426697
申请日：2006-06-27
申请人： Geeta Arora , Muralidhar Krishnaprasad
发明人： Geeta Arora , Muralidhar Krishnaprasad
IPC分类号： G06F7/00
CPC分类号： G06F17/30318 , Y10S707/99932
摘要： User-level bookmarks are initially created at a specified offset in a large object (LOB) of a database and automatically updated to reflect a new offset, if necessary, after database updates. By logically linking the bookmark to a data element, the bookmark continues to point to the same logical data element as it did before the update. An API provides the functionality of immutable bookmarks by automatically changing the offset of the bookmark following sliding inserts or deletions of data to the database.
摘要翻译：用户级书签最初以数据库的大对象（LOB）中指定的偏移量创建，并在数据库更新后自动更新以反映新的偏移量（如有必要）。通过将书签逻辑地链接到数据元素，书签继续指向与更新前相同的逻辑数据元素。 API通过在将数据滑动插入或删除到数据库后自动更改书签的偏移量，从而提供不可变书签的功能。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式