Blog ndi John Boyer ndi Mike Norris.
Introduction
Ndikofunikira kukhala ndi luso la Cognos Auditing logwira ntchito kuti mudziwe ndikumvetsetsa momwe ma Cognos amagwiritsidwira ntchito ndi omwe mumagwiritsa ntchito ndikuthandizani kuyankha mafunso ngati awa:
-
- Ndani akugwiritsa ntchito dongosololi?
- Kodi akutulutsa malipoti ati?
- Kodi lipotili limathamanga nthawi yanji?
- Mothandizidwa ndi zida zina, monga MotioCI, ndi ziti zomwe sizinagwiritsidwe ntchito?
Poganizira kufunikira kokhala ndi malo a Cognos Analytics, zodabwitsa kuti zochepa zalembedwa pamndandanda wazowerengera zomwe sizingafanane ndi zomwe zalembedwa. Mwina, zimangotengedwa ngati zopanda pake, koma mabungwe omwe amagwiritsa ntchito amadziwa kuti pakapita nthawi amafunsa matebulo a Audit Database ayamba kuchepa - makamaka ngati bungwe lanu lili ndi ogwiritsa ntchito ambiri okhala ndi malipoti ambiri ndipo ali ndi mbiri yakale. Chowonjezeranso ndichakuti kuwunika komwe kudulako kumatha kuchedwa chifukwa kumayikidwa pamzere pomwe sikungawonjezeredwe mwachangu, mwachitsanzo. Ndipamene mumayamba kulingalira zamomwe mungagwiritsire ntchito database momwe mungachitire ndi nkhokwe iliyonse yomwe ili ndi zofunikira pakufotokozera.
Magome akulu nthawi zambiri amafunsa mayankho. Kukula kwa tebulo, kumatenga nthawi yayitali kuyika ndikufunsa. Kumbukirani kuti matebulo awa ndi Audit Database kwenikweni ndi nkhokwe ya ntchito; Zolemba zikuchitika pafupipafupi ndipo zimatigwirira ntchito chifukwa sitingathe kuziwunika pakungowerenga momwe mungachitire ndi data mart.
Monga malo ogulitsira, thanzi la malo a Cognos liyeneranso kulingalira zaumoyo wa Audit Database. Kukula kopanda malire kwa Audit Database kumatha kukhala vuto pakapita nthawi ndipo pamapeto pake kumatha kukhudza magwiridwe antchito amtundu wa Cognos. M'mabungwe ambiri omwe ali ndi malamulo akunja amawagwiritsa ntchito, kusakhala ndi zowerengera zathunthu zitha kuwapangitsa kuti asamatsatire zotsatira zoyipa. Ndiye timachita bwanji ndikakhala kuti tili ndi chidziwitso chambiri pakuwunika zakale - nthawi zina mpaka zaka 10 - komabe timalandirabe malipoti omwe tikufunikira kuti tisunge zachilengedwe ndikusangalatsa ogwiritsa ntchito ndi magwiridwe antchito?
Chovuta
-
- Kukula kopanda malire kwa Audit Database kumakhudza thanzi la chilengedwe cha Cognos
- Kufotokozera kuchokera ku Audit Database kwayamba pang'onopang'ono kapena kosatheka
- Zochedwetsa zomwe zimakumana ndikuchedwa kulembedwa m'makalata a Audit Database
- Audit Database ikutha pa disk space
Zonsezi zikutanthauza kuti si malipoti okha omwe amadalira Audit Database omwe amavutika, koma nthawi zambiri dongosolo lonse. Ngati nkhokwe ya Audit ili pa seva yomweyo monga malo ogulitsira a Cognos, magwiridwe antchito azinthu zonse ma Cognos adzakhudzidwa ndi malowa.
Kukhazikitsa
Timaganiza:
-
- Cognos Analytics imayikidwa ndikuyendetsa
- Cognos idapangidwa kuti ilowe mu Audit Database
-
- Khalani ndi Audit Database m'malo mwake
- Ikani magawo oyenera a Audit mu kayendetsedwe ka Cognos
- Mbiri imalembedwa ku database ndi Cognos
- Audit Database yakhala ikugwiritsidwa ntchito kupitilira chaka chimodzi
- Chilengedwe chimagwira ntchito kwambiri ndi ogwiritsa ntchito ndikupha
- Phukusi la Audit likugwiritsidwa ntchito kuwonetsa kugwiritsa ntchito kwa Cognos
- Tikuyang'ana kukonza magwiridwe antchito a Audit Database
- Kuyambiranso kapena kuchotsa zolemba zakale sikuli kosankha nthawi zonse
Ngati simutero, khalani ndi Cognos Audit yoyikika ndikukonzedwa, Lodestar Solutions, a Motio mnzake, ali ndi zabwino positi polola Audit mu Cognos BI / CA.
The Anakonza
Pali njira zina zomwe zitha kudziwonetsa mwachangu:
-
- Kuchepetsa kuchuluka kwa zidziwitso ndi:
-
- Kusunthira zina mwazakale kusanja lina
- Kusunthira zina mwazakale pagome lina mumndandanda womwewo
- Ingochotsani kapena archive zina mwazidziwitso ndipo musadandaule nazo
- Khalani nawo. Ikani chitini pansi road ndikukankhira Database Administrator kuti ichitike
kusintha pomwe mukuwamanga posalola kusintha kwa schema kapena
mndandanda
Sitilimbana ndi njira 3. Njira 2, kuchotsa deta, si njira yabwino ndipo ndingakulimbikitseni kuti muchepetse miyezi 18. Koma, ngati mumakonda kwambiri, IBM imapereka zofunikira, AuditDBCleanup (Cognos BI) kapena a script (Cognos Analytics) zomwe zichite chimodzimodzi. Zogwiritsira ntchito Cognos BI zimachotsa zolemba potengera sitampu pomwe zolembedwa za Cognos Analytics zimangochotsa ma index ndi matebulo.
Malangizo omwe tidapereka kwa makasitomala m'mbuyomu pankhaniyi amayenera kugawidwa m'magulu awiri:
-
- Audit - Live: ili ndi chidziwitso chamasabata aposachedwa
- Audit - Mbiri: ili ndi mbiri yakale (mpaka zaka N)
Mwachidule, ndondomekoyi imayenda sabata iliyonse kusuntha zolemba zaposachedwa kwambiri kuchokera ku Audit Live kupita ku Audit Historical. Audit Live imayambiranso ngati chikwangwani chopanda kanthu izi zitatha.
-
- Live DB ndiyachangu komanso yolimba, kulola kuyika kuti ichitike mwachangu momwe zingathere
- Mafunso owerengera amapita ku Historical DB
Pogwiritsa ntchito njirayi, palibe "kulumikizana pamodzi" kwa zomwe zikuwonetsedwa pawokha komanso za mbiri yakale. Ndinganene kuti mwina mukufuna kuti zizikhala choncho.
Mu Cognos Administration, mutha kuwonjezera maulalo awiri osiyana a Audit Data Source. Wogwiritsa ntchito akamapereka lipoti lotsutsana ndi phukusi la Audit, amalimbikitsidwa kulumikizana komwe akufuna kugwiritsa ntchito:
Ngati mukufuna kuyang'ana pazowerengera zowerengera m'malo mwazowerengera zakale, mungotenga ulalo wa "Audit - Live" mukalimbikitsidwa (zikhale zosiyana, osati zachilendo.)
Ngati MUKUFUNITSANI kuti mupereke malingaliro ophatikizika a Live ndi Historical, mutha kutero, koma zingakhudze magwiridwe antchito.
Mwachitsanzo, mutha kupanga Database Yachitatu yotchedwa "Audit - Consolidated View" kenako, pagome lililonse mu Audit schema: pangani mawonekedwe omwewo ndi mgwirizano wa SQL pakati pa tebulo mu DB yamoyo ndi tebulo mu mbiri DB. Momwemonso, izi zitha kupezekanso mu mtundu wa Framework Manager, koma, magwiridwe antchito ndi lingaliro lofunikira.
Ena mwa makasitomala athu apanga mawonekedwe ophatikizidwa. Tikuganiza kuti izi mwina ndizopambanitsa. Magwiridwe antchito nthawi zonse amakhala oyipa pamawonedwe olumikizidwawa ndipo sitinapezepo milandu yambiri yomwe imagwiritsa ntchito ma seti a Live komanso Historical. Live ikugwiritsidwa ntchito pothetsera mavuto ndi Historical pakufotokozera zochitika.
Pofika pa Cognos Analytics 11.1.7, Audit Database yakula mpaka matebulo 21. Mutha kupeza zambiri pena paliponse pa Audit Database, zitsanzo zamaphunziro owerengera komanso mtundu wa Framework Manager. Mulingo wodula mitengo ndi Wocheperako, koma mungafune kugwiritsa ntchito gawo lotsatiralo, Basic, kugwiritsira ntchito zopempha, kasamalidwe ka akaunti ya ogwiritsa ntchito ndi nthawi yogwiritsira ntchito. Njira imodzi yomwe mungasungire magwiridwe antchito ake ndikusunga mitengo yodula kwambiri. Zachidziwikire, kudula mitengo komwe kumachitika ndi seva, momwe ntchito ya seva imakhudzidwira.
Ma tebulo ofunikira omwe oyang'anira ambiri adzachita nawo chidwi ndi matebulo 6 omwe amalowetsa zochitika za ogwiritsa ntchito ndikuwonetsa zochitika m'dongosolo.
- COGIPF_USERLOGON: Amagwiritsa ntchito zogwiritsa ntchito (kuphatikizapo kutseka) zambiri
- COGIPF_RUNREPORT: Amasunga zambiri zamomwe amaphedwa
- COGIPF_VIEWREPORT: Amasunga zambiri zamapulogalamu owonera malipoti
- COGIPF_EDITQUERY: Amasunga zambiri zamayankho amafunsidwa
- COGIPF_RUNJOB: Amasunga zambiri zokhudza zopempha za ntchito
- COGIPF_ACTION: Amalemba zochita za ogwiritsa ntchito mu Cognos (tebulo ili likhoza kukula mwachangu kwambiri kuposa enawo)
Kusintha kwa kunja kwa bokosi kumawoneka motere:
Analimbikitsa kasinthidwe:
Database ya Cognos Audit - Live ili ndi sabata limodzi la zambiri zowerengera. Zambiri zopitilira sabata limodzi zimasamutsidwa ku Cognos Audit Database - Historical.
Mzere wochokera ku Database ya Cognos Audit - Live to Cognos Audit Database - Mbiri pazithunzizi ndiyofunika kuti:
- Kutengera zambiri kuchokera ku Live Audit mpaka Historical Audit
- Chotsani mizere yonse mu Live Audit yomwe ndi yakale kuposa sabata limodzi
- Chotsani mizere yonse mu Historical Audit yomwe ndi yakale kuposa zaka x
- Chotsani mizere yonse mu COGIPF_ACTION yomwe ndi yakale kuposa miyezi 6
Index
Mitundu yosiyanasiyana yazosunga mitundu ili ndi mitundu yosiyanasiyana yolozera. Mndandanda wama database ndi kapangidwe ka data, komwe kumalumikizidwa ndi Table (kapena View), yogwiritsidwa ntchito pokweza nthawi yakufunsira mafunso mukamapeza zidziwitso kuchokera patebulopo (kapena View). Gwiritsani ntchito DBA yanu kuti mupange njira yabwino kwambiri. Afuna kudziwa mayankho a mafunso ngati awa kuti apange zisankho zabwino pazolumikiza ndendende. Zachidziwikire, woyang'anira nkhokweyo amatha kupeza mayankho a ena kapena mafunso onsewa popanda thandizo lanu, koma zingatenge kafukufuku wina ndi nthawi:
- Kodi matebulo ali ndi zolemba zingati ndipo mukuyembekezera kukula kwake? (Kulongosola tebulo sikungakhale kothandiza pokhapokha tebulo litakhala ndi zambiri.)
- Kodi mukudziwa magawo omwe ali apadera? Kodi amalola miyezo ya NULL? Kodi ndi mizati iti yomwe ili ndi nambala yamtundu waukulu kapena yayikulu? (Ma column omwe ali ndi mitundu ya manambala omwe ali UNIQUE ndipo NOT NULL ndioyenera kuchita nawo chinsinsi.)
- Kodi mavuto anu akulu akulu ali kuti lero? Kodi akutenga zidziwitsozo? Kodi pali mafunso kapena malipoti enieni omwe ali ovuta kwambiri? (Izi zitha kutsogolera woyang'anira nkhokwe kuzinthu zina zomwe zitha kukonzedwa.)
- Ndi minda iti yomwe imagwiritsidwa ntchito kuphatikizira matebulo owerengera?
- Ndi magawo ati omwe amagwiritsidwa ntchito kusefa, kusanja, kuphatikiza, ndikuphatikiza?
Ndizosadabwitsa kuti awa ndi mafunso omwewo omwe angafunike kuyankhidwa kuti akwaniritse magwiridwe antchito amtundu uliwonse.
Thandizo la IBM amalimbikitsa kupanga cholozera pamakalata "COGIPF_REQUESTID", "COGIPF_SUBREQUESTID", ndi "COGIPF_STEPID" pama tebulo otsatirawa kuti akwaniritse magwiridwe antchito:
- COGIPF_NATIVEQUERY
- COGIPF_RUNJOB
- COGIPF_RUNJOBSTEP
- COGIPF_RUNREPORT
- COGIPF_EDITQUERY
Kuphatikiza pa matebulo ena omwe sanagwiritsidwe ntchito:
- COGIPF_POWERPLAY
- COGIPF_HUMANTASKSERVICE
- COGIPF_HUMANTASKSERVICE_DETAIL
Mutha kugwiritsa ntchito poyambira, koma nditha kuyankha mafunso omwe ali pamwambapa kuti ndipeze yankho labwino kwambiri ku bungwe lanu.
tiganizira Other
- Kafukufuku wa FM Model. Kumbukirani kuti mtundu wa Framework Manager womwe IBM imapereka umakhala pama tebulo ndi minda. Zosintha zilizonse zomwe mungapange pama tebulo ofotokozera ziyenera kuwonetsedwa muchitsanzo. Kupepuka kapena kusinthaku kwakusintha - kapena kuthekera kwanu kwakapangidwe kanu kuti zisinthe - kungakhudze yankho lomwe mungasankhe.
- Zowonjezera. Ngati muchita, ino ndiye nthawi yoti muwonjezere magawo ena azomwe mungachite kapena zolozera kuti mukwaniritse malipoti owerengera.
- Magulu achidule. M'malo mongokopera zomwe zalembedwazi patebulo lanu lakale, liponderezeni. Mutha kuphatikiza zidziwitsozo mpaka masana kuti zikhale zosavuta kuzifotokozera.
- Kuwona m'malo mwa matebulo. Ena amati, "Chifukwa chake, m'malo mokhala ndi nkhokwe za 'zamakono' ndi nkhokwe ya 'mbiri', muyenera kukhala ndi database imodzi yokha, ndipo matebulo onse omwe ali momwemo akuyenera kukhala ndi 'mbiri'. Kenako, pangani malingaliro angapo, imodzi patebulo lililonse yomwe mukufuna kuwona ngati 'yapano', ndikuwonetserakuwonetserako mizere yakale yomwe simukufuna kuwona ndikulola okhawo apano adutse. ”
https://softwareengineering.stackexchange.com/questions/276395/two-database-architecture-operational-and-historical/276419#276419
Kutsiliza
Chofunikira ndikuti ndi zomwe zaperekedwa pano muyenera kukhala okonzeka bwino kukambirana bwino ndi DBA yanu. Mwayi ndi wabwino kuti adathetsa mavuto ofananawo m'mbuyomu.
Zosintha mu kapangidwe ka Cognos Audit Database zidzakulitsa magwiridwe antchito pakufotokozera molunjika komanso ntchito za chipani chachitatu zomwe zimadalira, monga Motio'm ReportCard ndi Inventory.
Mwa njira, ngati mwakhala mukucheza ndi DBA yanu, tikadakonda kumva za izi. Tikukondanso kumva ngati mwathetsa vuto la Database Yoyeserera bwino komanso momwe mudakwanitsira.
