Method for dynamic data blocking in a database system

US11663275B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Martin Oberhofer · Nagold, DE
• Geetha Sravanthi Pulipaty · Kanchinakote, IN
• Ruolin Wu · Mississauga, CA
• Mohammad Khatibi · Gormley, CA
• Neeraj Ramkrishna Singh · Bengaluru, IN
• Mark I-Kai Wang · Vaughan, CA

Key dates

• Filing date: Apr 6, 2020
• Grant date: May 30, 2023
• Expiry date: Jul 24, 2041

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2455
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A method is disclosed for a database system that includes a set of data blocks comprising records having attributes. The set of data blocks are instances of at least one block type. The block type is defined by a subset of one or more attributes of the attributes. An instance of the block type comprises records having one distinct group of values of the subset of attributes. The method includes detecting that a subset of one or more data blocks of the block type, of the set of data blocks, reached a first maximum number of records. The method includes determining an additional attribute of the attributes to define a new block type by the combination of the additional attribute and the subset of attributes that define the block type. The method includes creating one or more data blocks which are instances of the new block type.