会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • 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 HuSeema SundaraJagannathan Srinivasan
    • Ying HuSeema SundaraJagannathan Srinivasan
    • G06F7/00G06F17/00
    • 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.
    • 方法,系统和计算机程序产品提供了在分区维护操作(分区拆分,合并和移动)期间重建用户定义索引的改进性能。 维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作,其中分区数据库表的多行被从一个分区移动到另一分区,存储多个分区数据库表中的至少一个的映射信息 移动的行,包括每个移动的行的旧映射和每个被移动的行的对应的新映射,以及当重建索引时,用对应的多个移动的行中的每一个代替索引中的旧映射 为多个移动的行中的每一个存储新的映射。
    • 6. 发明申请
    • Techniques for Extending User-Defined Indexes with Auxiliary Properties
    • 扩展具有辅助属性的用户定义索引的技术
    • US20090030883A1
    • 2009-01-29
    • US12027897
    • 2008-02-07
    • Dinesh DasWesley LinSeema SundaraYing HuSriram Krishnamurthy
    • Dinesh DasWesley LinSeema SundaraYing HuSriram Krishnamurthy
    • G06F7/06
    • 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.
    • 在一个实施例中,数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 一个或多个功能可操作以生成用于一个或多个辅助属性的用户定义索引的索引条目。 一个或多个辅助属性不同于并且除了用于定义查询运算符的用户定义索引的主要属性之外。 数据库服务器接收定义用户定义的索引的第一个语句,其中第一个语句包含一个或多个定义一个或多个辅助属性的参数。 数据库服务器响应于第一语句来调用一个或多个函数,其中调用时一个或多个函数生成并根据定义一个或多个辅助的一个或多个参数来存储用户定义的索引的索引条目 属性。
    • 8. 发明申请
    • Database management system with persistent, user-accessible bitmap values
    • 数据库管理系统具有持久的,用户可访问的位图值
    • US20050216518A1
    • 2005-09-29
    • US10810756
    • 2004-03-26
    • Ying HuTimothy ChormaSeema SundaraEugene ChongSouripriya DasJagannathan Srinivasan
    • Ying HuTimothy ChormaSeema SundaraEugene ChongSouripriya DasJagannathan Srinivasan
    • G06F17/30G06F17/00
    • G06F16/2237
    • 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. The representation of the string of bits may be compressed. Bitmap operations on the values may alter the range specifier, the size of the string of bits, or individual bits in the string of bits. The objects represented by the bitmap values may be objects in the database management system or objects external thereto. An example of bitmap values of the first kind are bitmap values representing sets of rowids. rowid bitmap values may be used to make a user-defined index of attribute values for any set of objects contained in fields in the database management system. An example of bitmap values of the second kind are bitmap values representing sets of electronic product codes. ePC bitmap values may be used in any application where a compact representation of a set of ePC codes is desired.
    • 具有位图值的数据库管理系统,其中位列表示中的设置位指定其定义被内置到数据库管理系统中的一组对象。 数据库管理系统还包括对位图值的用户可访问操作。 位图值通过指定对象集合的范围的映射说明符和已经映射到范围说明符指定的对象集合的位串的表示来表示。 可以压缩比特串的表示。 对值的位图操作可以改变范围说明符,位串的大小或位串中的各个位。 由位图值表示的对象可以是数据库管理系统中的对象或其外部的对象。 第一类位图值的一个例子是表示一组rowid的位图值。 rowid位图值可用于为数据库管理系统中的字段中包含的任何对象集合创建用户定义的属性值索引。 第二种位图值的一个例子是表示电子产品代码集的位图值。 ePC位图值可以用于需要一组ePC代码的紧凑表示的任何应用中。