Abstract: Computer-readable media, methods, and systems are disclosed for utilizing partition-based locking mechanisms to improve execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. A first node receives a DML statement associated with a first transaction. The first node acquires a intent exclusive lock on table metadata. A second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. Next, an intent exclusive lock is acquired for the relevant partition table data on the second node and an exclusive lock on table metadata on the second node. The second transaction waits for the DML operation of the first transaction to complete. Then the first transaction is committed. Finally exclusive locks are acquired on table data and metadata and the second transaction is executed and committed.

Abstract: A high-frequency composite impactor including a high-frequency axial and a torsional impact assembly is disclosed. The high-frequency axial impact assembly includes an upper self-excited oscillation cavity, a lower self-excited oscillation cavity, an adjustment block and a lock nut. The torsional impact assembly includes an upper end cover, a reversing switch, a pendulum, a lower shell, a lower end cover, a nozzle, a connecting block and a retaining ring. The high-frequency axial impact assembly converts the flowing drilling fluid into a pulsed jet to achieve a high-frequency axial impact. The torsional impact assembly enables a torsional impact through a shunt, and finally enables a high-frequency composite impact, which can effectively reduce the stick-slip of the drill string, jump drilling and other downhole accidents. By reducing the friction between the drill string and the borehole wall, the impactor can reduce WOB loss, increase the ROP, and improve the drilling efficiency.

Abstract: A method of cyclic etching, comprising: (A) depositing, prior to cyclically etching a substrate through a mask opening, a pre-etch protection layer conformally over the mask, sidewalls of the mask defining the mask opening; and an exposed portion of the substrate exposed through the mask opening, the pre-etch protection layer deposited to a first thickness; and (B) cyclically etching the substrate by: (i) depositing a protection layer in the opening of the mask, the protection layer deposited to a second thickness that is less than half of the first thickness; (ii) etching through a portion of the protection layer disposed on the substrate and etching the substrate; and (iii) repeating (i) and (ii) until an end point is reached.

Abstract: Computer-readable media, methods, and systems are disclosed for database table partition pruning based on statistical information associated with non-partition columns. A tree partition specification is received defining partitions for a plurality of computed column statistics. Respective partitions are created for the plurality of computed column statistics based on the tree partition specification. A request is received to compute statistics for a plurality of columns of the plurality of computed column statistics to result in a plurality of computed column statistics. In response to determining that one or more modifications have been made to the partitioned database, the plurality of computed column statistics is marked as invalid. The computed column statistics are refreshed in response to modifications of the partitioned table. Thereafter, the statistics are marked as valid. Unnecessary table partitions are pruned based on the statistics, and the associated query is executed.

Abstract: A method and device for restoring and reconstructing a light source spectrum based on a hyperspectral image are provided. A hyperspectral image is processed to obtain a first maximum spectrum. The first maximum spectrum is matched with a light source spectral basis vector set in a light source spectrum dictionary, and a linear decomposition is performed to obtain a dictionary set. The maximum value of each waveband is obtained and iterative approximation is performed. Therefore, it can quickly restore the spectrum of the light source of the shooting environment from a single hyperspectral image using a relatively simple calculation process, and can still achieve a good restoration effect for monochromatic image scenes or image scenes with few colors, even close to the real light source spectrum. After the light source spectrum is obtained, this information can be further utilized for different kinds of applications.

Abstract: A method and device for restoring and reconstructing a light source spectrum based on a hyperspectral image are provided. A hyperspectral image is processed to obtain a first maximum spectrum. The first maximum spectrum is matched with a light source spectral basis vector set in a light source spectrum dictionary, and a linear decomposition is performed to obtain a dictionary set. The maximum value of each waveband is obtained and iterative approximation is performed. Therefore, it can quickly restore the spectrum of the light source of the shooting environment from a single hyperspectral image using a relatively simple calculation process, and can still achieve a good restoration effect for monochromatic image scenes or image scenes with few colors, even close to the real light source spectrum. After the light source spectrum is obtained, this information can be further utilized for different kinds of applications.

