Mechanism for updates on a database engine

摘要

A method for handling a computer database, the method comprising the following steps performed by a server (200) computer for each of one or more columns in each of one or more tables: in a preparation phase database : - assigning at least one primary data structure (110), at least one secondary data structure (120), and at least one tertiary data structure (130); a phase of writing database: - I write content in columns in a compressed format in the at least one primary data structure (110); a phase update database: - write an updated each updated in at least one tertiary data structure (130) of the respective column column of each row, along with a storage key value indicating a corresponding row in at least one primary data structure (110); a phase lookup database: - reading the updated values ​​and key storage at least one tertiary data structure (130), sorting updated by their storage key values ​​and store values ​​classified and keys storage sorted order in the at least one secondary data structure (120), and clean the at least one tertiary data structure (130); - answer a query database asking the at least one primary data structure (110) and at least one secondary data structure (120); a phase confirmation database: - produce a new (110D) version of the at least one primary data structure (110) combining the at least one secondary data structure (120) and an old version (110C) of the at least one primary data structure; where the question and the combination comprising reading a value for a key storage at least one secondary data structure (120) if the value exists or otherwise of at least one primary data structure (110)