Master database hauv SQL Server yog dab tsi?
Master database hauv SQL Server yog dab tsi?

Video: Master database hauv SQL Server yog dab tsi?

Video: Master database hauv SQL Server yog dab tsi?
Video: What is Database & SQL? 2024, Kaum ib hlis
Anonim

Cov Master database yog thawj configuration database hauv SQL Server . Nws muaj cov ntaub ntawv ntawm tag nrho cov databases uas muaj nyob rau ntawm server , suav nrog lub cev database cov ntaub ntawv thiab lawv qhov chaw. Cov Master database kuj muaj SQL Server cov configuration settings thiab nkag mus rau tus account cov ntaub ntawv.

Hais txog qhov no, dab tsi yog qhov database hauv SQL Server?

A database hauv SQL Server yog tsim los ntawm ib qho kev sau ntawm cov ntxhuav uas khaws cov ntaub ntawv tshwj xeeb. Ib lub rooj muaj cov kab sib sau, tseem hu ua cov ntaub ntawv los yog tuples, thiab kab, kuj hu ua tus cwj pwm.

Ib yam li ntawd, MSDB database hauv SQL Server yog dab tsi? MSDB yog ib qho tseem ceeb database hauv Microsoft SQL neeg rau zaub mov . Cov msdb database yog siv los ntawm cov SQL Server Tus neeg saib xyuas khaws cia cov haujlwm xws li sql server kev ua haujlwm, xa ntawv, kev pabcuam broker, kev npaj kho, tus neeg siv thiab qhov system database backup keeb kwm, thiab lwm yam.. Nws kuj yog siv los ntawm database engine thiab tswj studio.

Tom qab ntawd, ib tug kuj yuav nug, dab tsi yog qhov tseem ceeb ntawm tus tswv system database?

Cov master database yog system database thiab nws muaj cov ntaub ntawv hais txog kev khiav server lub configuration. Thaum SQL Server 2005 raug teeb tsa, nws feem ntau tsim tus tswv , qauv, msdb, tempdb peev txheej thiab kev faib tawm (ob kawg nyob ntawm version ntawm SQL Server) system database los ntawm lub neej ntawd.

Dab tsi yog 3 hom databases?

Ib qho system uas muaj databases npe a database tswj system, los yog DBM. Peb tau tham txog plaub lub ntsiab hom databases : ntawv databases , desktop database programs, kev sib raug zoo database tswj systems (RDMS), thiab NoSQL thiab object-oriented databases.

Pom zoo: