利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

5 条记录 (耗时 0.017 秒)

    Partition pruning with composite partitioning
    1.
    发明授权
    Partition pruning with composite partitioning 有权
    分区修剪与复合分区

    公开(公告)号：US06665684B2

    公开(公告)日：2003-12-16

    申请号：US09405980

    申请日：1999-09-27

    申请人： Mohamed Zait ,  Benoit Dageville ,  Andre Kruglikov ,  Gianfranco Putzolu

    发明人： Mohamed Zait ,  Benoit Dageville ,  Andre Kruglikov ,  Gianfranco Putzolu

    IPC分类号： G06F1700

    CPC分类号： G06F17/3033 ,  G06F17/30333 ,  G06F17/30492 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943

    摘要： Techniques are disclosed for expanding the concept of partitioning in variety of ways. In particular techniques are provided for performing multiple-dimension partitioning. In multiple-dimension partitioning, a database object is divided into partitions based on one criteria, and each of those resulting partitions is divided into sub-partitions based on a second criteria. The process of partitioning partitions based on different criteria may be repeated across any number of dimensions. Entirely different partitioning techniques may be used for each level of partitioning. The database server takes advantage of partitions when processing queries by selectively accessing a subset of partitions on disk or reducing the number of internal join operations.

    摘要翻译： 公开了以各种方式扩展划分概念的技术。 特别地，提供了用于执行多维分割的技术。 在多维分区中，基于一个条件将数据库对象划分为分区，并且根据第二准则将所生成的分区中的每一个划分为子分区。 可以跨任何数量的维度重复基于不同标准划分分区的过程。 完全不同的分区技术可用于每个级别的分区。 数据库服务器通过选择性地访问磁盘上的分区子集或减少内部联接操作的数量来处理查询时利用分区。

    Multi-phase locking for partition maintenance operations
    2.
    发明授权
    Multi-phase locking for partition maintenance operations 有权
    多相锁定用于分区维护操作

    公开(公告)号：US06370529B1

    公开(公告)日：2002-04-09

    申请号：US09481743

    申请日：2000-01-11

    申请人： Andre Kruglikov ,  Elizabeth Davis ,  Gianfranco Putzolu

    发明人： Andre Kruglikov ,  Elizabeth Davis ,  Gianfranco Putzolu

    IPC分类号： G06F1730

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

    摘要： A method and apparatus for multi-phase locking for partition maintenance operations is provided. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released. As a result of performing multi-phase locking for partition maintenance operations, the scope of resources locked is reduced and the efficiency of the partition maintenance operations, from a concurrency point of view, is increased.

    摘要翻译： 提供了用于分区维护操作的多相锁定的方法和装置。 在第一阶段，在数据字典中的元数据体上获取共享数据字典锁。 接下来，读取数据字典并生成受影响的分区的列表。 在第二阶段，在受影响的表上获取意向排他数据锁定。 接下来，在受影响的表的受影响的分区上获取独占数据锁。 释放数据字典上的共享数据字典锁定，并更改受影响的分区的数据的物理属性。 在第三阶段，在数据字典上获取独占数据字典锁。 与数据字典中的受影响的分区相关联的元数据被更新，排他性数据锁定在受影响的分区上，并且释放受影响的表上的意图排他数据锁定。 最后，数据字典上的专有数据字典锁定被释放。 作为对分区维护操作进行多相锁定的结果，锁定的资源的范围被减少，并且从并发的观点来看，分区维护操作的效率增加。

    Multi-phase locking for partition maintenance operations
    3.
    发明授权
    Multi-phase locking for partition maintenance operations 失效
    用于分区维护操作的多相锁定

    公开(公告)号：US6105026A

    公开(公告)日：2000-08-15

    申请号：US887963

    申请日：1997-07-03

    申请人： Andre Kruglikov ,  Elizabeth Davis ,  Gianfranco Putzolu

    发明人： Andre Kruglikov ,  Elizabeth Davis ,  Gianfranco Putzolu

    IPC分类号： G06F17/30

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

    摘要： A method and apparatus for multi-phase locking for partition maintenance operations. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released. As a result of performing multi-phase locking for partition maintenance operations, the scope of resources locked is reduced and the efficiency of the partition maintenance operations, from a concurrency point of view, is increased.

    摘要翻译： 一种用于分区维护操作的多相锁定的方法和装置。 在第一阶段，在数据字典中的元数据体上获取共享数据字典锁。 接下来，读取数据字典并生成受影响的分区的列表。 在第二阶段，在受影响的表上获取意向排他数据锁定。 接下来，在受影响的表的受影响的分区上获取独占数据锁。 释放数据字典上的共享数据字典锁定，并更改受影响的分区的数据的物理属性。 在第三阶段，在数据字典上获取独占数据字典锁。 与数据字典中的受影响的分区相关联的元数据被更新，排他性数据锁定在受影响的分区上，并且释放受影响的表上的意图排他数据锁定。 最后，数据字典上的专有数据字典锁定被释放。 作为对分区维护操作进行多相锁定的结果，锁定的资源的范围被减少，并且从并发的观点来看，分区维护操作的效率增加。