OceanBase Database provides a collection of Roaring bitmap functions for processing Roaring bitmap data. You can use these functions to perform complex Roaring bitmap queries and analysis at the database level. This enables user behavior analysis, user profiling, and crowd targeting applications to efficiently store, query, and process Roaring bitmap data.
The following table describes the Roaring bitmap functions supported by OceanBase Database.
Roaring bitmap functions
| Function type | Description |
|---|---|
| Roaring bitmap constructor functions | Construct a Roaring bitmap object. |
| Roaring bitmap cardinality calculation functions | Calculate the cardinality of Roaring bitmap data. |
| Roaring bitmap operation functions | Perform basic operations between Roaring bitmap data, such as intersection, union, XOR, and NAND. |
| Roaring bitmap judgment functions | Perform judgment on the input Roaring bitmap data and return a Boolean value. |
| Roaring bitmap output functions | Specify the output format of bitmap data. For example, you can specify to output each element in a Roaring bitmap in order as a string, and separate the elements with commas (,). |
| Roaring bitmap aggregate functions | Aggregate numeric data into a Roaring bitmap. |