FIELD: information technology.
SUBSTANCE: databases are created in form of relational tables, each described by metadata and containing data arranged into rows of identical structure, each row being identified by a unique number and represented by a set of fields with given data types. The method includes a step of creating a single log which consists of a user-defined number of files of a given size, among which are formed entries, each describing a update redo only on one page of one of the database tables and is intended to redo update in a database that was not recorded in external memory. Further, the method includes undoing all incomplete transactions on a logic level. Restart is performed in three cycles: analytical, redo cycle and undo cycle.
EFFECT: high accuracy of recovering data in databases of database management systems up to the last consistent state of databases without the need for additional random-access memory and external memory for logging.
4 cl, 6 dwg
Title | Year | Author | Number |
---|---|---|---|
REDO LOGGING FOR PARTITIONED DATA SET IN MEMORY | 2016 |
|
RU2654144C1 |
METHOD OF PROCESSING USER REQUESTS BY DISTRIBUTED INFORMATION SYSTEM | 2015 |
|
RU2606315C1 |
OPTIMISING SOFTWARE TRANSACTIONAL MEMORY OPERATIONS | 2006 |
|
RU2433453C2 |
EXTENDED STORAGE WITHOUT LOCKS FOR MULTIPLE ACCESS METHODS | 2014 |
|
RU2672719C2 |
METHOD OF ORGANIZING STORAGE OF HISTORICAL DELTAS OF RECORDS | 2017 |
|
RU2647648C1 |
WAY OF THE LINKED DATA STORAGE ARRANGEMENT | 2016 |
|
RU2621628C1 |
METHOD AND SYSTEM FOR GRANULAR RECOVERY OF BACKUP COPY OF DATABASE | 2024 |
|
RU2825077C1 |
DYNAMICALLY ALLOCATED DATABASE WITH TOPOLOGICAL INFORMATION BINDING | 2021 |
|
RU2780979C1 |
FLUSHING IN FILE SYSTEM | 2014 |
|
RU2671049C2 |
METHOD OF REPLICATION OF INFORMATION IN DATABASES | 2018 |
|
RU2706482C1 |
Authors
Dates
2014-08-27—Published
2013-06-20—Filed