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

1. 发明授权

US09965504B2 Transient and persistent representation of a unified table metadata graph 有权
公开(公告)号：US09965504B2
公开(公告)日：2018-05-08
申请号：US14553215
申请日：2014-11-25
申请人： Ivan Schreter , David Wein , Thorsten Glebe
发明人： Ivan Schreter , David Wein , Thorsten Glebe
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , G06F17/30584
摘要： Loading of table metadata into memory of an in-memory database is initiated. The table metadata is persisted across pages in a page chain. Thereafter, a plurality of metadata objects are materialized into memory that each include an object handle pinning an underlying persisted page in the page chain. The objects are populated with data from the underlying persisted pages. Subsequently, for one to many object relationships, a vector of object handles is generated that comprises a plurality of transient handles that each point to a different instance of a respective transient object. Alternatively, for one to one object relationships or many to one object relationships, an object handle to point to a respective linked object is generated. Related apparatus, systems, techniques and articles are also described.

2. 发明申请

US20160147445A1 Transient and Persistent Representation of a Unified Table Metadata Graph 有权
标题翻译：统一表元数据图的瞬态和持续表示
公开(公告)号：US20160147445A1
公开(公告)日：2016-05-26
申请号：US14553215
申请日：2014-11-25
申请人： Ivan Schreter , David Wein , Thorsten Glebe
发明人： Ivan Schreter , David Wein , Thorsten Glebe
IPC分类号： G06F3/06 , G06F17/30
CPC分类号： G06F17/30339 , G06F17/30584
摘要： Loading of table metadata into memory of an in-memory database is initiated. The table metadata is persisted across pages in a page chain. Thereafter, a plurality of metadata objects are materialized into memory that each include an object handle pinning an underlying persisted page in the page chain. The objects are populated with data from the underlying persisted pages. Subsequently, for one to many object relationships, a vector of object handles is generated that comprises a plurality of transient handles that each point to a different instance of a respective transient object. Alternatively, for one to one object relationships or many to one object relationships, an object handle to point to a respective linked object is generated. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将表元数据加载到内存数据库的内存中。表元数据在页链中的页面上持久化。此后，将多个元数据对象实现到存储器中，每个元数据对象包括在页链中固定底层持久页面的对象句柄。这些对象用来自底层持久化页面的数据填充。随后，对于一对多对象关系，生成对象句柄的向量，其包括多个瞬态句柄，每个临时句柄指向相应的瞬时对象的不同实例。或者，对于一对一对象关系或多对一关系，生成指向相应链接对象的对象句柄。还描述了相关设备，系统，技术和物品。

3. 发明申请

US20160147812A1 Garbage Collection of Versions Driving the Garbage Collection of Multi-Version Concurrency Control Timestamps 有权
标题翻译：垃圾收集版本驱动多版本并发控制垃圾收集时间戳
公开(公告)号：US20160147812A1
公开(公告)日：2016-05-26
申请号：US14579162
申请日：2014-12-22
申请人： Mihnea ANDREI , Ivan Schreter , Amarnadh Eluri , Thorsten Glebe , Eunsang Kim
发明人： Mihnea ANDREI , Ivan Schreter , Amarnadh Eluri , Thorsten Glebe , Eunsang Kim
IPC分类号： G06F17/30 , G06F12/02
CPC分类号： G06F17/30353
摘要： Disclosed herein are system, method, and computer program product embodiments for performing garbage collection on a multi-version concurrency control information in the database management system. An embodiment operates by determining, using multi-version concurrency control (MVCC) information, when a row manipulated by a write transaction is visible to a plurality of readers accessing a table that includes the row. The MVCC information for the row includes at least a creation timestamp, a destruction timestamp and a row state. Once the row is visible to the plurality of readers, garbage collecting at least the creation timestamp or the destruction timestamp in the MVCC information. After the creation timestamp or destruction timestamp have been garbage collected, the plurality of readers use the row state to determine accessibility of the row in the table.
摘要翻译：这里公开了用于在数据库管理系统中的多版本并发控制信息上执行垃圾收集的系统，方法和计算机程序产品实施例。一个实施例通过使用多版本并发控制（MVCC）信息确定当由写入事务操纵的行对于访问包括该行的表的多个读取器是可见的时，确定操作。该行的MVCC信息至少包括创建时间戳，销毁时间戳和行状态。一旦该行对于多个读取器是可见的，则垃圾收集至少在MVCC信息中的创建时间戳或破坏时间戳。在创建时间戳或破坏时间戳已经被垃圾回收之后，多个读取器使用行状态来确定表中行的可访问性。

4. 发明申请

US20130117247A1 Columnar Database Using Virtual File Data Objects 有权
标题翻译：使用虚拟文件数据对象的列数据库
公开(公告)号：US20130117247A1
公开(公告)日：2013-05-09
申请号：US13290866
申请日：2011-11-07
申请人： Ivan Schreter , Thorsten Glebe , Tobias Scheuer
发明人： Ivan Schreter , Thorsten Glebe , Tobias Scheuer
IPC分类号： G06F7/00
CPC分类号： G06F17/30315
摘要： A plurality of virtual files are instantiated in a columnar database. The columnar database includes a columnar data store that persists tables of data contained therein to the plurality of virtual files. Each virtual file is stored in physical data storage and a portion of the virtual file can be cached transiently in a persistence layer intermediate the columnar data store and the physical data storage. The virtual files each comprise a database object for storing data records. Operation are processed, in the columnar database, using the virtual files such that changes to virtual files resulting from the operations of one transaction are isolated from changes on the same virtual files resulting from the operations of other transactions. Related apparatus, systems, techniques and articles are also described.
摘要翻译：多个虚拟文件在柱状数据库中实例化。柱状数据库包括一个列数据存储，其将包含在其中的数据表保留到多个虚拟文件。每个虚拟文件存储在物理数据存储中，并且虚拟文件的一部分可以在列数据存储和物理数据存储之间的持久层中瞬时缓存。虚拟文件各自包括用于存储数据记录的数据库对象。在列数据库中，使用虚拟文件处理操作，使得从一个事务的操作产生的虚拟文件的更改与其他事务的操作产生的相同虚拟文件的更改隔离。还描述了相关设备，系统，技术和物品。

5. 发明授权

US09953050B2 Garbage collection of versions driving the garbage collection of multi-version concurrency control timestamps 有权
公开(公告)号：US09953050B2
公开(公告)日：2018-04-24
申请号：US14579162
申请日：2014-12-22
申请人： Mihnea Andrei , Ivan Schreter , Amarnadh Eluri , Thorsten Glebe , Eunsang Kim
发明人： Mihnea Andrei , Ivan Schreter , Amarnadh Eluri , Thorsten Glebe , Eunsang Kim
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30353
摘要： Disclosed herein are system, method, and computer program product embodiments for performing garbage collection on a multi-version concurrency control information in the database management system. An embodiment operates by determining, using multi-version concurrency control (MVCC) information, when a row manipulated by a write transaction is visible to a plurality of readers accessing a table that includes the row. The MVCC information for the row includes at least a creation timestamp, a destruction timestamp and a row state. Once the row is visible to the plurality of readers, garbage collecting at least the creation timestamp or the destruction timestamp in the MVCC information. After the creation timestamp or destruction timestamp have been garbage collected, the plurality of readers use the row state to determine accessibility of the row in the table.

6. 发明授权

US09483512B2 Columnar database using virtual file data objects 有权
标题翻译：使用虚拟文件数据对象的Columnar数据库
公开(公告)号：US09483512B2
公开(公告)日：2016-11-01
申请号：US13290866
申请日：2011-11-07
申请人： Ivan Schreter , Thorsten Glebe , Tobias Scheuer
发明人： Ivan Schreter , Thorsten Glebe , Tobias Scheuer
IPC分类号： G06F17/30
CPC分类号： G06F17/30315
摘要： A plurality of virtual files are instantiated in a columnar database. The columnar database includes a columnar data store that persists tables of data contained therein to the plurality of virtual files. Each virtual file is stored in physical data storage and a portion of the virtual file can be cached transiently in a persistence layer intermediate the columnar data store and the physical data storage. The virtual files each comprise a database object for storing data records. Operation are processed, in the columnar database, using the virtual files such that changes to virtual files resulting from the operations of one transaction are isolated from changes on the same virtual files resulting from the operations of other transactions. Related apparatus, systems, techniques and articles are also described.
摘要翻译：多个虚拟文件在柱状数据库中实例化。柱状数据库包括一个列数据存储，其将包含在其中的数据表保留到多个虚拟文件。每个虚拟文件存储在物理数据存储中，并且虚拟文件的一部分可以在列数据存储和物理数据存储之间的持久层中瞬时缓存。虚拟文件各自包括用于存储数据记录的数据库对象。在列数据库中，使用虚拟文件处理操作，使得从一个事务的操作产生的虚拟文件的更改与其他事务的操作产生的相同虚拟文件的更改隔离。还描述了相关设备，系统，技术和物品。

7. 发明授权

US09898551B2 Fast row to page lookup of data table using capacity index 有权
公开(公告)号：US09898551B2
公开(公告)日：2018-02-20
申请号：US14553878
申请日：2014-11-25
申请人： David Wein , Ivan Schreter
发明人： David Wein , Ivan Schreter
IPC分类号： G06F17/30 , G06F12/08 , G06F12/0817
CPC分类号： G06F17/30952 , G06F12/0817 , G06F17/30312 , G06F17/30321 , G06F17/30327 , G06F17/30424 , G06F17/30595
摘要： The subject matter disclosed herein provides methods for determining the page on which a desired row position value is located. A table having a plurality of rows can be accessed. The rows can be distributed across one or more pages in an in-memory database. Each row can be associated with a unique row position value. Each page can be associated with a capacity that is representative of an amount of data stored on the page. A capacity index having a plurality of entries can be created to record changes in capacity between pages. Neighboring entries in the capacity index can have a different capacity. Each entry in the capacity index can correspond to a page. A page directory can be created based on the capacity index. The page directory can indicate all possible row position values associated with each page. Related apparatus, systems, techniques, and articles are also described.

