397 results about "On column" patented technology

GUI selected rows of a displayed spreadsheet are collapsed based on column values such that all of the rows having the same value in the selected column are represented by a single collapsed row with an indicator indicating the row is collapsed. All column values of all the rows of the spreadsheet can be collapsed or individual column values can be collapsed. Collapsed rows are expanded for all rows or for a selected row. The expanded rows may be sorted, retain the original sequence but be grouped by column value or may be displayed in the original sequence with rows having different values.

A resistance change memory of an aspect of the present invention including memory cells including resistance change memory element, word lines connected to the memory cells, a row decoder which activates the word lines, redundant cells used instead of defective cells, a redundant word line connected to redundant cells, a redundant row decoder which activates the redundant word line, a control circuit in which defect address information indicating the word line connected to the defective cell is stored and which remedies the defective cell, and regions provided in a memory cell array and a redundant cell array and identified based on column address information, wherein the control circuit replaces a part of the word line connected to the defective cell with a part of the redundant word line in accordance with each of the regions, and allows the redundant row decoder to activate the replaced redundant word line.

The Hamming distance of an array of storage devices is increased by generating a parity check matrix based on column equations that are formed using an orthogonal parity code and includes a higher-order multiplier that changes each column. The higher order multiplier is selected to generate a finite basic field of a predetermined number of elements. The array has M rows and N columns, such that M is greater than or equal to three and N is greater than or equal to three. Row 1 through row M-2 of the array each have n-p data storage devices and p parity storage devices. Row M-1 of the array has n-(p+1) data storage devices and (p+1) parity storage devices. Lastly, row M of the array has N parity storage devices.

Video encoding or decoding utilising a spatial transform operating on rows and columns of a block, with a set of transform skip modes including: transform on rows and columns; transform on rows only; transform on columns only; no transform. An indication of the selected mode is provided to the decoder. Coefficients are scaled by a factor dependent upon the norm of the transform vector of the skipped transform to bring the untransformed image values to the same level as transformed coefficients.

The invention provides a super-resolution confocal microimaging device based on a column polarization vortex beam. The super-resolution confocal microimaging device comprises a pinhole filter, a collimating lens, a polarization and phase transformation system, a pupil filter, an optical filter, a detector and a three-dimensional translational platform, wherein a beam emitted from a laser passes the pinhole filter to obtain a Gauss basic mode beam, the collimating lens collimates the Gauss basic mode beam into the parallel beam, the polarization and phase transformation system allows the parallel beam to pass and obtain the column polarization vortex beam with preset polarization and phase distribution, the pupil filter allows the column polarization vortex beam to pass and to be reflected through a beam splitter and focused on a to-be-detected sample through a collecting lens, light signals reflected from the sample pass the collecting lens and the beam splitter to be incident on the optical filter, and the optical filter only allows a fluorescence signal of the light signals to be transmitted, the fluorescence signal is focused on a detecting pinhole through the collecting lens and is detected and converted, through the detector, into an electrical signal to be output, the sample is placed on the three-dimensional translational platform, detection of the sample at different positions can be realized by moving the three-dimensional translational platform, and accordingly three-dimensional scanning imaging of the sample can be realized.

The invention discloses a production process for extracting gallium from flyash and coal refuse, which recycles gallium by further deep utilizing the produced waste liquid on the basis of extracting alumina, silica gel from coal series solid waste. According to the invention, gallium chloride is acquired after middle temperature calcinations, leaching, carbon dioxide decomposition, direct adsorption on column, eluting, etc., problems of large slag and low slag utilization added value in current technology are solved, the extraction rate of gallium form flyash and coal refuse can reaches over 80%; the whole process is performed under normal atmosphere, thus the equipment requirement is low, resources are effectively utilized during the whole process, and no new pollution is caused to surrounding environment.

Systems, methods and articles of manufacture are disclosed for transposing array data on a SIMD multi-core processor architecture. A matrix in a SIMD format may be received. The matrix may comprise a SIMD conversion of a matrix M in a conventional data format. A mapping may be defined from each element of the matrix to an element of a SIMD conversion of a transpose of matrix M. A SIMD-transposed matrix T may be generated based on matrix M and the defined mapping. A row-wise algorithm may be applied to T, without modification, to operate on columns of matrix M.

