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

1. 发明申请

US20160147804A1 FORCED ORDERING OF A DICTIONARY STORING ROW IDENTIFIER VALUES 审中-公开
标题翻译：字典存储标识符值强制订购
公开(公告)号：US20160147804A1
公开(公告)日：2016-05-26
申请号：US14553892
申请日：2014-11-25
申请人： David Wein , Ivan Schreter , Mihnea Andrei , Martin Heidel , Frank Benkstein
发明人： David Wein , Ivan Schreter , Mihnea Andrei , Martin Heidel , Frank Benkstein
IPC分类号： G06F17/30 , G06F17/22
摘要： The subject matter disclosed herein provides methods for the forced ordering of a dictionary based on row identifier values. A plurality of concurrent transactions can be handled in an in-memory database. At least one of the transactions can include at least one write operation to a dictionary. Each write operation can be assigned a row identifier (ID). At least one of the write operations can be written to the dictionary out of sequence. The sequence can be based on the row ID. Each row ID in the dictionary can be mapped to a corresponding value identifier in the dictionary. The dictionary can position the value identifiers so that the corresponding row IDs are in a sorted sequential order based on the row ID. Related apparatus, systems, techniques, and articles are also described.
摘要翻译：本文公开的主题提供了基于行标识符值强制排序字典的方法。可以在内存数据库中处理多个并发事务。至少一个事务可以包括对字典的至少一个写入操作。每个写操作都可以被分配一个行标识符（ID）。写入操作中的至少一个可以按顺序写入字典。该序列可以基于行ID。字典中的每个行ID都可以映射到字典中的相应值标识符。字典可以定位值标识符，使得相应的行ID基于行ID按照排序的顺序排列。还描述了相关装置，系统，技术和制品。

2. 发明申请

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

3. 发明申请

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.
摘要翻译：启动将表元数据加载到内存数据库的内存中。表元数据在页链中的页面上持久化。此后，将多个元数据对象实现到存储器中，每个元数据对象包括在页链中固定底层持久页面的对象句柄。这些对象用来自底层持久化页面的数据填充。随后，对于一对多对象关系，生成对象句柄的向量，其包括多个瞬态句柄，每个临时句柄指向相应的瞬时对象的不同实例。或者，对于一对一对象关系或多对一关系，生成指向相应链接对象的对象句柄。还描述了相关设备，系统，技术和物品。

4. 发明授权

US09275097B2 Set-oriented locking based on in-memory bitmaps for a column-oriented database 有权
标题翻译：基于面向列的数据库的基于内存位图的面向集成锁定
公开(公告)号：US09275097B2
公开(公告)日：2016-03-01
申请号：US14143874
申请日：2013-12-30
申请人： Mark DeLaFranier , David Wein , Rolando Blanco , Anil Kumar Goel , Mihnea Andrei
发明人： Mark DeLaFranier , David Wein , Rolando Blanco , Anil Kumar Goel , Mihnea Andrei
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F17/30362 , G06F11/1448 , G06F17/30309 , G06F17/30312 , G06F17/30315 , G06F17/30339 , G06F17/30368 , G06F17/30371 , G06F2201/80 , G06F2201/825 , G06F2201/84 , G06F2201/87
摘要： A set-oriented locking based on in-memory bitmap for a column store database is described. An example method includes establishing a column-based in-memory database including a main store and a delta store, where the delta store has a plurality of row-visibility lock bitmaps visible to transactions at various points in time. The lock bitmaps represent a bit encoding to indicate whether there are granted row locks tables in the database. A delete or an update statement is executed with a transaction on a table. A set of row locks on rows of the table manipulated by the delete or the update statement are requested to preclude other transactions from currently deleting or updating the same rows. Accordingly, set operations are performed on the lock bitmap to manage the set of row locks associated with the transaction.
摘要翻译：描述了基于列存储数据库的内存中位图的面向集合的锁定。示例性方法包括建立包括主存储和增量存储的基于列的存储器内数据库，其中增量存储具有在不同时间点对事务可见的多个行可见性锁定位图。锁定位图表示一个位编码，指示是否在数据库中授予了行锁表。用表上的事务执行删除或更新语句。请求由delete或update语句操纵的表的行上的一组行锁排除其他事务当前正在删除或更新相同的行。因此，在锁定位图上执行设置操作以管理与事务相关联的行锁集合。

5. 发明申请

US20150019516A1 Providing Durability of In-Memory Columnar Datastores Using Multile Logs 审中-公开
标题翻译：使用Multile Logs提供内存列数据存储的耐久性
公开(公告)号：US20150019516A1
公开(公告)日：2015-01-15
申请号：US13937769
申请日：2013-07-09
申请人： David WEIN , Anil GOEL , Colin FLORENDO
发明人： David WEIN , Anil GOEL , Colin FLORENDO
IPC分类号： G06F17/30
CPC分类号： G06F16/221 , G06F16/215
摘要： Embodiments described herein generally relate to providing durability of in memory columnar datastores using multiple logs. A computer-implemented method is described. The method includes receiving a request to perform a transaction involving multiple tables in a column-oriented database system. The method further includes performing the transaction on each of the two or more database tables. Performance of the transaction generates two or more commit fragments corresponding to each of the two or more database tables. The method further includes writing each commit fragment to a transaction log for each of the two or more database tables. The method also includes writing a commit record for the transaction to a commit log after all commit fragments have been written.
摘要翻译：本文描述的实施例通常涉及使用多个日志提供存储器柱状数据存储的耐久性。描述了计算机实现的方法。该方法包括在面向列的数据库系统中接收执行涉及多个表的事务的请求。该方法还包括在两个或多个数据库表中的每一个上执行事务。事务的性能生成与两个或多个数据库表中的每一个相对应的两个或更多个提交片段。该方法还包括将每个提交片段写入两个或多个数据库表中的每一个的事务日志。该方法还包括在写入所有提交片段之后，将事务的提交记录写入提交日志。

6. 发明申请

US20090037367A1 System and Methodology Providing Workload Management in Database Cluster 有权
标题翻译：在数据库集群中提供工作负载管理的系统和方法
公开(公告)号：US20090037367A1
公开(公告)日：2009-02-05
申请号：US11840283
申请日：2007-08-17
申请人： David Wein
发明人： David Wein
IPC分类号： G06F17/30
CPC分类号： G06F9/5083 , G06F9/5061 , G06F11/2035 , G06F11/2046 , G06F11/2097 , G06F11/3409 , G06F11/3433 , G06F17/30306 , G06F2201/80 , G06F2209/5019 , G06F2209/5022
摘要： A system and methodology providing workload management in a database cluster. In one embodiment, for example, a method for allocating workload amongst a plurality of database servers sharing access to data comprises steps of: periodically collecting information about workload at each database server; distributing the workload information to each of the plurality of database servers; in response to a client connected to a first database server requesting that work be performed, examining the workload information to determine whether the requested work should be performed at a second database server having a lower workload than the first database server; if it is determined that the work should be performed at the second database server, automatically transferring the client connection to the second database server and performing the requested work at the second database server; and otherwise, performing the requested work at the first database server.
摘要翻译：在数据库集群中提供工作负载管理的系统和方法。在一个实施例中，例如，在共享数据访问的多个数据库服务器之间分配工作负荷的方法包括以下步骤：周期性地收集关于每个数据库服务器上的工作负载的信息; 将所述工作负载信息分配给所述多个数据库服务器中的每一个; 响应于连接到第一数据库服务器的客户端请求执行工作，检查工作负载信息以确定是否应该在具有比第一数据库服务器低的工作负载的第二数据库服务器上执行所请求的工作; 如果确定应在第二数据库服务器处执行工作，则自动将客户端连接传送到第二数据库服务器并在第二数据库服务器执行所请求的工作; 否则，在第一数据库服务器处执行所请求的工作。

7. 发明授权

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.

8. 发明授权

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.

9. 发明申请

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.
摘要翻译：本文公开的主题提供了由于翻转而重新格式化页面的方法。可以维护保存数据列的内存中阵列。可以维护一个或多个页面。每个页面可以有一行或多行存储数据列。可以监视内存中阵列中的数据列，以进行更改。可以基于更改在至少一个页面上执行翻转。翻转可以通过重写与至少一个页面相关联的元数据来重新格式化至少一个页面。还描述了相关装置，系统，技术和制品。

10. 发明申请

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.
摘要翻译：本文公开的主题提供了将数据从存储器阵列实现到一个或多个页面的方法。可以维护保存数据列的内存中阵列。可以维护一个或多个页面。一个或多个页面中的每一个可以具有用于存储数据列的一行或多行。可以标记一个或多个页面中的至少一个以实现。可以通过将数据从内存阵列复制到一个或多个页面的一行或多行来实现数据列。实现可以基于标记。还描述了相关装置，系统，技术和制品。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式