[Wranglers] Databases that added support for Translytical workloads in 2024

[Ali, Saqib]

Forgot to mention that Snowflake also has Hybrid tables that support OLTP
workloads with ability to define and enforce Primary Keys and Unique Key
constraints.

In general, I think, analytical databases will want to be close to
operational/transactional data to enable insight from operational data as
easily as analytical databases. We will see advanced analytical SQL
functions being supported in these translytical / HTAP / Hybrid tables.

On Fri, Jan 10, 2025 at 4:47 PM Ali, Saqib <docbook.xml at gmail.com> wrote:

> Here are three databases that added support for translytical workloads in
> 2024:
>
>
>    1. SQL DB in Microsoft Fabric. All data is replicated in near-real
>    time to open-source delta parquet format in OneLake. When you deploy a SQL
>    database in Fabric, you get two endpoints: an endpoint to the database and
>    a “SQL analytics endpoint” that allows querying the replicated data in
>    OneLake. This unifies operational and analytics work without having to move
>    any data. With the SQL analytics endpoint, you can query using the data
>    warehouse engine.
>    2. TiDB. Real-time replication of data from OLTP Table to Columnar
>    TiFlash tables. Analytical queries are served by the TiFlash Columnar
>    tables.
>    3. AlloydDB. Enable the Columnar Engine on the AlloyDB and then either
>    manually add columns to the Columnar Engine or use auto-columnarization,
>    which analyzes your workload and automatically adds columns.
>
>
> Saqib
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250110/e5cd7875/attachment.htm>