Data Read/Write Method and Apparatus for Database

    公开(公告)号:US20220300477A1

    公开(公告)日:2022-09-22

    申请号:US17837496

    申请日:2022-06-10

    Abstract: A data read/write method includes: establishing a first connection to a client, determining a first tablespace corresponding to the first connection, and determining a first node corresponding to the first connection or the first tablespace in a plurality of nodes, where the first connection receives a read/write request from the client; loading data in the first tablespace to a memory in the first node, and processing a read/write request on the first connection using a first working thread, where the first working thread is generated by a processor in the first node.

    Data transmission method and apparatus

    公开(公告)号:US10979520B2

    公开(公告)日:2021-04-13

    申请号:US15979951

    申请日:2018-05-15

    Abstract: Embodiments of the present invention relate to the database field, and in particular, to a data transmission method and apparatus, so as to reduce overheads for data transmission between nodes in a distributed database and lighten network load. In the embodiments of the present invention, a DN determines a column that has a distribution rule of parameters in the column; the DN determines, according to a data type of the parameters of the column and the distribution rule of the parameters in the column, a compression algorithm corresponding to the column; the DN compresses the column using the compression algorithm; and the DN sends a compressed column to a target node. In this way, the overheads for the data transmission between the nodes are reduced, and the network load is lightened.

    Database system lock operation method and device
    3.
    发明授权
    Database system lock operation method and device 有权
    数据库系统锁定操作方法和装置

    公开(公告)号:US09449041B2

    公开(公告)日:2016-09-20

    申请号:US14323546

    申请日:2014-07-03

    CPC classification number: G06F17/30371 G06F17/30362

    Abstract: 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.

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

    Data processing method and apparatus
    4.
    发明授权
    Data processing method and apparatus 有权
    数据处理方法和装置

    公开(公告)号:US09430198B2

    公开(公告)日:2016-08-30

    申请号:US14753232

    申请日:2015-06-29

    CPC classification number: G06F8/41 G06F9/45504 G06F17/30312 G06F21/6227

    Abstract: A data processing method and apparatus, which relate to the computer field and are capable of effectively improving scalability of a database system. The data processing method includes: receiving source code of an external routine, where the source code of the external routine is compiled by using an advanced programming language; compiling the source code to obtain intermediate code, where the intermediate code is a byte stream identifiable to a virtual machine on any operating platform; converting, according to an instruction set on the operating platform, the intermediate code into machine code capable of running on the operating platform; and storing the machine code to a database. The data processing method and apparatus provided by the embodiments of the present invention are used to process data.

    Abstract translation: 一种与计算机领域相关并且能够有效地提高数据库系统的可扩展性的数据处理方法和装置。 数据处理方法包括:接收外部例程的源代码,其中通过使用高级编程语言编译外部例程的源代码; 编译源代码以获得中间代码,其中中间代码是可在任何操作平台上为虚拟机标识的字节流; 根据操作平台上的指令,将中间代码转换成能够在操作平台上运行的机器代码; 并将机器代码存储到数据库。 由本发明实施例提供的数据处理方法和装置用于处理数据。

    LOCK MANAGEMENT METHOD AND SYSTEM, METHOD AND APPARATUS FOR CONFIGURING LOCK MANAGEMENT SYSTEM
    6.
    发明申请
    LOCK MANAGEMENT METHOD AND SYSTEM, METHOD AND APPARATUS FOR CONFIGURING LOCK MANAGEMENT SYSTEM 审中-公开
    锁定管理方法和系统,配置锁定管理系统的方法和装置

    公开(公告)号:US20160132364A1

    公开(公告)日:2016-05-12

    申请号:US14995789

    申请日:2016-01-14

    CPC classification number: G06F9/526 G06F9/46 G06F9/466 G06F9/50 G06F17/30362

    Abstract: A lock management method and system, and a method and an apparatus for configuring a lock management system is provided. A corresponding level of a lock management system is set for each service execution node according to the number of service execution nodes included in a distributed system, the number of system instances on all service execution nodes, the number of handling processes on all the service execution nodes, and a delay of access of each service execution node to a central control node of the distributed system. At least one lock manager is allocated to each service execution node separately according to the level, which is corresponding to each service execution node, of the lock management system. A lock level context is configured for each lock manager, where the lock level context is used to determine an adjacent lock manager of each lock manager.

    Abstract translation: 提供了一种锁管理方法和系统,以及用于配置锁管理系统的方法和装置。 根据分布式系统中包括的服务执行节点的数量,所有服务执行节点上的系统实例的数量,所有服务执行上的处理过程的数量,为每个服务执行节点设置相应级别的锁管理系统 节点,以及每个服务执行节点到分布式系统的中央控制节点的访问延迟。 至少一个锁管理器根据与锁管理系统的每个服务执行节点相对应的级别分别分配给每个服务执行节点。 为每个锁管理器配置锁级别上下文,其中锁级别上下文用于确定每个锁管理器的相邻锁管理器。

    Data Table Processing Method and Apparatus
    8.
    发明申请

    公开(公告)号:US20190108174A1

    公开(公告)日:2019-04-11

    申请号:US16204526

    申请日:2018-11-29

    Abstract: A data system comprising a primary server and a secondary server, where the primary server obtains a first partition instruction and a second partition instruction, partition data in a first data table according to a first partition key to obtain a first partition table, and send the second partition instruction to the secondary server. The first partition instruction includes a first partition key, and the second partition instruction includes a second partition key, which is different from the first partition key. The second partition instruction is for triggering the secondary server to partition data in a second data table on the secondary server according to the second partition key to obtain a second partition table, which is the same as the first data table.

    Lock management method and system, method and apparatus for configuring lock management system

    公开(公告)号:US10042678B2

    公开(公告)日:2018-08-07

    申请号:US14995789

    申请日:2016-01-14

    Abstract: A lock management method and system, and a method and an apparatus for configuring a lock management system is provided. A corresponding level of a lock management system is set for each service execution node according to the number of service execution nodes included in a distributed system, the number of system instances on all service execution nodes, the number of handling processes on all the service execution nodes, and a delay of access of each service execution node to a central control node of the distributed system. At least one lock manager is allocated to each service execution node separately according to the level, which is corresponding to each service execution node, of the lock management system. A lock level context is configured for each lock manager, where the lock level context is used to determine an adjacent lock manager of each lock manager.

    Data Processing Method and Apparatus
    10.
    发明申请
    Data Processing Method and Apparatus 有权
    数据处理方法与装置

    公开(公告)号:US20150301810A1

    公开(公告)日:2015-10-22

    申请号:US14753232

    申请日:2015-06-29

    CPC classification number: G06F8/41 G06F9/45504 G06F17/30312 G06F21/6227

    Abstract: A data processing method and apparatus, which relate to the computer field and are capable of effectively improving scalability of a database system. The data processing method includes: receiving source code of an external routine, where the source code of the external routine is compiled by using an advanced programming language; compiling the source code to obtain intermediate code, where the intermediate code is a byte stream identifiable to a virtual machine on any operating platform; converting, according to an instruction set on the operating platform, the intermediate code into machine code capable of running on the operating platform; and storing the machine code to a database. The data processing method and apparatus provided by the embodiments of the present invention are used to process data.

    Abstract translation: 一种与计算机领域相关并且能够有效地提高数据库系统的可扩展性的数据处理方法和装置。 数据处理方法包括:接收外部例程的源代码,其中通过使用高级编程语言编译外部例程的源代码; 编译源代码以获得中间代码,其中中间代码是可在任何操作平台上为虚拟机标识的字节流; 根据操作平台上的指令,将中间代码转换成能够在操作平台上运行的机器代码; 并将机器代码存储到数据库。 由本发明实施例提供的数据处理方法和装置用于处理数据。

Patent Agency Ranking