公开(公告)号：US20160147814A1

公开(公告)日：2016-05-26

申请号：US14553950

申请日：2014-11-25

申请人： Anil Kumar Goel ,  Ivan Schreter ,  Juchang Lee ,  Mihnea Andrei ,  Steffen Geissinger ,  Thomas Legler

发明人： Anil Kumar Goel ,  Ivan Schreter ,  Juchang Lee ,  Mihnea Andrei ,  Steffen Geissinger ,  Thomas Legler

IPC分类号： G06F17/30 ,  G06F3/06

CPC分类号： G06F17/30383 ,  G06F3/0619 ,  G06F3/0665 ,  G06F3/0689 ,  G06F17/30008 ,  G06F17/30171 ,  G06F17/30309 ,  G06F17/30348 ,  G06F17/30353 ,  G06F17/30356 ,  G06F17/30359 ,  G06F17/30368 ,  G06F17/30575 ,  G06F17/30592

摘要： As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory.

摘要翻译： 作为包括磁盘存储和内存存储的组合的数据库系统的一部分，包括表的多个记录被存储在多个片段中，该多个片段至少包括一个delta片段和保存在on上的主片段 磁盘存储。 每个片段具有可见性数据结构，以实现多版本并发控制。 可以使用字典压缩和n位压缩来压缩每个片段。 如果对于读取操作或写入操作进行访问，并且尚未存储在内存中，这些碎片将从磁盘存储器加载到内存中的主系统内存中。 同时执行多个无锁读取和写入操作，同时在多个片段中的至少一个片段上提供快照隔离，同时多个片段中的至少一个片段在主系统存储器中。

公开(公告)号：US10127260B2

公开(公告)日：2018-11-13

申请号：US14553950

申请日：2014-11-25

申请人： Anil Kumar Goel ,  Ivan Schreter ,  Juchang Lee ,  Mihnea Andrei ,  Steffen Geissinger ,  Thomas Legler

发明人： Anil Kumar Goel ,  Ivan Schreter ,  Juchang Lee ,  Mihnea Andrei ,  Steffen Geissinger ,  Thomas Legler

IPC分类号： G06F17/30 ,  G06F3/06

摘要： As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory.

公开(公告)号：US20160147786A1

公开(公告)日：2016-05-26

申请号：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.

摘要翻译： 日志记录作为数据库中数据库操作的一部分进行访问。 日志记录数据库中的日志插入，更新和删除操作，并为每行包括行位置，片段标识符（ID）和行ID。 此后，作为数据库操作的一部分，由日志记录指定的行通过以下方式定位：如果具有相应分段标识符的片段仍然可用，则使用片段标识符和日志对应记录中的行位置，否则使用 日志的相应记录中的行标识符，以查找相应行标识符列的索引中的行位置。 然后使用定位的行完成数据库操作。 还描述了相关设备，系统，技术和物品。

公开(公告)号：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.

公开(公告)号：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.

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

公开(公告)号：US09411866B2

公开(公告)日：2016-08-09

申请号：US13719737

申请日：2012-12-19

申请人： Christian Bartholomä ,  Michael Mühle ,  Hans-Jörg Leu ,  Steffen Geissinger ,  Thorsten Glebe ,  Martin Heidel ,  Lars Fricke ,  Volker Diesel ,  Christian Bensberg

发明人： Christian Bartholomä ,  Michael Mühle ,  Hans-Jörg Leu ,  Steffen Geissinger ,  Thorsten Glebe ,  Martin Heidel ,  Lars Fricke ,  Volker Diesel ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： Data replication in a database includes identifying a source database system. The source database includes a main index file and a delta log file. To create a replica, one or more symbolic links to the source database system are generated. The symbolic links identify a path to a physical location of the source database. A replica of the source database is generated based on the symbolic links. The replica includes a copy of the main index file and delta log file. Information associated with the replica and the symbolic links is stored in a recovery log. Replica are provided transparently to most database engine components by re-using partitioning infrastructure. Components “see” replica as tables with a single partition; that partition is a local replica.

摘要翻译： 数据库中的数据复制包括识别源数据库系统。 源数据库包括主索引文件和增量日志文件。 要创建副本，将生成到源数据库系统的一个或多个符号链接。 符号链接标识到源数据库的物理位置的路径。 基于符号链接生成源数据库的副本。 副本包括主索引文件和增量日志文件的副本。 与副本和符号链接相关联的信息存储在恢复日志中。 通过重新使用分区基础架构，对大多数数据库引擎组件透明地提供副本。 组件“将”副本视为具有单个分区的表; 该分区是本地副本。

公开(公告)号：US20150324382A1

公开(公告)日：2015-11-12