Abstract: A method for extracting spectral information of a substance under test includes: identifying a pixel region A(x, y) occupied by an object under test from a hyperspectral image acquired; extracting a specular reflection region Aq and a diffuse reflection region Ar from the pixel region A(x, y), and calculating a representative spectrum Iq(?) of the specular reflection region Aq and a representative spectrum Ir(?) of the diffuse reflection region Ar, respectively; by comparing each element in the representative spectrum Iq(?) of the specular reflection region Aq with each element in the representative spectrum Ir(?) of the diffuse reflection region Ar, separating information of a light source from spectral information of the object to obtain a first spectral invariant C(?). This method does not require additional spectral information of the light source, which improves the analysis efficiency.

Abstract: A method of cyclic etching, comprising: (A) depositing, prior to cyclically etching a substrate through a mask opening, a pre-etch protection layer conformally over the mask, sidewalls of the mask defining the mask opening; and an exposed portion of the substrate exposed through the mask opening, the pre-etch protection layer deposited to a first thickness; and (B) cyclically etching the substrate by: (i) depositing a protection layer in the opening of the mask, the protection layer deposited to a second thickness that is less than half of the first thickness; (ii) etching through a portion of the protection layer disposed on the substrate and etching the substrate; and (iii) repeating (i) and (ii) until an end point is reached.

Abstract: A carburization method for steel is contemplated, with austenitic stainless steel showing particular promise. The surface is first passivated with an acidic solution and then subjected to low temperature (between ˜350 to 550° C. or between ˜650 to 1,000° F.) carburization in the presence of a concentrated carbon solution (e.g., carbon monoxide, hydrogen gas, and nitrogen gas), followed by a repeated cycle of passivation and carburization under identical conditions but for a comparatively shorter period of time relative to the first cycle. The carburized surface is allowed to cool and cleaned, after which the resulting surface is shown to have ultrahigh tensile strength, increased interatomic bonding strength, and lowered electrical and thermal conductivity. To the extent this method can be employed to completely saturate and penetrate the workpiece (e.g., a foil), the resultant material and article are formed entirely from a novel composition.

Abstract: Provided are a method for screening for nanobodies and a corresponding system. The method uses polymerase chain reactions and cDNA 5? end rapid amplification technology to screen for and obtain nanobodies. The experiment cycle requires only approximately 21 days.

Abstract: A method for determining an end of a tailback in road traffic includes providing a signal quality map for a cell of a base station of a mobile radio system, where the signal quality map includes overview information about signal qualities occurring within the cell. The method also includes determining signal quality information for each of a plurality of mobile radio communication devices connected to the base station, and determining a probability density function based on determined signal quality information. A location is determined of the probability density function having a function gradient which corresponds to an angular amount of at least 75° with respect to a horizontal function axis of the probability density function, where the location is indicative of a tailback limit in the cell of the base station. A location of the tailback limit is then determined based on the determined location and the signal quality map.

Abstract: A carburization method for steel is contemplated, with austenitic stainless steel showing particular promise. The surface is first passivated with an acidic solution and then subjected to low temperature (between ˜350 to 550° C. or between ˜650 to 1,000° F.) carburization in the presence of a concentrated carbon solution (e.g., carbon monoxide, hydrogen gas, and nitrogen gas), followed by a repeated cycle of passivation and carburization under identical conditions but for a comparatively shorter period of time relative to the first cycle. The carburized surface is allowed to cool and cleaned, after which the resulting surface is shown to have ultrahigh tensile strength, increased interatomic bonding strength, and lowered electrical and thermal conductivity. To the extent this method can be employed to completely saturate and penetrate the workpiece (e.g., a foil), the resultant material and article are formed entirely from a novel composition.

Abstract: A method for determining an end of a tailback in road traffic includes providing a signal quality map for a cell of a base station of a mobile radio system, where the signal quality map includes overview information about signal qualities occurring within the cell. The method also includes determining signal quality information for each of a plurality of mobile radio communication devices connected to the base station, and determining a probability density function based on determined signal quality information. A location is determined of the probability density function having a function gradient which corresponds to an angular amount of at least 75° with respect to a horizontal function axis of the probability density function, where the location is indicative of a tailback limit in the cell of the base station. A location of the tailback limit is then determined based on the determined location and the signal quality map.

Abstract: Provided are a method for screening for nanobodies and a corresponding system. The method uses polymerase chain reactions and cDNA 5? end rapid amplification technology to screen for and obtain nanobodies. The experiment cycle requires only approximately 21 days.