FeatureBase Glossary of terms

Table of contents

0-9
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W - X - Y - Z

0-9

Term	Context	Additional information
1,048,576	FeatureBase Community `batch-size` ingest flag	CSV ingest flags

A

Term	Context	Additional information
ALL	PQL query	PQL ALL read query
Anti-entropy	FeatureBase Community cluster	Anti-entropy is a periodic process that compares each shard and its replicas across a cluster to repair inconsistencies.

APPLY	PQL query	PQL APPLY read query
ARROW	PQL query	PQL ARROW read query
Authentication	FeatureBase Community	Community authentication

B

Term	Context	Additional information
Batch (ingest)	Data import to FeatureBase	BULK INSERT statement
Bitmap Bitmap Index (BMI) Roaring B-Tree format (RBT)	FeatureBase database table rows	FeatureBase uses the Roaring Bitmap format to store data.
Bit Sliced Indexing (BSI)	Multi-bit integer and timestamp data types used for Range, Min, Max and Sum queries	* INT data type * TIMESTAMP data type * MIN query * MAX query * SUM query

C

Term	Context	Additional information
CLEAR	PQL query	PQL CLEAR write query
CLEARROW	PQL query	PQL CLEARROW write query
Cluster	FeatureBase Community	A Cluster configuration of FeatureBase nodes where data is evenly distributed and any node can respond to queries. Also defines how data is replicated and inter-node communication.
Concurrency	SQL/PQL Queries	Number of concurrent users running queries on data and how this may affect query latency
CONSTROW	PQL query	PQL CONSTROW read query
COUNT	PQL query	PQL COUNT read query

D

Term	Context	Additional information
Database	FeatureBase database	Dedicated resources which contain tables and data.
Data source	Source of data imported to FeatureBase	FeatureBase imports data from external data sources via HTTPS, Kafka, SQL or CSV ingest processing
Data types	Table columns	Data types and constraints
DELETE	PQL query	PQL DELETE write query
DIFFERENCE	PQL query	PQL DIFFERENCE read query
DISTINCT	PQL query	PQL DISTINCT read query

E

Term	Context	Additional information
EXTRACT	PQL query	PQL EXTRACT read query

F

Term	Context	Additional information
Field	Table rows	Field data types to group rows into different categories: * `bool` * `int` * `set` * `time` * `timestamp` * Mutex
Fields, ranked	Table rows	Rows kept in sorted order within the field.
Fragment	FeatureBase Community Row fields and database shards	A fragment typically corresponds to a file on disk which represents an intersection of: * field and shard, or * field, shard and `time` data type `time quantum` constraint
Freshness	Data import/ingest	How much time elapses from when a data point is “sensed” by the system, until that data point will affect the results of a query.

G

Term	Context	Additional information
Group By	PQL Query	PQL Group By Query

H

Term	Context	Additional information

I

Term	Context	Additional information
INCLUDESCOLUMN	PQL query	PQL INCLUDESCOLUMN read query
INTERSECT	PQL query	PQL INTERSECT read query
Index	FeatureBase tables	Denormalized top-level container roughly the same as an RDBMS table.
Ingest	Importing data to FeatureBase	Manage community ingest

J

Term	Context	Additional information

K

Term	Context	Additional information

L

Term	Context	Additional information
Latency	SQL/PQL Queries	How much time elapses between when a query is sent to a system and when the results return to the client.

M

Term	Context	Additional information
MAX	PQL Read query	PQL MAX Read query
MAX	SQL `int` constraint	INT data type
MAXSHARD `cluster.maxshard` parameter	FeatureBase Community Cluster flag	Zero-indexed shard allocation for current records, where `maxshard = 0` indicates 1 shard is allocated.
MIN	PQL Read query	PQL MIN Read query
Min	SQL `int` constraint	INT data type
`./molecula-consumer-[csv \| sql \| kafka]`	Community ingest	Manage community ingest
Mutex	String Data type	A FeatureBase field type similar to the Set type, in which only a single value can be set at any time. Conceptually similar to an enum type, but implemented on top of Set fields, with a performance cost from the single-value constraint. Not to be confused with the mutex synchronization primitive.

N

Term	Context	Additional information
Node	FeatureBase Community Cluster	An individual running instance of FeatureBase server which belongs to a cluster.
Normalizing	The act of identifying the cardinality of your data in order to design the relationships between different tables.	FeatureBase concepts
NOT	PQL query	PQL NOT read query

O

Term	Context	Additional information
Options	PQL Options query	PQL OPTIONS

P

Term	Context	Additional information
PERCENTILE	PQL query	PQL PERCENTILE read query
Pilosa	Former name of FeatureBase	Pilosa + Molecula = FeatureBase blog post
Pilosa Query Language (PQL)	Database queries	PQL-Guide
Protobuf		Binary serialization format used for internal messages which can be used by clients as an alternative to JSON. Protobuf

Q

Term	Context	Additional information
Query (PQL)	Pilosa Query Language	PQL Guide
Query (SQL)	Structured Query Language	SQL Guide

R

Term	Context	Additional information
Record Row	Database table row	Equivalent to RDBMS table row. FeatureBase uses “Record” to avoid confusion
Replica `cluster.replicas` parameter	FeatureBase Community Clusters	Replica of shard within a cluster. `cluster.replicas` configuration parameter determines the number of shard replicas within a cluster where `replicas=1` indicates no copies have been made.
Roaring Bitmap	FeatureBase database	roaringbitmap.org
Row		Rows are the fundamental vertical data axis within FeatureBase. Rows are namespaced by field so the same row ID in a different field refers to a different row.
Row `_id`
Row (Ranged)	PQL query	PQL Row read query
Row (Timestamp)	PQL query	PQL Row read query
Rows	PQL query	PQL Rows read query

S

Term	Context	Additional information
SET	PQL query	PQL SET write query
Shard	Roaring Bitmap format	Roaring Bitmap Format
Shard	FeatureBase Community Cluster	FeatureBase Community cluster
ShardWidth `cluster.shardwidth` parameter	FeatureBase Community Cluster	FeatureBase Community cluster
SORT	PQL query	PQL SORT read query
STORE	PQL query	PQL STORE write query
SUM	PQL query	PQL SUM read query

T

Term	Context	Additional information
Throughput	Data import/ingestion	Quantity of data that can be imported/ingested in a given time. May involve trade-off between Latency and Freshness
Time Quantum	SQL IDSET and STRINGSET constraint	IDSET data type STRINGSET data type
Timestamp	Data type	Timestamp data type
TTL (Time To Live)	IDSET and STRINGSET constraint	IDSET data type STRINGSET data type
TOML	FeatureBase Community configuration files	Tom’s Obvious Minimal Language (TOML)
TopK	PQL query	PQL TOPK read query
TopN	PQL query	PQL TOPN read query

U

Term	Context	Additional information
UNION	PQL query	PQL UNION read query
UNIONROWS	PQL query	PQL UNIONROWS read query

V

Term	Context	Additional information
View	FeatureBase fields	Internally managed method to separate data layouts within a field. Not exposed by the API
View (Primary)	FeatureBase fields	Standard view that represents typical base data
View (Time-based)	FeatureBase fields	Automatically generated view for time quantum fields

W - X - Y - Z

Term	Context	Additional information
XOR	PQL query	PQL XOR read query