公开(公告)号：US10922288B2

公开(公告)日：2021-02-16

申请号：US16358758

申请日：2019-03-20

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/23

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.

公开(公告)号：US10282349B2

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

申请号：US14836042

申请日：2015-08-26

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F17/30 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.

公开(公告)号：US20190220448A1

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

申请号：US16358758

申请日：2019-03-20

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/22

CPC classification number: G06F16/211 ,  G06F16/221 ,  G06F16/2282 ,  G06F16/2372

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.

公开(公告)号：US20170060890A1

公开(公告)日：2017-03-02

申请号：US14836042

申请日：2015-08-26

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30315 ,  G06F17/30339 ,  G06F17/30374

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.

Abstract translation: 在将数据元素存储在数据库中的方法中，数据库管理单元提供表格映射文件，以便能够访问存储介质中的多个表的表，所述表映射文件包括多个映射文件的映射记录 单表，包括指示表的信息，表的列，表的数据部分以及列的数据部分中包括的数据元素的值的范围的映射记录。 该单元通过通信接口在数据库处接收数据元素，确定要存储数据元素的表，列和数据段，并将数据元素存储在与确定的表，列和数据相对应的段文件中 部分。 然后，该单元更新与数据元素已存储的表，列和数据部分相对应的表映射文件。

公开(公告)号：US10255234B2

公开(公告)日：2019-04-09

申请号：US15163336

申请日：2016-05-24

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F17/30 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.

公开(公告)号：US20170060908A1

公开(公告)日：2017-03-02

申请号：US15163336

申请日：2016-05-24

Applicant: International Business Machines Corporation

Inventor： Gordon A. Booman ,  James L. Finnie ,  Oliver Koeth ,  Sunil K. Sarin

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30315 ,  G06F17/30339 ,  G06F17/30374

Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.