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

21. 发明申请

US20150242451A1 Database Table Re-Partitioning Using Two Active Partition Specifications 审中-公开
标题翻译：使用两个活动分区规范的数据库表重新分区
公开(公告)号：US20150242451A1
公开(公告)日：2015-08-27
申请号：US14188541
申请日：2014-02-24
申请人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
发明人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
IPC分类号： G06F17/30
CPC分类号： G06F17/30584 , G06F17/30578
摘要： Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将数据库表的源分区分区到目标分区。此后，指定了标识源分区和目标分区的转换分区规范。然后将数据从源分区移动（例如异步移动等）到目标分区。同时随着数据的移动，操作使用转换分区规范进行处理。随后，当所有数据已被移动到目标分区并且没有访问源分区的打开事务时，源分区将被丢弃。还描述了相关设备，系统，技术和物品。

22. 发明申请

US20150149426A1 TRANSACTION COMMIT OPERATIONS WITH THREAD DECOUPLING AND GROUPING OF I/O REQUESTS 审中-公开
标题翻译：具有螺纹解除和I / O要求分组的交易提交操作
公开(公告)号：US20150149426A1
公开(公告)日：2015-05-28
申请号：US14255807
申请日：2014-04-17
申请人： Kyu Hwan Kim , Juchang Lee
发明人： Kyu Hwan Kim , Juchang Lee
IPC分类号： G06F9/46 , G06F3/06 , G06F17/30
CPC分类号： G06F9/467 , G06F3/0604 , G06F3/0655 , G06F3/0674 , G06F17/30312 , G06F17/30371 , G06F17/30377 , G06F2003/0697
摘要： Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.
摘要翻译：在分布式数据库系统中将事务交付到磁盘时，服务器端处理领域的创新可以提高数据库节点的计算效率和/或降低网络带宽利用率。例如，当在数据库系统中提交事务时，在数据库系统的主节点处，服务器使用不同的线程进行某些处理器密集型操作和某些I / O密集型操作。或者，作为另一个例子，当在数据库系统中提交事务时，在数据库系统的主节点处，服务器对I / O请求进行分组作业。

23. 发明申请

US20150149409A1 DML REPLICATION WITH LOGICAL LOG SHIPPING 有权
标题翻译： DML代理与LOGICAL LOG船运
公开(公告)号：US20150149409A1
公开(公告)日：2015-05-28
申请号：US14302320
申请日：2014-06-11
申请人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
发明人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： Technologies are described for performing replication within a database environment. For example, replication of database data can be performed using data manipulation language (DML) statements and logical logs. A database node can execute a DML statement, create a logical log comprising the DML statement, and insert the logical log into a logical log queue. The logical log can be sent to one or more other database nodes for execution of the DML statement stored within the logical log. Logical logs can be grouped for sending to other nodes. Logical logs can be executed on a first node and one or more other nodes within the same transaction boundary. Execution of DML statements can be decoupled from sending, receiving, grouping, and/or processing of logical logs.
摘要翻译：描述了在数据库环境中执行复制的技术。例如，可以使用数据操作语言（DML）语句和逻辑日志来执行数据库数据的复制。数据库节点可以执行DML语句，创建包含DML语句的逻辑日志，并将逻辑日志插入到逻辑日志队列中。可以将逻辑日志发送到一个或多个其他数据库节点，以执行逻辑日志中存储的DML语句。逻辑日志可以分组发送到其他节点。逻辑日志可以在同一事务边界内的第一个节点和一个或多个其他节点上执行。 DML语句的执行可以与逻辑日志的发送，接收，分组和/或处理分离。

24. 发明申请

US20140297686A1 CLIENT-SIDE STATEMENT ROUTING IN DISTRIBUTED DATABASE 有权
标题翻译：分布式数据库中的客户端声明路由
公开(公告)号：US20140297686A1
公开(公告)日：2014-10-02
申请号：US14306963
申请日：2014-06-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30477
摘要： A system includes reception of a first query from a client device at a first database node of a database instance comprising two or more database nodes, determination of a second database node of the two or more database nodes associated with the first query, compilation of the first query at the first database node to generate first compiled code, and transmission of the first compiled code and a first identifier of the second database node from the first database node to the client device.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

25. 发明申请

