Tsvaga Zvakawanda Pamusoro Pemaonero eDatabase
Dhiyabhorosi maonero anokubvumira kukurumidza nyore kuderedza kuoma kwechiitiko chekushandisa kwemugumo uye kugadzirisa kukwanisa kwavo kwekuwana deta iri mumatafura ezvinyorwa zvese kuburikidza nekudzikisa deta iri kuwanikwa kumushandi wekupedzisira. Chaizvoizvo, maonero anoshandisa mhinduro yehurukuro yepa database yekushandura zvinhu zviri mukati mefurafura yezvigadzirwa zvemashoko.
Sei Uchishandisa Maonero?
Pane zvikonzero zviviri zvakakosha kupa vashandisi nekugona kuwana deta kuburikidza nekuona pane kuvapa nekugona zvakakwana kumatafura epa database:
- Maonero anopa sarudzo yakajeka, granular . Unogona kushandisa maonero ekugadzirisa deta iyo munhu anoshandiswa kuona mutafura. Semuenzaniso, kana iwe une vashandi vefurafura uye unoshuva kupa vamwe vashandisi nekutambira kune zvinyorwa zvevashandi venguva yakazara, unogona kugadzira maonero ane zvinyorwa chete. Izvi zviri nyore kwazvo kupfuura iyo (kusisika nekuchengetedza tafura yemumvuri) uye inosimbisa kuvimbika kwe data.
- Maonero anonyoresa ruzivo rwevashandisi . Maonero anovanza zvinyorwa zvakaoma zvehwandu dzako dzematafura kubva kuvashandi vekupedzisira vasingadi kuaona. Kana munhu anoshandisa zviri mukati maonero, havazooni mahwendefa etafura asina kusarudzwa nemaonero uye vangave vasinganzwisisi. Izvi zvinovadzivirira kubva pakuvhiringidzika kunokonzerwa nemamwe mazita asingatauri mazita, zvizivo zvakasiyana nematombo efurafura .
Kuumba Maonero
Kuumba maonero zvakananga: iwe unongoda kuumba mubvunzo une zvidzidzo zvaunoda kuisimbisa uye unozviisa mukati memuumbi we CREATE VIEW. Heino chirevo:
DZIDZA KUONA kuona zita AS
Somuenzaniso, kana uchida kuumba vashandi venguva yakazara vachiona ini ndakakurukura muchikamu chakapfuura, iwe unogona kubudisa murairo unotevera:
DZIDZA KUONA nguva yose AS
Sarudza first_name, last_name, employee_id
KUBVA vashandi
WHERE chiitiko = 'FT'
Kuchinja Maonero
Kushandura zviri mukati memaziso zvinoshandiswa zvakafanana zvakafanana neshoko sekusika kwemaonero, asi iwe unoshandisa mutemo we ALTER VIEW pane chirevo che CREATE VIEW. Semuenzaniso, kana iwe uchida kuwedzera kuvharwa kwekuona nguva yakazara iyo inowedzera nhamba yefoni yomushandi kumigumisiro, iwe ungabudisa murairo unotevera:
ALTER VIEW fulltime AS
Sarudza first_name, last_name, employee_id, foni
KUBVA vashandi
WHERE chiitiko = 'FT'
Kuchenesa Maonero
Zviri nyore kubvisa maonero kubva kune database pakushandisa mutemo we DROP VIEW. Somuenzaniso, kana uchida kubvisa vashandi venguva yakazara vachiona, iwe ungashandisa murairo unotevera:
DROP VIEW fulltime