会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 31. 发明授权
    • Techniques for extending user-defined indexes with auxiliary properties
    • 用辅助属性扩展用户定义的索引的技术
    • US07996387B2
    • 2011-08-09
    • US12027897
    • 2008-02-07
    • Dinesh DasWesley LinSeema SundaraYing HuSriram Krishnamurthy
    • Dinesh DasWesley LinSeema SundaraYing HuSriram Krishnamurthy
    • G06F17/30
    • G06F17/30463G06F17/30312G06F17/30471
    • In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The one or more functions are operable to generate index entries of the user-defined index for the one or more auxiliary properties. The one or more auxiliary properties are different than, and in addition to, a primary property of the user-defined index that provides for evaluating a query operator. The database server receives a first statement that defines the user-defined index, where the first statement includes one or more parameters that define the one or more auxiliary properties. The database server invokes the one or more functions in response to the first statement, where the one or more functions when invoked generate and store the index entries of the user-defined index according to the one or more parameters that define the one or more auxiliary properties.
    • 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 一个或多个功能可操作以生成用于一个或多个辅助属性的用户定义索引的索引条目。 一个或多个辅助属性不同于并且除了用于定义查询运算符的用户定义索引的主要属性之外。 数据库服务器接收定义用户定义的索引的第一个语句,其中第一个语句包含一个或多个定义一个或多个辅助属性的参数。 数据库服务器响应于第一语句来调用一个或多个函数,其中调用时一个或多个函数生成并根据定义一个或多个辅助的一个或多个参数来存储用户定义的索引的索引条目 属性。
    • 35. 发明申请
    • Method and system for speeding up rebuild of user-defined indexes during partition maintenance operations in the database systems
    • 在数据库系统中的分区维护操作期间加快重建用户定义索引的方法和系统
    • US20090177622A1
    • 2009-07-09
    • US12007325
    • 2008-01-09
    • Ying HuSeema SundaraJagannathan Srinivasan
    • Ying HuSeema SundaraJagannathan Srinivasan
    • G06F17/30
    • 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.
    • 方法,系统和计算机程序产品提供了在分区维护操作(分区拆分,合并和移动)期间重建用户定义索引的改进性能。 维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作,其中分区数据库表的多行被从一个分区移动到另一分区,存储多个分区数据库表中的至少一个的映射信息 移动的行,包括每个移动的行的旧映射和每个被移动的行的对应的新映射,以及当重建索引时,用对应的多个移动的行中的每一个代替索引中的旧映射 为多个移动的行中的每一个存储新的映射。
    • 36. 发明申请
    • Materialized views with user-defined aggregates
    • 具有用户定义聚合的物化视图
    • US20090019005A1
    • 2009-01-15
    • US11827796
    • 2007-07-13
    • Ying HuSeema SundaraJagannathan Srinivasan
    • Ying HuSeema SundaraJagannathan Srinivasan
    • G06F17/30
    • G06F17/30457
    • Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.
    • 描述了使用用户定义的聚合来支持物化视图的系统,方法,介质和其他实施例。 一个示例系统包括用于在与基表相关联的物化视图中暴露一组接口动作以支持用户定义的聚合的逻辑。 物化视图可以存储用户定义的聚合和有助于将用户定义的聚合逻辑连接到基表的用户定义的聚合上下文。 示例系统还可以包括用于支持用户定义的聚合的逻辑。 支持可以基于一组接口动作。 因此,示例系统和方法可以促进物化视图的增量更新和/或重写查询以访问物化视图。
    • 37. 发明申请
    • Queries with hard time constraints
    • 具有困难时间限制的查询
    • US20080288473A1
    • 2008-11-20
    • US11804508
    • 2007-05-18
    • Ying HuSeema SundaraJagannathan Srinivasan
    • Ying HuSeema SundaraJagannathan Srinivasan
    • G06F17/30
    • G06F17/30522G06F17/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.
    • 描述了与支持具有硬时间约束的查询相关联的系统,方法,媒体和其他实施例。 一个示例性系统实施例包括用于接受具有硬时间约束的查询的逻辑。 示例系统还可以包括用于选择性地将具有硬时间约束的查询重写到具有行限制或样本百分比限制的查询中的逻辑。 在一个示例中,通过将估计的查询执行时间与硬时间约束重复比较来计算行限制或抽样百分比限制。 示例系统还可以包括用于建立与重写查询相关联的定时器的逻辑。
    • 40. 发明授权
    • Constructing multidimensional histograms for complex spatial geometry objects
    • 为复杂的空间几何对象构建多维直方图
    • US08812488B2
    • 2014-08-19
    • US13587897
    • 2012-08-16
    • Bhuvan BambaRichard J. AndersonYing HuSiva Ravada
    • Bhuvan BambaRichard J. AndersonYing HuSiva Ravada
    • G06F17/30
    • G06F17/30241
    • Techniques are described for generating histograms for a multidimensional space. In the presence of large spatial objects, fuzzy splitting techniques are utilized to recursively divide the multidimensional space into partitions, where a single spatial object may belong to multiple partitions. Large spatial objects are essentially broken down into smaller objects that may allow for more efficient partitioning of the multidimensional space. A count of spatial objects in each partition yields a spatial histogram. A spatial object that belongs to multiple partitions may have a weighted count for each of the multiple partitions, based on the extent to which the spatial object overlaps with each partition. Thus, an object that is split among a handful of partitions will only contribute a fraction of a count to each partition. Small partitions having relatively few objects are avoided by refusing to subdivide a partition whose members drop below a threshold number.
    • 描述了用于生成多维空间的直方图的技术。 在存在大空间物体的情况下,使用模糊分割技术将多维空间递归地划分成分区,其中单个空间对象可能属于多个分区。 大的空间对象基本上被分解成更小的对象,这可以允许对多维空间进行更有效的划分。 每个分区中的空间对象的计数产生空间直方图。 基于空间对象与每个分区重叠的程度,属于多个分区的空间对象可以具有针对多个分区中的每一个的加权计数。 因此,在少数分区之间分割的对象只会为每个分区贡献一部分计数。 通过拒绝细分成员下降到阈值以下的分区来避免具有相对较少对象的小分区。