METHOD FOR STORING DATA ELEMENTS IN A DATABASE

摘要

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.

主权项

1. A method for storing a first data element in a database comprising at least one storage medium, a database management unit and at least one communication interface, the database comprising a plurality of tables, the plurality of tables comprising a plurality of rows, the rows comprising a plurality of columns of data elements, the tables being divided into a plurality of data sections, each data section of the plurality of data sections comprising a subset of the plurality of rows and one or more data elements from a column of the plurality of columns, each data section being stored in an individual data section-file in the at least one storage medium, the method comprising:
providing, by a computer processor, at least one table-mapping file for enabling access to a table of the plurality of tables in the storage medium, the at least one table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of one or more of: a table from the plurality of tables, a column of the table, a data section of the table, and a range of values of the one or more data elements included in the data section of the column; receiving, by the computer processor, the first data element at the database via the at least one communication interface; determining, by the computer processor, the table, column, and data section the first data element is to be stored in by the database management unit; storing, by the computer processor, the first data element in the individual data section-file corresponding to the determined table, column and data section by the database management unit; and updating, by the computer processor, the at least one table-mapping file corresponding to the table, columns and data section the first data element has been stored in by the database management unit.