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

1. 发明授权

US09189487B2 Method for recording transaction log, and database engine 有权
标题翻译：记录事务日志和数据库引擎的方法
公开(公告)号：US09189487B2
公开(公告)日：2015-11-17
申请号：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请求对应的数据页; 生成相应的事务日志进行修改; 划分事务日志以获得多个日志段; 以及将所述多个日志段写入到多个日志缓冲器中，并且将所述多个日志缓冲器中的日志段并行地写入日志文件。根据本发明，不仅减少了事务日志的日志缓冲器的粒度，而且大大增加了将日志文件写入磁盘的速度，从而提高了数据库系统的性能并增强了用户经验。

2. 发明申请

US20140372396A1 Database System Lock Operation Method and Device 有权
标题翻译：数据库系统锁定操作方法和设备
公开(公告)号：US20140372396A1
公开(公告)日：2014-12-18
申请号：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.
摘要翻译：提供了一种数据库系统锁操作方法，包括：由第一处理节点获取目标锁的锁操作数; 由所述第一处理节点使用所述目标锁来对目标数据对象执行锁获取操作; 当锁定操作数满足成功锁定获取操作的条件时，由第一处理节点确定锁获取操作成功，并且更新在锁操作数中的数据位的值并用于指示状态的第一处理节点上的目标锁的状态被锁定到用于指示第一处理节点上的目标锁的状态被锁定的值。因此，本发明的实施例进一步公开了节点设备。本发明的实施例可以提高数据库系统的性能。

3. 发明授权

US10860447B2 Database cluster architecture based on dual port solid state disk 有权
公开(公告)号：US10860447B2
公开(公告)日：2020-12-08
申请号：US16455087
申请日：2019-06-27
申请人： Huawei Technologies Co., Ltd.
发明人： Wei Yu , Huijun Liu
IPC分类号： G06F11/00 , G06F11/20 , G06F16/11 , G06F16/17 , G06F16/00 , G06F3/06 , G06F11/14
摘要： A database cluster architecture based on dual port solid state disk (SSD) is provided. The database cluster includes a plurality of nodes and a plurality of dual port solid state disks (SSDs). Each dual port SSD of the plurality of dual port SSDs is connected to a unique pair of nodes and each node in the unique pair of nodes is connected to a unique pair of dual port SSDs. A first node of the plurality of nodes writes a transaction log to a first dual port SSD, a second node connected to the first dual port SSD acquires the transaction log from the first dual port SSD and operates a database process to recover data according to the transaction log when the first node crashes.

4. 发明申请

US20190391978A1 Object Encoding and Computation Method in Database System and Database Server 审中-公开
公开(公告)号：US20190391978A1
公开(公告)日：2019-12-26
申请号：US16559245
申请日：2019-09-03
申请人： Huawei Technologies Co., Ltd.
发明人： Huijun Liu , Cong Meng , Chaowei Zhang
IPC分类号： G06F16/2453 , G06F16/22
摘要： An object encoding and computation method in a database system, where a global object sample space is constituted based on correlation between a plurality of object sample spaces in a database. A global dictionary table is created in the global object sample space to provide a globally unique encoding value for each object, set the encoding value as an object identifier (ID) of the object, and ensure that the object ID and object description information are in a one-to-one mapping relationship. The database object is encoded and compressed based on the global dictionary table. Further, the object ID is directly used for database query computation.

5. 发明授权

US10379977B2 Data management method, node, and system for database cluster 有权
公开(公告)号：US10379977B2
公开(公告)日：2019-08-13
申请号：US15365728
申请日：2016-11-30
申请人： Huawei Technologies Co., Ltd.
发明人： Wei Yu , Huijun Liu
IPC分类号： G06F11/00 , G06F11/20 , G06F16/11 , G06F16/17 , G06F3/06 , G06F16/00 , G06F11/14
摘要： The present disclosure provides a data management method for a database cluster including a first dual port SSD, a second dual port SSD, a first node, a second node, and a third node, where the first dual port SSD is connected to the first node and the second node, and the second dual port SSD is connected to the second node and the third node; and the first node writes a transaction log to the first dual port SSD, when the first node crashes, the second node acquires the transaction log from the first dual port SSD, and operates, according to the transaction log, data that is stored in the first node, so that, the second node or the third node can use a dual port SSD to read log information of the crashed node, and replace the first node to provide a service externally.

6. 发明申请

