利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

40 条记录 (耗时 0.04 秒)

    Method, system, and program for managing file names during the reorganization of a database object
    22.
    发明授权
    Method, system, and program for managing file names during the reorganization of a database object 有权
    在重新组织数据库对象期间管理文件名的方法，系统和程序

    公开(公告)号：US06460048B1

    公开(公告)日：2002-10-01

    申请号：US09311075

    申请日：1999-05-13

    申请人： James Zu-Chia Teng ,  Jeffrey James Todd

    发明人： James Zu-Chia Teng ,  Jeffrey James Todd

    IPC分类号： G06F1700

    CPC分类号： G06F17/30595 ,  Y10S707/99944

    摘要： Disclosed is a system, method, and program for reorganizing at least one database object. The database object is comprised of at least one database file. Each database file has a name. Source database files including data for the database objects subject to the reorganization have source names. Shadow copies of the source database files are created and shadow names for the shadow copies are generated, such that the source names and corresponding shadow names are different. The data in the shadow copies is reorganized. After the reorganization, the shadow names are used to access the database files for the reorganized database objects.

    摘要翻译： 公开了一种用于重组至少一个数据库对象的系统，方法和程序。 数据库对象由至少一个数据库文件组成。 每个数据库文件都有一个名称。 源数据库文件，包括重组的数据库对象的数据源具有源名称。 创建源数据库文件的卷影副本，并生成影子副本的影子名称，以便源名称和相应的影子名称不同。 影子副本中的数据被重新组织。 重组后，阴影名称用于访问重组数据库对象的数据库文件。

    Keymap order compression
    23.
    发明授权
    Keymap order compression 有权
    键盘顺序压缩

    公开(公告)号：US07783855B2

    公开(公告)日：2010-08-24

    申请号：US11615699

    申请日：2006-12-22

    申请人： Sauraj Goswami ,  You-Chin Fuh ,  Michael R. Shadduck ,  James Zu-Chia Teng

    发明人： Sauraj Goswami ,  You-Chin Fuh ,  Michael R. Shadduck ,  James Zu-Chia Teng

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

    CPC分类号： H03M7/30 ,  G06F17/30336

    摘要： Various embodiments of a computer-implemented method, system and computer program product are provided. A first plurality of key entries of a first index page are compressed in accordance with an order specified by a first keymap of the first index page. The first keymap also indicates respective positions of the key entries of the first plurality of key entries. A second keymap is generated indicating the order and also indicating respective post-compression positions of the key entries of the first plurality of key entries. The compressed first plurality of key entries is stored on a second index page with the second keymap.

    摘要翻译： 提供了计算机实现的方法，系统和计算机程序产品的各种实施例。 根据由第一索引页的第一键映射指定的顺序来压缩第一索引页的第一多个密钥条目。 第一键映射还指示第一多个密钥条目的密钥条目的相应位置。 产生指示顺序的第二键图，并且还指示第一多个键入口中的键入项的各自的后压缩位置。 压缩的第一多个密钥条目存储在具有第二密钥映射的第二索引页上。

    System and method for selective partition locking
    24.
    发明授权
    System and method for selective partition locking 有权
    选择性分区锁定的系统和方法

    公开(公告)号：US07480653B2

    公开(公告)日：2009-01-20

    申请号：US10817205

    申请日：2004-04-02

    申请人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Zu-Chia Teng ,  Julie A. Watts

    发明人： Karelle L. Cornwell ,  Tanya Couch ,  Robert W. Lyle ,  James Zu-Chia Teng ,  Julie A. Watts

    IPC分类号： G06F7/00 ,  G06F17/30 ,  G06F12/00 ,  G06F13/00 ,  G06F13/28

    CPC分类号： G06F17/30362 ,  Y10S707/99938

    摘要： A method and system for controlling concurrency of access to data in a database system, includes: partitioning a table in the database system into a plurality of partitions; receiving a request for access to data; determining a partition of the plurality of partitions that contains the data; determining if the data has been committed; and if so, avoiding locking the partition in response to the request. By avoiding locking the partition when the data has been committed, the number of partition locks that need to be requested from a local resource lock manager is reduced, improving performance.

    摘要翻译： 一种用于控制对数据库系统中的数据访问的并发性的方法和系统，包括：将所述数据库系统中的表划分成多个分区; 接收访问数据的请求; 确定包含所述数据的所述多个分区的分区; 确定数据是否已提交; 如果是这样，则避免锁定分区以响应该请求。 通过避免在数据提交时锁定分区，减少了需要从本地资源锁管理器请求的分区锁的数量，从而提高了性能。

    Method and system for reduced lock contention in SQL transactions
    27.
    发明授权
    Method and system for reduced lock contention in SQL transactions 失效
    在SQL事务中减少锁争用的方法和系统

    公开(公告)号：US07080074B2

    公开(公告)日：2006-07-18

    申请号：US10010371

    申请日：2001-11-05

    申请人： Namik Hrle ,  Andreas R. Maier ,  James Zu-Chia Teng ,  Julie A. Watts

    发明人： Namik Hrle ,  Andreas R. Maier ,  James Zu-Chia Teng ,  Julie A. Watts

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30595 ,  G06F17/30362 ,  Y10S707/99938

    摘要： According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.

    摘要翻译： 根据本发明的方法，装置和计算机可读介质，通过访问关系数据库中的表的所有行来执行扫描，评估每行以确定该行是否满足数据库查询的一组谓词， 并返回该行，如果它满足一组谓词。 根据本发明的优选实施例，无论当前的锁如何，都对所有行进行评估。 如果该行不满足该组谓词，而不考虑行上的当前锁定，则继续进行扫描。 根据本发明的锁定语义的优点在于它完全消除了对不满足语句谓词的行的锁争用的问题。

    System and method for avoiding deadlock situations due to pseudo-deleted entries
    28.
    发明授权
    System and method for avoiding deadlock situations due to pseudo-deleted entries 失效
    用于避免由于伪删除条目引起的死锁情况的系统和方法

    公开(公告)号：US06944615B2

    公开(公告)日：2005-09-13

    申请号：US09894090

    申请日：2001-06-28

    申请人： James Zu-Chia Teng ,  Namik Hrle

    发明人： James Zu-Chia Teng ,  Namik Hrle

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30362 ,  Y10S707/99938 ,  Y10S707/99952

    摘要： In a database management system (DBMS) (60) for a database application (10) including a database (12) having a table (14, 16, 18) and a unique key index (42) having indexes (44, 46, 48) therefor, the DBMS (60) includes a data manager (64), an index manager (66), a transaction manager (62), and a lock manager (68) which restricts access to the table by assigning locks to elements thereof. In order to avoid deadlock in the database application due to the pseudo-deleted entries, the lock categories include an X-lock and a Conditional S-lock, and have lock attributes including at least a Delete attribute for the X-lock. The Conditional S-lock is compatible (granted by the lock manager) with an X-lock whose Delete attribute is NOT SET, but is not compatible (granted) with an X-lock whose Delete attribute is SET. Each index entry includes a pseudo-delete flag which is SET by the index manager (66) to indicate deletion of the indexed row. Conditional upon locating a pseudo-deleted index key corresponding to a key to be added to the index, the index manager (66) requests a Conditional S-lock on the row indexed thereby, whereby the index manager (66) verifies the Delete transaction which set the pseudo-delete flag has committed.

    摘要翻译： 在数据库应用程序（10）的数据库管理系统（DBMS）（60）中，包括具有表（14,16,18）的数据库（12）和具有索引（44,46,48）的唯一键索引（42） ）为此，DBMS（60）包括数据管理器（64），索引管理器（66），事务管理器（62）和锁管理器（68），其通过向其元素分配锁限制对表的访问。 为了避免由于伪删除的条目而导致数据库应用程序中的死锁，锁类别包括X锁和条件S锁，并且具有至少包含X锁的Delete属性的锁属性。 条件S锁与X锁定（其Delete属性未设置）兼容，但与Delete属性为SET的X锁不兼容（授予）。 每个索引条目包括由索引管理器（66）设置为指示删除索引行的伪删除标志。 有条件的是，索引管理器（66）根据与要添加到索引的密钥相对应的伪删除的索引密钥来定位索引的行上的条件S锁定，由此索引管理器（66）验证删除事务， 设置伪删除标志已经提交。