知搜-全球专利检索

  1. 登录
  2. 注册

搜索结果

176 条记录 (耗时 0.033 秒)

    Index suspension prior to database update
    2.
    发明授权
    Index suspension prior to database update 有权

    公开(公告)号：US09934228B2

    公开(公告)日：2018-04-03

    申请号：US14477904

    申请日：2014-09-05

    申请人： International Business Machines Corporation

    发明人： Michael Bender ,  Wayne M. Delia

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30094 ,  G06F17/30129 ,  G06F17/30374

    摘要： Embodiments of the present invention disclose a method, a computer program product, and a computer system for suspending and activating a database index. A computer determines a quantity of changes for a number of rows of a database that are to be made by an update of the database. The computer determines whether to suspend an index of the database based, at least in part, on a comparison between the quantity of changes and a pre-determined threshold value. The computer suspends the index of the database based on a result of the comparison that indicates the quantity of changes at least meet the pre-determined threshold value. A suspension of the index of the database initiates a rebuilding of the index.

    INDEX SUSPENSION PRIOR TO DATABASE UPDATE
    3.
    发明申请
    INDEX SUSPENSION PRIOR TO DATABASE UPDATE 有权

    公开(公告)号：US20170316021A1

    公开(公告)日：2017-11-02

    申请号：US15656034

    申请日：2017-07-21

    申请人： International Business Machines Corporation

    发明人： Michael Bender ,  Wayne M. Delia

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30094 ,  G06F17/30129 ,  G06F17/30374

    摘要： Embodiments of the present invention disclose a method, a computer program product, and a computer system for suspending and activating a database index. A computer determines a quantity of changes for a number of rows of a database that are to be made by an update of the database. The computer determines whether to suspend an index of the database based, at least in part, on a comparison between the quantity of changes and a pre-determined threshold value. The computer suspends the index of the database based on a result of the comparison that indicates the quantity of changes at least meet the pre-determined threshold value. A suspension of the index of the database initiates a rebuilding of the index.

    METHOD FOR STORING DATA ELEMENTS IN A DATABASE
    9.
    发明申请
    METHOD FOR STORING DATA ELEMENTS IN A DATABASE 审中-公开

    公开(公告)号：US20170060908A1

    公开(公告)日：2017-03-02

    申请号：US15163336

    申请日：2016-05-24

    申请人： International Business Machines Corporation

    发明人： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30292 ,  G06F17/30315 ,  G06F17/30339 ,  G06F17/30374

    摘要： In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.