3results about How to "Realize automatic creation" patented technology

The application provides a cross-source synchronization table index creation method and device, equipment, storage medium and program product, which can be applied to the technical field of big data. The method comprises the following steps: receiving a query statement for obtaining data from a data warehouse; extracting a query field set and a condition field set from the query statement; obtaining data from the data warehouse according to the query statement, and synchronizing the obtained data to a target table in an online database, wherein the target table comprises data columns corresponding to the query field set; merging the condition field set into a candidate index field set of the target table; calculating a dispersion index of each field in the candidate index field set based on the condition value distribution corresponding to each field in the candidate index field set; selecting a target field set from the candidate index field set based on the dispersion index; and creating an index for each field in the target field set on the target table.

The utility model discloses a remote transmission communication device based on automatic link establishment, which comprises a remote transmission transceiving module, a surge protection network, a link monitoring module and a control module, and is characterized in that the link monitoring module and the remote transmission transceiving module are electrically connected with the control module; the surge protection network and the link monitoring module are electrically connected with the remote transmitting and receiving module, the surge protection network is electrically connected with a covered wire, and the remote transmitting and receiving module is electrically connected with an upper computer. According to the utility model, after the covered wire is connected with the remote transmitting and receiving module at the far end, the control module detects the link synchronization state, and performs master-slave mode switching according to the link state to realize automatic link establishment, thereby realizing remote transmission of data at two ends.

The application relates to the field of oil drilling and borehole technology, and discloses a multistage ball-throwing type hydraulic variable-diameter while-drilling reamer, which comprises a shell, an upper joint and a lower joint, a mandrel body is slidably connected in the shell, the outer wall of the mandrel body is provided with mandrel guide rails with gradually decreasing outer diameters, the inner side of a rotary connecting blade wing in the shell abuts against the mandrel guide rails, a limiter is arranged on the bottom end of the mandrel body, a positioning block on the shell is slidably connected in a broken line-shaped groove on the outer wall of the limiter, a ball-throwing seat is slidably connected below the limiter, the two are drivingly connected through a shift pin and a groove structure, a plurality of claw bodies are arranged in an array on the inner wall of the ball-throwing seat, a reset base plate is arranged on the bottom end of the ball-throwing seat, a heavy spring is arranged below the reset base plate, and a collector is arranged in the lower joint. The mandrel guide rails are driven to go up and support the blade wing to expand the hole through ball-throwing pressure holding, the positioning block guides the limiter to rotate and shift gears and drives the claw bodies to spread and release pressure, the heavy spring is rebounded, multistage variable-diameter and automatic pressure release in single-trip drilling are realized.