专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US10650011B2 Efficient performance of insert and point query operations in a column store 有权
公开(公告)号：US10650011B2
公开(公告)日：2020-05-12
申请号：US14664686
申请日：2015-03-20
申请人： International Business Machines Corporation
发明人： Ronald J. Barber , Bishwaranjan Bhattacharjee , Mohammad Sadoghi Hamedani , Guy M. Lohman , Chandrasekaran Mohan , Ippokratis Pandis , Vijayshankar Raman , Richard S. Sidle , Adam J. Storm
IPC分类号： G06F16/245 , G06F16/2458
摘要： A method includes logically organizing, by an object hierarchy processor, data objects in a first hierarchy. A portion of the data objects in the first hierarchy logically includes groupings of other data objects. The object hierarchy processor physically organizes the data objects across two or more types of memory in a second hierarchy. Another portion of the data objects in the second hierarchy physically includes groupings of other data objects. Groupings of the data objects in the second hierarchy are dynamically moved across the two or more types of memory. Levels of access of the data objects are tracked using a data structure that maps groupings of the data objects in the first hierarchy onto metadata information including combined access frequencies of the data objects, and current number of accessors to the data objects, in each grouping of the data objects.

2. 发明授权

US10282363B2 Database management system and method of operation 有权
公开(公告)号：US10282363B2
公开(公告)日：2019-05-07
申请号：US14857889
申请日：2015-09-18
申请人： International Business Machines Corporation
发明人： Namik Hrle , Daniel Martin , Chandrasekaran Mohan , James D. Spyker , Yongfeng Yao
IPC分类号： G06F17/30 , G06F16/27 , G06F16/28 , G06F16/2455
摘要： A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.

3. 发明授权

US09881049B2 Reducing the cost of update, delete, and append-only insert operations in a database 有权
公开(公告)号：US09881049B2
公开(公告)日：2018-01-30
申请号：US15366611
申请日：2016-12-01
申请人： International Business Machines Corporation
发明人： Ronald J. Barber , Bishwaranjan Bhattacharjee , Guy M. Lohman , Chandrasekaran Mohan , Vijayshankar Raman , Mohammad Sadoghi Hamedani , Richard S. Sidle , Adam J. Storm , Xun Xue
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30377 , G06F17/303 , G06F17/30303 , G06F17/30348 , G06F17/30368 , G06F17/30371 , G06F17/30504
摘要： A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.

4. 发明申请

US20190220468A1 DATABASE MANAGEMENT SYSTEM AND METHOD OF OPERATION 审中-公开
公开(公告)号：US20190220468A1
公开(公告)日：2019-07-18
申请号：US16364882
申请日：2019-03-26
申请人： International Business Machines Corporation
发明人： Namik Hrle , Daniel Martin , Chandrasekaran Mohan , James D. Spyker , Yongfeng Yao
IPC分类号： G06F16/27 , G06F16/2455 , G06F16/23 , G06F16/28
CPC分类号： G06F16/273 , G06F16/2358 , G06F16/2379 , G06F16/2455 , G06F16/283
摘要： A computer-implemented method for operating a database management system which includes a source database and a target database. A database management system is configured for asynchronously replicating data changes of the source database to the target database. The database management system receiving a request to perform a database statement. The method can identify the most recently committed one of a plurality of transactions having been committed in the source database before the receiving of the request. Identifying repeatedly the one of the plurality of transactions having been replicated most recently to the target database. Execution of the requested statement in the target database is delayed until an evaluation of the repeatedly identified most recently replicated transaction returns that the identified most recently committed transaction has been replicated to the target database. After the delaying execution, the method executes the requested statement in the target database.

5. 发明授权

US09922077B2 Reducing the cost of update, delete, and append-only insert operations in a database 有权
公开(公告)号：US09922077B2
公开(公告)日：2018-03-20
申请号：US15366562
申请日：2016-12-01
申请人： International Business Machines Corporation
发明人： Ronald J. Barber , Bishwaranjan Bhattacharjee , Guy M. Lohman , Chandrasekaran Mohan , Vijayshankar Raman , Mohammad Sadoghi Hamedani , Richard S. Sidle , Adam J. Storm , Xun Xue
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30377 , G06F17/303 , G06F17/30303 , G06F17/30348 , G06F17/30368 , G06F17/30371 , G06F17/30504
摘要： A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.

6. 发明授权

US09910876B2 Query handling in a columnar database 有权
公开(公告)号：US09910876B2
公开(公告)日：2018-03-06
申请号：US14301399
申请日：2014-06-11
申请人： International Business Machines Corporation
发明人： Walter D. Alvey , Ronald J. Barber , Yi Ding , Chandrasekaran Mohan , Steven R. Pearson , Richard S. Sidle , Adam J. Storm
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30339 , G06F17/30477
摘要： According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.

7. 发明申请

US20170075950A1 REDUCING THE COST OF UPDATE, DELETE, AND APPEND-ONLY INSERT OPERATIONS IN A DATABASE 有权
标题翻译：降低数据库中更新，删除和附加插入操作的成本
公开(公告)号：US20170075950A1
公开(公告)日：2017-03-16
申请号：US15366562
申请日：2016-12-01
申请人： International Business Machines Corporation
发明人： Ronald J. Barber , Bishwaranjan Bhattacharjee , Guy M. Lohman , Chandrasekaran Mohan , Vijayshankar Raman , Mohammad Sadoghi Hamedani , Richard S. Sidle , Adam J. Storm , Xun Xue
IPC分类号： G06F17/30
CPC分类号： G06F17/30377 , G06F17/303 , G06F17/30303 , G06F17/30348 , G06F17/30368 , G06F17/30371 , G06F17/30504
摘要： A first request may be received to update a first set of values. The first set of values may be stored at a first location within a first data page of a database. The first location may be read-only. In response to the receiving of the first request, a first set of records may be inserted into a second data page. The first set of records may include the update of the first set of values. In response to the inserting, a forward pointer may be stored in the first data page that points to the first set of records on the second data page. One or more committed values may be identified on the second data page. In response to the identifying, the one or more committed values may be merged from the second data page to a third data page.
摘要翻译：可以接收第一请求以更新第一组值。第一组值可以存储在数据库的第一数据页内的第一位置。第一个位置可能是只读的。响应于接收到第一请求，可以将第一组记录插入到第二数据页中。第一组记录可能包括更新第一组值。响应于插入，可以将前向指针存储在指向第二数据页上的第一组记录的第一数据页中。可以在第二数据页上识别一个或多个提交值。响应于识别，一个或多个提交值可以从第二数据页合并到第三数据页。

