SQL data warehouse yog dab tsi?
SQL data warehouse yog dab tsi?

Video: SQL data warehouse yog dab tsi?

Video: SQL data warehouse yog dab tsi?
Video: SSAS - Creating a Data Source and Data Source View 2024, Kaum ib hlis
Anonim

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.

Ntawm no, qhov txawv ntawm SQL Database thiab SQL data warehouse yog dab tsi?

Hauv kev xyaum, SQL database ” tau los xa mus rau ib qho twg cov ntaub ntawv repository raws li SQL ntawv ; xws li MySQL, Oracle, SQL ntawv Server. A SQL database feem ntau yog siv los khaws cia cov ntaub ntawv thaum a cov ntaub ntawv warehouse yog siv feem ntau los pab txhawb kev tshaj tawm thiab kev txheeb xyuas ntawm cov ntaub ntawv (qhov chaw khaws cia yog qhov thib ob rau lub cov ntaub ntawv tsom xam muaj nuj nqi.)

Tsis tas li ntawd, kuv yuav teeb tsa SQL cov ntaub ntawv 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:

Tsis tas li ntawd, Microsoft cov ntaub ntawv warehouse yog dab tsi?

A cov ntaub ntawv warehouse yog ib tug centralized repository ntawm integrated cov ntaub ntawv los ntawm ib lossis ntau qhov chaw sib txawv. Cov ntaub ntawv warehouses khaws tam sim no thiab keeb kwm cov ntaub ntawv thiab siv rau kev tshaj tawm thiab kev txheeb xyuas ntawm cov cov ntaub ntawv . Raws li cov cov ntaub ntawv yog txav mus los, nws tuaj yeem raug formatted, ntxuav, validated, summarized, thiab reorganized.

Dab tsi yog qhov txawv ntawm Azure SQL database thiab Azure cov ntaub ntawv warehouse?

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);

Pom zoo: