Cov txheej txheem:

Puas yog Azure SQL cov ntaub ntawv warehouse columnar?
Puas yog Azure SQL cov ntaub ntawv warehouse columnar?

Video: Puas yog Azure SQL cov ntaub ntawv warehouse columnar?

Video: Puas yog Azure SQL cov ntaub ntawv warehouse columnar?
Video: Managing Azure SQL Server Database Performance Course Preview 2024, Lub peb hlis ntuj
Anonim

Cov ntaub ntawv khaws cia yog ib feem tseem ceeb ntawm huab-raws li, kawg-rau-kawg loj cov ntaub ntawv daws. SQL ntawv Analytics khw muag khoom cov ntaub ntawv hauv cov rooj sib txheeb nrog columnar khaws cia. Hom ntawv no ho txo cov cov ntaub ntawv cov nqi khaws cia, thiab txhim kho cov lus nug kev ua haujlwm. Ib zaug cov ntaub ntawv yog khaws cia, koj tuaj yeem khiav analytics ntawm qhov loj heev.

Hais txog qhov no, Microsoft Azure SQL cov ntaub ntawv warehouse yog dab tsi?

Azure SQL Data Warehouse yog huab-based enterprise cov ntaub ntawv warehouse uas leverages loj heev thaum uas tig mus ua (MPP) kom ceev nrooj cov lus nug nyuaj hla petabytes ntawm cov ntaub ntawv . Siv SQL Data Warehouse raws li ib feem tseem ceeb ntawm ib tug loj cov ntaub ntawv daws.

Ib qho tseem yuav nug, qhov txawv ntawm Azure SQL database thiab Azure cov ntaub ntawv warehouse yog dab tsi? Azure SQL Database yog kev sib txheeb database -as-kev pabcuam siv Microsoft SQL ntawv Server Engine (ntau dua); Azure SQL Data Warehouse yog ib qho kev sib txuas loj heev (MPP) huab-raws li, scale-out, kev sib raug zoo database muaj peev xwm ua cov ntim loj ntawm cov ntaub ntawv (ntxiv);

Kuj paub yog, yog SQL cov ntaub ntawv warehouse?

SQL ntawv database feem ntau yog siv rau kev lag luam hauv online, thaum a cov ntaub ntawv warehouse feem ntau yog siv rau hauv online analytical processing.

Kuv yuav tsim ib lub tsev khaws ntaub ntawv hauv Azure li cas?

Tsim ib lub tsev khaws ntaub ntawv

  1. Nyem Tsim ib qho chaw nyob rau sab laug sab laug ntawm lub Azure portal.
  2. Xaiv Databases los ntawm nplooj ntawv tshiab, thiab xaiv SQL Data Warehouse nyob rau hauv Featured ntawm nplooj ntawv tshiab.
  3. Sau daim ntawv SQL Data Warehouse nrog cov ntaub ntawv hauv qab no:

Pom zoo: