Technology Flows Downstream

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715841

    Comments posted to this topic are about the item Technology Flows Downstream

  • David.Poole

    SSC Guru

    Points: 75191

    This is following a trend.  At both the AWS RE:Invent and Microsoft Ignite,  Snowflake DB played a prominent role.

    Similarly we have Vertica runing in EON Mode.

    The local caching strategies on the compute nodes makes or breaks these sorts of systems.  The separation of compute from storage means that you could have two or more completely separate data marts, each with very different load and access patterns accessing the same data.  At the same time you can have a third "data warehouse" in Snowflake terms or "sub cluster" in Vertica terms that is used for ETL work.  AWS S3 storage is eleven 9s resilient so that is a step up.

    As the compute nodes are focussed on compute and don't have to worry about storage you can see a noticeable performance improvement.  Again, I stress that it all depends on the way in which the data is cached on the compute nodes.

     

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715841

    An important trend as workloads increase. Most of us would prefer more machines to grow a load than a larger single machine.

  • Eric M Russell

    SSC Guru

    Points: 125020

    I'm not sure if a current or near future SQL edition will do this, but in Cosmos DB, throughput is provisioned using request units per second (RU/s), so the number of compute nodes elastically scale automatically without the need for purchasing vCores or choosing a DTU tier. It will even horizontally scale (automatically redistributing) data partitions across replicas.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply