[Wranglers] Databases that added support for Translytical workloads in 2024
Ali, Saqib
docbook.xml at gmail.com
Sun Jan 12 13:55:21 UTC 2025
One thing I like about the hybrid tables in Snowflake is that it supports
all the advanced analytics functions like match_recognize, dynamic pivot
etcs.
On Fri, Jan 10, 2025 at 5:55 PM Ali, Saqib <docbook.xml at gmail.com> wrote:
> 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/20250112/eef8610d/attachment.htm>
More information about the Wranglers
mailing list