column-based store for PostgreSql: TimescaleDB extension.self-hosted: ClickHouse, SingleStore, MariaDb ColumnStore, QuestDB.Indexed columns (see parameters setup section below), or by usage of pre-aggregated tables / materialized views.įor a real time big data analytics (billions of rows, TBs in size) you can consider to use specialized columnar databases (data warehouses): In case of moderate size fact tables - up to millions of rows - most popular DBs can do that.įor large tables a dataset size can be limited by applying WHERE conditons on There are no any limitations on the dataset size, however your database should be able to execute aggregate queries fast enough: ideally in seconds (up to 2 minutes max). GROUP BY) on-the-fly to retrieve the necessary data for the report. ĭata is not imported: SeekTable executes aggregate queries ( SELECT. You can configure a 'live' connection to your SQL database and use it as a data source for operational reports (pivot tables, charts, flat tables). Setup SQL database for pivot table reports This documentation page assumes that you already have a SeekTable account.
0 kommentar(er)