The invention relates to a construction and management method for secondary indexes of a key value library and belongs to the technical field of computer data management. The construction and management method for secondary indexes of the key value library mainly aims at performing index on columns in the key value library so as to accelerate range query of the columns. The method includes initializing an index information column family and an index entry column family needed by the secondary indexes of the key value library and setting a comparison type of column names of the column families as a composite column name type; building a batch processing operation list of the secondary indexes to data to be indexed and submitting the completion of an index creation to the key value library; and according to the query requests of a user and with an index name serving as a column key, building a minimum and a maximum of a composite column name with query ranges and obtaining and sending back query results from the index information column family. The method is based on column families of the key value library, indexes are performed by building of the composite column name, most operations of the indexes are column operations, the speed is rapid, and efficient range inquires are facilitated for users.

Methods of reducing high molecular weight species (HMW) formation in a sample containing a protein purified using ion exchange (IEX) chromatography are disclosed, as are a number of related methods, e.g., methods of reducing on-column denaturation of a protein in a protein sample purified using an ion exchange (IEX) column or resin. The methods share characteristics of including arginine, glycine and / or histidine in the buffers used during the ion exchange (IEX) chromatography.

An adjustable weight-loaded dip-chin machine. Dip bars and chin bars with means for vertical adjustment are mounted on columns, which in turn are mounted on a base. An arm is pivotally attached to the base, and weights can be added to an arm spindle attached to the arm. A belt is attached to the arm, and the weighted arm spindle resist upward exerciser motion when performing dips or chins. A pivot hook releasably engages the arm spindle in an elevated position for convenience and safety when commencing and ending a squat exercise series. Means are disclosed for adjusting the height of the pivot hook on a column, and for automatically disengaging the pivot hook from the arm spindle when exercise commences. A squat platform is sized to fit between foot platforms, which together form a stable standing area for the exerciser. Squat handles are height-adjustably mounted to the columns.

The invention discloses a vehicle color identification method based on defogging processing and weight blocking. The method includes the following steps that vehicle images to be identified are collected; preprocessing is conducted on the collected vehicle images; image weight blocking is conducted on the processed images; RGB-to-HSV color spatial switching is conducted on all blocks of images, the images are divided into three independent single channels according to the H component, the S component and the V component, statistics is conducted on column diagrams of different pixels of all the channels, the maximum value in each channel column diagram is found out, the maximum values of the three channels are merged, and the values of the H component, the S component and the V component of the main colors of the blocks of images are obtained respectively; the colors of all the blocking images are searched for, the most common colors in all the blocking images are found out to serve as the alternative colors of the vehicle color, color classification is conducted according to the H value and the V value, and the final vehicle color is determined. The vehicle color identification method has the advantages of being high in accuracy, good in robustness and high in practicability.

The invention provides an inquiry optimizing method based on a column-storage model. The inquiry optimizing method is characterized by comprising steps: receiving input inquiry according to relationship tables from a user; converting into inquiry according to an attribute binary table; generating an initial logic plan tree; optimizing same-table connection sequence for the logic inquiry plan tree generated in the last step; registering a relationship set J for each relationship table according to connection information stored in the logic plan tree; judging the type of the relationship tables according to the set J; optimizing connection sequence of single-event tables; and optimizing connection sequence of multi-event tables. Event tables have relationship with multiple tables, and rest tables are dimension tables. The inquiry optimizing method based on the column-storage model has the advantages that the method is implemented according to characteristics of column-storage data and characteristics of an analytical inquiry request, the quantity of extracted data and intermediate result generated during connection of each step are reduced to the greatest extent, and an inquiry execution strategy with high efficiency is obtained.

An apparatus and method for on-column analysis in flash chromatography. The detection scheme utilizes refractive index changes as analytes move through an illuminated region of a chromatography column. The column packing material is a diffuse scattering medium when the refractive index of the solvent is significantly different than that of the packing material. The magnitude of the signal depends on the degree to which the refractive index mismatch is changed as an analyte passes through the illuminated region. This detection scheme provides a simple, inexpensive means for monitoring the end of a flash chromatography column to determine the exit time of the species of interest, thus greatly reducing the post-column analysis time. Additionally, the detector is movable along the length of the column, offering the potential to monitor separations as they occur.

