WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
1. Data numeric,gtextual,gvisual,gorgaudioginformationgthatgde-
gscribesgreal-worldgsystems.
2. analog Historically,gdatagwasgmostlyg ,gencod-
edgasgcontinuousgvariationsgongvariousgphysicalgmedia.
3. digital Today,gdatagisgmostlyg ,gencodedgas
zerosgandgonesgongelectronicgandgmagneticgmedia.
4. database agcollectiongofgdatagingagstructuredgformat.gIngprinciple,
cangbegstoredgongpapergorgevengclaygtablets.gIngpractice,g
however,gmoderngonesgareginvariablygstoredgongcom-
gputers.
5. databasegsystem softwaregthatgreadsgandgwritesgdatagingagdatabase.gen-
/gdatabasegman- gsuregdatagisgsecure,ginternallygconsistent,gandgavailable
gagementgsystemg gatgallgtimes.gThesegfunctionsgaregchallenginggforglargeg
/gDBMS databasesgwithgmanygusers,gsogdatagbasegsystemsgareg
complex.
6. databasegapplica- softwaregthatghelpsgbusinessgusersginteractgwithgdata-
gtion gbasegsystems.
7. databasegadminis- - responsiblegforgsecuringgthegdatabasegsystemgagainstg
gtrator unauthorizedgusers.
- enforcesgproceduresgforgusergaccessgandgdatabaseg
systemgavailability.
8. databasegdesignerg determinesgthegformatgofgeachgdatagelementgandgthe
overallgdatabasegstructure.gMustgbalancegseveralgprior-
gities,gincludinggstorage,gresponsegtime,gandgsupportgfor
grulesgthatggoverngthegdata.gSincegthesegprioritiesgofteng
conflict,gdatabasegdesigngisgtechnicallygchallenging.
9. databasegprogram- developsgcomputergprogramsgthatgutilizegagdatabase.
gmer
10. databaseguser -gagconsumergofgdatagingagdatabase.
request,gupdate,gorgusegstoredgdatagtoggenerategreportsg
orginformation.
1g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
- usuallygaccessgthegdatabasegviagapplicationsgbutgcang
alsogsubmitgqueriesgdirectlygtogthegdatabasegsystem.
11. transaction aggroupgofgqueriesgthatgmustgbegeithergcompletedgor
rejectedgasgagwhole.gExecutiongofgsome,gbutgnotgall,gqueri
esgresultsginginconsistentgorgincorrectgdata.
12. querygprocessorg g g -ginterpretsgqueries,gcreatesgagplangtogmodifygthegdata-
basegorgretrievegdata,gandgreturnsgquerygresultsgtogtheg
application.
- managesgconnectionsgfromgmultiplegusersgandgcom-
gpilesgqueriesgintoglow-
levelginstructionsgforgthegstoragegengine.
13. querygoptimizationg Thegquerygprocessorgperformsg togen-
suregthegmostgefficientginstructionsgaregexecutedgongtheg
data.
14. indexes usedgbygthegstoragegmanagergtogquicklyglocategdata.
15. transactiongmanag- ensuresgtransactionsgaregproperlygexecuted.
ger
16. log agfilegcontaininggagcompletegrecordgofgallginserts,gup-
gdates,gandgdeletesgprocessedgbygthegdatabase.
17. relationalgdatabaseg storesgdatagingtables,gcolumns,gandgrows,gsimilargtoga
spreadsheet.
18. SQL
includesgstatementsgthatgreadgandgwritegdata,gcreat
egandgdeletegtables,gandgadministergthegdatabasegsyste
m.
19. biggdata Theggrowthgofgtheginternetgingtheg1990sggeneratedgmas-
sivegvolumesgofgonlinegdata,goftengwithgpoorlygstructuredg
orgmissingginformation.
20. NoSQL Thegnewergnon-relationalgsystems,gforg'notgonlygSQL',
andgaregoptimizedgforgbiggdata.
2g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
21. Opengsource
3g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
softwaregthatganyonegcanginspect,gcopy,gandgmodifygwithg
noglicensinggfee.
22. query agcommandgforgagdatabasegthatgtypicallyginsertsgnew
data,gretrievesgdata,gupdatesgdata,gorgdeletesgdatagfromg
agdatabase.
23. queryglanguage agcomputergprogrammingglanguagegforgwritinggdata-
basegqueries.
24. CRUD ThegfourgcommongqueriesgaregangacronymgforgCreate,
Read,gUpdate,gandgDeletegdata.
25. SELECT retrievesgdatagfromgagtable.
26. UPDATE modifiesgdatagingagtable.
27. CREATEgTABLE createsgagnewgtablegbygspecifyinggthegtablegandgcolumn
names.
28. datagtype Eachgcolumngisgassignedgag thatgindi-
catesgthegformatgofgcolumngvaluesgandgcangbegnumeric,gte
xtual,gorgcomplex.
29. databasegdesign agspecificationgofgdatabasegobjectsgsuchgasgtables,
columns,gdatagtypes,gandgindexes.gAlsogrefersgtogthegproc
essgusedgtogdevelopgthegspecification.
30. analysis
specifiesgdatabasegrequirementsgwithoutgregardgt
ogagspecificgdatabasegsystem.
31. ERgdiagrams depictsgentities,grelationships,gandgattributes.
32. logicalgdesign implementsgdatabasegrequirementsgingagspecificgdata-
basegsystem.gspecifiesgtables,gcolumns,gandgkeys.
33. key agcolumngusedgtogidentifygindividualgrowsgofgagtable.
34. tablegdiagram depictsgtheglogicalgdesign.
4g/g57
Studygonlinegatghttps://quizlet.com/_evoyts
1. Data numeric,gtextual,gvisual,gorgaudioginformationgthatgde-
gscribesgreal-worldgsystems.
2. analog Historically,gdatagwasgmostlyg ,gencod-
edgasgcontinuousgvariationsgongvariousgphysicalgmedia.
3. digital Today,gdatagisgmostlyg ,gencodedgas
zerosgandgonesgongelectronicgandgmagneticgmedia.
4. database agcollectiongofgdatagingagstructuredgformat.gIngprinciple,
cangbegstoredgongpapergorgevengclaygtablets.gIngpractice,g
however,gmoderngonesgareginvariablygstoredgongcom-
gputers.
5. databasegsystem softwaregthatgreadsgandgwritesgdatagingagdatabase.gen-
/gdatabasegman- gsuregdatagisgsecure,ginternallygconsistent,gandgavailable
gagementgsystemg gatgallgtimes.gThesegfunctionsgaregchallenginggforglargeg
/gDBMS databasesgwithgmanygusers,gsogdatagbasegsystemsgareg
complex.
6. databasegapplica- softwaregthatghelpsgbusinessgusersginteractgwithgdata-
gtion gbasegsystems.
7. databasegadminis- - responsiblegforgsecuringgthegdatabasegsystemgagainstg
gtrator unauthorizedgusers.
- enforcesgproceduresgforgusergaccessgandgdatabaseg
systemgavailability.
8. databasegdesignerg determinesgthegformatgofgeachgdatagelementgandgthe
overallgdatabasegstructure.gMustgbalancegseveralgprior-
gities,gincludinggstorage,gresponsegtime,gandgsupportgfor
grulesgthatggoverngthegdata.gSincegthesegprioritiesgofteng
conflict,gdatabasegdesigngisgtechnicallygchallenging.
9. databasegprogram- developsgcomputergprogramsgthatgutilizegagdatabase.
gmer
10. databaseguser -gagconsumergofgdatagingagdatabase.
request,gupdate,gorgusegstoredgdatagtoggenerategreportsg
orginformation.
1g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
- usuallygaccessgthegdatabasegviagapplicationsgbutgcang
alsogsubmitgqueriesgdirectlygtogthegdatabasegsystem.
11. transaction aggroupgofgqueriesgthatgmustgbegeithergcompletedgor
rejectedgasgagwhole.gExecutiongofgsome,gbutgnotgall,gqueri
esgresultsginginconsistentgorgincorrectgdata.
12. querygprocessorg g g -ginterpretsgqueries,gcreatesgagplangtogmodifygthegdata-
basegorgretrievegdata,gandgreturnsgquerygresultsgtogtheg
application.
- managesgconnectionsgfromgmultiplegusersgandgcom-
gpilesgqueriesgintoglow-
levelginstructionsgforgthegstoragegengine.
13. querygoptimizationg Thegquerygprocessorgperformsg togen-
suregthegmostgefficientginstructionsgaregexecutedgongtheg
data.
14. indexes usedgbygthegstoragegmanagergtogquicklyglocategdata.
15. transactiongmanag- ensuresgtransactionsgaregproperlygexecuted.
ger
16. log agfilegcontaininggagcompletegrecordgofgallginserts,gup-
gdates,gandgdeletesgprocessedgbygthegdatabase.
17. relationalgdatabaseg storesgdatagingtables,gcolumns,gandgrows,gsimilargtoga
spreadsheet.
18. SQL
includesgstatementsgthatgreadgandgwritegdata,gcreat
egandgdeletegtables,gandgadministergthegdatabasegsyste
m.
19. biggdata Theggrowthgofgtheginternetgingtheg1990sggeneratedgmas-
sivegvolumesgofgonlinegdata,goftengwithgpoorlygstructuredg
orgmissingginformation.
20. NoSQL Thegnewergnon-relationalgsystems,gforg'notgonlygSQL',
andgaregoptimizedgforgbiggdata.
2g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
21. Opengsource
3g/g57
, WGUgD426g-gDatagManagementgFoundations
Studygonlinegatghttps://quizlet.com/_evoyts
softwaregthatganyonegcanginspect,gcopy,gandgmodifygwithg
noglicensinggfee.
22. query agcommandgforgagdatabasegthatgtypicallyginsertsgnew
data,gretrievesgdata,gupdatesgdata,gorgdeletesgdatagfromg
agdatabase.
23. queryglanguage agcomputergprogrammingglanguagegforgwritinggdata-
basegqueries.
24. CRUD ThegfourgcommongqueriesgaregangacronymgforgCreate,
Read,gUpdate,gandgDeletegdata.
25. SELECT retrievesgdatagfromgagtable.
26. UPDATE modifiesgdatagingagtable.
27. CREATEgTABLE createsgagnewgtablegbygspecifyinggthegtablegandgcolumn
names.
28. datagtype Eachgcolumngisgassignedgag thatgindi-
catesgthegformatgofgcolumngvaluesgandgcangbegnumeric,gte
xtual,gorgcomplex.
29. databasegdesign agspecificationgofgdatabasegobjectsgsuchgasgtables,
columns,gdatagtypes,gandgindexes.gAlsogrefersgtogthegproc
essgusedgtogdevelopgthegspecification.
30. analysis
specifiesgdatabasegrequirementsgwithoutgregardgt
ogagspecificgdatabasegsystem.
31. ERgdiagrams depictsgentities,grelationships,gandgattributes.
32. logicalgdesign implementsgdatabasegrequirementsgingagspecificgdata-
basegsystem.gspecifiesgtables,gcolumns,gandgkeys.
33. key agcolumngusedgtogidentifygindividualgrowsgofgagtable.
34. tablegdiagram depictsgtheglogicalgdesign.
4g/g57
