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

41. 发明授权

US07987164B2 Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems 有权
标题翻译：在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统
公开(公告)号：US07987164B2
公开(公告)日：2011-07-26
申请号：US12007325
申请日：2008-01-09
申请人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
发明人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30336
摘要： A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.
摘要翻译：方法，系统和计算机程序产品提供了在分区维护操作（分区拆分，合并和移动）期间重建用户定义索引的改进性能。维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作，其中分区数据库表的多行被从一个分区移动到另一分区，存储多个分区数据库表中的至少一个的映射信息移动的行，包括每个移动的行的旧映射和每个被移动的行的对应的新映射，以及当重建索引时，用对应的多个移动的行中的每一个代替索引中的旧映射为多个移动的行中的每一个存储新的映射。

42. 发明申请

US20100161680A1 Data visualization with summary graphs 有权
标题翻译：数据可视化与汇总图
公开(公告)号：US20100161680A1
公开(公告)日：2010-06-24
申请号：US12317362
申请日：2008-12-22
申请人： Medha Atre , Seema Sundara , Jagannathan Srinivasan
发明人： Medha Atre , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30554
摘要： Systems, methods, and other embodiments associated with visualizing data using summary graphs are described. One example method includes constructing a summary graph for display. The summary graph represents the data as a summary node having a plurality of property edges connected to the summary node. The summary node represents the set of values for the node in the data.
摘要翻译：描述了使用概要图形与可视化数据相关联的系统，方法和其他实施例。一个示例性方法包括构建用于显示的摘要图。汇总图表示作为具有连接到汇总节点的多个属性边缘的汇总节点的数据。汇总节点表示数据中节点的值集合。

43. 发明申请

US20070050381A1 Indexes that are based on bitmap values and that use summary bitmap values 有权
标题翻译：基于位图值的索引，并使用汇总位图值
公开(公告)号：US20070050381A1
公开(公告)日：2007-03-01
申请号：US11215639
申请日：2005-08-29
申请人： Ying Hu , Timothy Chorma , Seema Sundara , Jagannathan Srinivasan
发明人： Ying Hu , Timothy Chorma , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F7/00
CPC分类号： G06F17/30324
摘要： A database management system that has bitmap values in which set bits in a representation of a bitstring specify a set of objects whose definitions are built into the database management system. The database management system further includes user-accessible operations on the bitmap values. The bitmap values are represented by means of a mapping specifier that specifies a range of the set of objects and a representation of a string of bits that has been mapped onto the set of object specified by the range specifier. Objects containing bitmap values may be indexed by means of an index tree that includes summary bitmap values.
摘要翻译：具有位图值的数据库管理系统，其中位列表示中的设置位指定其定义被内置到数据库管理系统中的一组对象。数据库管理系统还包括对位图值的用户可访问操作。位图值通过指定对象集合的范围的映射说明符和已经映射到范围说明符指定的对象集合的位串的表示来表示。包含位图值的对象可以通过包含摘要位图值的索引树进行索引。

44. 发明授权

US06351742B1 Method and mechanism for database statement optimization 有权
标题翻译：数据库语句优化的方法和机制
公开(公告)号：US06351742B1
公开(公告)日：2002-02-26
申请号：US09272627
申请日：1999-03-18
申请人： Nipun Agarwal , Dinesh Das , Jagannathan Srinivasan
发明人： Nipun Agarwal , Dinesh Das , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , G06F17/30469 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A method and system for optimizing the execution of database statements are described. An aspect is directed to the generation of an execution plan for a database statement, wherein the database statement contains a predicate having one or more arguments whose values are not known at the time the execution plan is generated (e.g., at compile time). A feature of this aspect involves passing a description of the argument(s) to the optimizer. An example of such a description includes the argument type of the predicate argument.
摘要翻译：描述了优化数据库语句执行的方法和系统。一方面涉及生成数据库语句的执行计划，其中数据库语句包含具有一个或多个参数的谓词，其值在生成执行计划时（例如，在编译时），其值不为已知。此方面的一个特点涉及将参数的描述传递给优化器。这种描述的示例包括谓词参数的参数类型。

45. 发明授权