US20140222418A1 FIXED STRING DICTIONARY 审中-公开
标题翻译：固定字典
公开(公告)号：US20140222418A1
公开(公告)日：2014-08-07
申请号：US13874327
申请日：2013-04-30
申请人： Martin Richtarsky , Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Martin Richtarsky , Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/27
CPC分类号： G06F16/367 , G06F16/22 , G06F16/221 , G06F16/2228 , G06F16/313 , G06F16/36
摘要： The subject matter described herein relates to implementation of a dictionary in a column-based, in-memory database where values are not stored directly, rather, for each column, a dictionary is created with all distinct values. For each row, a reference to the corresponding value in the dictionary is stored. In one aspect, data is stored in a memory structure organized in a column store format defined by a plurality of columns and a plurality of rows. A dictionary for each column in the memory structure is generated. The dictionary has distinct values for each column. A reference to the dictionary is generated for each column in the memory structure. The dictionary and the reference to the dictionary are stored in the memory structure.
摘要翻译：本文描述的主题涉及在基于列的存储器内数据库中实现字典，其中值不直接存储，而是对于每一列，创建具有所有不同值的字典。对于每一行，存储对字典中对应值的引用。在一个方面，数据被存储在以由多个列和多行定义的列存储格式组织的存储器结构中。生成内存结构中每列的字典。字典对于每一列都有不同的值。为存储器结构中的每个列生成对字典的引用。字典和对字典的引用存储在存储器结构中。

26. 发明申请

US20140156619A1 Locking Protocol for Partitioned and Distributed Tables 有权
标题翻译：分区和分布式表的锁定协议
公开(公告)号：US20140156619A1
公开(公告)日：2014-06-05
申请号：US13750194
申请日：2013-01-25
申请人： Juchang LEE , Jin Yeon Lee , Yongjae Chuh , Jaeyun Noh
发明人： Juchang LEE , Jin Yeon Lee , Yongjae Chuh , Jaeyun Noh
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30008 , G06F17/30362
摘要： Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.
摘要翻译：本文公开了用于为分区和分布式数据库表提供锁定协议的系统，方法和计算机程序产品实施例。锁定方法包括由至少一个处理器执行第二节点上的第一数据库事务，尝试以有意的排他模式获取和获取第二节点上的锁定，由至少一个处理器执行第二数据库事务在第一节点上，以独占模式获取第一节点上的锁定，并且以排他模式等待获取第二节点上的锁定，由至少一个处理器将第一数据库事务路由到第一节点，并且不成功地尝试获得第一节点上的锁并由至少一个处理器提交第一数据库事务。

27. 发明申请

US20140149368A1 Compressed Representation of a Transaction Token 有权
标题翻译：压缩表示事务令牌
公开(公告)号：US20140149368A1
公开(公告)日：2014-05-29
申请号：US13760850
申请日：2013-02-06
申请人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
发明人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30286 , G06F17/30356
摘要： Methods, systems and computer-readable storage mediums encoded with computer programs executed by one or more processors for providing a compressed representation of a transaction token are disclosed. In an embodiment, a transaction token maintains statues of transaction to a database in a first data structure and a second data structure. The first data structure includes a plurality of identifiers respectively corresponding to the transactions to the database and a corresponding status of each identifier indicating whether a given transaction is open or closed, wherein the plurality of identifiers is maintained below a threshold number of identifiers. The second data structure includes a plurality of identifiers of transactions to the database beyond the threshold and whose status is open.
摘要翻译：公开了由用于提供交易令牌的压缩表示的一个或多个处理器执行的计算机程序编码的方法，系统和计算机可读存储介质。在一个实施例中，交易令牌将事务的雕像以第一数据结构和第二数据结构维护到数据库。第一数据结构包括分别对应于数据库的事务的多个标识符以及指示给定事务是打开还是关闭的每个标识符的对应状态，其中多个标识符被维持在阈值数量的标识符之下。第二数据结构包括多个到数据库的事务的标识符超出阈值并且其状态是开放的。

28. 发明授权

