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

21. 发明授权

US09734173B2 Assignment of data temperatures in a fragmented data set 有权
公开(公告)号：US09734173B2
公开(公告)日：2017-08-15
申请号：US13797785
申请日：2013-03-12
申请人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
发明人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30312 , G06F17/30345
摘要： A plurality of data records that comprise a data set can be stored in a plurality of main part fragments such that each main part fragment includes a subset of the set of data records. Each fragment of the plurality of main part fragments can be assigned a relative data temperature. A newly arrived data record for storage in the data set can be placed in a delta part, and a merge can be performed to add the newly arrived data record to a corresponding main part fragment. The performing of the merge can occur more quickly if the corresponding main part fragment has a higher relative data temperature than if the corresponding main part fragment has a lower relative data temperature.

22. 发明申请

US20160147776A1 ALTERING DATA TYPE OF A COLUMN IN A DATABASE 审中-公开
标题翻译：更改数据库中的列的数据类型
公开(公告)号：US20160147776A1
公开(公告)日：2016-05-26
申请号：US14552902
申请日：2014-11-25
申请人： Colin Florendo , Ivan Schreter , Panfeng Zhou , David Wein , Steffen Geissinger , Michael Muehle
发明人： Colin Florendo , Ivan Schreter , Panfeng Zhou , David Wein , Steffen Geissinger , Michael Muehle
IPC分类号： G06F17/30
摘要： Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.
摘要翻译：这里公开了用于改变数据库中的列的数据类型的系统，方法和计算机程序产品实施例。实施例通过将与列相关联的原始字典转换为新字典来操作。新字典使用不同的数据类型存储原始字典的值。然后，将包含原始字典的键的索引向量更新为包含新字典的相关键。由于原始字典的大小通常远小于相关列中的行数，因此该字典转换会降低数据库系统的更改列数据类型的计算成本，并减少或甚至最小化用户数据库停机时间。

23. 发明申请

US20160147748A1 MOVING TABLES ACROSS NODES IN AN IN-MEMORY DATABASE INSTANCE 有权
标题翻译：内存数据库中的动态表格
公开(公告)号：US20160147748A1
公开(公告)日：2016-05-26
申请号：US14549806
申请日：2014-11-21
申请人： Colin Florendo , Ivan Schreter
发明人： Colin Florendo , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/303 , G06F17/30339 , G06F17/30958
摘要： The present disclosure involves systems, software, and computer implemented methods for moving a table from a source node to a destination node. In one example, the method includes receiving metadata associated with an in-memory database table stored at a source node. A table container is created responsive to receiving the metadata. The destination node sequentially requests, from the source node, portions of the table, wherein the table is serialized at the source node to provide a serialized sequence of table portions. Sequentially requesting comprises sending a request for a next portion of the table after processing a received portion, which includes receiving a portion of the serialized table, deserializing the received portion, adding the deserialized portion to the created table container, and in response to an end of file indication associated with the received portion, ending the requests and finalizing the table.
摘要翻译：本公开涉及用于将表从源节点移动到目的地节点的系统，软件和计算机实现的方法。在一个示例中，该方法包括接收与存储在源节点处的存储器内数据库表相关联的元数据。响应于接收元数据创建表容器。目的地节点从源节点顺序地请求表的部分，其中表在源节点被序列化以提供表部分的序列化序列。顺序请求包括在处理接收到的部分之后发送对表的下一部分的请求，其包括接收序列化表的一部分，对接收到的部分进行反序列化，将反序列化部分添加到创建的表容器中，并响应于结束与所接收的部分相关联的文件指示，结束请求并完成表格。

24. 发明申请

US20140279961A1 UNIFIED ARCHITECTURE FOR HYBRID DATABASE STORAGE USING FRAGMENTS 有权
标题翻译：使用片段的混合数据库存储的统一架构
公开(公告)号：US20140279961A1
公开(公告)日：2014-09-18
申请号：US13797676
申请日：2013-03-12
申请人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
发明人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
IPC分类号： G06F17/30
CPC分类号： G06F3/0661 , G06F3/0608 , G06F3/0673 , G06F17/30153 , G06F17/30312 , G06F17/30315 , G06F17/30339 , G06F17/30345 , G06F17/30486
摘要： Data records of a data set can be stored in multiple main part fragments retained in on-disk storage. Each fragment can include a number of data records that is equal to or less than a defined maximum fragment size. Using a compression that is optimized for each fragment, each fragment can be compressed. After reading at least one of the fragments into main system memory from the on-disk storage, an operation can be performed on the fragment or fragments while the in the main system memory.
摘要翻译：数据集的数据记录可以存储在保留在磁盘存储中的多个主要部分片段中。每个片段可以包括等于或小于所定义的最大片段大小的多个数据记录。使用针对每个片段优化的压缩，可以压缩每个片段。在从磁盘存储器读入主系统存储器中的至少一个片段之后，可以在主系统存储器中对片段或片段执行操作。

