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

1. 发明申请

US20180203888A1 Multi-Version Concurrency Control Method in Database and Database System 审中-公开
公开(公告)号：US20180203888A1
公开(公告)日：2018-07-19
申请号：US15919469
申请日：2018-03-13
申请人： Huawei Technologies Co., Ltd.
发明人： Jijun Wen , Yuanyuan Nie , Jian Li
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F16/2322 , G06F11/1469 , G06F16/2329 , G06F16/2365 , G06F2201/84
摘要： A multi-version concurrency control method in a database and a database system is presented. The database system sets a data page link of a page, where the data page link includes a page pointer, and a page pointer is used to point to another version page prior to a last operation on the version page. In this way, when a page in the database is read, if a timestamp of a current version page is greater than a timestamp of a read transaction, page-level rollback may be directly performed according to a data page link of the page that is requested to read to roll back to a page that needs to be read, which facilitates queries for data on each version page in the database. Further, the database system may implement record rollback efficiently.

2. 发明授权

US09778998B2 Data restoration method and system 有权
公开(公告)号：US09778998B2
公开(公告)日：2017-10-03
申请号：US14660460
申请日：2015-03-17
申请人： Huawei Technologies Co., Ltd.
发明人： Jijun Wen , Yuanyuan Nie , Wentao Xu
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1469 , G06F17/30575
摘要： Embodiments of the present invention disclose a data restoration method, including: after a transaction is submitted, saving a generated transaction log to a buffer of a current node, and backing up the transaction log to a buffer of at least one backup node except the current node; writing the transaction log saved in the buffer of the current node or the transaction log backed up in the buffer of the backup node into a transaction log file in a disk, where the transaction log file in the disk is used for restoring data of the current node; and restoring, based on the transaction log file in the disk, lost data of the current node when a data loss event occurs in the current node. By means of the present invention, a risk of system data can be reduced, and durability, safety, and reliability of the system data can be improved.

3. 发明授权

US09953051B2 Multi-version concurrency control method in database and database system 有权
公开(公告)号：US09953051B2
公开(公告)日：2018-04-24
申请号：US15199181
申请日：2016-06-30
申请人： Huawei Technologies Co., Ltd.
发明人： Jijun Wen , Yuanyuan Nie , Jian Li
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30353 , G06F11/1469 , G06F17/30356 , G06F17/30371 , G06F2201/84
摘要： A multi-version concurrency control method in a database and a database system, where the database system sets a data page link of a page, where the data page link includes a page pointer, and a page pointer is used to point to another version page prior to a last operation on the version page. Hence, when a page in the database is read, and when a timestamp of a current version page is greater than a timestamp of a read transaction, page-level rollback may be directly performed according to a data page link of the page that is requested to read to roll back to a page that needs to be read, which facilitates queries for data on each version page in the database, and the database system may implement record rollback efficiently.

4. 发明授权

US09449041B2 Database system lock operation method and device 有权
标题翻译：数据库系统锁定操作方法和装置
公开(公告)号：US09449041B2
公开(公告)日：2016-09-20
申请号：US14323546
申请日：2014-07-03
申请人： Huawei Technologies Co., Ltd.
发明人： Yuanyuan Nie , Huijun Liu , Chuanting Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F17/30362
摘要： A database system lock operation method is provided that includes: acquiring, by a first processing node, a lock operand of a target lock; using, by the first processing node, the target lock to perform a lock acquiring operation on a target data object; when the lock operand meets a condition for a successful lock acquiring operation, determining, by the first processing node, that the lock acquiring operation is successful, and updating a value of a data bit that is in the lock operand and used to indicate a state of the target lock on the first processing node to a value that is used to indicate that the state of the target lock on the first processing node is lock held. Accordingly, the embodiments of the present invention further disclose a node device. The embodiments of the present invention can improve performance of a database system.
摘要翻译：提供了一种数据库系统锁操作方法，包括：由第一处理节点获取目标锁的锁操作数; 由所述第一处理节点使用所述目标锁来对目标数据对象执行锁获取操作; 当锁定操作数满足成功锁定获取操作的条件时，由第一处理节点确定锁获取操作成功，并且更新在锁操作数中的数据位的值并用于指示状态的第一处理节点上的目标锁的状态被锁定到用于指示第一处理节点上的目标锁的状态被锁定的值。因此，本发明的实施例进一步公开了节点设备。本发明的实施例可以提高数据库系统的性能。

