Bincika Ƙarin Game da Manyan Labarai - Gudanar da Bayanan Data

Bincika Ƙari Game da Bayanan Bincike

Bayani na bayanai suna ba ka damar sauƙin haɓakar ƙwarewar mai amfani da ƙarshe kuma ƙayyade ikon yin amfani da bayanai da ke cikin ɗakunan bayanai ta hanyar taƙaita bayanan da aka gabatar zuwa mai amfani. Ainihin, ra'ayi yana amfani da sakamakon binciken tambayoyin don yin tasiri don samar da abubuwan da ke ciki na tarin tushe.

Me ya sa amfani da ra'ayoyi?

Akwai dalilai biyu na farko don samar da masu amfani da damar shiga bayanai ta hanyar ra'ayoyi maimakon samar da su ta hanyar kai tsaye ga matakan bayanai:

• Hannuna suna samar da sauki, ma'auni na granular . Zaka iya amfani da ra'ayi don iyakance bayanan da aka yarda da mai amfani a cikin tebur. Alal misali, idan kana da ladabi ma'aikata kuma yana son samarwa wasu masu amfani damar samun damar yin amfani da rikodin ma'aikata na cikakken lokaci, zaka iya ƙirƙirar ra'ayi wanda ya ƙunshi waɗannan bayanan. Wannan ya fi sauƙi fiye da madadin (ƙirƙirar da rike tebur inuwa) da kuma tabbatar da amincin bayanan.
• Hanyoyi suna sauƙaƙe kwarewar mai amfani . Sukan boye cikakkun bayanai na ɗakunan bayananku daga masu amfani da ƙarshen waɗanda basu buƙatar ganin su. Idan mai amfani ya ƙare abubuwan da ke cikin ra'ayi, ba za su ga ginshiƙai na launi wanda ba'a zaba ta hanyar ra'ayi ba kuma ba zasu fahimta ba. Wannan yana kare su daga rikicewa da aka lalace da ginshiƙai masu suna, masu mahimman bayanai da maɓallin kewayawa .

Samar da Duba

Samar da ra'ayi yana da sauƙi: kuna buƙatar ƙirƙirar tambaya wanda ya ƙunshi ƙuntatawa da kuke so don tilas da sanya shi a cikin Dokar CREATE VIEW. Ga jerin haɗin:

Sanya VIEW sunan mai suna AS

Alal misali, idan kuna son ƙirƙirar ma'aikata cikakken lokacin da na tattauna a cikin sashe na baya, za ku ba da umurnin mai zuwa:

BABI BUKIYA azaman AS
Sanya farko_name, last_name, worker_id
FROM ma'aikata
BABI matsayi = 'FT'

Shirya Duba

Canja abinda ke cikin ra'ayi yana amfani da daidaitattun daidai ɗin azaman ƙirƙirar ra'ayi, amma kuna amfani da umarnin ALTER VIEW maimakon dokar CREATE VIEW. Alal misali, idan kana so ka ƙara ƙuntatawa zuwa kallo na cikakke wanda ya ƙara lambar tarho na ma'aikaci zuwa sakamakon, za a ba da umarni mai zuwa:

SHE DUKIYA azaman AS
Sanya farko_name, last_name, worker_id, tarho
FROM ma'aikata
BABI matsayi = 'FT'

Share Share

Yana da sauƙi don cire wani ra'ayi daga wani bayanai ta amfani da umurnin DROP VIEW. Alal misali, idan kuna so su share aikin ma'aikata na cikakken lokaci, za ku yi amfani da wannan umurnin:

DROP DUBI cikakken lokaci