2results about How to "Avoid scanning" patented technology

This application relates to a method and system for comparing table data in a row-oriented storage database. The method includes: acquiring the database to be verified; collecting business characteristics, constructing a B+ tree index, and partitioning the database; sequentially locating the difference partitions, difference rows, and difference fields based on the B+ tree index and partitioning combined with hash calculation; and outputting the comparison results based on the difference fields. This embodiment achieves rapid location and on-demand reading of difference partitions in a row-oriented storage database. By sequentially locating the difference partitions, difference rows, and difference fields based on the B+ tree index and partitioning combined with hash calculation, it achieves rapid identification of the partitions containing the difference data, avoiding a full scan of irrelevant data, thereby significantly reducing disk I / O, memory usage, and bandwidth consumption, improving verification efficiency, and reducing resource overhead.

The invention belongs to the technical field of distributed optical fiber sensing, and particularly relates to a BOCDA optical fiber sensing device and method based on linear frequency modulation pulse pumping. Comprising a laser, an optical fiber coupler, a first electro-optic phase modulator, a first erbium-doped optical fiber amplifier, an optical isolator, a sensing optical fiber, a second electro-optic phase modulator, an electro-optic intensity modulator, an electro-optic pulse signal modulator, a scrambler, a second erbium-doped optical fiber amplifier, an optical circulator, an optical filter, a photoelectric detector and a low-pass filter. And a data acquisition and analysis system. Due to the fact that the frequency of the pump light pulse changes linearly, the change of the probe light amplitude along with time directly carries Brillouin gain spectrum information, scanning of the frequency difference of the pump probe light is avoided, one-time measurement can be completed only through one-dimension scanning, and the measurement time of the BOCDA optical fiber sensor is greatly shortened.