5. 发明申请

US20150254264A1 Method for Recording Transaction Log, and Database Engine 有权
标题翻译：记录事务日志和数据库引擎的方法
公开(公告)号：US20150254264A1
公开(公告)日：2015-09-10
申请号：US14721600
申请日：2015-05-26
申请人： Huawei Technologies Co., Ltd.
发明人： Wei Yu , Huijun Liu , Yuanyuan Nie
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30097 , G06F11/1469 , G06F17/30 , G06F17/30109 , G06F17/30368 , G06F17/30371 , G06F17/30575 , G06F2201/80
摘要： A method for recording a transaction log, and a database engine, and pertains to the field of database technologies. The method includes receiving an structured query language (SQL) request; modifying, according to the SQL request, a data page corresponding to the SQL request; generating a corresponding transaction log for the modifying; partitioning the transaction log to obtain a plurality of log segments; and writing the plurality of log segments into a plurality of log buffers, and writing the log segments in the plurality of log buffers into a log file in parallel. According to the present invention, not only lock granularities of the log buffers of the transaction log are reduced, but also a speed at which a log file is written into a magnetic disk is greatly increased, thereby improving performance of a database system and enhancing user experience.
摘要翻译：用于记录事务日志的方法和数据库引擎，并且涉及数据库技术领域。该方法包括接收结构化查询语言（SQL）请求; 根据SQL请求修改与SQL请求对应的数据页; 生成相应的事务日志进行修改; 划分事务日志以获得多个日志段; 以及将所述多个日志段写入到多个日志缓冲器中，并且将所述多个日志缓冲器中的日志段并行地写入日志文件。根据本发明，不仅减少了事务日志的日志缓冲器的粒度，而且大大增加了将日志文件写入磁盘的速度，从而提高了数据库系统的性能并增强了用户经验。

6. 发明授权

US10331652B2 Method and apparatus for determining hot page in database 有权
公开(公告)号：US10331652B2
公开(公告)日：2019-06-25
申请号：US15344181
申请日：2016-11-04
申请人： Huawei Technologies Co., Ltd.
发明人： Haifeng Li , Yuanyuan Nie , Chunxin Yang
IPC分类号： G06F3/06 , G06F16/23 , G06F16/22 , G06F16/21
摘要： The present invention provides a method for determining a hot page in a database. The method includes: when the database is accessed, configuring a counter for each of N pages in the database, where each counter is used to count a quantity of times of concurrent access to a page corresponding to the counter, the concurrent access means that at least one read command or write command accessing the page needs to wait for accessing the page, the N pages are all pages in the database or N pages in the database, and N is a positive integer; and calculating, according to a quantity of times of concurrent access to the Kth page and an access time parameter, whether frequency of concurrent access to the Kth page exceeds a specific threshold, so as to determine that the Kth page is a hot page.

7. 发明申请

US20160314161A1 Multi-Version Concurrency Control Method in Database and Database System 有权
标题翻译：数据库和数据库系统中的多版本并发控制方法
公开(公告)号：US20160314161A1
公开(公告)日：2016-10-27
申请号：US15199181
申请日：2016-06-30
申请人： Huawei Technologies Co., Ltd.
发明人： Jijun Wen , Yuanyuan Nie , Jian Li
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30353 , G06F11/1469 , G06F17/30356 , G06F17/30371 , G06F2201/84
摘要： A multi-version concurrency control method in a database and a database system, where the database system sets a data page link of a page, where the data page link includes a page pointer, and a page pointer is used to point to another version page prior to a last operation on the version page. Hence, when a page in the database is read, and when a timestamp of a current version page is greater than a timestamp of a read transaction, page-level rollback may be directly performed according to a data page link of the page that is requested to read to roll back to a page that needs to be read, which facilitates queries for data on each version page in the database, and the database system may implement record rollback efficiently.
摘要翻译：数据库和数据库系统中的多版本并发控制方法，其中数据库系统设置页面的数据页面链接，其中数据页面链接包括页面指针，并且页面指针用于指向另一个版本页面在版本页面上的最后一个操作之前。因此，当读取数据库中的页面时，当当前版本页面的时间戳大于读取事务的时间戳时，可以根据所请求的页面的数据页链接直接执行页面级回滚读取回滚到需要读取的页面，这有助于查询数据库中每个版本页面上的数据，数据库系统可以有效地实现记录回滚。