US09098566B2 Method and system for presenting RDF data as a set of relational views 有权
标题翻译：将RDF数据呈现为一组关系视图的方法和系统
公开(公告)号：US09098566B2
公开(公告)日：2015-08-04
申请号：US13114965
申请日：2011-05-24
申请人： Jagannathan Srinivasan , Yongmei Xie , Jayanta Banerjee
发明人： Jagannathan Srinivasan , Yongmei Xie , Jayanta Banerjee
IPC分类号： G06F17/30
CPC分类号： G06F17/30604 , G06F17/30292
摘要： Disclosed is an approach for presenting RDF data as a set of relational views. By presenting the RDF data as relational views, this permits integrated access to the RDF-based data from existing relational database tools, such as by asserting SQL queries against the relational views. One or more classes are identified within the RDF data, wherein a relational view of the set of the relational views maps properties relating to a particular class.
摘要翻译：公开了一种将RDF数据呈现为一组关系视图的方法。通过将RDF数据呈现为关系视图，这允许从现有关系数据库工具集成访问基于RDF的数据，例如通过针对关系视图断言SQL查询。在RDF数据内识别一个或多个类，其中关系视图集合的关系视图映射与特定类相关的属性。

46. 发明授权

US08015180B2 Queries with hard time constraints 有权
标题翻译：具有困难时间限制的查询
公开(公告)号：US08015180B2
公开(公告)日：2011-09-06
申请号：US11804508
申请日：2007-05-18
申请人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
发明人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F17/30
CPC分类号： G06F17/30522 , G06F17/30533
摘要： Systems, methodologies, media, and other embodiments associated with supporting queries with hard time constraints are described. One exemplary system embodiment includes logic for accepting a query having a hard time constraint. The example system may also include logic for selectively rewriting the query having the hard time constraint into a query having a row limitation or a sample percentage limitation. In one example, the row limitation or sample percentage limitation are computed by repetitively comparing an estimated query execution time to the hard time constraint. The example system may also include logic for establishing a timer(s) associated with the rewritten query.
摘要翻译：描述了与支持具有硬时间约束的查询相关联的系统，方法，媒体和其他实施例。一个示例性系统实施例包括用于接受具有硬时间约束的查询的逻辑。示例系统还可以包括用于选择性地将具有硬时间约束的查询重写到具有行限制或样本百分比限制的查询中的逻辑。在一个示例中，通过将估计的查询执行时间与硬时间约束重复比较来计算行限制或抽样百分比限制。示例系统还可以包括用于建立与重写查询相关联的定时器的逻辑。

47. 发明授权

US06360228B1 Transactional framework for executing statements involving non-native code 有权
标题翻译：用于执行涉及非本地代码的语句的事务框架
公开(公告)号：US06360228B1
公开(公告)日：2002-03-19
申请号：US09324605
申请日：1999-06-02
申请人： Seema Sundara , Ravi Murthy , Nipun Agarwal , Jagannathan Srinivasan
发明人： Seema Sundara , Ravi Murthy , Nipun Agarwal , Jagannathan Srinivasan
IPC分类号： G06F1730
CPC分类号： G06F17/30371 , Y10S707/99931 , Y10S707/99943 , Y10S707/99953
摘要： Described herein is a framework for providing statement atomicity for DDL statements. The framework allows the ability to perform, as multiple transactions, the DDL operations specified by a DDL statement. To begin execution of a DDL statement, a DBMS, for example, updates a flag to indicate that DDL operations have commenced. While the flag is set to this state, the DBMS prevents execution of operations that depend on the DDL statement being executed as an atomic unit. If the DDL operations are aborted, the flag is set to a state that indicates that the execution of the DDL operations did not complete, and the DBMS continues to disallow dependent operations that depend on the atomicity of the DDL statement. Because the flag is used to provide statement atomicity, DDL operations may be performed as multiple transactions. For a DML statement, a mechanism described herein preserves the transactional context of a DML statement. When, for example, a DBMS is executing a transaction and generates a callout, the DBMS prevents operations that may change the transactional context of work performed in response to the callout.
摘要翻译：这里描述的是为DDL语句提供语句原子性的框架。该框架允许作为多个事务执行由DDL语句指定的DDL操作的功能。要开始执行DDL语句，例如，DBMS会更新一个标志，以指示DDL操作已经开始。当标志设置为此状态时，DBMS将阻止执行依赖于作为原子单元执行的DDL语句的操作。如果DDL操作被中止，则该标志被设置为指示执行DDL操作未完成的状态，并且DBMS继续禁止依赖于DDL语句的原子性的依赖操作。因为该标志用于提供语句原子性，所以DDL操作可以被执行为多个事务。对于DML语句，本文所述的机制保留DML语句的事务上下文。例如，当DBMS正在执行事务并生成标注时，DBMS会防止可能改变响应于标注执行的工作的事务上下文的操作。