The invention discloses a multi-core parallel hash partitioning optimizing method based on column storage. The method mainly solves the problem that an existing parallel hash partitioning algorithm can not efficiently use resources of a multi-core processor. According to the technical scheme, data partitioning tasks are dynamically distributed to multiple cores for execution by means of a mapping and simplification parallel programming model, and corresponding strategies for avoiding write conflicts are selected according to different storage structures of column storage data sets; primary hash partitioning is carried out through a mapping thread, and an obtained primary hash partitioning result is sent to a simplification thread for secondary hash partitioning after data tilt optimization; a final hash partitioning result is fed back. According to the method, the characteristic that tasks can be executed in parallel on the multi-core processor is well used, the method can be suitable for input data in various distribution modes, high-speed caching efficiency and overall performance of the multi-core processor are improved, and the method can be used for multi-core parallel multi-step hash partitioning of the column storage data sets.

The invention relates to poly-amide bonded hydrophilic interaction chromatography (HILIC) stationary phases and novel HILIC methods for use in the characterization of large biological molecules modified with polar groups, known to those skilled in the art as glycans. The invention particularly provides novel, poly-amide bonded materials designed for efficient separation of large biomolecules, e.g. materials having a large percentage of larger pores (i.e. wide pores). Furthermore, the invention advantageously provides novel HILIC methods that can be used in combination with the stationary phase materials described herein to effectively separate protein and peptide glycoforms by eliminating previously unsolved problems, such as on-column aggregation of protein samples, low sensitivity of chromatographic detection of the glycan moieties, and low resolution of peaks due to restricted pore diffusion and long intra / inter-particle diffusion distances.

The present invention is an electronic height gauge utilizing new technology and includes a first column (Column 1) and a second column (Column 2), a display unit with a cover, a measuring scriber, a fixed capacitance sensor and a linear moving capacitance sensor. The fixed capacitance sensor is located on a flat surface on Column 1, flat surface having a length equivalent to the length of Column 1. The linear moving capacitance sensor is located inside the display unit cover positioned to face the fixed capacitance sensor. The fixed capacitive sensor and linear moving capacitive sensors are facing toward each other only, and do not make direct physical contact with the fixed capacitor sensor when the height gauge is operating in upward and downward movements. The fixed and moving capacitive sensors are instead making only electrical contact with each other when the height gauge is making upward and downward movements. This linear direct data non-contact sensor transfer system results in high accuracy of measurements, which also ensures the repeatability of accurate measurements. Also, since the fixed capacitance sensor and the linear moving capacitance sensor have no physical contact with each other, there is no wear and tear damage on either component part, thereby leading to a longer life of use with stability in accurate measurements and repeatability. Because the measuring system is comparatively simple, and easy to assemble and service and maintain compared to the existing rotary capacitive sensor electronic height gauges that exist on the market, the overall cost of production and maintenance is minimized. On the second column (Column 2), a simple rack and gear system is added. These gears of column 2 are connected to a hand wheel located on the rear of the display unit. The handwheel is used for making upward and downward vertical movements. This rack and gear system of column 2 of the present invention is only used to aid the same in making upward and downward movements, and does not affect the measuring accuracy of the height gauge, as it did in the height gauges that have existed on the market.

The invention provides a collaborative design method and system for a parent plate and a plate blank of a medium plate oriented to production order combined optimization. The method comprises the following steps: specific to a sub-plate one-dimensional combined optimization design in a medium plate production order, building an optimized control model under the consideration of the constraints of complicated production processes, equipment and the like specific to the aim of minimizing residual materials and material loss, deciding a sub-plate combination way, the length of the parent plate and the length of the plate blank, selectively coding the plate blank section of each order after orders are received, designing a decoding method based on column generation, and generating plate blank and parent plate design schemes; then, searching for a better code string in neighborhood through repeated iterations based on tabu search; and when an end condition is satisfied, selecting a current optimal code string for evaluation and adjustment, and outputting corresponding plate blank and parent plate design results lastly. A system controller controls the design processes of the parent plate and the plate blank of the medium plate according to the method. Through adoption of the collaborative design method and system, residual parent plates and material loss are reduced, and the production demand can be met better.

