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

21. 发明申请

US20160147861A1 Database System With Transaction Control Block Index 有权
标题翻译：具有事务控制块索引的数据库系统
公开(公告)号：US20160147861A1
公开(公告)日：2016-05-26
申请号：US14553494
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee , Mihnea Andrei
发明人： Ivan Schreter , Juchang Lee , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30353
摘要： A plurality of transactions is handled in a database. Each transaction includes a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record. The temporary timestamp are based, at least in part, on the corresponding transaction. Further, a final timestamp is assigned to each record with a commit operation. It can later be determined, using a visibility function and based on the assigned temporary timestamps and final timestamps, which of the records are visible in a consistent view for a first transaction. Based on such determination, access can be provided to those records determined to be visible to be accessed to the first transaction.
摘要翻译：在数据库中处理多个事务。每个事务包括在数据库中的至少一个记录上的多个操作，其中至少两个事务被同时处理。此后，将临时时间戳分配给每个记录。临时时间戳至少部分地基于相应的事务。此外，通过提交操作将最终时间戳分配给每个记录。稍后可以使用可见性功能并基于分配的临时时间戳和最终时间戳来确定哪个记录在第一个事务的一致视图中可见。基于这样的确定，可以向确定为可见以被访问到第一交易的那些记录提供访问。

22. 发明申请

US20160147821A1 Supporting Cursor Snapshot Semantics 有权
标题翻译：支持光标快照语义
公开(公告)号：US20160147821A1
公开(公告)日：2016-05-26
申请号：US14553790
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee
发明人： Ivan Schreter , Juchang Lee
IPC分类号： G06F17/30 , G06F9/46
CPC分类号： G06F17/30371
摘要： A database upon opening each of at least one cursor for a transaction, assigns each statement forming part of a transaction a statement sequence number (SSN) involving at least one row of the database. Thereafter, temporary timestamps are assigned to the at least one row using a transaction identifier and the corresponding SSN. Further, active cursors are monitored such that a final timestamp is prevented from being associated with each row until it has no remaining cursors. Related apparatus, systems, techniques and articles are also described.
摘要翻译：数据库在打开事务的至少一个游标中的每一个时，分配构成事务的每个语句的涉及数据库的至少一行的语句序列号（SSN）。此后，使用事务标识符和对应的SSN将临时时间戳分配给至少一行。此外，监视活动光标，使得最终时间戳被阻止与每行相关联，直到其没有剩余的游标。还描述了相关设备，系统，技术和物品。

23. 发明授权

US09971770B2 Inverted indexing 有权
公开(公告)号：US09971770B2
公开(公告)日：2018-05-15
申请号：US14552897
申请日：2014-11-25
申请人： Ivan Schreter , Chaitanya Gottipati , Thomas Legler
发明人： Ivan Schreter , Chaitanya Gottipati , Thomas Legler
IPC分类号： G06F17/30
CPC分类号： G06F17/30011 , G06F17/30622
摘要： Disclosed herein are system, method, and computer program product embodiments for inverted indexing. An embodiment operates by receiving a request to add a new document identifier (doc ID) to an inverted index. A memory block corresponding to where the doc ID is to be added is determined or located, and the available space remaining in the memory block is determined. If the memory block has available space, the doc ID is added to the memory block.

24. 发明授权

US09842052B2 Selective allocation of CPU cache slices to database objects 有权
公开(公告)号：US09842052B2
公开(公告)日：2017-12-12
申请号：US14690774
申请日：2015-04-20
申请人： Ivan Schreter
发明人： Ivan Schreter
IPC分类号： G06F9/46 , G06F13/00 , G06F7/00 , G06F12/0846 , G06F9/52 , G06F9/54
CPC分类号： G06F12/0848 , G06F9/52 , G06F9/544 , G06F12/0895 , G06F2212/1021 , G06F2212/282 , G06F2212/604 , G06F2212/608
摘要： A central processing unit (CPU) forming part of a computing device, initiates execution of code associated with each of a plurality of objects used by a worker thread. The CPU has an associated cache that is split into a plurality of slices. It is determined, by a cache slice allocation algorithm for each object, whether any of the slices will be exclusive to or shared by the object. Thereafter, for each object, any slices determined to be exclusive to the object are activated such that the object exclusively uses such slices and any slices determined to be shared by the object are activated such that the object shares or is configured to share such slices.

25. 发明授权

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.

26. 发明授权

US09779104B2 Efficient database undo / redo logging 有权
公开(公告)号：US09779104B2
公开(公告)日：2017-10-03
申请号：US14553833
申请日：2014-11-25
申请人： Mihnea Andrei , Ivan Schreter , David Wein , Shiping Chen , Panfeng Zhou , Steffen Geissinger
发明人： Mihnea Andrei , Ivan Schreter , David Wein , Shiping Chen , Panfeng Zhou , Steffen Geissinger
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30162 , G06F11/1402 , G06F17/30185 , G06F17/30336 , G06F17/30368
摘要： Log records are accessed as part of a database operation in a database. The log records log insert, update, and delete operations in the database and include, for each row, a row position, a fragment identifier (ID), and a row ID. Thereafter, as part of the database operation, rows specified by the log records are located by: using the fragment identifier and the row position within the corresponding record of the log if the fragment with the corresponding fragment identifier is still available, otherwise, using the row identifier within the corresponding record of the log to look up the row position in an index of a corresponding row identifier column. The database operation is then finalized using the located rows. Related apparatus, systems, techniques and articles are also described.

