公开(公告)号：US20230168979A1

公开(公告)日：2023-06-01

申请号：US17539640

申请日：2021-12-01

Applicant: International Business Machines Corporation

Inventor： Martin Jungfer ,  Jens Peter Seifert ,  Karl Fleckenstein ,  Thomas Rech ,  Alexander Zietlow ,  Dirk Nakott ,  Holger Hellmuth ,  Hans-Jürgen Zeltwanger

IPC: G06F11/18 ,  G06F11/30 ,  G06F16/2453

CPC classification number: G06F11/181 ,  G06F11/3006 ,  G06F16/24534

Abstract: A tool for replacing a first database node of a database management system by a second database node. The tool receives an indication that the first database node received a data access request for accessing a database shared between the first database node and the second database node. The tool duplicates the data access request at the first database node. Responsive to a determination that the duplicated data access request includes a data changing statement and a previously executed statement, the tool modifies the duplicated data access request to prevent execution of the data changing statement and the previously executed statement at the second database node. The tool executes the modified duplicated data access request at the second database node. The tool replaces, based on a replacement condition being met, the first database node with the second database node in the database management system.

公开(公告)号：US09619502B2

公开(公告)日：2017-04-11

申请号：US14635378

申请日：2015-03-02

Applicant: International Business Machines Corporation

Inventor： Joern Klauke ,  Thomas Rech ,  Jens Seifert ,  Calisto P. Zuzarte

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30315 ,  G06F17/30383 ,  G06F17/30592

Abstract: Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table.

公开(公告)号：US12093139B2

公开(公告)日：2024-09-17

申请号：US17644569

申请日：2021-12-16

Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION

Inventor： Karl Fleckenstein ,  Jens Peter Seifert ,  Hans-Jürgen Zeltwanger ,  Thomas Rech ,  Dirk Nakott ,  Holger Hellmuth ,  Alexander Zietlow ,  Martin Jungfer

IPC: G06F16/00 ,  G06F11/14 ,  G06F16/23

CPC classification number: G06F11/1469 ,  G06F16/2379 ,  G06F2201/84

Abstract: A system and method for a database management system. The method comprises: receiving a database transaction for inserting a set of records in a database table of the database management system or for creating indexes. The database transaction may be executed using the database management system. The database management system may rollback the database transaction by truncating the database table or the created indexes.

公开(公告)号：US09547681B2

公开(公告)日：2017-01-17

申请号：US14291061

申请日：2014-05-30

Applicant: International Business Machines Corporation

Inventor： Joern Klauke ,  Thomas Rech ,  Jens Seifert ,  Calisto P. Zuzarte

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30315 ,  G06F17/30383 ,  G06F17/30592

Abstract: Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table.

Abstract translation: 以表格形式存储数据的各种方式，使得一些记录以行方向存储，并且一些数据以列定向的方式存储。 分别存储在行和列中的方式的记录可以重叠（全部或部分地），一些实施例通过以下方式实现数据的双重取向：（i）使用范围分区;（ii）使用联合全部 视图命令;和/或（iii）使用第一表，暂存表和物化查询表。

公开(公告)号：US09317697B2

公开(公告)日：2016-04-19

申请号：US13750547

申请日：2013-01-25

Applicant: International Business Machines Corporation

Inventor： Albert Maier ,  Thomas Rech ,  Johannes Schuetzner ,  Volker Seemann

IPC: G06F21/00 ,  G06F21/60 ,  G06F17/30 ,  G06F21/62

CPC classification number: G06F21/60 ,  G06F17/30286 ,  G06F17/30566 ,  G06F21/62 ,  G06F21/6209

Abstract: Embodiments related to processing of restricted-access data. An aspect includes receiving a request for data from a user by a storage system infrastructure comprising a centralized database that stores non-restricted access data and a local system that stores restricted-access data associated with a first set of areas or entities and comprising a federated database for providing a federated view, wherein the requested data comprises restricted-access first data and non-restricted access second data. Another aspect includes based on an association of the user, routing, by a routing entity, the request to the local system. Another aspect includes receiving the request at the at least one federated database of the local system. Another aspect includes retrieving from the federated database the restricted-access first data and the non-restricted access second data. Another aspect includes displaying the federated view comprising the restricted-access first data and the non-restricted access second data to the user.

Abstract translation: 与限制访问数据的处理相关的实施例。 一方面包括通过包括存储非受限访问数据的集中式数据库的存储系统基础设施来接收来自用户的数据请求，以及存储与第一组区域或实体相关联的限制访问数据的本地系统，并且包括联合 用于提供联合视图的数据库，其中所请求的数据包括受限访问的第一数据和非受限访问的第二数据。 另一方面包括基于用户的关联，由路由实体将该请求路由到本地系统。 另一方面包括在本地系统的至少一个联合数据库处接收该请求。 另一方面包括从联合数据库检索受限访问的第一数据和非受限访问的第二数据。 另一方面包括向用户显示包括受限访问第一数据和非限制访问第二数据的联合视图。

公开(公告)号：US20150347484A1

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

申请号：US14635378

申请日：2015-03-02

Applicant: International Business Machines Corporation