25. 发明授权

US09348833B2 Consolidation for updated/deleted records in old fragments 有权
标题翻译：整合旧片段中更新/删除的记录
公开(公告)号：US09348833B2
公开(公告)日：2016-05-24
申请号：US13797710
申请日：2013-03-12
申请人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
发明人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30153 , G06F17/30135 , G06F17/30162
摘要： A plurality of data records of a data set can be stored in a plurality of main part fragments, at least one of which is an old fragment stored on-disk. A number of one or more data records in the old fragment that have been marked for deletion can be determined to be greater than a threshold number, and the old fragment can be loaded into main system memory. A merge of the old fragment can be performed to remove the one or more data records marked for deletion.
摘要翻译：数据组的多个数据记录可以存储在多个主要部分片段中，其中至少一个是存储在磁盘上的旧片段。已经标记为删除的旧片段中的一个或多个数据记录可以被确定为大于阈值数，并且旧片段可以被加载到主系统存储器中。可以执行旧片段的合并，以删除标记为删除的一个或多个数据记录。

26. 发明申请

US20140279962A1 CONSOLIDATION FOR UPDATED/DELETED RECORDS IN OLD FRAGMENTS 有权
标题翻译：旧版本更新/删除记录的综合
公开(公告)号：US20140279962A1
公开(公告)日：2014-09-18
申请号：US13797710
申请日：2013-03-12
申请人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
发明人： Ivan Schreter , Dirk Thomsen , Colin Florendo , Blaine French
IPC分类号： G06F17/30
CPC分类号： G06F17/30153 , G06F17/30135 , G06F17/30162
摘要： A plurality of data records of a data set can be stored in a plurality of main part fragments, at least one of which is an old fragment stored on-disk. A number of one or more data records in the old fragment that have been marked for deletion can be determined to be greater than a threshold number, and the old fragment can be loaded into main system memory. A merge of the old fragment can be performed to remove the one or more data records marked for deletion.
摘要翻译：数据组的多个数据记录可以存储在多个主要部分片段中，其中至少一个是存储在磁盘上的旧片段。已经标记为删除的旧片段中的一个或多个数据记录可以被确定为大于阈值数，并且旧的片段可以被加载到主系统存储器中。可以执行旧片段的合并，以删除标记为删除的一个或多个数据记录。

27. 发明授权

US08713046B2 Snapshot isolation support for distributed query processing in a shared disk database cluster 有权
标题翻译：快照隔离支持共享磁盘数据库集群中的分布式查询处理
公开(公告)号：US08713046B2
公开(公告)日：2014-04-29
申请号：US13309603
申请日：2011-12-02
申请人： Surendra Kumar Vishnoi , Colin Florendo
发明人： Surendra Kumar Vishnoi , Colin Florendo
IPC分类号： G06F17/30
CPC分类号： G06F17/30362
摘要： System, method, computer program product embodiments and combinations and sub-combinations thereof for snapshot isolation support for distributed query processing in a shared disk database cluster are provided. The embodiments include the forming of object identification data in a leader node of query execution in the shared disk database cluster. At least one fragment of the query execution is distributed to at least one worker node in the shared disk database cluster, and the object identification data is utilized for multiversion concurrency control during query execution by the leader node and at least one worker node.
摘要翻译：提供了用于共享磁盘数据库集群中的分布式查询处理的快照隔离支持的系统，方法，计算机程序产品实施例及其组合和子组合。实施例包括在共享磁盘数据库集群中的查询执行的前导节点中形成对象标识数据。查询执行的至少一个片段被分发到共享磁盘数据库集群中的至少一个工作节点，并且对象标识数据被用于在由前导节点和至少一个工作节点执行查询期间的多版本并发控制。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式