27. 发明授权

US09665609B2 Garbage collection of multi-version concurrency control (MVCC) data blocks 有权
公开(公告)号：US09665609B2
公开(公告)日：2017-05-30
申请号：US14553901
申请日：2014-11-25
申请人： Mihnea Andrei , Ivan Schreter , Amarnadh Sai Eluri
发明人： Mihnea Andrei , Ivan Schreter , Amarnadh Sai Eluri
IPC分类号： G06F17/30
CPC分类号： G06F17/30348
摘要： Disclosed herein are system, method, and computer program product embodiments for performing garbage collection in a database management system with a multi-version concurrency control. An embodiment operate by qualifying a multi-version concurrency control (MVCC) block for garbage collection, where the MVCC block includes multiple cells, each cell corresponding to a row of a table that was acted on by a transaction. Determining that the MVCC block can be garbage collected based on MVCC information in the MVCC block, where the MVCC information includes information that determines whether changes made to rows in the multiple cells are visible in a database management system. Based on the determining, garbage collecting the MVCC block.

28. 发明授权

US09626291B2 Lock-free, scalable read access to shared data structures using garbage collection 有权
公开(公告)号：US09626291B2
公开(公告)日：2017-04-18
申请号：US14643755
申请日：2015-03-10
申请人： Ivan Schreter
发明人： Ivan Schreter
IPC分类号： G06F17/30 , G06F12/02
CPC分类号： G06F12/0261 , G06F17/30303 , G06F17/30575 , G06F2212/1048
摘要： At least one read operation of at least one object of a data container is initiated. The data container includes an anchor object, a first internal data object and a first garbage collection object, the anchor object comprising a pointer to a versioned structure tree. Thereafter, in response to the at least one incompatible write operation, a second internal data object and a second garbage collection object are created for the data container. The second garbage collection object has a reference to the second internal data object. Subsequently, the second internal data object is installed in the anchor object and the first garbage collection object is passed to a garbage collection process so that space used by the first garbage collection object in a database can be reused. Related apparatus, systems, techniques and articles are also described.

29. 发明授权

US09542279B2 Shadow paging based log segment directory 有权
标题翻译：基于阴影寻呼的日志段目录
公开(公告)号：US09542279B2
公开(公告)日：2017-01-10
申请号：US13290726
申请日：2011-11-07
申请人： Ivan Schreter
发明人： Ivan Schreter
IPC分类号： G06F17/30 , G06F17/40 , G06F11/14
CPC分类号： G06F11/1471 , G06F17/30368 , G06F17/30377
摘要： Replay of data transactions is initiated in a data storage application. Pages of a log segment directory characterizing metadata for a plurality of log segment are loaded into memory. Thereafter, redundant pages within the log segment directory are removed. It is then determined, based on the log segment directory, which log segments need to be accessed. These log segments are accessed to execute the log replay. Related apparatus, systems, techniques and articles are also described.
摘要翻译：在数据存储应用程序中启动数据事务的重放。表示多个日志段的元数据的日志段目录的页面被加载到存储器中。此后，将删除日志段目录中的冗余页面。然后根据日志段目录确定哪些日志段需要被访问。访问这些日志段以执行日志重放。还描述了相关设备，系统，技术和物品。

30. 发明授权

US09519673B2 Management of I/O and log size for columnar database 有权
标题翻译：管理数据库的I / O和日志大小
公开(公告)号：US09519673B2
公开(公告)日：2016-12-13
申请号：US13215726
申请日：2011-08-23
申请人： Ivan Schreter
发明人： Ivan Schreter
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30377 , G06F11/1461 , G06F11/1471 , G06F17/30315 , G06F17/30368 , G06F2201/80
摘要： A system includes reception of a transaction to change a columnar table, recordation of the transaction within a delta structure in a volatile memory, recordation of the transaction within a log of a persisted memory, reception of an instruction to merge the delta structure in the volatile memory with a first instantiation of the columnar table in the volatile memory, and in response to the instruction, merging of the delta structure in the volatile memory with the first instantiation of the columnar table in the volatile memory to create a merged columnar table in the volatile memory, and not storing the merged columnar table in the persisted memory.
摘要翻译：系统包括接收交易以更改列表，在易失性存储器内的增量结构内记录事务，在持久存储器的日志内记录事务的记录，接收将易失性存储器中的delta结构合并的指令存储器，其中易失性存储器中的列表的第一次实例化，并且响应于该指令，将易失性存储器中的delta结构与易失性存储器中的列表的第一次实例合并，以便在易失性存储器中创建合并的列表易失性存储器，并且不将合并的列表存储在持久存储器中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式