8. 发明申请

US20160350351A1 IN-PLACE UPDATES WITH CONCURRENT READS IN A DECOMPOSED STATE 审中-公开
标题翻译：在分解状态下进行同步读取的更新
公开(公告)号：US20160350351A1
公开(公告)日：2016-12-01
申请号：US14727346
申请日：2015-06-01
申请人： International Business Machines Corporation
发明人： Ronald J. Barber , Bishwaranjan Bhattacharjee , Mohammad Sadoghi Hamedani , Guy M. Lohman , Chandrasekaran Mohan , Vijayshankar Raman , Richard S. Sidle , Adam J. Storm , Xun Xue
IPC分类号： G06F17/30
CPC分类号： G06F16/2343 , G06F16/2315 , G06F16/2365 , G06F16/2379
摘要： A method includes setting, by an update processor, a write latch in a first data structure associated with an object. The first data structure is copied to a storage structure. A history tuple sequence number (TSN) of the first data structure is set to point to a TSN of the copied first data structure. The version identifier is set to point to a transaction identification for the object. Data portions are updated for the first data structure. The version identifier is read from the first data structure. It is determined whether the version identifier of the first data structure is visible for a transaction including isolation requirements. If version identifier of the first data structure is visible, the first data structure is accessed and it is determined whether the version identifier of the first data structure changed since starting the transaction.
摘要翻译：一种方法包括由更新处理器设置与对象相关联的第一数据结构中的写入锁存器。第一个数据结构被复制到存储结构中。将第一数据结构的历史元组序列号（TSN）设置为指向所复制的第一数据结构的TSN。版本标识符被设置为指向对象的事务标识。为第一数据结构更新数据部分。从第一数据结构读取版本标识符。确定第一数据结构的版本标识符对于包括隔离要求的事务是否可见。如果第一数据结构的版本标识符是可见的，则访问第一数据结构，并且确定自开始事务之后是否改变了第一数据结构的版本标识符。

9. 发明申请

US20160203050A1 DATA REPLICATION IN A DATABASE MANAGEMENT SYSTEM 有权
标题翻译：数据库管理系统中的数据复制
公开(公告)号：US20160203050A1
公开(公告)日：2016-07-14
申请号：US14592165
申请日：2015-01-08
申请人： International Business Machines Corporation
发明人： Namik Hrle , Daniel Martin , Chandrasekaran Mohan , Sunil K. Sarin , James D. Spyker , Yongfeng Yao
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1402 , G06F17/30289 , G06F17/30581 , G06F17/30917
摘要： According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.
摘要翻译：根据一个方面，操作数据库管理系统（DBMS）来执行数据复制。 DBMS包括源数据库和目标数据库。源数据库包括分别包括一个或多个第一列的多个第一表，并且目标数据库包括分别包括一个或多个第二列的多个第二表。第一列中的多个第一列中的每一个映射到第二列之一，并且第二列中的每一列适于存储映射到第二列的第一列的复制数据更改。每个第二列具有分配的更新时间，更新时间是当第二列最近接收到的增量数据从其映射的第一列改变时的时刻。 DBMS在提供数据复制时操作处理所请求的数据库语句。

10. 发明申请

US20150213071A1 BUFFERING INSERTS INTO A COLUMN STORE DATABASE 有权
标题翻译：将插入缓冲区插入列存储数据库
公开(公告)号：US20150213071A1
公开(公告)日：2015-07-30
申请号：US14168146
申请日：2014-01-30
申请人： International Business Machines Corporation
发明人： Walter D. Alvey , Matthew A. Huras , Sam S. Lightstone , Chandrasekaran Mohan , Steven R. Pearson , James J. Seeger, JR. , Richard S. Sidle , David C. Smith , Adam J. Storm
IPC分类号： G06F17/30
CPC分类号： G06F17/30315
摘要： Embodiments relate to database systems. An aspect includes deferring row insert operations until occurrence of a triggering event. One method includes receiving a row insert for a tuple into a column group store table, where the tuple includes one or more tuplets and each of the tuplets corresponds to a column group in the column group store table. The method also includes copying at least one of the tuplets into an insert buffer that is specific to one of the column groups in the column group store table. The method also includes deferring the row insert into the column group store table until an occurrence of one or more triggering events. The method also includes flushing the row insert into storage associated with the column group store table, in response to the occurrence of the one or more triggering events.
摘要翻译：实施例涉及数据库系统。一方面包括推迟行插入操作，直到发生触发事件。一种方法包括将元组的行插入接收到列组存储表中，其中元组包括一个或多个元组，并且每个元组对应于列组存储表中的列组。该方法还包括将至少一个元组复制到特定于列组存储表中的一个列组的插入缓冲器中。该方法还包括将行插入推迟到列组存储表中，直到发生一个或多个触发事件。响应于一个或多个触发事件的发生，该方法还包括将行插入刷新到与列组存储表相关联的存储器中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式