US08700660B2 Client-side statement routing for partitioned tables 有权
标题翻译：分区表的客户端语句路由
公开(公告)号：US08700660B2
公开(公告)日：2014-04-15
申请号：US13449063
申请日：2012-04-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A system includes reception of a first query from a client device at a first database node of a database instance comprising two or more database nodes, the first query specifying a first database table which is partitioned among two or more of the two or more database nodes, determination of first partitioning metadata of the first database table, the first partitioning metadata usable to identify one of the two or more database nodes based on table key values, compilation of the first query at the first database node to generate first compiled code, and transmission of the first compiled code and the first partitioning metadata from the first database node to the client device.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，第一查询指定在两个或多个数据库节点中的两个或更多个数据库节点之间划分的第一数据库表确定所述第一数据库表的第一分区元数据，所述第一分区元数据可用于基于表键值识别所述两个或多个数据库节点中的一个，所述第一数据库节点处的第一查询的编译以生成第一编译代码;以及将第一编译代码和第一分区元数据从第一数据库节点传输到客户端设备。

29. 发明授权

US08442962B2 Distributed transaction management using two-phase commit optimization 有权
标题翻译：使用两阶段提交优化的分布式事务管理
公开(公告)号：US08442962B2
公开(公告)日：2013-05-14
申请号：US12980178
申请日：2010-12-28
申请人： Juchang Lee , Michael Muehle
发明人： Juchang Lee , Michael Muehle
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30371 , G06F9/466
摘要： A computer-implemented method, a computer-readable medium and a system are provided. A transaction master for each of a plurality of transactions of a database is provided. Each transaction master is configured to communicate with at least one transaction slave to manage execution of a transaction in the plurality of transactions. Each transaction master configured to perform generating a transaction token to specify data to be visible for a transaction on the database, the transaction token including a transaction identifier for identifying whether the transaction is a committed transaction or an uncommitted transaction, receiving a request to commit the transaction, initiating, based on the request, a two-phase commit operation to commit the transaction. The two-phase commit operation includes preparing for committing the transaction, writing a committed transaction to a memory, optimizing the two-phase commit operation by omitting a phase of the two-phase commit operation, generating an acknowledgement of the committed transaction. The plurality of transactions of the database are executed with each transaction master.
摘要翻译：提供了计算机实现的方法，计算机可读介质和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。每个事务主机被配置为执行生成事务令牌以指定对数据库上的事务可见的数据，该事务令牌包括用于识别事务是提交的事务还是未提交的事务的事务标识符，接收提交请求事务，根据请求发起一个两阶段提交操作来提交事务。两阶段提交操作包括准备提交事务，将已提交事务写入存储器，通过省略两阶段提交操作的阶段来优化两阶段提交操作，生成已提交事务的确认。数据库的多个事务与每个事务主机一起执行。

30. 发明申请

US20120167098A1 Distributed Transaction Management Using Optimization Of Local Transactions 有权
标题翻译：使用优化本地事务的分布式事务管理
公开(公告)号：US20120167098A1
公开(公告)日：2012-06-28
申请号：US12980208
申请日：2010-12-28
申请人： Juchang Lee , Michael Muehle , Jaeyun Noh
发明人： Juchang Lee , Michael Muehle , Jaeyun Noh
IPC分类号： G06F9/46
CPC分类号： G06F17/30377
摘要： A computer-implemented method, a computer program product, and a system are provided. A transaction master for each of a plurality of transactions of a database is provided. Each transaction master is configured to communicate with at least one transaction slave to manage execution a transaction in the plurality of transactions. A transaction token that specifies data to be visible for the transaction on the database is generated. The transaction token includes a transaction identifier for identifying whether the transaction is a committed transaction or an uncommitted transaction. The transaction master is configured to update the transaction token after execution of the transaction. A determination whether the transaction can be executed on the at least one transaction slave without accessing data specified by the transaction token is made. The transaction is executed on the at least one transaction slave using a transaction token stored at the at least one transaction slave.
摘要翻译：提供了计算机实现的方法，计算机程序产品和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。生成一个事务令牌，用于指定对数据库上的事务可见的数据。交易令牌包括用于识别交易是承诺交易还是未提交交易的交易标识符。事务主机被配置为在执行事务之后更新事务令牌。确定是否可以在不访问由交易令牌指定的数据的情况下在至少一个事务从属方上执行事务。使用存储在所述至少一个事务从属单元处的事务令牌在所述至少一个事务从属单元上执行事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式