申请号：US14274973

申请日：2014-05-12

申请人： Thomas Seufert ,  Steffen Geissinger

发明人： Thomas Seufert ,  Steffen Geissinger

IPC分类号： G06F17/30

CPC分类号： G06F16/2453 ,  G06F16/14 ,  G06F16/172 ,  G06F16/2282 ,  G06F16/951

摘要： The present disclosure describes methods, systems, and computer program products for optimizing single-value database read operations. One computer-implemented method includes initializing, by a computer, a single value cache associated with a created database table where a column of the database table contains a single or unique data value, verifying that the created database table is in a useable state, performing an operation on the database table, and retrieving the data value from the single value cache without locking the column containing the single or unique data value.

摘要翻译： 本公开描述了用于优化单值数据库读取操作的方法，系统和计算机程序产品。 一种计算机实现的方法包括由计算机初始化与创建的数据库表相关联的单个值缓存，其中数据库表的列包含单个或唯一的数据值，验证所创建的数据库表是否处于可用状态，执行 数据库表上的操作，以及从单值缓存中检索数据值，而不锁定包含单个或唯一数据值的列。

公开(公告)号：US09774652B2

公开(公告)日：2017-09-26

申请号：US14310781

申请日：2014-06-20

申请人： Florian Foebel ,  Bjoern Friedmann ,  Boris Gruschko ,  Christian Mohr ,  Martin Strenge ,  Steffen Geissinger

发明人： Florian Foebel ,  Bjoern Friedmann ,  Boris Gruschko ,  Christian Mohr ,  Martin Strenge ,  Steffen Geissinger

IPC分类号： G06F17/30 ,  H04L29/08 ,  H04L29/06

CPC分类号： H04L67/02 ,  G06F17/30365 ,  H04L67/42

摘要： A system includes establishment of a WebSocket connection at a WebSocket endpoint of the system with a WebSocket client, registration of a callback at the WebSocket endpoint for an event associated with an update to data of the database, identification of an update to the data of the database at an HTTP endpoint of the system, sending, in response to the identification of the update, a trigger event from the HTTP endpoint, reception of the trigger event at the WebSocket endpoint, and execution of the callback by the WebSocket endpoint to transmit the update to the WebSocket client.

公开(公告)号：US20140172794A1

公开(公告)日：2014-06-19

申请号：US13719737

申请日：2012-12-19

申请人： Christian BARTHOLOMÄ ,  Michael Mühle ,  Hans-Jörg Leu ,  Steffen Geissinger ,  Thorsten Glebe ,  Martin Heidel ,  Lars Fricke ,  Volker Diesel ,  Christian Bensberg

发明人： Christian BARTHOLOMÄ ,  Michael Mühle ,  Hans-Jörg Leu ,  Steffen Geissinger ,  Thorsten Glebe ,  Martin Heidel ,  Lars Fricke ,  Volker Diesel ,  Christian Bensberg

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： Data replication in a database includes identifying a source database system. The source database includes a main index file and a delta log file. To create a replica, one or more symbolic links to the source database system are generated. The symbolic links identify a path to a physical location of the source database. A replica of the source database is generated based on the symbolic links. The replica includes a copy of the main index file and delta log file. Information associated with the replica and the symbolic links is stored in a recovery log. Replica are provided transparently to most database engine components by re-using partitioning infrastructure. Components “see” replica as tables with a single partition; that partition is a local replica.

摘要翻译： 数据库中的数据复制包括识别源数据库系统。 源数据库包括主索引文件和增量日志文件。 要创建副本，将生成到源数据库系统的一个或多个符号链接。 符号链接标识到源数据库的物理位置的路径。 基于符号链接生成源数据库的副本。 副本包括主索引文件和增量日志文件的副本。 与副本和符号链接相关联的信息存储在恢复日志中。 通过重新使用分区基础架构，对大多数数据库引擎组件透明地提供副本。 组件“将”副本视为具有单个分区的表; 该分区是本地副本。

公开(公告)号：US10360210B2

公开(公告)日：2019-07-23

申请号：US14274973

申请日：2014-05-12

申请人： Thomas Seufert ,  Steffen Geissinger

发明人： Thomas Seufert ,  Steffen Geissinger

IPC分类号： G06F16/2453 ,  G06F16/14 ,  G06F16/172 ,  G06F16/951 ,  G06F16/22

摘要： The present disclosure describes methods, systems, and computer program products for optimizing single-value database read operations. One computer-implemented method includes initializing, by a computer, a single value cache associated with a created database table where a column of the database table contains a single or unique data value, verifying that the created database table is in a useable state, performing an operation on the database table, and retrieving the data value from the single value cache without locking the column containing the single or unique data value.