Inventor： Joern Klauke ,  Thomas Rech ,  Jens Seifert ,  Calisto P. Zuzarte

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30315 ,  G06F17/30383 ,  G06F17/30592

Abstract: Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table.

Abstract translation: 以表格形式存储数据的各种方式，使得一些记录以行方向存储，并且一些数据以列定向的方式存储。 分别存储在行和列中的方式的记录可以重叠（全部或部分地），一些实施例通过以下方式实现数据的双重取向：（i）使用范围分区;（ii）使用联合全部 视图命令;和/或（iii）使用第一表，暂存表和物化查询表。

公开(公告)号：US20250077523A1

公开(公告)日：2025-03-06

申请号：US18457379

申请日：2023-08-29

Applicant: International Business Machines Corporation

Inventor： Dirk Nakott ,  Hans-Jürgen Zeltwanger ,  Jens Peter Seifert ,  Holger Hellmuth ,  Jörn Klauke ,  Martin Jungfer ,  Thomas Rech ,  Malte Schünemann

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2458

Abstract: Methods for capturing temporary database tables for analyzing a database query are provided. Aspects include obtaining a capture pattern and the database query having a sequence of statements. Aspects also include determining that a first statement of the sequence of statements matches the capture pattern, creating a list of temporary tables based on the first statement, and determining that a second statement of the sequence of statements includes one of a drop, commit, and truncate commands that correspond to a table in the list of temporary tables. Aspects further include creating a copy of the table in the list of temporary tables, generating an updated first statement by replacing a reference to the table in the list of temporary tables with a reference to the copy of the table, removing the table from the list of temporary tables, and executing the database query by performing the sequence of statements.

公开(公告)号：US20240311358A1

公开(公告)日：2024-09-19

申请号：US18302022

申请日：2023-04-18

Applicant: International Business Machines Corporation

Inventor： Hans-Jürgen Zeltwanger ,  Dirk Nakott ,  Jens Peter Seifert ,  Holger Hellmuth ,  Jörn Klauke ,  Martin Jungfer ,  Thomas Rech ,  Alexander Zietlow

IPC: G06F16/22

CPC classification number: G06F16/2282

Abstract: In several aspects for storing a table, in which the table is configured for comprising records having values of one or more attributes, a processor creates a pseudo table representing the table, the creating comprising defining an empty version of the table in a program. One or more records may be inserted in the pseudo table by encoding attribute values of the one or more records as inline data in the program. In response to determining that the pseudo table satisfies a materialization criterion, the pseudo table may be materialized by creating the table with the records encoded in the program and removing the program.

公开(公告)号：US20150347483A1

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

申请号：US14291061

申请日：2014-05-30

Applicant: International Business Machines Corporation

Inventor： Joern Klauke ,  Thomas Rech ,  Jens Seifert ,  Calisto P. Zuzarte

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30315 ,  G06F17/30383 ,  G06F17/30592

Abstract: Various ways of storing data in tabular form such that some records are stored in a row oriented manner and some data is stored in a column oriented manner. The records respectively stored in the row and column oriented manners may, or may not, overlap (in whole or in part. Some embodiments accomplish this dual orientation of data by: (i) using a range partition; (ii) using a union all view command; and/or (iii) using a first table, a staging table and a materialized query table.

公开(公告)号：US20130198857A1

公开(公告)日：2013-08-01

申请号：US13750547

申请日：2013-01-25

Applicant: International Business Machines Corporation

Inventor： Albert Maier ,  Thomas Rech ,  Johannes Schuetzner ,  Volker Seemann

IPC: G06F21/60

CPC classification number: G06F21/60 ,  G06F17/30286 ,  G06F17/30566 ,  G06F21/62 ,  G06F21/6209

Abstract: Embodiments related to processing of restricted-access data. An aspect includes receiving a request for data from a user by a storage system infrastructure comprising a centralized database that stores non-restricted access data and a local system that stores restricted-access data associated with a first set of areas or entities and comprising a federated database for providing a federated view, wherein the requested data comprises restricted-access first data and non-restricted access second data. Another aspect includes based on an association of the user, routing, by a routing entity, the request to the local system. Another aspect includes receiving the request at the at least one federated database of the local system. Another aspect includes retrieving from the federated database the restricted-access first data and the non-restricted access second data. Another aspect includes displaying the federated view comprising the restricted-access first data and the non-restricted access second data to the user.

Abstract translation: 与限制访问数据的处理相关的实施例。 一方面包括通过包括存储非受限访问数据的集中式数据库的存储系统基础设施来接收来自用户的数据请求，以及存储与第一组区域或实体相关联的限制访问数据的本地系统，并且包括联合 用于提供联合视图的数据库，其中所请求的数据包括受限访问的第一数据和非受限访问的第二数据。 另一方面包括基于用户的关联，由路由实体将该请求路由到本地系统。 另一方面包括在本地系统的至少一个联合数据库处接收该请求。 另一方面包括从联合数据库检索受限访问的第一数据和非受限访问的第二数据。 另一方面包括向用户显示包括受限访问第一数据和非限制访问第二数据的联合视图。