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

11. 发明授权

US09977802B2 Large string access and storage 有权
公开(公告)号：US09977802B2
公开(公告)日：2018-05-22
申请号：US14524998
申请日：2014-10-27
申请人： Colin Florendo , Ivan Schreter , Mihnea Andrei
发明人： Colin Florendo , Ivan Schreter , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： Techniques for handling large string values in a string dictionary within an in-memory database system are presented. The string dictionary can be a paged-column main dictionary. For example, a value block of a dictionary may be loaded into memory, where the dictionary stores values for dictionary compression. The value block may include a first portion of a large string value and one or more logical pointers to one or more large string pages containing a remainder of the large string value. The large string value may be materialized into a contiguous location in memory, and a pointer to the materialized large string value may be created.

12. 发明授权

US09965513B2 Set-orientated visibility state retrieval scheme 有权
公开(公告)号：US09965513B2
公开(公告)日：2018-05-08
申请号：US14553226
申请日：2014-11-25
申请人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
发明人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30339 , G06F17/30345 , G06F17/30353 , G06F17/30548
摘要： Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.

13. 发明申请

US20150142818A1 PAGED COLUMN DICTIONARY 有权
公开(公告)号：US20150142818A1
公开(公告)日：2015-05-21
申请号：US14333224
申请日：2014-07-16
申请人： Colin Florendo , Carsten Thiel , Ivan Schreter , Mihnea Andrei , Anil Kumar Goel
发明人： Colin Florendo , Carsten Thiel , Ivan Schreter , Mihnea Andrei , Anil Kumar Goel
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： A request for an entry of a dictionary having multiple dictionary blocks may be received, where the dictionary stores string values associated with corresponding value identifiers (IDs) for dictionary compression. One of the dictionary blocks may be selectively loaded into memory, and the dictionary block that has been loaded into memory may be searched. A value ID directory may be constructed in memory, where the value ID directory includes last value IDs for the dictionary blocks, and each of the last value IDs is mapped to an index of one of the dictionary blocks that includes a string value for that last value ID. A separator directory may also be constructed in memory, where the separator directory includes separators for the dictionary blocks, and each of the separators is mapped to an index of one of the dictionary blocks that includes a string value for that separator.
摘要翻译：可以接收对具有多个字典块的字典的输入的请求，其中字典存储与用于字典压缩的相应值标识符（ID）相关联的字符串值。一个字典块可以被选择性地加载到存储器中，并且可以搜索已经加载到存储器中的字典块。值ID目录可以在存储器中构造，其中值ID目录包括字典块的最后值ID，并且每个最后的值ID被映射到包括该最后一个的字符串值的字典块之一的索引值ID。分隔符目录也可以在内存中构建，其中分隔符目录包括字典块的分隔符，并且每个分隔符都映射到包含该分隔符的字符串值的字典块之一的索引。

14. 发明授权

US09977801B2 Paged column dictionary 有权
公开(公告)号：US09977801B2
公开(公告)日：2018-05-22
申请号：US14333224
申请日：2014-07-16
申请人： Colin Florendo , Carsten Thiel , Ivan Schreter , Mihnea Andrei , Anil Kumar Goel
发明人： Colin Florendo , Carsten Thiel , Ivan Schreter , Mihnea Andrei , Anil Kumar Goel
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30312
摘要： A request for an entry of a dictionary having multiple dictionary blocks may be received, where the dictionary stores string values associated with corresponding value identifiers (IDs) for dictionary compression. One of the dictionary blocks may be selectively loaded into memory, and the dictionary block that has been loaded into memory may be searched. A value ID directory may be constructed in memory, where the value ID directory includes last value IDs for the dictionary blocks, and each of the last value IDs is mapped to an index of one of the dictionary blocks that includes a string value for that last value ID. A separator directory may also be constructed in memory, where the separator directory includes separators for the dictionary blocks, and each of the separators is mapped to an index of one of the dictionary blocks that includes a string value for that separator.

15. 发明申请

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.
摘要翻译：这里公开了用于改变数据库中的列的数据类型的系统，方法和计算机程序产品实施例。实施例通过将与列相关联的原始字典转换为新字典来操作。新字典使用不同的数据类型存储原始字典的值。然后，将包含原始字典的键的索引向量更新为包含新字典的相关键。由于原始字典的大小通常远小于相关列中的行数，因此该字典转换会降低数据库系统的更改列数据类型的计算成本，并减少或甚至最小化用户数据库停机时间。