48. 发明授权

US07774346B2 Indexes that are based on bitmap values and that use summary bitmap values 有权
标题翻译：基于位图值的索引，并使用汇总位图值
公开(公告)号：US07774346B2
公开(公告)日：2010-08-10
申请号：US11215639
申请日：2005-08-29
申请人： Ying Hu , Timothy Chorma , Seema Sundara , Jagannathan Srinivasan
发明人： Ying Hu , Timothy Chorma , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F7/00
CPC分类号： G06F17/30324
摘要： A database management system that has bitmap values in which set bits in a representation of a bitstring specify a set of objects whose definitions are built into the database management system. The database management system further includes user-accessible operations on the bitmap values. The bitmap values are represented by means of a mapping specifier that specifies a range of the set of objects and a representation of a string of bits that has been mapped onto the set of object specified by the range specifier. Objects containing bitmap values may be indexed by means of an index tree that includes summary bitmap values.
摘要翻译：具有位图值的数据库管理系统，其中位列表示中的设置位指定其定义被内置到数据库管理系统中的一组对象。数据库管理系统还包括对位图值的用户可访问操作。位图值通过指定对象集合的范围的映射说明符和已经映射到范围说明符指定的对象集合的位串的表示来表示。包含位图值的对象可以通过包含摘要位图值的索引树进行索引。

49. 发明申请

US20090100089A1 Reference partitioned tables 有权
标题翻译：引用分区表
公开(公告)号：US20090100089A1
公开(公告)日：2009-04-16
申请号：US11974084
申请日：2007-10-11
申请人： George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souriprlya Das
发明人： George Eadon , Eugene Inseok Chong , Shrikanth Shankar , Ananth Raghavan , Jagannathan Srinivasan , Souriprlya Das
IPC分类号： G06F7/00
CPC分类号： G06F17/30595 , G06F17/30486 , Y10S707/953 , Y10S707/954
摘要： Systems, methodologies, media, and other embodiments associated with supporting reference partitioned tables in a relational database are described. One example method includes identifying a partitioning strategy (e.g., range, list, hash) associated with a parent table that is related to a child table by a referential constraint. The example method may also include creating the child table to be a reference-partitioned table partitioned according to the partitioning strategy associated with the parent table. The example method may also include creating the child table to be equi-partitioned with respect to the parent table. The child table is not to replicate a partition key of the parent table but rather is to inherit a partitioning key associated with the parent table through a foreign key relationship.
摘要翻译：描述了在关系数据库中支持参考分区表的系统，方法，媒体和其他实施例。一个示例性方法包括通过参考约束识别与父表相关联的分割策略（例如，范围，列表，散列）。示例方法还可以包括根据与父表相关联的分区策略将子表创建为被分区的引用分区表。示例性方法还可以包括创建相对于父表等份分割的子表。子表不是复制父表的分区密钥，而是通过外键关系继承与父表关联的分区密钥。

50. 发明申请

US20080288446A1 Queries with soft time constraints 有权
标题翻译：具有软时间限制的查询
公开(公告)号：US20080288446A1
公开(公告)日：2008-11-20
申请号：US11804502
申请日：2007-05-18
申请人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
发明人： Ying Hu , Seema Sundara , Jagannathan Srinivasan
IPC分类号： G06F17/30
CPC分类号： G06F17/30536
摘要： Systems, methodologies, media, and other embodiments associated with supporting queries with soft time constraints are described. One exemplary system embodiment includes logic for accepting a query having a soft time constraint. The example system may also include logic for rewriting the query having the soft time constraint into a query having a row limitation or a sample percentage limitation. In one example, the row limitation or sample percentage limitation are computed by repetitively comparing an estimated query execution time to the soft time constraint.
摘要翻译：描述了与支持具有软时间约束的查询相关联的系统，方法，媒体和其他实施例。一个示例性系统实施例包括用于接受具有软时间约束的查询的逻辑。示例系统还可以包括用于将具有软时间约束的查询重写为具有行限制或样本百分比限制的查询的逻辑。在一个示例中，通过将估计的查询执行时间与软时间约束重复比较来计算行限制或样本百分比限制。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式