8. 发明申请

US20160147801A1 OPTIMIZED ROLLOVER PROCESSES TO ACCOMMODATE A CHANGE IN VALUE IDENTIFIER BIT SIZE AND RELATED SYSTEM RELOAD PROCESSES 审中-公开
标题翻译：优化滚动过程来调整数值标识符大小和相关系统过渡过程中的变化
公开(公告)号：US20160147801A1
公开(公告)日：2016-05-26
申请号：US14553844
申请日：2014-11-25
申请人： David Wein , Mihnea Andrei , Ivan Schreter , Rolando Blanco , Thomas Legler
发明人： David Wein , Mihnea Andrei , Ivan Schreter , Rolando Blanco , Thomas Legler
IPC分类号： G06F17/30 , G06F3/06
CPC分类号： G06F17/30315 , G06F3/0604 , G06F3/064 , G06F3/0673
摘要： The subject matter disclosed herein provides methods for reformatting a page due to a rollover. An in-memory array holding a column of data can be maintained. One or more pages can be maintained. Each page can have one or more rows for storing the column of data. The column of data in the in-memory array can be monitored for a change. A rollover can be performed on at least one of the pages based on the change. The rollover can reformat the at least one page by rewriting metadata associated with the at least one page. Related apparatus, systems, techniques, and articles are also described.
摘要翻译：本文公开的主题提供了由于翻转而重新格式化页面的方法。可以维护保存数据列的内存中阵列。可以维护一个或多个页面。每个页面可以有一行或多行存储数据列。可以监视内存中阵列中的数据列，以进行更改。可以基于更改在至少一个页面上执行翻转。翻转可以通过重写与至少一个页面相关联的元数据来重新格式化至少一个页面。还描述了相关装置，系统，技术和制品。

9. 发明申请

US20160147459A1 MATERIALIZING DATA FROM AN IN-MEMORY ARRAY TO AN ON-DISK PAGE STRUCTURE 有权
标题翻译：将数据从内存阵列转换为磁盘结构
公开(公告)号：US20160147459A1
公开(公告)日：2016-05-26
申请号：US14553872
申请日：2014-11-25
申请人： David Wein , Mihnea Andrei , Dirk Thomsen , Ivan Schreter
发明人： David Wein , Mihnea Andrei , Dirk Thomsen , Ivan Schreter
IPC分类号： G06F3/06 , G06F17/30
CPC分类号： G06F3/065 , G06F3/0608 , G06F3/0617 , G06F3/0644 , G06F3/0673 , G06F3/0685 , G06F17/30315 , G06F17/30339 , G06F17/3048 , G06F17/30575
摘要： The subject matter disclosed herein provides methods for materializing data from an in-memory array to one or more pages. An in-memory array holding a column of data can be maintained. One or more pages can be maintained. Each of the one or more pages can have one or more rows for storing the column of data. At least one of the one or more pages can be marked for materialization. The column of data can be materialized by copying the data from the in-memory array to the one or more rows of the one or more pages. The materializing can be based on the marking. Related apparatus, systems, techniques, and articles are also described.
摘要翻译：本文公开的主题提供了将数据从存储器阵列实现到一个或多个页面的方法。可以维护保存数据列的内存中阵列。可以维护一个或多个页面。一个或多个页面中的每一个可以具有用于存储数据列的一行或多行。可以标记一个或多个页面中的至少一个以实现。可以通过将数据从内存阵列复制到一个或多个页面的一行或多行来实现数据列。实现可以基于标记。还描述了相关装置，系统，技术和制品。

10. 发明授权

US09811549B2 Applying a database transaction log record directly to a database table container 有权
公开(公告)号：US09811549B2
公开(公告)日：2017-11-07
申请号：US14552914
申请日：2014-11-25
申请人： Ivan Schreter , Shiping Chen , David Wein , Steffen Geiβinger
发明人： Ivan Schreter , Shiping Chen , David Wein , Steffen Geiβinger
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F17/30368
摘要： Disclosed herein are system, method, and computer program product embodiments for directly restoring a database from a log volume. An embodiment operates by reading one or more database transaction log records from a log volume. The embodiment then loads from a database table persistent storage one or more pages containing rows in the database table that will be read from or written to by the one or more database transaction log records. The embodiment then loads a dictionary for each column associated with the one or more database transaction log records. The embodiment then applies the one or more database transaction log records directly into the one or more loaded pages and the one or more dictionaries. Each dictionary and page modified in memory is then written to the database table persistent storage when a savepoint operation is performed.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式