The present invention relates to a detecting method for small target based on column of infrared line detector in image processing technology field. The target is detected by using method of signal processing and mode identifying according with small target character in each single column scanned formed by each detector. The method needs not to detect target after reconstructing frame image for scanned field image, so detecting speed is increased, and image uneven influence is removed, and can response early. The target detection is processed for single column by using matching filtering, wavelet transformation and FKT arithmetic, and the detecting result is combined for constructing guide head signal process unit with rapid-speed and steadiness characters. The method can great increase target detecting efficiency using infrared column scanner by taking full advantage of scanned image character.

The invention discloses a multi-core synchronization data query optimization method based on column storage. A map-reduce execution flow is constructed aiming at a query plane, and is composed of a plurality of sub-map-reduce flows; the query operation of a database is finished through the execution of the plurality of sub-map-reduce flows; when the plurality of sub-map-reduce flows are executed, a map-reduce model is responsible for distributing each mapping task to different cores and executing, each core is used for orderly determining input-output key value pair of the mapping function and simplifying function according to the operation in the distributed mapping task so as to finish the execution of the query plan. The feature that the tasks can be executed synchronously on the multi-core processor is well utilized, the return time of the great data query result is shortened, and the data query efficiency is improved.

The invention discloses a time sequence database system based on column storage. The time sequence database system comprises: an SQL (Structured Query Language) parser, wherein the SQL parser is usedfor converting SQL into an abstract syntax tree through parsing; a logic plan generator which is used for generating a logic query plan by utilizing the abstract syntax tree, wherein the logic query plan is expressed by a relation algebra; a query optimizer which is used for optimizing the query plan by utilizing the state information of the database and outputting the rewritten query plan; an executor which is used for executing the query plan in a block iteration mode and is responsible for interacting with the storage layer to obtain data queried by a user; and a storage engine which is used for storing data in a row and column manner. According to the invention, data in the database is stored in a column mode; based on combination of column storage and rocksdb, high-speed insertion data characteristics and an indexing function of a traditional database are achieved, in the aspect of an executor, part of operators are improved to be deeply combined with characteristics of a storageengine, and meanwhile, new characteristics of a modern processor are used for accelerating query.

The invention discloses a service dual-active implementation method and system of a big data platform. The method comprises that a Hadoop cluster massive file processing cluster obtains and stores source files and preprocesses source data in the source files; a first cluster processes the data, thus obtaining data processing results and carries out node blocking to the data processing results; related data of the data processing results in the first cluster is synchronized to a second cluster by a synchronization tool; the first cluster and the second cluster are equipped with same numbers of nodes; and node-to-node increment synchronization is carried out between the first cluster and the second cluster by binary data. According to the MPP database architecture based on column storage provided by the invention, the node-to-node increment synchronization is carried out between the homogeneous clusters by the binary data; through transmission of compressed increment file blocks, the batch inquiry is separated; moreover, the online inquiry timeliness is ensured; and the problems of time and resource conflicts between batch processing and online real time inquiry are solved.

The invention relates to a fixture for sintering a semiconductor device and a sintering method for a plurality of tube cores of a semiconductor laser. The fixture comprises a base, a support frame, a cover plate, lifting columns, springs and fixed columns, wherein the support frame is fixedly arranged on the base; the cover plate is arranged on the support frame; the lifting columns are arranged in slotted holes of the cover plates, and extend to a part below the cover plate; the springs are sleeved on column bodies of the lifting columns, and grooves are formed in the bottom surfaces of the lower ends of the column bodies; the fixed columns are inserted into the grooves; and screw holes are formed in the lower lateral surfaces of the lifting columns; screws are screwed into the screw holes, and are used for blocking the springs, and fixing the fixed columns in the grooves. The semiconductor laser is arranged on a heat sink with a solder, the heat sink is arranged under the fixed columns, pressure is applied to the tube cores through the fixed columns under the action of the springs to well fix the tube cores of the laser and the heat sink, the fixture is covered and sealed through a protective cover, and the fixture and the protective cover are arranged on a heating table for sintering. The fixture is simple in structure; and a plurality of semiconductor lasers can be sintered at one time, so that the production efficiency is improved.

