The invention discloses a high-
concurrency database page consistency reading method and
system connected with massive power distribution terminals, and relates to the technical field of
database management, and the method comprises the steps: checking whether a visible tuple offset
list of a current page is empty or not when an MVCC
database storage engine is updated in situ to trigger a sequential scanning operation; if the
original data page is empty, reading the
original data page from the buffer area;
copying the
original data page to generate a page copy, performing unsubmitted transaction
rollback and submitted transaction
rollback on the page copy, and restoring to obtain an MVCC visible page; all tuple pointers in the page are traversed, the tuple pointers are screened, tuple entities are positioned, tuples marked as delayed deletion are filtered, and visible tuples are reserved; and pre-allocating a memory space in the sequential scanning descriptor, covering the copy of the storage page, recording the offset of the visible tuple to a visible tuple offset
list, positioning the visible tuple according to the page and the offset, and returning the visible tuple. According to the invention, the memory allocation and
rollback section access overhead can be reduced, and the sequential scanning performance is improved.