Function
Thedatabaseserverisbuiltonthebasisofthedatabasesystem,whichhasthecharacteristicsofthedatabasesystemandhasitsuniqueaspect.Themainfunctionsareasfollows:
Databasemanagementfunctions,includingsystemconfigurationandmanagement,dataaccessandupdatemanagement,dataintegritymanagementanddatasecuritymanagement.
Databasequeryandmanipulationfunctions,includingdatabaseretrievalandmodification.
Databasemaintenancefunctions,includingdataimport/exportmanagement,databasestructuremaintenance,datarecoveryfunctionsandperformancemonitoring.
Databaserunsinparallel.Sincethereismorethanoneuseraccessingthedatabaseatthesametime,thedatabaseservermustsupportaparalleloperationmechanismtohandlemultipleeventsoccurringatthesametime.
Networking
Thenetworkofthedataserverisshowninthefigurebelow.
Advantages
1.Reducedprogrammingamount
ThedatabaseserverprovidesastandardAPI(ApplicationProgrammingInterface)fordatamanipulation.
2.Highdatabasesecurity
Thedatabaseserverprovidestoolsformonitoringperformanceandconcurrencycontrol.TheDBA(DatabaseAdministrator)isresponsiblefortheunifiedauthorizationtoaccessthedatabaseandnetworkmanagement.
3.Datareliabilitymanagement
Thedatabaseserverprovidesunifieddatabasebackup/restore,start/stopdatabasemanagementtools.
4.Fullutilizationofcomputerresources
Thedatabaseserverseparatesdatamanagementandprocessingfromtheclient,sothatthecomputerresourcesinthenetworkcanbeflexiblyallocatedandusedtothefullest.
5.Systemperformanceimprovement
Cangreatlyreducenetworkoverhead.
Coordinateoperations,reduceresourcecompetition,andavoiddeadlocks.
Provideonlinequeryoptimizationmechanism.
6.Easytoexpand
Supportmulti-processor(sametype)horizontalexpansion.
Supporthorizontalexpansionofmultipleservers.
Supportverticalexpansion,theservercanbetransplantedtoamorepowerfulcomputer,anddoesnotinvolvetheredistributionofprocessingdata.