8. 发明申请

US20160203197A1 Method and System for Automatic Management of Dynamically Allocated Memory in a Computing Unit 审中-公开
标题翻译：计算单元动态分配存储器自动管理方法与系统
公开(公告)号：US20160203197A1
公开(公告)日：2016-07-14
申请号：US15079309
申请日：2016-03-24
申请人： Huawei Technologies Co., Ltd.
发明人： Kumar Rajeev Rastogi , Amit Kapila , Dilip Kumar , Yuanyuan Nie
IPC分类号： G06F17/30
CPC分类号： G06F16/254 , G06F16/1727 , G06F16/23 , G06F16/2308 , G06F16/2379
摘要： A method and system for automatic management of dynamically allocated memory in a computer where the system comprises one or more client machines, a communication network and a computer. The one or more users provide one or more queries to access data from the computer and the client machines send the received queries to the computer through the communication network. The processor configured in the computer creates a heap record upon identifying the received queries to be at least one INSERT, DELETE and first type of UPDATE. The heap record is stored in data segment of the one or more databases and when the received queries is second type of UPDATE, the processor creates an undo record and stores the undo record in undo segment of the databases.
摘要翻译：一种用于在计算机中动态分配的存储器的自动管理的方法和系统，其中系统包括一个或多个客户端机器，通信网络和计算机。一个或多个用户提供一个或多个查询以从计算机访问数据，并且客户端机器通过通信网络将接收到的查询发送到计算机。在计算机中配置的处理器在识别接收到的查询时将创建一个堆记录，以至少是一个INSERT，DELETE和第一种类型的UPDATE。堆记录存储在一个或多个数据库的数据段中，当接收到的查询是UPDATE的第二种类型时，处理器创建一个撤销记录，并将撤销记录存储在数据库的撤销段中。

9. 发明申请

US20170351667A1 TRANSACTION PROCESSING METHOD, PROCESSING NODE, CENTRAL NODE, AND CLUSTER 审中-公开
公开(公告)号：US20170351667A1
公开(公告)日：2017-12-07
申请号：US15686633
申请日：2017-08-25
申请人： Huawei Technologies Co., Ltd.
发明人： Yuanyuan Nie , Jijun Wen , Jian Li
IPC分类号： G06F17/30
CPC分类号： G06F16/2308 , G06F16/00 , G06F16/128
摘要： The disclosure discloses a transaction processing method, a processing node, and a central node. The method includes: receiving, by the processing node in the cluster, global snapshot information according to a preset time interval, where the global snapshot information includes a transaction identifier of a running transaction in a cluster; storing the received global snapshot information in a cache; and processing the transaction according to the global snapshot information stored in the cache. In the transaction processing method, a central node in a cluster sends latest global snapshot information to each processing node according to a preset time interval, so that the processing node can store the global snapshot information. When applying for global snapshot information during transaction processing, the processing node does not need to obtain latest snapshot information from the central node. Therefore, network overheads can be reduced, and transaction processing efficiency can be improved.

10. 发明申请

US20170132268A1 METHOD AND APPARATUS FOR DETERMINING HOT PAGE IN DATABASE 审中-公开
公开(公告)号：US20170132268A1
公开(公告)日：2017-05-11
申请号：US15344181
申请日：2016-11-04
申请人： Huawei Technologies Co., Ltd.
发明人： Haifeng Li , Yuanyuan Nie , Chunxin Yang
IPC分类号： G06F17/30
CPC分类号： G06F16/2322 , G06F3/061 , G06F3/0653 , G06F3/0656 , G06F16/217 , G06F16/22 , G06F16/2336
摘要： The present invention provides a method for determining a hot page in a database. The method includes: when the database is accessed, configuring a counter for each of N pages in the database, where each counter is used to count a quantity of times of concurrent access to a page corresponding to the counter, the concurrent access means that at least one read command or write command accessing the page needs to wait for accessing the page, the N pages are all pages in the database or N pages in the database, and N is a positive integer; and calculating, according to a quantity of times of concurrent access to the Kth page and an access time parameter, whether frequency of concurrent access to the Kth page exceeds a specific threshold, so as to determine that the Kth page is a hot page.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式