The Guide for Time Series Data Projects is out.

Download now
Skip to content
Time Series

Time Series Data Modeling

← Go back to Time Series Data

CrateDB is not only a pure time series database; it also accommodates a variety of data types such as JSON, geospatial, vectors, full-text search, and binary large objects (BLOBs).

  • Relational and Time Series Data: CrateDB uses a simple relational representation of time series data, allowing easy querying with standard SQL, including window and aggregation functions.
    -- Read more on CrateDB as a relational database or time series database

  • Document/JSON Data: CrateDB supports JSON data, which is ideal for importing/exporting time series data. It allows direct insertion of JSON payloads with new attributes automatically indexed.
    -- Read more on CrateDB as a JSON database

  • Full-Text Search: CrateDB handles textual data effectively, offering robust full-text search capabilities for exact matches, typos, phrases, and synonyms.
    -- Read more on CrateDB as a search engine

  • Vector Search: CrateDB supports float vector data type for columns, accommodating up to 2048 dimensions. It uses a Hierarchical Navigable Small World graph for efficient indexing of vectors.
    -- Read more on CrateDB as a vector database

  • Geospatial Data: It handles geospatial data, enabling tracking of changes over time in a geographic area, vital for numerous applications.
    -- Read more on CrateDB as a geospatial database

  • Binaries (BLOBs): CrateDB manages binary large objects (BLOBs) efficiently, crucial for multimedia content or large log files in time series applications.
    -- Read more on CrateDB for BLOBs

Time Series Data Modeling

In this tutorial video, we explore time series data modeling in CrateDB. We will see that CrateDB is not just a time series database; it supports various different data types. Then, we will showcase the use of native SQL and how to query different data types.

Watch the video >

Modeling Data in CrateDB

The workshop introduces the fundamental concepts of CrateDB, and how it can be used to efficiently store, query, and analyze large amounts of data. You will learn how to efficiently model data in CrateDB.

Watch the video >

Guide for Time Series Data Projects

CrateDB simplifies SQL querying for timestamped, append-only records and supports JSON data for storing arbitrary contextual details. CrateDB also handles textual data, floating-point vectors, geospatial data, and binary large objects (BLOBs) efficiently. Its strong full-text search capabilities, spatial context provision through geospatial data, and efficient handling of BLOBs make it an excellent choice for managing complex time series data.

Whitepaper: "Guide for Time Series Projects: Data Modeling, Storage, and Lifecycle with CrateDB"

Discover other time series topics

Interested in learning more?