FIELD: computer equipment.
SUBSTANCE: invention relates to computer engineering. Proposed is a method for adaptive management of free memory space on the storage device when working with databases, in which, when creating a record, for each page of the storage device a metric of a fixed size and a certain type is generated, which is stored separately from the page itself and characterizes the free space on the storage device; data on the average length of records in each table is collected; the type of metric is replaced to more accurately indicate the free space, based on the data collected in the previous step; when a new record is added to the page, a search is made for a page that is suitable for placing the record using the values of metrics; the value of the metric is updated each time a record is written to the page.
EFFECT: technical result is to increase the speed when working in databases using database management systems.
5 cl, 4 dwg, 3 tbl
Title | Year | Author | Number |
---|---|---|---|
METHOD FOR SEPARATING DATABASE OBJECTS BASED ON PRIVACY LABELS | 2017 |
|
RU2676223C1 |
METHOD OF ORGANIZING STORAGE OF HISTORICAL DELTAS OF RECORDS | 2017 |
|
RU2647648C1 |
METHOD OF THE PARTIALLY MATCHING LARGE OBJECTS STORAGE ORGANIZATION | 2017 |
|
RU2656721C1 |
WAY OF THE LINKED DATA STORAGE ARRANGEMENT | 2016 |
|
RU2621628C1 |
METHOD FOR DATA RECOVERY IN DATABASE MANAGEMENT SYSTEM | 2013 |
|
RU2526753C1 |
METHOD AND SYSTEM FOR AUTOMATED GENERATION AND FILLING OF DATA MARTS USING DECLARATION DESCRIPTION | 2022 |
|
RU2795902C1 |
METHOD AND SYSTEM FOR FORMING PARTITIONED DATA MARTS CONTAINING GEODATA AND THEIR USE IN PROCESS OF DATA STORAGE OPERATION | 2023 |
|
RU2811359C1 |
MULTIVARIATE DATABASE AND METHOD OF ACCESS TO MULTIVARIATE DATABASE | 2006 |
|
RU2325690C1 |
EXTENDED STORAGE WITHOUT LOCKS FOR MULTIPLE ACCESS METHODS | 2014 |
|
RU2672719C2 |
DEVICE FOR DETERMINING DISTANCE AND SPEED OF OBJECTS BASED ON STEREO APPROACH | 2012 |
|
RU2582853C2 |
Authors
Dates
2018-11-08—Published
2017-11-28—Filed