2results 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.