Organization of multi-access in databases
A particular, but important problem of freeing database memory in multi-access conditions is considered. A number of solutions to this problem are proposed and their advantages and disadvantages are noted. Three methods of organizing work with free space are considered. The first method assumes two...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
EDP Sciences
2021-01-01
|
| Series: | E3S Web of Conferences |
| Online Access: | https://www.e3s-conferences.org/articles/e3sconf/pdf/2021/46/e3sconf_wfces2021_01006.pdf |
| _version_ | 1818897472664109056 |
|---|---|
| author | Kolyeva Natalya |
| author_facet | Kolyeva Natalya |
| author_sort | Kolyeva Natalya |
| collection | DOAJ |
| description | A particular, but important problem of freeing database memory in multi-access conditions is considered. A number of solutions to this problem are proposed and their advantages and disadvantages are noted. Three methods of organizing work with free space are considered. The first method assumes two additional modes of capturing pages: “Joint deletion” and “deletion”. In the second method, the pages after the last tuple have been deleted are inserted at the end of the free list. The third method involves the actual presentation of the freed pages of the relationship to the free memory pool of the segment and is postponed until the relationship is reorganized. |
| first_indexed | 2024-12-19T19:16:43Z |
| format | Article |
| id | doaj.art-564d632391c4465aadec0f3e4352f5af |
| institution | Directory Open Access Journal |
| issn | 2267-1242 |
| language | English |
| last_indexed | 2024-12-19T19:16:43Z |
| publishDate | 2021-01-01 |
| publisher | EDP Sciences |
| record_format | Article |
| series | E3S Web of Conferences |
| spelling | doaj.art-564d632391c4465aadec0f3e4352f5af2022-12-21T20:09:06ZengEDP SciencesE3S Web of Conferences2267-12422021-01-012700100610.1051/e3sconf/202127001006e3sconf_wfces2021_01006Organization of multi-access in databasesKolyeva NatalyaA particular, but important problem of freeing database memory in multi-access conditions is considered. A number of solutions to this problem are proposed and their advantages and disadvantages are noted. Three methods of organizing work with free space are considered. The first method assumes two additional modes of capturing pages: “Joint deletion” and “deletion”. In the second method, the pages after the last tuple have been deleted are inserted at the end of the free list. The third method involves the actual presentation of the freed pages of the relationship to the free memory pool of the segment and is postponed until the relationship is reorganized.https://www.e3s-conferences.org/articles/e3sconf/pdf/2021/46/e3sconf_wfces2021_01006.pdf |
| spellingShingle | Kolyeva Natalya Organization of multi-access in databases E3S Web of Conferences |
| title | Organization of multi-access in databases |
| title_full | Organization of multi-access in databases |
| title_fullStr | Organization of multi-access in databases |
| title_full_unstemmed | Organization of multi-access in databases |
| title_short | Organization of multi-access in databases |
| title_sort | organization of multi access in databases |
| url | https://www.e3s-conferences.org/articles/e3sconf/pdf/2021/46/e3sconf_wfces2021_01006.pdf |
| work_keys_str_mv | AT kolyevanatalya organizationofmultiaccessindatabases |