Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

114 results about "Bitmap index" patented technology

A bitmap index is a special kind of database index that uses bitmaps. Bitmap indexes have traditionally been considered to work well for low-cardinality columns, which have a modest number of distinct values, either absolutely, or relative to the number of records that contain the data. The extreme case of low cardinality is Boolean data (e.g., does a resident in a city have internet access?), which has two values, True and False. Bitmap indexes use bit arrays (commonly called bitmaps) and answer queries by performing bitwise logical operations on these bitmaps. Bitmap indexes have a significant space and performance advantage over other structures for query of such data. Their drawback is they are less efficient than the traditional B-tree indexes for columns whose data is frequently updated: consequently, they are more often employed in read-only systems that are specialized for fast query - e.g., data warehouses, and generally unsuitable for online transaction processing applications.

Gray-code-based distributed data layout method and query method

InactiveCN102890678AImplement aggregation queryImprove the efficiency of sequential accessSpecial data processing applicationsTheoretical computer scienceEngineering
The invention belongs to the technical field of a database, and discloses a gray-code-based distributed data layout method. The method comprises the steps of: dividing a range of each attribute into a plurality of equal portions; encoding according to a gray code order; marking a certain attribute value of a tuple comprising a plurality of attributes through the gray codes of the equal portions of the attribute value, namely an index code of the attribute value; forming an index key value of the tuple by mixing the index code of each attribute value in the tuple, wherein the tuple achieves the distributed data layout according to the order of the gray codes, the distributed data layout is deployed on a distributed system, the bitmap index of content perception is achieved at a host computer terminal of the system and the content perception is stored in a file name, and physical storage of data and statistical index of the data are achieved on a slave terminal of the system. The invention also discloses a query method employing the database formed by means of the method. The data layout obtained by the method can meet the requirements of data processing such as exact matching search, range search, multi-dimensional search, multi-attribute search and aggregated analysis, and the method is high in disc access efficiency.
Owner:EAST CHINA NORMAL UNIVERSITY

Bitmap index compressing method and bitmap index decompressing method

The embodiment of the invention provides a bitmap index compressing method and device. Bitmap information of segments of bitmap indexes corresponding to an index key word is obtained according to preset segment width segments, deviation values of effective values of the bitmap information of the segments are stored according to the corresponding binary storage digits, compression information of the bitmap information of the segments is obtained, and due to the fact that only the deviation values of the effective values in the bitmap information of the segments are stored, storage space of the bitmap indexes can be reduced. Correspondingly, the embodiment of the invention provides a bitmap index decompressing method and device, storage bits of binary representation information of the deviation values of the effective values are utilized for obtaining the deviation values of the effective values in the compression information of the bitmap information of the segments, the bits corresponding to the deviation values of the effective values in initialized bitmap information are arranged to be the effective values, decompression information corresponding to the compression information of the bitmap information of the segments is obtained, the decompression complexity of the bitmap indexes can be reduced, and the searching query efficiency of the bitmap indexes is improved.
Owner:SHANGHAI DAMENG DATABASE

System and method for indexing queries, rules and subscriptions

This invention introduces a new concept called virtual construct intervals (VCI), where each predicate interval is decomposed into one or more of these construct intervals. These VCIs strictly cover the predicate interval. Namely, every attribute value covered by the predicate interval is also covered by at least one of the decomposed VCIs, and vice versa. Each construct interval has a unique ID or interval coordinate and a set of endpoints. A construct interval is considered activated when a predicate interval using it in its decomposition is added to the system. The predicate ID is then inserted into the ID lists associated with the decomposed VCIs. To facilitate fast search, a bitmap vector is used to indicate the activation of VCIs that cover an event value. The challenge is to find an appropriate set of construct intervals to make predicate decomposition simple and, more importantly, to build efficient bitmap indexes. Because each construct interval covers only a small range of attribute values, the invention also uses bitmap clipping to cut unnecessary bitmap storage. To facilitate bitmap clipping, the invention introduce the covering segment concept. Bit positions outside a covering segment are pruned.
Owner:INT BUSINESS MASCH CORP

Graph data storing method and subgraph enquiring method based on external memory

The invention discloses a graph data storing method and a subgraph enquiring method based on external memories. The invention belongs to the technical field of database. The graph data storing method comprises steps that: (1) graph data formats are unified into a standard graph data format; (2) the edges of the graph data are classified and stored according to the tag information of the starting point and the end point of each edge of the graph data, and a B+-Tree index is established for each class of edges; (3) the points of the graphs are divided into a plurality of domains according to the tag information of each point of the graph data, wherein the points in a same domain orderly corresponds to a bit according to the sequence of identifiers; then, according to the tag information of the starting points and the end points of the edges, a bitmap index is established for each class of edges in the step (2); and (4) a starting point data histogram and an end point data histogram are established for each class of edges. The subgraph enquiring method comprises steps that: first, a subgraph to be enquired is decomposed; then the sub-modules obtained through decomposition are enquired; and the enquiry results are integrated. The methods provided by the invention have characteristics of high enquiring efficiency and good extensibility.
Owner:PEKING UNIV

Indexing method of distributed column storage system

The invention discloses an indexing method of a distributed column storage system. The method comprises the steps of obtaining distribution characteristics of each column of data, and setting a domain value and a division rule of each column of data; obtaining a continuous data area after division according to the domain value and the division rule; establishing an area coding vector corresponding to each data area; performing statistic calculation to obtain statistic information of each column of data, and combining the statistic information with the corresponding area coding vector to obtain an area coding vector with the statistic information; and performing data indexing by taking the area coding vector with the statistic information as a bit vector of a bitmap index. According to the indexing method of the distributed column storage system, a division mode of the grouping bitmap index conforms to a query filtering condition by setting the domain value and the division rule of each column of data; and by calculating the statistic information of the column data, the accuracy of grouping bitmap query is improved, the statistic information of the data in the column storage system can be reserved, and the integrity of data information is ensured.
Owner:BEIJING GUODIANTONG NETWORK TECH CO LTD +3
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products