M'ndandanda wazopezekamo[Bisani][Show]
- 1. Mukutanthauza chiyani ndi Database?
- 2. Mukutanthauza chiyani ndi DBMS?
- 3. Fotokozani zilankhulo zosiyanasiyana za DBMS.
- 4. Lembani maubwino angapo a DBMS?
- 5. Tchulani zovuta za machitidwe ochiritsira mafayilo omwe ma DBMS ali nawo.
- 6. Mukutanthauza chiyani ndi katundu wa ACID mu DBMS?
- 7. Kodi SQL imagwira ntchito yotani mu DBMS?
- 8. Kodi malo opanda kanthu kapena ziro amawerengedwa ngati NULL muzosungira?
- 9. Kodi kusunga deta ndi chiyani kwenikweni?
- 10. Kodi kufufuza kwa DBMS kumatanthauza chiyani?
- 11. Fotokozani zigawo zosiyanasiyana za DBMS zochotsa deta.
- 12. Kodi "kukhathamiritsa kwa mafunso" kumatanthauza chiyani kwa inu?
- 13. Chifaniziro chaubale: ndi chiyani?
- 14. Kodi mawu akuti “entity,” “entity type,” ndi “entity set” amatanthauza chiyani mu kasamalidwe ka database?
- 15. Kodi maubwenzi ndi chiyani, ndipo ndi maubwenzi otani omwe alipo mu DBMS?
- 16. Kodi RDBMS ndi chiyani kwenikweni?
- 17. Kodi mawu akuti “intension” ndi “extension” amatanthauza chiyani pankhokwe?
- 18. Kodi njira zambiri zokhazikika ndi chiyani ndipo mawu oti "normalization" amatanthauza chiyani?
- 19. Fotokozani loko. Kusiyanitsa kwakukulu pakati pa loko yogawana ndi loko yokhayokha panthawi yachinsinsi iyenera kufotokozedwa.
- 20. Kodi mawu akuti “normalization” ndi “denormalization” amatanthauza chiyani?
- 21. Fotokozani kugawa kwa database ndi kufunikira kwake.
- 22. Kodi mawu oti “proactive,” “retroactive,” ndi “simultaneous update” amatanthauza chiyani kwa inu?
- 23. Kodi mawu akuti “cholozera” amatanthauza chiyani kwa inu? Fotokozani mitundu yambiri ya zolozera.
- 24. Fotokozani kusiyana pakati pa ma netiweki ndi madongosolo a database.
- 25. Fotokozani MongoDB.
- 26. Fotokozani kusiyana pakati pa dongosolo la 2-tier ndi 3-tier DBMS.
- 27. Kodi mawu akuti “hashing” amatanthauzanji?
- 28. Kodi woyang'anira database amachita chiyani mu DBMS?
- Kutsiliza
Zambiri zitha kupezeka kulikonse padziko lapansi! Pamsika wamasiku ano, ma data opitilira 2.5 quintillion amapangidwa tsiku lililonse.
Ndikofunikira kuti tonse tizisanthula detayi ndikupereka zotsatira zofunikira pogwiritsa ntchito njira zoyendetsera database (DBMS). Kumbali ina, kukhala ndi chidziwitso cha DBMS kumapangitsa kuti zitheke kugwira ntchito ngati woyang'anira database.
Popeza mukuwerenga izi za Mafunso a Mafunso a DBMS, ndikuganiza kuti mukudziwa kale izi. Ntchito iliyonse yowunikira ma data iyenera kuyamba ndikumvetsetsa kokhazikika kwadongosolo la database (DBMS).
Kupanga makina opangira ma database kumafuna kutha kulinganiza, kuwunika, kudutsa, ndikumvetsetsa kuchuluka kwa data.
Nawa ochepa DBMS kuyankhulana mafunso kukuthandizani kupambana lotsatira kuyankhulana ntchito ndi kutera malo inu mwakhala mukulota, kaya inu mwayamba kale ntchito analytics deta kapena akungoyamba kumene.
Mafunso apamwamba oyankhulana a DBMS asonkhanitsidwa pamndandanda kuti mupindule nawo kuti akuthandizeni kuyankhulana kwanu ndikulimbitsa kumvetsetsa kwanu pankhaniyi.
1. Mukutanthauza chiyani ndi Database?
Dongosolo losungiramo zinthu zakale ndi mndandanda wazinthu zomwe zimatha kusinthidwa, kuzipeza, ndikusungidwa mosavuta. Chilichonse chomwe chimapangidwa ndi lamulo lopanga ndi chinthu cha database, ndipo ma database nthawi zambiri amakhala ndi ma tebulo kapena zinthu zomwe zili ndi zolembera ndi minda.
Kulowa kumodzi patebulo kumayimiridwa ndi tuple kapena mzere. Zofunikira zosungirako deta, zomwe zimapereka zambiri za gawo linalake la tebulo, ndi chikhalidwe kapena gawo.
DBMS imatenga deta kuchokera ku database pogwiritsa ntchito mafunso operekedwa ndi ogwiritsa ntchito.
2. Mukutanthauza chiyani ndi DBMS?
DBMS ndi mapulogalamu apakompyuta omwe amakuthandizani kupanga ndikuwongolera deta yolumikizidwa mwanzeru.
Kunena mwanjira ina, kasamalidwe ka database (DBMS) amatipatsa mawonekedwe kapena chida chogwirira ntchito zosiyanasiyana kuphatikiza kumanga nkhokwe, kuwonjezera deta, kuchotsa, kusintha deta, ndi zina zotero.
Mapulogalamu otchedwa database management system (DBMS) amathandiza kuti deta isungidwe m'njira yotetezeka kwambiri kusiyana ndi mafayilo opangira mafayilo.
3. Fotokozani zilankhulo zosiyanasiyana za DBMS.
Izi ndi zina mwa zilankhulo zomwe ma DBMS amagwiritsa ntchito:
- DDL (Chiyankhulo Chotanthauzira Chidziwitso): Malangizo ofunikira kuti afotokoze nkhokweyo ali mmenemo. CREATE, ALTER, DROP, TRUNCATE, RENAME, etc. ndi zitsanzo zochepa.
- DML(Chiyankhulo Chogwiritsa Ntchito Data): Zimaphatikizapo malamulo ofunikira kuti mugwire ntchito ndi zomwe zili munkhokwe. Zitsanzo zikuphatikizapo SELECT, UPDATE, INSERT, DELETE, etc.
- DCL (Chiyankhulo Choyang'anira Data): Zimaphatikizapo malamulo omwe ali ofunikira kuti athane ndi zilolezo za ogwiritsa ntchito ndi kuwongolera kachitidwe ka database. Mwachitsanzo, GRANT ndi REVOKE.
- TCL (Transaction Control Language): Zimaphatikizapo malamulo omwe amayenera kugwiritsidwa ntchito poyang'anira zochitika za database. Mwachitsanzo, COMMIT, ROLLBACK, ndi SAVEPOINT.
4. Lembani maubwino angapo a DBMS?
- Ndizotheka kuti ogwiritsa ntchito ambiri azitha kusinthana data kuchokera pankhokwe yomweyo nthawi imodzi. Kuphatikiza apo, kugawana kotereku kumapangitsa kuti ogwiritsa ntchito azitha kuyankha mwachangu pazosintha zomwe zili mu database.
- Ndizotheka kuti ogwiritsa ntchito ambiri aziwona data ya database yomweyo nthawi imodzi.
- amachepetsa kubwereza mu nkhokwe poyambitsa dongosolo lomwe limagwirizanitsa deta yonse mu database imodzi.
- Pakafunika, zomwe zili mu database zitha kubwezeretsedwanso ndipo zosunga zobwezeretsera zitha kukonzedwa kuti zipangidwe zokha.
- Zimathandizira kusintha mawonekedwe a data ndikusunga mawonekedwe azinthu zonse zomwe zikuyenda.
5. Tchulani zovuta za machitidwe ochiritsira mafayilo omwe ma DBMS ali nawo.
Timakakamizika kuyang'ana tsamba lililonse pamafayilo omwe ali ndi mafayilo chifukwa palibe indexing, zomwe zimapangitsa kuti zopezekazo ziwononge nthawi komanso zaulesi.
Kudumphadumpha ndi kusagwirizana ndizovuta zina chifukwa mafayilo nthawi zambiri amakhala ndi deta yocheperako komanso yobwereza, ndipo kusintha imodzi mwazomwe zimapangitsa kuti zonsezi zikhale zosagwirizana.
Kufikira kwa data kumakhala kovuta kwambiri ndi machitidwe opangira mafayilo chifukwa deta ndi yosalongosoka. Choyipa china ndi kusowa kwa concurrency control, zomwe zimalepheretsa ntchito zambiri kugwira ntchito pa fayilo imodzi nthawi imodzi ndipo m'malo mwake zimakakamiza chinthu chimodzi kutseka tsamba lonse.
Machitidwe oyang'anira database adathetsanso zovuta ndi machitidwe azikhalidwe zamafayilo kuphatikiza macheke achilungamo, kulekanitsa deta, atomiki, chitetezo, ndi zina zambiri.
6. Mukutanthauza chiyani ndi katundu wa ACID mu DBMS?
Mfundo zazikuluzikulu zomwe ziyenera kutsatiridwa pofuna kusunga kukhulupirika kwa deta ndi makhalidwe a ACID a kasamalidwe ka deta. Izi ndi zomwe zili:
- Atomicity - Zomwe zimatchedwanso "zonse kapena palibe", atomicity imanena kuti kuwunika kulikonse kwa gawo limodzi kumachitika kwathunthu kapena ayi.
- Kusasinthika: Katunduyu akuwonetsa kuti zomwe zili munkhokwe zimakhazikika musanachite chilichonse komanso pambuyo pake.
- Kudzipatula - Katunduyu amatanthawuza kuti zochitika zambiri zitha kuchitika nthawi imodzi.
- Durability - Katunduyu amawonetsetsa kuti ntchito iliyonse imalembedwa m'makumbukidwe osasinthika ikamalizidwa.
7. Kodi SQL imagwira ntchito yotani mu DBMS?
SQL imayimira Structured Query Language, ndipo ntchito yake yayikulu ndikulumikizana ndi nkhokwe zaubale polowetsa ndikusintha / kusintha deta.
8. Kodi malo opanda kanthu kapena ziro amawerengedwa ngati NULL muzosungira?
Ayi, mtengo wa NULL ndi wosiyana kwambiri ndi zero ndi malo opanda kanthu chifukwa umatanthawuza mtengo womwe wapatsidwa, wosadziwika, wosapezeka, kapena wosayenerera, mosiyana ndi malo opanda kanthu ndi zero, omwe aliyense amaimira khalidwe.
9. Kodi kusunga deta ndi chiyani kwenikweni?
Kusunga deta ndi njira yosonkhanitsa, kuchotsa, kukonza, ndi kutumiza deta kuchokera kumalo angapo kuti isungidwe mu database imodzi.
Malo osungiramo zidziwitso amatha kuganiziridwa ngati malo apakati pomwe deta imagwiritsidwa ntchito posanthula deta ndikuchokera ku machitidwe opangira zinthu ndi ma database ena ogwirizana.
A nyumba yosungiramo deta lili ndi mbiri yakale yochokera ku bungwe lomwe limagwiritsidwa ntchito kupititsa patsogolo zisankho mkati mwakampani.
10. Kodi kufufuza kwa DBMS kumatanthauza chiyani?
Njira ya Checkpoint imachotsa zipika zonse zam'mbuyomu kuchokera pamakina ndikuzisunga kosatha pa chipangizo chosungira.
Njira ziwiri zomwe zingathandize DBMS kuchira ndi kusunga makhalidwe a ACID monga kusunga masamba amthunzi ndi kusunga chipika cha malonda aliwonse. Macheke ndi ofunikira pamakina obwezeretsa potengera chipika.
Mbiri ya chipika cha transaction ingagwiritsidwe ntchito kubweza deta yonse yodzipereka mpaka nthawi ya ngozi kuchokera kumalo ochezera, omwe ndi mfundo zochepa zomwe injini ya database imatha kuchira pambuyo pa ngozi.
11. Fotokozani zigawo zosiyanasiyana za DBMS zochotsa deta.
Kutulutsa kwa data ndikubisa zidziwitso zosafunika kuchokera kwa wogwiritsa ntchito kuti alimbikitse kulumikizana kwachangu. Pali magawo atatu a abstraction:
- Mulingo Wathupi: Gawo laling'ono kwambiri lachidziwitso limafotokoza kusungidwa kwa data mu kukumbukira. Njira zonse zotsatizana komanso zopezeka mwachisawawa zingagwiritsidwe ntchito kupeza deta. Mitengo ya B + ndi njira za hashing zimagwiritsidwa ntchito kukonza mafayilo.
- Logic Level: Mulingo womwe deta imasungidwa ngati matebulo. Kuphatikiza apo, zomanga zoyambira zimagwiritsidwa ntchito kusunga kulumikizana pakati pa zinthu zosiyanasiyana.
- Mulingo Wowonera: Ndiwo mulingo wapamwamba kwambiri wofotokozera. Gawo lokha la nkhokwe yeniyeni, yoimiridwa ndi mizere ndi mizati, yomwe imapezeka kwa ogwiritsa ntchito. Mawonedwe angapo a database yomweyi ndi yotheka. Ogwiritsa ntchito samadziwitsidwa za kusungidwa ndi kukhazikitsa.
12. Kodi "kukhathamiritsa kwa mafunso" kumatanthauza chiyani kwa inu?
Njira yokwaniritsira mafunso imapeza njira yowunikira yomwe ili ndi mtengo wotsika kwambiri womwe ukuyembekezeka. Gawoli limakhala lofunikira ngati pali ma aligorivimu angapo ndi njira zomwe zilipo kuti achite vuto lomwelo.
Zotsatirazi ndi zina mwazabwino za kukhathamiritsa kwa mafunso:
- Kutulutsa kumaperekedwa mofulumira kwambiri
- Amachepetsa zovuta za nthawi ndi danga
- Zofunsa zambiri zitha kukonzedwa munthawi yochepa.
13. Chifaniziro chaubale: ndi chiyani?
Njira yopangira databaseyi imagwiritsa ntchito zithunzi kuwonetsa zinthu zenizeni zenizeni monga mabungwe ndikuwonetsa ubale wawo. Njirayi imapangitsa kukhala kosavuta kuti gulu la DBA limvetsetse schema.
14. Kodi mawu akuti “entity,” “entity type,” ndi “entity set” amatanthauza chiyani mu kasamalidwe ka database?
Bungwe: Chinthu chenichenicho chimatengedwa ngati chinthu ngati chili ndi zinthu zomwe zimagwirizana ndi zomwe zimapangidwira. Mwachitsanzo, wophunzira, wogwira ntchito, kapena mphunzitsi amaimira bungwe.
Mtundu wa bungwe: Mtundu wa bungwe umafotokozedwa ngati gulu la mabungwe omwe ali ndi mawonekedwe ofanana. Mtundu wa bungwe umayimiridwa ndi tebulo limodzi kapena angapo olumikizidwa mu database. N'zotheka kuganiza za mtundu wa bungwe kapena zomwe zimatchulidwa kuti ndizomwe zimazindikiritsa bungwelo. Wophunzira, mwachitsanzo, amaimira chinthu chokhala ndi makhalidwe monga wophunzira, dzina la wophunzira, ndi zina zotero.
Gulu: Mabungwe onse omwe ali munkhokwe ya gulu linalake amasonkhanitsidwa ngati gulu. Mwachitsanzo, gulu lamagulu ndi gulu la ophunzira onse, antchito, aphunzitsi, ndi ena otero.
15. Kodi maubwenzi ndi chiyani, ndipo ndi maubwenzi otani omwe alipo mu DBMS?
Mu DBMS, ubale ndi mkhalidwe womwe magulu awiri amalumikizana wina ndi mnzake. Pachifukwa ichi, tebulo lachinsinsi lakunja likuyimira fungulo loyamba la tebulo lina.
Mndandanda wotsatirawu umaphatikizapo mitundu yambiri ya maubwenzi omwe amapezeka mu DBMS:
- Ubale Umodzi ndi Umodzi: Mawuwa amagwiritsidwa ntchito kutanthauza mgwirizano wapakati pa mzere A ndi mzere B.
- Ubale Wapamodzi ndi Ambiri: Amagwiritsidwa ntchito ngati pali ubale pakati pa mzere umodzi mu Gulu A ndi mizere yambiri mu Gulu B.
- Maubwenzi Ambiri-Kuchuluka - Amagwiritsidwa ntchito pamene mizere yambiri pa tebulo A ikhoza kulumikizidwa ndi mizere yambiri pa tebulo B.
- Ubale Wodziwonetsera - Wogwiritsidwa ntchito pamene cholembera mu tebulo A chikugwirizana ndi zolemba zina patebulo lomwelo.
16. Kodi RDBMS ndi chiyani kwenikweni?
RDBMS, kapena ma relational database management systems, ndi chidule cha machitidwewa. Amagwiritsidwa ntchito kuti azitsatira ma index index ndi ma data.
Ma RDBMS ndi kagawo kakang'ono ka kasamalidwe ka database komwe amagwiritsa ntchito kapangidwe kake kuti apeze ndikupeza zidziwitso zazinthu zina zama database. Relational database management system (RDBMS) imapangitsa kuti zikhale zosavuta kusintha, kuyika, kuchotsa, kusintha, ndikuwongolera nkhokwe yaubale.
Nthawi zambiri, RDBMS imagwiritsa ntchito chilankhulo cha SQL chifukwa ndi yosavuta kugwiritsa ntchito komanso imagwiritsidwa ntchito pafupipafupi.
17. Kodi mawu akuti “intension” ndi “extension” amatanthauza chiyani pankhokwe?
Kusiyanitsa kwakukulu pakati pa cholinga ndi kukulitsa mu database ndi motere:
Kulimbikira: Cholinga, chomwe nthawi zina chimatchedwa schema ya database, chimagwiritsidwa ntchito pofotokoza kufotokozera kwa database. Zimakhazikitsidwa panthawi yomanga nkhokwe ndipo nthawi zambiri sizisintha.
Kuwonjeza: Kumbali ina, kukulitsa ndi kuyeza kwa kuchuluka kwa ma tuples mu nkhokwe nthawi iliyonse. Ma tuples akapangidwa, kusinthidwa, kapena kufufutidwa mu nkhokwe, kukulitsa, komwe kumadziwikanso kuti chithunzithunzi cha database, kumasintha mtengo mosalekeza.
18. Kodi njira zambiri zokhazikika ndi chiyani ndipo mawu oti "normalization" amatanthauza chiyani?
Normalization ndi njira yopangira deta kuti mupewe kubwereza kwa data ndi redundancy. Magawo angapo okhazikika amatsatana ndipo amatchedwa mawonekedwe abwinobwino. Mawonekedwe otsatirawa amadalirana.
Mitundu itatu yoyambirira yodziwika bwino ndi iyi.
NF-1, kapena First Normal Form, mizere yopanda magulu mobwerezabwereza
2NF imayimira Second Normal Form. Mtengo uliwonse wa gawo lothandizira (lopanda makiyi) limadalira kiyi yayikulu yonse.
Atatu-Normal-Form (3NF) amadalira makiyi oyambirira okha ndipo sizidalira mindandanda ina iliyonse yothandizira (yopanda makiyi).
Mulinso ndi mawonekedwe apamwamba, monga BCNF, kuphatikiza awa.
BNCF - Mtundu wotsogola komanso wotsimikizika wa 3NF umatchedwa 3.5NF. Gome liyenera kukhala mu 3NF ndikutsatira lamulo la BCNF loti A akhale chinsinsi chachikulu patebulo pa kudalira kulikonse kwa A->B.
19. Fotokozani loko. Kusiyanitsa kwakukulu pakati pa loko yogawana ndi loko yokhayokha panthawi yachinsinsi iyenera kufotokozedwa.
Loko ya database ndi njira yachitetezo yomwe imalepheretsa ogwiritsa ntchito awiri kapena kupitilira apo kuti asinthe gawo lazogawana nthawi imodzi.
Palibe wogwiritsa ntchito wina wankhokwe kapena gawo lomwe lingathe kusintha deta mpaka loko itatulutsidwa pa nkhokwe inayake pomwe wogwiritsa ntchito m'dawunilodi m'modzi kapena gawo lapeza loko.
Lock Yogawana: Kuwerenga chinthu cha data kumafuna loko yogawana, ndipo zochitika zambiri zimatha kusunga loko pa chinthu chomwecho pansi pa loko yogawana. Zinthu za data mu loko yogawana zimatha kuwerengedwa ndi zochitika zambiri.
Kutsekera Kwapadera: Kugulitsa kulikonse kokhudza kulemba kumakhala ndi loko, komwe kumadziwika kuti loko kokha. Loko ili limaletsa kuchita zinthu zingapo, kuletsa kusagwirizana kulikonse mu database.
20. Kodi mawu akuti “normalization” ndi “denormalization” amatanthauza chiyani?
Njira yokhazikika imaphatikizapo kuswa deta m'matebulo ambiri kuti muchepetse kuchepa. Kukhazikika kumabweretsa kugwiritsidwa ntchito kwakukulu kwa disk space ndikupangitsa kukhala kosavuta kusunga kukhulupirika kwa database.
Denormalization ndi yosiyana ndi normalization popeza imaphatikiza matebulo okhazikika kukhala tebulo limodzi kuti ifulumizitse kubweza deta. Potembenuza kukhazikika, ntchito ya JOIN imatithandiza kupanga chiwonetsero chambiri.
21. Fotokozani kugawa kwa database ndi kufunikira kwake.
Dongosolo lomveka bwino limagawidwa m'magulu osiyana, odzidalira okha ndi njira yogawanitsa deta, yomwe imathandizira kupezeka, kugwira ntchito, ndi kuwongolera.
Zotsatirazi ndi zina mwazifukwa zomwe kugawa kwa database ndikofunikira:
- Imawonjezera mphamvu ya mafunso
- Kumakuthandizani kuti mupeze magawo ofunikira a gawo linalake
- Deta ikhoza kusungidwa pamalo osungiramo ulesi, otsika mtengo.
22. Kodi mawu oti “proactive,” “retroactive,” ndi “simultaneous update” amatanthauza chiyani kwa inu?
Kusintha Kwachidziwitso: database isanayambike m'dziko lenileni, zosinthazi zimapangidwira.
Kusintha kwa Retroactive: database ikayamba kugwira ntchito mdziko lenileni, zosintha zosinthika izi zimapangidwira.
Kusintha Kwanthawi Imodzi: Zosinthazi zimapangidwira kunkhokwe nthawi yomweyo pomwe zimayamba kuchitika mdziko lenileni.
23. Kodi mawu akuti “cholozera” amatanthauza chiyani kwa inu? Fotokozani mitundu yambiri ya zolozera.
Cholozera ndi chinthu cha database chomwe chimathandizira kusintha kwa data pamzere ndi mzere ndikuyimira zotsatira.
Izi ndi mitundu ingapo ya zolozera:
- Cholozera Chowonekera: Cholozera chamtunduwu chimalengezedwa nthawi yomweyo SQL ikangoperekedwa. Wogwiritsa ntchito sanadziwitsidwe za chilengezo cha cholozera panthawiyi.
- Cholozera Chowonekera: Popeza chimayang'ana funso m'mizere ingapo, cholozera chamtunduwu ndi chomwe chikufotokozedwa ndi PL/SQL.
24. Fotokozani kusiyana pakati pa ma netiweki ndi madongosolo a database.
Deta imasanjidwa kukhala ma node omwe amafanana ndi mtengo mumndandanda wazotsatira wanthawi zonse. Node ikhoza kukhala ndi mfundo imodzi yokha ya kholo yolumikizidwa nayo.
Chotsatira chake, deta yachitsanzo ichi imakhala ndi mgwirizano umodzi-kuchuluka. Document Object Approach (DOM), yomwe imagwiritsidwa ntchito pafupipafupi pakusakatula masamba, ndi chitsanzo chabwino kwambiri chamtunduwu.
Kusinthika kosinthika kwachitsanzo chotsogola ndi mtundu wa database ya netiweki. Deta imakonzedwa mofanana ndi mtengo muzochitika izi. Komabe, mfundo imodzi ya mwana ikhoza kulumikizidwa ndi mfundo zingapo za makolo.
Ulalo wambiri mpaka wambiri umayamba pakati pa ma data monga zotsatira. Malo osungiramo maukonde akuphatikizapo Integrated Data Store (IDS) ndi IDMS (Integrated Database Management System).
25. Fotokozani MongoDB.
MongoDB ndi gwero lotseguka, lopanda ubale, losakhazikika. Zambiri zanu zimasungidwa m'zosonkhanitsa zopangidwa ndi zikalata zomwe zili patsamba lathu lokhala ndi zolemba.
Chikalata ku MongoDB ndi chinthu chokulirapo cha JSON chopanda mawonekedwe kapena mawu. Zolemba za JSON zimayimiridwa ndi MongoDB mumtundu wa binary-encoded wotchedwa BSON.
26. Fotokozani kusiyana pakati pa dongosolo la 2-tier ndi 3-tier DBMS.
Mawu oti "zomangamanga zamagulu awiri" amatanthauza kamangidwe ka seva yamakasitomala momwe mapulogalamu omwe amayendera makasitomala amalumikizana mwachindunji ndi nkhokwe zomwe zikuyenda pa maseva popanda kugwiritsa ntchito zida zapakati.
Mapangidwe a 3-tier akuphatikizanso gawo lowonjezera pakati pa kasitomala ndi seva kuti apatse ogwiritsa ntchito mawonekedwe owoneka bwino ndikupangitsa kuti dongosolo likhale lotetezeka komanso lopezeka. Mu mawonekedwe awa, pulogalamu ya kasitomala-mbali imalumikizana ndi pulogalamu ya mbali ya seva, yomwe imalankhula ndi dongosolo la database.
27. Kodi mawu akuti “hashing” amatanthauzanji?
Chingwe cha zilembo chimathamangitsidwa kukhala kiyi kapena mtengo womwe umayimira chingwe choyambirira koma nthawi zambiri amakhazikika pautali wocheperako. Popeza kupeza chinthu pogwiritsa ntchito kiyi yachifupi kuposa mtengo woyambirira ndikofulumira, hashing imagwiritsidwa ntchito kulondolera ndi kubweza zinthu m'ma database.
28. Kodi woyang'anira database amachita chiyani mu DBMS?
The Database Administrator (DBA) ali ndi maudindo ofunikira awa mu DBMS:
- Kukhazikitsa ndi kukhazikitsa ma database
- Kusamuka kwa data
- Kuyang'anira magwiridwe antchito
- Kukonzekera ndi kukhazikitsa njira zotetezera
- Kubwezeretsa deta ndi kusunga
- Kusaka zolakwika
Kutsiliza
Kutoleredwa kwa mafunso ndi mayankho a DBMS oyankhulana ndi mayankho kwaperekedwa ngati chiwongolero kuti ofuna kusankhidwa athe kumvetsetsa mwachangu komanso mosavuta mafunsowa.
Pomaliza, tasanthula mafunso apamwamba oyankhulana a DBMS omwe amafunsidwa pafupipafupi m'mabungwe.
Siyani Mumakonda