16. 发明申请

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.
摘要翻译：本公开涉及用于将表从源节点移动到目的地节点的系统，软件和计算机实现的方法。在一个示例中，该方法包括接收与存储在源节点处的存储器内数据库表相关联的元数据。响应于接收元数据创建表容器。目的地节点从源节点顺序地请求表的部分，其中表在源节点被序列化以提供表部分的序列化序列。顺序请求包括在处理接收到的部分之后发送对表的下一部分的请求，其包括接收序列化表的一部分，对接收到的部分进行反序列化，将反序列化部分添加到创建的表容器中，并响应于结束与所接收的部分相关联的文件指示，结束请求并完成表格。

17. 发明授权

US10089342B2 Main memory database management using page index vectors 有权
公开(公告)号：US10089342B2
公开(公告)日：2018-10-02
申请号：US14328511
申请日：2014-07-10
申请人： Reza Sherkat , Guenter Radestock , Ivan Schreter , Colin Florendo , Mihnea Andrei , Anil Kumar Goel
发明人： Reza Sherkat , Guenter Radestock , Ivan Schreter , Colin Florendo , Mihnea Andrei , Anil Kumar Goel
IPC分类号： G06F17/30
摘要： A compression manager may store, within an index vector, a plurality of value identifiers (IDs), each value ID representing a value within a database. A page generator may designate a number of the value IDs as defining a page within the index vector, so that the index vector includes a plurality of pages, each page including the number of value IDs. The page generator may store the index vector in a secondary memory of a main memory database. An iterator may access a requested value ID, and a page loader may load a corresponding page of the index vector that contains the requested value ID into the main memory database.

18. 发明授权

US09558216B2 Moving tables across nodes in an in-memory database instance 有权
标题翻译：在内存数据库实例中的节点之间移动表
公开(公告)号：US09558216B2
公开(公告)日：2017-01-31
申请号：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.
摘要翻译：本公开涉及用于将表从源节点移动到目的地节点的系统，软件和计算机实现的方法。在一个示例中，该方法包括接收与存储在源节点处的存储器内数据库表相关联的元数据。响应于接收元数据创建表容器。目的地节点从源节点顺序地请求表的部分，其中表在源节点被序列化以提供表部分的序列化序列。顺序请求包括在处理接收到的部分之后发送对表的下一部分的请求，该接收部分包括接收序列化表的一部分，对接收到的部分进行反序列化，将反序列化部分添加到创建的表容器中，并响应于结束与所接收的部分相关联的文件指示，结束请求并完成表格。

19. 发明申请

US20160147834A1 Set-Orientated Visibility State Retrieval Scheme 有权
标题翻译：面向可视性状态检索方案
公开(公告)号：US20160147834A1
公开(公告)日：2016-05-26
申请号：US14553226
申请日：2014-11-25
申请人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
发明人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30339 , G06F17/30345 , G06F17/30353 , G06F17/30548
摘要： Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.
摘要翻译：这里公开了用于确定行可见性状态的系统，方法和计算机程序产品实施例。实施例通过基于与行对应的行状态位图的可见行状态值来初始化行的结果位图来进行操作，其中结果位图的值指示该行是可见还是不可见; 确定其对应的可见行状态值指示所述一行或多行不可见的一行或多行; 以及基于一个或多个版本化的行状态值来确定是否更新所述结果位图以指示所述一行或多行是可见的，其中所述一个或多个版本化行状态值指示相应行是否不可见或可见。

20. 发明申请

US20150142819A1 LARGE STRING ACCESS AND STORAGE 有权
标题翻译：大量的访问和存储
公开(公告)号：US20150142819A1
公开(公告)日：2015-05-21
申请号：US14524998
申请日：2014-10-27
申请人： Colin Florendo , Ivan Schreter , Mihnea Andrei
发明人： Colin Florendo , Ivan Schreter , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： Techniques for handling large string values in a string dictionary within an in-memory database system are presented. The string dictionary can be a paged-column main dictionary. For example, a value block of a dictionary may be loaded into memory, where the dictionary stores values for dictionary compression. The value block may include a first portion of a large string value and one or more logical pointers to one or more large string pages containing a remainder of the large string value. The large string value may be materialized into a contiguous location in memory, and a pointer to the materialized large string value may be created.
摘要翻译：介绍了在内存数据库系统中处理字符串字典中大字符串值的技术。字典字典可以是分页列主字典。例如，字典的值块可以被加载到存储器中，其中字典存储用于字典压缩的值。值块可以包括大字符串值的第一部分和包含大字符串值的余数的一个或多个大字符串页的一个或多个逻辑指针。大字符串值可以被实现到存储器中的连续位置，并且可以创建指向物化的大字符串值的指针。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式