Video encoding or decoding utilizing a spatial transform operating on rows and columns of a block, with a set of transform skip modes including: transform on rows and columns; transform on rows only; transform on columns only; no transform. An indication of the selected mode is provided to the decoder. Coefficients are scaled by a factor dependent upon the norm of the transform vector of the skipped transform to bring the untransformed image values to the same level as transformed coefficients.

An adjustable weight-loaded dip-chin machine. Dip bars and chin bars with means for vertical adjustment are mounted on columns, which in turn are mounted on a base. An arm is pivotally attached to the base, and weights can be added to an arm spindle attached to the arm. A belt is attached to the arm, and weights added to the arm spindle resist upward motion of an exerciser performing dips or chins. Elastic bands may be added connecting the arm to the base, and / or the belt to the base, which serve to render the exercise more strenuous. Dip bars incorporate a plurality of dip bar legs, each a differing distance from the other dip bar. Chin bars incorporate a downwardly-sloping dogleg. An alternate embodiment adjustable dip-chin machine incorporates a weight stack which can be attached to the belt. Stack weights selected from the weight stack render exercise more strenuous.

The invention provides a big-data parallel processing system and method based on column storage and relates to the field of big-data processing. The big-data parallel processing system comprises a client-side, a master control node and multiple data nodes, wherein the master control node comprises an HBase master controller and an SQL main engine. The HBase master controller takes charge of management and maintenance of the data nodes, the SQL main engine takes charge of analysis of SQL statements and continuous distribution of the SQL statements to the data nodes. Each data node comprises an HBase subarea node and an SQL sub engine, wherein the HBase subarea node takes charge of data storage and management on each data node, and the SQL sub engine takes charge of analysis and execution of SQL on the data nodes. The master control node and the data nodes comprise HBase tables and further respectively comprise SQL tables. The big-data parallel processing system and method based on the column storage is suitable for an environment with large-scale data volume and provides an SQL interface of a perfect structuralized relational data model.

The invention provides a super-long-span spoke-type suspend-dome structure based on a flying-swallow-type truss arch. A cantilever assembly construction technology of a super-long-span flying-swallow-type truss arch bridge is used for reference, a single-layer net shell is replaced with the flying-swallow-type truss arch manufactured through single-blade double-curved-surface ruled-surface-shaped variable-section steel pipes, thus the bearing capacity and stability of the suspend-dome structure can be enhanced, and the construction difficulty is lowered; an arachnoid suspend-dome cable system is constituted by a radial cable, a circumferential cable, a ring-exterior anchor cable and vertical supporting rods, a saddle paraboloid space cable system is constituted by an on-column rigid arch, a saddle paraboloid space cable, a curved suspension beam, an oblique boom, a tail balance cable and vertical supporting rods, and the two sets of self-balancing cable structure systems cooperatively work and make respective advantages complementary to each other; and a petal-shaped arch shell roof is constituted by a roof arched bracket, truss-type purlins and a petal-shaped roof shell, and thus the appearance is beautiful. The super-long-span spoke-type suspend-dome structure has the advantages that cantilever assembly construction is convenient, the carrying capacity is high, and structural stability is good, and the 200-300-m super-long-span suspend-dome structure can be constructed.

The invention relates to a column-storage-oriented data compression method. The column-storage-oriented data compression method is characterized by comprising a step 1, dividing data stored according to columns into a plurality of areas; a step 2, defining a group of statistic information for the data in the areas; a step 3, sequentially defining a group of statistic quantities for each area by the aid of the statistic information in the step 2, and realizing quantitative estimation according to characteristics of distribution of the data in each area; a step 4, computing a similarity factor between each two adjacent area according to the learned statistic quantities of the two adjacent areas; a step 5, sequentially computing a value of each statistic quantity for the first area in a column, and selecting the values by a compression method according to the statistic values by the aid of a and computing a stepwise selection method; a step 6, computing a similarity factor between each two adjacent areas according to the statistic values of the remaining i area, directly applying compression strategy of the adjacent previous area if the two adjacent areas are similar, selecting a mode according to the compression method in the step 5 and selecting the compression method again; and a step 7, compressing the current area according to the obtained compression method. The compression method is based on column storage, compression is carried out according to the areas, a high-efficiency compression strategy selection method is designed, and column-storage-oriented massive data management can be effectively supported.