US20160239542A1 Method, Apparatus, and System for Storing Execution Plan 审中-公开
标题翻译：存储执行计划的方法，设备和系统
公开(公告)号：US20160239542A1
公开(公告)日：2016-08-18
申请号：US15136472
申请日：2016-04-22
申请人： Huawei Technologies Co., Ltd.
发明人： Wei Yu , Jijun Wen , Huijun Liu
IPC分类号： G06F17/30 , H04L29/08
CPC分类号： G06F16/24542 , H04L67/2842
摘要： A method, apparatus, and system for storing an execution plan, and relate to the field of databases, which may improve a cache hit rate of an execution plan and reduce system overheads. The method includes sending, by the client, a structured query language (SQL) request and generated location information to the database server, and according to the received SQL request and the received location information, generating and executing, by the database server, an execution plan corresponding to the SQL request, and saving the execution plan to a cache indicated by the location information. The location information may indicate a location of a cache of a client or a cache of a database server.
摘要翻译：一种用于存储执行计划并涉及数据库领域的方法，装置和系统，其可以提高执行计划的高速缓存命中率并减少系统开销。该方法包括由客户端向数据库服务器发送结构化查询语言（SQL）请求和生成的位置信息，并且根据接收的SQL请求和接收的位置信息，由数据库服务器生成和执行执行计划对应于SQL请求，并将执行计划保存到由位置信息指示的高速缓存。位置信息可以指示客户机的高速缓存或数据库服务器的高速缓存的位置。

7. 发明授权

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.
摘要翻译：提供了一种数据库系统锁操作方法，包括：由第一处理节点获取目标锁的锁操作数; 由所述第一处理节点使用所述目标锁来对目标数据对象执行锁获取操作; 当锁定操作数满足成功锁定获取操作的条件时，由第一处理节点确定锁获取操作成功，并且更新在锁操作数中的数据位的值并用于指示状态的第一处理节点上的目标锁的状态被锁定到用于指示第一处理节点上的目标锁的状态被锁定的值。因此，本发明的实施例进一步公开了节点设备。本发明的实施例可以提高数据库系统的性能。

8. 发明申请

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请求对应的数据页; 生成相应的事务日志进行修改; 划分事务日志以获得多个日志段; 以及将所述多个日志段写入到多个日志缓冲器中，并且将所述多个日志缓冲器中的日志段并行地写入日志文件。根据本发明，不仅减少了事务日志的日志缓冲器的粒度，而且大大增加了将日志文件写入磁盘的速度，从而提高了数据库系统的性能并增强了用户经验。

9. 发明授权

US09460186B2 Database management method and system 有权
标题翻译：数据库管理方法和系统
公开(公告)号：US09460186B2
公开(公告)日：2016-10-04
申请号：US14956666
申请日：2015-12-02
申请人： Huawei Technologies Co., Ltd.
发明人： Huijun Liu , Zhongqing Xu , Junnan Gao
IPC分类号： G06F17/30
CPC分类号： G06F17/30584 , G06F17/30463 , G06F17/30477 , G06F17/30554
摘要： A database management method and system. The method includes dividing, by a database system, a data partition into a physical partition layer and a logical partition layer, wherein the logical partition segment and the physical partition segment are mapped to each other using a mapping relationship; receiving, by the database system, a data operation instruction of a user, and determining a logical partition segment to which a data record that is requested for operation by the data operation instruction belongs; determining, according to the data operation instruction and the mapping relationship, a physical partition segment that is corresponding to the determined logical partition segment and at the physical partition layer to perform an operation on the data record that is requested for operation by the data operation instruction.
摘要翻译：数据库管理方法和系统。该方法包括将数据库系统划分为物理分区层和逻辑分区层，其中使用映射关系将逻辑分区段和物理分区段映射到彼此; 由数据库系统接收用户的数据操作指令，并且确定由数据操作指令所请求操作的数据记录所属的逻辑分区段; 根据数据操作指令和映射关系，确定与所确定的逻辑分区段相对应的物理分区段，并在物理分区层处对由数据操作指令请求操作的数据记录执行操作。

10. 发明授权

US11194806B2 Object encoding and computation method in database system and database server 有权
公开(公告)号：US11194806B2
公开(公告)日：2021-12-07
申请号：US16559245
申请日：2019-09-03
申请人： Huawei Technologies Co., Ltd.
发明人： Huijun Liu , Cong Meng , Chaowei Zhang
IPC分类号： G06F16/2453 , G06F16/22
摘要： An object encoding and computation method in a database system, where a global object sample space is constituted based on correlation between a plurality of object sample spaces in a database. A global dictionary table is created in the global object sample space to provide a globally unique encoding value for each object, set the encoding value as an object identifier (ID) of the object, and ensure that the object ID and object description information are in a one-to-one mapping relationship. The database object is encoded and compressed based on the global dictionary table. Further, the object ID is directly used for database query computation.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式