Concepts

An introduction to the core concepts of Kinetica.

Entities

• Collections
• Tables
  • Distribution (Sharding/Replication)
  • Primary Keys
  • Shard Keys
  • Foreign Keys
• Views
  • Filtered
  • Joined
  • Materialized
• Types
  • Data Types
  • Column Properties
• Nulls
• Indexes
  • Primary Key
  • Relational
  • Column

Features

• Compression
• Dictionary Encoding
• Full Text Search
• Protection
• TTL

Operations

• Expressions (Operators/Functions)
• Aggregation
• Iteration
• In-Memory Tables
• Merge Records Tables
• Projections
• Joins
• Set Unions
• Set Intersections (Intersect)
• Set Subtractions (Except)
• Window
• Rollup
• Cube
• Grouping Sets
• Pivot
• Unpivot